A New Approach to Extraction Transformation Loading Using Pipelining

Trinity Journal of Management, IT & Media (TJMITM)
Year: 2010 (Jan-Dec), Volume: (1), Issue. (1)
First page: (07) Last page: (10)
Online ISSN: A/F
Print ISSN: 2320-6470
doi: 

A New Approach to Extraction Transformation Loading Using Pipelining
Dr. Rajender Singh Chhillar1 and Barjesh Kochar2

1Professor, CS Department, M.D.U.
2Head (MCA, IT), GNIM
Corresponding author email id:

Received:
12 -04-2010

Accepted:
15-06-2010

Online Published:
20-07-2010

How to cite the Article

This image has an empty alt attribute; its file name is images.png
View on Google Scholar

ABSTRACT

Companies have lots of precious data lying around  throughout their networks that needs to be moved  from one place to another such as from one business  centre to another or to a data warehouse for  analysis. The problem is that the data lies in  different sorts of heterogeneous systems, and  therefore in all sorts of formats. To accumulate  data at one place and to make strategic decisions  we need a data warehouse system. This consists of  extract, transform and load (ETL) software, which  extract data from various resources, transform it into  new data formats according to required information  needs, and then load it into desired data structure(s).  Such softwares take enormous time for the purpose.  To deal with the problem of time taken by ETL  process, in this paper we are presenting a new  technique of ETL using pipelining. We had divided  ETL process into various segments which worked  simultaneously using pipelining.  

KEYWORDS

Data Warehouse, Data Mart, Pipelining, Nested  Pipelining.