Preserving and Querying Histories of XML-Published Relational Databases [chapter]

Fusheng Wang, Carlo Zaniolo
2003 Lecture Notes in Computer Science  
There is much current interest in publishing and viewing database-resident data as XML documents. In fact, such XML views of the database can be easily visualized on web browsers and processed by web languages, including powerful query languages such as XQuery. As the database is updated, its external XML view also evolves. In this paper, we investigate the problem of representing the evolution history of such a view as yet another XML document, whereby the complete history of the database can
more » ... lso be visualized on web browsers, processed by web languages, and queried using powerful query languages such as XQuery. We investigate various approaches used for publishing relational data, and identify and select those which are best for representing and querying database histories. We show that the selected representations make it easy to formulate in XQuery temporal queries that are difficult to express using SQL on database relations. Finally, we discuss briefly the storage organization that can be used to support these queries efficiently.
doi:10.1007/978-3-540-45275-1_3 fatcat:qxx3yanhmfcxnfju4h4ui3uyxa