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
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.