Skip to main content
SpringerLink
Log in

Constraint Preserving Transformation from Relational Schema to XML Schema

  • Published:
World Wide Web Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. S. Abiteboul, P. Buneman, and D. Suciu, Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, 2000.

  2. C. Baru, “XViews: XML Views of Relational Schemas.” In Proceedings of DEXA Workshop, 1999, pp. 700–705.

  3. S. Boag, D. C. M. Fernandez, D. Florescu, J. Robie, J. Simeon, and M. Stefanescu, “XQuery 1.0: An XML Query Language.” W3C Working Draft, http://www.w3.org/TR/2002/WD-xquery-20020430/, 2002.

  4. T. Bray, J. Paoli, C. Sperberg-McQueen, and E. Maler, “Extensible Markup Language (XML) 1.0 (Second Edition).” W3C Recommendation, http://www.w3.org/TR/REC-xml. 2000.

  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, 2000, pp. 646–648.

  6. A. Deutsch, M. Fernandez, D. Florescu, A. Levy, and D. Suciu, “XML-QL: A Query Language for XML.” Submission to W3C, http://www.w3.org/TR/NOTE-xml-ql/. 1998.

  7. D. Fallside, “XML Schema Part 0: Primer.” W3C Recommendation, http://www.w3.org/TR/xmlschema-0/. 2001.

  8. M. Fernandez, Y. Kadiyska, D. Suciu, A. Morishima, and W. Tan, “SilkRoute: A Framework for Publishing Relational Data in XML.” ACM Trans. Database Syst., 27(4), 2002, 438–493.

    Google Scholar 

  9. Kappel, E. Kapsammer, S. Rausch-Schott, and W. Retschitzegger, “X-Ray - Towards Integrating XML and Relational Database Systems.” In Proceedings of the 19th ER Int. Conf. 2000.

  10. G. Kappel, E. Kapsammer, and W. Retschitzegger, “Integrating XML and Relational Database Systems.” World Wide Web, 7(4), 2004, 343–384.

  11. D. Lee, M. Mani, F. Chiu, and W. Chu, “Nesting-Based Relational-to-XML Schema Translation.” In Proceedings of the WebDB, 2001, pp. 61–66.

  12. C. Liu, M. Vincent, J. Liu, and M. Guo, “A Virtual XML Database Engine for Relational Databases.” In Proceedings of XSYM, 2003, pp. 37–51.

  13. J. Shanmugasundaram, J. Kiernan, E. Shekita, C. Fan, and J. Funderburk, “Querying XML Views of Relational Data.” In Proceedings of VLDB, 2001, pp. 261–270.

  14. J. Shanmugasundaram, E. Shekita, R. Barr, M. Carey, B. Lindsay, H. Pira-hesh, and B. Reinwald, “Efficiently Publishing Relational Data as XML Documents.” In Proceedings of VLDB, 2000, pp. 65–76.

  15. V. Turau, “Making Legacy Data Accessible for XML Applications.” http://www.informatik.fh-wiesbaden.de/turau/DB2XML/2001/.

Download references

Author information

Authors and Affiliations

  1. Centre for Internet Computing and E-Commerce, Faculty of Information and Communication Technologies, Swinburne University of Technology, Melbourne, VIC, 3122, Australia

    Chengfei Liu Dr.

  2. Advanced Computing Research Centre, School of Computer and Information Science, University of South Australia, Adelaide, SA, 5095, Australia

    Millist W. Vincent & Jixue Liu

Authors
  1. Chengfei Liu Dr.
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Millist W. Vincent
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jixue Liu
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Chengfei Liu Dr..

Rights and permissions

Reprints and permissions

About this article

Cite this article

Liu, C., Vincent, M.W. & Liu, J. Constraint Preserving Transformation from Relational Schema to XML Schema. World Wide Web 9, 93–110 (2006). https://doi.org/10.1007/s11280-005-4263-5

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11280-005-4263-5

Keywords

Search

Navigation