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

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

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