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. Efficient Use of the Query Optimizer for Automated Database Design
 
conference paper not in proceedings

Efficient Use of the Query Optimizer for Automated Database Design

Papadomanolakis, Stratos
•
Dash, Debabrata
•
Ailamaki, Anastassia  
2007
International Conference on Very Large Data Bases (VLDB), Vienna, Austria

State-of-the-art database design tools rely on the query optimizer for comparing between physical design alternatives. Although it provides an appropriate cost model for physical design, query optimization is a computationally expensive process. The significant time consumed by optimizer invocations poses serious performance limitations for physical design tools, causing long running times, especially for large problem instances. So far it has been impossible to remove query optimization overhead without sacrificing cost estimation precision. Inaccuracies in query cost estimation are detrimental to the quality of physical design algorithms, as they increase the chances of “missing” good designs and consequently selecting sub-optimal ones. Precision loss and the resulting reduction in solution quality is particularly undesirable and it is the reason the query optimizer is used in the first place. In this paper we eliminate the tradeoff between query cost estimation accuracy and performance. We introduce the INdex Usage Model (INUM), a cost estimation technique that returns the same values that would have been returned by the optimizer, while being three orders of magnitude faster. Integrating INUM with existing index selection algorithms dramatically improves their running times without precision compromises.

  • Details
  • Metrics
Type
conference paper not in proceedings
Author(s)
Papadomanolakis, Stratos
Dash, Debabrata
Ailamaki, Anastassia  
Date Issued

2007

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
LABOS  
DIAS  
Event nameEvent placeEvent date
International Conference on Very Large Data Bases (VLDB), Vienna, Austria

Vienna, Austria

September 2007

Available on Infoscience
October 10, 2007
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/12806
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