Skip to main content
SpringerLink
Log in

Efficiently Mapping Integrity Constraints from Relational Database to XML Document1

  • Conference paper
  • First Online:
Advances in Databases and Information Systems (ADBIS 2001)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2151))

Abstract

XML is rapidly emerging as the dominant standard for exchanging data on the WWW. Most of application data are stored in relational databases due to its popularity and rich development experiences over it. Therefore, how to provide a proper mapping approach from relational data to XML documents becomes an important topic. Integrity constraints are useful for semantic specification that plays the important roles in relation schema definition. The existing XML schema language does not define general constraints and maintaining method for integrity constraints. So how to use XML to express and maintain integrity constraints especially the advanced integrity constraints, e.g., general constraints of relational data is one of challenge research issues. In this paper, a novel mapping approach is proposed to map relation data to XML document with active nodes, XMLA, and extended DTD with constraints, DTDC. The ability to maintain integrity constraints makes our approach more effective than other approaches.

This work is partially supported by the Teaching and Research Award Program for Outstanding Young Teachers in Higher Education Institutions and the Cross Century Excellent Young Teacher Foundation of the Ministry of Education of China, the Natural Science Foundation (69803004) of China.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Reference

  1. Bray, T., Paoli, J., Sperberg-McQueen, CM., and Maler, E.: Extensible Markup Language (XML) 1.0 (Second Edition). W3C recommendation REC-xml-20001006 (2001) http://www.w3.org/TR/2000/REC-xml-20001006

  2. Biron, P.V. and Malhotra, A.: XML schema part 1: Structure. W3C Working Draft (1999) http://www.w3.org/TR/xmlschema-2/

  3. Abiteboul, S. and Vianu, V.: Rugular Path Queryies with Constraints. In Proc. 16th ACM Symp. on Principles of Database Systems (1997) 51–61

    Google Scholar 

  4. Labrinidis, A. and Roussopoulos, N.: WebView Materialization. In Proc. of the ACM SIGMOD Intl. Conf. on Management of Data. Dallas, Texas (2000)14–19

    Google Scholar 

  5. Challenger, J., Iyengar, A., and Dantzig, P.: A Scalable System for Consistently Caching dynamic Web Data. In Proc. of INFOCOM’99 (1999)

    Google Scholar 

  6. Calvanese, D., Giacomo, G.D., and Lenzerini, M.: What is View-Based Query Rewriting? In Proc. of the 7th Intl. Workshop on Knowledge Representation Meets Databases (2000) 17–27

    Google Scholar 

  7. Papakonstantinou, Y. and Vassalos, V.: Query Rewriting for Semistructured Data. In Proc. of ACM SIGMOD Intl. Conf. on Management of Data (1999) 455–66

    Google Scholar 

  8. Cluet, S., Delobel, C, Simeon, J., and Smaga, K.: Your Mediators Need Data Conversion! Proc. of ACM SIGMOD Conf. on Management of Data. Seattle, U.S.A. SIGMOD Record, Vol. 27(2). Association for Computing Machinery, Inc., New York (1998)177–188

    Chapter  Google Scholar 

  9. Ullman, J.D.: Information Integration Using Logical Views. In Proc. of the 6th Intl. Conf. on Database Theory. Lecture Nodes in Computer Science, Vol. 1186. Springer-Verlag, Berlin Heidelberg New York (1997) 19–40

    Google Scholar 

  10. Christophides, V., Cluet, S., and Siméon, J.: On Wrapping Query Languages and Efficient XML Integration. Proc. of ACM SIGMOD Conf. on Management of Data. Dallas, U.S.A. In: W. Chen, J. Naughton and P. Bernstein(eds.): SIGMOD Record, Vol. 29(2). Association for Computing Machinery, Inc., New York (2000) 141–152

    Chapter  Google Scholar 

  11. Thompson, H.S., Beech, D., Maloney, M., Mendelsohn N. (ed.): XML Schema Part 1: Structures. W3C (2000) http://www.w3.org/TR/xmlschema-1

  12. Carey, M., Lindsay, B., Pirahesh, H., and Reinwald, B.: Efficiently Publishing Relational Data as XML Documents. Proc. of 26th VLDB. Morgan Kaufmann, Cairo, Egypt (2000) 65–76

    Google Scholar 

  13. Buneman, P., Fan, W., Weinstein, S.: Interaction between Path and Type Constraints. Proc. of ACM Symposium on Principles of Database Systems. ACM Press. Philadelphia, U.S. A (1999) 56–67

    Google Scholar 

  14. Fan, W. and Siméon, J.: Integrity Constraints for XML. Proc. of ACM Symposium on Principles of Database Systems. ACM Press. Dallas, Texas (2000)

    Google Scholar 

  15. Yang, X. and Wang, G.: Mapping Referential Integrity Constraints from Relational Databases to XML. Proc. of 2nd Intl. Web-Age Information Management. In: Lu, H. and Yu, G. (eds.) Lecture Nodes of Computer Science, Springer-Verlag, Xi’an, China (2001)

    Google Scholar 

  16. Lee, D. and Chun, W. Comparative Analysis of Six XML Schema Languages. SIGMOD Record. Vol. 29(3). Association for Computing Machinery, Inc., New York (2000) 76–87

    Google Scholar 

  17. Ramarkrishnan, R and Gehrke, H.: Database Management Systems (Second Edition). McGraw-Hill. New York, 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science & Engineering, Northeastern University, Shenyang, 110004, P.R. China

    Xiaochun Yang, Ge Yu & Guoren Wang

Authors
  1. Xiaochun Yang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ge Yu
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Guoren Wang
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Mathematics and Informatics, Akademijos st. 4, 2600, Vilnius, Lithuania

    Albertas Caplinskas

  2. Department of Informatics Systems, University of Klagenfurt, Universitätsstr. 65, 9020, Klagenfurt, Austria

    Johann Eder

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Yang, X., Yu, G., Wang, G. (2001). Efficiently Mapping Integrity Constraints from Relational Database to XML Document1. In: Caplinskas, A., Eder, J. (eds) Advances in Databases and Information Systems. ADBIS 2001. Lecture Notes in Computer Science, vol 2151. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44803-9_26

Download citation

  • DOI: https://doi.org/10.1007/3-540-44803-9_26

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42555-7

  • Online ISBN: 978-3-540-44803-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation