Bridging relational database history and the web: the XML approach

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 ...

• Type: Conference
• Year: 2006
• Where: WIDM
• Authors: Fusheng Wang, Xin Zhou, Carlo Zaniolo
• Keywords: Relational Tables, Temporal Database, WIDM 2006, flat Relational Tables