ONE-TO-MANY DATA TRANSFORMATION OPERATIONS - Optimization and Execution on an RDBMS

Paulo Carreira, Helena Galhardas, João Pereira, Andrzej Wichert

2007

Abstract

The optimization capabilities of RDBMSs make them attractive for executing data transformations that support ETL, data cleaning and integration activities. However, despite the fact that many useful data transformations can be expressed as relational queries, an important class of data transformations that produces several output tuples for a single input tuple cannot be expressed in that way. To address this limitation a new operator, named data mapper, has been proposed as an extension of Relational Algebra for expressing one-to-many data transformations. In this paper we study the feasibility of implementing the mapper operator as a primitive operator on an RDBMS. Data transformations expressed as combinations of standard relational operators and mappers can be optimized resulting in interesting performance gains.

Paper Citation

in Harvard Style

Carreira P., Galhardas H., Pereira J. and Wichert A. (2007). ONE-TO-MANY DATA TRANSFORMATION OPERATIONS - Optimization and Execution on an RDBMS . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 21-27. DOI: 10.5220/0002371900210027

in Bibtex Style

@conference{iceis07,
author={Paulo Carreira and Helena Galhardas and João Pereira and Andrzej Wichert},
title={ONE-TO-MANY DATA TRANSFORMATION OPERATIONS - Optimization and Execution on an RDBMS},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={21-27},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002371900210027},
isbn={978-972-8865-88-7},
}

in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ONE-TO-MANY DATA TRANSFORMATION OPERATIONS - Optimization and Execution on an RDBMS
SN - 978-972-8865-88-7
AU - Carreira P.
AU - Galhardas H.
AU - Pereira J.
AU - Wichert A.
PY - 2007
SP - 21
EP - 27
DO - 10.5220/0002371900210027