Normalising OLAP cubes for controlling sparsity

Abstract

A poorly designed OLAP (on-line analytical processing) cube can have a size much larger than the volume of information, potentially leading to problems with performance and usability. We give a new normal form for OLAP cube design and synthesis and decomposition algorithms to produce normalised OLAP cube schemata. OLAP cube normalisation controls the structural sparsity resulting from inter-dimensional functional dependencies. We assume that functional dependencies are used to describe the constraints of the application universe of discourse. Our methods help the user to identify cube schemata with structural sparsity, and to change the design in order to obtain more economy of space. © 2003 Elsevier B.V. All rights reserved.