2005 · 66 citations · 10 references
ComputingInformation SystemsInformation TechnologyData EngineeringData ManagementKnowledge MappingData IntegrationData MappingData ModelingData WarehousingDatabase DesignProcess ModelingConceptual Model DevelopmentConceptual Process ModelingData Warehouse DesignEtl ProcessingExtract (Etl) ProcessesExtract, Transform, Load (Etl)Logical Modeling
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.
10
Conceptual modeling for ETL processes
Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos · 2002 · 378 citations · Full text
Optimizing ETL Processes in Data Warehouses
Alkis Simitsis, Panos Vassiliadis, Timos Sellis · 2005 · 207 citations · Full text