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

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

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