Database Paper Browser

Back to papers

LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries

Summary: LPLM is a neural language model for LIKE-pattern cardinality estimation, with a novel pattern language and distribution for in-between wildcards. A data-generation method trains it; it outperforms prior work on Q-error with similar runtime/memory. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6864
Venue
SIGMOD
Year
2024
Pagerank
4.8017628e-05
Overall Rank
7,188 | 50.05%
DOI
10.1145/3639309

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank Citing Paper Year Venue Pagerank
9,725 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 4.290223e-05
9,727 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 4.2901665e-05
9,824 Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement 2025 SIGMOD 4.2710095e-05
9,947 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 4.2391999e-05
10,216 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 4.1905499e-05
10,219 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.1905499e-05
10,598 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.1905499e-05
10,757 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB 4.1905499e-05
10,884 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 21 of 21 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.0040465394
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059446482
100 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00050033475
141 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00041819767
203 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00034868567
325 The History of Histograms (abridged) 2003 VLDB 0.00027398081
329 Neo: A Learned Query Optimizer 2019 VLDB 0.00027301488
606 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00019251186
627 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00018959896
1,145 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.00013672625
1,194 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00013411666
1,372 Random Sampling over Joins Revisited 2018 SIGMOD 0.0001233325
1,379 Substring Selectivity Estimation 1999 PODS 0.00012280308
1,638 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00011050093
1,978 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 9.8764627e-05
2,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.955077e-05
3,229 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.3390133e-05
4,352 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 6.2542257e-05
5,630 Monotonic Cardinality Estimation of Similarity Selection: A Deep Learning Approach 2020 SIGMOD 5.4010111e-05
7,473 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 4.7149077e-05
8,685 Wander Join: Online Aggregation for Joins 2016 SIGMOD 4.4624568e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,382 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 5.0835686e-05
9,727 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 4.2901665e-05
4,431 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.1870601e-05
9,947 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 4.2391999e-05
3,455 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 7.0760196e-05
7,220 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 4.7926382e-05
7,473 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 4.7149077e-05
804 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001643674
10,216 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 4.1905499e-05
9,725 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 4.290223e-05