Design and Implementation of ETL Management Tool

被引：1
|
作者：
Fang Ying-lan [1 ]
Han Bing [1 ]
机构：
[1] N China Univ Technol, Coll Informat Engn, Beijing, Peoples R China
来源：
2009 SECOND INTERNATIONAL SYMPOSIUM ON KNOWLEDGE ACQUISITION AND MODELING: KAM 2009, VOL 1 | 2009年
关键词：
component; ETL; data; database; extract rule; conversion rule;
D O I：
10.1109/KAM.2009.105
中图分类号：
TP301 [理论、方法];
学科分类号：
081202 ;
摘要：
ETL is an important foundation of building data warehouse. Users extract the required data from the data source. and after clean the data, in accordance with pre-defined model of good data warehouse, data will be loaded into the data warehouse. The article has designed and implemented a common management tool for ETL according to the principle of ETL and the project actual needs. It can not only support DB2, Oracle, SQL Server and MYSQL and so on databases conversions but also itself custom extraction, conversion rules, and may have deploy scheduling tasks at any time. ETL management tool provides a good application platform for data analysis in decision-making.
引用
收藏
页码：446 / 449
页数：4
相关论文
共 50 条
  • [1] DESIGN AND IMPLEMENTATION OF AN ETL APPROACH
    Muntean, Mihaela I.
    PROCEEDINGS OF THE 16TH INTERNATIONAL CONFERENCE ON INFORMATICS IN ECONOMY (IE 2017): EDUCATION, RESEARCH & BUSINESS TECHNOLOGIES, 2017, : 270 - 276
  • [2] UnifiedViews: An ETL tool for RDF data management
    Knap, Tomas
    Hanecak, Peter
    Klimek, Jakub
    Mader, Christian
    Necasky, Martin
    Van Nuffelen, Bert
    Skoda, Petr
    SEMANTIC WEB, 2018, 9 (05) : 661 - 676
  • [3] Design and Implementation of ETL Strategy in Tele-Communication Based on the Tool of Teradata Data Warehouse
    Zhang Qinhe
    Li Min
    2011 INTERNATIONAL CONFERENCE ON FUTURE MANAGEMENT SCIENCE AND ENGINEERING (ICFMSE 2011), VOL 1, 2011, 5 : 31 - 36
  • [4] Design and implementation of an efficient database management tool
    Guo, Zhongyi
    Huang, Yingzhen
    Qian, Rongxin
    Liu, Zheyuan
    Gu, Rongjie
    Advances in Intelligent Systems and Computing, 2021, 1244 AISC : 113 - 119
  • [5] Design and implementation of a laboratory practicals management tool
    Langa, HM
    2004 IEEE AFRICON: 7TH AFRICON CONFERENCE IN AFRICA, VOLS 1 AND 2: TECHNOLOGY INNOVATION, 2004, : 965 - 968
  • [6] 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
  • [7] Design and Implementation of Resource Management Tool for Virtual Machine
    Kim, Byung Ki
    Yoo, Young Jun
    Yoo, Chuck
    Ko, Young Woong
    COMPUTER APPLICATIONS FOR COMMUNICATION, NETWORKING, AND DIGITAL CONTENTS, 2012, 350 : 17 - +
  • [8] Design and Implementation of a Tool for the Analysis and Management of Cardiac Parameters
    Aguilera Perez, Jorge
    Gonzalez Fernadez, Rene
    2016 COMPUTING IN CARDIOLOGY CONFERENCE (CINC), VOL 43, 2016, 43 : 377 - 380
  • [9] Design and Implementation of ETL in Police Intelligence Data Warehouse System
    Shen Liangzhong
    Liu Shihua
    Chen Shengkai
    FRONTIERS OF MANUFACTURING AND DESIGN SCIENCE II, PTS 1-6, 2012, 121-126 : 3865 - +
  • [10] Design of ETL provenance tool based on minimal attribute set
    1600, Association for Computing Machinery, 2 Penn Plaza, Suite 701, New York, NY 10121-0701, United States (Part F132530):
12345