Design and Realization of an ETL Method in Business Intelligence Project

被引：0
|
作者：
Pan, Bin [1 ]
Zhang, Guomin [1 ]
Qin, Xuepei [1 ]
机构：
[1] Xihua Univ, Ctr Radio Adm & Technol Dev, Chengdu, Sichuan, Peoples R China
来源：
2018 IEEE 3RD INTERNATIONAL CONFERENCE ON CLOUD COMPUTING AND BIG DATA ANALYSIS (ICCCBDA) | 2018年
关键词：
ETL; business intelligence; data warehouse; appraisal system; DATA WAREHOUSE;
D O I：
暂无
中图分类号：
TP301 [理论、方法];
学科分类号：
081202 ;
摘要：
Extract, Transform, Load (ETL) plays an important role in Business Intelligence (BI) project. Traditional ETL method is inflexible and inefficient when it is used for complex and changeable data transmission. Hence, it is necessary to improve the efficiency of ETL method. In this paper, a new ETL method based on Extract, Clean, Load, Transform and Load (ECL-TL) framework is designed and implemented. The ETL method in appraisal system is also discussed. The application shows that the ECL-TL method improves the efficiency and flexibility of the system.
引用
收藏
页码：275 / 279
页数：5
相关论文
共 50 条
  • [1] Design and Implementation of an ETL Approach in Business Intelligence Project
    Wang, Tieniu
    Hu, Jianhua
    Zhou, Haihe
    PRACTICAL APPLICATIONS OF INTELLIGENT SYSTEMS, 2011, 124 : 281 - 286
  • [2] The Research & Application of ETL tool in Business Intelligence Project
    Jun, Tang
    Kai, Cui
    Yu, Feng
    Gang, Tong
    2009 INTERNATIONAL FORUM ON INFORMATION TECHNOLOGY AND APPLICATIONS, VOL 2, PROCEEDINGS, 2009, : 620 - +
  • [3] Realization Business Intelligence in Commerce using Microsoft Business Intelligence
    Krneta, Dragoljub
    Radosav, Dragica
    Radulovic, Biljana
    2008 6TH INTERNATIONAL SYMPOSIUM ON INTELLIGENT SYSTEMS AND INFORMATICS, 2008, : 210 - +
  • [4] Business Intelligence: Performance and Sustainability Measures in an ETL Process
    Pereira, Andreia Penso
    Cardoso, Bruno Paula
    Laureano, Raul M. S.
    2018 13TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI), 2018,
  • [5] Leveraging Business Process Models for ETL Design
    Wilkinson, Kevin
    Simitsis, Alkis
    Castellanos, Malu
    Dayal, Umeshwar
    CONCEPTUAL MODELING - ER 2010, 2010, 6412 : 15 - 30
  • [6] DOD-ETL: distributed on-demand ETL for near real-time business intelligence
    Machado, Gustavo V.
    Cunha, Italo
    Pereira, Adriano C. M.
    Oliveira, Leonardo B.
    JOURNAL OF INTERNET SERVICES AND APPLICATIONS, 2019, 10 (01)
  • [7] The Design and Realization of Electrolytic Tinning Line (ETL) Control System
    Wang, Cuiping
    2012 THIRD INTERNATIONAL CONFERENCE ON TELECOMMUNICATION AND INFORMATION (TEIN 2012), 2012, : 67 - 70
  • [8] Design and realization of bank non-site auditing ETL
    Wang, Shan
    Information Technology Journal, 2013, 12 (24) : 8165 - 8170
  • [9] Business Intelligence and Analytics: On-demand ETL over Document Stores
    Souibgui, Manel
    Atigui, Faten
    Ben Yahia, Sadok
    Cherfi, Samira Si-Said
    RESEARCH CHALLENGES IN INFORMATION SCIENCE (RCIS 2020), 2020, 385 : 556 - 561
  • [10] Significance of Data Integration and ETL in Business Intelligence Framework for Higher Education
    Rodzi, Nur Alia Hamizah Mohamad
    Othman, Mohd Shahizan
    Yusuf, Lizawati Mi
    2015 International Conference on Science in Information Technology (ICSITech), 2015, : 181 - 186
12345