RDBMS support for one-to-many data transformations

Nuno Henrique Castro Melo Godinho de

Key information

Authors:

Nuno Henrique Castro Melo Godinho de (Nuno Henrique Castro Melo Godinho de Matos)

Supervisors:

João Carlos Serrenho Dias Pereira (João Carlos Serrenho Dias Pereira); Helena Isabel De Jesus Galhardas (Helena Isabel De Jesus Galhardas)

Published in

June 4, 2010

Abstract

Data transformations are essential in the context of data migration, data integration and data warehousing. A data transformation is the fundamental unit of work in each of these processes. One-to-many data transformations constitute a particular class of data transformations that produce several output records for each input record. We describe this class of data transformations, the contexts in which they are useful, and their sup- port by Relational technology. Furthermore, we compare three different Relational Database Management Systems (RDBMS) in regard to their performance and expressive power when faced with one-to-many data transformations.