On Transformation to Redundancy Free XML Schema from Relational Database Schema

  • Chengfei Liu
  • Jixue Liu
  • Minyi Guo
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2642)


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.


Relational Database Relational Schema Nest Structure Data Redundancy Component Relation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    S. Abiteboul, P. Buneman, and D. Suciu. Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, 2000.Google Scholar
  2. 2.
    C. Baru. Xviews: Xml views of relational schemas. In Proceedings of DEXA Workshop, pages 700–705, 1999.Google Scholar
  3. 3.
    S. Boag, D. Chamberlin and M. Fernandez, D. Florescu, J. Robie, J. Simeon, and M. Stefanescu. XQuery 1.0: An XML Query Language, April 2002. W3C Working Draft,
  4. 4.
    T. Bray, J. Paoli, C. Sperberg-McQueen, and E. Maler. Extensible Markup Language (XML) 1.0 (Second Edition), October 2000. W3C Recommendation,
  5. 5.
    M. Carey, J. Kiernan, J. Shanmugasundaram, E. Shekita, and S. Subramanian. Xperanto: Middleware for publishing object-relational data as xml documents. In Proceedings of VLDB, pages 646–648, 2000.Google Scholar
  6. 6.
    A. Deutsch, M. Fernandez, D. Florescu, A. Levy, and D. Suciu. XML-QL: A Query Language for XML, August 1998. Submission to W3C,
  7. 7.
    D. Fallside. XML Schema Part 0: Primer, May 2001. W3C Recommendation,
  8. 8.
    M. Fernandez, W. Tan, and D. Suciu. Silkroute: Trading between relations and xml. In Proceedings of WWW, pages 723–725, 2000.Google Scholar
  9. 9.
    D. Lee, M. Mani, F. Chiu, and W. Chu. Nesting-based relational-to-xml schema translation. In Proceedings of the WebDB, pages 61–66, 2001.Google Scholar
  10. 10.
    C. Liu, M. Guo, and J. Liu. Accessing relational databases via xml schema. Technical report, School of Computer and Information Science, University of South Australia, December 2002.Google Scholar
  11. 11.
    J. Shanmugasundaram, J. Kiernan, E. Shekita, C. Fan, and J. Funderburk. Querying xml views of relational data. In Proceedings of VLDB, pages 261–270, 2001.Google Scholar
  12. 12.
    J. Shanmugasundaram, E. Shekita, R. Barr, M. Carey, B. Lindsay, H. Pirahesh, and B. Reinwald. Efficiently publishing relational data as xml documents. In Proceedings of VLDB, pages 65–76, 2000.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Chengfei Liu
    • 1
  • Jixue Liu
    • 1
  • Minyi Guo
    • 2
  1. 1.Advanced Computing Research Centre, School of Computer and Information ScienceUniversity of South AustraliaAustralia
  2. 2.Department of Computer SoftwareThe University of AizuAizu-Wakamatsu City, FukushimaJapan

Personalised recommendations