A generalised temporal algebra

Authors:
Georgia Garani
Affiliations:
Department of Computer Science and Telecommunications, Higher Technological Educational Institute of Larissa, Larissa, Greece
Venue:
Data & Knowledge Engineering
Year:
2006

Citing 14
Cited 2

Logic, algebra and databases

Logic, algebra and databases
The temporal query language TQuel

ACM Transactions on Database Systems (TODS)
Extending relational algebra to manipulate temporal data

Information Systems
A recursive algebra for nested relations

Information Systems
On completeness of historical relational query languages

ACM Transactions on Database Systems (TODS)
Joining nested relations and subrelations

Information Systems
The TSQL2 Temporal Query Language

The TSQL2 Temporal Query Language
Temporal Relational Data Model

IEEE Transactions on Knowledge and Data Engineering
SQL Extension for Interval Data

IEEE Transactions on Knowledge and Data Engineering
Algebraic Identities and Query Optimization in a Parametric Model for Relational Temporal Databases

IEEE Transactions on Knowledge and Data Engineering
Temporal Data Management

IEEE Transactions on Knowledge and Data Engineering
An Introduction to Database Systems

An Introduction to Database Systems
Joining interval data in relational databases

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Join operations in temporal databases

The VLDB Journal — The International Journal on Very Large Data Bases

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

Data & Knowledge Engineering
Modeling temporal dimensions of semistructured data

Journal of Intelligent Information Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

The algebra (TNA) of a generalised temporal database model supporting temporal relations nested to any finite depth is presented. The temporal nested relations consist of temporal nested attributes which are formed from temporal attributes together with the corresponding time-varying attributes. Therefore, the temporal dimension of the model is nested and is not integral with the corresponding time-dependent value. All the operations of the algebra are defined recursively and are proved to be closed. In particular, considering the natural join operation for temporal nested relations, different cases are presented, distinguished by the types and the nesting levels of the common attributes that participate in the natural join operation.