%0 Journal Article %1 wang08archis %A Wang, Fusheng %A Zaniolo, Carlo %A Zhou, Xin %D 2008 %J The VLDB Journal %K research.xml research.db research.conceptual.time %N 6 %P 1445--1463 %T ArchIS: an XML-based approach to transaction-time temporal database systems %U http://dx.doi.org/10.1007/s00778-007-0086-6 %V 17 %X Abstract  Effective support for temporal applications by database systems represents an important technical objective that is difficultto achieve since it requires an integrated solution for several problems, including (i) expressive temporal representationsand data models, (ii) powerful languages for temporal queries and snapshot queries, (iii) indexing, clustering and query optimizationtechniques for managing temporal information efficiently, and (iv) architectures that bring together the different piecesof enabling technology into a robust system. In this paper, we present the ArchIS system that achieves these objectives bysupporting a temporally grouped data model on top of RDBMS. ArchIS’ architecture uses (a) XML to support temporally grouped(virtual) representations of the database history, (b) XQuery to express powerful temporal queries on such views, (c) temporalclustering and indexing techniques for managing the actual historical data in a relational database, and (d) SQL/XML for executingthe queries on the XML views as equivalent queries on the relational database. The performance studies presented in the papershow that ArchIS is quite effective at storing and retrieving under complex query conditions the transaction-time historyof relational databases, and can also assure excellent storage efficiency by providing compression as an option. This approachachieves full-functionality transaction-time databases without requiring temporal extensions in XML or database standards,and provides critical support to emerging application areas such as RFID.

@article{wang08archis, abstract = {Abstract  Effective support for temporal applications by database systems represents an important technical objective that is difficultto achieve since it requires an integrated solution for several problems, including (i) expressive temporal representationsand data models, (ii) powerful languages for temporal queries and snapshot queries, (iii) indexing, clustering and query optimizationtechniques for managing temporal information efficiently, and (iv) architectures that bring together the different piecesof enabling technology into a robust system. In this paper, we present the ArchIS system that achieves these objectives bysupporting a temporally grouped data model on top of RDBMS. ArchIS’ architecture uses (a) XML to support temporally grouped(virtual) representations of the database history, (b) XQuery to express powerful temporal queries on such views, (c) temporalclustering and indexing techniques for managing the actual historical data in a relational database, and (d) SQL/XML for executingthe queries on the XML views as equivalent queries on the relational database. The performance studies presented in the papershow that ArchIS is quite effective at storing and retrieving under complex query conditions the transaction-time historyof relational databases, and can also assure excellent storage efficiency by providing compression as an option. This approachachieves full-functionality transaction-time databases without requiring temporal extensions in XML or database standards,and provides critical support to emerging application areas such as RFID.}, added-at = {2010-10-07T11:04:56.000+0200}, author = {Wang, Fusheng and Zaniolo, Carlo and Zhou, Xin}, biburl = {https://www.bibsonomy.org/bibtex/20349265befd83fd0da7b1505a9174456/msn}, description = {SpringerLink - Journal Article}, interhash = {eff39a0496da767ddabaac8637ecb89a}, intrahash = {0349265befd83fd0da7b1505a9174456}, journal = {The VLDB Journal}, keywords = {research.xml research.db research.conceptual.time}, month = {#nov#}, number = 6, pages = {1445--1463}, timestamp = {2010-10-07T11:04:56.000+0200}, title = {ArchIS: an XML-based approach to transaction-time temporal database systems}, url = {http://dx.doi.org/10.1007/s00778-007-0086-6}, volume = 17, year = 2008 }