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.

Wolters, A., Blazevic, M., & Riehle, D. M. (2023). On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems. In G. Wills, L. Buttyán, P. Kacsuk, & V. Chang (Eds.), Proceedings of the 8th International Conference on Internet of Things, Big Data and Security IoTBDS: Prague, Czech Republic; 21 to 23 April 2023 (pp. 140–149). SciTePress. https://doi.org/10.5220/0011851200003482

@inproceedings{Wolters2023On,
	address = {Set{\' u}bal},
	author = {Wolters, Anna and Blazevic, Mevludin and Riehle, Dennis M.},
	booktitle = {Proceedings of the 8th {International} {Conference} on {Internet} of {Things}, {Big} {Data} and {Security}  {IoTBDS}: Prague, {Czech} {Republic}; 21 to 23 {April} 2023},
	doi = {10.5220/0011851200003482},
	editor = {Wills, Gary and Butty{\' a}n, Levente and Kacsuk, P{\' e}ter and Chang, Victor},
	isbn = {978-989-758-643-9},
	year = {2023},
	pages = {140--149},
	organization = {SciTePress},
	title = {On-{Premise} {Internet} of {Things} ({IoT}) {Data} {Storage}: Comparison of {Database} {Management} {Systems}},
	url = {https://doi.org/10.5220/0011851200003482},
}