large amounts of data generated from IoT devices. We
additionally observed that there exist large differences
between databases of the same type since InfluxDB
indicated a weaker performance than QuestDB, for
instance.
Our study has limitations since we restricted the
set of tested systems to open-source and on-premise
databases, while commercial and/or systems hosted
on clouds make up a large majority of the database
systems available as demonstrated in our market re-
search. We did not consider further requirements for
using database systems in an IoT application, such
as security. Still, we demonstrated the strengths and
weaknesses of six popular databases regarding their
suitability for IoT use cases, providing a comprehen-
sive overview to support decision-making.
ACKNOWLEDGEMENTS
This research has been supported by the Deutsche
Forschungsgemeinschaft (DFG) under Research
Grant No. 432399058.
REFERENCES
Alam, M., Rufino, J., Ferreira, J., Ahmed, S. H., Shah, N.,
& Chen, Y. (2018). Orchestration of microservices for
iot using docker and edge computing. IEEE Commun.
Mag., 56(9), 118–123.
Amghar, S., Cherdal, S., & Mouline, S. (2018). Which
NoSQL database for IoT Applications? 2018 Proc.
of MoWNeT, 131–137.
Bader, A., Kopp, O., & Falkenthal, M. (2017). Survey
and comparison of open source time series databases.
Datenbanksysteme für Business, Technologie und Web
(BTW 2017) - Workshopband, 249–268.
Baiyere, A., Topi, H., Wyatt, J., Venkatesh, V., & Donnel-
lan, B. (2020). Internet of things (IoT) – a research
agenda for information systems. Commun. Assoc. Inf.
Syst., 47(1), 21.
Beynon-Davies, P. (2017). Database systems. Bloomsbury
Publishing.
Chauhan, D., & Bansal, K. L. (2017). Using the advantages
of nosql: A case study on mongodb. Int. J. Recent In-
nov. Trends Comput. Commun., 5, 90–93.
Chen, M., Mao, S., & Liu, Y. (2014). Big data: A survey.
Mob. Netw. Appl., 19, 171–209.
Chui, M., Löffler, M., & Roberts, R. (2020). The Internet of
Things. McKinsey Quarterly.
Codd, E. F. (1970). A relational model of data for large
shared data banks. Commun. ACM, 13, 377–387.
De Mauro, A., Greco, M., & Grimaldi, M. (2015). What is
big data? A consensual definition and a review of key
research topics. AIP Conference Proceedings, 1644,
97–104.
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of
database systems (7th ed.). Pearson.
Fatima, H., & Wasnik, K. (2016). Comparison of sql, nosql
and newsql databases for internet of things. 2016
IEEE Bombay Section Symposium (IBSS), 1–6.
Gregor, S., & Hevner, A. R. (2013). Positioning and pre-
senting design science research for maximum impact.
MIS Quarterly, 37, 337–355.
Gubbi, J., Buyya, R., Marusic, S., & Palaniswami, M.
(2013). Internet of Things (IoT): A vision, architec-
tural elements, and future directions. Future Gener.
Comput. Syst., 29(7), 1645–1660.
Hao, Y., Qin, X., Chen, Y., Li, Y., Sun, X., Tao, Y., Zhang,
X., & Du, X. (2021). Ts-benchmark: A benchmark
for time series databases. Proc. of 37th IEEE ICDE,
588–599.
ITU-T, T. S. S. o. I. (2011). Overview of the Internet of
Things (tech. rep.) [Publication Title: International
Telecommunication Union].
Liu, R., & Yuan, J. (2019). Benchmarking time series
databases with iotdb-benchmark for iot scenarios.
arXiv preprint. http://arxiv.org/abs/1901.08304
Lycett, M. (2013). ’Datafication’: Making sense of (big)
data in a complex world. Eur. J. Inf. Syst., 22(4),
381–386.
Miorandi, D., Sicari, S., De Pellegrini, F., & Chlamtac,
I. (2012). Internet of things: Vision, applications
and research challenges. Ad Hoc Networks, 10(7),
1497–1516.
Mostafa, J., Wehbi, S., Chilingaryan, S., & Kopmann, A.
(2022). Scits: A benchmark for time-series databases
in scientific experiments and industrial internet of
things. Proc. of the 34th Int. Conf. Sci. Stat. Database
Manag., 1–11.
Musa, E., Dela
ˇ
c, G., Šili
´
c, M., & Vladimir, K. (2019).
Comparison of relational and time-series databases
for real-time massive datasets. 2019 Proc. of the 42th
MIPRO, 1065–1070.
Nasar, M., & Kausar, M. A. (2019). Suitability of influxdb
database for iot applications. Int. J. Eng. Innov. Tech-
nol., 8, 1850–1857.
Peffers, K., Tuunanen, T., Rothenberger, M. A., & Chatter-
jee, S. (2007). A design science research methodology
for information systems research. J. Manag. Inf. Syst.,
24(3), 45–77.
Rautmare, S., & Bhalerao, D. M. (2016). MySQL and
NoSQL database comparison for IoT application.
2016 Proc. of. IEEE ICACA, 235–238.
Rayes, A., & Salam, S. (2017). Internet of things from hype
to reality. Springer Basel.
Sestino, A., Prete, M. I., Piper, L., & Guido, G. (2020). In-
ternet of Things and Big Data as enablers for business
digitalization strategies. Technovation, 98(July).
solid IT gmbh. (2022). Db-engines ranking. Retrieved
December 7, 2022, from https://db-engines.com/en/
ranking/relational+dbms
Strohbach, M., Ziekow, H., Gazis, V., & Akiva, N. (2015).
Towards a big data analytics framework for iot and
smart city applications. MOST, 4, 257–282.
On-Premise Internet of Things (IoT) Data Storage: Comparison of Database Management Systems
147