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 73
- Downloads 0
A MODEL OF AN AUTONOMOUS SMART LIGHTING SYSTEM USING SENSORS
Traditional street lighting systems receive data about daylight levels and adjust the lighting. However, in such conditions, energy consumption increases since the sensors of such systems receive data on only one indicat...
INFORMATION TECHNOLOGIES AND THE FUTURE OF EDUCATION IN THE REPUBLIC OF KAZAKHSTAN
The aim of the article is a comprehensive approach to addressing the digitalization of education in the Republic of Kazakhstan based on identifying problems in this area, forming priority tasks and possible ways to sol...
TRACKING OF NON-STANDARD TRAJECTORIES USING MPC METHODS WITH CONSTRAINTS HANDLING ALGORITHM
In recent decades, a Model-Based Predictive Control (MPC) has revealed its dominance over other control methods such as having an ability of constraints handling and input optimization in terms of the value function. H...
THE EXPERT SYSTEM OF CONTROL AND KNOWLEDGE ASSESSMENT
The article deals with the problem of objective knowledge assessment using expert automated systems for monitoring and evaluating knowledge. The expert systems of control and knowledge estimation are usually developed...
Statistical analysis of random walks on network
This paper describes an investigation of analytical formulas for parameters in random walks. Random walks are used to model situations in which an object moves in a sequence of steps in randomly chosen directions. Given...