• DocumentCode
    2456937
  • 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
  • fYear
    2012
  • fDate
    1-5 April 2012
  • Firstpage
    498
  • Lastpage
    509
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering (ICDE), 2012 IEEE 28th International Conference on
  • Conference_Location
    Washington, DC
  • ISSN
    1063-6382
  • Print_ISBN
    978-1-4673-0042-1
  • Type

    conf

  • DOI
    10.1109/ICDE.2012.66
  • Filename
    6228109