Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches
Summary: Open-source platform automating DB/workload/cost setup and aggregating multiple SOTA index-selection approaches for reproducible, comparable evaluations. Interactive UI shows per-query index usage and cost effects and lets users edit selections to explore impacts and prototype new strategies. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Stefan Halfpap (Berlin Institute for the Foundations of Learning and Data; Technical University of Berlin)
- 2. Jan Kossmann (Snowflake)
- 3. Rainer Schlosser (Hasso Plattner Institute)
- 4. Volker Markl (Berlin Institute for the Foundations of Learning and Data; German National Research Center for Information Technology; Technical University of Berlin)
BibTeX Citation
@article{halfpap_vldb24,
title = {{Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches}},
author = {Halfpap, Stefan and Kossmann, Jan and Schlosser, Rainer and Markl, Volker},
journal = {PVLDB},
series = {{VLDB} '24},
volume = {17},
number = {12},
pages = {4301--4304},
doi = {10.14778/3685800.3685860},
url = {https://doi.org/10.14778/3685800.3685860},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB | 0.00028636811 |
| 768 | Automatic Physical Database Tuning: A Relaxation-based Approach | 2005 | SIGMOD | 0.00014173242 |
| 1,481 | Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms | 2020 | VLDB | 0.00010644613 |
| 1,904 | CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads | 2011 | VLDB | 9.5040429e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 387 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 2 | 1,512 | On the Analysis of Indexing Schemes | 1997 | PODS |
| 3 | 5,039 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 4 | 6,651 | Progressive Indexes: Indexing for Interactive Data Analysis | 2019 | VLDB |
| 5 | 6,327 | Breaking It Down: An In-depth Study of Index Advisors | 2024 | VLDB |
| 6 | 87 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |
| 7 | 4,643 | Learned Index Benefits: Machine Learning Based Index Performance Estimation | 2022 | VLDB |
| 8 | 4,550 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB |
| 9 | 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB |
| 10 | 1,481 | Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms | 2020 | VLDB |