A temporal object relational SQL language with attribute timestamping in a temporal transparency environment

  • Authors:
  • Vo Thi Ngoc Chau;Suphamit Chittayasothorn

  • Affiliations:
  • Department of Computer Engineering, Faculty of Engineering, King Mongkut's Institute of Technology Ladkrabang, Bangkok 10520, Thailand;Department of Computer Engineering, Faculty of Engineering, King Mongkut's Institute of Technology Ladkrabang, Bangkok 10520, Thailand

  • Venue:
  • Data & Knowledge Engineering
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of any type is naturally handled. With temporal logic, users can issue temporal queries in an intuitively expressive manner. The language provides valid time support for upward compatibility, temporal upward compatibility, sequenced and non-sequenced variants to serve both non-temporal and temporal users. Using object relational technology, the implementation is made for embedded and interactive SQL modes. All existing interfaces of an ORDBMS are inherited with temporal transparency.