• 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