Title :
History-less checking of dynamic integrity constraints
Author_Institution :
Comput. & Inf. Sci., Kansas State Univ., Manhattan, KS, USA
Abstract :
An efficient implementation method is described for dynamic integrity constraints formulated in past temporal logic. Although the constraints can refer to past states of the database, their checking does not require that the entire database history be stored. Instead, every database state is extended with auxiliary relations that contain the historical information necessary for checking constraints. Auxiliary relations can be implemented as materialized relational views. The author analyzes the computational cost of the method and outlines how it can be implemented by using existing database technology. Related work on dynamic integrity constraints is surveyed
Keywords :
data integrity; temporal databases; temporal logic; computational cost; database history; database state; dynamic integrity constraints; historical information; materialized relational views; past temporal logic; Constraint optimization; Data models; History; Logic; Office automation; Relational databases; Transaction databases;
Conference_Titel :
Data Engineering, 1992. Proceedings. Eighth International Conference on
Conference_Location :
Tempe, AZ
Print_ISBN :
0-8186-2545-7
DOI :
10.1109/ICDE.1992.213153