专用ETL模式设计与实现  

Design and implementation of special ETL pattern

作　　者：谢婷婷[1] 李伟华[1] 

机构地区：[1]西北工业大学计算机学院,西安710129

出　　处：《计算机工程与应用》2010年第35期133-135,162,共4页Computer Engineering and Applications

基　　金：国家"十一五"预研项目;国家部委专项基金~~

摘　　要：以指挥决策支持系统为背景,构建一个专门针对该系统设计的ETL组件,由此提出专用ETL组件的"ETL+元知识库+交互式环境"的构建模式。该组件采用基于CWM建模的方式来优化对ETL元数据的提取并缩短开发周期。基于领域知识的匹配转换及交互式可扩展环境具有提高数据清洗转换效率,实现复杂转换逻辑的优势,并为各个决策支持系统构建自己的专用ETL组件提供参考。A special ETL subassembly is designed for command Decision-making Support System（DSS）a,nd then it puts for-ward a construction model of＂ETL ＋ Meta-knowledge Base ＋ interactive environment.＂It is modeled based on CWM to op-timize the metadata extraction of ETL and reduce development cycles.Data transformation which based on domain knowl-edge and interactivee,xtensible environment brings advantagest,hat increase efficiency for data transformation and realize com-plicated transformation logict,hen it can give references for other DSS to construct their own ETL subassembly.

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

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]