Advantages of Database Management System

Advantages of Database Management System

The database management system has several advantages over the traditional file system. A brief description of these is given below

• Program-Data Independence

Program-Data Independence The separation of data from the application program is called data Independence) In a database management system, data is kept separate from application programs. This property allows a database to change and grow without changing the application programs that process the data.

• Minimum Data Redundancy

Minimum Data Redundancy Storing of the same data at more than one place in a system is called data redundancy In a database system, data is integrated into a single, logical structure. Each fact is stored (as far as possible) in only one place. This minimizing of data redundancy increases data processing speed. It also ensures the correctness of data

• Improved Data Sharing 

Improved Data Sharing Database is designed as a shared resource. Authorized users are allowed permissions to use the database. Thus, many users can access and work on the same data at the same time.

• Improved Data Consistency 

Improved Data Consistency By reducing data redundancy, the data inconsistency is reduced. In
a database management system, each data item is stored, as far as possible, at one place only) For example, if a customer's address is stored at two or more places, there will be doubt about which address is current. On the other hand, it is stored only once, there can be no doubt. Also, updating of data value is easy when each value is stored in one place only.

• Security of Data

Security of Data In a database management system, all data is stored in one place.
This provides complete control over how the data can be used This feature is used to apply security checks. For example, every user may be allowed to retrieve data freely but only selected users can be allowed to update or modify it

• Advanced Capabilities

Database management systems use the latest technology. They provide facilities for online access and reporting of data through the Internet