The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Adding time dimension to relational model and extending relational algebra
Information Systems
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
A homogeneous relational model and query languages for temporal databases
ACM Transactions on Database Systems (TODS)
Extending relational algebra to manipulate temporal data
Information Systems
Time-by-Example Query Language for Historical Databases
IEEE Transactions on Software Engineering
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
A temporal relational algebra as a basis for temporal relational completeness
Proceedings of the sixteenth international conference on Very large databases
Information Sciences: an International Journal
Inadequacy of interval timestamps in temporal databases
Information Sciences: an International Journal
Evaluation of relational algebras incorporating the time dimension in databases
ACM Computing Surveys (CSUR)
On completeness of historical relational query languages
ACM Transactions on Database Systems (TODS)
Experimenting with temporal relational databases
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
On an algebra for historical relational databases: two views
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Extensions to SQL for Historical Databases
IEEE Transactions on Knowledge and Data Engineering
Temporal Relational Data Model
IEEE Transactions on Knowledge and Data Engineering
Relational Database Systems with Zero Information Loss
IEEE Transactions on Knowledge and Data Engineering
A Statistical Interface for Historical Relational Databases
Proceedings of the Third International Conference on Data Engineering
The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans
Proceedings of the Third International Conference on Data Engineering
Temporal Relational Data Model
IEEE Transactions on Knowledge and Data Engineering
Database Versions to Represent Bitemporal Databases
DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
The VLDB Journal — The International Journal on Very Large Data Bases
ADVIS'04 Proceedings of the Third international conference on Advances in Information Systems
Nested bitemporal relational algebra
ISCIS'06 Proceedings of the 21st international conference on Computer and Information Sciences
Querying event sequences by exact match or similarity search: Design and empirical evaluation
Interacting with Computers
Extending temporal query languages to handle imprecise time intervals
Computer Languages
Hi-index | 0.00 |
We consider the representation of temporal data based on tuple and attribute timestamping. We identify the requirements in modeling temporal data and elaborate on their implications in the expressive power of temporal query languages. We introduce a temporal relational data model where N1NF relations and attribute timestamping are used and one level of nesting is allowed. For this model, a nested relational tuple calculus (NTC) is defined. We follow a comparative approach in evaluating the expressive power of temporal query languages, using NTC as a metric and comparing it with the existing temporal query languages. We prove that NTC subsumes the expressive power of these query languages. We also demonstrate how various temporal relational models can be obtained from our temporal relations by NTC and give equivalent NTC expressions for their languages. Furthermore, we show the equivalence of intervals and temporal elements (sets) as timestamps in our model.