Benefits and Limitations of Database Management:

The database management approach provides managerial end users with several important benefits such as:
1. Reduce the duplication of data
2. Integrate data so that they can be accessed by multiple programs and users.
3. Programs are not dependent on the format of the data and the type of secondary storage hardware being used.
4. Users are provided with an inquiry/response and reporting capability that allows them to easily obtain the information they need without having to write computer programs.
5. Computer programming is simplified because programs are not dependent on either the logical format of the data or their physical storage location.
6. Integrity and security of the data stored in databases can be increased since access to data and modification of the database are controlled by database management system software, a data dictionary, and a database administrator function.

The limitations of database management arise from:

1. It's increased technological complexity.
2. Development a large database and installing a DBMS can be difficult and expensive.
3. More hardware capability is required, since storage requirements for the organization's data, overhead control data, and the DBMS programs are greater.
4. Longer processing times may result from high-volume transaction processing applications since an extra layer of software (the DBMS) exists between application programs and the operating system.
5. If an organization relies on centralized databases, their vulnerability to errors, fraud, & failures is increased.
6. If an organization relies on distributed databases problems of the inconsistency of data can arise. 
Mukesh Rajput

Mukesh Rajput

I am a Computer Engineer, a small amount of the programming tips as it’s my hobby, I love to travel and meet people so little about travel, a fashion lover and love to eat food, I am investing a good time to keep the body fit so little about fitness also..

Post A Comment:


Mukesh Rajput