Title: EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing

Authors: Abdeltawab M.A. Hendawi; Shaker H. Ali El-Sappagh

Addresses: Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt. ' Information Systems Department, Faculty of Computers and Information, Minia University, El-Minia, Egypt

Abstract: During the last few years, researchers and developers had proposed various trials to put a standard conceptual design of ETL processes in data warehouse. These trials try to represent the main mapping activities at the conceptual level. Due to limitations of the previous trials, in this paper 1) We propose a model for conceptual design of ETL processes and we call it entity mapping diagram (EMD). The proposed model is built upon the enhancement of the models in the previous work to support some missing mapping features. 2) We implemented the proposed conceptual model in a prototype called EMD Builder and use it in an illustration scenario.

Keywords: ETL processes; data mart; online analytical processing; OLAP; conceptual modelling; intelligent information systems; entity mapping diagram; EMD; database systems; data warehousing; conceptual design; extraction; transformation; loading.

DOI: 10.1504/IJIIDS.2012.047003

International Journal of Intelligent Information and Database Systems, 2012 Vol.6 No.3, pp.255 - 272

Received: 15 Oct 2010
Accepted: 07 May 2011
Published online: 16 Aug 2014 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article