Mapping conceptual to logical models for 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 previous line of research, we have presented a conceptual and a logical model for ETL processes. In this paper, we describe the mapping of the conceptual to the logical model. First, we identify how a conceptual entity is mapped to a logical entity. Next, we determine the execution order in the logical workflow using information adapted from the conceptual model. Finally, we provide a methodology for the transition from the conceptual to the logical model. Categories and Subject Descriptors H.2.1 [Database Management]: Logical design - data models, schema and subschema. General Terms Algorithms, Design. Keywords Data warehousing, ETL, conceptual modeling, logical modeling.

• Type: Conference
• Year: 2005
• Where: DOLAP
• Authors: Alkis Simitsis
• Keywords: Conceptual, DOLAP 2005, Information Management, Logical Entity, Logical Model