DBScholar

Back to papers

Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance

Summary: Extends q-grams with wildcards to estimate selectivity for low-edit-distance string predicates, using replacement semilattices, string hierarchies, and combinatorial analysis. BasicEQ and optimized OptEQ outperform SEPIA in accuracy across three benchmarks. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h0fd04405fca72367
Venue
VLDB
Year
2007
Pagerank
7.7739779e-05
Overall Rank
2,981 | 80.02%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{lee_vldb07,
        title = {{Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance}},
        author = {Lee, Hongrae and Ng, Raymond T. and Shim, Kyuseok},
        journal = {PVLDB},
        series = {{VLDB} '07},
        volume = {33},
        pages = {195--206},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank Citing Paper Year Venue Pagerank
934 Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints 2008 VLDB 0.00012973416
1,941 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 9.3141839e-05
2,158 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD 8.9272802e-05
2,362 Hashed Samples: Selectivity Estimators For Set Similarity Selection Queries 2008 VLDB 8.5601252e-05
3,522 Efficient Approximate Entity Extraction with Edit Distance Constraints 2009 SIGMOD 7.2167201e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
4,551 Power-Law Based Estimation of Set Similarity Join Size 2009 VLDB 6.5314641e-05
4,878 Probabilistic String Similarity Joins 2010 SIGMOD 6.3569172e-05
5,566 Faerie: Efficient Filtering Algorithms for Approximate Dictionary-based Entity Extraction 2011 SIGMOD 6.0651335e-05
5,811 Efficient Approximate Search on String Collections (Tutorial) 2009 VLDB 5.9701598e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
7,440 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 5.5118924e-05
7,863 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD 5.4220286e-05
10,070 Cardinality Estimation of LIKE Predicate Queries using Deep Learning 2025 SIGMOD 5.0733319e-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
29 Fast Algorithms for Mining Association Rules 1994 VLDB 0.00051028332
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
919 Estimating the Selectivity of XML Path Expressions for Internet Scale Applications 2001 VLDB 0.00013042589
1,164 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001170903
1,466 Substring Selectivity Estimation 1999 PODS 0.00010546176
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
8,267 Indexing Mixed Types for Approximate Retrieval 2005 VLDB 5.3492332e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,105 Selectivity Estimation For Boolean Queries 2000 PODS
2 1,068 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB
3 3,270 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD
4 3,281 Multi-Dimensional Substring Selectivity Estimation 1999 VLDB
5 934 Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints 2008 VLDB
6 2,158 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD
7 108 Approximate String Joins in a Database (Almost) for Free 2001 VLDB
8 1,466 Substring Selectivity Estimation 1999 PODS
9 4,138 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB
10 7,863 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD