数据仓库的多维数据模型研究

The Study of Multi-Dimension Data Model for Data Warehouse

作为数据仓库设计的核心和基础,数据模型的研究直接影响到决策支持技术的发展。该文首先在对OLAP的需要分析基础上,提出了研究数据模型应该满足的六点约束,并分析了现有模型的优缺点。然后,针对这六点约束,引进分维函数建立多维模型视图,利用聚集偏序集族定义维的结构,提出了一种多维数据模型,并给出了以OLAP操作为核心的操作代数。

To be the ba si c and core accept of data warehouse designing,the study of data model is effec ting the development of decision support technology deeply.In this paper,base d on the necessary of OLAP,six constraints of data modeling are presented.Afte r analysing the existing data models,under these constrains,a new data model i s presented,which has data model view with partition function,and uses the agg regation function to support the complex multi hierarchies.Along with the model ,an associated algebra that includes a set of OLAP operations and supports comp lex aggregation is also presented.