Home (Referential Integrity)
Home  
 
 
Home » GIS » Referential Integrity


 

Referential Integrity

GIS Reference imageRegion

referential integrityThe capability to ensure that changes to one table that affect other tables are transmitted to those other tables.

 


referential integrity
A mechanism for ensuring that data remains accurate and consistent as a database changes. When changes are made to a table related to another table by a common key, the changes are automatically reflected in both tables.

See referential integrity. data model 1. The result of the conceptual design process. A generalized, user-defined view of the data related to applications.
2. A formal method of describing the behavior of the real-world entities.

Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, Archive for storing historical data in little space)
Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB ...

See also: Information, Database, Model, Software, GIS

GIS Reference imageRegion

 
 rssRSS