Storing XML documents in databases using existing object-relational features

  • Authors:
  • Dušan Petković

  • Affiliations:
  • University of Applied Sciences, Rosenheim, Germany

  • Venue:
  • Proceedings of the Fifth Balkan Conference in Informatics
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

One of main research areas concerning XML documents is how to store them. Researchers usually suggest the use of relational databases for this task. However, object-relational databases with their extended data model are better for this purpose, because the "flat" relational model is not ideal for mapping of hierarchic structure of XML. Several papers have been published, which describe how structures and constraints of XML documents can be mapped to object-relational databases (ORDBs). However, their results cannot be applied in practice, because the available technology is usually not aware of object-oriented concepts, which are used. In this paper we propose mapping rules that are practicable for existing ORDBMSs in general. Specifically, we analyze object-oriented concepts implemented in an existing ORDBMS (DB2) and show how XML Schema parts can be mapped to them. We also perform a case study to illustrate mappings according to our rules. Although the paper discusses the use of XML Schema instances as metadata, existing DTD instances can also be used, because they can be easily transformed to corresponding XML Schema documents. To our knowledge this is the first such proposition for the database system mentioned above.