Nov 23, 2010

DBMS

What is DBMS ?

DBMS :- Is a collation of related records and a set of  programs that access and manipulate these records. DBMS enables user to enter,store  and manage this data.
In DBMS the data was stored in the flat file format .So,the information about different objects was maintained separately in different physical files.The relation between these objects to be maintained in a separate physical file.Thus a single package would consist of too many files and wholesome programming to integrate them into a single system.
Solution to these problems are centralized database system.In this system the database is stored in the central location.Every user can access to the common database which is stored in central location from there machine.


 C. J. Date :- An authority on database technology defines a database system.as computer based record keeping system whose overall purpose is to record and maintain information.
We use a filing cabinet and paper files to file our papers.They provide centralized control of data.when we have new paper to be filed, we add those sheet s to a file.Old unwanted papers can be removed.
Changes can be made to existing files.when a particular document or paper is required it can be accessed.
A database management system is similar to this filing cabinet.it is as an electronic filing cabinet,which besides storing also allows addition,deletion,modification and retrieval of data.

1 comment: