DocumentCode
408368
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
Volume
2
fYear
2004
fDate
5-7 April 2004
Firstpage
460
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Information Technology: Coding and Computing, 2004. Proceedings. ITCC 2004. International Conference on
Print_ISBN
0-7695-2108-8
Type
conf
DOI
10.1109/ITCC.2004.1286696
Filename
1286696
Link To Document