Departmental Papers (CIS)

Date of this Version

September 2006

Document Type

Journal Article


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:


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.


Relational databases, updates, XML views



Date Posted: 13 February 2007

This document has been peer reviewed.