DBScholar

Back to papers

Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search

Summary: Adaptive framework for similarity join and search that selects per-object prefixes via a cost model, instead of fixed prefix-filtering. Efficient indexes enable dynamic prefix selection, yielding gains vs traditional prefix-filtering baselines. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h2b0ed84fa10c1dea
Venue
SIGMOD
Year
2012
Pagerank
0.00012777679
Overall Rank
966 | 93.53%
DOI
10.1145/2213836.2213847

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{wang_sigmod12,
        title = {{Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search}},
        author = {Wang, Jiannan and Li, Guoliang and Feng, Jianhua},
        series = {{SIGMOD} '12},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2213836.2213847},
        url = {https://dl.acm.org/doi/10.1145/2213836.2213847},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 43 of 43 citing papers.

Rank Citing Paper Year Venue Pagerank
679 JOSIE: Overlap Set Similarity Search for Finding Joinable Tables in Data Lakes 2019 SIGMOD 0.00014802
2,097 Open Data Integration 2018 VLDB 9.0397587e-05
2,235 String Similarity Joins: An Experimental Evaluation 2014 VLDB 8.7832223e-05
2,514 An Empirical Evaluation of Set Similarity Join Techniques 2016 VLDB 8.3446573e-05
2,570 Locality-Sensitive Hashing for Earthquake Detection: A Case Study of Scaling Data-Driven Science 2018 VLDB 8.2599759e-05
2,933 Leveraging Set Relations in Exact Set Similarity Join 2017 VLDB 7.827041e-05
3,359 An Efficient Partition Based Method for Exact Set Similarity Joins 2016 VLDB 7.3640394e-05
3,604 Overlap Set Similarity Joins with Theoretical Guarantees 2018 SIGMOD 7.1548073e-05
3,774 On the Complexity of Inner Product Similarity Join 2016 PODS 7.0102162e-05
3,849 QASCA: A Quality-Aware Task Assignment System for Crowdsourcing Applications 2015 SIGMOD 6.9657571e-05
4,167 Local Similarity Search for Unstructured Text 2016 SIGMOD 6.7547438e-05
4,515 Approximate String Joins with Abbreviations 2018 VLDB 6.5529885e-05
4,703 Learned Cardinality Estimation for Similarity Queries 2021 SIGMOD 6.4458272e-05
4,994 Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples 2021 SIGMOD 6.3099657e-05
5,233 String Similarity Measures and Joins with Synonyms 2013 SIGMOD 6.2049921e-05
5,467 Pigeonring: A Principle for Faster Thresholded Similarity Search 2019 VLDB 6.1037173e-05
5,779 Question Answering Over Knowledge Graphs: Question Understanding Via Template Decomposition 2018 VLDB 5.9804127e-05
5,923 Dima: A Distributed In-Memory Similarity-Based Query Processing System 2017 VLDB 5.9283659e-05
6,404 Human-in-the-loop Data Integration 2017 VLDB 5.7797097e-05
6,504 Nexus: Correlation Discovery over Collections of Spatio-Temporal Tabular Data 2024 SIGMOD 5.7456631e-05
6,617 A Pivotal Prefix Based Filtering Algorithm for String Similarity Search 2014 SIGMOD 5.7150599e-05
7,035 Efficient Similarity Join and Search on Multi-Attribute Data 2015 SIGMOD 5.5997831e-05
7,640 SyncSignature: A Simple, Efficient, Parallelizable Framework for Tree Similarity Joins 2023 VLDB 5.4624931e-05
7,728 Scalable Column Concept Determination for Web Tables Using Large Knowledge Bases 2013 VLDB 5.4515436e-05
7,854 Allign: Aligning All-Pair Near-Duplicate Passages in Long Texts 2021 SIGMOD 5.4230974e-05
8,717 TxtAlign: Efficient Near-Duplicate Text Alignment Search via Bottom-k Sketches for Plagiarism Detection 2022 SIGMOD 5.2705676e-05
9,158 Balance-Aware Distributed String Similarity-Based Query Processing System 2019 VLDB 5.2041319e-05
9,535 Set Similarity Search for Skewed Data 2018 PODS 5.151324e-05
9,778 LES3: Learning-based Exact Set Similarity Search 2021 VLDB 5.115551e-05
9,825 On-the-Fly Token Similarity Joins in Relational Databases 2014 SIGMOD 5.1084057e-05
9,918 Towards a Unified Framework for String Similarity Joins 2019 VLDB 5.0983269e-05
10,256 Near-Duplicate Sequence Search at Scale for Large Language Model Memorization Evaluation 2023 SIGMOD 5.0405429e-05
10,331 Local Filtering: Improving the Performance of Approximate Queries on String Collections 2015 SIGMOD 5.0228171e-05
10,332 Efficient and Effective KNN Sequence Search with Approximate n-grams 2014 VLDB 5.0228171e-05
10,929 Pail: Efficient kNN Search on Set-Valued Attributes 2026 VLDB 4.9605343e-05
11,400 Extensible and Robust Evaluation of Similarity Queries 2025 VLDB 4.9605343e-05
11,668 Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching 2024 VLDB 4.9605343e-05
11,748 Grouping Time Series for Efficient Columnar Storage 2023 SIGMOD 4.9605343e-05
11,809 A Two-Level Signature Scheme for Stable Set Similarity Joins 2023 VLDB 4.9605343e-05
11,863 TokenJoin: Efficient Filtering for Set Similarity Join with Maximum Weighted Bipartite Matching 2023 VLDB 4.9605343e-05
11,904 OpenTFV: An Open Domain Table-Based Fact Verification System 2022 SIGMOD 4.9605343e-05
12,277 ZigZag: Supporting Similarity Queries on Vector Space Models 2018 SIGMOD 4.9605343e-05
12,623 RCSI: Scalable similarity search in thousand(s) of genomes 2013 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank Cited Paper Year Venue Pagerank
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
169 Efficient Exact Set-Similarity Joins 2006 VLDB 0.00027077763
202 Efficient set joins on similarity predicates 2004 SIGMOD 0.00025244506
359 Efficient Parallel Set-Similarity Joins Using MapReduce 2010 SIGMOD 0.00019963275
934 Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints 2008 VLDB 0.00012973416
1,068 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012170201
1,928 ATLAS: A Probabilistic Algorithm for High Dimensional Similarity Search 2011 SIGMOD 9.3476482e-05
1,941 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 9.3141839e-05
2,084 Bed-Tree: An All-Purpose Index Structure for String Similarity Search Based on Edit Distance 2010 SIGMOD 9.0533042e-05
2,327 n-Gram/2L: A Space and Time Efficient Two-Level n-Gram Inverted Index Structure 2005 VLDB 8.6228658e-05
2,362 Hashed Samples: Selectivity Estimators For Set Similarity Selection Queries 2008 VLDB 8.5601252e-05
3,270 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD 7.4613275e-05
3,822 Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints 2010 VLDB 6.9814064e-05
4,138 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.7706361e-05
4,551 Power-Law Based Estimation of Set Similarity Join Size 2009 VLDB 6.5314641e-05
4,981 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3161219e-05
5,566 Faerie: Efficient Filtering Algorithms for Approximate Dictionary-based Entity Extraction 2011 SIGMOD 6.0651335e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,359 An Efficient Partition Based Method for Exact Set Similarity Joins 2016 VLDB
2 169 Efficient Exact Set-Similarity Joins 2006 VLDB
3 1,941 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB
4 8,434 Fast Approximate Similarity Join in Vector Databases 2025 SIGMOD
5 202 Efficient set joins on similarity predicates 2004 SIGMOD
6 2,933 Leveraging Set Relations in Exact Set Similarity Join 2017 VLDB
7 2,514 An Empirical Evaluation of Set Similarity Join Techniques 2016 VLDB
8 3,822 Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints 2010 VLDB
9 11,555 Similarity Joins of Sparse Features 2024 SIGMOD
10 7,035 Efficient Similarity Join and Search on Multi-Attribute Data 2015 SIGMOD