QUIET: continuous query-driven index tuning

Authors:
Kai-Uwe Sattler;Ingolf Geist;Eike Schallehn
Affiliations:
Department of Computer Science, University of Magdeburg, Magdeburg, Germany;Department of Computer Science, University of Magdeburg, Magdeburg, Germany;Department of Computer Science, University of Magdeburg, Magdeburg, Germany
Venue:
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Year:
2003

Citing 4
Cited 7

The LRU-K page replacement algorithm for database disk buffering

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
WATCHMAN: A Data Warehouse Intelligent Cache Manager

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes

ICDE '00 Proceedings of the 16th International Conference on Data Engineering

Automatic physical design tuning: workload as a sequence

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Self-tuning database systems: a decade of progress

VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Self-organizing strategies for a column-store database

EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology
When is it time to rethink the aggregate configuration of your OLAP server?

Proceedings of the VLDB Endowment
Adaptive Physical Design for Curated Archives

SSDBM 2009 Proceedings of the 21st International Conference on Scientific and Statistical Database Management
Proactive database index tuning through data threshold prediction

Proceedings of the 47th Annual Southeast Regional Conference
Workload management: a technology perspective with respect to self-* characteristics

Artificial Intelligence Review

Quantified Score

Hi-index	0.00

Visualization

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 dynamic 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 automatically at runtime. In this way, index tuning is driven by queries without explicit actions of the database users.