Managing Time in Relational Databases

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