作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

›› 2005, Vol. 31 ›› Issue (20): 79-.

• 论文 • 上一篇    下一篇

MS OLAP数据立方自动增量更新的程序实现

向阳,王庆大,张迎春   

  1. 同济大学电信学院,泰安市国家税务局,山东科技大学信息学院 上海 200092
  • 发布日期:2005-10-25

Programming of Automatic and Incremental Update of Data Cube in MS OLAP

XIANG Yang1,WANG Qingda2,ZHANG Yingchun3   

  1. (1.School of Telecommunications,Tongji University,Shanghai 200092;2.Taian Municipal State Taxation Bureau,Taian 271000;3.School of Information,Shandong University of Science and Technology,Taian 271019)
  • Published:2005-10-25

摘要: 针对MS OLAP对海量数据立方体进行完全更新非常耗时,以及在它的服务器管理器中实现数据立方体的手动增量更新操作繁琐,需要由熟悉MDX语言的专业人员完成的问题,文章提出了基于事实表上时间戳或其它标志的自动增量更新方案,并给出了C#编写的程序示例。

关键词: MSOLAP, 数据立方体, 自动增量更新

Abstract: MS OLAP service,a data warehouse software produced by Microsoft Corp is a time-consuming task to update cube completely.Although a cube can be updated by an incremental method manually in MS OLAP analysis manager,but it is so difficult and bothersome that only those being able to use MDX can accomplish it.This article gives a practical method of automatic and incremental update for data cube,and gives the programming sample developed in C#.

中图分类号: