DBMS (Database Management System)

DBMS (Database Management System)

Database management system is a collection of interrelated data and set of programs to retrieve those data. DBMS provides a interface to user and programmer to modify and manage data. The purpose of DBMS is to store and retrieve database information in convenient and effective manner. An organisation use DBMS to manage large amount of information, as information is very important in an organization. A DBMS ensures safety of the information stored, from an unauthorized access. Many popular dbms are MySql, Oracle, Sybase, Microsoft Access and IBM DB2 etc.

If user or programmer wants to access information from database, then user can’t directly access information from database. User makes queries to DBMS and then DBMS retrieve information from database and provides information to user. Thus DBMS (Database Management System) is a middle layer between user and database.

There are many different types of DBMS (database management systems), some of them can run on small systems and some they can run large system.

Types of database management system

1. Hierarchical DBMS
2.  Network DBMS
3.  Relational DBMS
4.  Flat file DBMS
5.  Object oriented DBMS

Advantages of DBMS

1.  Data is independent in DBMS
2.  Provides data redundancy
3.  Provides flexibility
4.  Data can be shared among users
5.  Provides data persistency
6. Provides data consistency
7.  Ability to recover crashes and errors

Disadvantages of DBMS

1. Costly than traditional file system.
2. It is more complex.
3. Larger in size.