journey to the endless end....... the peace in DRC

It was first week of July 06. I started my journey in DRC. The very environment started appearing as journey through an obscured way. I was told "hero's are in the grave". How ever my first station was a Pweto of Kalemie with Katanga province..... the home of Kabila.

On my way to pweto I reached Kalemie. It was more unknown to me. After four days my journey  for Pweto would start. I really liked this Kalemie town. It was just beside the Longest lake of the world.... Lake Tanganika. I was informed that it was more then 600 kms in length and I was not interested to know the width.

First time I saw some white crow. Congo is a country where you have road to ply but you do have airport to fly. So after four days I started for Pweto with a flying box make in USSR. The box kept on flying over Tanganica. It was great... After almost 02 hours we reached to Moba. Its a hilly area on the last part of the lake tanganika. Then on wards again we flew for my destination Pweto. It is another beautiful hill station near lake Mwaroo. That was my first working place.

My boss received me with other members and the crew went back with the flying box. I was shown my room.There was a wooden bed and there was nothing. I want for wash. I found there was door with no lock with a board mentioning whether any one is inside or not. ..........to be continued....

MS Access...... the starter

If you puzzled to by thinking how to kick off the learning of Database(DB). I must tell you it should be MS Access. It is very well in reach to every one. To understand DB and implement those in chronological way it is the best platform. The very important part is that both front end and back end are residing together. Some of the important features of Access are as follows:

Features of MS Access:

1.    Light and accurate.
2.    Easy to create and destroy(remove).
3.    Available with office pkg which is very common to all.
4.    Easy to understand and make DB structure.
5.    Access report is one of the best data representation scope yet the easiest one.
6.    Wizard is there to guide and lead.
7.    A detailed help option to walk beside you.
8.    Inter-active forms and query to help the end users.
9.    VB Script and Macro to bring the flavor of professional designer.
10.    Well defined back end coding scope to improve database design.
11.    Back end coding facilities can take you to the era of simulation.(...provided you take interest)

Limitations:

1.    Back end storage is small.
2.    Data base security some times compromised.   
3.    Some might delete of remove accdb or mdb file accidentally or by mistake.
4.    Data grid is not available.
5.    Since Data grid is not integrated dynamic search engine design is difficult. 
6.    Mainly PC based Database scheme handler.

Looking ahead  with solution

1.   Problem with storage: Off course storage is a problem. But a database in terms of growth and utilization can be of two types. In one type the database size does not increases or remain fixed and only data manipulation takes place. This type is called manipulative and another type where the database gets increased every day with data manipulation. This type may be called as Growing DB. Now consider a database of Military unit. It remains fixed on the other hand a banking software is growing with every entries. A database with a size fixed up to 200-300 MB Access is well and good. However if there is a requirements of more space to manage a growing DB, you can always combine the access front end with mysql, MS SQL Server or even with oracle. You can down load my odbc connector 3.5 to connect Access front end to mysql. Since MS Access and SQL Server are both MS product they can be paired more easily. 

2.    Security: You must not demand an integrated security like Oracle. However following steps would help you:  

a.   Hide the Side bar control panel to restrict unauthorized venture to your DB.

b.  You can always make ACCDE or MDE file to make an Access DB locked from others venture.

c.   Encrypt with password. 

3.    Data Grid and Dynamic Search:  Dynamic Search can very easily be planned if you know how to   play with VB Script. Docmd is a big solution to many problem in MS Access.

.................................To be continued

Step into database

It's now IT every-where. Before I go in to details let me tell some thing I think about IT or computer engineering. Once some completed CSE or any related degree he has got several options to go ahead. Actually he has three ways from which one to be chosen---- Hardware, Software and Networking. To me those who are brilliant might go for hardware engineering and the others may opt for software or networking. Even networking demands very much painstaking effort in comparison to software. So software is the easiest game. With in software there are divisions. One simulation and the other one is database. The former if coupled with hardware then is the toughest of all I have discussed except hardware engineering. But database is the easiest of all.
With in database there are several doors to step ahead. In fact you would get many books with challenge to learn database in seven days.How...... To me if you are beginner then first you should learn it by your self.

You need a solid foundation which I thing MS access can give. Start a simple .mdb or .accdb file. Just make a student.accdb file in office 2007 save it and close. Thats all. Now we need to know why we are making database. Its for the users and users will use it through their terminals,..mean computers. So you need to be thought full for both this objects. Yes I am talking about requirement analysis. It is very important if you think that you would make your way with database.A database has two parts. One is front End and the other  back end. Front end is the one where the users inter acts and the back end where the data get stored. 

Lets know Front End and Back End:
Some of the front end like MS Access, VB-6 or vb2010, PHP, ASP,Java, form builder oracle and so many. To me for beginner MS Access is the best. For back end I can name Oracle,mysql, xl also back end of access. off course Oracle is the best with all it's features. Again remember this is a back end for advance users. I don't say it is difficult, saying only that don't start with this. 


SQL:
The core of Data base is SQL  or standard Query Language. It is a standard set by the database back end communicators society. So if you learn it in MS access and get habituated with it, get familiar with it you can use it every where like oracle, mysql or SQL Server.


a.   Components of Front End and Back End: The main component of Front are Reports, Forms, Query etc and the back end comprises of mainly tables,procedures,functions.


b.   How SQL is used to communicate between front end and back end:  When a user needs some data he sends the request in terms of SQL. The processor send that SQL to the back end who acts like a librarian. So the librarian reads the requirements and match the requirement with the data it contains. Those data matches it selects those and forward it to processor. Processor in terms places those to data grid of the front end and user can see those. 


c.  When a user sends a data request towards back end manager, there are three question needs to be cleared to back end. 
      1.  First Question: What you like to know. (select Name,Address,Payment,.....)
      2.  Second Question: From where I Would get those. (From Table Employee)  
      3.  Basing on What Criteria. (Where Address='Permanent')


Now if we add the answer of all this question we will make a SQL and that is
    Select Name,Address,Payment 
    from Employee
    Where Address='Permanent';


Now the back end manager will open the data library and give out the data........




That is all for today.... I will try to share so that my friends can start with MS Access. I would try to take you up to php-mysql and web server Apachi......in coming days......