Recursive Referential Integrity

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, http://www.datagovernance.com/glossary-governance/