PAPER DIGEST
Most Influential SIGMOD 2009 Paper · 2026-03 edition

Entity Resolution With Iterative Blocking

Steven Euijong Whang; David Menestrina; Georgia Koutrika; Martin Theobald; Hector Garcia-Molina

Venue
ACM SIGMOD Conference (SIGMOD) 2009
Recognition
Most Influential SIGMOD 2009 Paper (Rank No. 7)
Edition
2026-03
Impact factor
6
Certificate ID
d3fd7ca6f7da0ed7

Abstract

Entity Resolution (ER) is the problem of identifying which records in a database refer to the same real-world entity. An exhaustive ER process involves computing the similarities between pairs of records, which can be very expensive for large datasets. Various blocking techniques can be used to enhance the performance of ER by dividing the records into blocks in multiple ways and only comparing records within the same block. However, most blocking techniques process blocks separately and do not exploit the results of other blocks. In this paper, we propose an <i>iterative blocking framework</i> where the ER results of blocks are reflected to subsequently processed blocks. Blocks are now iteratively processed until no block contains any more matching records. Compared to simple blocking, iterative blocking may achieve higher accuracy because reflecting the ER results of blocks to other blocks may generate additional record matches. Iterative blocking may also be more efficient because processing a block now saves the processing time for other blocks. We implement a scalable iterative blocking system and demonstrate that iterative blocking can be more accurate and efficient than blocking for large datasets.

Download PDF certificate