An Automated, Yet Interactive and Portable DB Designer
Summary: Automated, portable PostgreSQL physical designer for offline and online workloads; yields near-optimal index sets and materialization schedules. Frames index selection as a combinatorial optimization solved by mature solvers; reveals index interactions and provides interactive, visual DBA guidance. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Ioannis Alagiannis (EPFL)
- 2. Debabrata Dash (Carnegie Mellon University; EPFL)
- 3. Karl Schnaitter (University of California Santa Cruz)
- 4. Anastasia Ailamaki (EPFL)
- 5. Neoklis Polyzotis (University of California Santa Cruz)
BibTeX Citation
@inproceedings{alagiannis_sigmod10,
title = {{An Automated, Yet Interactive and Portable DB Designer}},
author = {Alagiannis, Ioannis and Dash, Debabrata and Schnaitter, Karl and Ailamaki, Anastasia and Polyzotis, Neoklis},
series = {{SIGMOD} '10},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1807167.1807314},
url = {https://dl.acm.org/doi/10.1145/1807167.1807314},
year = {2010}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,222 | CliffGuard: A Principled Framework for Finding Robust Database Designs | 2015 | SIGMOD | 6.3103741e-05 |
| 9,008 | Making Data Clouds Smarter at Keebo: Automated Warehouse Optimization using Data Learning | 2023 | SIGMOD | 5.3335632e-05 |
| 10,773 | Physical Visualization Design: Decoupling Interface and System Design | 2025 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 184 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00026256101 |
| 501 | Database Tuning Advisor for Microsoft SQL Server 2005 | 2004 | VLDB | 0.0001738508 |
| 768 | Automatic Physical Database Tuning: A Relaxation-based Approach | 2005 | SIGMOD | 0.00014173242 |
| 1,997 | Efficient Use of the Query Optimizer for Automated Physical Design | 2007 | VLDB | 9.3378162e-05 |
| 4,550 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB | 6.635765e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,298 | GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization | 2024 | VLDB |
| 2 | 12,644 | Online AutoAdmin (Physical Design Tuning) | 2007 | SIGMOD |
| 3 | 4,550 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB |
| 4 | 11,306 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 5 | 2,811 | Constrained Physical Design Tuning | 2008 | VLDB |
| 6 | 184 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB |
| 7 | 1,272 | A Framework for Automating Physical Database Design | 1991 | VLDB |
| 8 | 2,364 | To Tune or not to Tune? A Lightweight Physical Design Alerter | 2006 | VLDB |
| 9 | 3,003 | Configuration-Parametric Query Optimization for Physical Design Tuning | 2008 | SIGMOD |
| 10 | 768 | Automatic Physical Database Tuning: A Relaxation-based Approach | 2005 | SIGMOD |