Skip to main content
SpringerLink
Log in
Book cover

International Conference on Web-Age Information Management

WAIM 2001: Advances in Web-Age Information Management pp 329–340Cite as

Mapping Referential Integrity Constraints from Relational Databases to XML

  • Conference paper
  • First Online:

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

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. Referential integrity constraints are useful for semantic specification that plays the important roles in relation schema definition. So far, there are about a dozen of XML schema languages have been proposed. Although most languages are based on DTD, they have different grammar resulting in the XML world more complicated. In this paper, we investigate referential integrity constraints for XML. An extended DTD with several kinds of constraints-DTDc is proposed, and a corresponding equivalent mapping approach, ICMAP is presented. Finally, the comparison on the respect of constraint representation capability is performed, which proves that ICMAP is more effective than other known 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.

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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bray, T., Paoli, J., Sperberg-McQueen, C.M (eds.).: Extensible Markup Language (XML) 1.0. W3C. (1998) http://www.w3.org/TR/REC-xml

  2. Abiteboul, S., Vianu, V.: Rugular Path Queryies with Constraints. Proc. of 16th ACM PODS. ACM Press, Tucson, Arizona(1997)51–61

    Google Scholar 

  3. Labrinidis, A., Roussopoulos, N.: Web View Materialization. Proceedings ACM SIGMOD Int. Conference on Management of Data. ACM Press, Dallas, Texas(2000)14–19

    Google Scholar 

  4. Papakonstantinou, Y., Vassalos, V.: Query Rewriting for Semistructured Data. Proceedings ACM SIGMOD Int. Conference on Management of Data. ACM Press, Philadephia(1999)455–466

    Google Scholar 

  5. Cluet, S., Delobel, C, Siméon, J., Smaga, K.: Your Mediators Need Data Conversion!. SIGMOD Record Vol. 27(2). Association for Computing Machinery, Inc., New York (1998)177–188

    Google Scholar 

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

  7. Microsoft.: XML Schema Developer’s Guide. Internet Document. (2000) http://msdn.micro soft.com/xml/XMLGuide/schema-overview.asp

  8. Davidson, A., Fuchs, M., Hedin, M., et al: Schema for Object-Oriented XML 2.0. W3C. (1999) http://www.w3.org/TR/NOTE-SOX

  9. Jelliffe, R.: Scematron. Internet Document. (2000) http://www.ascc.net/xml/resource/schematron/

  10. Klarlund, N., Moller, A., Schwatzbach, M.I.: DSD: A Schema Language for XML. Proc. of 3rd ACM Workshop on Formal Methods in Software Practice(2000)

    Google Scholar 

  11. Lee, D., Chu. 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 

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

    Chapter  Google Scholar 

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

    Google Scholar 

  14. Fan, W., Siméon, J.: Integrity Constraints for XML. Proc. of 19th ACM PODS. ACM Press, Dallas, Texas (2000)23–34

    Google Scholar 

  15. Buneman, P., Fan, W., Weinstein, S.: Path Constraints on Semistructured and Structured Data. Proc. of 17th ACM PODS. ACM Press, Seattle, Washington(1998)129–138

    Google Scholar 

  16. Fernández, M., Tan, W.C., Suciu D.: SilkRoute: Trading between Relations and XML. Proc. of 9th Int. Conf. on World Wide Web. (2000)

    Google Scholar 

  17. Yang, X., Wang, G., Yu, G., Wang, D.: Study on Information Cooperation in Virtual Enterprise Information Systems. Proc. of 3rd CODAS. IEEE Computer Society Press. Beijing, China(2001)

    Google Scholar 

  18. Yang, X., Wang, G., Yu, G.: Mapping General Constraints from Relational Database to XML. Technique Report of Northeastern University, TR-CS-2001-02(2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

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

    Xiaochun Yang & Guoren Wang

Authors
  1. Xiaochun Yang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Guoren Wang
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Information and Software Engineering, George Mason University, Fairfax, VA, 22030-4444, USA

    X. Sean Wang

  2. Department of Computer Science and Engineering, Northeastern University, Shenyang, 110004, China

    Ge Yu

  3. Department of Computer Science, Hong Kong University of Science and Technology, Clear Water Bay, Kowloon, Hong Kong, China

    Hongjun Lu

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Yang, X., Wang, G. (2001). Mapping Referential Integrity Constraints from Relational Databases to XML. In: Wang, X.S., Yu, G., Lu, H. (eds) Advances in Web-Age Information Management. WAIM 2001. Lecture Notes in Computer Science, vol 2118. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-47714-4_30

Download citation

  • DOI: https://doi.org/10.1007/3-540-47714-4_30

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42298-3

  • Online ISBN: 978-3-540-47714-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation