@inproceedings{afe4518b05074284ae9e4a81d6618d9c,
title = "Efficient temporal coalescing query support in relational database systems",
abstract = "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.",
author = "Xin Zhou and Fusheng Wang and Carlo Zaniolo",
year = "2006",
doi = "10.1007/11827405\_66",
language = "English",
isbn = "3540378715",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "676--686",
booktitle = "Database and Expert Systems Applications - 17th International Conference, DEXA 2006, Proceedings",
note = "17th International Conference on Database and Expert Systems Applications, DEXA 2006 ; Conference date: 04-09-2006 Through 08-09-2006",
}