Advanced database systems
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Point-Based Temporal Extension of Temporal SQL
DOOD '97 Proceedings of the 5th International Conference on Deductive and Object-Oriented Databases
Coalescing in Temporal Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Querying Historical Data in IBM DB2 C/S DBMS Using Recursive SQL
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Temporal XML? SQL Strikes Back!
TIME '05 Proceedings of the 12th International Symposium on Temporal Representation and Reasoning
Scalable architecture and query optimization fortransaction-time DBs with evolving schemas
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Hi-index | 0.00 |
The interest in, and user demand for, temporal databases have only increased with time; unfortunately, DBMS vendors and standard groups have not moved aggressively to extend their systems with support for transaction-time or valid-time. This can be partially attributed to the expected major R&D costs to add temporal support to RDBMS by directly extending the database engine. The newly introduced SQL:2003 standards have actually significantly enhanced our ability to support temporal applications in commercial database systems. The long recognized problem of coalescing, which is difficult to support in the framework of SQL:1992, can now be effectively supported in RDBMS. In this paper, we investigate alternatives of temporal coalescing queries under temporal data models in RDBMS. We provide an SQL:2003-based query algorithm and a native relational user defined aggregates (UDA) approach – both approaches only require a single scan of the database. We conclude that temporal queries can be best supported by OLAP functions supported in the current SQL:2003 standards. These new findings demonstrate that the current RDBMS are mature enough to directly support efficient temporal queries, and provide a new paradigm for temporal database research and implementation.