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

Prasoon Dadhich, Andrey Sadovykh, Alessandra Bagnato, Michal Kepka, Ondřej Kaas, Karel Charvát

2018

Abstract

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.

Paper Citation

in Harvard Style

Dadhich P., Sadovykh A., Bagnato A., Kepka M., Kaas O. and Charvát K. (2018). Sensor-based Database with SensLog: A Case Study of SQL to NoSQL Migration.In Proceedings of the 7th International Conference on Data Science, Technology and Applications - Volume 1: DATA, ISBN 978-989-758-318-6, pages 239-244. DOI: 10.5220/0006909202390244

in Bibtex Style

@conference{data18,
author={Prasoon Dadhich and Andrey Sadovykh and Alessandra Bagnato and Michal Kepka and Ondřej Kaas and Karel Charvát},
title={Sensor-based Database with SensLog: A Case Study of SQL to NoSQL Migration},
booktitle={Proceedings of the 7th International Conference on Data Science, Technology and Applications - Volume 1: DATA,},
year={2018},
pages={239-244},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006909202390244},
isbn={978-989-758-318-6},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 7th International Conference on Data Science, Technology and Applications - Volume 1: DATA,
TI - Sensor-based Database with SensLog: A Case Study of SQL to NoSQL Migration
SN - 978-989-758-318-6
AU - Dadhich P.
AU - Sadovykh A.
AU - Bagnato A.
AU - Kepka M.
AU - Kaas O.
AU - Charvát K.
PY - 2018
SP - 239
EP - 244
DO - 10.5220/0006909202390244