Choose Index below for a list of all words and phrases defined in this glossary.

Recursive Referential Integrity

index | Index

Recursive Referential Integrity - definition(s)

Recursive Referential Integrity - see also Referential Integrity(RI). One special type of "RI" involves just a single table, tied back to itself. A set of columns is set up as the foreign key, referencing the primary key column(s), but of another record. In this manner, a hierarchy can be created within the table. For example, in a table that stores Products, one product can be a subtype of another product.

[Category=Data Governance ]

Source: The Data Governance Institute, 21 December 2009 10:19:17, External





Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: