OLAP-Tools for the Formation of Connected and Diversified Production and Project Management Systems

Abstract

This article is devoted to the problem of the ability to represent business processes of complex systems of project and production management as a set of interacting semantically defined objects. To solve this problem, multidimensional modeling based on OLAP technology is proposed. The model covering the information system is presented in the form of a Metabase, which contains information about each type of instance of an independent business process. A mathematical description of the model of the subject area from the standpoint of OLAP-tools is given. It is proposed to use a multidimensional data model as a hypercube, the edges of which are sequences of values of the analyzed parameters for multidimensional analysis of the subject area. A multidimensional database is considered as an object archive designed to store the attributes of passive and active objects. Each OLTP system is an implementation of the subject area model and is mapped to a multidimensional matrix as OLAP-cube. The application of this concept in a Web-based environment is covered.