Efficient and Scalable Processing of String Similarity Join

Chuitian Rong, Wei Lu, Xiaoli Wang, Xiaoyong Du, Yueguo Chen, Anthony K.H. Tung
2013 IEEE Transactions on Knowledge and Data Engineering  
The string similarity join is a basic operation of many applications that need to find all string pairs from a collection given a similarity function and a user specified threshold. Recently, there has been considerable interest in designing new algorithms with the assistant of an inverted index to support efficient string similarity joins. These algorithms typically adopt a two-step filter-and-refine approach in identifying similar string pairs: (1) generating candidate pairs by traversing the
more » ... inverted index; and (2) verifying the candidate pairs by computing the similarity. However, these algorithms either suffer from poor filtering power (which results in high verification cost), or incur too much computational cost to guarantee the filtering power. In this paper, we propose a multiple prefix filtering method based on different global orderings such that the number of candidate pairs can be reduced significantly. We also propose a parallel extension of the algorithm that is efficient and scalable in a MapReduce framework. We conduct extensive experiments on both centralized and Hadoop systems using both real and synthetic datasets, and the results show that our proposed approach outperforms existing approaches in both efficiency and scalability.
doi:10.1109/tkde.2012.195 fatcat:duymkqx6z5br5alidzx4vfju4i