Multidimensional indexing structure development for the optimal formation of aggregated indicators in OLAP hypercube

Abstract

In this paper calculation and formation of aggregational values being the main elements of operative analysis of multidimensional data, in the form of hypercube and the development of effective correlation structure to the data during the process of the analytical analysis are considered. In the course of writing, basic concepts of multidimensional data model and internal structure are given. Measurements used for the implementation of hypercube and for the description of dimension elements the secuence of sets theory is applied. Pre-calculation of all aggregation values for quick operative analysis and in order to carry out the effective correlation to the values received in the result of calculation, multidimensional indexing are developed. In this structure, in accordance with the primary keys intersection of dimensional elements multidimensional indexing structure having been formed and pre-aggregation is made for the initial quantitative values through the formed multidimensional indexing structure. Pre-aggregation values in separate structure is stored and according to multidimensional indexing the pointer is installed to the aggregational value address. This means one multidimensional index matched with one value. After the termination of pre-aggregational values calculation, calculations of aggregational values that are solved in all the intersections of the values are considered. In the end of paper conclusion and literature are given.