基于模型驱动体系架构的OLAP开发方法  

On-line analysis processing development method based on model driven architecture

作　　者：宋旭东[1,2] 胡墨谦[1] 刘晓冰[2] 

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

出　　处：《计算机集成制造系统》2010年第2期423-430,共8页Computer Integrated Manufacturing Systems

基　　金：国家自然科学基金资助项目(70572098)~~

摘　　要：传统的联机分析处理开发方法难以很好满足企业的决策需求,复杂性和高效性是OLAP系统开发面临的两大主要问题。为此,在数据仓库系统统一集成建模框架下,提出了一种新的基于模型驱动体系架构的联机分析处理开发方法。使用UML Profile和公共仓库元模型规范,建立了基于模型驱动体系架构的联机分析处理平台无关模型元模型和联机分析处理平台相关模型元模型,并采用查询/视图/转换规范的Relation语言建立了一套平台无关模型元模型到平台相关模型元模型的转换规则,在模型转换工具MediniQ VT和IBM的EMF框架下,实现了平台无关模型到平台相关模型的转换,通过自定义的从平台相关模型实例到结构化查询语言转换的Java类生成联机分析处理结构化查询语言代码,实现了模型驱动的联机分析处理软件开发过程。最后,通过某企业决策信息系统实际应用,验证了该方法的可行性和高效性。Traditional On-Line Analysis Processing （OLAP）development method was difficult to offer suitable solutions for enterprises＇ decision demands. Complexity and efficiency were the major problems concerning the development of OLAP system. To tackle these problems,a new OLAP development method based on Model Driven Architecture （MDA） in an integrated Data Warehouse （DW） modeling framework was proposed. By using UML Profile and Common Warehouse Metamodel （CWM）,OLAP Platform Independent Model （PIM） Meta-model and OLAP Platform Specific Model （PSM） Meta-model were constructed,a set of transformation rules from OLAP PIM meta-model to OLAP PSM meta-model by using the Query/View/Transformation （QVT） relation language was proposed,transformation between PIM model and PSM model under the model transformation tool-MediniQVT and IBM Eclipse Modeling Framework （EMF） was implemented,OLAP Structured Query Language （SQL） code by using user-defined transformation Java class between PSM model and SQL code was generated so that model-driven OLAP development was accomplished. Finally,this method was applied in practice and proved to be feasible and effective.

关 键 词：数据仓库 联机分析处理 模型驱动体系架构 查询/视图/转换 

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