MEASURING AND IMPROVING DATABASE QUERY PERFORMANCE FOR LARGE XML STRUCTURES

Authors

  • 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

Keywords:

XML, database, performance, XPath, query

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

Published

2019-09-06

Issue

Vol. 9 No. 2 (2019): May-August 2562

Section

บทความวิจัย (Research Article)

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.