An End-to-End Learning-based Cost Estimator

Summary: An end-to-end tree-structured estimator jointly predicts query cardinality and execution cost, encoding both query predicates and physical operators. Pattern-based string embeddings improve generalization to predicate values without enumerating them, while handling complex query structures. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h65c46788cb871bbe
Venue: VLDB
Year: 2020
Pagerank: 0.00017829982
Overall Rank: 461 | 96.91%
DOI: 10.14778/3368289.3368296

Incoming Non-self Citations Over Time

Authors

1. Ji Sun (Tsinghua University)
2. Guoliang Li (Tsinghua University)

BibTeX Citation

@article{sun_vldb20,
        title = {{An End-to-End Learning-based Cost Estimator}},
        author = {Sun, Ji and Li, Guoliang},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {3},
        pages = {307--319},
        doi = {10.14778/3368289.3368296},
        url = {https://doi.org/10.14778/3368289.3368296},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 106 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
11,224	Esc: An Early-Stopping Checker for Budget-aware Index Tuning	2025	VLDB	4.9793485e-05
11,425	Learned Cost Models for Query Optimization: From Batch to Streaming Systems	2025	VLDB	4.9793485e-05
11,430	AXE: A Task Decomposition Approach to Learned LSM Tuning	2025	VLDB	4.9793485e-05
11,443	LEAP: A Low-cost Spark SQL Query Optimizer using Pairwise Comparison	2025	VLDB	4.9793485e-05
11,453	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	4.9793485e-05
11,857	DeepO: A Learned Query Optimizer	2022	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061066921
79	Practical Selectivity Estimation through Adaptive Sampling	1990	SIGMOD	0.00036487763
85	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00035864347
145	Neo: A Learned Query Optimizer	2019	VLDB	0.0002908188
255	The History of Histograms (abridged)	2003	VLDB	0.00022981861
314	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.00021282642
437	QTune: A Query-Aware Database Tuning System with Deep Reinforcement Learning	2019	VLDB	0.00018315867
560	Plan-Structured Deep Neural Network Models for Query Performance Prediction	2019	VLDB	0.00016403151
682	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.0001481781
688	Cardinality Estimation Done Right: Index-Based Join Sampling	2017	CIDR	0.00014753664
1,257	Sampling-Based Query Re-Optimization	2016	SIGMOD	0.00011310561
2,172	A Black-Box Approach to Query Cardinality Estimation	2007	CIDR	8.9214171e-05
2,625	Statistical Learning Techniques for Costing XML Queries	2005	VLDB	8.2089383e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,711	Learned Index Benefits: Machine Learning Based Index Performance Estimation	2022	VLDB
2	982	Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation	2022	VLDB
3	2,342	Learned Cardinality Estimation: An In-depth Study	2022	SIGMOD
4	7,417	Cardinality Estimation of Approximate Substring Queries using Deep Learning	2022	VLDB
5	2,885	Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction	2022	VLDB
6	5,649	Sample-Efficient Cardinality Estimation Using Geometric Deep Learning	2024	VLDB
7	10,027	Cardinality Estimation of LIKE Predicate Queries using Deep Learning	2025	SIGMOD
8	1,064	Are We Ready For Learned Cardinality Estimation?	2021	VLDB
9	2,522	Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation	2022	VLDB
10	6,660	Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation	2023	SIGMOD