Managing Time in Relational Databases
How to Design, Update and Query Temporal Data
By- Tom Johnston, Enterprise Data Architecture Consultant, Mindful Data, Inc., Atlanta, GA, USA
- Randall Weis, Founder and CEO, InBase Inc., Lemont, IL, USA
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.
Audience
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
Reviews
-
"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
Contents
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
