Formal semantics and pragmatics for natural language querying
Formal semantics and pragmatics for natural language querying
On completeness of historical relational query languages
ACM Transactions on Database Systems (TODS)
Advanced database systems
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
Querying ATSQL databases with temporal logic
ACM Transactions on Database Systems (TODS)
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
DNIS '02 Proceedings of the Second International Workshop on Databases in Networked Information Systems
Transaction Timestamping in (Temporal) Databases
Proceedings of the 27th International Conference on Very Large Data Bases
Coalescing in Temporal Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
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
ACM Transactions on Database Systems (TODS)
XTABLES: Bridging relational technology and XML
IBM Systems Journal
Transaction Time Support Inside a Database Engine
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
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
s-XML: An efficient mapping scheme to bridge XML and relational database
Knowledge-Based Systems
Hi-index | 0.00 |
The preservation of digital artifacts represents an unanswered challenge for the modern information society: XML and its query languages provide an effective environment to address this challenge because of their ability to support temporal information and queries, and make it easy to publish database history to the Web. In this paper, we focus on the problem of preserving, publishing, and querying efficiently the history of a relational database. Past research on temporal databases revealed the difficulty of achieving satisfactory solutions using flat relational tables and SQL. Here we show that the problem can be solved using (a) XML to support temporally grouped representations of the database history, and (b) XQuery to express powerful temporal queries on such representations. Furthermore, the approach is quite general and it can be used to preserve and query the history of multi-version XML documents. Then we turn to the problem of efficient implementation, and we investigate alternative approaches, including (i) XML DBMS, (ii) shredding XML into relational tables and using SQL/XML on these tables, (iii) SQL:2003 nested tables, and iv) OR-DBMS extended with XML support. These experiments suggest that a combination of temporal XML views and physical relational tables provides the best approach for managing temporal database information.