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 条
  • [31] The Design and Implementation of the Modeling Tool of the Six Sigma Project Management Model Based on Web
    Zhao, Xu
    Lin, Manshan
    2010 INTERNATIONAL CONFERENCE ON INFORMATION, ELECTRONIC AND COMPUTER SCIENCE, VOLS 1-3, 2010, : 1574 - 1576
  • [32] Design, Development and Implementation of a Network Intrusion Detection Tool for Air Traffic Management Systems
    de Riberolles, Theobald
    2018 48TH ANNUAL IEEE/IFIP INTERNATIONAL CONFERENCE ON DEPENDABLE SYSTEMS AND NETWORKS WORKSHOPS (DSN-W), 2018, : 96 - 99
  • [33] The Design and Implementation of Secure Program Design Education Tool
    Yu, Qinrui
    Xu, Jinsheng
    Yu, Huiming
    Yuan, Xiaohong
    PROCEEDINGS OF THE 12TH INTERNATIONAL CONFERENCE ON COMPUTER SUPPORTED EDUCATION (CSEDU), VOL 1, 2020, : 319 - 324
  • [34] Workflow management for ETL development
    Smith, Aaron W.
    Rahman, Nayem
    Schmitt, Jacob J.
    JOURNAL OF DECISION SYSTEMS, 2013, 22 (04) : 319 - 331
  • [35] A framework for the design of ETL scenarios
    Vassiliadis, P
    Simitsis, A
    Georgantas, P
    Terrovitis, M
    ADVANCED INFORMATION SYSTEMS ENGINEERING, PROCEEDINGS, 2003, 2681 : 520 - 535
  • [36] A Service-Oriented Framework for ETL Implementation
    Oliveira, Bruno
    Leite, Mario
    Oliveira, Oscar
    Belo, Orlando
    PROGRESS IN ARTIFICIAL INTELLIGENCE, EPIA 2022, 2022, 13566 : 636 - 647
  • [37] Script-based Automation ETL Tool
    Li, Ji-zhe
    Kuang, Bei-jing
    Liu, Jin-gang
    PROCEEDINGS OF THE 2016 6TH INTERNATIONAL CONFERENCE ON MANAGEMENT, EDUCATION, INFORMATION AND CONTROL (MEICI 2016), 2016, 135 : 968 - 972
  • [38] Records Management: Design and Implementation
    Schneider, Rene
    ZEITSCHRIFT FUR BIBLIOTHEKSWESEN UND BIBLIOGRAPHIE, 2011, 58 (02): : 108 - 108
  • [39] SPATIAL ETL TOOL FOR BETTER INTEROPERABILITY IN GIS
    Sustersic, Katja
    Podobnikar, Tomaz
    GEODETSKI VESTNIK, 2013, 57 (04) : 719 - 733
  • [40] Design of Literature Management Tool
    Liao, Xiaojing
    CROSS-CULTURAL DESIGN: APPLICATIONS IN MOBILE INTERACTION, EDUCATION, HEALTH, TRANSPORT AND CULTURAL HERITAGE, CCD 2015, PT II, 2015, 9181 : 230 - 240
12345