Advantages of Database Management System

Database Management System is software used in the place early method of file processing system. Database management system provides many advantages to an organisation.

Advantages of Database Management System are:

Data Redundancy: In a traditional file system, various files and applications may be duplicated in several places (files). It leads to data redundancy. Suppose a bank stores its information in traditional file system. Bank stores its customer detail, saving account details, current account details in various files. There are many chances that address and phone no of a customer is stored in customer details file, saving account details file. It is seen that same information is stored in many files. Such a situation is called data redundancy.

Database management system controls data redundancy and if data redundancy is controlled you can save your storage area.

Data Consistency: If you can control data redundancy, then you can also control data inconsistency. In my previous example of bank, address and phone no of a customer is stored in customer details file, saving account details file. Suppose, address of a customer is changed in customer detail table, but this change is not appear in saving account detail table. Such a situation is called data inconsistency.

Database management system automatically updates each occurrence of data in database. Then data consistency is controlled by database management system.

Data Sharing: A DBA (Database Administrator) provides specific control to a specific user. Database management system manages authentication of each user. Authorized user can access data and be able to share data.

Data Integrity: Data Integrity means that data in database is always accurate, such that incorrect information cannot be stored in database. Integrity of data can be maintained by key constraints. Suppose a primary key is set to an attribute, then primary key uniquely identifies each rows in a table.

Security of data: The main purpose of a database system is to provide data security. A database management system provides security by authorization. A DBA (Database Administrator) grant some specific permission to specific user. For example, username and password for users.

Data backup and recovery:  In a file processing system, data backup is also possible. In my previous bank example, if user A is transferring some money to user B and at the same time system crashes. At this situation, there is possibility that amount is deleted from user A account but amount is not transferred to user B account.

To overcome this problem of file processing system, a database management system uses recovery subsystems. And the recovery subsystem is responsible for making sure that the database is restored to the state it was in before the program started executing.