Database Management Challenges and Solutions in IoT Environments: A Systematic Literature Review

Ahmad Ferdaws Ahmadi; Esmatullah Hadi; Shahvali Karimi; Reshad Ahmadi; Farid Hassani

doi:10.59535/jece.v2i1.257

Authors

Ahmad Ferdaws Ahmadi Kabul University
Esmatullah Hadi Kabul University
Shahvali Karimi Kabul University
Reshad Ahmadi Kabul University
Farid Hassani Kabul University

DOI:

https://doi.org/10.59535/jece.v2i1.257

Keywords:

Internet of Things (IoT), Database Management, Challenges, Solutions, Systematic Literature Review

Abstract

The rapid proliferation of Internet of Things (IoT) devices has led to an unprecedented volume and velocity of data generation, posing significant challenges for database management. This study investigates the complexities of database management within IoT environments and explores effective methods for addressing key obstacles. Through a comprehensive literature review and analysis of existing research, the study examines how database management systems handle the immense volume and speed of data from IoT devices. It also explores methods for ensuring data security and privacy amidst the diverse data types and dynamic nature of IoT systems. Furthermore, the study assesses the potential of emerging technologies like blockchain and edge computing in addressing scalability challenges in IoT database management. The findings underscore the critical importance of scalable infrastructure, distributed computing, and optimized processing techniques in effectively managing IoT-generated data. Recommendations are provided for organizations to leverage innovative approaches and technologies to overcome the challenges posed by the IoT data landscape. Ultimately, this study contributes to advancing understanding in the field of IoT database management and provides insights for future research and development efforts.

Downloads

Download data is not yet available.

References

Cooper, J., & James, A. (2009). Challenges for database management in the internet of things. IETE Technical Review, 26(5), 320-329. [Online]. Available: https://www.tandfonline.com/doi/abs/10.4103/0256-4602.55275

Rayes, A., Salam, S., Rayes, A., & Salam, S. (2017). Internet of things (IoT) overview. Internet of Things From Hype to Reality: The Road to Digitization, 1-34. [Online]. Available: https://link.springer.com/chapter/10.1007/978-3-319-44860-2_1

Diène, B., Diallo, O., Rodrigues, J. J., Ndoye, E. H. M., & Teodorov, C. (2020, September). Data management mechanisms for IoT: architecture, challenges and solutions. In 2020 5th International Conference on Smart and Sustainable Technologies (SpliTech) (pp. 1-6). IEEE. [Online]. Available: https://link.springer.com/article/10.1007/s10586-020-03138-7

Diène, B., Rodrigues, J. J., Diallo, O., Ndoye, E. H. M., & Korotaev, V. V. (2020). Data management techniques for Internet of Things. Mechanical Systems and Signal Processing, 138, 106564. [Online]. Available: https://doi.org/10.1016/j.ymssp.2019.106564

Albouq, S. S., Abi Sen, A. A., Almashf, N., Yamin, M., Alshanqiti, A., & Bahbouh, N. M. (2022). A survey of interoperability challenges and solutions for dealing with them in IoT environment. IEEE Access, 10, 36416-36428. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/9741799

Abu-Elkheir, M., Hayajneh, M., & Ali, N. A. (2013). Data management for the internet of things: Design primitives and solution. Sensors, 13(11), 15582-15612. [Online]. Available: https://doi.org/10.3390/s131115582

Bessis, N., & Dobre, C. (Eds.). (2014). Big data and internet of things: a roadmap for smart environments (Vol. 546). Basel, Switzerland: Springer International Publishing.

Zikria, Y. B., Kim, S. W., Hahm, O., Afzal, M. K., & Aalsalem, M. Y. (2019). Internet of Things (IoT) operating systems management: Opportunities, challenges, and solution. Sensors, 19(8), 1793. [Online]. Available: https://doi.org/10.3390/s19081793

Patrono, L., Atzori, L., Šolić, P., Mongiello, M., & Almeida, A. (2020). Challenges to be addressed to realize Internet of Things solutions for smart environments. Future generation computer systems, 111, 873-878. [Online]. Available: https://doi.org/10.1016/j.future.2019.09.033

Tawalbeh, L. A., Muheidat, F., Tawalbeh, M., & Quwaider, M. (2020). IoT Privacy and security: Challenges and solutions. Applied Sciences, 10(12), 4102. [Online]. Available: https://doi.org/10.3390/app10124102

Petrakis, E. G., Sotiriadis, S., Soultanopoulos, T., Renta, P. T., Buyya, R., & Bessis, N. (2018). Internet of things as a service (itaas): Challenges and solutions for management of sensor data on the cloud and the fog. Internet of Things, 3, 156-174. [Online]. Available: https://doi.org/10.1016/j.iot.2018.09.009

Toma, C., Alexandru, A., Popa, M., & Zamfiroiu, A. (2019). IoT solution for smart cities’ pollution monitoring and the security challenges. Sensors, 19(15), 3401. [Online]. Available: https://doi.org/10.3390/s19153401

Ren, H., Li, H., Dai, Y., Yang, K., & Lin, X. (2018). Querying in internet of things with privacy preserving: Challenges, solutions and opportunities. IEEE Network, 32(6), 144-151. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/8315210

M. Babar, F. Khan, W. Iqbal, A. Yahya, F. Arif, Z. Tan, and J. M. Chuma, "A secured data management scheme for smart societies in industrial internet of things environment," IEEE Access, vol. 6, pp. 43088-43099, 2018. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/8423621

W. Z. Khan, M. H. Rehman, H. M. Zangoti, M. K. Afzal, N. Armi, and K. Salah, "Industrial internet of things: Recent advances, enabling technologies and open challenges," Computers & Electrical Engineering, vol. 81, p. 106522, 2020. [Online]. Available: https://doi.org/10.1016/j.compeleceng.2019.106522

P. T. A. Mai, J. K. Nurminen, and M. Di Francesco, "Cloud databases for internet-of-things data," in 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom), 2014, pp. 117-124. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/7059651

J. Davies and C. Fortuna (Eds.), The Internet of Things: From Data to Insight. John Wiley & Sons, 2020.

S. Rautmare and D. M. Bhalerao, "MySQL and NoSQL database comparison for IoT application," in 2016 IEEE International Conference on Advances in Computer Applications (ICACA), 2016, pp. 235-238. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/7887957

S. Amghar, S. Cherdal, and S. Mouline, "Which NoSQL database for IoT applications?," in 2018 International Conference on Selected Topics in Mobile and Wireless Networking (MoWNet), 2018, pp. 131-137. [Online]. Available: https://ieeexplore.ieee.org/abstract/document/8428922

C. Asiminidis, G. Kokkonis, and S. Kontogiannis, "Database systems performance evaluation for IoT applications," International Journal of Database Management Systems (IJDMS) Vol, vol. 10, 2018. [Online]. Available: https://dx.doi.org/10.2139/ssrn.3360886

S. Vongsingthong and S. Smanchat, "A review of data management in internet of things," Asia-Pacific Journal of Science and Technology, vol. 20, no. 2, pp. 215-240, 2015. [Online]. Available: http://resjournal.kku.ac.th/