Evaluation of storage and query performance of sensor based Internet of Things data with MongoDB

Abstract

Internet of Things (IoT) can be defined as the communication network that connects physical devices such as sensors, actuators, electronic home appliances and smart devices with each other and other systems. As part of IoT, numerous physical devices work concurrently and produce data continuously with big volumes. In this regard, NoSQL technology is utilized, because relational databases are insufficient to store and query the IoT data. NoSQL is the database technology that allows rapid organization of different non-relational data types. NoSQL databases are divided into four categories, which are key-value based, column-oriented, document-oriented and graph databases. Since graph databases do not provide effective solutions for IoT data, several studies in the literature focus on the use of database technologies in the other three categories for the purpose of storing and querying IoT data more effectively. In this paper, it is aimed to evaluate the storage and query performance of MongoDB on IoT data. It has been decided to use MongoDB, which is a document-oriented NoSQL database technology, because of its popular usage and high performance. Yahoo Cloud Serving Benchmark (YCSB), which is an open source tool developed by Yahoo that allows database operations at different volumes, is used for performance measurements. YCSB has been made compatible with the IoT dataset that is used for performance measurements, by re-organizing its DB Interface Layer for this study. The paper is concluded with discussion of the performance measurement results.