期刊名称：International Journal of Computer Science and Network Security
印刷版ISSN：1738-7906
出版年度：2006
卷号：6
期号：4
页码：36-41
出版社：International Journal of Computer Science and Network Security
摘要：Pre-aggregation is one of the most effective techniques in OLAP to ensure quick responses to user queries in data warehouses. Partial pre-aggregation is used widely, and the technique usually requires that the hierarchies of a dimension are onto, covering and self-onto. However, in real-world applications, many irregular dimensions do not meet the requirements. To solve the problem, in this paper, we propose a new dimension model to support the modeling of irregular dimensions based on extended directed Hasse graph. The model can express various relationships among dimension levels and different relationships among elements in the domain of a dimension. The model can also avoid aggregation loops in a dimension and ensure correct aggregation paths in the dimension by controlling the directions of paths and disallowing isolated nodes in EDH graphs. Thus, it can support both regular and irregular dimensions.
