referential integrity

Also found in: Acronyms, Wikipedia

0.01 sec.

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.

(database)

referential integrity - 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.

Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.

?Page tools

Printer friendly
Cite / link

Feedback

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found			If this is important then you will want to build a program from RPG or another language to enforce data quality and referential integrity. AS/400 Data Tools Make Your Life Easier by John Andersen / Computers and Internet community In addition to maintaining referential integrity and handling data compatibility and translation issues, creating realistic test data now requires a federated data access capability, so you can extract related data from multiple databases using a single extract process. Enterprise strategies to improve application by Software World Without properly correlating the backup and recovery processes, each database may maintain independent referential integrity, but the correlation between the two may be lost. Planning for backup and recovery: the key elements for a successful ... by Dow, James / Computer Technology Review			Reference Point reference range reference record reference rounds reference section reference seismometer reference signal level reference sound level reference spheroid reference standard specification reference standards reference station reference supply reference temperature reference time reference tone reference validation mechanism reference vehicle reference voltage reference volume reference white reference white level referencing Referendum referendum and initiative referential integrity referential transparency referentially transparent referer referred pain referrer Refik Halid Karay refine Refined C Refined Fortran refined kerosine refined lard refined lecithin refined oil refined paraffin wax refined tar refinement Refiner refinery refinery gas refining Refining of Metals Refining of Petroleum Products refining temperature reflash reflation			Referendarius Referendarius Referendary Referendary Referendarz Referendarz referendum referendum referendum Referendum and Initiative Referendum and Initiative Referendum and Initiative referendums referendums referendums referent referent referent referent Referent system Referent system Referent system Referent system Referente Macro della Ditta in Appalto referential referential referential referential referential idea referential index deletion referential integrity Referential Integrity Check Referential opacity Referential transparancy Referential transparency Referential Universal Digital Indexer referentiality referentiality referentially referentially referentially referentially Referentially opaque Referentially transparent Référentiel de Bon Usage Référentiel Général d'Interopérabilité Référentiel Général de Sécurité Référentiel Génie Civil referents referents Referer Referment Referment Refernce textbooks Refernce textbooks referral referral referral referral referral referral

Encyclopedia

Free Tools:	For surfers: Free toolbar & extensions \| Word of the Day \| Help For webmasters: Free content \| Linking \| Lookup box \| Double-click lookup

Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.