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 ?
The tool also retains referential integrity, check constraints and unique constraints and uniqueness (if unique index exists).
the commission also includes the migration of existing data with their referential integrity, the implementation project including project management and the subsequent maintenance (system service) and operation of the specialized procedure (hosting) in a certified data center over 4 years.
GenRocket TDG (TM) is the industry's first and only patented Test Data Generation platform capable of generating controlled and conditioned real-time synthetic test data with referential integrity at the rate of 10,000 rows per second.
There are two relationships with referential integrity: the relationship between customers and products on the Customer[R] field and the relationship between products and orders on the ProductID field.
Rather than simply randomizing the data, it uses pseudonymization and anonymization techniques to ensure the database is truly representative of the original and retains its referential integrity and distribution characteristics.
- 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.
FPE also preserves 'referential integrity' of the data, which allows the data to be analysed in a protected state, without having to de-crypt it first.
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."
Their signature solution, Grid-Tools Datamaker?, 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).