Advantages of DBMS

An advantages of DBMS is listed below, basically it contains all the problems of file system.

In DBMS system database is centralized, and it also have it's own data manipulation program.

DBMS = Database + Set of manipulation program

1) Minimal Data Redundancy

• Avoid unnecessary data duplication because of centralized system.
• Reduce data redundancy, and prevents memory wastage.
• Because of centralized data, it reduce query processing time.

2) Data Consistency

• Due to data redundancy, data Inconsistency may arise.
• Due to minimal data redundancy in DBMS, inconsistent data can be eliminated.
• It ensures the data consistency in database.

3) Data Access

• There are many ways to retrieve data.
• You can retrieve data by writing a single SQL query.
• So, data can be accessed in convenient and efficient manner.

4) Shared Data

• It is easy to shared data among all authorized user and applications.
• Due to centralized data storage, sharing is easy.

5) Data Integrity

• For integration between of two databases, both must be consistent and correct.
• To achieve correctness and consistency in database, must satisfy some constraints.
• DBMS provides an easy way to implement such constraints. It improves data integrity of database.

6) Guaranteed Atomicity

• DBMS provides a supervisor programs that ensures, an operation/transaction must be complete either all (100%) or none (0%).

7) Concurrent Access

• DBMS provides a simultaneous access to a database by multiple users under some supervision.
• Due to simultaneous access, it gives better performance and faster response.

8) Data Security

• DBMS has a facility to provide different database access privileges to user as per requirement of application program.
• It prevents database from unauthorized access. 

<-- Previous     Next-->