• Jun 14, 2017 News!Vol.8, No.5 has been indexed by EI (Inspec).   [Click]
  • Nov 09, 2017 News!Vol.9, No.5 has been published with online version. 16 peer reviewed articles from 11 specific areas are published in this issue.   [Click]
  • Jul 19, 2017 News!Vol.9, No.4 has been published with online version. 16 peer reviewed articles from 16 specific areas are published in this issue.   [Click]
General Information
Editor-in-chief
Prof. Wael Badawy
Department of Computing and Information Systems Umm Al Qura University, Canada
I'm happy to take on the position of editor in chief of IJCTE. We encourage authors to submit papers concerning any branch of computer theory and engineering.
IJCTE 2013 Vol.5(3): 484-487 ISSN: 1793-8201
DOI: 10.7763/IJCTE.2013.V5.734

Revised Framework for ETL Workflow Management for Efficient Business Decision-Making

Saifur Rehman Malik, Azra Shamim, Zanib Bibi, Sajid Ullah Khan, and Shabir Ahmad Gorsi
Abstract—Business decision-making is not a simple task. There are many reasons for that but the main reason is data comes from heterogeneous operational sources of an organization. Therefore, it is difficult to organize and maintain especially if a huge volume of data is involved. A data warehouse is helpful in this regard as it can assists in business decision-making. Data collection and loading it into a data warehouse is difficult job because data sources are not in consistent form. This job usually consists of three main processes that involve extraction, transformation and loading. To extract the data from different sources, then transform it into a unified format and consequently load it into the warehouse, ETL (Extract, transform and load) tools are required. Nowadays, the majority of ETL tools organize workflow. An ETL workflow can be considered as a group of ETL jobs with dependencies between them. In this research paper a revised ETL workflow management framework which is based upon different considerations is proposed. These considerations along with the addition of the components in the workflow scheduling layer would help in making more effective and quality business decisions.

Index Terms—Data warehouse, ETL, ETL Tools, workflow management.

Azra Shamim is with the Faculty of Computer Science and Information Technology University Malaya (e-mail: azra.majeed864@yahoo.com).

[PDF]

Cite:Saifur Rehman Malik, Azra Shamim, Zanib Bibi, Sajid Ullah Khan, and Shabir Ahmad Gorsi, "Revised Framework for ETL Workflow Management for Efficient Business Decision-Making," International Journal of Computer Theory and Engineering vol. 5, no. 3, pp. 484-487, 2013.

Copyright © 2008-2015. International Journal of Computer Theory and Engineering. All rights reserved.
E-mail: ijcte@vip.163.com