IOT DATA MANAGEMENT USING MYSQL: A SCALABLE AND EFFICIENT STORAGE FRAMEWORK
Abstract
The growth of Internet of Things (IoT) devices produces enormous real-time data. This leads to difficulty in data storage, scalability and retrieval. Traditional database systems find difficulty in handling large volume of sensor data keeping low-latency performance. This paper proposes an IoT data management framework based on a relational database platform MySQL which is scalable and high performing.
The proposed framework includes optimized database schemas, indexing mechanisms, partitioning approaches and replication methods which can improve system performance and reliability. The study shows that query response time is reduced, storage utilization is increased and more scalability in dealing huge data. The study ahows that an optimized MySQL database can be used as backend solution for IoT applications.
Downloads
References
2. https://www.tencentcloud.com/techpedia/135369
3. https://www.tigerdata.com/learn/how-to-choose-an-iot-database
4. https://webyog.com/implementing-the-internet-of-things-with-mysql/
5. Using MySQL for Storing and Analysing Sensor Data in IoT System Kiran H M HBRP Publication Page 72-78 2025
6. Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments Mahmoud Eyada , Walaa Saber , Mohammed M. El Genidy, And Fathy Amer 2020
7. Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments Mahmoud Eyada , Walaa Saber , Mohammed M. El Genidy, and Fathy Amer2020
8. https://ozgurozkok.com/implementing-the-internet-of-things-with-mysql/
9. https://www.linkedin.com/pulse/why-mysql-hidden-gem-ai-powered-iot-applications-ivg4c
Copyright (c) 2026 IJRDO -Journal of Computer Science Engineering
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Author(s) and co-author(s) jointly and severally represent and warrant that the Article is original with the author(s) and does not infringe any copyright or violate any other right of any third parties, and that the Article has not been published elsewhere. Author(s) agree to the terms that the IJRDO Journal will have the full right to remove the published article on any misconduct found in the published article.
