Title :
Fuzzy Joins Using MapReduce
Author :
Afrati, Foto N. ; Sarma, Anish Das ; Menestrina, David ; Parameswaran, Aditya ; Ullman, Jeffrey D.
Author_Institution :
Nat. Tech. Univ. Athens, Athens, Greece
Abstract :
Fuzzy/similarity joins have been widely studied in the research community and extensively used in real-world applications. This paper proposes and evaluates several algorithms for finding all pairs of elements from an input set that meet a similarity threshold. The computation model is a single MapReduce job. Because we allow only one MapReduce round, the Reduce function must be designed so a given output pair is produced by only one task, for many algorithms, satisfying this condition is one of the biggest challenges. We break the cost of an algorithm into three components: the execution cost of the mappers, the execution cost of the reducers, and the communication cost from the mappers to reducers. The algorithms are presented first in terms of Hamming distance, but extensions to edit distance and Jaccard distance are shown as well. We find that there are many different approaches to the similarity-join problem using MapReduce, and none dominates the others when both communication and reducer costs are considered. Our cost analyses enable applications to pick the optimal algorithm based on their communication, memory, and cluster requirements.
Keywords :
data analysis; distributed processing; fuzzy set theory; Hamming distance; Jaccard distance; MapReduce job; data analytics; edit distance; fuzzy joins; optimal algorithm; similarity joins; similarity-join problem; Algorithm design and analysis; Approximation algorithms; Clustering algorithms; Computational modeling; Educational institutions; Hamming distance; Program processors;
Conference_Titel :
Data Engineering (ICDE), 2012 IEEE 28th International Conference on
Conference_Location :
Washington, DC
Print_ISBN :
978-1-4673-0042-1
DOI :
10.1109/ICDE.2012.66