Data warehouses architecture based on uniform view and construction method
基于统一视图的数据仓库体系结构及其构建方法*

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.