On transformation to redundancy free XML schema from relational database schema

  • Authors:

  • Chengfei Liu;Jixue Liu;Minyi Guo

  • Affiliations:

  • Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, Australia;Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, Australia;Department of Computer Software, The University of Aizu, Aizu-Wakamatsu City, Fukushima, Japan

  • Venue:
  • APWeb'03 Proceedings of the 5th Asia-Pacific web conference on Web technologies and applications
  • Year:
  • 2003

Quantified Score

Hi-index 0.00

Visualization

Abstract

While XML is emerging as the universal format for publishing and exchanging data on the Web, most business data is still stored and maintained in relational database management systems. As a result, there is an increasing need to efficiently 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, then users can access the relational database through the XML schema. In this paper, we discuss issues in transforming a relational database schema into corresponding schema in XML Schema. We aim to achieve high level of nesting while introducing no data redundancy for 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.