MEASURING AND IMPROVING DATABASE QUERY PERFORMANCE FOR LARGE XML STRUCTURES

Article Sidebar

PDF
Published: Sep 6, 2019
Keywords:
XML, database, performance, XPath, query

Main Article Content

Marko Niinimaki
Lecturer, Webster University Thailand, 1 Empire Tower, South Sathorn Road, Bangkok 10120, Thailand
Matti Heikkurinen
Senior Advisor, Ludwig-Maximilians-Universität München, Geschwister-Scholl-Platz 1, 80539 Munich, Germany
Jan Schmidt
Researcher, Ludwig-Maximilians-Universität München, Geschwister-Scholl-Platz 1, 80539 Munich, Germany
Kitichai Chanyalikit
Lecturer, Webster University Thailand, 1 Empire Tower, South Sathorn Road, Bangkok 10120, Thailand

Abstract

We measured XPath query performance with two XML database packages using a large sample of XML documents and queries utilizing both the document structure and keywords. One of the packages is a “native” XML database, and the other one an XML-enabled relational database system. With large number of documents, both packages have performance problems. Using MongoDB improves the performance of some of the queries significantly, with some limitations on the expressive power of the query language. This is most likely an acceptable trade-off in most of the application scenarios.

Downloads

Download data is not yet available.

Article Details

Issue
Vol. 9 No. 2 (2019): May-August 2562
Section
บทความวิจัย (Research Article)
Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

*Copyright

            The article has been published in Kasem Bundit Engineering Journal (KBEJ) is the copyright of the Kasem Bundit University. Do not bring all of the messages or republished except permission from the university.

 * Responsibility

          If the article is published as an article that infringes the copyright or has the wrong content the author of article must be responsible.