Execution of data mappers

  • Authors:
  • Paulo Carreira;Helena Galhardas

  • Affiliations:
  • Oblog Consulting and FCUL, Carnaxide, Portugal;INESC-ID and IST, IST Taguspark, Porto Salvo, Portugal

  • Venue:
  • Proceedings of the 2004 international workshop on Information quality in information systems
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data mappers are essential operators for implementing data transformations supporting schema mapping and integration scenarios such as legacy data migration, ETL processes for data warehousing, data cleaning activities, and business integration initiatives. Despite their widespread use, no formalization of this important operation has been proposed so far. In this paper we propose the data mapper operator as an extension to the relational algebra. We supply a set of algebraic rewriting rules for optimizing queries that combine standard relational operators with data mappers. Finally, we propose algorithms for their efficient physical execution.