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 62
- Downloads 0
APPLICATION OF INFORMATION TECHNOLOGIES FOR SEMANTIC TEXT PROCESSING
An expert system for text analysis based on the heuristic knowledge of an expert linguist is proposed. Methods of linguistic analysis of the text through the use of computer technology have been further developed. Data...
ANALYSIS OF DYNAMICAL CHANGES FROM LARGE SET OF REMOTE SENSING IMAGES
Basic elements of changes on the multi-temporal satellite image and their basic sets of dynamic objects are formulated and defined, for which the main characteristics define the dynamic object as an area of motion. Suc...
USING OF ADDITIONAL METHODS OF USER AUTHORIZATION
The article considers the methods of additional authorization of users of information systems, their advantages, and disadvantages, typical examples of usage. Multifactor authentication is becoming a standard tool for...
SUBJECT BEHAVIOR DETECTION AND ANALYSIS BASED ON COMPUTER VISION TECHNOLOGY
This article discusses the current problem of identifying violations during distance learning during the final certification. The coronavirus (COVID-19) pandemic has served as a stimulus for innovation in the field of...
APPLICATION OF INFORMATION SYSTEMS AND TOOLS IN BIOINFORMATICS
The pace at which scientific data is produced and disseminated has never been as high as it is currently. Modern sequencing technologies make it possible to obtain the genome of a specific organism in a few days, and t...