Skip to content
DSML.KZ
Publications

Article · Scientific Journal of Astana IT University · March 30, 2022

MULTIDIMENSIONAL DATABASES IN INFORMATION SYSTEMS OF UNIVERSITIES

Assel Mukasheva, Didar Yedilkhan, M. Aldiyar

Assel Mukasheva
Open via DOI

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, andmost importantly in a short time. The article discusses the capabilities of multidimensionaldatabases, in particular, multidimensional OLAP (On-Line Analytical Processing) cubes whenanalyzing large amounts of data. Provides an overview and features of a multidimensionaldatabase and discusses the steps you need to take with a multidimensional database tounderstand the structure and capabilities of an OLAP cube. To create a knowledge base, itdescribes the steps you can take to create and execute a multidimensional database thatyou can collect from various sources, save to a database, and then prepare a report usingOLAP analysis. Various information system data processing technologies such as OLTP andOLAP were considered. The algorithm of the data storage process for analysis purposes wasstudied. A model of a multidimensional database in the form of a three-dimensional cubewas presented. Examples of analysis and ways of obtaining information from the data cubewere also given. The use of a multidimensional database in higher education institutions as asimple and effective method of data storage is considered. There are also illustrations of thestructure of a higher educational institution to see the bulkiness of information, and what kindof information database operates in the educational institution.

Big Data and Business IntelligenceAdvanced Database Systems and QueriesEngineering and Information Technologymultidimensional databasesdata cubesonline analytical processing

More by Assel Mukasheva