A case study : ingestion analysis of WSN data in databases using docker

Velásquez Vargas, Washington Adrián and Muñoz Arcentales, José Andrés and Salvachúa Rodríguez, Joaquín (2018). A case study : ingestion analysis of WSN data in databases using docker. In: "1st International Conference on Computer Applications & Information Security (ICCAIS 2018)", 04/04/2018 - 06/04/2018, Riyadh, Saudi Arabia, Saudi Arabia. pp. 1-6.

Description

Title: A case study : ingestion analysis of WSN data in databases using docker
Author/s:
  • Velásquez Vargas, Washington Adrián
  • Muñoz Arcentales, José Andrés
  • Salvachúa Rodríguez, Joaquín
Item Type: Presentation at Congress or Conference (Article)
Event Title: 1st International Conference on Computer Applications & Information Security (ICCAIS 2018)
Event Dates: 04/04/2018 - 06/04/2018
Event Location: Riyadh, Saudi Arabia, Saudi Arabia
Title of Book: 1st International Conference on Computer Applications & Information Security (ICCAIS 2018)
Date: 2018
Subjects:
Freetext Keywords: Kafka; wireless sensor networks; database; mysql; mongodb; couchdb; neo4j; postgresql; scala; akka; docker
Faculty: E.T.S.I. Telecomunicación (UPM)
Department: Otro
Creative Commons Licenses: Recognition - No derivative works - Non commercial

Full text

[img]
Preview
PDF - Requires a PDF viewer, such as GSview, Xpdf or Adobe Acrobat Reader
Download (1MB) | Preview

Abstract

In this paper, we present an analysis of the different database systems for storing the information gather by a wireless sensor network. In this work we present different test scenarios in order to evaluate the Fetch Time and the use of Mebibyte in Relational (MySQL, PostgreSQL) and No-SQL (MongoDB, Couch, Ne04J) databases. For achieving this goal, the database instances are deployed in Docker containers for providing the same deploy, host platform and, also present a performance analysis of the resources for each database. Moreover, we conduct a case of study focus in the storage of the asynchronous information collected by a WSN in a reactive evacuation system, this is information is handled by a Kafka cluster and Zookeeper topics. Finally the tests made in this work provide the information needed for making the correct elections of the database in this type of systems.

More information

Item ID: 52226
DC Identifier: https://oa.upm.es/52226/
OAI Identifier: oai:oa.upm.es:52226
Deposited by: Memoria Investigacion
Deposited on: 03 Dec 2018 18:25
Last Modified: 03 Dec 2018 18:25
  • Logo InvestigaM (UPM)
  • Logo GEOUP4
  • Logo Open Access
  • Open Access
  • Logo Sherpa/Romeo
    Check whether the anglo-saxon journal in which you have published an article allows you to also publish it under open access.
  • Logo Dulcinea
    Check whether the spanish journal in which you have published an article allows you to also publish it under open access.
  • Logo de Recolecta
  • Logo del Observatorio I+D+i UPM
  • Logo de OpenCourseWare UPM