What Makes a Good Physical Plan? — Experiencing Hardware-Conscious Query Optimization with Candomble

Summary: Proposes Candomble, an interactive, touch-based environment for hardware-conscious query optimization. Humans act as live physical optimizers, rewriting GPU/CPU plans and extracting rules for a downstream rule-based planner. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hdae5c8bded3bd313
Venue: SIGMOD
Year: 2016
Pagerank: 5.7270789e-05
Overall Rank: 6,630 | 55.43%
DOI: 10.1145/2882903.2899410

Incoming Non-self Citations Over Time

Authors

1. Holger Pirk (Massachusetts Institute of Technology)
2. Oscar Moll (Massachusetts Institute of Technology)
3. Sam Madden (Massachusetts Institute of Technology)

BibTeX Citation

@inproceedings{pirk_sigmod16,
        title = {{What Makes a Good Physical Plan? — Experiencing Hardware-Conscious Query Optimization with Candomble}},
        author = {Pirk, Holger and Moll, Oscar and Madden, Sam},
        series = {{SIGMOD} '16},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2882903.2899410},
        url = {https://dl.acm.org/doi/10.1145/2882903.2899410},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,003	MOCHA: A Tool for Visualizing Impact of Operator Choices in Query Execution Plans for Database Education	2022	VLDB	5.9172558e-05
10,030	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	5.0925155e-05

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
21	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00056855599
495	Building Efficient Query Engines in a High-Level Language	2014	VLDB	0.00017370758
1,473	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	0.00010557973
2,123	Tupleware: "Big" Data, Big Analytics, Small Clusters	2015	CIDR	9.0060385e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,773	Hardware-conscious Query Processing in GPU-accelerated Analytical Engines	2019	CIDR
2	6,935	Demonstrating Efficient Query Processing in Heterogeneous Environments	2014	SIGMOD
3	2,226	Physical Data Independence, Constraints, and Optimization with Universal Plans	1999	VLDB
4	996	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB
5	4,855	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB
6	7,578	Interactive Plan Hints for Query Optimization	2009	SIGMOD
7	2,857	Constrained Physical Design Tuning	2008	VLDB
8	21	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB
9	243	Automating Physical Database Design in a Parallel Database	2002	SIGMOD
10	3,041	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD