Authors: E. Malinowski, E. Zimanyi
Tags: 2005, conceptual modeling
Hierarchies are used in data warehouses (DWs) and on-line analytical processing (OLAP) systems to see data at differ-ent levels of detail. However, many kinds of hierarchies arising in real-world situations are not addressed by current OLAPsystems. Further, there is still no agreement on a conceptual model for DW and OLAP design that offers both a graphicalrepresentation and a formal definition.In this paper, we formally define the MultiDimER model, a conceptual multidimensional model that allows to representfacts with measures as well as the different kinds of hierarchies already classified in our previous work [E. Malinowski,E. Zima ́nyi, OLAP hierarchies: a conceptual perspective, in: Proceedings of the 16th International Conference onAdvanced Information Systems Engineering, 2004, pp. 477–491]. We also present the mapping of such hierarchies tothe relational model, as well as their implementation in commercial DW products.Read the full paper here: https://reader.elsevier.com/reader/sd/pii/S0169023X0500145X?token=21A2D955D62F58F7D6874756F98BFB41828296AEA6B8986F05280364F877958B2E9765A354C4073D49C30BFA68FED97A
