DBScholar

Back to papers

Estimating Alphanumeric Selectivity in the Presence of Wildcards

Summary: First study of alphanumeric selectivity with wildcards, using a suffix-tree-based structure built from a statistics pass over the database. Suffix-tree-based models guide selectivity estimation for LIKE predicates; empirical results on TPC‑D show five promising techniques. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h340c98db7908ec58
Venue
SIGMOD
Year
1996
Pagerank
0.0001170903
Overall Rank
1,164 | 92.20%
DOI
10.1145/233269.233341

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{krishnan_sigmod96,
        title = {{Estimating Alphanumeric Selectivity in the Presence of Wildcards}},
        author = {Krishnan, P. and Vitter, Jeffrey Scott and Iyer, Bala},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233341},
        url = {https://dl.acm.org/doi/10.1145/233269.233341},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 21 of 21 citing papers.

Rank Citing Paper Year Venue Pagerank
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
919 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013042589
1,068 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012170201
1,466 Substring Selectivity Estimation 1999 PODS 0.00010546176
2,105 Selectivity Estimation For Boolean Queries 2000 PODS 9.0253094e-05
2,158 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD 8.9272802e-05
2,232 Effective Phrase Prediction 2007 VLDB 8.7867154e-05
2,310 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB 8.6493038e-05
2,981 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.7739779e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
4,138 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.7706361e-05
4,545 XPathLearner: An On-Line Self-Tuning Markov Histogram for XML Path Selectivity Estimation 2002 VLDB 6.5366364e-05
5,977 Spatial Indexing in Microsoft SQL Server 2008 2008 SIGMOD 5.9106575e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
6,974 Space-efficient Substring Occurrence Estimation 2011 PODS 5.614352e-05
7,440 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 5.5118924e-05
8,186 CXHist: An On-line Classification-Based Histogram for XML String Selectivity Estimation 2005 VLDB 5.3653848e-05
8,988 Dynamic Data Structures for Document Collections and Graphs 2015 PODS 5.2305422e-05
10,070 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 5.0733319e-05
10,094 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 5.068372e-05
10,355 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0156513e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 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.0023948467
60 The Merge/Purge Problem for Large Databases 1995 SIGMOD 0.00039343755
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036394222
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020265363
1,317 Copy Detection Mechanisms for Digital Documents 1995 SIGMOD 0.00011042663
1,647 Combinatorial Pattern Discovery for Scientific Data: Some Preliminary Results 1994 SIGMOD 9.9747449e-05
3,279 Hypergraph based reorderings of outer join queries with complex predicates 1995 SIGMOD 7.4510308e-05
5,309 Practical Prefetching via Data Compression (extended abstract) 1993 SIGMOD 6.1726798e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 6,122 Optimization of Conjunctive Predicates for Main Memory Column Stores 2016 VLDB
2 3,371 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
3 4,138 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB
4 2,981 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB
5 960 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
6 10,355 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD
7 3,281 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB
8 2,105 Selectivity Estimation For Boolean Queries 2000 PODS
9 6,974 Space-efficient Substring Occurrence Estimation 2011 PODS
10 1,466 Substring Selectivity Estimation 1999 PODS