Skip to main navigation Skip to search Skip to main content

Time-completeness trade-offs in record linkage using adaptive query processing

  • Roald Lengu*
  • , Paolo Missier
  • , Alvaro A.A. Fernandes
  • , Giovanna Guerrini
  • , Marco Mesiti
  • *Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Applications that involve data integration among multiple sources often require a preliminary step of data reconciliation in order to ensure that tuples match correctly across the sources. In dynamic settings such as data mashups, however, traditional offline data reconciliation techniques that require prior availability of the data may not be applicable. The alternative, performing similarity joins at query time, is computationally expensive, while ignoring the mismatch problem altogether leads to an incomplete integration. In this paper we make the assumption that, in some dynamic integration scenarios, users may agree to trade the completeness of a join result in return for a faster computation. We explore the consequences of this assumption by proposing a novel, hybrid join algorithm that involves a combination of exact and approximate join operators, managed using adaptive query processing techniques. The algorithm is optimistic: it can switch between physical join operators multiple times throughout query processing, but it only resorts to approximate join operators when there is statistical evidence that result completeness is compromised. Our experiments show that sensible savings in join execution time can be achieved in practice, at the expense of a modest reduction in result completeness.

Original languageEnglish
Title of host publicationProceedings of the 12th International Conference on Extending Database Technology
Subtitle of host publicationAdvances in Database Technology, EDBT'09
Pages851-861
Number of pages11
DOIs
Publication statusPublished - 2009
Event12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09 - Saint Petersburg, Russian Federation
Duration: 24 Mar 200926 Mar 2009

Publication series

NameProceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09

Conference

Conference12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09
Country/TerritoryRussian Federation
CitySaint Petersburg
Period24/03/0926/03/09

ASJC Scopus subject areas

  • Computer Science Applications
  • Software

Fingerprint

Dive into the research topics of 'Time-completeness trade-offs in record linkage using adaptive query processing'. Together they form a unique fingerprint.

Cite this