loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
16th International Conference on Data Engineering (ICDE'00)
DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
San Diego, California
February 28-March 03
ISBN: 0-7695-0506-6
ASCII Text
x 
 
Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy Lohman, Alan Skelley, "DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes," Data Engineering, International Conference on, pp. 101, 16th International Conference on Data Engineering (ICDE'00), 2000.
 
 
BibTex
x
 
@article{ 10.1109/ICDE.2000.839397,
author = {Gary Valentin and Michael Zuliani and Daniel C. Zilio and Guy Lohman and Alan Skelley},
title = {DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes},
journal ={Data Engineering, International Conference on},
volume = {0},
year = {2000},
issn = {1063-6382},
pages = {101},
doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2000.839397},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Data Engineering, International Conference on
TI - DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
SN - 1063-6382
SP
EP
A1 - Gary Valentin,
A1 - Michael Zuliani,
A1 - Daniel C. Zilio,
A1 - Guy Lohman,
A1 - Alan Skelley,
PY - 2000
KW - Relational Database
KW - Optimizer
KW - Index Selection
KW - Knapsack Algorithm
KW - Auto-Tuning
KW - Self-Tuning
KW - Database Design
KW - Wizard
VL - 0
JA - Data Engineering, International Conference on
ER -
 
Gary Valentin, IBM Toronto Lab
Michael Zuliani, IBM Toronto Lab
Daniel C. Zilio, IBM Toronto Lab
Guy Lohman, IBM Almaden Research Center
Alan Skelley, University of Toronto
This paper introduces the concept of letting an RDBMS Optimizer optimize its own environment. In our project, we have used the DB2 Optimizer to tackle the index selection problem, a variation of the knapack problem. This paper will discuss our implementation of index recommendation, the user interface, and provide measurements on the quality of the recommended indexes.
Index Terms:
Relational Database, Optimizer, Index Selection, Knapsack Algorithm, Auto-Tuning, Self-Tuning, Database Design, Wizard
Citation:
Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy Lohman, Alan Skelley, "DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes," icde, pp.101, 16th International Conference on Data Engineering (ICDE'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.