首页    期刊浏览 2024年11月10日 星期日
登录注册

文章基本信息

  • 标题: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.
国家哲学社会科学文献中心版权所有