Semi-Automatic Index Tuning: Keeping DBAs in the Loop

Details Semi-Automatic Index Tuning: Keeping DBAs in the Loop Semi-Automatic Index Tuning: Keeping DBAs in the Loop

2010-04-08

arxiv.org/abs/1004.1249v6

Computer Science

Databases

Scientific paper

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 workload to be known in advance. The foundation of our approach is the Work Function Algorithm, which can solve a wide variety of online optimization problems with strong competitive guarantees. We present an experimental analysis that validates the benefits of semi-automatic tuning in a wide variety of conditions.

Affiliated with

Also associated with

No associations

Rating

Semi-Automatic Index Tuning: Keeping DBAs in the Loop does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Semi-Automatic Index Tuning: Keeping DBAs in the Loop, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Semi-Automatic Index Tuning: Keeping DBAs in the Loop will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-713083