基于统一视图数据仓库体系结构及其构建方法.docVIP

基于统一视图数据仓库体系结构及其构建方法 　　（1.大连交通大学, 辽宁 大连 116028； 2.大连理工大学, 辽宁 大连116024； 3.朝阳师范高等专科学校, 辽宁 ?┏?阳 122000） 　　 　　摘 要： 　　为了构建支持企业决策分析的数据仓库，分析了传统数据仓库模型的局限性，提出了一个基于统一视图模型的数据仓库体系结构。该体系结构是在传统数据仓库模型的数据源和数据仓库之间增加一个统一标准层，并利用统一视图―资源数据和数据仓库―统一视图的两级映射，保证了数据的透明访问和模型本身良好的可用性，进而支持灵活的多数据仓库的构建。基于该体系结构，给出了统一视图模型的建立和数据仓库三层之间两级映射的方法，提出了一种新的基于统一视图模型的数据映射―抽取―装载数据仓库ETL建模过程，并开发了相应的数据仓库构建系统。应用表明，该体系结构是可行且有效的。 　　关键词：统一视图模型； 数据仓库； 映射―抽取―装载； 抽取―转换―装载 　　中图分类号：TP311文献标志码：A 　　文章编号：1001-?B3695(2009)04-?B1384-?B02 　　 　　Data warehouses architecture based on uniform view and construction method 　　 　　SONG Xu-dong1, 2, YIN Xiao-ming1,3， SONG Liang1， LIU Xiao-bing2 　　(1. Dalian Jiaotong University, Dalian Liaoning 116028, China; 2. Dalian University of Technology, Dalian Liaoning 116024, China; ??3.Chaoyang Teachers College, Chaoyang Liaoning 122000, China） 　　 　　Abstract:To construct enterprise data warehouses supporting decision, a new data warehouses architecture based on uniform view model was proposed through analyzing the limitation of the traditional data warehouse model. In order to support flexible construction of data warehouses, uniform standard layer was added between source layer and data warehouse layer of tradition data warehouses model. In order to guarantee the transparency access and the usability, two mapping methods were adopted between uniform view layer and source data layer, between data warehouses layer and uniform view layer. Based on this architecture, construction method of uniform view model and mapping methods amongst data warehouses three-layer were given, ETL processes of data warehouses construction based on uniform view were provided, and relative data warehouses construction system was developed. The architecture has been applied in practice and proved to be effective. 　　Key words：uniform view model； data warehouses； mapping-extraction-loading；ETL 　　?オ? 　　企业在实施信息化技术的过程中积累了大量的设计、生产、库存、销售、采购和财务等业务数据，如何将企业海量业务数据转换为决策信息已成为目前企业信息化的难点和热点问题，数据仓库被认为是最好的解决方案。数据仓库是一个面向