Swoosh: a generic approach to entity resolution

被引:182
作者
Benjelloun, Omar [2 ]
Garcia-Molina, Hector [1 ]
Menestrina, David [1 ]
Su, Qi [1 ]
Whang, Steven Euijong [1 ]
Widom, Jennifer [1 ]
机构
[1] Stanford Univ, Dept Comp Sci, Stanford, CA 94305 USA
[2] Google Inc, Mountain View, CA 94043 USA
关键词
Entity resolution; Generic entity resolution; Data cleaning; INTEGRATION; LINKAGE;
D O I
10.1007/s00778-008-0098-x
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:255 / 276
页数:22
相关论文
共 39 条
  • [1] Ananthakrishna R., 2002, Proceedings of the Twenty-eighth International Conference on Very Large Data Bases, P586
  • [2] [Anonymous], 2003, 2003 ACM SIGMOD INT, DOI DOI 10.1145/872757.872796
  • [3] [Anonymous], P ACM SIGMOD INT C M
  • [4] [Anonymous], P ICDE TOK JAP
  • [5] [Anonymous], P ACM SIGMOD
  • [6] [Anonymous], 2005, WWW '05
  • [7] [Anonymous], 2006, CURRENT
  • [8] Arasu A., 2006, Proceedings of VLDB Endowment, P918
  • [9] Bansal N, 2002, ANN IEEE SYMP FOUND, P238, DOI 10.1109/SFCS.2002.1181947
  • [10] Baxter, 2003, P ACM SIGKDD 03 WORK