DBScholar

Back to papers

Guided automated learning for query workload re-optimization

Summary: GALO automates fixing costly query plans with offline learning of recurring patterns, yielding RDF/SPARQL knowledge base of remedies. Third-tier re-optimizer after cost-based optimization, enabling cross-workload generalization and performance insight on TPC-DS/IBM datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
12110
Venue
VLDB
Year
2019
Pagerank
5.733869e-05
Overall Rank
6,938 | 52.40%
DOI
10.14778/3352063.3352120

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{damasio_vldb19,
        title = {{Guided automated learning for query workload re-optimization}},
        author = {Damasio, Guilherme and Corvinelli, Vincent and Godfrey, Parke and Mierzejewski, Piotr and Mihaylov, Alex and Szlichta, Jaroslaw and Zuzarte, Calisto},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {12},
        pages = {2010--2021},
        doi = {10.14778/3352063.3352120},
        url = {https://doi.org/10.14778/3352063.3352120},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank Citing Paper Year Venue Pagerank
4,398 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.7248611e-05
4,909 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.4486671e-05
8,163 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4751517e-05
9,441 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.2678428e-05
9,601 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.2487799e-05
10,834 QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach 2025 VLDB 5.093636e-05
11,870 GALO: Guided Automated Learning for re-Optimization 2019 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0024089429
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
524 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00017120666
744 Fundamental Techniques for Order Optimization 1996 SIGMOD 0.00014411295
959 Memory-Efficient Hash Joins 2015 VLDB 0.00012953588
3,816 Optimizing Nested Queries with Parameter Sort Orders 2005 VLDB 7.1002641e-05
4,454 Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization 2017 VLDB 6.6929626e-05
4,635 Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g 2008 VLDB 6.5928815e-05
5,514 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.1901666e-05
7,448 Interactive Plan Hints for Query Optimization 2009 SIGMOD 5.6147364e-05
11,870 GALO: Guided Automated Learning for re-Optimization 2019 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,513 Galley: Modern Query Optimization for Sparse Tensor Programs 2025 SIGMOD
2 10,830 PlanRGCN: Predicting SPARQL Query Performance 2025 VLDB
3 11,548 DeepO: A Learned Query Optimizer 2022 SIGMOD
4 5,059 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD
5 5,394 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB
6 10,508 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD
7 4,045 Logical and Physical Optimizations for SQL Query Execution over Large Language Models 2025 SIGMOD
8 10,884 Conformal Prediction for Verifiable Learned Query Optimization 2025 VLDB
9 2,420 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB
10 11,870 GALO: Guided Automated Learning for re-Optimization 2019 VLDB