10.5281/zenodo.1149082
https://zenodo.org/records/1149082
oai:zenodo.org:1149082
Baralis, Elena
Elena
Baralis
Politecnico di Torino
Dalla Valle, Andrea
Andrea
Dalla Valle
Politecnico di Torino
Garza, Paolo
Paolo
Garza
Politecnico di Torino
Rossi, Claudio
Claudio
Rossi
Istituto Superiore Mario Boella
Scullino, Francesco
Francesco
Scullino
Istituto Superiore Mario Boella
SQL versus NoSQL Databases for Geospatial Applications
Zenodo
2017
Geospatial data
Geospatial databases
Database-as-a-service (DBaaS)
2017-12-11
eng
10.5281/zenodo.1149081
https://zenodo.org/communities/eu
Creative Commons Attribution 4.0 International
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.
European Commission
10.13039/501100000780
700256
Improving Resilience to Emergencies through Advanced Cyber Technologies