(1.大连交通大学, 辽宁 大连 116028; 2.大连理工大学, 辽宁 大连116024; 3.朝阳师范高等专科学校, 辽宁 朝阳 122000)
关键词:统一视图模型; 数据仓库; 映射—抽取—装载; 抽取—转换—装载
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. ......