Chapter 10

Temporal Referential Integrity

This chapter describes referential integrity as it applies to bitemporal tables and to state-time tables, as well as to conventional tables. It describes bitemporal referential integrity as the constraint that the bitemporal area of any child row must be fully contained within the bitemporal area of a set of related parent rows, and explains the semantics which this constraint implements. It provides similar explanations of state-time referential integrity and of conventional referential integrity, and of the semantics they implement.

Keywords

clock tick; decoalesce; episode; existence dependent; referent; statement; temporal referential integrity; withdraw

Referential integrity is a well-understood relational ...

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.