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: 11922
Venue: VLDB
Year: 2019
Pagerank: 4.8230386e-05
Overall Rank: 7,127 | 50.42%
DOI: 10.14778/3352063.3352120

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,429	Real-time Workload Pattern Analysis for Large-scale Cloud Databases	2023	VLDB	7.1010535e-05
5,525	QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting	2023	VLDB	5.4600815e-05
8,659	Learned Offline Query Planning via Bayesian Optimization	2025	SIGMOD	4.4722928e-05
9,352	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	4.3522361e-05
9,587	Low Rank Learning for Offline Query Optimization	2025	SIGMOD	4.3215645e-05
10,568	QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach	2025	VLDB	4.1945683e-05
11,675	GALO: Guided Automated Learning for re-Optimization	2019	VLDB	4.1945683e-05

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.0040449103
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
496	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021728655
661	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00018481174
907	Fundamental Techniques for Order Optimization	1996	SIGMOD	0.00015435983
1,016	Memory-Efficient Hash Joins	2015	VLDB	0.00014638492
4,045	Optimizing Nested Queries with Parameter Sort Orders	2005	VLDB	6.4985218e-05
4,512	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.1241619e-05
4,744	Effective and Complete Discovery of Order Dependencies via Set-based Axiomatization	2017	VLDB	5.957936e-05
5,815	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.3165295e-05
7,440	Interactive Plan Hints for Query Optimization	2009	SIGMOD	4.7302233e-05
11,675	GALO: Guided Automated Learning for re-Optimization	2019	VLDB	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,279	Galley: Modern Query Optimization for Sparse Tensor Programs	2025	SIGMOD	4.5435639e-05
10,564	PlanRGCN: Predicting SPARQL Query Performance	2025	VLDB	4.1945683e-05
11,350	DeepO: A Learned Query Optimizer	2022	SIGMOD	4.1945683e-05
6,040	Steering Query Optimizers: A Practical Take on Big Data Workloads	2021	SIGMOD	5.2412035e-05
6,667	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB	4.9688874e-05
10,219	Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking	2026	SIGMOD	4.1945683e-05
5,840	Logical and Physical Optimizations for SQL Query Execution over Large Language Models	2025	SIGMOD	5.3042561e-05
10,630	Conformal Prediction for Verifiable Learned Query Optimization	2025	VLDB	4.1945683e-05
3,348	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	7.1904529e-05
11,675	GALO: Guided Automated Learning for re-Optimization	2019	VLDB	4.1945683e-05