Bitemporal Data

Bitemporal Data : Theory and Practice

By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 1 business day
When will my order arrive?

Description

Bitemporal data has always been important. But it was not until 2011 that the ISO released a SQL standard that supported it. Currently, among major DBMS vendors, Oracle, IBM and Teradata now provide at least some bitemporal functionality in their flagship products. But to use these products effectively, someone in your IT organization needs to know more than how to code bitemporal SQL statements. Perhaps, in your organization, that person is you.

To correctly interpret business requests for temporal data, to correctly specify requirements to your IT development staff, and to correctly design bitemporal databases and applications, someone in your enterprise needs a deep understanding of both the theory and the practice of managing bitemporal data. Someone also needs to understand what the future may bring in the way of additional temporal functionality, so their enterprise can plan for it. Perhaps, in your organization, that person is you.

This is the book that will show the do-it-yourself IT professional how to design and build bitemporal databases and how to write bitemporal transactions and queries, and will show those who will direct the use of vendor-provided bitemporal DBMSs exactly what is going on "under the covers" of that software.
show more

Product details

  • Paperback | 400 pages
  • 188 x 230 x 20mm | 840g
  • Morgan Kaufmann Publishers In
  • San Francisco, United States
  • English
  • Approx. 170 illustrations; Illustrations, unspecified
  • 0124080677
  • 9780124080676
  • 735,172

Table of contents

Preface.



Chapter 1. Basic Concepts.

Part I. Theory.



Chapter 2. Time and Temporal Terminology.
Chapter 3. The Relational Paradigm: Mathematics.
Chapter 4. The Relational Paradigm: Logic.
Chapter 5. The Relational Paradigm: Ontology.
Chapter 6. The Relational Paradigm: Semantics.
Chapter 7. The Allen Relationships.
Chapter 8. Temporal Integrity Concepts.
Chapter 9. Temporal Entity Integrity.
Chapter 10. Temporal Referential Integrity.

Part II. Practice.



Chapter 11. Temporal Transactions.
Chapter 12. Basic Temporal Queries.
Chapter 13. Advanced Temporal Queries.
Chapter 14. Future Assertion Time.
Chapter 15. Temporal Requirements.
Chapter 16. Bitemporal Data and the Inmon Data Warehouse.
Chapter 17. Semantic Integration via Messaging.
Chapter 18. Bitemporal Data and the Kimball Data Warehouse.
Chapter 19. The Future of Relational Databases.

Afterword: Reflections on Mindfulness and Bitemporality.




Annotated Bibliography.
show more

Review Text

"...the book describes in a nice and engaging manner an important business problem, the (often serious) shortcomings of existing IT solutions, and ways to solve the problem properly."-- Computing Reviews, Bitemporal Data
show more

Review quote

"...the book describes in a nice and engaging manner an important business problem, the (often serious) shortcomings of existing IT solutions, and ways to solve the problem properly."--Computing Reviews, Bitemporal Data
show more

About Tom Johnston

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.
show more