Home
Scholarly Works
An xml index advisor for DB2
Conference

An xml index advisor for DB2

Abstract

XML database systems are expected to handle increasingly complex queries over increasingly large and highly structured XML databases. An important problem that needs to be solved for these systems is how to choose the best set of indexes for a given workload. We have developed an XML Index Advisor that solves this XML index recommendation problem and is tightly coupled with the query optimizer of the database system. We have implemented our XML Index Advisor for DB2. In this demonstration we showcase the new query optimizer modes that we added to DB2, the index recommendation process, and the effectiveness of the recommended indexes.

Authors

Elghandour I; Aboulnaga A; Zilio DC; Chiang F; Balmin A; Beyer K; Zuzarte C

Pagination

pp. 1267-1270

Publisher

Association for Computing Machinery (ACM)

Publication Date

June 9, 2008

DOI

10.1145/1376616.1376752

Name of conference

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
View published work (Non-McMaster Users)

Contact the Experts team