4. The Origins of Asserted Versioning
IT Best Practices
Contents
A Non-Temporal Table and a Basic Version Table77 Basic Versioning79 A Second Update Transaction
81 Logical Delete Versioning83 Temporal Gap Versioning86 Effective Time Versioning87 Effective Time Versioning and Retroactive Updates
89 Effective Time Versioning and Retroactive Inserts and Deletions
90 The Scope and Limits of Best Practice Versioning92 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 ...