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 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.
