Database Management System

In my last post,I wrote about database management system.So you may ask that what a database management system actually means??
A database management system(DBMS) is a collection of programs that enables users to create and maintain a database.The DBMS is a general purpose software system that facilitates the process of defining,constructing,manipulating and sharing databases among various users and applications.

• Defining a database involves specifying the data types,structures and constraints of the data to be stored in the database.The database definition or descriptive information is also stored in the database in the form of a database catalog or dictionary,called metadata*.
• Constructing the database is the process of storing the data on some storage medium that is controlled by the DBMS.
• Manipulating a database includes functions such as querying the database to retrieve specific database to retrieve specific data,updating the database to reflect changes in the mini world and generating reports from the data.
• Sharing a database allows multiple users and programs to access the database simultaneously.

An application program accesses the database by sending queries or requests for data to the DBMS.A query is typically a statement requesting the retrieval of information.

 A simplified database system environment.

*metadata: Generally known as data about data. So, it means that it stores various information like type of data, size of data, etc.