Computer Engineering and Applications ›› 2010, Vol. 46 ›› Issue (35): 133-135.DOI: 10.3778/j.issn.1002-8331.2010.35.038

• 数据库、信号与信息处理 • Previous Articles     Next Articles

Design and implementation of special ETL pattern

XIE Ting-ting,LI Wei-hua   

  1. Department of Computer Science and Engineering,Northwestern Polytechnical University,Xi’an 710129,China
  • Received:2009-09-08 Revised:2009-11-24 Online:2010-12-11 Published:2010-12-11
  • Contact: XIE Ting-ting

专用ETL模式设计与实现

谢婷婷,李伟华   

  1. 西北工业大学 计算机学院,西安 710129
  • 通讯作者: 谢婷婷

Abstract: A special ETL subassembly is designed for command Decision-making Support System(DSS),and then it puts forward a construction model of “ETL + Meta-knowledge Base + interactive environment”.It is modeled based on CWM to optimize the metadata extraction of ETL and reduce development cycles.Data transformation which based on domain knowledge and interactive,extensible environment brings advantages,that increase efficiency for data transformation and realize complicated transformation logic,then it can give references for other DSS to construct their own ETL subassembly.

Key words: Weapon-Target Adapted Decision-making Support System(WTADSS), Data Extraction, Transformation and Loading(ETL), Common Warehouse Metamodel(CWM), meta-knowledge base, interactive environment

摘要: 以指挥决策支持系统为背景,构建一个专门针对该系统设计的ETL组件,由此提出专用ETL组件的“ETL+元知识库+交互式环境”的构建模式。该组件采用基于CWM建模的方式来优化对ETL元数据的提取并缩短开发周期。基于领域知识的匹配转换及交互式可扩展环境具有提高数据清洗转换效率,实现复杂转换逻辑的优势,并为各个决策支持系统构建自己的专用ETL组件提供参考。

关键词: 指挥决策支持系统, 抽取转换加载, 公共仓库元模型, 元知识库, 交互式

CLC Number: