Translating SQL Into Relational Algebra: Optimization, Semantics, and Equivalence of SQL Queries
IEEE Transactions on Software Engineering
A temporally oriented data model
ACM Transactions on Database Systems (TODS)
PODS '86 Proceedings of the fifth ACM SIGACT-SIGMOD symposium on Principles of database systems
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
A homogeneous relational model and query languages for temporal databases
ACM Transactions on Database Systems (TODS)
A temporal relational model and a query language
Information Sciences: an International Journal
Algebra and query language for a historical data model
The Computer Journal - Special issue on databases
Safety and translation of relational calculus
ACM Transactions on Database Systems (TODS)
Temporal databases status and research directions
ACM SIGMOD Record - Directions for future database research & development
Evaluation of relational algebras incorporating the time dimension in databases
ACM Computing Surveys (CSUR)
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
Temporal databases: theory, design, and implementation
Temporal databases: theory, design, and implementation
A consensus glossary of temporal database concepts
ACM SIGMOD Record
Unifying temporal data models via a conceptual model
Information Systems
On the semantics of “now” in databases
ACM Transactions on Database Systems (TODS)
Advanced database systems
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
Joe Celko's SQL for smarties: advanced SQL programming (2nd editor)
Joe Celko's SQL for smarties: advanced SQL programming (2nd editor)
The object data standard: ODMG 3.0
The object data standard: ODMG 3.0
Spatio-temporal database support for legacy applications
SAC '98 Proceedings of the 1998 ACM symposium on Applied Computing
Maintaining knowledge about temporal intervals
Communications of the ACM
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Data Models
SQL Extension for Interval Data
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
Relational Database Systems with Zero Information Loss
IEEE Transactions on Knowledge and Data Engineering
First-Order Queries over Temporal Databases Inexpressible in Temporal Logic
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
Point-Versus Interval-Based Temporal Data Models
ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
On the Completeness of Temporal Database Query Languages
ICTL '94 Proceedings of the First International Conference on Temporal Logic
Coalescing in Temporal Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Layered Temporal DBMS: Concepts and Techniques
Proceedings of the Fifth International Conference on Database Systems for Advanced Applications (DASFAA)
Evaluating the Completeness of TSQL2
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Querying ATSQL databases with temporal logic
ACM Transactions on Database Systems (TODS)
A Foundation for Conventional and Temporal Query Optimization Addressing Duplicates and Ordering
IEEE Transactions on Knowledge and Data Engineering
TVQL - Temporal Versioned Query Language
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
TEMPOS: A Platform for Developing Temporal Applications on Top of Object DBMS
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
Augmenting a Conceptual Model with Geospatiotemporal Annotations
IEEE Transactions on Knowledge and Data Engineering
Modification semantics in now-relative databases
Information Systems
An algebraic framework for temporal attribute characteristics
Annals of Mathematics and Artificial Intelligence
Efficient temporal counting with bounded error
The VLDB Journal — The International Journal on Very Large Data Bases
Towards General Temporal Aggregation
BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
Data & Knowledge Engineering
Querying multiple video streams and hypermedia objects of a video-based virtual space system
Digital Cities'03 Proceedings of the Third international conference on Information Technologies for Social Capital: cross-Cultural Perspectives
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
ACM SIGMOD Record
The telic/atelic distinction in temporal databases
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Managing proposals and evaluations of updates to medical knowledge: Theory and applications
Journal of Biomedical Informatics
Hi-index | 0.00 |
A wide range of database applications manage time-varying data. Many temporal query languages have been proposed, each one the result of many carefully made yet subtly interacting design decisions. In this article we advocate a different approach to articulating a set of requirements, or desiderata, that directly imply the syntactic structure and core semantics of a temporal extension of an (arbitrary) nontemporal query language. These desiderata facilitate transitioning applications from a nontemporal query language and data model, which has received only scant attention thus far.The paper then introduces the notion of statement modifiers that provide a means of systematically adding temporal support to an existing query language. Statement modifiers apply to all query language statements, for example, queries, cursor definitions, integrity constraints, assertions, views, and data manipulation statements. We also provide a way to systematically add temporal support to an existing implementation. The result is a temporal query language syntax, semantics, and implementation that derives from first principles.We exemplify this approach by extending SQL-92 with statement modifiers. This extended language, termed ATSQL, is formally defined via a denotational-semantics-style mapping of temporal statements to expressions using a combination of temporal and conventional relational algebraic operators.