Structuring SQL/ NoSQL databases for IoT data
Abstract
The proliferation of Internet of Things (IoT) devices has led to an exponential increase in the volume, velocity, and variety of data generated from diverse sources. Efficiently structuring databases to store and manage this vast and heterogeneous IoT data presents significant challenges. This research paper explores the design considerations and methodologies for structuring SQL and NoSQL databases to effectively store and analyze IoT data. Through a comprehensive review of existing literature and case studies, the paper examines various database models, schema designs, indexing techniques, and data partitioning strategies tailored to the unique characteristics of IoT data. Additionally, the paper investigates the trade-offs between SQL and NoSQL databases in terms of scalability, flexibility, consistency, and performance for IoT applications. The findings provide valuable insights and guidelines for database architects, developers, and researchers to optimize database structures for efficient storage, retrieval, and analysis of IoT data, thereby enabling innovative IoT applications and services in diverse domains.
Downloads
References
Abadi, D. J., Boncz, P. A., & Harizopoulos, S. (2009). The Design and Implementation of Modern Column-Oriented Database Systems. Foundations and Trends® in Databases, 2(3), 195-259.
Agrawal, R., & El Abbadi, A. (2020). Database Management Systems: A Technical Perspective. CRC Press.
Chaudhuri, S., & Dayal, U. (1997). An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, 26(1), 65-74.
Dean, J., & Ghemawat, S. (2008). MapReduce: Simplified Data Processing on Large Clusters. Communications of the ACM, 51(1), 107-113.
Gehani, A., & Jagadish, H. V. (2002). Database Management Systems for Internet Applications. ACM Computing Surveys, 34(3), 277-292.
Han, J., & Kamber, M. (2006). Data Mining: Concepts and Techniques. Morgan Kaufmann Publishers.
Hellerstein, J. M., & Stonebraker, M. (Eds.). (2008). Readings in Database Systems. MIT Press.
Hadoop Apache. (n.d.). Apache Hadoop. Retrieved from https://hadoop.apache.org/
Inmon, W. H., & Hackathorn, R. D. (2003). Using the Data Warehouse. Wiley.
Lakshman, A., & Malik, P. (2010). Cassandra: A Decentralized Structured Storage System. ACM SIGOPS Operating Systems Review, 44(2), 35-40.
Singh, K. Artificial Intelligence & Cloud in Healthcare: Analyzing Challenges and Solutions Within Regulatory Boundaries.
Bhanushali, A., Singh, K., Sivagnanam, K., & Patel, K. K. (2023). WOMEN'S BREAST CANCER PREDICTED USING THE RANDOM FOREST APPROACH AND COMPARISON WITH OTHER METHODS. Journal of Data Acquisition and Processing, 38(4), 921.
Singh, K. HEALTHCARE FRAUDULENCE: LEVERAGING ADVANCED ARTIFICIAL INTELLIGENCE TECHNIQUES FOR DETECTION.
Leavitt, N. (2010). Will NoSQL Databases Live Up to Their Promise? Computer, 43(2), 12-14.
MongoDB. (n.d.). MongoDB. Retrieved from https://www.mongodb.com/
O'Reilly, T. (2005). What Is Web 2.0: Design Patterns and Business Models for the Next Generation of Software. O'Reilly Media.
Oracle Corporation. (n.d.). Oracle Database. Retrieved from https://www.oracle.com/database/
Poulos, M. (2012). Big Data Analytics: From Strategic Planning to Enterprise Integration with Tools, Techniques, NoSQL, and Graph. Apress.
Rabl, T., & Jacobsen, H. A. (2012). Data-Centric Benchmarking of Cloud Databases. Proceedings of the VLDB Endowment, 5(12), 1979-1982.
RavenDB. (n.d.). RavenDB. Retrieved from https://ravendb.net/
Stonebraker, M. (2005). One Size Fits All: An Idea Whose Time Has Come and Gone. IEEE Data Engineering Bulletin, 28(3), 3-10.
Tennison, J. (2008). Pro CouchDB: Scalable NoSQL Database Based on Apache CouchDB. Apress.
Wang, H., Cai, Y., & Shu, Z. (2017). Performance Evaluation of NoSQL Databases: A Case Study. IEEE Access, 5, 1297-1307.
YCSB. (n.d.). Yahoo! Cloud Serving Benchmark (YCSB). Retrieved from https://github.com/brianfrankcooper/YCSB
Yu, H., & Vahdat, A. (2016). Efficient Data Management for IoT Systems. IEEE Internet Computing, 20(6), 12-19.
Zaharia, M., Chowdhury, M., Franklin, M. J., Shenker, S., & Stoica, I. (2010). Spark: Cluster Computing with Working Sets. HotCloud, 10(10-10), 95.
Bhanushali, A., Singh, K., & Kajal, A. (2024). Enhancing AI Model Reliability and Responsiveness in Image Processing: A Comprehensive Evaluation of Performance Testing Methodologies. International Journal of Intelligent Systems and Applications in Engineering, 12(15s), 489-497.
Singh, K., Bhanushali, A., & Senapati, B. (2024). Utilizing Advanced Artificial Intelligence for Early Detection of Epidemic Outbreaks through Global Data Analysis. International Journal of Intelligent Systems and Applications in Engineering, 12(2), 568-575.
