Volume 8 Number 4 (Apr. 2013)
Home > Archive > 2013 > Volume 8 Number 4 (Apr. 2013) >
JSW 2013 Vol.8(4): 809-816 ISSN: 1796-217X
doi: 10.4304/jsw.8.4.809-816

XML Data Storage and Query Optimization in Relational Database by XPath Processing Model

Xiaojie Yuan, Xiangyu Hu, Dongxing Wu, Haiwei Zhang, Xin Lian
College of Information Technology and Science, Nankai University, Tianjin, China

AbstractXML is de facto new standard for data representation and exchanging on the web. Along with the growth of XML data, traditional relational databases support XML data processing across-the-board. Consistent storage and efficient query for XML data is the chief problem in XML supported relational databases. This work presents mechanisms of Storage and query optimization for XML data in relational database. XML data are treated as a kind of data type in relational database, and XML tables are used to store native XML data in fixed schema. Structural summary index is built and maintained in relational database and an optimizing mechanism based on XPath model named Compressed XML Query Tree will also be presented in order to improve efficiency of XML data query by reducing superabundant join operations from ancestordescendent axis. All strategies are appropriate for classical XML query algorithms. Algorithms for XML query will be performed in experiments on real XML datasets in relational database and query workloads to report the performance of our mechanism and show the efficiency compared with other mechanisms.

Index TermsXML, XPath, Data Storage, Query Optimization, Compressed XPath Query Tree.

[PDF]

Cite: Xiaojie Yuan, Xiangyu Hu, Dongxing Wu, Haiwei Zhang, Xin Lian, "XML Data Storage and Query Optimization in Relational Database by XPath Processing Model," Journal of Software vol. 8, no. 4, pp. 809-816, 2013.

General Information

ISSN: 1796-217X (Online)
Frequency: Monthly (2006-2019); Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Dec 06, 2019 News!

    Vol 14, No 1- Vol 14, No 4 has been indexed by EI (Inspec)   [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Jun 22, 2020 News!

    The papers published in Vol 15, No 5 have all received dois from Crossref    [Click]

  • Aug 01, 2018 News!

    [CFP] 2020 the annual meeting of JSW Editorial Board, ICCSM 2020, will be held in Rome, Italy, July 17-19, 2020   [Click]

  • Jun 22, 2020 News!

    Vol 15, No 5 has been published with online version     [Click]