loading
Papers

Research.Publish.Connect.

Paper

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

Topics: Architectural Concepts; Big Data Applications; Big Data Infrastructure; Data Analytics; Data Modeling and Visualization; Data Science; Data Structures and Data Management Algorithms; Database Architecture and Performance; Large Scale Databases; Management of Sensor Data; Modeling and Managing Large Data Systems; Nosql Databases; Open Data; Open Source Databases; Organizational Concepts and Practices; Query Processing and Optimization

Authors: Prasoon Dadhich 1 ; Andrey Sadovykh 1 ; Alessandra Bagnato 1 ; Michal Kepka 2 ; Ondřej Kaas 2 and Karel Charvát 3

Affiliations: 1 Softeam Group, Paris and France ; 2 University of West Bohemia, Plze and Czech Republic ; 3 Lesprojekt-sluby Ltd., Martinov and Czech Republic

ISBN: 978-989-758-318-6

Keyword(s): NoSQL, Performance Testing, Modeling, Data Migration, Benchmarking, Sensor-based Database, Cloud Computing, Virtualization, Scaling, Data Architecture and Analysis.

Related Ontology Subjects/Areas/Topics: Architectural Concepts ; Artificial Intelligence ; Business Analytics ; Data Analytics ; Data Engineering ; Data Management and Quality ; Data Modeling and Visualization ; Data Structures and Data Management Algorithms ; Database Architecture and Performance ; Databases and Data Security ; Databases and Information Systems Integration ; Enterprise Information Systems ; Knowledge Discovery and Information Retrieval ; Knowledge-Based Systems ; Large Scale Databases ; Management of Sensor Data ; Modeling and Managing Large Data Systems ; Nosql Databases ; Open Data ; Open Source Databases ; Organizational Concepts and Best Practices ; Query Processing and Optimization ; Symbolic Systems

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 ex isting 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. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 35.172.195.49

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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

@conference{data18,
author={Prasoon Dadhich. and Andrey Sadovykh. and Alessandra Bagnato. and Michal Kepka. and Ond\v{r}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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.