Kaizen: a semi-automatic index advisor

Index tuning; i.e., selecting indexes that are appropriate for the workload to obtain good system performance, is a crucial task for database administrators. Administrators rely on automated index advisors for this task, but existing advisors work either offline, requiring a-priori knowledge of the workload, or online, taking the administrator out of the picture and assuming total control of the index tuning task. Semi-automatic index tuning is a new paradigm that achieves a middle ground: the advisor analyzes the workload online and provides recommendations tailored to the current workload, and the administrator is able to provide feedback to refine future recommendations. In this demonstration we present Kaizen, an index tuning tool that implements semi-automatic tuning.

[1]  Sam Lightstone,et al.  DB2 Design Advisor: Integrated Automatic Physical Database Design , 2004, VLDB.

[2]  Surajit Chaudhuri,et al.  Database Tuning Advisor for Microsoft SQL Server 2005 , 2004, VLDB.

[3]  Neoklis Polyzotis,et al.  A Benchmark for Online Index Selection , 2009, 2009 IEEE 25th International Conference on Data Engineering.

[4]  Allan Borodin,et al.  Online computation and competitive analysis , 1998 .

[5]  Surajit Chaudhuri,et al.  An Online Approach to Physical Design Tuning , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[6]  Serge Abiteboul,et al.  On-Line Index Selection for Shifting Workloads , 2007, 2007 IEEE 23rd International Conference on Data Engineering Workshop.

[7]  Surajit Chaudhuri,et al.  Database tuning advisor for microsoft SQL server 2005: demo , 2005, SIGMOD '05.

[8]  Surajit Chaudhuri,et al.  Interactive physical design tuning , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[9]  Vivek R. Narasayya,et al.  Automatic physical design tuning: workload as a sequence , 2006, SIGMOD Conference.

[10]  Surajit Chaudhuri,et al.  Constrained physical design tuning , 2009, The VLDB Journal.

[11]  Benoît Dageville,et al.  Automatic SQL Tuning in Oracle 10g , 2004, VLDB.

[12]  PolyzotisNeoklis,et al.  Semi-automatic index tuning , 2012, VLDB 2012.

[13]  Neoklis Polyzotis,et al.  Semi-Automatic Index Tuning: Keeping DBAs in the Loop , 2012, Proc. VLDB Endow..

[14]  Lise Getoor,et al.  Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications , 2009, Proc. VLDB Endow..