• DocumentCode
    3122951
  • Title

    Modeling and optimization of extraction-transformation-loading (ETL) processes in data warehouse: An overview

  • Author

    Anand, Nitin ; Kumar, Manoj

  • fYear
    2013
  • fDate
    4-6 July 2013
  • Firstpage
    1
  • Lastpage
    5
  • Abstract
    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.
  • Keywords
    data warehouses; ETL operations; ETL processes; data cleansing; data customization; data extraction; data transformation; data warehouse; extraction-transformation-loading processes; modeling; optimization; Data mining; Data models; Data warehouses; Databases; Loading; Unified modeling language; Warehousing; Data Mart; Data Quality (DQ); Data Staging Area; Data warehouse; ETL; Metadata; OLTP;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computing, Communications and Networking Technologies (ICCCNT),2013 Fourth International Conference on
  • Conference_Location
    Tiruchengode
  • Print_ISBN
    978-1-4799-3925-1
  • Type

    conf

  • DOI
    10.1109/ICCCNT.2013.6726592
  • Filename
    6726592