4. The Origins of Asserted Versioning
IT Best Practices
Contents
A Non-Temporal Table and a Basic Version Table77
Basic Versioning79
An Insert Transaction79
An Update Transaction80
A Second Update Transaction81
A Delete Transaction82
Logical Delete Versioning83
Temporal Gap Versioning86
Effective Time Versioning87
Effective Time Versioning and Retroactive Updates89
Effective Time Versioning and Retroactive Inserts and Deletions90
The Scope and Limits of Best Practice Versioning92
Glossary References93
Lots of things are important to us. That's why we keep data about them in our databases. In a non-temporal table, each one of them, i.e. each object, is represented by one and only one row. In a version table, however, each row represents a period of time ...

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