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. An Automated, yet Interactive and Portable DB designer
 
conference paper

An Automated, yet Interactive and Portable DB designer

Alagiannis, Ioannis  
•
Dash, Debabrata
•
Schnaitter, Karl
Show more
2010
Proceedings of the ACM SIGMOD International Conference on Management of Data
ACM SIGMOD International Conference on Management of Data

Tuning tools attempt to configure a database to achieve optimal performance for a given workload. Selecting an optimal set of physical structures is computationally hard since it involves searching a vast space of possible configurations. Commercial DBMSs offer tools that can address this problem. The usefulness of such tools, however, is limited by their dependence on greedy heuristics, the need for a-priori (offline) knowledge of the workload, and lack of an optimal materialization schedule to get the best out of suggested design features. Moreover, the open source DBMSs do not provide any automated tuning tools. This demonstration introduces a comprehensive physical designer for the PostgreSQL open source DBMS. The tool suggests design features for both offline and online workloads. It provides close to optimal suggestions for indexes for a given workload by modeling the problem as a combinatorial optimization problem and solving it by sophisticated and mature solvers. It also determines the interaction between indexes to suggest an effective materialization strategy for the selected indexes. The tool is interactive as it allows the database administrator (DBA) to suggest a set of candidate features and shows their benefits and interactions visually. For the demonstration we use large realworld scientific datasets and query workloads.

  • Files
  • Details
  • Metrics
Type
conference paper
DOI
10.1145/1807167.1807314
Author(s)
Alagiannis, Ioannis  
Dash, Debabrata
Schnaitter, Karl
Ailamaki, Anastasia  
Polyzotis, Neoklis
Date Issued

2010

Published in
Proceedings of the ACM SIGMOD International Conference on Management of Data
Start page

1183

End page

1186

Subjects

Physical Design Tuning

•

Continuous Tuning

•

Index Interaction

Note

DEMO EURYI

Editorial or Peer reviewed

NON-REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
ACM SIGMOD International Conference on Management of Data

Indianapolis, Indiana, USA

June 6–10, 2010

Available on Infoscience
December 6, 2010
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/61919
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