Sciweavers

Share
DOLAP
2005
ACM

Mapping conceptual to logical models for ETL processes

10 years 6 months ago
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.
Alkis Simitsis
Added 14 Oct 2010
Updated 14 Oct 2010
Type Conference
Year 2005
Where DOLAP
Authors Alkis Simitsis
Comments (0)
books