The development and implementation of a multidimensional relational database of fire danger metrological data

Abstract

The study designs and implements a multi-dimensional relational database of fire danger metrological information, as well as areas with vegetation. During conceptualization, OLAP algorithms are taken into account as applied to the selection of long-term meteodata and their mathematical processing presented by multidimensional hypercubes. When designing the SQL structure, a layered architecture of geographic information system (GIS) is used, including attribute and geographical characters. The data according to the technology is tested in the Jewish Autonomous Region. The database contains metrological information from five weather stations from 1960 to 2020 and five branches of local forest districts from 1997 to 2020. At present, data is being filled in for the Omsk Region, Primorsky Krai of the Russian Federation and the Osh Region of the Kyrgyz Republic.