NoSQL Database Performance Tuning for IoT Data - Cassandra Case Study

Lucas B. Dias, Maristela Holanda, Ruben C. Huacarpuma, Rafael T. de Sousa Jr

2018

Abstract

Data provided by Internet of Things (IoT) are time series and have some specific characteristics that must be considered with regard to storage and management. IoT data is very likely to be stored in NoSQL system databases where there are some particular engine and compaction strategies to manage time series data. In this article, two of these strategies found in the open source Cassandra database system are described, analyzed and compared. The configuration of these strategies is not trivial and may be very time consuming. To provide indicators, the strategy with the best time performance had its main parameter tested along 14 different values and results are shown, related to both response time and storage space needed. The results may help users to configure their IoT NoSQL databases in an efficient setup, may help designers to improve database compaction strategies or encourage the community to set new default values for the compaction strategies.

Paper Citation

in Harvard Style

Dias L., Holanda M., Huacarpuma R. and de Sousa Jr R. (2018). NoSQL Database Performance Tuning for IoT Data - Cassandra Case Study.In Proceedings of the 3rd International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS, ISBN 978-989-758-296-7, pages 277-284. DOI: 10.5220/0006782702770284

in Bibtex Style

@conference{iotbds18,
author={Lucas B. Dias and Maristela Holanda and Ruben C. Huacarpuma and Rafael T. de Sousa Jr},
title={NoSQL Database Performance Tuning for IoT Data - Cassandra Case Study},
booktitle={Proceedings of the 3rd International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,},
year={2018},
pages={277-284},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006782702770284},
isbn={978-989-758-296-7},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 3rd International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,
TI - NoSQL Database Performance Tuning for IoT Data - Cassandra Case Study
SN - 978-989-758-296-7
AU - Dias L.
AU - Holanda M.
AU - Huacarpuma R.
AU - de Sousa Jr R.
PY - 2018
SP - 277
EP - 284
DO - 10.5220/0006782702770284