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

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 a...

Full description

Saved in:
Bibliographic Details
Published in:Data & knowledge engineering Vol. 67; no. 3; pp. 331 - 361
Main Authors: Chau, Vo Thi Ngoc, Chittayasothorn, Suphamit
Format: Journal Article
Language:English
Published: Elsevier B.V 01.12.2008
Subjects:
Attribute timestamping
Object relational database
SQL
Temporal database
Temporal transparency
Attribute timestamping
Temporal database
Object relational database
SQL
Temporal transparency
ISSN:0169-023X, 1872-6933
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:0169-023X
1872-6933
DOI:10.1016/j.datak.2008.06.008