WEB OLAP conceptual data model design on the basis of situationoriented database

Abstract

Realization of the Web OLAP providing formation of hypercubes "on the fly" from situation-oriented database (SODB) is discussed. The architecture of an OLAPapplication on the basis of SODB is considered. The database ER-model as a basis of the conceptual multidimensional model which is setting a set of potential hypercubes is used. Design of hypercubes dimensions and measures are discussed. The approach is illustrated on an example of multidimensional activity model for dissertational councils of higher education institution.