Title :
Integrity constraints in temporal relational databases
Author :
Tansel, Abdullah Uz
Author_Institution :
Dept. Stat. & Comput. Inf. Syst., Baruch Coll., City Univ. of New York, NY, USA
Abstract :
We address the key issues of integrity constraints in temporal data within the relational framework. 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 of temporality in managing time-varying data, 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) and it is peculiar to temporal data only. We also generalize single state integrity constraints to multistate temporal integrity constraints and apply them to existential and referential integrity.
Keywords :
data integrity; data structures; relational databases; temporal databases; existential integrity; primary key; referential integrity; single state integrity constraints; temporal grouping identifier; temporal relational databases; time-varying data; Books; Data models; Database systems; Educational institutions; History; Information systems; Logic; Relational databases; Statistics;
Conference_Titel :
Information Technology: Coding and Computing, 2004. Proceedings. ITCC 2004. International Conference on
Print_ISBN :
0-7695-2108-8
DOI :
10.1109/ITCC.2004.1286696