The database management system is a system software to create and manage databases. Examples of DBMS are MySQL, Oracle, MS SQL, etc.
Features of Database Management System
- Data Definition – The data definition feature is used for the creation, modification, and removal of definitions that defines the organization of the data in the database.
- Data Manipulation – The data manipulation feature helps you to insert, update, and delete the actual data from the database.
- Data Retrieval – The data retrieval feature helps you to retrieve the data from the database. Which can help you to use it in many applications for different purposes.
- User Administration – The user administration feature helps you to register and monitor users, enforce data security, monitor performance, maintain data integrity, deal with concurrency control, and recover information corrupted by unexpected failures.
Characteristics of DBMS
- DBMS uses a digital repository that is established on the server to store, retrieve and manage the information.
- DBMS provides a clear and logical view of the process that modifies the data.
- DBMS contains an ACID property to maintain the data in a healthy state in case of failure.
- It reduces the complexity of relations between data.
- It provides security to the data.
- It shows the database from different viewpoints according to the requirements of the user.
- It supports the manipulation and processing of the data.
- It contains automatic database backup and recovery features.
Advantages of DBMS
- It controls database redundancy because all the data are stored in the same database.
- DBMS-authorized users can easily share the data of the database among multiple users.
- It can be easily maintained because of the centralized nature of the database system.
- It reduces the development and maintenance time.
- It provides a backup and recovery feature where you can back up and recover after data corruption
- It provides different kinds of user interfaces like graphical user interfaces and command line interfaces.
Disadvantages of DBMS
- Cost of hardware and software: DBMS requires a high-speed processor and a large memory size to run it.
- Size – It requires a large space for disks and large memory to run it efficiently.
- Complexity – It creates additional complexity and requirements.
- Higher impact of failure – failure of the database management system can impact most of the organization. All data is stored in a single database and if the database is damaged due to any kind of failure like electric failure or database corruption then data may be lost forever.
Read Next – Database System vs File System