Volume 4, Number 2 (3-2016)                   SCJ 2016, 4(2): 18-31 | Back to browse issues page


XML Persian Abstract Print


Download citation:
BibTeX | RIS | EndNote | Medlars | ProCite | Reference Manager | RefWorks
Send citation to:

Daneshpour N. Optimizing Process of Data Extraction, Transformation and Load in Data Warehouse Based on Parallel Processing. SCJ. 2016; 4 (2) :18-31
URL: http://scj.kashanu.ac.ir/article-1-262-en.html

1- Assistant Professor Shahid Rajaee Teacher Training University , ndaneshpour@srttu.edu
Abstract:   (838 Views)

Abstract

Data Warehouses are used to store data in a structure that facilitates data analysis. The process of Extracting, Transforming, and Loading (ETL) covers the process of retrieving required data from the source system and loading them to the data warehouse. Although the structure of source data (e.g. ER model) and DW (e.g. star schema) are usually specified, there is a clear lack of a standard model to represent the ETL scenarios. Using various tools, the ELT process is designed in many different ways based on the source and destination of data structure. The ETL process has time and cost bottlenecks in process of building DW. According to previously proposed different methods on reducing time and efficiency of the ETL process, this paper tries to propose a more efficient method. This paper represents a reduction of the execution time of the ETL process using the parallel processing techniques leading to reduction rate of 29% in execution time.

Full-Text [PDF 887 kb]   (388 Downloads)    
Type of Study: Research | Subject: Special
Received: 2015/07/31 | Accepted: 2015/10/18 | Published: 2016/09/21

Add your comments about this article : Your username or email:
Write the security code in the box

Send email to the article author


© 2015 All Rights Reserved | Soft Computing Journal

Designed & Developed by : Yektaweb