Welcome to D
SIGMOD 2003
PODS 2003
SIGMOD-RECOR
ADBIS
CIDR 2003
CIKM 2003
DASFAA 2003
Data Enginee
DEBS
DMKD 2003
DOLAP 2003
DPDJ 2003
ER
GIS 2003
Hypertext 20
ICDE 2003
ICDM 2003
ICDT 2003
JCDL 2003
KRDB 2003
MIR 2003
MIS 2003
MMDB 2003
RIDE 2003
SBBD 2003
SIGIR 2003
SIGIR-FORUM
SIGKDD 2003
SIGKDD-EXP
SSDBM 2003
TIME 2003
TODS
VLDB 2003
<<< = VLDB'03 Pape>>>
 = Plenary Talk
VLDB Journal
WIDM 2003

QUIET: Continuous Query-driven Index Tuning


Kai-Uwe Sattler, Ingolf Geist, and Eike Schallehn

  View Paper (PDF)  

Return to Advanced Models and Languages/Architectures for Data Analysis (Session D3)


Abstract

Index tuning as part of database tuning is the task of selecting and creating indexes with the goal of reducing query processing times. However, in dy- namic environments with various ad-hoc queries it is difficult to identify potential useful indexes in advance. In this demonstration, we present our tool QUIET addressing this problem. This tool "intercepts" queries and - based on a cost model as well as runtime statistics about profits of index configurations - decides about index creation au- tomatically at runtime. In this way, index tuning is driven by queries without explicit actions of the database users.


©2004 Association for Computing Machinery