TITLE:
Hierarchical Datacubes
AUTHORS:
Mickaël Martin Nevot, Sébastien Nedjar, Lotfi Lakhal
KEYWORDS:
ROLAP Cubing, Data Warehouse, Datacube, Big Data, Business Intelligence, Hierarchical Cube, Hierarchical Dimensions
JOURNAL NAME:
Journal of Computer and Communications,
Vol.11 No.6,
June
30,
2023
ABSTRACT: Many approaches have been proposed to pre-compute data cubes in order to efficiently respond to OLAP queries in data warehouses. However, few have proposed solutions integrating all of the possible outcomes, and it is this idea that leads the integration of hierarchical dimensions into these responses. To meet this need, we propose, in this paper, a complete redefinition of the framework and the formal definition of traditional database analysis through the prism of hierarchical dimensions. After characterizing the hierarchical data cube lattice, we introduce the hierarchical data cube and its most concise reduced representation, the closed hierarchical data cube. It offers compact replication so as to optimize storage space by removing redundancies of strongly correlated data. Such data are typical of data warehouses, and in particular in video games, our field of study and experimentation, where hierarchical dimension attributes are widely represented.