article

Constraint Preserving Transformation from Relational Schema to XML Schema

Authors:

Millist W. Vincent,

Jixue LiuAuthors Info & Claims

World Wide Web, Volume 9, Issue 1

Pages 93 - 110

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

Published: 01 March 2006 Publication History

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.

References

[1]

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

Digital Library

[2]

{2} C. Baru, "XViews: XML Views of Relational Schemas." In Proceedings of DEXA Workshop, 1999, pp. 700-705.

[3]

{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]

{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]

{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]

{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]

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

[8]

{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.

Digital Library

[9]

{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]

{10} G. Kappel, E. Kapsammer, and W. Retschitzegger, "Integrating XML and Relational Database Systems." World Wide Web, 7(4), 2004, 343-384.

Digital Library

[11]

{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]

{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]

{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]

{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]

{15} V. Turau, "Making Legacy Data Accessible for XML Applications." http://www.informatik.fhwiesbaden.de/turau/DB2XML/2001/.

Cited By

Ma ZLi CYan L(2017)Reengineering Probabilistic Relational Databases with Fuzzy Probability Measures into XML ModelJournal of Database Management10.4018/JDM.201707010228:3(26-47)Online publication date: 1-Jul-2017
https://dl.acm.org/doi/10.4018/JDM.2017070102
Bai LYan LMa ZXu C(2015)Incorporating fuzziness in spatiotemporal XML and transforming fuzzy spatiotemporal data from XML to relational databasesApplied Intelligence10.1007/s10489-015-0677-743:4(707-721)Online publication date: 1-Dec-2015
https://dl.acm.org/doi/10.1007/s10489-015-0677-7
Szabó GBenczúr A(2015)Functional dependencies on extended relations defined by regular languagesAnnals of Mathematics and Artificial Intelligence10.1007/s10472-013-9352-z73:1-2(205-243)Online publication date: 1-Jan-2015
https://dl.acm.org/doi/10.1007/s10472-013-9352-z
Show More Cited By

Index Terms

Constraint Preserving Transformation from Relational Schema to XML Schema
1. Applied computing
  1. Document management and text processing
    1. Document preparation
2. Information systems
  1. Data management systems
    1. Database design and models
      1. Relational database model
    2. Query languages
      1. Relational database query languages
  2. World Wide Web
    1. Web applications
    2. Web services

Recommendations

Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents
DocEng '01: Proceedings of the 2001 ACM Symposium on Document engineering

Many organizations and enterprises establish distributed working environments, where different users need to exchange information based on a common model. XML is widely used to facilitate this information exchange. The extensibility of XML allows the ...
XML-based XML schema access
WWW '07: Proceedings of the 16th international conference on World Wide Web

XML Schema's abstract data model consists of components, which are the structures that eventually define a schema as a whole. XML Schema's XML syntax, on the other hand, is not a direct representation of the schema components, and it proves to be ...
XML Schema Re-Engineering Using a Conceptual Schema Approach
ITCC '05: Proceedings of the International Conference on Information Technology: Coding and Computing (ITCC'05) - Volume I - Volume 01

At present, the eXtensible Markup Language (XML) is popular for both data presentation and data transfer activities. XML Documents follow XML Schemas. It is possible to use them as database schemas and databases. An XML Schema can be hierarchical or ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image World Wide Web

World Wide Web Volume 9, Issue 1

March 2006

104 pages

ISSN:1386-145X

Issue’s Table of Contents

Copyright © Copyright © 2006 Springer Science + Business Media, Inc.

Publisher

Kluwer Academic Publishers

United States

Publication History

Published: 01 March 2006

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

12
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 01 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Ma ZLi CYan L(2017)Reengineering Probabilistic Relational Databases with Fuzzy Probability Measures into XML ModelJournal of Database Management10.4018/JDM.201707010228:3(26-47)Online publication date: 1-Jul-2017
https://dl.acm.org/doi/10.4018/JDM.2017070102
Bai LYan LMa ZXu C(2015)Incorporating fuzziness in spatiotemporal XML and transforming fuzzy spatiotemporal data from XML to relational databasesApplied Intelligence10.1007/s10489-015-0677-743:4(707-721)Online publication date: 1-Dec-2015
https://dl.acm.org/doi/10.1007/s10489-015-0677-7
Szabó GBenczúr A(2015)Functional dependencies on extended relations defined by regular languagesAnnals of Mathematics and Artificial Intelligence10.1007/s10472-013-9352-z73:1-2(205-243)Online publication date: 1-Jan-2015
https://dl.acm.org/doi/10.1007/s10472-013-9352-z
Smith KSeligman LRosenthal AKurcz CGreer MMacheret CSexton MEckstein A(2014)"Big Metadata"Proceedings of Workshop on Data analytics in the Cloud10.1145/2627770.2627776(1-4)Online publication date: 22-Jun-2014
https://dl.acm.org/doi/10.1145/2627770.2627776
Franceschet MGubiani DMontanari APiazza C(2013)A graph-theoretic approach to map conceptual designs to XML schemasACM Transactions on Database Systems10.1145/2445583.244558938:1(1-44)Online publication date: 26-Apr-2013
https://dl.acm.org/doi/10.1145/2445583.2445589
Ning BLiu CYu J(2013)Efficient processing of top-k twig queries over probabilistic XML dataWorld Wide Web10.1007/s11280-011-0144-216:3(299-323)Online publication date: 1-May-2013
https://dl.acm.org/doi/10.1007/s11280-011-0144-2
Liu JMa Z(2013)Formal transformation from fuzzy object-oriented databases to fuzzy XMLApplied Intelligence10.1007/s10489-013-0438-439:3(630-641)Online publication date: 1-Oct-2013
https://dl.acm.org/doi/10.1007/s10489-013-0438-4
Huang HLiu CZhou X(2012)Approximating query answering on RDF databasesWorld Wide Web10.1007/s11280-011-0131-715:1(89-114)Online publication date: 1-Jan-2012
https://dl.acm.org/doi/10.1007/s11280-011-0131-7
Ahmad K(2011)A comparative analysis of managing XML data in relational databaseProceedings of the Third international conference on Intelligent information and database systems - Volume Part I10.5555/1997166.1997178(100-108)Online publication date: 20-Apr-2011
https://dl.acm.org/doi/10.5555/1997166.1997178
Zhou RLiu CLi J(2008)Holistic constraint-preserving transformation from relational schema into XML schemaProceedings of the 13th international conference on Database systems for advanced applications10.5555/1802514.1802520(4-18)Online publication date: 19-Mar-2008
https://dl.acm.org/doi/10.5555/1802514.1802520
Show More Cited By

View Options

View options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents