Semi-Automatic Index Tuning: Keeping DBAs in the Loop

@article{Schnaitter2012SemiAutomaticIT,
  title={Semi-Automatic Index Tuning: Keeping DBAs in the Loop},
  author={Karl Schnaitter and Neoklis Polyzotis},
  journal={PVLDB},
  year={2012},
  volume={5},
  pages={478-489}
}
To obtain good system performance, a DBA must choose a set of indices that is appropriate for the workload. The system can aid in this challenging task by providing recommendations for the index configuration. We propose a new index recommendation technique, termed semi-automatic tuning, that keeps the DBA “in the loop” by generating recommendations that use feedback about the DBA’s preferences. The technique also works online, which avoids the limitations of commercial tools that require the… CONTINUE READING
Highly Cited
This paper has 43 citations. REVIEW CITATIONS

Citations

Publications citing this paper.
Showing 1-10 of 22 extracted citations

References

Publications referenced by this paper.
Showing 1-10 of 18 references

Interactive physical design tuning Configuration - parametric query optimization for physical design tuning

  • K. A. Ross L. Hu, Y.-C. Chang, C. A. Lang, D. Zhang
  • 2008

Similar Papers

Loading similar papers…