Managing Time in Relational Databaes

Description

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.

KEY FEATURES

1. Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.

2. Provides a true practical guide to the different possible methods of time-oriented databases with techniques of using existing funtionality to solve real world problems within an enterprise data architecture environment.

3. Written by IT professionals for IT professionals, this book employs a heavily example-driven approach which reinforces learning by showing the results of puting the techniques discussed into practice.

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