Have a personal or library account? Click to login
Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases Cover

Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases

By: Marcin Pietroń  
Open Access
|Feb 2020

Abstract

Databases are a basic component of every GIS system and many geoinformation applications. They also hold a prominent place in the tool kit of any cartographer. Solutions based on the relational model have been the standard for a long time, but there is a new increasingly popular technological trend – solutions based on the NoSQL database which have many advantages in the context of processing of large data sets. This paper compares the performance of selected spatial relational and NoSQL databases executing queries with selected spatial operators. It has been hypothesised that a non-relational solution will prove to be more effective, which was confirmed by the results of the study. The same spatial data set was loaded into PostGIS and MongoDB databases, which ensured standardisation of data for comparison purposes. Then, SQL queries and JavaScript commands were used to perform specific spatial analyses. The parameters necessary to compare the performance were measured at the same time. The study’s results have revealed which approach is faster and utilises less computer resources. However, it is difficult to clearly identify which technology is better because of a number of other factors which have to be considered when choosing the right tool.

DOI: https://doi.org/10.2478/pcr-2019-0014 | Journal eISSN: 2450-6966 | Journal ISSN: 0324-8321
Language: English
Page range: 167 - 179
Submitted on: Oct 14, 2019
Accepted on: Nov 25, 2019
Published on: Feb 1, 2020
Published by: Polish Geographical Society
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2020 Marcin Pietroń, published by Polish Geographical Society
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.