Time-based operators for relational algebra query languages

Authors:
M.A Bassiouni;M.J Llewellyn;A Mukherjee
Affiliations:
Department of Computer Science, University of Central Florida, Orlando, FL 32816, U.S.A.;Department of Computer Science, University of Central Florida, Orlando, FL 32816, U.S.A.;Department of Computer Science, University of Central Florida, Orlando, FL 32816, U.S.A.
Venue:
Computer Languages
Year:
1993

Citing 15
Cited 1

A temporally oriented data model

ACM Transactions on Database Systems (TODS)
The temporal query language TQuel

ACM Transactions on Database Systems (TODS)
Logical modeling of temporal data

SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Extending the relational algebra to support transaction time

SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Time-by-Example Query Language for Historical Databases

IEEE Transactions on Software Engineering
A temporal relational model and a query language

Information Sciences: an International Journal
Historical database views

Information and Software Technology
Evaluation of relational algebras incorporating the time dimension in databases

ACM Computing Surveys (CSUR)
A relational-calculus query language for historical databases

Computer Languages - Special issue: ICCL '88—Part III: Special purpose languages
On an algebra for historical relational databases: two views

SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
A query language for a homogeneous temporal database

PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
The database language GEM

SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
Extensions to SQL for Historical Databases

IEEE Transactions on Knowledge and Data Engineering
Towards An Implementation of Database Management Systems with Temporal Support

Proceedings of the Second International Conference on Data Engineering
Toward a Multihomogeneous Model for a Temporal Database

Proceedings of the Second International Conference on Data Engineering

Extending temporal query languages to handle imprecise time intervals

Computer Languages

Quantified Score

Hi-index	0.00

Visualization

Abstract

We present a new approach for historical relational algebra languages based upon generalized logic for Boolean and comparison operators and a temporal modification of the standard relational algebra operators. Historical versions of standard (snapshot) relational algebra operators based upon this generalized logic are presented. The temporal modification employs a logic that operates on sets of value/time-interval pairs and which can be applied to snapshot as well as historical databases. Our emphasis is that the generalized operators can be used to enrich existing historical query languages and to provide an easier and more natural time-based interface. Using the generalized operators, users can express their queries more naturally, succinctly and elegantly. Examples are presented which illustrate that the modified operators offer a good degree of flexibility in expressing different temporal requirements.