Visual Design Editor for Schemes and Procedures of Filling OLAP Cubes in Multidimensional Databases

Intellectual Systems and Technologies

The development of OLAP cubes for use in business analysis systems requires coordinated actions of the database administrator and analyst. Their interaction is an iterative process, and it slows down the design of the storage component and generalization of the data. We have developed a new analytic tool, which will allow to perform most of the operations to control a logical and physical scheme. It will speed up the process of storage subsystem development. This tool, described in this paper, is a specialized graphic editor,. The paper formulates the requirements for graphical representation of OLAP cubes and ETL, requirements for editor functions and implementing the interface examples.

Citation:Popov S.G., Konenkov A.V., Samochadina T.N. Visual design editor for schemes and procedures of filling olap cubes in multidimensional databases. St. Petersburg State Polytechnical University Journal. Computer Science. Telecommunications and Control Systems, 2017, Vol. 10, No. 4, Pp. 107–117. DOI: 10.18721/JCSTCS.10410