Suitability of Graph Database Technology for the Analysis of Spatio-Temporal Data

Sedick Baker Effendi, Brink van der Merwe and Wolf-Tilo Balke
Additional contact information
Sedick Baker Effendi: Department of Computer Science, Stellenbosch University, Stellenbosch 7600, South Africa
Brink van der Merwe: Department of Computer Science, Stellenbosch University, Stellenbosch 7600, South Africa
Wolf-Tilo Balke: Institute for Information Systems, TU Braunschweig, D-38106 Braunschweig, Germany

Future Internet, 2020, vol. 12, issue 5, 1-31

Abstract: Every day large quantities of spatio-temporal data are captured, whether by Web-based companies for social data mining or by other industries for a variety of applications ranging from disaster relief to marine data analysis. Making sense of all this data dramatically increases the need for intelligent backend systems to provide realtime query response times while scaling well (in terms of storage and performance) with increasing quantities of structured or semi-structured, multi-dimensional data. Currently, relational database solutions with spatial extensions such as PostGIS, seem to come to their limits. However, the use of graph database technology has been rising in popularity and has been found to handle graph-like spatio-temporal data much more effectively. Motivated by the need to effectively store multi-dimensional, interconnected data, this paper investigates whether or not graph database technology is better suited when compared to the extended relational approach. Three database technologies will be investigated using real world datasets namely: PostgreSQL, JanusGraph, and TigerGraph. The datasets used are the Yelp challenge dataset and an ambulance response simulation dataset, thus combining real world spatial data with realistic simulations offering more control over the dataset. Our extensive evaluation is based on how each database performs under practical data analysis scenarios similar to those found on enterprise level.

Keywords: graph databases; spatio-temporal data; NoSQL; yelp dataset (search for similar items in EconPapers)
JEL-codes: O3 (search for similar items in EconPapers)
Date: 2020
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
https://www.mdpi.com/1999-5903/12/5/78/pdf (application/pdf)
https://www.mdpi.com/1999-5903/12/5/78/ (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:gam:jftint:v:12:y:2020:i:5:p:78-:d:350811

Access Statistics for this article

Future Internet is currently edited by Ms. Grace You

More articles in Future Internet from MDPI
Bibliographic data for series maintained by MDPI Indexing Manager ().