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

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Data & knowledge engineering Jg. 67; H. 3; S. 331 - 361
Hauptverfasser: Chau, Vo Thi Ngoc, Chittayasothorn, Suphamit
Format: Journal Article
Sprache:Englisch
Veröffentlicht: Elsevier B.V 01.12.2008
Schlagworte:
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-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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