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
18_Baralis_et_al_2017_BSD.pdf
md5:96c96b4dcef9204e873a2c8f95122491
348.3 kB Download
267
335
views
downloads
All versions This version
Views 267267
Downloads 335335
Data volume 116.7 MB116.7 MB
Unique views 257257
Unique downloads 312312

Share

Cite as