The VLDB Journal

, Volume 18, Issue 1, pp 255–276

Swoosh: a generic approach to entity resolution

  • Omar Benjelloun
  • Hector Garcia-Molina
  • David Menestrina
  • Qi Su
  • Steven Euijong Whang
  • Jennifer Widom
Regular Paper

DOI: 10.1007/s00778-008-0098-x

Cite this article as:
Benjelloun, O., Garcia-Molina, H., Menestrina, D. et al. The VLDB Journal (2009) 18: 255. doi:10.1007/s00778-008-0098-x

Abstract

We consider the entity resolution (ER) problem (also known as deduplication, or merge–purge), in which records determined to represent the same real-world entity are successively located and merged. We formalize the generic ER problem, treating the functions for comparing and merging records as black-boxes, which permits expressive and extensible ER solutions. We identify four important properties that, if satisfied by the match and merge functions, enable much more efficient ER algorithms. We develop three efficient ER algorithms: G-Swoosh for the case where the four properties do not hold, and R-Swoosh and F-Swoosh that exploit the four properties. F-Swoosh in addition assumes knowledge of the “features” (e.g., attributes) used by the match function. We experimentally evaluate the algorithms using comparison shopping data from Yahoo! Shopping and hotel information data from Yahoo! Travel. We also show that R-Swoosh (and F-Swoosh) can be used even when the four match and merge properties do not hold, if an “approximate” result is acceptable.

Keywords

Entity resolutionGeneric entity resolutionData cleaning

Copyright information

© Springer-Verlag 2008

Authors and Affiliations

  • Omar Benjelloun
    • 1
  • Hector Garcia-Molina
    • 2
  • David Menestrina
    • 2
  • Qi Su
    • 2
  • Steven Euijong Whang
    • 2
  • Jennifer Widom
    • 2
  1. 1.Google Inc.Mountain ViewUSA
  2. 2.Computer Science DepartmentStanford UniversityStanfordUSA