Managing Time in Databases: A Comprehensive Approach Book

Part 1. Introduction.
Chapter 1. Historical Contextualization
Chapter 2. A Taxonomy of Methods of Managing Time in Databases.
Chapter 3. Temporal Data Management in Enterprise Data Architecture.
Chapter 4. The Objectives and Origins of Asserted Versioning.
Chapter 5. Basic Concepts of Asserted Versioning.

Part 2. Current Practice in Temporal Data Management.
Chapter 6. Baseline: Updates in Place.
Chapter 7. Standard Practice: Adding a Date to a Primary Key.
Chapter 8. Best Practice: Using Effective Date Pairs.

Part 3. Asserted Versions: a New Approach to Bi-Temporal Data Management.
Chapter 9. Objects, Episodes, Versions and Assertions.
Chapter 10.The Mechanics of Maintaining Versioned Objects.
Chapter 11. The Semantics of Maintaining Versioned Objects.
Chapter 12. Querying Versioned Objects.

Part 4. Introducing Versioned Objects into the Enterprise.
Chapter 13. A Business-Driven Approach to Bi-Temporality
Chapter 14. Surrogate Keys.
Chapter 15. Versioned Objects, Warehouse Snapshots and Versioned Dimensions
Chapter 16. Maximizing Performance for Bi-Temporal Tables.

Part 5. Related Matters.
Chapter 17. Temporal Dimensions and Codd's Information Principle.
Chapter 18. Deferred Transactions and Future States.
Chapter 19. Sandboxes and Release Management.
Chapter 20. The Problem of Identifying Recurring Objects.
Chapter 21. Other Kinds of Asserted Versions.

Part 6. The Asserted Versioning Prototype.
Chapter 22. Specifying Asserted Version Tables.
Chapter 23. Generating Asserted Version Tables From ERwin Macros.
Chapter 24. Using the Prototype.