IngentaConnect Constraint Preserving Transformation from Relational Schema to XM...

Authors: Liu, Chengfei¹; Vincent, Millist²; Liu, Jixue³

Source: World Wide Web, Volume 9, Number 1, March 2006 , pp. 93-110(18)

Publisher: Springer

Abstract:

XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately publish relational data as XML documents for Internet-based applications. One way to publish relational data is to provide virtual XML documents for relational data via an XML schema which is transformed from the underlying relational database schema such that users can access the relational database through the XML schema. In this paper, we discuss issues in transforming a relational database schema into the corresponding XML schema. We aim to preserve all integrity constraints defined in a relational database schema, to achieve high level of nesting and to avoid introducing data redundancy in the transformed XML schema. In the paper, we first propose a basic transformation algorithm which introduces no data redundancy, then we improve the algorithm by exploring further nesting of the transformed XML schema.

Keywords: schema transformation; XML; XML schema; relational databases

Document Type: Research article

DOI: 10.1007/s11280-005-4263-5

Affiliations: 1: Email: cliu@swin.edu.au 2: Email: millist.vincent@unisa.edu.au 3: Email: jixue.liu@unisa.edu.au

The full text electronic article is available for purchase. You will be able to download the full text electronic article after payment.

$47.00 plus tax Refund Policy

Constraint Preserving Transformation from Relational Schema to XML Schema