Published December 11, 2017 | Version v1
Conference paper Open

SQL versus NoSQL Databases for Geospatial Applications

  • 1. Politecnico di Torino
  • 2. Istituto Superiore Mario Boella

Description

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.

Notes

© 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

18_Baralis_et_al_2017_BSD.pdf

Files (348.3 kB)

Name Size Download all
md5:96c96b4dcef9204e873a2c8f95122491
348.3 kB Preview Download

Additional details

Funding

I-REACT – Improving Resilience to Emergencies through Advanced Cyber Technologies 700256
European Commission