Geoinformation system of decision support based on the geoportal spatial data storage

Main Article Content

Sergey Andrieiev
https://orcid.org/0000-0003-4256-2637
Volodymyr Zhilin
https://orcid.org/0000-0002-7342-3456

Abstract

The subject of the study is the development of a geographic information system for decision support (DSS), based on the storage of spatial data of the geoportal. The object of the study is the process of combining and integrating information containing various types of spatial data into the geoportal repository. The purpose of the work is to increase the efficiency of statistical and predictive analysis of geodata for reporting and supporting decision-making of geographic information tasks in real time. Conclusions. Based on the analysis of the architectures of modern decision-making systems, a structure of geoinformation DSS’s based on the spatial data storage of the geoportal is proposed. The main features and functions that are included in subsystems of such a DSS are analyzed, namely the functions of the subsystem for extracting, converting and loading data, the functions of the data storage subsystem and the data analysis subsystem. The consideration of mentioned subsystems DSS was carried out with a detailed study of their structural and functional schemes, analysis of existing technologies of processing and spatial information storage, as well as modern methods of geodata analysis. At the same time, a reasonable choice of a database management system for the practical implementation of a multidimensional geodatabase is made, which performs the functions of a spatial data storage as the basis of a DSS geoportal. A substantial analysis of Microsoft SQL Server Analysis Services (SSAS), as а base platform for the deployment of Business Intelligence (BI) analytical systems, a Unified Dimensional Model (UDM) as the core of Online Analytical Processing (OLAP) complex multidimensional data analysis technology was performed. The aspects of planning and programming the SSAS architecture, the features of developing multi-dimensional databases using SQL BI Development Studio (BIDS) and SQL Server Management Studio (SSMS), as well as the specifics of using SQL Server Integration Services (SSIS) to work with multi-dimensional databases are analyzed. Thus, the groundwork has been set for the development of geoinformation DSS using Microsoft SQL Server multidimensional data analysis tools to create a multidimensional spatial data storage of the geoportal. A methodology for software implementation of a spatial data multidimensional storage of a geoportal is also proposed. The proposed approaches to the development of geoinformation DSS based on the spatial data storage provide integration into the geoportal repository of information containing various types of spatial data. The software implementation of the multidimensional geoportal provides an efficiency level increase of statistical and predictive geodata analysis for reporting and supporting decision-making of geographic information tasks in a real time.

Article Details

How to Cite
Andrieiev, S., & Zhilin, V. (2020). Geoinformation system of decision support based on the geoportal spatial data storage. Advanced Information Systems, 4(2), 60–79. https://doi.org/10.20998/2522-9052.2020.2.11
Section
Methods of information systems synthesis
Author Biographies

Sergey Andrieiev, National Aerospace University named after N. Ye. Zhukovskiy "Kharkiv Aviation Institute", Kharkiv

Candidate of Technical Sciences, Associate Professor, Associate Professor of Geoinformation Technologies and Space Monitoring of the Earth Department

Volodymyr Zhilin, National Aerospace University named after N. Ye. Zhukovskiy "Kharkiv Aviation Institute", Kharkiv

Candidate of Technical Sciences, Associate Professor, Associate Professor of Geoinformation Technologies and Space Monitoring of the Earth Department

References

Andrieiev, S. and Zhilin, V. (2020), “Methodology of creation of atlases of historical cartographic models from data of aerophotography with the use of геоінформаційних technologies”, Advanced Information Systems, Vol. 4, No. 1, pp. 45-62, DOI: http://dx.doi.org/10.20998/2522-9052.2020.1.08

Andrieiev, S., Zhilin, V. and Melnyk, A. (2019), “The use of anamorphosis cartographic models for geodata analysis”, Advanced Information Systems, Vol. 3, No. 3, pp. 5-16, DOI: http://dx.doi.org/10.20998/2522-9052.2019.3.01

Andreev, S. and Zhilin, V. (2019), “Application of aerophotic data with unmanned aircraft for developing 3D models of terrain”, Control, navigation and communication systems: collection of scientific works, No. 1(53), Poltava NTU Yuri Kondratyuk, Poltava, pp. 3-16, DOI: http://dx.doi.org/10.26906/SUNZ.2019.1.003

Marakas, G.M. (1999), Decision support systems in the twenty-first century, Upper Saddle River, N.J, Prentice Hall.

Larichev, O.I. and Petrovsky V.A. (1987), “Decision Support Systems: The current state and prospects of their development”, The results of science and technology, Avg. Technical cybernetics, VINITI, Moscow, Vol. 21, pp. 131-164.

Bonczek, R.H., Holsapple, C. and Whinston, A.B. (1981), Foundations of Decision Support Systems, Acad. Press, New York.

Anisimova, O.L., Zraenko, D.Yu. and Komosko, V.V. (2010), ”Storage of spatial objects as a part of the regional node of IPD UrFO: model of storage”, Spatial data, No. 1, p. 62.

Inmon, W.H. (1991), Building the Data Warehouse, John Wiley & Sons, New-York, 312 p.

Weizmann, V.M. (2002), Design of economic information systems, MUBiNT, Yaroslavl, 213 p.

Terelyansky, P.V. (2009), Decision support systems. Experience of design, Volga State Techn. University, Volgograd, 127 p.

Shannon, K. (1963), Works on information theory and cybernetics, IIL, Moscow, 829 p.

Spirley, E. (2001), Corporate data warehouses. Planning, development, implementation, Williams, Moscow, 400 p.

Kuznetsov, S.D. (1998), Design and development of corporate information systems, Moscow, 120 p.

DSTU ISO 19101: 2002 (E) (2005), Geographic Information / Geomatics Complex, Geographic Information – Reference Model, Kyiv.

Serebryakov, S.V. and Bazhenov, Yu.D. (2008), “A new approach to the organization and storage of spatial data”, Geodesy and Cartography, Vol. 7.

Kosyakov, S.V. and Nikolsky N.V. (1997), “On the integration of GIS and applied software”, Materials of the GIS'97 forum, GIS-Association, Moscow.