SQL or NoSQL? contrasting approaches to the storage, manipulation and analysis of spatio-temporal online social network data

Adrian Tear

    Research output: Chapter in Book/Report/Conference proceedingOther chapter contribution

    404 Downloads (Pure)


    Researchers are now accessing millions of Online Social Network (OSN) interactions. These are available at no or low cost through Application Programming Interfaces (APIs) or data custodians including DataSift and GNIP. Records held in Extensible Markup Language (XML) or JavaScript Object Notation (JSON) are well structured but often inconveniently formatted for use in popular Relational Database Management Systems (RDBMS) or Geographic Information Systems (GIS) software. In contrast, emerging NoSQL (Not-only Structured Query Language) technologies are specially designed to ‘ingest’ unstructured data. Extract/Transform/Load (ETL) procedures for the storage and subsequent analysis of two OSN datasets in SQL/NoSQL databases are examined. The fixed data model of the relational approach may prove problematic when loading unpredictable document-based structures arising from extended periods of data collection. Although relational databases are far from obsolete the spatial analysis community seems likely to benefit from experimentation with new software explicitly designed for handling spatio-temporal Big Data.
    Original languageEnglish
    Title of host publicationComputational science and its applications – ICCSA 2014
    Subtitle of host publication14th international conference, Guimarães, Portugal, June 30 – July 3, 2014, proceedings, Part I
    EditorsBeniamino Murgante, Sanjay Misra, Ana Maria A. C. Rocha, Carmelo Torre, Jorge Gustavo Rocha, Maria Irene Falcao, David Taniar, Bernady O. Apduhan, Osvaldo Gervasi
    Place of PublicationBerlin
    ISBN (Electronic)9783319091440
    ISBN (Print)9783319091433
    Publication statusPublished - 2014
    EventICCSA 14th International Conference - Guimaraes, Portugal
    Duration: 30 Jun 20143 Jul 2014

    Publication series

    NameLecture Notes in Computer Science
    ISSN (Print)0302-9743


    ConferenceICCSA 14th International Conference


    Dive into the research topics of 'SQL or NoSQL? contrasting approaches to the storage, manipulation and analysis of spatio-temporal online social network data'. Together they form a unique fingerprint.

    Cite this