Stanford InfoLab Publication Server

Swoosh: A Generic Approach to Entity Resolution

Benjelloun, Omar and Garcia-Molina, Hector and Menestrina, David and Su, Qi and Whang, Steven Euijong and Widom, Jennifer (2005) Swoosh: A Generic Approach to Entity Resolution. Technical Report. Stanford.

WarningThere is a more recent version of this item available.



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 4 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.

Item Type:Techreport (Technical Report)
Uncontrolled Keywords:Entity resolution, record linkage, merge/purge, deduplication
Related URLs:Project Homepage
ID Code:708
Deposited By:Import Account
Deposited On:02 Mar 2005 16:00
Last Modified:22 Dec 2008 17:54

Available Versions of this Item

Download statistics

Repository Staff Only: item control page