The Community for Technology Leaders
2008 IEEE 24th International Conference on Data Engineering (2008)
Cancun, Mexico
Apr. 7, 2008 to Apr. 12, 2008
ISBN: 978-1-4244-1836-7
pp: 833-842
Iman Elghandour , University of Waterloo.
Ashraf Aboulnaga , University of Waterloo.
Daniel C. Zilio , IBM Toronto Lab.
Fei Chiang , University of Toronto.
Andrey Balmin , IBM Almaden Research Center.
Kevin Beyer , IBM Almaden Research Center.
Calisto Zuzarte , IBM Toronto Lab.
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. In this paper, we present an XML Index Advisor that solves this XML index recommendation problem and has the key characteristic of being tightly coupled with the query optimizer. We rely on the optimizer to enumerate index candidates and to estimate the benefit gained from potential index configurations. We expand the set of candidate indexes obtained from the query optimizer to include more general indexes that can be useful for queries other than those in the training workload. To recommend an index configuration, we introduce two new search algorithms. The first algorithm finds the best set of indexes for the specific training workload, and the second algorithm finds a general set of indexes that can benefit the training workload as well as other similar workloads. We have implemented our XML Index Advisor in a prototype version of IBM

C. Zuzarte et al., "XML Index Recommendation with Tight Optimizer Coupling," 2008 IEEE 24th International Conference on Data Engineering(ICDE), Cancun, Mexico, 2008, pp. 833-842.
89 ms
(Ver 3.3 (11022016))