integrity constraint

integrity constraint

(database)
A constraint (rule) that must remain true for a database to preserve integrity. Integrity constraints are specified at database creation time and enforced by the database management system.

Examples from a genealogical database would be that every individual must be their parent's child or that they can have no more than two natural parents.
References in periodicals archive ?
where Ri means the relation, Ii means the integrity constraint for i [member of] <1,n>; I means global integrity constraints for all relationships among relations.
Existence integrity constraint: [Tau] ([E.sub.i]) cannot have null or duplicate values for [k.sub.i], for all i = 1, 2, ..., n.
This condition is imposed by the integrity constraint in line 10, and relative to the facts in listing 1 it is instantiated to
A System Prototype for Map Editing and Integrity Constraint Validation
However, contrary to the schema constraint routine, in the integrity constraint routine the removal of a subtree (rooted at an update position p) triggers the subtree traversal for searching key and foreign key values involved in the update.
Likewise, a referential integrity constraint would be defined between the INVOICE and the ACCOUNT tables based on that Account_Number value.
Note that the definition of local and global data items suggests that there be no integrity constraints between local and global data items at a site (as that could lead to an intersite integrity constraint involving local data items).
Partial subsumption is essentially the application of the subsumption algorithm with C as the integrity constraint and D as the body of a rule that defines a predicate.
In addition to defining a database in terms of an EDB and an IDB, it is necessary to formalize what is meant by an integrity constraint. Kowalski (1978) suggests that an integrity constraint is a formula that is consistent with the DDB, but for Reiter (1984) and Lloyd and Topor (1985), an integrity constraint is a theorem of the DDB.
Suppose the plane can carry at most 200 passengers, so that the integrity constraint of the system is res_seats [less than or equal to] 200.
And faced with challenging PCB interposer layout due to irregular routing patterns and signal integrity constraints, Intel engineers introduced a router using AI and ML at PCB West last year.

Full browser ?