TY - CHAP
T1 - Preserving and querying histories of XML-published relational databases
AU - Wang, Fusheng
AU - Zaniolo, Carlo
PY - 2003
Y1 - 2003
N2 - 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 also 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.
AB - 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 also 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.
UR - https://www.scopus.com/pages/publications/0242276253
U2 - 10.1007/978-3-540-45275-1_3
DO - 10.1007/978-3-540-45275-1_3
M3 - Chapter
AN - SCOPUS:0242276253
SN - 3540202552
T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
SP - 26
EP - 38
BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
A2 - Genero, Marcela
A2 - Grandi, Fabio
A2 - van den Heuvel, Willem-Jan
A2 - Krogstie, John
A2 - Lyytinen, Kalle
A2 - Mayr , Heinrich C.
A2 - Nelson, Jim
A2 - Olivé, Antoni
A2 - Piattini, Mario
A2 - Poels, Geert
A2 - Roddick, John
A2 - Siau, Keng
A2 - Yoshikawa, Masatoshi
A2 - Yu, Eric S. K.
PB - Springer Verlag
ER -