Skip to main content
SpringerLink
Log in

The Comparison of Processing Efficiency of Spatial Data for PostGIS and MongoDB Databases

  • Conference paper
  • First Online:
Beyond Databases, Architectures and Structures. Paving the Road to Smart Data Processing and Analysis (BDAS 2019)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 1018))

Abstract

This paper presents the issue of geographic data storage in NoSQL databases. The authors present the performance investigation of the non-relational database MongoDB with its built-in spatial functions in relation to the PostgreSQL database with a PostGIS spatial extension. As part of the tests, the authors were designed queries simulating common problems in the processing of point data. In addition, the main advantages and disadvantages of NoSQL databases are presented in the context of the ability to manipulate spatial data.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Db-engines ranking. https://db-engines.com/en/ranking/

  2. MongoDB Docs - geospatial query operators. https://docs.mongodb.com/manual/reference/operator/query-geospatial/

  3. PostGIS 2.5.2 dev manual. https://postgis.net/docs/

  4. QGIS documentation. https://qgis.org/en/docs/

  5. Burzańska, M., Wiśniewski, P.: How poor Is the “poor man’s search engine”? In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2018. CCIS, vol. 928, pp. 294–305. Springer, Cham (2018). https://doi.org/10.1007/978-3-319-99987-6_23

    Chapter  Google Scholar 

  6. Agarwal, S., Rajan, K.: Performance analysis of MongoDB versus postGIS/postgreSQL databases for line intersection and point containment spatial queries. Spat. Inf. Res. 24(6), 671–677 (2016)

    Article  Google Scholar 

  7. Akulakrishna, P.K., Lakshmi, J., Nandy, S.: Efficient storage of big-data for real-time GPS applications. In: 2014 IEEE Fourth International Conference on Big Data and Cloud Computing (BdCloud), pp. 1–8. IEEE (2014)

    Google Scholar 

  8. Bajerski, P., Kozielski, S.: Computational model for efficient processing of geofield queries. In: Cyran, K.A., Kozielski, S., Peters, J.F., Stańczyk, U., Wakulicz-Deja, A. (eds.) Man-Machine Interactions. AISC, vol. 59, pp. 573–583. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-00563-3_60

    Chapter  Google Scholar 

  9. Chmielewski, S., Samulowska, M., Lupa, M., Lee, D.J., Zagajewski, B.: Citizen science and WebGIS for outdoor advertisement visual pollution assessment. Comput. Environ. Urban Syst. 67, 97–109 (2018)

    Article  Google Scholar 

  10. Chromiak, M., Stencel, K.: A data model for heterogeneous data integration architecture. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 547–556. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-06932-6_53

    Chapter  Google Scholar 

  11. Chuchro, M., Franczyk, A., Dwornik, M., Lesniak, A.: A big data processing strategy for hybrid interpretation of flood embankment multisensor data. Geol. Geophys. Environ. 42(3), 269–277 (2016)

    Article  Google Scholar 

  12. Czerepicki, A.: Perspektywy zastosowania baz danych nosql w inteligentnych systemach transportowych. Prace Naukowe Politechniki Warszawskiej. Transport 92, 29–38 (2013)

    Google Scholar 

  13. Fraczek, K., Plechawska-Wojcik, M.: Comparative analysis of relational and non-relational databases in the context of performance in web applications. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2017. CCIS, vol. 716, pp. 153–164. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-58274-0_13

    Chapter  Google Scholar 

  14. Goodchild, M.F.: Citizens as sensors: the world of volunteered geography. GeoJournal 69(4), 211–221 (2007)

    Article  Google Scholar 

  15. Harezlak, K., Skowron, R.: Performance aspects of migrating a web application from a relational to a NoSQL database. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2015. CCIS, vol. 521, pp. 107–115. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-18422-7_9

    Chapter  Google Scholar 

  16. Hricov, R., Šenk, A., Kroha, P., Valenta, M.: Evaluation of XPath queries over XML documents using sparkSQL framework. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2017. CCIS, vol. 716, pp. 28–41. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-58274-0_3

    Chapter  Google Scholar 

  17. Inglot, A., Koziol, K.: The importance of contextual topology in the process of harmonization of the spatial databases on example BDOT500. In: 2016 Baltic Geodetic Congress (BGC Geomatics), pp. 251–256 (2016)

    Google Scholar 

  18. Kopec, A., Bala, J., Pieta, A.: WebGL based visualisation and analysis of stratigraphic data for the purposes of the mining industry. Procedia Comput. Sci. 51, 2869–2877 (2015)

    Article  Google Scholar 

  19. Kozioł, K., Lupa, M., Krawczyk, A.: The extended structure of multi-resolution database. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 435–443. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-06932-6_42

    Chapter  Google Scholar 

  20. Krawczyk, A.: A concept for the modernization of underground mining master maps based on the enrichment of data definitions and spatial database technology. In: E3S Web of Conferences, vol. 26, p. 00010. EDP Sciences (2018)

    Google Scholar 

  21. Li, Y., Kim, G., Wen, L., Bae, H.: MHB-tree: a distributed spatial index method for document based nosql database system. In: Han, Y.H., Park, D.S., Jia, W., Yeo, S.S. (eds.) Ubiquitous Information Technologies and Applications. LNCS, vol. 214, pp. 489–497. Springer, Dordrecht (2013). https://doi.org/10.1007/978-94-007-5857-5_53

    Chapter  Google Scholar 

  22. Longley, P.A., Goodchild, M.F., Maguire, D.J., Rhind, D.W.: Geographic Information Systems and Science. Wiley, Hoboken (2005)

    Google Scholar 

  23. Salazar Loor, J., Fdez-Arroyabe, P.: Aerial and satellite imagery and big data: blending old technologies with new trends. In: Dey, N., Bhatt, C., Ashour, A.S. (eds.) Big Data for Remote Sensing: Visualization, Analysis and Interpretation, pp. 39–59. Springer, Cham (2019). https://doi.org/10.1007/978-3-319-89923-7_2

    Chapter  Google Scholar 

  24. Lupa, M., Kozioł, K., Leśniak, A.: An attempt to automate the simplification of building objects in multiresolution databases. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2015. CCIS, vol. 521, pp. 448–459. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-18422-7_40

    Chapter  Google Scholar 

  25. Ma, Y., et al.: Remote sensing big data computing: challenges and opportunities. Future Gener. Comput. Syst. 51, 47–60 (2015)

    Article  Google Scholar 

  26. Martins, P., Cecílio, J., Abbasi, M., Furtado, P.: GISB: a benchmark for geographic map information extraction. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2015-2016. CCIS, vol. 613, pp. 600–609. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-34099-9_46

    Chapter  Google Scholar 

  27. Mirek, K., Mirek, J.: Non-parametric approximation used to analysis of psinsar[tm] data of upper silesian coal basin, poland. Acta Geodynamica et Geomaterialia 6(4), 405–410 (2009)

    Google Scholar 

  28. Pavlicek, A., Doucek, P., Novák, R., Strizova, V.: Big data analytics – geolocation from the perspective of mobile network operator. In: Tjoa, A.M., Zheng, L.-R., Zou, Z., Raffai, M., Xu, L.D., Novak, N.M. (eds.) CONFENIS 2017. LNBIP, vol. 310, pp. 119–131. Springer, Cham (2018). https://doi.org/10.1007/978-3-319-94845-4_11

    Chapter  Google Scholar 

  29. Piorkowski, A.: MySQL spatial and PostGIS-implementations of spatial data standards. EJPAU 14(1), 03 (2011)

    Google Scholar 

  30. Płuciennik, E., Zgorzałek, K.: The multi-model databases – a review. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2017. CCIS, vol. 716, pp. 141–152. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-58274-0_12

    Chapter  Google Scholar 

  31. Wyszomirski, M.: Przeglad mozliwosci zastosowania wybranych baz danych nosql do zarzadzania danymi przestrzennymi. Roczniki Geomatyki-Annals of Geomatics 16(1 (80)), 55–69 (2018)

    Google Scholar 

  32. Xu, G., Gao, S., Daneshmand, M., Wang, C., Liu, Y.: A survey for mobility big data analytics for geolocation prediction. IEEE Wirel. Commun. 24(1), 111–119 (2017)

    Article  Google Scholar 

  33. Zhang, X., Song, W., Liu, L.: An implementation approach to store GIS spatial data on NoSQL database. In: 2014 22nd International Conference on Geoinformatics (GeoInformatics), pp. 1–5. IEEE (2014)

    Google Scholar 

