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

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:

12 -04-2010


Online Published:

How to cite the Article

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


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.  


Data Warehouse, Data Mart, Pipelining, Nested  Pipelining.