Advantages of DBMS

 Data Independence

The DBMS provides an abstract view of the data that hides details such as, how data is stored, how it is represented. Abstraction of such kind provides a advantage of Data Independence.

 

Easy Access to Data

DBMS provide many useful utility commands or techniques that are used to retrieve data as per user need in a efficient way. 

 

Data Integrity

Data Integrity can be defined as overall accuracy, completeness, and consistency of data. DBMS provide a high level of Data Integrity by enforcing integrity constraints on data. (We will discuss later Integrity Constraints).

Centralized Management

In FPS, data scattered in various files, and files may be in different formats, writing new application programs to retrieve the appropriate data from different files is difficult.

DBMS provides an easy way to join different relations (tables), so that we can extract required data from different relations in an easy manner.

 

Atomicity

In many applications, it is crucial that, if a failure occurs, the data be restored to the consistent state that existed prior to the failure. It is difficult to ensure atomicity in a conventional file-processing system.

DBMS provides transaction control utilities such as savepoint, rollback and commit to achieve the atomicity.

 

Security

Not all users have access permission to all type of data, but enforcing such restrictions in FPS is difficult. DBMS provides grant and revoke commands to restrict the access of a user over the data objects as well as control the behavior of them means how the user is accessing data.