On the semantics of “now” in databases
ACM Transactions on Database Systems (TODS)
Advanced database systems
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
Managing historical semistructured data
Theory and Practice of Object Systems
XMill: an efficient compressor for XML data
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
SilkRoute: trading between relations and XML
Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
Querying ATSQL databases with temporal logic
ACM Transactions on Database Systems (TODS)
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
A Formal Temporal Object-Oriented Data Model
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
Generalized Version Control in an Object-Oriented Database
Proceedings of the Fourth International Conference on Data Engineering
Tamino - A DBMS designed for XML
Proceedings of the 17th International Conference on Data Engineering
A Unifying Framework for Version Control in a CAD Environment
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Efficiently Publishing Relational Data as XML Documents
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Efficient schemes for managing multiversionXML documents
The VLDB Journal — The International Journal on Very Large Data Bases
Realizing Temporal XML Repositories Using Temporal Relational Databases (Poster)
CODAS '01 Proceedings of the Third International Symposium on Cooperative Database Systems for Advanced Applications
Observing Transaction-Time Semantics with TTXPath
WISE '01 Proceedings of the Second International Conference on Web Information Systems Engineering (WISE'01) Volume 1 - Volume 1
Publishing and Querying the Histories of Archived Relational Databases in XML
WISE '03 Proceedings of the Fourth International Conference on Web Information Systems Engineering
XTABLES: Bridging relational technology and XML
IBM Systems Journal
Temporal slicing in the evaluation of XML queries
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
ArchIS: an XML-based approach to transaction-time temporal database systems
The VLDB Journal — The International Journal on Very Large Data Bases
Data & Knowledge Engineering
Managing the History of Metadata in Support for DB Archiving and Schema Evolution
ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
The chronon based model for temporal databases
DASFAA'08 Proceedings of the 13th international conference on Database systems for advanced applications
Prefix-based node numbering for temporal XML
WISE'11 Proceedings of the 12th international conference on Web information system engineering
Reuse or never reuse the deleted labels in XML query processing based on labeling schemes
DASFAA'06 Proceedings of the 11th international conference on Database Systems for Advanced Applications
Hi-index | 0.00 |
There is much current interest in publishing and viewing databases as XML documents. The general benefits of this approach follow from the popularity of XML and the tool set available for visualizing and processing information encoded in this universal standard. In this paper, we explore the additional and unique benefits achieved by this approach on temporal database applications. We show that XML with XQuery can provide surprisingly effective solutions to the problem of supporting historical queries on past content of database relations and their evolution. Indeed, using XML, the histories of database relations can be naturally represented by temporally grouped data models. Thus, we identify mappings from relations to XML that are most conducive to modeling and querying database histories, and show that temporal queries that would be difficult to express in SQL can be easily expressed in standard XQuery. This approach is very general, insofar as it can be used to store the version history of arbitrary documents and, for relational databases, it also supports queries on the evolution of their schema.Then, we turn to the problem of supporting efficiently the storage and the querying of relational table histories. We present an experimental study of the pros and cons of using native XML databases, versus using traditional databases, where the XML-represented histories are supported as views on the historical tables.