Highly Efficient String Similarity Search and Join over Compressed Indexes
Guorui Xiao, Jin Wang, Chunbin Lin, Carlo Zaniolo
Abstract
String similarity search and join are essential op-erations in many fields. Existing solutions adopt a filter-and-verification framework and build inverted indexes based on generated signatures to prune dissimilar candidates. While existing solutions mainly focus on improving the query processing performance, little attention is paid to reducing the inverted indexes' memory consumption. In cases where the index size is larger than the memory, users have to employ more expensive disk-based algorithms rather than in-memory ones. In this paper, we propose a flexible framework CSS to reduce the index size and keep high query performance for string search and join applications. It can be easily incorporated into a broad scope of existing frameworks. We first give improved solutions for offline inverted lists construction to better support string similarity search. Nevertheless, they cannot be applied in the problem of string similarity join where indexes are constructed online. To address this issue, we further propose the first approach for online construction of compressed inverted lists. We theoretically study a benefit model to help find the best trade-off between memory consumption and execution time, and then propose an adaptive compression approach based on it. Experimental results on large-scale datasets demonstrate that CSS can reduce the memory consumption by 3 to 5 times while having similar or even better query processing performance for a variety of string similarity search and join frameworks.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Your agent calls
Luneget_paper_fulltext
Free to start. No credit card required.
Terminal
Install the CLIlune papers fulltext ebea84fd-3b60-4656-83a8-e799cbe0c0a5Builds on1
Related papers
- MetricJoin: Leveraging Metric Properties for Robust Exact Set Similarity JoinsManuel Widmoser, Daniel Kocher, Nikolaus Augsten, Willi MannICDE 2023 · 4 citations
- A Two-Level Signature Scheme for Stable Set Similarity JoinsDaniel Ulrich Schmitt, Daniel Kocher, Nikolaus Augsten, Willi Mann et al.VLDB 2023 · 3 citations
- minIL: A Simple and Small Index for String Similarity Search with Edit DistanceZhong Yang, Bolong Zheng, Xianzhi Wang, Guohui Li et al.ICDE 2022 · 2 citations
- Boosting Graph Similarity Search through Pre-ComputationJongik KimSIGMOD 2021 · 10 citations
- SSC-Join: An Efficient Syntactic-Semantic Collaboration Based Set Semantic Similarity Join AlgorithmLianyin Jia, Chengchen Zeng, Mengjuan Li, Suprio Ray et al.ICDE 2026
