Advertisement

X-Ray - Towards Integrating XML and Relational Database Systems

  • Gerti Kappel
  • Elisabeth Kapsammer
  • Stefan Rausch- Schott
  • Werner Retschitzegger
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1920)

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.

Keywords

Element Type Base Relation Relational Schema Mapping Knowledge Document Type Definition 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, 2000Google Scholar
  2. 2.
    Bourret, R.: XML and Databases. Technical University of Darmstadt, http://www.informatik.tudarmstadt.de/DVS1/staff/bourret/xml/XMLAndDatabases.htm, June, 2000
  3. 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, 2000Google Scholar
  4. 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 1996Google Scholar
  5. 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, 2000Google Scholar
  6. 6.
    Ceri, S., Fraternali, P., Paraboschi, S.: Design Principles for Data-Intensive Web SitesACM SIGMOD Record, Vol. 24, No. 1, March, 1999Google Scholar
  7. 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, 2000Google Scholar
  8. 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., 1999Google Scholar
  9. 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, 1997Google Scholar
  10. 10.
    Fernandez, M., Tan, W-C., Suciu, D.: SilkRoute: Trading between Relations and XML9th Int. World Wide Web Conf. (WWW), Amsterdam, May, 2000Google Scholar
  11. 11.
    Florescu, D., Levy, A., Mendelzon, A.: Database Techniques for the World Wide Web: A SurveyACM SIGMOD Record, Vol. 27, No. 3, September, 1998Google Scholar
  12. 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, 1999Google Scholar
  13. 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., 1999Google Scholar
  14. 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, 1999Google Scholar
  15. 15.
    Kanne, C.-C., Moerkotte, G.: Efficient Storage of XML Data. Proc. Of the 16th Int. Conf. On Data Engineering (ICDE), San Diego, March, 2000Google Scholar
  16. 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, 1994Google Scholar
  17. 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. 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, 2000Google Scholar
  19. 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. 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, 1999Google Scholar
  21. 21.
    Raumbaugh, J., Jacobson, I., Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, 1999Google Scholar
  22. 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, 2000Google Scholar
  23. 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, 2000Google Scholar
  24. 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, 1999Google Scholar
  25. 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, 1993Google Scholar
  26. 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 2000Google Scholar
  27. 27.
    Widom, J.: Data Management for XML-Research Directions. IEEE Data Engineering Bulletin, Special Issue on XML, Vol. 22, No. 3, September, 1999Google Scholar
  28. 28.
    W3C-World-Wide-Web Consortium. http://www.w3.org, 2000
  29. 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., 1999Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Gerti Kappel
    • 1
  • Elisabeth Kapsammer
    • 1
  • Stefan Rausch- Schott
    • 1
  • Werner Retschitzegger
    • 1
  1. 1.Institute of Applied Computer Science, Department of Information Systems (IFS)University of LinzLinzAustria

Personalised recommendations