What is (DBMS)?

Database Management System (DBMS) is a collection of programs which enable its users to access database, manipulate data, reporting/ representation of data.

It also helps to control access to the database.

Database management Systems are not a new concept. And such as had been first implemented in 1960, But Charles Bachman’s integrated Data store (IDS) is said to be the first DBMS in history.

There are 4 major type of DBMS:

11. Hierarchical – this type of DBMS employs the ‘parent-child’

Relationship of storing data. This type of DBMS is rarely used nowadays.

22. Network DBMS – this type of DBMS supports many relations.

This usually results in complex database structures.

33. RDM Server is an example of a database management system that implement the network model.

44.  Relational DBMS – this type of DBMS defines database relationships in form of tables, also known as relation.

Unlike network DBMS, RDBMS dose not support many to many relationships. Relational DBMS usually have per-defined data types that they can support.

This is the most popular DBMS type in the market. Example of relational database management systems include MySQL, Oracle and Microsoft SQL Server database.