Database management system is the most important computer program but there are also some disadvanages. Some most common and important advantages and disadvantages of database management system are described below:
Advantages and disadvantages of database management system
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 allows them to easily obtain 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 database management system
The limitations of database management arise from its 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 are increased.
Yet problems of 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 organizations data resource management effort.
You may like also:
- 6 major conceptual types of database
- Advantages and disadvantages of internet
- Important way of data resource management
- 4 Major uses of Database Management Systems
- Various way of Database Access