Departmental Papers (CIS)

Document Type

Journal Article

Date of this Version

September 2006

Comments

Postprint version. Copyright ACM, 2006. The is the author's version of the work. It is posted here by permission of ACM for your personal use. Not for redistribution. The definitive version was published in ACM Transactions on Database Systems (TODS), Volume 31, Issue 3, September 2006, Pages: 839 - 886.
Publisher URL: http://doi.acm.org/10.1145/1166074.1166078

Abstract

XML has become an important medium for data exchange, and is frequently used as an interface to (i.e., a view of) a relational database. Although a lot of work has been done on querying relational databases through XML views, the problem of updating relational databases through XML views has not received much attention. In this work, we map XML views expressed using a subset of XQuery to a corresponding set of relational views. Thus, we transform the problem of updating relational databases through XML views into a classical problem of updating relational databases through relational views. We then show how updates on the XML view are mapped to updates on the corresponding relational views. Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates to the underlying relational database.

Keywords

Relational databases, updates, XML views

Share

COinS
 

Date Posted: 13 February 2007

This document has been peer reviewed.