An XML Index Advisor for DB2

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Fei Chiang, Andrey Balmin, Calisto Zuzarte, Kevin Beyer

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Citations (Scopus)

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.

Original languageEnglish
Title of host publicationProceedings of the ACM SIGMOD International Conference on Management of Data
Pages1267-1270
Number of pages4
DOIs
Publication statusPublished - 10 Dec 2008
Externally publishedYes
Event2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08 - Vancouver, BC, Canada
Duration: 9 Jun 200812 Jun 2008

Other

Other2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08
CountryCanada
CityVancouver, BC
Period9/6/0812/6/08

Fingerprint

XML
Demonstrations

Keywords

  • Automatic Physical Database Design
  • Index Advisor
  • Xml Databases

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Elghandour, I., Aboulnaga, A., Zilio, D. C., Chiang, F., Balmin, A., Zuzarte, C., & Beyer, K. (2008). An XML Index Advisor for DB2. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 1267-1270). [1376752] https://doi.org/10.1145/1376616.1376752

An XML Index Advisor for DB2. / Elghandour, Iman; Aboulnaga, Ashraf; Zilio, Daniel C.; Chiang, Fei; Balmin, Andrey; Zuzarte, Calisto; Beyer, Kevin.

Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. p. 1267-1270 1376752.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Elghandour, I, Aboulnaga, A, Zilio, DC, Chiang, F, Balmin, A, Zuzarte, C & Beyer, K 2008, An XML Index Advisor for DB2. in Proceedings of the ACM SIGMOD International Conference on Management of Data., 1376752, pp. 1267-1270, 2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08, Vancouver, BC, Canada, 9/6/08. https://doi.org/10.1145/1376616.1376752
Elghandour I, Aboulnaga A, Zilio DC, Chiang F, Balmin A, Zuzarte C et al. An XML Index Advisor for DB2. In Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. p. 1267-1270. 1376752 https://doi.org/10.1145/1376616.1376752
Elghandour, Iman ; Aboulnaga, Ashraf ; Zilio, Daniel C. ; Chiang, Fei ; Balmin, Andrey ; Zuzarte, Calisto ; Beyer, Kevin. / An XML Index Advisor for DB2. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. pp. 1267-1270
@inproceedings{7188c1f070274390904fcfee2a72efd4,
title = "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.",
keywords = "Automatic Physical Database Design, Index Advisor, Xml Databases",
author = "Iman Elghandour and Ashraf Aboulnaga and Zilio, {Daniel C.} and Fei Chiang and Andrey Balmin and Calisto Zuzarte and Kevin Beyer",
year = "2008",
month = "12",
day = "10",
doi = "10.1145/1376616.1376752",
language = "English",
isbn = "9781605581026",
pages = "1267--1270",
booktitle = "Proceedings of the ACM SIGMOD International Conference on Management of Data",

}

TY - GEN

T1 - An XML Index Advisor for DB2

AU - Elghandour, Iman

AU - Aboulnaga, Ashraf

AU - Zilio, Daniel C.

AU - Chiang, Fei

AU - Balmin, Andrey

AU - Zuzarte, Calisto

AU - Beyer, Kevin

PY - 2008/12/10

Y1 - 2008/12/10

N2 - 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.

AB - 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.

KW - Automatic Physical Database Design

KW - Index Advisor

KW - Xml Databases

UR - http://www.scopus.com/inward/record.url?scp=57149133394&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=57149133394&partnerID=8YFLogxK

U2 - 10.1145/1376616.1376752

DO - 10.1145/1376616.1376752

M3 - Conference contribution

SN - 9781605581026

SP - 1267

EP - 1270

BT - Proceedings of the ACM SIGMOD International Conference on Management of Data

ER -