摘要
在对数据仓库集成技术研究的基础上,结合一些有代表性的商用高端数据仓库产品,设计了一个基于数据仓库的集成框架MI-DAWA,并且实现了MI-DAWA对元数据管理工具、ETL工具、OLAP SERVER等商用高端数据仓库产品的集成,能有效提高数据仓库建设的效率,非专业人员也可快速实现一个数据仓库过程。MI-DAWA已经在本地某行业数据仓库及辅助决策系统中投入了实际应用。最终实现业务分析人员驱动的、程序化的数据仓库过程是MI_DAWA正待解决的问题。
One data warehouse integration framework MI-DAWA (metadata-based integrated framework for data warehouse) is presented based on the research of data warehouse integration technology and the incorporation of some representative high-tier commercial data warehouse products. Selected high-tier commercial data warehouse products such as the metadata management tools, ETL, OLAP SERVER are integrated with the framework and the overall efficiency is improved comparing with standalone application of these pro- ducts. The MI-DAWA framework is put into practice to support data warehouse system and assistant decision-making system in a local enterprise. In future, MI-DAWA framework will be extended to completely implement the process of programmable data warehourse driven by business analysts.
出处
《计算机工程与设计》
CSCD
北大核心
2008年第9期2250-2253,共4页
Computer Engineering and Design