Skip to main content
SpringerLink
Log in

X-Ray - Towards Integrating XML and Relational Database Systems

  • Conference paper
  • First Online:
Conceptual Modeling — ER 2000 (ER 2000)

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

Included in the following conference series:

Abstract

Relational databases get more and more employed in order to store the content of a web site. At the same time, XML is fast emerging as the dominant standard at the hypertext level of web site management describing pages and links between them. Thus, the integration of XML with relational database systems to enable the storage, retrieval and update of XML documents is of major importance. This paper presents X-Ray, a generic approach for integrating XML with relational database systems. The key idea is that mappings may be defined between XML DTDs and relational schemata while preserving their autonomy. This is made possible by introducing a meta schema and meta knowledge for resolving data model heterogeneity and schema heterogeneity. Since the mapping knowledge is not hard-coded but rather reified within the meta schema, maintainability and changeability is enhanced. The meta schema provides the basis for X-Ray to automatically compose XML documents out of the relational database when requested and decompose them when they have to be stored.

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 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.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.

References

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

    Google Scholar 

  2. Bourret, R.: XML and Databases. Technical University of Darmstadt, http://www.informatik.tudarmstadt.de/DVS1/staff/bourret/xml/XMLAndDatabases.htm, June, 2000

  3. Bourret, R., Bornhövd, C., Buchmann, A.P.: A Generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases2nd Int. Workshop on Advanced Issues of EC and Web-based Information Systems (WECWIS), San Jose, California, June, 2000

    Google Scholar 

  4. Böhm, K., Aberer, K.: HyperStorM-Administering Structured Documents Using Object-Oriented Database TechnologyProc. of the ACM SIGMOD Int. Conf. on Management of Data, Montreal, Canada, June 1996

    Google Scholar 

  5. Carey, M., Florescu, D., Ives, Z., Lu, Y., Shanmugasundaram, J., Shekita, E., Subramanian, S.: XPERANTO: Publishing Object-Relational Data as XMLInt. Workshop on the Web and Databases (WebDB), Dallas, May, 2000

    Google Scholar 

  6. Ceri, S., Fraternali, P., Paraboschi, S.: Design Principles for Data-Intensive Web SitesACM SIGMOD Record, Vol. 24, No. 1, March, 1999

    Google Scholar 

  7. Ceri, S., Fraternali, P., Paraboschi, S.: XML: Current Developments and Future Challenges for the Database CommunityProc. of the 7th Int. Conf. on Extending Database Technology (EDBT), Springer, LNCS 1777, Konstanz, March, 2000

    Google Scholar 

  8. Deutsch,_A., Fernandez,_M., Suciu,_D.: Storing Semistructured Data in RelationsWorkshop on Query Processing for Semistructured Data and Non-Standard Data Formats, Jerusalem, Jan., 1999

    Google Scholar 

  9. Ehmayer, G., Kappel, G., Reich, S.: Connecting Databases to the Web-A Taxonomy of GatewaysProc. of the 8th Int. Conf. on Database and Expert Systems Applications (DEXA), Springer LNCS 1308, Toulouse, September, 1997

    Google Scholar 

  10. Fernandez, M., Tan, W-C., Suciu, D.: SilkRoute: Trading between Relations and XML9th Int. World Wide Web Conf. (WWW), Amsterdam, May, 2000

    Google Scholar 

  11. Florescu, D., Levy, A., Mendelzon, A.: Database Techniques for the World Wide Web: A SurveyACM SIGMOD Record, Vol. 27, No. 3, September, 1998

    Google Scholar 

  12. Florescu, D., Kossmann, D.: Storing and Querying XML Data Using an RDBMSIEEE Data Engineering Bulletin, Special Issue on XML, Vol. 22, No. 3, September, 1999

    Google Scholar 

  13. Gardarin, G., Sha, F., Dang-Ngoc, T.-T.: XML-based Components for Federating Multiple Heterogeneous Data SourcesProc. of the 18th Int. Conf. on Conceptual Modeling (ER), Paris, Nov., 1999

    Google Scholar 

  14. Goldman, R., McHugh, J., Widom, J.: From Semistructured Data to XML: Migrating the Lore Data Model and Query LanguageProc. of the 2nd Int. Workshop on the Web and Databases (WebDB), Philadelphia, June, 1999

    Google Scholar 

  15. Kanne, C.-C., Moerkotte, G.: Efficient Storage of XML Data. Proc. Of the 16th Int. Conf. On Data Engineering (ICDE), San Diego, March, 2000

    Google Scholar 

  16. Kappel, G., Preishuber, S., Pröll, E., Rausch-Schott, S., Retschitzegger, W., Wagner, R.R., Gierlinger, Ch.: COMan-Coexistence of Object-Oriented and Relational Technology. Proc. of the 13th Int.Conf. on the Entity-Relationship Approach (ER), Manchester, December, 1994

    Google Scholar 

  17. Kappel, G., Kapsammer, E., Retschitzegger, W.: X-Ray-Towards Integrating XML and Relational Database Systems. Technical Report, Department of Information Systems (IFS), JKU Linz, http://www.ifs.uni-linz.ac.at/ifs/research/publications/papers00.html, July, 2000

  18. Klettke, M., Meyer, H.: XML and Object-Relational Database Systems-Enhancing StructuralMappings Based on Statistics. Int. Workshop on the Web and Databases (WebDB), Dallas, May, 2000

    Google Scholar 

  19. Object Design, Inc.: An XML Data Server for Building Enterprise Web Applications. http://www.odi.com/excelon/XMLResource/build_ent_web_apps.pdf, 1999

  20. Pröll, B., Sighart, H., Retschitzegger, W., Starck, H.: Ready for Prime Time-Pre-Generation of Web Pages in TIScover. Proc. of the 8th Int. ACM Conference on Information and Knowledge Management (CIKM), Kansas City, Missouri, November, 1999

    Google Scholar 

  21. Raumbaugh, J., Jacobson, I., Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, 1999

    Google Scholar 

  22. Schmidt, A. R., Kersten, M. L., Windhouwer, M. A., Waas, F.: Efficient Relational Storage and Retrieval of XML Documents. Workshop on the Web and Databases (WebDB), Dallas, May, 2000

    Google Scholar 

  23. Schöning, H., WÄsch, J.: Tamino-An Internet Database System. Proc. of the 7th Int. Conf. on Extending Database Technology (EDBT), Springer, LNCS 1777, Konstanz, March, 2000

    Google Scholar 

  24. Shanmugasundaram, J., et al.: Relational Databases for Querying XML Documents: Limitations and Opportunities. Proc. of the 25th Int. Conf. On Very Large Data Bases (VLDB), Edinburgh, 1999

    Google Scholar 

  25. Shoens, K., et al.: The Rufus system: Information organization for semi-structured data. Proc. of the Int. Conf. On Very Large Data Bases (VLDB), Dublin, Ireland, 1993

    Google Scholar 

  26. Surjanto, B., Ritter, N., Loeser, H.: XML Content Management based on Object-Relational Database Technology. Proc. Of the 1st Int. Conf. On Web Information Systems Engineering (WISE), Hongkong, June 2000

    Google Scholar 

  27. Widom, J.: Data Management for XML-Research Directions. IEEE Data Engineering Bulletin, Special Issue on XML, Vol. 22, No. 3, September, 1999

    Google Scholar 

  28. W3C-World-Wide-Web Consortium. http://www.w3.org, 2000

  29. VanZwol, R., Apers, P., Wilschutz, A.: Implementing Semi Structured Data with Moa. Workshop on Query Processing for Semistructured Data and Non-Standard Data Formats, Jerusalem, Jan., 1999

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Applied Computer Science, Department of Information Systems (IFS), University of Linz, Altenbergerstra\e 69, A-4040, Linz, Austria

    Gerti Kappel, Elisabeth Kapsammer, Stefan Rausch- Schott & Werner Retschitzegger

Authors
  1. Gerti Kappel
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Elisabeth Kapsammer
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Stefan Rausch- Schott
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Werner Retschitzegger
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Departamento de Ciência da Computação, Universidade Federal de Minas Gerais, 31270-010, Belo Horizonte - MG, Brasil

    Alberto H. F. Laender

  2. Marriott School School of Accountancy and Information Systems, Brigham Young University, 585 TNRB, P.O. Box 23087, UT 84602-3087, Provo, USA

    Stephen W. Liddle

  3. Department of Computer Information Systems, Georgia State University, College of Business Administration, 30302-4015, Atlanta, Georgia, USA

    Veda C. Storey

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kappel, G., Kapsammer, E., Schott, S.R., Retschitzegger, W. (2000). X-Ray - Towards Integrating XML and Relational Database Systems. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds) Conceptual Modeling — ER 2000. ER 2000. Lecture Notes in Computer Science, vol 1920. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45393-8_25

Download citation

  • DOI: https://doi.org/10.1007/3-540-45393-8_25

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-41072-0

  • Online ISBN: 978-3-540-45393-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation