Clock: Synchronizing internal relational storage with external XML documents

X. Zhang, G. Mitchell, Wang-chien Lee, E. A. Rundensteiner

Research output: Contribution to conferencePaper

4 Scopus citations

Abstract

In many business settings, a relational database system (RDBMS) will serve as the storage manager for data from XML documents. In such a system, once the XML data is dissembled and loaded into the storage system, XML queries posed against the (virtual) XML documents are processed by translating them into SQL queries against the relational storage. However, for applications which frequently update their XML documents, we cannot afford to reload a complete, possibly large, document for each update, instead we must be able to incrementally propagate document updates to the stored XML data. In this paper, we address the issue of correctly reflecting updates of external XML documents into the loaded XML data in a relational database system. We describe Clock, a framework for synchronizing the relational storage with updated XML documents by exploiting a metadata-driven technology. First, we propose a set of (DTD preserving) update primitives for XML documents. Second, based on the mapping between XML and the relational model, we describe the propagation of those update primitives. Validation of the updates ensures they will not violate the constraints specified by the DTD. We have implemented a working prototype of the Clock system using the IBM's XML4J parser, JDBC 2 and Oracle 8I. We report on preliminary experiments conducted using this prototype to analyze our algorithms in a document update setting.

Original languageEnglish (US)
Pages111-118
Number of pages8
Publication statusPublished - Jan 1 2001
Event11th International Workshop on Research Issues in Data Engineering (RIDE 2001) - Heidelberg, Germany
Duration: Apr 1 2001Apr 2 2001

Other

Other11th International Workshop on Research Issues in Data Engineering (RIDE 2001)
CountryGermany
CityHeidelberg
Period4/1/014/2/01

    Fingerprint

All Science Journal Classification (ASJC) codes

  • Computer Science(all)

Cite this

Zhang, X., Mitchell, G., Lee, W., & Rundensteiner, E. A. (2001). Clock: Synchronizing internal relational storage with external XML documents. 111-118. Paper presented at 11th International Workshop on Research Issues in Data Engineering (RIDE 2001), Heidelberg, Germany.