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. This book integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.

Autorentext
Dr. Tom Johnston is the Chief Scientist at Asserted Versioning, LLC, which has developed a middleware product which supports the standard theory of bitemporal data, and which also implements the Asserted Versioning extensions to that standard theory. He is the co-author of Managing Time in Relational Databases (Morgan-Kaufmann, 2010). He lives in Atlanta, Georgia. Randall Weis, founder and CEO of InBase, Inc, has more than 25 years of experience in IT and IT management, specializing in enterprise data architecture. Weis' technical expertise is in sophisticated, multi-tiered systems. He has designed logical and physical data models and implemented several high profile, very large database (VLDB) systems in the financial and insurance industries. These systems have had very stringent performance and real-time history requirements. His software development company, InBase, Inc., has developed software and Web sites used by some of the nations largest companies. Weis has been a presenter at various user groups, including Guide, Share, Midwest Database Users Group and Camp IT Expo. His technique for modeling history, retro activity and future dating has been reviewed and approved for the physical implementation of IBM's Insurance Application Architecture (IAA).

Klappentext
Managing Time in Relational Databases presents a comprehensive view of how to manage a temporal database. Temporal data management refers to an integrated method of managing data about the past, present, and future of the objects and events of interest to the user. The practical and comprehensive nature of this material is demonstrated in each chapter by a mixture of diagrams and text typical for a book about data architecture and data models. The chapters dealing specifically with managing temporal and bi-temporal data will rely heavily on an example-driven approach, each example presenting specific real-world scenarios.

Inhalt

Part 1. An Introduction to Temporal Data ManagementChapter 1. A Brief History of Temporal Data ManagementChapter 2. A Taxonomy of Bi-Temporal Data Management MethodsPart 2. An Introduction to Asserted VersioningChapter 3. The Origins of Asserted Versioning: Computer Science ResearchChapter 4. The Origins of Asserted Versioning: IT Best PracticesChapter 5. The Core Concepts of Asserted VersioningChapter 6. Diagrams and Other NotationsChapter 7. The Basic ScenarioPart 3. Designing, Maintaining and Querying Asserted Version DatabasesChapter 8. Designing and Generating Asserted Versioning DatabasesChapter 9. An Introduction to Temporal TransactionsChapter 10.Temporal Transactions on Single TablesChapter 11. Temporal Transactions on Multiple TablesChapter 12. Deferred Assertions and Other Pipeline DatasetsChapter 13. Re-Presenting Internalized Pipeline DatasetsChapter 14. Allen Relationship and Other QueriesChapter 15. Optimizing Asserted Versioning DatabasesChapter 16. ConclusionAppendix: Bibliographical Essay