数据仓库ETL元模型设计  

Design ETL Meta-model In Data Warehouses

作　　者：宋旭东[1] 闫晓岚[1] 刘晓冰[2] 杨莉国[1] 

机构地区：[1]大连交通大学软件学院,辽宁大连116028 [2]大连理工大学CIMS,辽宁大连116024

出　　处：《计算机仿真》2010年第9期106-108,119,共4页Computer Simulation

基　　金：国家自然科学基金项目;(70572098);产品知识资源管理理论与方法研究(70471056)

摘　　要：针对传统的ETL(Extract/Transform/Load)开发方法难以满足企业的决策需求,复杂性和高效性是ETL开发面临的两大主要问题。为此,在数据仓库系统统一集成建模框架下,为提高管理质量和快速性,提出一种数据仓库ETL元模型设计方法,取代了以往在特定的数据仓库中对ETL建模的方法,使得ETL过程较早地进入数据仓库设计阶段,实现了ETL与数据仓库在概念层上的无缝融合,减少了开发时间和成本代价。最后通过模型实际应用,验证了方法的可行性和高效性。Traditional methods of ETL development are difficult to meet the Enterprise decision-making needs. Complexity and highly efficiency are the primary problems concerning ETL tools. To deal with theses problems,we put forward a method of designing the ETL meta-model in the Data warehouse,which takes the place of ETL modeling in the special data warehouse,and the design of ETL can be specified in the early stages of a DW project. It achieved the seamless integration between ETL and data warehouse designed on conceptual level,and reduced the development time and cost. Finally,we prove our approach usability and efficiency by practical application of this model.

关 键 词：数据仓库 抽取-转换-加载 统一建模语言扩展 元模型 

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