MULTIDIMENSIONAL DATABASES IN INFORMATION SYSTEMS OF UNIVERSITIES

2022

Full text Open access: Gold Metadata (CSL-JSON)
DOI 10.37943/aitu.2022.53.85.008
Data confidence 70 medium
How this score is calculated

It is built from checkable properties of the record itself: whether the article has a DOI, how many independent sources confirmed its data, whether the required fields are filled in, and how recent the latest confirmation is. Disagreement between sources and a missing identifier lower it. A value of 80 or above means the record was published without further checking; 60 to 79 means it is published at reduced confidence, with a manual check advisable. A record verified by an editor by hand is never pushed below 90 by a recalculation. This scores our data about the article, not the article itself.

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.