RUS  ENG
Full version
JOURNALS // Computing, Telecommunication and Control // Archive

St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Sys, 2017 Volume 10, Issue 4, Pages 107–117 (Mi ntitu197)

Intellectual Systems and Technologies

Visual design editor for schemes and procedures of filling OLAP cubes in multidimensional databases

S. G. Popov, A. V. Konenkov, T. N. Samochadina

Peter the Great St. Petersburg Polytechnic University

Abstract: 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.

Keywords: database, database management system, BI, analyst, system administrator, OLAP, ETL, schematic editor, graphical notation.

UDC: 004.652.4

DOI: 10.18721/JCSTCS.10410



© Steklov Math. Inst. of RAS, 2024