A database management system (DBMS) is system software that is made for creating and managing databases. With the help of the DBMS, a user or a developer can create, get, update, and manage data in a systemic way. This system is kind of an interface between a user and a database. It also ensures that data is consistently organized and easily accessible.

Here is a diagram regarding the use of a DBMS:

There are three important features of a DBMS, and these are the data, the database engine, and the database schema. The data is a collection of information, the database engine allows data to be locked, accessed, and modified, and the database schema defines the logical structure of the database.

The DBMS provides a general view of how data can be accessed by multiple users from multiple locations in a controlled manner. It also limits a user's access to user data. The database schema provides the logic of how a user can view the data. The DBMS handles all the requests and executes them on the database.

Both logical and physical data independence is offered by the DBMS. This means that an application can use APIs to utilize the data from the database. In addition, clients and applications don't need to worry about the locations of the stored data and changes to the physical structure of the data, such as storage and hardware.

Popular database models and their management systems include the following:

• Relational database management system (RDMS)
• NoSQL DBMS
• In-memory database management system (IMDBMS)
• Columnar database management system (CDBMS)
• Cloud-based data management system