Relational databases have been around for a long time, and Spatial databases have exploited this feature for close to two decades. The recent past has seen the development of NoSQL non-relational databases, which are now being adopted for spatial object storage and handling too. Moreover, this is gaining ground in the context of increased shift towards Geospatial Web Services on both the Web and mobile platforms especially in the user-centric services, where there is a need to improve the query response time. This paper attempts to evaluate the performance of an existing NoSQL database ‘MongoDB’ with its inbuilt spatial functions with that of an SQL database with spatial extension ‘PostGIS’ for two fundamental spatial problems—line intersection and point containment problem, across a range of datasets, with varying feature counts. Given these results, NoSQL databases may be better suited for simultaneous multiple-user query systems including Web-GIS and mobile-GIS. Further studies are required to understand the full potential of NoSQL databases across various geometries and spatial query types.
This is a preview of subscription content, access via your institution.
Buy single article
Instant access to the full article PDF.
Tax calculation will be finalised during checkout.
Soni, G. (2013). Open source spatial database for mobile devices. Computer Engineering and Intelligent Systems (IISTE).
Baas, B., Quak, W., Van Oosterom, P. et al. (2012). NoSQL spatial: Neo4j versus PostGIS. Master Thesis, Geographical Information Management and Applications.
Scholz, J. (2011). Coping with dynamic, unstructured data sets—NoSQL a buzzword or a savior? In M. Schrenk, V. V. Popovich, P. Zeile (Eds.), Proceedings of 16th international conference on urban planning, regional development and information society REAL CORP (pp. 121–129). ISBN: 978-3-9503110-1-3.
Kolb, L. (n.d.). NoSQL-Datenbanken. Kapitel 1: Einführung; Universität Leipzig. http://dbs.unileipzig.de/file/NoSQL_SS14_01_Intro.pdf.
NoSQL Databases Explained | MongoDB. White Paper (n.d.). https://www.mongodb.com/nosql-explained.
Lourenço, J. R., et al. (2015). Choosing the right NoSQL database for the job: a quality attribute evaluation. Journal of Big Data, 2, 18. doi:10.1186/s40537-015-0025-0.
de Souza Baptista, C., de Oliveira, M. G., da Silva, T. E. (2011). Using OGC services to interoperate spatial data stored in SQL and NoSQL databases. XII GEOINFO, Campos do Jordão, Brazil, November 27–29, 2011.
Xiao, Z. F., & Liu, Y. M. (2011). Remote sensing image database based on NOSQL database. Geoinformatics, 2011, 1–5.
Schmid, S., Galicz, E., Reinhardt, W. (2015). Performance investigation of selected SQL and NoSQL databases. AGILE 2015, Lisbon, June 9–12, 2015.
Popescu, A., Bacalu, A.-M. (2009). Geo NoSQL: CouchDB, MongoDB, and Tokyo cabinet. http://nosql.mypopescu.com/post/300199706/geo-nosql-couchdb-mongodb-tokyo-cabinet.
Steiniger, S., & Hunter, A. J. S. (2012). Free and open source GIS software for building a spatial data infrastructure. Geospatial Free and Open Source Software in the 21st Century (Part 5). doi:10.1007/978-3-642-10595-1_15.
van der Veen, J. S., van der Waaij, B., Meijer, R. J. (2012). Sensor data storage performance: SQL or NoSQL, physical or virtual. In: IEEE fifth international conference on cloud computing, Honolulu, Hawaii, USA, June 24–29, 2012.
PostGIS Development Group, Postgis Manual. http://postgis.net/docs/index.html. Accessed January 14, 2014.
Chris. (2014). A primer on geospatial data and MongoDB—mLab Blog. http://blog.mlab.com/2014/08/a-primer-on-geospatial-data-and-mongodb. Accessed August 19, 2014.
Butler, H. et al. (2015). The GeoJSON format specification. Internet Engineering Task Force.
We would like to acknowledge the responses and interactions with MongoDB developers through emails which helped during this research project.
About this article
Cite this article
Agarwal, S., Rajan, K.S. Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queries. Spat. Inf. Res. 24, 671–677 (2016). https://doi.org/10.1007/s41324-016-0059-1
- Spatial databases
- Spatial queries