数据仓库中的一种立方体数据模型

The Cube Data Model in Data Warehouses

数据仓库和联机分析处理(OLAP)是商业数据处理领域中的两个最重大的新技术。OLAP应用要求对数据仓库中存储的大量数据进行分析,用标准关系数据库技术来实现非常复杂的查询是相当困难的。所以,在数据仓库中,数据被组织成立方体数据模型。该文提出了一种简单、直观的数据立方体模型以及在这个立方体上支持OLAP操作的代数。为复杂的查询提供了简要的表述方法。

Data warehousing and On-Line Analytical Processing OLAP are two of the most significant new technologies in the business data processing area.OLAP refers to the technique of performing complex analysis over a larger amount information stored in a data warehouse.The complexity of queries required to support OLAP applications makes it difficult to implement using standard relational database technology.In data warehouse system,data are organized into data cube,This paper proposes a model of a data cube and an algebra to support OLAP operations on this cube.The model presented is simple and intuitive,and the algebra provides a means to concisely express complex OLAP queries.