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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.