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
关键词
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 条
  • [41] Network security design and its realization in CIMS project
    Jiang, M.
    Wang, B.Y.
    Chen, W.
    Jiang, D.Z.
    Ding, Q.L.
    Xiaoxing Weixing Jisuanji Xitong/Mini-Micro Systems, 2001, 22 (04):
  • [42] A multifrequency quadrature bridge for realization of the capacitance standard at ETL
    Nakamura, Y
    Fukushima, A
    Sakamoto, Y
    Endo, T
    Small, GW
    IEEE TRANSACTIONS ON INSTRUMENTATION AND MEASUREMENT, 1999, 48 (02) : 351 - 355
  • [43] Diagnosis of initial data to design a project model enabling the implementation of a business intelligence process for design and construction engineering companies in Cuba
    Garcia, Julio
    Macias, Jose A.
    REVISTA INGENIERIA DE CONSTRUCCION, 2010, 25 (02): : 267 - 284
  • [44] Enricommender: Business Intelligence for User Interface Design
    Ciarrone, Alexis
    Leiva, Luis A.
    Dubiel, Mateusz
    INTERACTING WITH COMPUTERS, 2024, 37 (01) : 1 - 17
  • [45] Improvement Design on the Data Structure of Business Intelligence
    Zhang Jing
    Tang Xuefei
    Liu Fei
    FUTURE COMPUTER, COMMUNICATION, CONTROL AND AUTOMATION, 2011, 119 : 313 - 321
  • [46] Process of Ontology Design for Business Intelligence System
    Dudycz, Helena
    Korczak, Jerzy
    INFORMATION TECHNOLOGY FOR MANAGEMENT, 2016, 243 : 17 - 28
  • [47] Business Intelligence and Big Data Systems Supporting Project Management
    Pondel, Jolanta
    Pondel, Maciej
    2015 SSR International Conference on Social Sciences and Information (SSR-SSI 2015), Pt 1, 2015, 10 : 227 - 232
  • [48] A Design Theory for Knowledge Transfer in Business Intelligence
    Vizecky, Karen
    AMCIS 2011 PROCEEDINGS, 2011,
  • [49] Design Issues in Social Business Intelligence Projects
    Golfarelli, Matteo
    BUSINESS INTELLIGENCE, EBISS 2015, 2016, 253 : 62 - 86
  • [50] Business intelligence systems: Design and implementation strategies
    Gangadharan, GR
    Swami, SN
    ITI 2004: PROCEEDINGS OF THE 26TH INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGY INTERFACES, 2004, : 139 - 144