Data integrity deals with the reliability of the data stored in the database, that is, the requirement that the database must describe the real world as accurately as possible. All access to the data in your database goes through the DBMS (Database Management System).

Database Management System

The DBMS controls the interaction of the user with the database to ensure that a number of data integrity constraints are observed. By observing these constraints, the DBMS protects your data from damage or corruption. The DBMS is a very complex unit in your database system, but the methods that it uses to maintain data integrity are based on a few fundamental concepts:

  • Write transactions and recovery.

  • Read consistency and concurrency.

  • Table locking.

  • Deadlock detection.

  • Committing updates.

See Also