Standard Article

Temporal Databases

  1. Abdullah Uz Tansel

Published Online: 15 SEP 2008

DOI: 10.1002/9780470050118.ecse432

Wiley Encyclopedia of Computer Science and Engineering

Wiley Encyclopedia of Computer Science and Engineering

How to Cite

Tansel, A. U. 2008. Temporal Databases. Wiley Encyclopedia of Computer Science and Engineering. 1–7.

Author Information

  1. City University of New York, Baruch College and the Graduate Center, New York, New York

Publication History

  1. Published Online: 15 SEP 2008

Abstract

A temporal database stores time-varying data and has the capabilities to manipulate it. Two commonly used time dimensions for maintaining temporal data are valid time and transaction time. Temporal databases are classified as valid time, transaction time, or bitmeporal databases. Temporality in databases involve subtle issues like comparing database states at different times, temporal grouping, different ways to represent the same temporal data, consistency of the timestamps of different attributes, temporal integrity constraints, and designing temporal databases. A temporal atom is a timestamp and value pair in which The timestamp is valid and/or transaction time and value are the time-varying data. For representing and manipulating temporal data, data models handle temporal atoms differently. In relational data model, which is the focus of this entry, attribute or tuple time stamping may be used. Temporal algebra and temporal calculus languages are defined accordingly. Proposals for extending SQL2 for temporal data manipulation exist, and SQl3 supports user-defined data types that can be used for defining and manipulating temporal data. This entry covers temporal query languages and the temporal issues mentioned above.

Keywords:

  • homogenous relations;
  • temporal atom;
  • temporal algebra;
  • temporal calculus;
  • temporal databases;
  • temporal database design;
  • temporal integrity constraints;
  • temporal grouping;
  • temporal SQL;
  • transaction time;
  • valid time;
  • weak relations