Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads
 
conference paper

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

Dash, Debabrata
•
Polyzotis, Neoklis
•
Ailamaki, Anastasia  
2011
Proceedings of the VLDB Endowment

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).

  • Files
  • Details
  • Metrics
Loading...
Thumbnail Image
Name

p362-dash.pdf

Type

Publisher's Version

Version

Published version

Access type

openaccess

Size

696.08 KB

Format

Adobe PDF

Checksum (MD5)

f7ca6c4f9df01e3d65745c04e78e1088

Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés