MULTIDIMENSIONAL DATABASES IN INFORMATION SYSTEMS OF UNIVERSITIES
Journal Title: Scientific Journal of Astana IT University - Year 2022, Vol 9, Issue 9
Abstract
The article is devoted to the description of the method of multidimensional database, which is an effective method of data storage, which allows analyzing data qualitatively, and most importantly in a short time. The article discusses the capabilities of multidimensional databases, in particular, multidimensional OLAP (On-Line Analytical Processing) cubes when analyzing large amounts of data. Provides an overview and features of a multidimensional database and discusses the steps you need to take with a multidimensional database to understand the structure and capabilities of an OLAP cube. To create a knowledge base, it describes the steps you can take to create and execute a multidimensional database that you can collect from various sources, save to a database, and then prepare a report using OLAP analysis. Various information system data processing technologies such as OLTP and OLAP were considered. The algorithm of the data storage process for analysis purposes was studied. A model of a multidimensional database in the form of a three-dimensional cube was presented. Examples of analysis and ways of obtaining information from the data cube were also given. The use of a multidimensional database in higher education institutions as a simple and effective method of data storage is considered. There are also illustrations of the structure of a higher educational institution to see the bulkiness of information, and what kind of information database operates in the educational institution.
Authors and Affiliations
A. Mukasheva, D. Yedilkhan, M. Aldiyar
Keywords
Related Articles
- EP ID EP712429
- DOI 10.37943/AITU.2022.53.85.008
- Views 82
- Downloads 0
Intelligent dam breach threat monitoring system
The article is devoted to the development of a river flow modeling technique. The paper considers possible approaches to modeling the flow of fluids, as well as an analysis of existing solution methods and the formulat...
DISTRIBUTION OF ETHEREUM BLOCKCHAIN ADDRESSES
In the contemporary world, Ethereum is a very reliable financial saving among cryptocurrencies. It is also well known as a blockchain platform for creating and launching its own cryptocurrency. The applications run on...
DEVELOPMENT OF A QUESTION ANSWERING CHATBOT FOR BLOCKCHAIN DOMAIN
Large Language Models (LLMs), such as ChatGPT, have transformed the field of natural language processing with their capacity for language comprehension and generation of human-like, fluent responses for many downstream t...
EFFECTIVE MANAGEMENT AND OPTIMIZATION OF BUSINESS PROCESSES
This article discusses the problems of introducing an effective business, as well as optimizing business processes. Various approaches to managing and optimizing business processes are analyzed. The reasons for which it...
CONFIDENTIAL INFORMATION SECRET METHOD
The article deals with the issues of hiding text information in a graphic file. Most often, one or two least significant bits of the image pixels are modified. To do this, each byte of the secret message is divided into...