A COMPARATIVE ANALYSIS OF SQL AND NOSQL DATABASES FOR SCALABLE DATA APPLICATIONS

Rasika Khandal

doi:10.29121/shodhkosh.v5.i1.2024.5914

Authors

Dr. Rasika Khandal Assistant Professor, B.C.A. Department, Sudha Sureshbhai Maniar College of Computer and Management, RTM Nagpur University, Nagpur, India

DOI:

https://doi.org/10.29121/shodhkosh.v5.i1.2024.5914

Keywords:

Sql, Nosql, Scalability, Relational Databases, Document Databases, Performance, Big Data, Data Modeling, Distributed Systems, Database Comparison

Abstract [English]

Today, where big data and cloud computing are the new normal, the kind of database used can affect the performance as well as scalability of applications significantly. In this paper, we are going to compare between SQL (Structured Query Language) and NoSQL (Not Only SQL) databases on parameters such as scalability, performance, data structure, flexibility and an appropriate use of these databases on various types of applications. Research is based on a combination of descriptive statistics and test of hypothesis in judging what users prefer and would like to deal with in the real world using both SQL and NoSQL. The findings give an idea about the most appropriate database model that fits in current data applications.

References

Raman, R., & Chandra, S. (2003). A Framework for Intelligent Database Systems. Journal of Computer Science and Informatics, 6(2), 112-118.

Verma, K., & Sharma, R. (2005). Artificial Intelligence Techniques in Database Query Optimization. International Journal of Computer Applications, 2(4), 45-52.

Cattell, R. (2011). Scalable SQL and NoSQL Data Stores. ACM SIGMOD Record, 39(4), 12-27. DOI: https://doi.org/10.1145/1978915.1978919

Han, J., E, H., Le, G., & Du, J. (2011). Survey on NoSQL Database. IEEE 6th International Conference on Pervasive Computing and Applications, 363-366. DOI: https://doi.org/10.1109/ICPCA.2011.6106531

Moniruzzaman, A. B. M., & Hossain, S. A. (2013). NoSQL Database: New Era of Databases for Big Data Analytics - Classification, Characteristics and Comparison. International Journal of Database Theory and Application, 6(4), 1-14.

Li, Q., & Manoharan, S. (2013). A Performance Comparison of SQL and NoSQL Databases. IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM), 15-19. DOI: https://doi.org/10.1109/PACRIM.2013.6625441

Sadalage, P. J., & Fowler, M. (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional.

Hecht, R., & Jablonski, S. (2011). NoSQL Evaluation: A Use Case-Oriented Survey. Proceedings of the International Conference on Cloud and Service Computing, 336-341. DOI: https://doi.org/10.1109/CSC.2011.6138544

Atzeni, P., & Torlone, R. (2014). Management of Data on the Web: SQL, NoSQL, and Beyond. Communications of the ACM, 57(2), 56-63.

Singh, V., & Prakash, A. (2015). Comparative Study of SQL and NoSQL Databases. International Journal of Advanced Research in Computer Science, 6(4), 20-24. DOI: https://doi.org/10.26483/ijarcs.v9i4.6279

Bajpai, R., & Agarwal, M. (2016). Evaluating the Performance of MongoDB and MySQL Databases for Big Data Workloads. International Journal of Computer Trends and Technology, 38(1), 30-35.

Batra, S., & Tyagi, C. (2017). Comparative Analysis of Relational and Non-Relational Databases. International Journal of Advanced Research in Computer Science and Software Engineering, 7(4), 439-445.

Sharma, K., & Gupta, L. (2019). Analyzing SQL and NoSQL Performance for Real-Time Applications. Journal of Information Systems and Technology, 12(2), 67-74.

Patel, S., & Mehta, R. (2020). Performance Comparison of SQL and NoSQL Databases for Big Data Applications. International Journal of Computer Science and Engineering, 8(3), 45-51.

Kumar, D., & Singh, A. (2021). ACID vs. BASE: Choosing the Right Database Model for Modern Applications. International Journal of Advanced Computing, 9(1), 22-29.

Roy, A., & Thomas, R. (2021). Scalability in NoSQL Databases: MongoDB and Cassandra Compared. Journal of Data Science and Applications, 13(2), 95-102.

Thomas, R., Roy, S., & Meena, V. (2022). Polyglot Persistence: Integrating SQL and NoSQL in Enterprise Systems. Proceedings of the International Conference on Database Technologies, 101-108.

Adams, J., & Roy, P. (2023). Benchmarking SQL and NoSQL Databases in Cloud Environments. Journal of Cloud Computing and Data Management, 15(4), 88-96.

Bansal, T., & Khurana, R. (2023). A Survey on the Role of NoSQL Databases in Real-Time Analytics. International Journal of Big Data and Analytics, 10(1), 50-59.

Singh, A., & Patel, V. (2023). Trends in Database Technology: The Rise of Multi-Model Systems. International Conference on Advances in Data Engineering, 24(2), 65-72.