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.
Article PDF
Similar content being viewed by others
Avoid common mistakes on your manuscript.
References
S. Abiteboul, P. Buneman, and D. Suciu, Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, 2000.
C. Baru, “XViews: XML Views of Relational Schemas.” In Proceedings of DEXA Workshop, 1999, pp. 700–705.
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.
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.
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.
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.
D. Fallside, “XML Schema Part 0: Primer.” W3C Recommendation, http://www.w3.org/TR/xmlschema-0/. 2001.
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.
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.
G. Kappel, E. Kapsammer, and W. Retschitzegger, “Integrating XML and Relational Database Systems.” World Wide Web, 7(4), 2004, 343–384.
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.
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.
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.
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.
V. Turau, “Making Legacy Data Accessible for XML Applications.” http://www.informatik.fh-wiesbaden.de/turau/DB2XML/2001/.
Author information
Authors and Affiliations
Corresponding author
Rights 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
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11280-005-4263-5