Abstract
An increasing number of database management systems are expanding their functionality to work with various types of spatial data. This is true for both relational and NoSQL data models. The article describes the main features of those data models for which the functions of storing and processing spatial data are implemented. A comparative analysis of the performance of typical spatial queries for database management systems based on various data models, including multi-model ones, is carried out. The dataset on which the comparison is performed is presented in the form of three blocks of OpenStreetMap vector data for the territory of the Novosibirsk region. Based on the results of the study, recommendations are made on the use of certain data models, depending on the available data and the tasks to be solved.
Highlights
Today, most geographic information systems use the relational model as the main data storage model
The study consisted of the following blocks: formation of a set of vector spatial data, selection of NoSQL DBMS that allow making queries to spatial data, compiling a list of spatial queries that are identical in meaning, their implementation and formulation of conclusions
The relational database PostgreSQL with PostGIS and pgRouting modules was taken as the base DBMS with which the study compared NoSQL solutions [5]
Summary
Most geographic information systems use the relational model as the main data storage model. It can be implemented both in the format of the geographic information system itself, and using any third-party relational database management system [1]. Relational databases have a number of undeniable advantages [2], but alternative storage models (NoSQL) have received significant development, which have their advantages [3]. These positive aspects are considered in sufficient detail [4], but they do not always affect the side of storage and processing of spatial data. The main idea of the research described in the article was to compare the performance of DBMSs based on different data storage models when performing basic spatial queries
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
