Clock: Synchronizing internal relational storage with external XML documents

X. Zhang, G. Mitchell, W. C. Lee, E. A. Rundensteiner

Research output: Contribution to conferencePaperpeer-review

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

All Science Journal Classification (ASJC) codes

  • Computer Science(all)

Fingerprint Dive into the research topics of 'Clock: Synchronizing internal relational storage with external XML documents'. Together they form a unique fingerprint.

Cite this