S.S. Mikhaylova1, E.S. Budaev2, S.D. Danilova3, Yu.A. Korablev4

1,2 Financial University under the Government of the Russian Federation (Moscow, Russia)
1 ssmihajlova@fa.ru, 2 esbudaev@fa.ru, 3 sddanilova@fa.ru, 4 yuakorablev@fa.ru

The management of the spatial development of the regions of the Russian Federation is complicated by fragmentation of data, heterogeneity of sources (statistics, departmental, municipal systems) and distortion of information during transmission between management levels, which prevents the formation of informed decisions.

Objective – to develop a conceptual model of a hybrid data warehouse for a decision support system (DSS) that provides integration, analysis and visualization of heterogeneous spatial development data.

A unified system of indicators has been formed for 8 thematic blocks (economy, society, infrastructure, ecology, etc.), consistent with the "Spatial Development Strategy of the Russian Federation until 2036." A hybrid storage architecture based on Modern Data Warehouse (MDW) with migration to Data Lake-house has been proposed. Implemented a system for assessing the reliability of data with a hierarchy of reliability sources (statistics → departmental → municipal → alternative).

The implementation of the model will increase the effectiveness of regional development management by optimizing data consolidation, supporting scenario forecasting and monitoring the region's spatial development strategy, and reducing reporting time for decision makers.

Public administration systems of the regions of the Russian Federation, analytical units of the Ministry of Economic Development of the Russian Federation, research institutes.

Mikhaylova S.S., Budaev E.S., Danilova S.D., Korablev Yu.A. Development of a hybrid data warehouse model for a decision support system in the field of spatial development of the region. Nonlinear World. 2025. V. 23. № 3. P. 107–116. DOI: https:// doi.org/10.18127/ j20700970-202503-13 (In Russian)

1. Breslin M. Data Warehousing Battle of the Giants: Comparing the Basics of the Kimball and Inmon Models. Business Intelligence Journal. 9. 2004.
2. Building a Scalable Data Warehouse with Data Vault 2.0 by Daniel Linstedt & Michael Olschimke, 2016.
3. Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh. James Serra. 2024.
4. Zaharia M.A., Ghodsi A., Xin R., Armbrust M. Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics. Conference on Innovative Data Systems Research. 2021.
5. Abu Hasan R., Kirienko A.B., Homonenko A.D. Metod perekhoda ot hranilishch dannyh k ozeram dannyh geoinformacionnyh sistem na osnove Lyambda-arhitektury. Intellektual'nye tekhnologii na transporte. 2024. № 1 (37). S. 45–55. DOI: 10.20295/ 2413-2527-2024-137-45-55 (In Russian).
6. Krugi Gromova – issledovanie russkih IT-vendorov i rossijskogo PO. URL: https://russianbi.ru/index.php#report (In Russian).
7. Landshaft Open Source Data Engineering v 2024 godu: mesto Rossii i mirovye tendencii. URL: https://habr.com/ru/articles/ 809427/ (In Russian).
8. Proektirovanie DWH. Data Modeling. Kimball, Data Vault 2.0, Anchor Modeling. URL: https://ivan-shamaev.ru/data-modeling-dwh-kimball-scd-types-data-vault-2-anchor-modeling/ (In Russian).