Sensor-based Database with SensLog: A Case Study of SQL to NoSQL Migration

Result code in IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F49777513%3A23520%2F18%3A43951820" target="_blank" >RIV/49777513:23520/18:43951820 - isvavai.cz</a>

Result on the web

<a href="https://www.scitepress.org/PublicationsDetail.aspx?ID=Aykdthh%2fVGo%3d&t=1" target="_blank" >https://www.scitepress.org/PublicationsDetail.aspx?ID=Aykdthh%2fVGo%3d&t=1</a>

DOI - Digital Object Identifier

<a href="http://dx.doi.org/10.5220/0006909202390244" target="_blank" >10.5220/0006909202390244</a>

Result language

angličtina

Original language name

Sensor-based Database with SensLog: A Case Study of SQL to NoSQL Migration

Original language description

Sensors gained a significant role in the Internet of Things (IoT) applications in various industry sectors. The information retrieved from the sensors are generally stored in the database for post-processing and analysis. This sensor database could grow rapidly when the data is frequently collected by several sensors altogether. It is thus often required to scale databases as the volume of data increases dramatically. Cloud computing and new database technologies has become key technologies to solve these problems. Traditionally relational SQL databases are widely used and have proved reliable over time. However, the scalability of SQL databases at large scale has always been an issue. With the ever-growing data volumes, various new database technologies have appeared which proposes performance and scalability gains under severe conditions. They have often named as NoSQL databases as opposed to SQL databases. One of the challenges that have arisen is knowing how and when to migrate existing relational databases to NoSQL databases for performance and scalability. In the current paper, we present a work in progress with the DataBio project for the SensLog application case study with some initial success. We will report on the ideas and the migration approach of SensLog platform and the performance benchmarking.

Czech name

—

Czech description

—

Type

D - Article in proceedings

CEP classification

—

OECD FORD branch

10201 - Computer sciences, information science, bioinformathics (hardware development to be 2.2, social aspect to be 5.8)

Project

<a href="/en/project/LO1506" target="_blank" >LO1506: Sustainability support of the centre NTIS - New Technologies for the Information Society</a><br>

Continuities

P - Projekt vyzkumu a vyvoje financovany z verejnych zdroju (s odkazem do CEP)<br>S - Specificky vyzkum na vysokych skolach

Publication year

2018

Confidentiality

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů

Article name in the collection

Proceedings of the 7th International Conference on Data Science, Technology and Applications (DATA 2018)

ISBN

978-989-758-318-6

ISSN

—

e-ISSN

neuvedeno

Number of pages

6

Pages from-to

239-244

Publisher name

SCITEPRESS – Science and Technology Publications, Lda.

Place of publication

Setúbal

Event location

Porto

Event date

Jul 26, 2018

Type of event by nationality

WRD - Celosvětová akce

UT code for WoS article

—