An xml index advisor for DB2

10 years 10 months ago
An xml index advisor for DB2
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. Categories and Subject Descriptors H.2 [Database Management]: Physical Design General Terms Algorithms, Design, Experimentation, Performance Keywords XML Databases, Automatic Physical Database Design, Index Advisor
Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio
Added 08 Dec 2009
Updated 08 Dec 2009
Type Conference
Year 2008
Authors Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Fei Chiang, Andrey Balmin, Kevin S. Beyer, Calisto Zuzarte
Comments (0)