Integrity = validity + completeness

Amihai Motro

ACM Transactions on Database Systems · 1989 · 177 citations · 3 references

DOIFull text

Open access

Concepts

TL;DR

Database integrity comprises validity, excluding false data, and completeness, ensuring all true data is present, and this model largely subsumes the traditional integrity constraints. The article proposes a uniform relational database integrity model that incorporates both validity and completeness. The model defines and implements a mechanism that determines the integrity of query answers, treating integrity assessment as a process analogous to answer computation. Users find answers with detailed integrity certifications more meaningful.

Abstract

Database integrity has two complementary components: validity , which guarantees that all false information is excluded from the database, and completeness , which guarantees that all true information is included in the database. This article describes a uniform model of integrity for relational databases, that considers both validity and completeness. To a large degree, this model subsumes the prevailing model of integrity (i.e., integrity constraints). One of the features of the new model is the determination of the integrity of answers issued by the database system in response to user queries. To users, answers that are accompanied with such detailed certifications of their integrity are more meaningful. First, the model is defined and discussed. Then, a specific mechanism is described that implements this model. With this mechanism, the determination of the integrity of an answer is a process analogous to the determination of the answer itself.

References

3