A Methodology for the Conceptual Modeling of ETL Processes

9 years 3 months ago
A Methodology for the Conceptual Modeling of ETL Processes
Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we propose a methodology for the earliest stages of the data warehouse design, with the goal of tracing the analysis of the structure and content of the existing data sources and their intentional mapping to the common conceptual data warehouse model. The methodology comprises a set of steps that can be summarized as follows: (a) identification of the proper data stores; (b) candidates and active candidates for the involved data stores; (c) attribute mapping between the providers and the consumers, and (d) annotation of the diagram with runtime constraints.
Alkis Simitsis, Panos Vassiliadis
Added 06 Jul 2010
Updated 06 Jul 2010
Type Conference
Year 2003
Authors Alkis Simitsis, Panos Vassiliadis
Comments (0)