Managing Time in Relational Databases book cover

Managing Time in Relational Databases

How to Design, Update and Query Temporal Data

Managing Time in Relational Databases shows how to make the rich information content of bi-temporal data available to business users, while simplifying the design, maintenance and retrieval of that data. Metadata declarations eliminate the need to directly model temporal data. Temporal data maintenance is isolated in code that can be invoked to update bi-temporal data in any database and from any application program, across the enterprise. Anyone who can write queries against conventional data will be able to write queries against the bi-temporal data structures described in this book.

IT professionals directly concerned with managing data and providign access to it. This inlcudes data modelers, database developers, database designers, data architects, database analysts, corporate database administrators, SQL programmers, and applications systems developers.

Hardbound, 512 Pages

Published: July 2010

Imprint: Morgan Kaufmann

ISBN: 978-0-12-375041-9


  • "You cannot escape temporal data. You need to get over it, sit down and read what Tom and Randy are telling you in this book. "--Joe Celko, Independent Consultant & Columnist for Intelligent Enterprise, USA

    "The authors present an original and comprehensive conceptual approach called Asserted Versioning, which includes support for bi-temporality and is a significant advance in the theory and practice of managing time-varying data."--Richard Snodgrass, Professor of Computer Science at the University of Arizona

    "Information technology consultants Johnston and Weis explain how to integrate time into a business data system, so that the past, present, and projected future of things can be accessed easily and quickly. Tables that show time are versioned tables, and they show how using them lowers the cost and increases the value of temporal data, data that shows change through time. They introduce temporal data management and asserted versioning, then look at designing, maintaining, and querying asserted version databases."--SciTech Book News


  • Part 1. An Introduction to Temporal Data Management
    Chapter 1. A Brief History of Temporal Data Management
    Chapter 2. A Taxonomy of Bi-Temporal Data Management Methods

    Part 2. An Introduction to Asserted Versioning
    Chapter 3. The Origins of Asserted Versioning: Computer Science Research
    Chapter 4. The Origins of Asserted Versioning: IT Best Practices
    Chapter 5. The Core Concepts of Asserted Versioning
    Chapter 6. Diagrams and Other Notations
    Chapter 7. The Basic Scenario

    Part 3. Designing, Maintaining and Querying Asserted Version Databases
    Chapter 8. Designing and Generating Asserted Versioning Databases
    Chapter 9. An Introduction to Temporal Transactions
    Chapter 10.Temporal Transactions on Single Tables
    Chapter 11. Temporal Transactions on Multiple Tables
    Chapter 12. Deferred Assertions and Other Pipeline Datasets
    Chapter 13. Re-Presenting Internalized Pipeline Datasets
    Chapter 14. Allen Relationship and Other Queries
    Chapter 15. Optimizing Asserted Versioning Databases
    Chapter 16. Conclusion

    Appendix: Bibliographical Essay


advert image