Conference paper Open Access

SQL versus NoSQL Databases for Geospatial Applications

Baralis, Elena; Dalla Valle, Andrea; Garza, Paolo; Rossi, Claudio; Scullino, Francesco

In the last years, we are witnessing an increasing availability of geolocated data, ranging from satellite images to
user generated content (e.g., tweets). This big amount of data is exploited by several cloud-based applications to deliver effective and customized services to end users. In order to provide a good user experience, a low-latency response time is needed, both when data are retrieved and provided. To achieve this goal, current geospatial applications need to exploit efficient and scalable geospatial databases, the choice of which has a high impact on the overall performance of the deployed applications. In this paper, we compare, from a qualitative point of view, four state-of-the-art SQL and NoSQL databases with geospatial features, and then we analyze the performances of two of them, selecting the ones based on the Database-as-a-service (DBaaS) model: Azure SQL Database and Azure DocumentDB (i.e., an SQL database versus a NoSQL one). The empirical evaluation shows pros and cons of both solutions and it is performed on a real use case related to an emergency management application.

© 2017 IEEE. Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.
Files (348.3 kB)
Name Size
348.3 kB Download
All versions This version
Views 432432
Downloads 605605
Data volume 210.7 MB210.7 MB
Unique views 421421
Unique downloads 568568


Cite as