Download references

Acknowledgements

This work was financed by the AGH - University of Science and Technology, Faculty of Geology, Geophysics and Environmental Protection as a part of a statutory project.

Author information

Authors and Affiliations

  1. Department of Geoinformatics and Applied Computer Science, AGH University of Science and Technology, al. Mickiewicza 30, 30-059, Cracow, Poland

    Dominik Bartoszewski & Michal Lupa

  2. Department of Biocybernetics and Biomedical Engineering, AGH University of Science and Technology, A. Mickiewicza 30 Av., 30-059, Cracow, Poland

    Adam Piorkowski

Authors
  1. Dominik Bartoszewski
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Adam Piorkowski
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Michal Lupa
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Michal Lupa .

Editor information

Editors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Stanisław Kozielski

  2. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Dariusz Mrozek

  3. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Paweł Kasprowski

  4. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Bartoszewski, D., Piorkowski, A., Lupa, M. (2019). The Comparison of Processing Efficiency of Spatial Data for PostGIS and MongoDB Databases. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. Paving the Road to Smart Data Processing and Analysis. BDAS 2019. Communications in Computer and Information Science, vol 1018. Springer, Cham. https://doi.org/10.1007/978-3-030-19093-4_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-19093-4_22

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-19092-7

  • Online ISBN: 978-3-030-19093-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation