CoDE Publications CoDE Publications
IRIDIA Publications IRIDIA Publications
SMG Publications
WIT Publications
WIT Publications
SMG Publications
Home People Research Activities Publications Teaching Resources
By Class By Topic By Year
By Class By Topic By Year
login
E. Malinowski and E. Zimányi. Hierarchies in a Multidimensional Model: From Conceptual Modeling to Logical Representation. Data & Knowledge Engineering, 59(2):348-377, 2006.

Abstract

Hierarchies are used in Data Warehouses (DWs) and On-Line Analytical Processing (OLAP) systems to see data at different levels of detail. However, many kinds of hierarchies arising in real-world situations are not addressed by current OLAP systems. Further, there is still no agreement on a conceptual model for DW and OLAP design that offers both a graphical representation and a formal definition. In this paper, we formally define the MultiDimER model, a conceptual multidimensional model that allows to represent facts with measures as well as the different kinds of hierarchies already classified in our previous work [25]. We also present the mapping of such hierarchies to the relational model, as well as their implementation in commercial DW products.


Updated: 2017-03-27