Updating XML using object-relational database

  • Authors:
  • Pensri Amornsinlaphachai;M. Akhtar Ali;Nick Rossiter

  • Affiliations:
  • University of Northumbria at Newcastle, UK;University of Northumbria at Newcastle, UK;University of Northumbria at Newcastle, UK

  • Venue:
  • BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Presently, the area of updating XML is immature since XQuery has not provided update features. Thus this area has not been investigated as fully as it should have been. Moreover existing researches focus on updating native XML database so that everything must be created from scratch. Furthermore, an XML document is often treated as a database by keeping all data in one document, leading invariably to data redundancy. Such redundancy in XML documents can lead to data inconsistency and low performance when updates are performed. Therefore, we exploit the power of traditional database systems, which are fully developed to update XML documents. We present a mechanism to link non-redundant data kept in multiple XML documents. The data is held in an object-relational database (ORDB) and an update language is proposed, an extension to XQuery, which is translated into SQL for updating XML data stored in an ORDB. Finally, we present a technique to propagate the changes in an ORDB to XML documents.