DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
The XML benchmark project
Automatic physical database tuning: a relaxation-based approach
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
DB2 goes hybrid: integratng native XML and XQuery with relational data and SQL
IBM Systems Journal
An XML transaction processing benchmark
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
XML Index Recommendation with Tight Optimizer Coupling
ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
Effective pruning for XML structural match queries
Data & Knowledge Engineering
XML: some papers in a haystack
ACM SIGMOD Record
Recommending XML physical designs for XML databases
The VLDB Journal — The International Journal on Very Large Data Bases
Hi-index | 0.00 |
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.