BugRaptors Blog

database integrity testing

Data Integrity Definition- How To Enforce It In Databases

August 30 2018, 12:16pm

Posted by Claire Mackerras

Enforcing Data Integrity Into Databases

Database Integrity is a central underlying aspect or term in the implementation of database technology. Having faith in the data correctness is a prerequisite for using the data in business, research or decision-making applications. So it’s for sure that the factors of ensuring database security and reliability cannot be ignored. One also has to consider the use of error checking and correction codes to deal with the integrity issues and improve the performance of database systems.

Enforcing Data Integrity in Databases

Basically, there are four primary types of data integrity: entity, domain, referential and user-defined.

1. Entity Integrity ensures a table does not have any duplicate rows and is uniquely identified.

2. Domain Integrity requires that a set of data values fall within a specific range (domain) in order to be valid.

3. Referential Integrity is concerned with keeping the relationships between tables synchronized.

Check out the advantages of enforcing integrity constraints, here: https://www.bugraptors.com/what-is-data-integrity/

See comments