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 66
- Downloads 0
STUDY OF THE CRYPTOGRAPHIC STRENGTH OF THE S-BOX OBTAINED ON THE BASIS OF EXPONENTIATION MODULO
This article presents one of the main transformations of symmetric block ciphers used to protect confidential information, a new method for obtaining a non-linear S block, and an analysis of the results obtained. The S-b...
MATHEMATICAL SIMULATION AND STUDY OF CONTROL STABILITY OF THE CHEMICAL-ENGINEERING PROCESSES IN INDUSTRY
This work is considered to study analysis of dynamic system for simulation of the technological process under uncertainty and complexity. To study and simulate a complicated technology process the technical scheme of r...
DEVELOPMENT OF THE STRUCTURE OF AN AUTOMATED SYSTEM FOR DIAGNOSING DISEASES
Today, the importance of information support for various medical technologies has increased significantly. The use of modern information technologies is becoming a critical factor in the development of most branches of k...
DEVELOPMENT OF A LINEAR REGRESSION MODEL BASED ON VEGETATION INDICES OF AGRICULTURAL CROPS
The article is devoted to the study of vegetation indices for assessing the productivity of agricultural crops of the North Kazakhstan Agricultural Experimental Station (NKAES) LLP. The research was carried out using a m...
RESEARCH OF QUANTUM KEY DISTRIBUTION PROTOCOLS: BB84, B92, E91
The proposed article is devoted to the investigation of quantum key distribution protocols. The idiosyncrasy of this theme lies within the truth that present day strategies of key distribution, which utilize classical...