Advantages of Database Approach


[Previous] [Table of Contents] [Next]

Advantages of Database Approach

—Reduces redundancies

In database approach data can be stored at a single place or with controlled redundancy under DBMS, which saves space and does not permit inconsistency.

—Provides environment for data independence

In the file-based system, a change in the structure of data may require alterations to programs. Database Management systems separates data descriptions from data. Hence it is not affected by changes. This is called Data Independence, where details of data are not exposed.

—Enforces integrity

Data Integrity means that the data should be accurate and consistent. This is done by providing some checks or constraints. These are consistency rules that the database is not permitted to violate.

—Security

Only authorised users may use the database and their access types can be restricted to only retrieval, insert, update or delete or any of these. For example, the Branch Manager of any company may have access to all data whereas the Sales Assistant may not have access to salary details.

—Answers unforeseen queries

DBMS utilises techniques to store and retrieve the data efficiently at least for unforeseen queries.

—Provides support for transactions, recovery etc.

DBMS provides facilities for recovering the hardware and software failures. In case a program fails, it restores the database to a state in which it was before the execution of the program.

A DBMS also allows multiple transactions to occur simultaneously.