data warehouse

The article analyzes modern approaches to the use of data warehouses and data lakes in the construction of information technology platforms for smart regions. Data processing technologies in data warehouses and data lakes allow for the integration, storage, and analysis of large amounts of information generated by various sources, including operational transaction systems, IoT sensors, and other data received in real time.

The examined approach to building an adaptive and convenient data warehouse goes beyond simple data storage, focusing on processing data for various types of reports. A hybrid concept for constructing the data warehouse is proposed, combining the advantages of existing methodologies and providing optimal interaction with the data warehouse for all users. The proposed method allows for the quick deployment, adaptive maintenance, and easy scalability of the data warehouse in the future.

Запропоновано описання функцій основних компонент концептуальної моделі системи підтримки прийняття рішень. Проаналізовано технології розроблення компо- нент системи прийняття рішень, визначено множину основних задач кожної зі складових.

Description of the functions of the basic components of the conceptual model of decision support systems. The analysis of technology development component of decision making, defined set of basic tasks of each of the components.

Запропоновано описання компонент концептуальної моделі системи підтримки прийняття рішень. Проаналізовано підходи до побудови концептуальної моделі, розгля- нуто підходи до проектування основних компонентів системи підтримки прийняття рішень.

In the article components of the conceptual model of the decision support system are described. The analysis of approaches to construction of conceptual model is conducted, approaches to planning of basic components of the decision support system are considered.

The interactive web application which consist of database, data warehouses, progressive mobile application and main web interface has been developed. It gives an opportunity create, send and the other proceed users' requests and also review, change, delete and transfer component elements, manage additional functions which are not available for simple user. The other important specification of developed app is ability to work offline.

This paper is devoted to the principles of constructing a software system of the aggregated data formation. The main principles of constructing a software system of the aggregated data formation are considered and their comparative analysis are carried out. An alternative principle of constructing a software system is proposed. This principle of constructing allows to eliminate the problems of fast and reliable data processing, scaling, automation of the software system components, improve data quality and security.

Description of architecture of the system of support of decision-making is offered in the article. The analysis of types of architecture is conducted, architecture of informative resource of the systems of support of decision-making, which is based on principles of construction of depository of information is considered.

This paper discusses the problems that arise when working with disparate data sources using database. The model of data warehouse is presented as way of integrating and processing data from disparate sources while creating a decision support system for the design of distributed energy systems.

This article describes the classification and approaches to the construction of DSS that take into account various aspects of the uncertainty of the development of DSS. Features of the classification were proposed and described. Generalized classification of DSS was improved. The analysis of the types of architecture, architecture reviewed information resource decision support systems, based on the principles of building a data warehouse.

In this article information from the management objects regarding the data consolidation processes obtained from both internal and external sources is collected and analyzed. On this basis data warehouse is built. Integration and analysis means of diverse input data of the region economic sphere are developed.