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

• Autorzy: Pietroń Marcin

Identyfikatory

DOI

10.2478/pcr-2019-0014

• Języki publikacji: EN

Abstrakty

EN

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.

Słowa kluczowe

EN

spatial analyses; spatial data; MongoDB; PostGIS; efficiency

• Wydawca: Polskie Towarzystwo Geograficzne. Oddział Kartograficzny
• Czasopismo: Polish Cartographical Review
• Rocznik: 2019
• Tom: Vol. 51, No. 4
• Strony: 167--179
• Opis fizyczny: Bibliogr. 18 poz., rys., tab., wykr.

Twórcy

autor

Pietroń Marcin

• Warsaw University of Technology, Faculty of Geodesy and Cartography, Department of Cartography

Bibliografia

• Adamczyk J., Konieczny A., 2010, Rodzaje analiz przestrzennych. In: K. Okła, Geomatyka w Lasach Państwowych – Część I. Podstawy. Warszawa: CILP, 214 pp.
• Agarwal S., Rajan K.S., 2017, Analyzing the performance of NoSQL vs. SQLdatabases for spatial and aggregate queries. “Free and Open Source Software for Geospatial (FOSS4G) Conference Proceedings” Vol. 17, Article 4, Boston.
• Baralis E., Garza P., Valle A.D., 2017, SQL versus NoSQL Databases for Geospatial Applications. In: IEEE International Conference on Big Data, Boston, IEEE, pp. 3388–3397.
• Fowler M., Sadalage P.J., 2015, NoSQL. Kompedium wiedzy. Polish transl. J. Hubisz, Gliwice: Helion, pp. 19−36.
• Gotlib D., 2013, Ogólna koncepcja, cel budowy i zakres informacyjny BDOT10k i BDOO. In: R. Olszewski, D. Gotlib (eds.), Rola bazy danych obiektów topograficznych w tworzeniu infrastruktury informacji przestrzennej w Polsce. Warszawa: GUGiK, pp. 51−57.
• Harrison G., 2019, NoSQL, NewSQL i BigData. Polish transl. P. Pilch, Gliwice: Helion, pp. 29−32, 58−59, 70−77.
• Laksano D., 2018, Testing spatial data deliverance in SQL and NoSQL database using NodeJS Fullstack Web App. 4th International Conference on Science and Technology (ICST), Yogyakarta, IEEE.
• Lupa M., Piórkowski A., 2019, The comparison of processing efficiency of spatial data for PostGIS and MongoDB Databases. In: S. Kozielski et al., Beyond databases, architectures and structures. Paving the road to smart data processing and analysis. 15th International Conference, BDAS 2019, Ustroń: Springer International Publishing, pp. 291–302.
• Ullman J.D., Widom J., 2000, Podstawowy wykład z systemów baz danych. Polish transl. M. Jurkiewicz, Warszawa: Wydawnictwo Naukowo-Techniczne, pp. 19−33, 118−122, 168−197.
• Wyszomirski M., 2018, Przegląd możliwości zastosowania wybranych baz danych NoSQL do zarządzania danymi przestrzennymi. “Roczniki Geomatyki” T. 16, z. 1(80), pp. 55−69.
• Internet sources
• PostGIS Development Group, PostGIS 2.5.4.dev Manual. In: PostGIS Documentation [online], https://postgis.net/docs/manual-2.5/ (access August 2019).
• pgAdmin Development Team, Features. In: pgAdmin homepage [online], https://www.pgadmin.org/features/ (access August 2019).
• MongoDB Inc., GeoJSON Objects. In: MongoDB Documentation [online], https://docs.mongodb.com/manual/reference/geojson/ (access September 2019).
• OSGeo, QGIS – wiodący otwartoźródłowy system GIS. In: Official QGIS project website, https://qgis.org/pl/site/about/index.html (access August 2019). Python Software Foundation, General Python FAQ, 2010. In:
• Python Documentation, https://docs.python.org/3/faq/general.html (access August 2019).
• MongoDB Inc., Geospatial Queries. In: MongoDB Documentation [online], https://docs.mongodb.com/manual/geospatial-queries/ (access August 2019a). PostGIS Development Group, PostGIS Reference. In:
• PostGIS Documentation [online], https://postgis. net/docs/reference.html (access August 2019).
• MongoDB Inc., Database Profiler. In: MongoDB Documentation [online], https://docs.mongodb.com/manual/tutorial/manage-the-database-profiler/ (access August 2019b).

Uwagi

Opracowanie rekordu ze środków MNiSW, umowa Nr 461252 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2020).