The database management system is the most important computer program but there are also some disadvantages. Some most common and important advantages and disadvantages of a database management system are described below:
Advantages and disadvantages of database management system (DBMS)
The database management approach provides end-users with several important benefits. Database management reduces the duplication of data; it integrates data so that they can be accessed by multiple programs and users.
Programs are not dependent on the format of the data and the type of secondary storage being used. Users are provided with inquiry/response and reporting capabilities that allow them to easily obtain the information they need without having to write programs.
Programming is simplified because programs are not dependent on either the logical format of the data or their storage location. Finally, the integrity and security of the data stored in databases can be increased, since access to data and modification of the database are controlled by DBMS software, data dictionary, and database administration function.
Disadvantages of the database management system (DBMS)
The limitations of database management arise from increased technological complexity. Thus, a database management approach can pose problems in data resource management.
Developing large databases of complex data types and installing a DBMS can be difficult and expensive. More hardware capability is required, since storage requirements for the organization’s data, overhead control data, and the DBMS programs are greater.
Longer processing times may result from high- volume transaction processing applications. Finally, if an organization relies on centralized databases, its vulnerability to errors, fraud, and failures is increased.
Yet problems of the inconsistency of data can arise if a distributed database approach is used. Therefore, the security and integrity of an organization’s databases are major concerns of the organization’s data resource management effort.
You may like also: