Temporal Data Modeling and Integrity Constraints in Relational Databases

Abstract

We address the key issues of temporal data modeling and temporal integrity constraints in the temporal extensions to the relational data model in attribute and tuple time stamping. These issues include representation of temporal data, temporal grouping identifiers, primary keys of temporal relations and other forms of temporal integrity constraints. We extend the traditional integrity constraints to the temporal domain. In tackling subtle issues temporality creates, we conceptualize that a temporal integrity constraint has a data and a temporal (time) component. The time component of a temporal integrity constraint limits the attribute values to the lifespan of an object (tuple). We also generalize single state integrity constraints to multi-state temporal integrity constraints and apply them to existential and referential integrity. We provide algorithms for enforcing the two types of temporal integrity constraints. © Springer-Verlag 2004.