摘要: 针对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#.
中图分类号:
向阳,王庆大,张迎春. MS OLAP数据立方自动增量更新的程序实现[J]. , 2005, 31(20): 79-.
XIANG Yang1,WANG Qingda2,ZHANG Yingchun3. Programming of Automatic and Incremental Update of Data Cube in MS OLAP[J]. , 2005, 31(20): 79-.