Chapter 9

Temporal Entity Integrity

This chapter describes entity integrity as it applies to both temporal tables and conventional tables, and shows how conventional entity integrity is a limit case of temporal entity integrity.

Keywords

temporal entity integrity; conventional table; bitemporal table; state-time table; assertion-time table; state-time interval

The previous chapter provided us with several useful concepts. First of all, it distinguished the implementation mechanics from the semantics of entity integrity, calling the former row integrity and the latter referent integrity. This distinction, as we will see in the next chapter, also applies to referential integrity (not to be confused with referent integrity). The previous chapter also ...

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.