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

被引：3
|
作者：
Wolters, Anna [1 ]
Blazevic, Mevludin [1 ]
Riehle, Dennis M. [1 ]
机构：
[1] Univ Koblenz, Inst IS Res, Univstr 1, Koblenz, Germany
来源：
PROCEEDINGS OF THE 8TH INTERNATIONAL CONFERENCE ON INTERNET OF THINGS, BIG DATA AND SECURITY, IOTBDS 2023 | 2023年
关键词：
Internet of Things; Big Data; Database Management System; Time-series Database; DESIGN SCIENCE RESEARCH; BIG DATA;
D O I：
10.5220/0011851200003482
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
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.
引用
收藏
页码：140 / 149
页数：10
相关论文
共 50 条
  • [1] Comparison of Data Aggregation Techniques In Internet of Things (IoT)
    Rahman, H.
    Ahmed, N.
    Hussain, I.
    PROCEEDINGS OF THE 2016 IEEE INTERNATIONAL CONFERENCE ON WIRELESS COMMUNICATIONS, SIGNAL PROCESSING AND NETWORKING (WISPNET), 2016, : 1296 - 1300
  • [2] Internet of Things (IoT) Architecture for Flood Data Management
    Ghapar, Azimah Abdul
    Yussof, Salman
    Abu Bakar, Asmidar
    INTERNATIONAL JOURNAL OF FUTURE GENERATION COMMUNICATION AND NETWORKING, 2018, 11 (01): : 55 - 62
  • [3] Smart Systems and the Internet of Things (IOT) For Waste Management
    Tamakloe, Claude-Noel
    Rosca, Elena, V
    2020 IEEE INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND VIRTUAL ENVIRONMENTS FOR MEASUREMENT SYSTEMS AND APPLICATIONS (CIVEMSA 2020), 2020,
  • [4] Data Storage in Blockchain Based Architectures for Internet of Things (IoT)
    Shaikh, Munavwar
    Shibu, Charles
    Angeles, Enrico
    Pavithran, Deepa
    2021 IEEE INTERNATIONAL IOT, ELECTRONICS AND MECHATRONICS CONFERENCE (IEMTRONICS), 2021, : 335 - 339
  • [5] Securing Data Provenance in Internet of Things (IoT) Systems
    Baracaldo, Nathalie
    Bathen, Luis Angel D.
    Ozugha, Roqeeb O.
    Engel, Robert
    Tata, Samir
    Ludwig, Heiko
    SERVICE-ORIENTED COMPUTING - ICSOC 2016 WORKSHOPS, 2017, 10380 : 92 - 98
  • [6] Data Provenance Model for Internet of Things (IoT) Systems
    Olufowobi, Habeeb
    Engel, Robert
    Baracaldo, Nathalie
    Bathen, Luis Angel D.
    Tata, Samir
    Ludwig, Heiko
    SERVICE-ORIENTED COMPUTING - ICSOC 2016 WORKSHOPS, 2017, 10380 : 85 - 91
  • [7] A Combination of Internet of Things (IoT) and Graph Database for Future Battlefield Systems
    Tripathi, Gaurav
    Sharma, Bhawna
    Rajvanshi, Sonali
    2017 IEEE INTERNATIONAL CONFERENCE ON COMPUTING, COMMUNICATION AND AUTOMATION (ICCCA), 2017, : 1252 - 1257
  • [8] Nexus of Internet of Things (IoT) and Big Data: Roadmap for Smart Management Systems (SMgS)
    Roy M.
    Roy A.
    IEEE Engineering Management Review, 1600, 47 (02): : 53 - 65
  • [9] Uploading and Replicating Internet of Things (IoT) Data on Distributed Cloud Storage
    Kumar, Akshay
    Narendra, Nanjangud C.
    Bellur, Umesh
    PROCEEDINGS OF 2016 IEEE 9TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING (CLOUD), 2016, : 670 - 677
  • [10] Internet of things (IoT) in information management
    Cao, Xiong Fei
    Chaudhry, Sohail
    Xu, Li Da
    LIBRARY HI TECH, 2020, 38 (01) : 1 - 3
12345