DBScholar

Back to papers

Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently

Summary: Cost-based selection of variable-length grams for approximate string queries with VGRAM-style indexing. Dynamic programming yields tight lower bounds on shared grams and enables automatic gram discovery for workloads, linking gram choice to index structure and performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
4062
Venue
SIGMOD
Year
2008
Pagerank
9.1621686e-05
Overall Rank
2,103 | 85.58%
DOI
10.1145/1376616.1376655

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{yang_sigmod08,
        title = {{Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently}},
        author = {Yang, Xiaochun and Wang, Bin and Li, Chen},
        series = {{SIGMOD} '08},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1376616.1376655},
        url = {https://dl.acm.org/doi/10.1145/1376616.1376655},
        year = {2008}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank Citing Paper Year Venue Pagerank
2,459 WHAM: A High-throughput Sequence Alignment Method 2011 SIGMOD 8.550768e-05
3,193 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD 7.649474e-05
3,446 Efficient Approximate Entity Extraction with Edit Distance Constraints 2009 SIGMOD 7.4087786e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
4,359 Incremental Maintenance of Length Normalized Indexes for Approximate String Matching 2009 SIGMOD 6.7451753e-05
5,071 Fast Subtrajectory Similarity Search in Road Networks under Weighted Edit Distance Constraints 2020 VLDB 6.3761034e-05
5,667 Efficient Approximate Search on String Collections (Tutorial) 2009 VLDB 6.1279762e-05
5,726 Pigeonring: A Principle for Faster Thresholded Similarity Search 2019 VLDB 6.1079184e-05
6,182 Reference-Based Alignment in Large Sequence Databases 2009 VLDB 5.9493566e-05
6,858 A Generic Framework for Efficient and Effective Subsequence Retrieval 2012 VLDB 5.7523396e-05
9,613 On-the-Fly Token Similarity Joins in Relational Databases 2014 SIGMOD 5.2447096e-05
10,085 Local Filtering: Improving the Performance of Approximate Queries on String Collections 2015 SIGMOD 5.1559617e-05
10,086 Efficient and Effective KNN Sequence Search with Approximate n-grams 2014 VLDB 5.1559617e-05
10,505 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 5.093636e-05
11,929 ZigZag: Supporting Similarity Queries on Vector Space Models 2018 SIGMOD 5.093636e-05
12,247 LinkIT: Privacy Preserving Record Linkage and Integration via Transformations 2013 SIGMOD 5.093636e-05
12,442 SimDB: A Similarity-aware Database System 2010 SIGMOD 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank Cited Paper Year Venue Pagerank
107 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00033511706
158 Robust and Efficient Fuzzy Match for Online Data Cleaning 2003 SIGMOD 0.00028199923
200 Efficient set joins on similarity predicates 2004 SIGMOD 0.00025597287
254 Record Linkage: Similarity Measures and Algorithms 2006 SIGMOD 0.00023199211
1,040 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012466499
1,140 Estimating Alphanumeric Selectivity in the Presence of Wildcards 1996 SIGMOD 0.0001200574
1,427 Substring Selectivity Estimation 1999 PODS 0.00010812749
2,262 n-Gram/2L: A Space and Time Efficient Two-Level n-Gram Inverted Index Structure 2005 VLDB 8.8440146e-05
2,899 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.97814e-05
4,035 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.9439151e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,810 Dynamic Data Structures for Document Collections and Graphs 2015 PODS
2 10,085 Local Filtering: Improving the Performance of Approximate Queries on String Collections 2015 SIGMOD
3 11,081 An Evaluation of N-Gram Selection Strategies for Regular Expression Indexing in Contemporary Text Analysis Tasks 2025 VLDB
4 4,359 Incremental Maintenance of Length Normalized Indexes for Approximate String Matching 2009 SIGMOD
5 6,818 Space-efficient Substring Occurrence Estimation 2011 PODS
6 107 Approximate String Joins in a Database (Almost) for Free 2001 VLDB
7 4,776 An Efficient Index Structure for String Databases 2001 VLDB
8 2,899 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB
9 7,692 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD
10 1,040 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB