a proposed model for data warehouse etl processes：模型数据仓库etl过程.pdfVIP

Journal of King Saud University – Computer and Information Sciences (2011) 23, 91– 104 King Saud University Journal of King Saud University – Computer and Information Sciences .sa ORIGINAL ARTICLE A proposed model for data warehouse ETL processes Shaker H. Ali El-Sappagh a,*, Abdeltawab M. Ahmed Hendawi b, Ali Hamed El Bastawissy b a Mathematics Department, College of Science, King Saud University, Saudi Arabia b Information Systems Department, Faculty of Computers and Information, Cairo University, Cairo, Egypt Received 19 September 2010; accepted 23 February 2011 Available online 8 May 2011 KEYWORDS Abstract Extraction–transformation–loading (ETL) tools are pieces of software responsible for Data warehouse; the extraction of data from several sources, its cleansing, customization, reformatting, integration, ETL processes; and insertion into a data warehouse. Building the ETL process is potentially one of the biggest tasks Database; of building a warehouse; it is complex, time consuming, and consume most of data warehouse pro- Data mart; ject’s implementation efforts, costs, and resources. Building a data warehouse requires focusing clo- OLAP; sely on understanding three main areas: the source area, the destination area, and the mapping area Conceptual modeling (ETL processes). The source area has standard models such as entity relationship diagram, and the de