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

8. Designing and Generating Asserted Versioning Databases
Contents
Translating a Non-Temporal Logical Data Model into a Temporal Physical Data Model169
The Logical Data Model169
Referential Constraints Between Non-Temporal and Bi-Temporal Tables171
Asserted Versioning Metadata173
The Physical Data Model180
Generating an Asserted Versioning Database from a Physical Data Model and Metadata181
Temporalizing the Physical Data Model182
Generating Temporal Entity and Temporal Referential Integrity Constraints185
Redundancies in the Asserted Versioning Bi-Temporal Schema186
Apparent Redundancies in the Asserted Versioning Schema186
A Real Redundancy in the Asserted Versioning Schema188
Glossary References189
An Asserted Versioning database is one that contains ...

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