Integrating XML and Relational Database Systems

  • Authors:

  • Gerti Kappel;Elisabeth Kapsammer;Werner Retschitzegger

  • Affiliations:

  • Institute of Software Technology and Interactive Systems, Business Informatics Group (BIG), Vienna University of Technology, Favoritenstraße 9-11/188, A-1040 Wien, Austria gerti@big.t ...;Institute of Applied Computer Science, Department of Information Systems (IFS), University of Linz, Altenbergerstraße 69, A-4040 Linz, Austria ek@ifs.uni-linz.ac.at;Institute of Applied Computer Science, Department of Information Systems (IFS), University of Linz, Altenbergerstraße 69, A-4040 Linz, Austria wr@ifs.uni-linz.ac.at

  • Venue:
  • World Wide Web
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

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. Data model heterogeneity and schema heterogeneity, however, make this a challenging task. In this respect, the contribution of this paper is threefold. First, a comparison of concepts available in XML schema specification languages and relational database systems is provided. Second, basic kinds of mappings between XML concepts and relational concepts are presented and reasonable mappings in terms of mapping patterns are determined. Third, design alternatives for integrating XML and relational database systems are examined and X-Ray, a generic approach for integrating XML with relational database systems is proposed. Finally, an in-depth evaluation of related approaches illustrates the current state of the art with respect to the design goals of X-Ray.