An evaluation of DB2 Express-C pureXML Feature Pack using the TPoX performance benchmark
Wang, Li (2011)
Wang, Li
HAAGA-HELIA ammattikorkeakoulu
2011
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201105096788
https://urn.fi/URN:NBN:fi:amk-201105096788
Tiivistelmä
This thesis provides an introduction to XML indexes of DB2 pureXML Feature Pack, evaluating the effect of XML indexes to performance of application queries.
The thesis consists of two parts. The first part, chapters 1-4, present an overview of the “Transaction Processing over XML” (TPoX) benchmark and introduction to the implementation of XML indexes in DB2 9 LUW, based on literature research in handbooks, case studies and manuals. The smallest configured TPoX benchmark environment (XS scaling with 3 620 833 XML documents in 10GB disc size) is installed on Windows XP platform in a Microsoft Virtual PC 2007 computer. The second part, the empirical part in chapter 5, presents series of tests using selected XQuery queries of TPoX in the generated XS environment, with and without the XML indexes on XML columns. The use of indexes is studied from the extended EXPLAIN tables of hybrid DB2 giving performance estimates in TIMERON units of DB2. The performance effect is measured in the corresponding TPoX test runs of 25...100 concurrent virtual users.
According to the empirical tests, the XML indexes have a remarkable impact on the query performance and it proved to be effective to TPoX benchmark performance.
The study concludes that, the indexes on XML columns have a significant effect on the query performance in TPoX benchmark. Moreover, how to build up the indexes on XML column is also a highly considerable issue.
.
The thesis consists of two parts. The first part, chapters 1-4, present an overview of the “Transaction Processing over XML” (TPoX) benchmark and introduction to the implementation of XML indexes in DB2 9 LUW, based on literature research in handbooks, case studies and manuals. The smallest configured TPoX benchmark environment (XS scaling with 3 620 833 XML documents in 10GB disc size) is installed on Windows XP platform in a Microsoft Virtual PC 2007 computer. The second part, the empirical part in chapter 5, presents series of tests using selected XQuery queries of TPoX in the generated XS environment, with and without the XML indexes on XML columns. The use of indexes is studied from the extended EXPLAIN tables of hybrid DB2 giving performance estimates in TIMERON units of DB2. The performance effect is measured in the corresponding TPoX test runs of 25...100 concurrent virtual users.
According to the empirical tests, the XML indexes have a remarkable impact on the query performance and it proved to be effective to TPoX benchmark performance.
The study concludes that, the indexes on XML columns have a significant effect on the query performance in TPoX benchmark. Moreover, how to build up the indexes on XML column is also a highly considerable issue.
.