Modeling and Optimization of Extraction-Transformation-Loading (ETL) processes in Data Warehouse: An Overview

被引：0
|
作者：
Anand, Nitin [1 ]
Kumar, Manoj [1 ]
机构：
[1] AIACT&R, New Delhi, India
来源：
2013 FOURTH INTERNATIONAL CONFERENCE ON COMPUTING, COMMUNICATIONS AND NETWORKING TECHNOLOGIES (ICCCNT) | 2013年
关键词：
Data Mart; Data Quality (DQ); Data Staging Area; Data warehouse; ETL; Metadata; OLTP;
D O I：
暂无
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
ETL processes are responsible for the extraction of data from several sources, their cleansing, their customization and transformation, and finally, their loading into a data warehouse. In this paper we are reviewing the optimization of its execution plan. We review on the optimization of the sequence of the ETL operations involved in the overall process.
引用
收藏
页数：5
相关论文
共 50 条
  • [1] An Overview and Implementation of Extraction-Transformation-Loading (ETL) Process in Data Warehouse (Case Study: Department of Agriculture)
    Wijaya, Rahmadi
    Pudjoatmodjo, Bambang
    [J]. 2015 3rd International Conference on Information and Communication Technology (ICoICT), 2015, : 70 - 74
  • [2] Simulating Secure Data Extraction in Extraction Transformation Loading (ETL) Processes
    Mrunalini, M.
    Kumar, T. V. Suresh
    Kanth, K. Rajani
    [J]. 2009 THIRD UKSIM EUROPEAN SYMPOSIUM ON COMPUTER MODELING AND SIMULATION (EMS 2009), 2009, : 142 - +
  • [3] Extraction, Transformation, and Loading (ETL) module for hotspot spatial data warehouse using geokettle
    Astriani, Winda
    Trisminingsih, Rina
    [J]. 2ND INTERNATIONAL SYMPOSIUM ON LAPAN-IPB SATELLITE (LISAT) FOR FOOD SECURITY AND ENVIRONMENTAL MONITORING, 2016, 33 : 626 - 634
  • [4] A New Approach for Conceptual Extraction-Transformation-Loading Process Modeling
    Biswas, Neepa
    Chattapadhyay, Samiran
    Mahapatra, Gautam
    Chatterjee, Santanu
    Mondal, Kartick Chandra
    [J]. INTERNATIONAL JOURNAL OF AMBIENT COMPUTING AND INTELLIGENCE, 2019, 10 (01) : 30 - 45
  • [5] Real Time Data Warehouse Updates Through Extraction-Transformation-Loading Process Using Change Data Capture Method
    Thulasiram, Sunaadh
    Ramaiah, Nagaraj A.
    [J]. SECOND INTERNATIONAL CONFERENCE ON COMPUTER NETWORKS AND COMMUNICATION TECHNOLOGIES, ICCNCT 2019, 2020, 44 : 552 - 560
  • [6] RAMEPS: A REQUIREMENTS ANALYSIS METHOD FOR EXTRACTING-TRANSFORMATION-LOADING (ETL) PROCESSES IN DATA WAREHOUSE SYSTEMS
    Taa, Azman
    Abdullah, Mohd Syazwan
    Norwawi, Norita Md
    [J]. PROCEEDINGS OF THE 3RD INTERNATIONAL CONFERENCE ON COMMUNICATIONS AND INFORMATION TECHNOLOGY, 2009, : 15 - +
  • [7] Data extraction, transformation and loading tools in a data warehouse
    Zhou, Zhi-Kui
    Xu, Xian-Chuan
    [J]. Beijing Ligong Daxue Xuebao/Transaction of Beijing Institute of Technology, 2003, 23 (06): : 720 - 723
  • [8] A proposed model for data warehouse ETL processes
    El-Sappagh, Shaker H. Ali
    Hendawi, Abdeltawab M. Ahmed
    El Bastawissy, Ali Hamed
    [J]. JOURNAL OF KING SAUD UNIVERSITY-COMPUTER AND INFORMATION SCIENCES, 2011, 23 (02) : 91 - 104
  • [9] Requirements Analysis Method For Extracting-Transformation-Loading (ETL) In Data Warehouse Systems
    Taa, Azman
    Abdullah, Mohd Syazwan
    Norwawi, Norita Md
    [J]. COMPUTING & INFORMATICS, 2009, : 363 - 368
  • [10] A Systematic Literature Review on Big Data Extraction, Transformation and Loading (ETL)
    Nwokeji, Joshua C.
    Matovu, Richard
    [J]. INTELLIGENT COMPUTING, VOL 2, 2021, 284 : 308 - 324
12345