文章基本信息

标题：Optimization of ETL Work Flow in Data Warehouse
本地全文：下载
作者：Kommineni Sivaganesh ; P Srinivasu ; Dr Suresh Chandra Satapathy 等
期刊名称：International Journal on Computer Science and Engineering
印刷版ISSN：2229-5631
电子版ISSN：0975-3397
出版年度：2012
卷号：4
期号：09
页码：1579-1586
出版社：Engg Journals Publications
摘要：ETL is responsible for extracting the information or data from different several Areas and applies some cleaning, customization, transformation function for data and finally loading into the data warehouse. This paper presents , to implement the one ETL scenario with the help of ARKTOS II. It is a stepwise process, firstly to design the conceptual model for the ETL scenario it contains the quick documentation which contains their relationships, attributes and transformation among them. Next one is a formal logical model for the ETL scenario, it contains the flow of data from the sources towards the data warehouse through the transformations and data stores. ETL processes handle the large volume of data, and managing the workload. It is a complex task and expensive operations in terms of time and system resources. Therefore to minimize the time required for completion of ETL workflow and resources needed for the ETL tasks. So that we implement the optimization for the ETL workflows, in the minimizing the total cost of the ETL scenario.
关键词：Extraction; Transformation; Loading; Conceptual Design; Logical Design; Optimization.