On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems

Anna Wolters, Mevludin Blazevic, Dennis M. Riehle

2023

Abstract

The Internet of Things (IoT) connects millions of devices, leading to the production of vast amounts of data. For such data to be of value, efficient and effective data storage is of utmost importance. In this paper, we present a comparison of on-premise database management systems in the context of the IoT. We perform a market analysis on relational, Not Only SQL (NoSQL), and time-series database systems as well as a requirement analysis in order to comprehensively compare database systems based on functional and non-functional criteria. After an initial selection, we compare MySQL, PostgreSQL, Cassandra, MongoDB, InfluxDB, and QuestDB. As a result, we provide a best practice guide to support the decision-making on which database to select for an IoT use case.

Paper Citation

in Harvard Style

Wolters A., Blazevic M. and Riehle D. (2023). On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems. In Proceedings of the 8th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS, ISBN 978-989-758-643-9, SciTePress, pages 140-149. DOI: 10.5220/0011851200003482

in Bibtex Style

@conference{iotbds23,
author={Anna Wolters and Mevludin Blazevic and Dennis M. Riehle},
title={On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems},
booktitle={Proceedings of the 8th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,},
year={2023},
pages={140-149},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011851200003482},
isbn={978-989-758-643-9},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 8th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,
TI - On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems
SN - 978-989-758-643-9
AU - Wolters A.
AU - Blazevic M.
AU - Riehle D.
PY - 2023
SP - 140
EP - 149
DO - 10.5220/0011851200003482
PB - SciTePress