Hierarchies in a multidimensional model: From conceptual modeling to logical representation

E. Malinowski, E. Zimányi
2006 Data & Knowledge Engineering  
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
more » ... ows 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.
doi:10.1016/j.datak.2005.08.003 fatcat:o7lzwffdgrdt3mnftbmysy4d4y