Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning
Summary: ADOPT uses episodic execution plus reinforcement learning to pick attribute orders for worst-case optimal joins. A shared processed-data index prevents redundant work across episodes, enabling fast convergence to near-optimal orders and outperforming WCOJ baselines on complex/skewed queries. (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. Junxiong Wang (Cornell University)
- 2. Mitchell Gray (Cornell University)
- 3. Immanuel Trummer (Cornell University)
- 4. Ahmet Kara (University of Zurich)
- 5. Dan Olteanu (University of Zurich)
BibTeX Citation
@article{wang_vldb23,
title = {{Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning}},
author = {Wang, Junxiong and Gray, Mitchell and Trummer, Immanuel and Kara, Ahmet and Olteanu, Dan},
journal = {PVLDB},
series = {{VLDB} '23},
volume = {16},
number = {12},
pages = {4094--4097},
doi = {10.14778/3611540.3611629},
url = {https://doi.org/10.14778/3611540.3611629},
year = {2023}
}Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,978 | ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning | 2023 | VLDB | 5.514996e-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 |
|---|---|---|---|---|
| 34 | The Design Of Postgres | 1986 | SIGMOD | 0.00049302774 |
| 211 | EmptyHeaded: A Relational Engine for Graph Processing | 2016 | SIGMOD | 0.00024797217 |
| 490 | Design and Implementation of the LogicBlox System | 2015 | SIGMOD | 0.000175757 |
| 1,712 | SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning | 2019 | SIGMOD | 9.9492299e-05 |
| 7,978 | ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning | 2023 | VLDB | 5.514996e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,882 | Efficiently Computing Join Orders with Heuristic Search | 2023 | SIGMOD |
| 2 | 3,051 | Towards a Hands-Free Query Optimizer through Deep Learning | 2019 | CIDR |
| 3 | 8,400 | The Fittest Survives: An Adaptive Approach to Query Optimization | 1995 | VLDB |
| 4 | 1,815 | SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning | 2018 | VLDB |
| 5 | 1,286 | Adaptive Optimization of Very Large Join Queries | 2018 | SIGMOD |
| 6 | 1,740 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 7 | 6,593 | Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis | 2023 | VLDB |
| 8 | 1,712 | SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning | 2019 | SIGMOD |
| 9 | 6,735 | Join Order Selection with Deep Reinforcement Learning: Fundamentals, Techniques, and Challenges | 2023 | VLDB |
| 10 | 7,978 | ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning | 2023 | VLDB |