Temporal Data & the Relational ModelBy
- C.J. Date
- Hugh Darwen
- Nikos Lorentzos
Temporal database systems are systems that provide special support for storing, querying, and updating historical and/or future data. Current DBMSs provide essentially no temporal features at all, but this situation is likely to change soon for a variety of reasons; in fact, temporal databases are virtually certain to become important sooner rather than later, in the commercial world as well as in academia. This book provides an in-depth description of the foundations and principles on which those temporal DBMSs will be built. These foundations and principles are firmly rooted in the relational model of data; thus, they represent an evolutionary step, not a revolutionary one, and they will stand the test of time.
Paperback, 422 Pages
Published: November 2002
Imprint: Morgan Kaufmann
- Preface. Part I Preliminaries: A Review of Relational Concepts. An Overview of Tutorial D. Part II Laying the Foundation: Time and the Database. What Is the Problem? Intervals. Opeartors on Intervals. The EXPAND and COLLAPSE Operators. The PACK and UNPACK Operators. Generalizing the Relational Operators. Part III Building on the Foundations: Database Design. Integrity Constraints I: Candidate Keys and Related Constraints. Integrity Constraints II: General Constraints. Database Queries. Database Updates. Stated Times and Logged Times. Point and Interval Types Revisited. Appendixes: Implementation Considerations. Generalizing the EXPAND and COLLAPSE Operators. References and Bibliography. Index.