Thursday 20 October 2011

Why Database Use


Any organization, be it a bank, Manufacturing company, Hospital, university, Conglomerate of a Governments departments , requires huge amount of data in some form or other. All such organization need reo collect data manipulate them and store them for future use. All such types of organization require data for a number of purposes, say;
A)  Preparing sales reports
B)  Forecasting sales
C)  Preparing accounts reports
D)  Getting medical histories of patients

Thus, we can say that data are very vital corporate resources. The amount of data used these data in organizations can be measured in the range of some billions of bytes or characters. The financial investment involved is also very high, Many organizations have become cortically dependent on the continued and successful operations of databases.

What is Database Management System ?


A database management system is an organized collection of facts. In other words we can say that it is a collection of information arranged and presented to serve an assigned purpose.
An example of a database is dictionary, where words are arranged alphabetically. Another example is a telephone directory, where subscriber’s names are listed in alphabetically order. Similarly, when you think of a box of cards with name and addresses written as a mailing list, then the box and its contents form a mailing database. Figure contains cards with mailing addresses. All these cards are placed in alphabetically order of names and the collection of these cards would be called a database.
Note: - Thus information stored in a database is arranged in a particular order.
In order to keep database updated, we may need to perform operation like adding information, removing information, editing existing information, etc. Take the case of a telephone diary, in which you note down the names, address and phone numbers of your friends. This is also a type of database. If you make new friends, you note the information about him /her in the diary which is equivalent to adding data to a database. If address of your friends changes then you note the new address in your diary which means editing a database. If you want to send a letter to your friend then you look into the diary to locate the address. This is called searching a database.
In case your telephone diary captains very large numbers of names, address, phone numbers, moreover, the name are not arranged in any orders. Thus , it would be very difficult to locate the names , address, and phone numbers of your friends .thus It is essential to arrange the names in some order, say alphabetically ,to make search easy, However as the number of friends gets larger, managing the database manually become difficult . A database management software package is a helpful tool in such a situation.