Chapter 8

Temporal Integrity Concepts and Notations

This chapter develops the concepts and notation required to discuss temporal entity integrity and temporal referential integrity, and also introduces a graphic notation for representing temporal integrity constraints.

Keywords

assertion time; atemporal state; bitemporal cell; coalesce; existence-dependent; implicitly bitemporal; inscription; referent identifier; referent integrity; row integrity; state time; temporal entity integrity; temporal referential integrity

Two of the principal constraints on relational tables are entity integrity and referential integrity. Primary key declarations set up the mechanisms by which a DBMS enforces entity integrity. Foreign key declarations set up the mechanisms ...

Get Bitemporal Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.