互联网 qkzz.net
全刊杂志网:首页 > 女性 > 文章正文
刊社推荐

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


□ 宋旭东 银晓明 宋 亮 刘晓冰

  (1.大连交通大学, 辽宁 大连 116028; 2.大连理工大学, 辽宁 大连116024; 3.朝阳师范高等专科学校, 辽宁 朝阳 122000)
  
  摘 要:
  为了构建支持企业决策分析的数据仓库,分析了传统数据仓库模型的局限性,提出了一个基于统一视图模型的数据仓库体系结构。该体系结构是在传统数据仓库模型的数据源和数据仓库之间增加一个统一标准层,并利用统一视图—资源数据和数据仓库—统一视图的两级映射,保证了数据的透明访问和模型本身良好的可用性,进而支持灵活的多数据仓库的构建。基于该体系结构,给出了统一视图模型的建立和数据仓库三层之间两级映射的方法,提出了一种新的基于统一视图模型的数据映射—抽取—装载数据仓库ETL建模过程,并开发了相应的数据仓库构建系统。应用表明,该体系结构是可行且有效的。
  关键词:统一视图模型; 数据仓库; 映射—抽取—装载; 抽取—转换—装载
  中图分类号:TP311文献标志码:A
  文章编号:1001-3695(2009)04-1384-02
  
  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. ......
很抱歉,暂无全文,若需要阅读全文或喜欢本刊物请联系《计算机应用研究》杂志社购买。
欢迎作者提供全文,请点击编辑
分享:
 

了解更多资讯,请关注“木兰百花园”
分享:
 
精彩图文


关键字
支持中国杂志产业发展,请购买、订阅纸质杂志,欢迎杂志社提供过刊、样刊及电子版。
关于我们 | 网站声明 | 刊社管理 | 网站地图 | 联系方式 | 中图分类法 | RSS 2.0订阅 | IP查询
全刊杂志赏析网 2017