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

Data warehouses architecture based on uniform view and construction method

为了构建支持企业决策分析的数据仓库,分析了传统数据仓库模型的局限性,提出了一个基于统一视图模型的数据仓库体系结构。该体系结构是在传统数据仓库模型的数据源和数据仓库之间增加一个统一标准层,并利用统一视图—资源数据和数据仓库—统一视图的两级映射,保证了数据的透明访问和模型本身良好的可用性,进而支持灵活的多数据仓库的构建。基于该体系结构,给出了统一视图模型的建立和数据仓库三层之间两级映射的方法,提出了一种新的基于统一视图模型的数据映射—抽取—装载数据仓库ETL建模过程,并开发了相应的数据仓库构建系统。应用表明,该体系结构是可行且有效的。

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 archi- tecture, 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.