Mapping conceptual to logical models for ETL processes

  • Authors:
  • Alkis Simitsis

  • Affiliations:
  • National Technical University of Athens

  • Venue:
  • Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.