EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing. (1st January 2012)

• Record Type: Journal Article
• Authors: Hendawi, Abdeltawab M.A.; Ali El-Sappagh, Shaker H.
• Is Part Of: International journal of intelligent information and database systems. Volume 6:Number 3(2012)
• Page Start: 255
• Page End: 272
• Publication Date: 2012-01-01
• Subjects: modelling ETL processes -- database -- data mart -- DM -- online analytical processing -- OLAP -- conceptual modelling -- intelligent information systems -- entity mapping diagram -- EMD -- database systems -- data warehouse -- DW; Database management -- Computer programs -- Periodicals; Information retrieval -- Computer programs -- Periodicals; Information storage and retrieval systems -- Computer programs -- Periodicals; Artificial intelligence -- Periodicals; Expert systems (Computer science) -- Periodicals; Intelligent agents (Computer software) -- Periodicals; 006.33
• Languages: English
• ISSNs: 1751-5858

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.