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.

• Type: Conference
• Year: 2003
• Where: CAISE
• Authors: Alkis Simitsis, Panos Vassiliadis
• Keywords: CAISE 2003, Data Stores, Data Warehouse, Data Warehouse Design