MULTIDIMENSIONAL DATABASES IN INFORMATION SYSTEMS OF UNIVERSITIES

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.