Performance Analysis of NoSQL Database Technologies for AI-Driven Decision Support Systems in Cloud-Based Architectures
DOI:
https://doi.org/10.63282/3050-922X.IJERET-V3I2P107Keywords:
NoSQL, MongoDB, Cassandra, Redis, Couchbase, Artificial Intelligence, Decision Support Systems, Cloud Computing, Database Performance, Big DataAbstract
With the emergence of increasingly intricate, data-driven platforms for Decision Support Systems (DSSs), as Artificial Intelligence (AI) applications increasingly are applied to a wide variety of industries, related to decision making, there is a need to carry out deeper analysis of the concept of decision support system and to assist in making sound decisions. The systems demand good, scalable and effective data management systems. The volume, variety, and velocity of data created in cloud-based AI platforms pose a challenge to traditional Relational Database Systems (RDBMSs). NoSQL databases have become an attractive alternative due to their schema-less approach, horizontal scalability, and high-performance data manipulation capabilities. In this paper, a detailed performance study of the leading NoSQL databases has been developed: MongoDB, Cassandra, Redis, and Couchbase from the perspective of decision support systems based on AI in cloud structures. We analyse all the databases using a set of parameters, including read/write latency, throughput, scalability, fault tolerance, consistency, and ease of integration with AI frameworks. Proposed methodology comprises the implementation of each of the NoSQL technologies under a simulation cloud environment with the help of benchmarking devices like YCSB (Yahoo! Cloud Serving Benchmark) and applications designed after the instructions. In addition, we suggest a decision matrix and multi-criteria analysis framework to guide architects in selecting the appropriate databases in accordance with specific AI-based DSS requirements. The findings have shown that MongoDB performed better in terms of flexibility and integration, Cassandra in write-intensive workloads and fault tolerance, Redis in low-latency operations, and Couchbase in balanced operational performance. The results of this research provide important references to the recommendations concerning the appropriateness of NoSQL solutions that can be used to improve AI-based DSS in distributed cloud environments. It educates both the researchers and practitioners on trade-offs and the best deployment practices
References
[1] Power, D. J. (2002). Decision support systems: concepts and resources for managers (Vol. 13, pp. 1-20). Westport: Quorum Books.
[2] Shim, J. P., Warkentin, M., Courtney, J. F., Power, D. J., Sharda, R., & Carlsson, C. (2002). Past, present, and future of decision support technology. Decision support systems, 33(2), 111-126.
[3] Lakshman, A., & Malik, P. (2010). Cassandra: a decentralised structured storage system. ACM SIGOPS operating systems review, 44(2), 35-40.
[4] Abramova, V., & Bernardino, J. (2013, July). NoSQL databases: MongoDB vs Cassandra. In Proceedings of the International C* conference on computer science and software engineering (pp. 14-22).
[5] Yu, Y., Li, M., Liu, L., Li, Y., & Wang, J. (2019). Clinical big data and deep learning: Applications, challenges, and future outlooks. Big Data Mining and Analytics, 2(4), 288-305.
[6] Ghemawat, S., Gobioff, H., & Leung, S. T. (2003, October). The Google file system. In Proceedings of the nineteenth ACM symposium on Operating systems principles (pp. 29-43).
[7] Zaharia, M., Xin, R. S., Wendell, P., Das, T., Armbrust, M., Dave, A., & Stoica, I. (2016). Apache spark: a unified engine for big data processing. Communications of the ACM, 59(11), 56-65.
[8] Dignum, V. (2019). Responsible artificial intelligence: how to develop and use AI responsibly (Vol. 2156). Cham: Springer.
[9] Klein, J., Gorton, I., Ernst, N., Donohoe, P., Pham, K., & Matser, C. (2015, February). Performance evaluation of NoSQL databases: a case study. In Proceedings of the 1st workshop on performance analysis of big data systems (pp. 5-10).
[10] Győrödi, C. A., Dumşe-Burescu, D. V., Zmaranda, D. R., Győrödi, R. Ş., Gabor, G. A., & Pecherle, G. D. (2020). Performance analysis of NoSQL and relational databases with CouchDB and MySQL for the application’s data storage. Applied Sciences, 10(23), 8524.
[11] Gupta, A., Tyagi, S., Panwar, N., Sachdeva, S., & Saxena, U. (2017, October). NoSQL databases: Critical analysis and comparison. In 2017 International conference on computing and communication technologies for smart nation (IC3TSN) (pp. 293-299). IEEE.
[12] Pentyala, D. K. (2018). AI-Driven Decision-Making for Ensuring Data Reliability in Distributed Cloud Systems. International Journal of Modern Computing, 1(1), 1-22.
[13] Horn, W. (2001). AI in medicine is transitioning from knowledge-intensive to data-intensive systems. Artificial intelligence in medicine, 23(1), 5-12.
[14] Murty, J. (2008). Programming Amazon Web Services: S3, EC2, SQS, FPS, and SimpleDB. "O'Reilly Media, Inc.".
[15] Compare, M., Baraldi, P., & Zio, E. (2019). Challenges to IoT-Enabled Predictive Maintenance for Industry 4.0. IEEE Internet of Things Journal, 7(5), 4585-4597.
[16] Lee, J., Ni, J., Singh, J., Jiang, B., Azamfar, M., & Feng, J. (2020). Intelligent maintenance systems and predictive manufacturing. Journal of Manufacturing Science and Engineering, 142(11), 110805.
[17] Matallah, H., Belalem, G., & Bouamrane, K. (2020). Evaluation of NoSQL databases: MongoDB, Cassandra, HBase, Redis, Couchbase, OrientDB. International Journal of Software Science and Computational Intelligence (IJSSCI), 12(4), 71-91.
[18] Boral, H., & Dewitt, D. J. (1984). A methodology for database system performance evaluation. ACM SIGMOD Record, 14(2), 176-185.
[19] Swaminathan, S. N., & Elmasri, R. (2016, June). Quantitative analysis of scalable NoSQL databases. In 2016 IEEE International Congress on Big Data (BigData Congress) (pp. 323-326). IEEE.
[20] Tang, E., & Fan, Y. (2016, November). Performance comparison between five NoSQL databases. In 2016, the 7th International Conference on Cloud Computing and Big Data (CCBD) (pp. 105-109). IEEE.
