loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Paulo Carreira 1 ; Helena Galhardas 2 ; João Pereira 2 and Andrzej Wichert 2

Affiliations: 1 Faculty of Sciences, University of Lisbon, Portugal ; 2 INESC-ID, Portugal

ISBN: 978-972-8865-88-7

ISSN: 2184-4992

Keyword(s): Data Warehousing, Data Cleaning, Data Integration, ETL, Query optimization.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems ; Legacy Systems

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.

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 100.24.113.182

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 3: ICEIS, ISBN 978-972-8865-88-7, pages 21-27. DOI: 10.5220/0002371900210027

@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 3: ICEIS,},
year={2007},
pages={21-27},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002371900210027},
isbn={978-972-8865-88-7},
}

TY - CONF

JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: 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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.