5. The Core Concepts of Asserted Versioning
Contents
Objects, Episodes, Versions and Assertions97
Objects97
Episodes98
Versions100
Assertions102
Temporal Integrity Constraints104
Temporal Entity Integrity104
Temporal Referential Integrity108
Bi-Temporal Tables and Non-Bi-Temporal Views111
Surrogate Keys and Bi-Temporal Match Logic115
Surrogate Keys, Business Keys and Conventional Tables115
Surrogate Keys, Business Keys and Asserted Version Tables116
Glossary References117
Managed objects are data which transformations and constraints treat as a single unit. In the relational model, individual rows of data are the managed objects to which integrity constraints are applied, and these individual rows of data each represent a different object. One object: ...

Get Managing Time in Relational Databases 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.

Start your free trial