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 63
- Downloads 0
SYSTEMATIZATION OF INTERNATIONAL AND DOMESTIC EXPERIENCE IN PROJECT MANAGEMENT AIMED AT ADAPTING PUBLIC-PRIVATE PARTNERSHIPS TO THE IMPLEMENTATION OF SUSTAINABLE ENERGY DEVELOPMENT PROGRAMS
European countries are recognized leaders in the use of public-private partnerships in project management for large-scale infrastructure projects, including those that contribute to energy efficiency in various sectors...
SYSTEM OF PREVENTIVE АCTION OF CONSTRUCTION ENTERPRISES ON THE BASIS OF IDENTIFICATION OF ANTICRISIS POTENTIAL
Peculiarities of formation of anti-crisis potential of construction enterprises are considered. Construction companies are rapidly adapting to the requirements of the digital economy, transforming the management struct...
TASKS AND METHODS OF TEXT SENTIMENT ANALYSIS
The purpose of this article is to study one of the methods of social networks analysis – text sentiment analysis. Today, social media has become a big data base that social network analysis is used for various purposes...
NEURAL NETWORK MODELING AND OPTIMISING OF THE AGGLOMERATION PROCESS OF SULPHIDE POLYMETALLIC ORES
During the operation of the lead-zinc production while processing of polymetallic ores, problems arose related to the quality of products and the efficient use of equipment – agglomeration furnace and crushing apparatus...
INFORMATION AND ANALYTICAL TOOLS FOR MONITORING THE PRICES OF MATERIAL AND TECHNICAL RESOURCES (MTR) OF CONSTRUCTION
The article deals with features and principles of the price monitoring system for material and technical resources operating now in the road industry. To improve the process of information collection, processing, and a...