Temporal Data & the Relational Model

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.

This book is arranged in three parts and a set of appendixes:

• Preliminaries: Provides a detailed review of the relational model, and an overview of the Tutorial D language.
• Laying the Foundations: Explains basic temporal data problems and introduces fundamental constructs and operators for addressing those problems.
• Building on the Foundations: Applies the material of the previous part to issues of temporal database design, temporal constraints, temporal query and update, and much more.
• Appendixes: Include annotated references and bibliography, implementation considerations, and other topics.

Key features:

• Describes a truly relational approach to the temporal data problem.
• Addresses implementation as well as model issues.
• Covers recent research on new database design techniques, a new normal form, new relational operators, new update operators, a new approach to the problem of "granularity," support for "cyclic point types," and other matters.
• Includes review questions and exercises in every chapter.
• Suitable for both reference and tutorial purposes.

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.

This book is arranged in three parts and a set of appendixes: Preliminaries: Provides a detailed review of the relational model, and an overview of the Tutorial D language.