Development of a Spatiotemporal Database for Evolution Analysis of the Moscow Backbone Power Grid

Currently in the field of transport geography, the spatial evolution of electrical networks remain globally understudied. Publicly available data sources, including remote sensing data, have made it possible to collect spatial data on electrical networks, but at the same time a suitable data structure for storing them has not been defined. The main purpose of this study was the collection and structuring of spatiotemporal data on electric networks with the possibility of their further processing and analysis. To collect data, we used publicly available remote sensing and geoinformation systems, archival schemes and maps, as well as other documents related to the Moscow power grid. Additionally, we developed a web service for data publication and visualization. We conducted a small morphological analysis of the evolution of the network to show the possibilities of working with the database using a Python script. For example, we found that the portion of new lines has been declining since 1950s and in the 2010s the portion of partial reconstruction reached its maximum. Thus, the developed data structure and the database itself provide ample opportunities for the analysis and interpretation of the spatiotemporal development of electric networks. This can be used as a basis to study other territories. The main results of the study are published on the web service where the user can interactively choose a year and two forms of power lines representation to visualize on a map.

Design aspects of hierarchical variable-intersecting database for storing bioecological parameters for solving problems of mathematical modeling of the population dynamics of Baikal organisms

The project model of the BaikalIntelli research platform is considered for universal storage, input and processing arbitrary spatio-temporal databases of bioecological parameters. Information technologies that allow implementing the basic functionality of the universal meta-mechanism (means) of data systematization are considered. The monitoring mechanism was tested by entering the spatiotemporal database «Spatio-temporal variability of oligochaete populations in the area of industrial wastewater discharge from the Baikal pulp and paper mill».

Spatiotemporal Query Algebra Based on Native XML

A formal algebra is essential for applying standard database-style query optimization to XML queries. We propose a spatiotemporal XML data model and develop such an algebra based on Native XML, for manipulating spatiotemporal XML data. After studying NXD spatiotemporal database and query framework, formal representation of spatiotemporal query algebra is investigated, containing logical structure of spatiotemporal database, data type system, and querying operations. It shows that the model and algebra lay a firm foundation for managing spatiotemporal XML data.

A SPATIOTEMPORAL AGGREGATION QUERY METHOD USING MULTI-THREAD PARALLEL TECHNIQUE BASED ON REGIONAL DIVISION

Existing spatiotemporal database supports spatiotemporal aggregation query over massive moving objects datasets. Due to the large amounts of data and single-thread processing method, the query speed cannot meet the application requirements. On the other hand, the query efficiency is more sensitive to spatial variation then temporal variation. In this paper, we proposed a spatiotemporal aggregation query method using multi-thread parallel technique based on regional divison and implemented it on the server. Concretely, we divided the spatiotemporal domain into several spatiotemporal cubes, computed spatiotemporal aggregation on all cubes using the technique of multi-thread parallel processing, and then integrated the query results. By testing and analyzing on the real datasets, this method has improved the query speed significantly.