Performance Evaluation of IoT Database Management using Mongo DB versus MYSQL Databases

Author: Shivani Sharma

Journal Name:

PDF Download PDF

Abstract

Internet of Things (IoT) is the latest enhancing technology in which all the physical devices are interconnected through internet. Physical devices can be refrigerator, door, watches, geyser and many more. These devices use Sensors to percept the environment and send the information to connected device. There is large amount of data that an IoT device stores. So, it’s challenging to store that huge amount of data. In this research paper we will study and evaluate the performance of SQL and NOSQL DBMS further we shall conclude why IoT prefers NOSQL DBMS to store its Data

Keywords

Sensors, percept, database management, SQL, NOSQL

Conclusion

After studying and comparing both the DBMS (MONGODB AND MYSQL) we conclude that MONGODB (NOSQL) is the best choice to store and manage huge, rapidly changing, of various types data. MONGODB leads in Flexibility, Scalability, easiness and in many properties from MYSQL. MYSQL is a popular choice when we are dealing with structured data. But now a days we are dealing mostly with unstructured data, that is it can be in form of Images, Audios, Videos and many more. Even when we are uploading any pictures they are in the form of Unstructured data. So, we can clearly say it is the generation of Unstructured data. That’s why MYSQL is not that much popular now. In IoT, data is heterogeneous, Unstructured (mostly), rapidly changing, huge volume. So, we evaluated MONGODB is the best choice to store and manage IoT Data

References

-

How to cite this article

-