Тип публикации: доклад, тезисы доклада, статья из сборника материалов конференций
Конференция: 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 organizatiПоказать полностьюon. 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