Kaizen: a semi-automatic index advisor

I Jimenez, H Sanchez, QT Tran… - Proceedings of the 2012 …, 2012 - dl.acm.org
Proceedings of the 2012 ACM SIGMOD International Conference on Management of …, 2012dl.acm.org
Index tuning; ie, 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 …
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.
ACM Digital Library
以上显示的是最相近的搜索结果。 查看全部搜索结果