A middleware approach to storing and querying XML documents in relational databases

  • Authors:
  • Zülal Şevkli;Mine Mercan;Atakan Kurt

  • Affiliations:
  • Dept. of Computer Eng., Fatih University, Istanbul, Turkey;Dept. of Computer Eng., Fatih University, Istanbul, Turkey;Dept. of Computer Eng., Fatih University, Istanbul, Turkey

  • Venue:
  • ADVIS'04 Proceedings of the Third international conference on Advances in Information Systems
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper we present a middleware for storing and retrieving XML documents in relational databases. To store XML documents in RDBMS, several mapping approaches can be used. We chose structure independent approach. This approach stores XML documents in fixed-schema tables and does not require a direct extension of SQL. So the middleware can be used with any RDBMS with minor changes in the interface. The middleware offers two alternative methods -namely XRel and Edge- for storing XML in the database. The Edge method is a straightforward method, while XRel utilizes path summary information for faster query processing. We present a comparative experimental study on the performance of insertion and retrieval of two types of XML documents along with a set of XPath queries executed though the XPath query processor which is a part of the middleware.