What is DBMS (Database Management System)?
Database management system (DBMS) is software that is used to manage the database.
DBMS provides an interface to perform various operations like database creation, storing data in it, updating data, creating a table in the database and a lot more.
Database Management System allows users to do the following:
- Define Data – Allows the users to create, modify and delete the definitions which define the organization of the database
- Update Data – Provides access to the users to insert, modify and delete data from the database.
- Retrieve Data – Allows the user to retrieve data from the database based on the requirement.
- Administration of users – Register the users and monitor their action, enforce data security, and maintain data integrity.
Characteristics of DBMS:
- To limit the permission of the users.
- Provide multiple views of the single database schema.
- Facilitates security and sharing of data.
- Offers both physical and logical data independence.
Types of DBMS:
- Object Oriented
Some of the popular DBMS software are MySQL, PostgreSQL, Oracle, SQLite, MariaDB, MS SQL Server, etc. All these software are based on different types of DBMS available in the market.