CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads

Details CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads

2011-04-16

arxiv.org/abs/1104.3214v1

Proceedings of the VLDB Endowment (PVLDB), Vol. 4, No. 6, pp. 362-372 (2011)

Computer Science

Databases

VLDB2011

Scientific paper

Index tuning, i.e., selecting the indexes appropriate for a workload, is a crucial problem in database system tuning. In this paper, we solve index tuning for large problem instances that are common in practice, e.g., thousands of queries in the workload, thousands of candidate indexes and several hard and soft constraints. Our work is the first to reveal that the index tuning problem has a well structured space of solutions, and this space can be explored efficiently with well known techniques from linear optimization. Experimental results demonstrate that our approach outperforms state-of-the-art commercial and research techniques by a significant margin (up to an order of magnitude).

Affiliated with

Also associated with

No associations

Rating

CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 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 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-346986