Thumbnail
Access Restriction
Subscribed

Author Valentin, G. ♦ Zuliani, M. ♦ Zilio, D.C. ♦ Lohman, G. ♦ Skelley, A.
Source IEEE Xplore Digital Library
Content type Text
Publisher Institute of Electrical and Electronics Engineers, Inc. (IEEE)
File Format PDF
Copyright Year ©2000
Language English
Subject Domain (in DDC) Computer science, information & general works ♦ Data processing & computer science
Subject Keyword Relational databases ♦ Engines ♦ Electrical capacitance tomography ♦ Design optimization ♦ Cost function ♦ Statistics ♦ Constraint optimization ♦ Combinatorial mathematics ♦ User interfaces
Abstract 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 knapsack problem. This paper discusses our implementation of index recommendation, the user interface, and provide measurements on the quality of the recommended indexes.
Description Author affiliation: IBM Canada Ltd., Toronto, Ont., Canada (Valentin, G.)
ISBN 0769505066
ISSN 10636382
Educational Role Student ♦ Teacher
Age Range above 22 year
Educational Use Research ♦ Reading
Education Level UG and PG
Learning Resource Type Article
Publisher Date 2000-03-03
Rights Holder Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Size (in Bytes) 118.96 kB
Page Count 10
Starting Page 101
Ending Page 110


Source: IEEE Xplore Digital Library