6. Diagrams and Other Notations
Contents
The Asserted Version Table120
The Temporal Primary Key122
The Temporal Foreign Key123
The Effective Time Period124
The Episode Begin Date124
The Assertion Time Period124
The Row Creation Date125
The Basic Asserted Versioning Diagram125
Additional Diagrams and Notations130
Viewing the Asserted Version Table132
The Conventional Table View133
The Version Table View134
The Assertion Table View135
Views and Mental Images137
Glossary References138
In the first section of this chapter, we present the schema common to all asserted version tables, using a table of health insurance policies as an example. All of the concepts introduced in the last chapter, such as objects, episodes, versions and assertions, and the two ...

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