DBScholar

Back to papers

Substring Selectivity Estimation

Summary: Introduces MO (Maximal Overlap), a substring selectivity estimator using pruned count-suffix trees that leverages all maximal query substrings to produce better estimates. Proves MO dominates KVI under short‑memory strings and gives MOC/MOLC algs trading accuracy vs cost. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
1178
Venue
PODS
Year
1999
Pagerank
0.00010812749
Overall Rank
1,427 | 90.22%
DOI
10.1145/303976.304001

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{jagadish_pods99,
        address = {New York, NY, USA},
        series = {{PODS} '99},
        title = {{Substring Selectivity Estimation}},
        url = {https://dl.acm.org/doi/10.1145/303976.304001},
        doi = {10.1145/303976.304001},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Jagadish, H. V. and Ng, Raymond T. and Srivastava, Divesh},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank Citing Paper Year Venue Pagerank
257 The History of Histograms (abridged) 2003 VLDB 0.00023154793
901 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013334162
1,040 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012466499
1,170 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011827259
2,061 Selectivity Estimation For Boolean Queries 2000 PODS 9.2445049e-05
2,103 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD 9.1621686e-05
2,176 Effective Phrase Prediction 2007 VLDB 9.0172465e-05
2,899 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.97814e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
4,438 XPathLearner: An On-Line Self-Tuning Markov Histogram for XML Path Selectivity Estimation 2002 VLDB 6.7061802e-05
6,760 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.7826781e-05
6,818 Space-efficient Substring Occurrence Estimation 2011 PODS 5.7643154e-05
7,268 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 5.6597123e-05
8,021 CXHist: An On-line Classification-Based Histogram for XML String Selectivity Estimation 2005 VLDB 5.5055705e-05
8,810 Dynamic Data Structures for Document Collections and Graphs 2015 PODS 5.3654354e-05
9,844 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 5.2094602e-05
10,097 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.1502319e-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.0024089429
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
58 The Merge/Purge Problem for Large Databases 1995 SIGMOD 0.00040116748
118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031922279
267 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022798161
274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022645621
786 Universality of Serial Histograms 1993 VLDB 0.00014053885
992 Query Size Estimation by Adaptive Sampling (Extended Abstract) 1990 PODS 0.00012790174
1,140 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001200574
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,114 Approximate Substring Matching over Uncertain Strings 2011 VLDB
2 4,035 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB
3 7,692 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD
4 10,097 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD
5 901 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB
6 6,818 Space-efficient Substring Occurrence Estimation 2011 PODS
7 1,140 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD
8 2,899 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB
9 2,061 Selectivity Estimation For Boolean Queries 2000 PODS
10 3,207 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB