Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases
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...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Sciendo
2019-12-01
|
| Series: | Polish Cartographical Review |
| Subjects: | |
| Online Access: | https://doi.org/10.2478/pcr-2019-0014 |
| _version_ | 1818486193063460864 |
|---|---|
| author | Pietroń Marcin |
| author_facet | Pietroń Marcin |
| author_sort | Pietroń Marcin |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-12-10T16:19:44Z |
| format | Article |
| id | doaj.art-ea136542db2f45fb878b52ddbb760e76 |
| institution | Directory Open Access Journal |
| issn | 0324-8321 2450-6966 |
| language | English |
| last_indexed | 2024-12-10T16:19:44Z |
| publishDate | 2019-12-01 |
| publisher | Sciendo |
| record_format | Article |
| series | Polish Cartographical Review |
| spelling | doaj.art-ea136542db2f45fb878b52ddbb760e762022-12-22T01:41:53ZengSciendoPolish Cartographical Review0324-83212450-69662019-12-0151416717910.2478/pcr-2019-0014pcr-2019-0014Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databasesPietroń Marcin0Warsaw University of Technology, Faculty of Geodesy and Cartography, Department of CartographyDatabases 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.https://doi.org/10.2478/pcr-2019-0014spatial analysesspatial datamongodbpostgisefficiency |
| spellingShingle | Pietroń Marcin Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases Polish Cartographical Review spatial analyses spatial data mongodb postgis efficiency |
| title | Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases |
| title_full | Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases |
| title_fullStr | Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases |
| title_full_unstemmed | Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases |
| title_short | Analysis of performance of selected geospatial analyses implemented on the basis of relational and NoSQL databases |
| title_sort | analysis of performance of selected geospatial analyses implemented on the basis of relational and nosql databases |
| topic | spatial analyses spatial data mongodb postgis efficiency |
| url | https://doi.org/10.2478/pcr-2019-0014 |
| work_keys_str_mv | AT pietronmarcin analysisofperformanceofselectedgeospatialanalysesimplementedonthebasisofrelationalandnosqldatabases |