№2, 2024

Gulnara Nabibayova

The article highlights the main characteristics, features and structure of online analytical processing systems based on the same technology that perform online analytical processing of data. This technology allows analysts to explore and navigate a multidimensional indicator structure called an online analytical processing cube (data cube). Indicators (measures) of data cube play an important role in the decision-making process. To solve certain problems, these measures often need to be classified or grouped. Moreover, empty measures are common in data cube. This fact negatively affects strategic decision making. Unfortunately, online analytical processing itself is not well suited for classifying, clustering, and predicting empty measures of data cube in the presence of large data. In this regard, today there is a need to use new technologies to solve such problems. Such technologies include neural networks. The article discusses the problem of integrating online analytical processing and a neural network, showing the possibilities and advantages of such integration. It mentions that in the case of big data, the integration of online analytical processing technology and neural networks is very effective in solving problems of classification, clustering and empty measure prediction of data cube. An architectural and technological model for the integration of online analytical processing and neural networks is presented (pp.43-48).

Keywords:Data warehouse, OLAP, Artificial intelligence, Machine learning, Neural network, Forecasting, Clustering, Classification

Abdelbaki, W., Messaoud, R., Yahia, S. (2012). Neural-Based Approach for Extending OLAP to Prediction, in: Proceedings of science conference Data Warehousing and Knowledge Discovery (DaWaK 2012), Springer-Verlag Berlin Heidelberg, 117–129.

Abdelbaki, W., Yahia, S. Messaoud, R. (2015). Modular Neural Networks for Extending OLAP to Prediction. Book Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI, Springer Nature, 73-93.

Alguliyev, R. M., Nabibayova, G. Ch., Gurbanova, A. M. (2019). Development of a Decision Support System with the use of OLAP-Technologies in the National Terminological Information Environment, in: International Journal of Modern Education and Computer Science (IJMECS). 6, 43-52.

Artikova, M., Rasulova, Sh. (2021). Data classification using neural networks, in: Scientific Collection «InterConf»: Scientific Goals and Purposes in XXI Century, (78), 403-409.  https://ojs.ukrlogos.in.ua/index.php/interconf/article/view/15124 [in Russian].

Codd, E.F., Codd, S.B., Salley, C.T. (1993). Providing OLAP (on-line Analytical Processing) to User-analysts: An IT Mandate. http://www.estgv.ipv.pt/paginaspessoais/jloureiro/esi_aid2007_2008/fichas/codd.pdf.

Du, K.-L. (2010). Clustering: A neural network approach, in: Neural Networks, vol. 23, issue 1, 89-107.

Gulesian, M. (2008). Using Neural Networks and OLAP Tools to Make Business Decisions, https://www.developer.com/database/using-neural-networks-and-olap-tools-to-make-business-decisions/

Inmon, W.H. (2005). Building the Data Warehouse, John Wiley & Sons, pp. 596.

Iskanderova, Sh. (2023). The impact of artificial intelligence on the modern world, in: Science and Education Scientific Journal, Impact Factor 3.848. 4, 564-570. [in Russian]

Kohonen map. https://basegroup.ru/deductor/function/algorithm/kohonen [in Russian].

Kohonen neural network, self-organizing maps, learning, (2022). 
https://microtechnics.ru/nejronnaya-set-kohonena-samoorganizuyushhiesya-karty-obuchenie/ [in Russian].

Kumar, K., Krishna, R., Kumar, De S. (2005). Fuzzy OLAP Cube for Qualitative Analysis / Proceedings of the 3rd International Conference on Intelligent Sensing and Information Processing (ICISIP), 290-295, http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=1529464&tag=1

Main characteristics of OLAP systems, (2020). https://hsbi.hse.ru/articles/osnovnye-kharakteristiki-olap-sistem/ [in Russian].

McCulloch, W., Pitts, W. (1943). A logical calculus of the ideas immanent in nervous activity, in: Bulletin of Mathematical Biology, 5, 115–133.

Neural networks, perceptron.
https://neerc.ifmo.ru/wiki/index.php?title=Нейронные_сети,_перцептрон#cite_note-3 [in Russian].

Oreshko, V. (2021). Data classification using neural networks. https://loginom.ru/blog/neural-classification [in Russian].

Rosenblatt, F. (1958). The perceptron: a probabilistic model for information storage and organization in the brain, Psychological Review, 65(6), 386–408.

What is Online Analytical Processing (OLAP)? https://aws.amazon.com/ru/what-is/olap/ [in Russian].

Yunusova, L., Magsumova, A. (2019). Clustering using neural networks and searching for dependencies, 
https://cyberleninka.ru/article/n/klasterizatsiya-s-pomoschyu-neyronnyh-setey-i-poisk-zavisimostey-1 [in Russian].