摘要： 该文重点研究基于关系型数据库如何组织数据以满足多维分析的需要，即如何对星形模式的维表进行分解，分解成多个具有层次关系的、标准化的、低粒度的维表，以易于实现由上而下（ｄｒｉｌｌ ｄｏｗｎ）及由下而上（ｒｏｌｌ ｕｈｐ）的数据挖掘（ｄａｔａ ｍｉｎｉｎｇ）．

关键词: 多维数据, ROLAP, 元数据, 事实表, 维表, 属性表

Abstract: This paper firstly compares ROLAP(OLAP based on relational database) and MOLAP(OLAP based on Multidlinensional database), and then focus on the data storage mode of ROLAP.We decompose the dimension table of star mode into hierarchical, normalized and small dimension tables so that it would be easy to drill down and roll up which is generally called data mining.

中图分类号: 

• TP311