DBScholar

Back to papers

The Case For Language Model Approximated LIKE Predicate

Summary: SMILE reframes wildcard LIKE as neural pattern decoding: a compact column-local language model translates complex LIKE predicates into small candidate sets, then verifies via hash lookups. Yields asymptotic, dataset-size-invariant evaluation, robust to drift, outperforming trigram/B+-tree indexes by large margins. (summarized by gpt-5.4-mini on Apr 11 2026)

Paper ID
h3100bb9b6fb2de85
Venue
SIGMOD
Year
2026
Pagerank
4.9605343e-05
Overall Rank
10,762 | 27.87%
DOI
10.1145/3786703
PDF
Download (CC BY 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@inproceedings{li_sigmod26,
        title = {{The Case For Language Model Approximated LIKE Predicate}},
        author = {Li, Yingze and Wang, Dong and Wang, Zixuan and Zhou, Yingli and Yan, Yu and Geng, Jian and Wang, Xinyue and Zeng, Ziqing and Wang, Hongzhi},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3786703},
        url = {https://dl.acm.org/doi/10.1145/3786703},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 43 of 43 cited papers.

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

Rank Cited Paper Year Venue Pagerank
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046249672
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
95 Potter's Wheel: An Interactive Data Cleaning System 2001 VLDB 0.00034319763
108 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00032945275
162 Robust and Efficient Fuzzy Match for Online Data Cleaning 2003 SIGMOD 0.00027626077
311 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021315058
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
647 Evaluating Top-k Selection Queries 1999 VLDB 0.00015165562
695 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014679058
774 FITing-Tree: A Data-aware Index Structure 2019 SIGMOD 0.00014063511
941 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012938573
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,068 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012170201
1,228 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.00011425748
1,529 Updatable Learned Index with Precise Positions 2021 VLDB 0.00010320909
1,751 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7128647e-05
2,019 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.1666472e-05
2,158 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD 8.9272802e-05
2,785 Interaction between Record Matching and Data Repairing 2011 SIGMOD 7.9995952e-05
2,844 SNARF: A Learning-Enhanced Range Filter 2022 VLDB 7.9291659e-05
3,328 Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift 2023 SIGMOD 7.4094448e-05
3,358 Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL 2024 VLDB 7.3650961e-05
3,435 AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics 2018 SIGMOD 7.2845431e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
3,715 The Case for a Learned Sorting Algorithm 2020 SIGMOD 7.0549546e-05
4,047 Magneto: Combining Small and Large Language Models for Schema Matching 2025 VLDB 6.8177935e-05
4,138 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.7706361e-05
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
4,538 Pattern Functional Dependencies for Data Cleaning 2020 VLDB 6.5398994e-05
4,833 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3834856e-05
4,915 Can Learned Models Replace Hash Functions? 2023 VLDB 6.3452789e-05
5,566 Faerie: Efficient Filtering Algorithms for Approximate Dictionary-based Entity Extraction 2011 SIGMOD 6.0651335e-05
6,404 Human-in-the-loop Data Integration 2017 VLDB 5.7797097e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
7,064 Human-in-the-loop Outlier Detection 2020 SIGMOD 5.5930864e-05
7,103 LITS: An Optimized Learned Index for Strings 2024 VLDB 5.5824915e-05
7,621 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 5.4664683e-05
7,863 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD 5.4220286e-05
9,176 One Seed, Two Birds: A Unified Learned Structure for Exact and Approximate Counting 2024 SIGMOD 5.200391e-05
9,742 Repairing Data through Regular Expressions 2016 VLDB 5.1183191e-05
10,070 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 5.0733319e-05
10,350 Stop Word and Related Problems in Web Interface Integration 2009 VLDB 5.0182149e-05
Previous Page 1 / 1 Next

Semantically Similar Papers