ADVANTAGES OF DATABASE

ADVANTAGES OF DATABASE

 

1. Redundancy can be reduced
2. Inconsistency can be avoided
3. Data can be shared
4. Standards can be enforced
5. Security restrictions can be applied
6. Integrity can be maintained
7. Conflicting requirements can be balanced

 

Redundancy can be reduced

 

In non-database systems, each application or department has its own private files resulting in considerable amount of redundancy of the stored data. Thus, storage space is wasted. By having a centralized database most of this can be avoided. We do not say or suggest that all redundancy should be eliminated. Sometimes there are sound business and technical reasons for maintaining multiple copies of the same data. In a database system, however, this redundancy can be controlled.

 

Inconsistency can be avoided

 

This is really a outcome to the above point. When the same data is duplicated and changes are made at one site, which is not propagated to the other site, it gives rise to inconsistency. Then the two entries regarding the same data will not agree. At such times the data is said to be inconsistent. So if the redundancy is removed changes of having inconsistent data is also removed.

 

 

Data can be shared

 

The existing applications can share the data in a database.

 

Standards can be enforced

 

With the central control of the database, the database administrator can enforce standards.

 

NEXT

 

 

Database Management System by Mrs.M.Govindammal