Сибирский федеральный университет

Тип публикации: доклад, тезисы доклада, статья из сборника материалов конференций

Конференция: International Workshop “Hybrid methods of modeling and optimization in complex systems” (HMMOCS 2022); Krasnoyarsk; Krasnoyarsk

Год издания: 2022

Идентификатор DOI: 10.15405/epct.23021.1

Ключевые слова: olap, hypercube, FASMI, multi-dimensional structure, analytics

Аннотация: This paper reveals the concept of an OLAP technology stack for solving problems of Big Data multidimensional analysis as applied to business process reengineering of operational and tactical management of an organization based on incoming information about the current state of the external and internal environment of the organization. The description of the technology, its modifications, as well as the possibilities of the technology and application cases are given. OLAP technology allows you to quickly demonstrate the necessary aggregated indicators to the user, i.e., forms a certain data structure at the request of each user. The payment for the efficiency of providing aggregated data is the need for disk space, where additionally generated data tables will be stored. It should also be noted that the MDX language is considered as the query language for the hypercube data, not the SQL language, since it is the most suitable for working with multidimensional data structures. Application areas of OLAP technology are BI-systems, CRM-systems, and organization management systems.

Журнал: HYBRID METHODS OF MODELING AND OPTIMIZATION IN COMPLEX SYSTEMS

Номера страниц: 1-10

Место издания: London, United Kingdom

Издатель: European Proceedings

• Sokolov V. A. (Siberian Federal University)
• Kuzmich R. I. (Siberian Federal University)
• Stupina A. A. (The Siberian Fire and Rescue Academy of State Firefighting Service of the Ministry of Russian Federation for Civil Defence, Emergencies and Elimination of Consequences of Natural Disasters)
• Ponomareva K. A. (Siberian Federal University)
• Pokushko M. V. (University of Cadiz)

• РИНЦ (eLIBRARY.RU)