referential integrity


Also found in: Acronyms, Wikipedia.

referential integrity

(database)
A collection of properties which should be possessed by data in a relational database.

For example, in a database of family members, if we enter A as a spouse of B, we should also enter B as a spouse of A. Similarly, if we remove one end of the relationship we should also remove the other.

referential integrity

A database management safeguard that ensures every foreign key matches a primary key. For example, customer numbers in a customer file are the primary keys, and customer numbers in the order file are the foreign keys. If a customer record is deleted, the order records must also be deleted; otherwise they are left without a primary reference. If the DBMS does not test for this, it must be programmed into the applications.
References in periodicals archive ?
Detailed tracking at individual test/accession level ensures full reportability and referential integrity.
REFERENTIAL INTEGRITY (RI) is a method for ensuring the "correctness" of data within a DBMS.
With GenRocket's TDG technology, software testers quickly create and execute comprehensive test scenarios with patterned and conditioned synthetic test data based on pre-defined data models that preserve the referential integrity of parent child relationships in the production database.
The use of GenRocket's TDG technology allows software test consultants to quickly create and execute comprehensive test scenarios with patterned and conditioned test data, based on the most complex data models while preserving the referential integrity and parent child relationships.
Preserves the formats and referential integrity of protected data, so that existing analytics and ad hoc queries don't need to change.
It maintains referential integrity across business lines and different platforms such as Oracle, MSSQL, Cache, Hadoop, and file formats that include VSAM, Excel, delimited, and XML.
Capgemini clients benefit from optimal protection of their data in non-production environments, and from the assurance that their masked data remains representative of the original production data with full referential integrity.
is a revolutionary tool that creates and publishes quality test data from scratch whilst maintaining the relationships and referential integrity of production environments.
Data integrities, such as entity integrity and referential integrity, are enforced to comply with any business rules in database (Date, 2004).
When you have multiple related tables, the order you enter data is important, especially when you are enforcing referential integrity.
We extend previous research that is based on a single relation to multi-relation database environment, by including referential integrity constraints, access time based heuristic, and a comprehensive cost model that considers most transaction types including updates and joins.
Without properly correlating the backup and recovery processes, each database may maintain independent referential integrity, but the correlation between the two may be lost.