O'Reilly logo

Managing Time in Relational Databases by Randall Weis, Tom Johnston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required