Integrity

What is Database Integrity?

In database, database integrity is accuracy and compatibility of data.

The database integrity is on the faith of many integrity constraints, so that is, designing complete database integrity is designing a complete database integrity constraint. Database integrity constraint can be achieved through the DBMS or application, and it is based on integrity constraint of DBMS as a part of mode to be stored in database. With achieving the integrity constraint of DBMS, we could design it according to the steps of designing database. And by the application software to achieve the integrity of the database are included in the application of software design.

Database integrity is a key for Database Application System, and its function is mainly reflected in the following areas:

1. Database integrity constraints can prevent legitimate users from adding non-semantic data using when using the database;

2. Using base on integrity control mechanism of DBMS to achieve the transaction rules, easy to define, easy to understand, and it can reduce the complexity of applications and improve the efficiency of operating efficiency. At the same time, base on integrity control mechanism of DBMS is centralized management, and therefore it can be achieved integrity of the database more easily than the application;

3. Reasonable designing in integrity of the database, designs are applied with consideration both the integrity of the database and system performance. For example, when loading a large amount of data, just need temporarily unavailable the constraint that is base on integrity control mechanism of DBMS before the loading of the database, after it, re-entry into force. We can guarantee the data will not affect the efficiency of loading but also ensures the integrity of the database;

4. In the software application testing, the good integrity of the database contributes to finding out the errors of application software earlier.