Keywords:-
Article Content:-
Abstract
The exponential growth of data in modern applications has intensified the need for efficient and scalable database management systems. This research analyzes the impact of database architecture on system performance by comparing traditional SQL (relational) and NoSQL (non-relational) database models. SQL databases, characterized by their structured schema and ACID compliance, are optimized for transactional integrity and complex query operations. Conversely, NoSQL databases emphasize horizontal scalability, flexible data models, and high availability, making them well-suited for big data and real-time applications. The study employs a practical benchmarking approach using representative systems — PostgreSQL (SQL) and MongoDB / Cassandra (NoSQL) — tested under various workloads, including read-intensive, write-intensive, and mixed transaction environments. Key performance metrics such as latency, throughput, CPU utilization, memory consumption, and scalability were measured and analyzed. Results indicate that while SQL databases outperform NoSQL systems in complex query execution and transactional consistency, NoSQL databases exhibit superior write throughput and horizontal scalability under high-volume distributed workloads. The findings highlight that no single database architecture is universally optimal; performance and efficiency depend heavily on the application’s data structure, consistency requirements, and workload patterns. The study concludes with practical recommendations for selecting an appropriate database architecture and emphasizes the growing relevance of hybrid or polyglot persistence models that combine the strengths of both paradigms.
References:-
References
W. Khan, T. Kumar, Z. Cheng, K. Raj, A. M. Roy, and B. Luo, “SQL and NoSQL Databases Software Architectures Performance Analysis and Assessments – A Systematic Literature Review,” arXiv preprint, 2022.
Qaddara, Y. Alraba’nah, and M. O. Hiari, “Evaluation of SQL and NoSQL Databases on Parallel Processing,” Engineering, Technology & Applied Science Research, vol. 15, no. 4, pp. 24298–24304, 2025.
M. Z. Khan, F. Uz Zaman, M. Adnan, A. Imroz, M. A. Rauf, and Z. Phul, “Comparative Case Study: An Evaluation of Performance Computation between SQL and NoSQL Database,” Journal of Software Engineering, (year not specified).
H. Balasubramanian, “Performance Analysis of Scalable SQL and NoSQL Databases: A Quantitative Approach,” M.S. thesis, Wayne State Univ., 2014.
K. Shivangi, P. Kaur, and A. Pranjal, “Empirical Evaluation of NoSQL and Relational Database Systems,” Recent Advances in Computer Science and Communications, vol. 14, no. 8, 2021.
K. Gupta, “Comparative Study of SQL vs NoSQL Databases for Web Applications,” Int. J. Res. Modern Eng. & Emerging Technol. (IJRMEET), 2025.
Hiremath, “Comparative Analysis of Relational vs NoSQL Databases in Web Applications Dataset,” Int. J. Res. Modern Eng. & Emerging Technol. (IJRMEET), 2025.
[8] R. Khandal, “A Comparative Analysis of SQL and NoSQL Databases for Scalable Data Applications,” ShodhKosh: Journal of Visual and Performing Arts, vol. 5, no. 1, 2024.
K. Jain, “Experimental Evaluation: Is NoSQL better than SQL Database?,” Preprint, 2024.
M. S. Kumar and J. Prabhu, “Comparison of NoSQL Database and Traditional Database – An Emphatic Analysis,” Int. J. on Informatics Visualization, (year not specified).
S. R. S. Al Maamari and M. Nasar, “A Comparative Analysis of NoSQL and SQL Databases: Performance, Consistency, and Suitability for Modern Applications with a Focus on IoT,” East Journal of Computer Science, vol. 1, no. 2, pp. 10–15, 2025.
E. Popescu and A. Radu, “A Comparative Study of Scalability and Performance in NoSQL Databases for Big Data Storage and Retrieval,” Int. J. Applied Health Care Analytics, (year not specified).
F. Eppinger and U. Störl, “NoSQL Database Tuning through Machine Learning,” arXiv preprint, 2022.
A. E. Alflahi, M. A. Y. Mohammed, and A. Alsammani, “Enhancement of Database Access Performance by Improving Data Consistency in a Non-relational Database System (NoSQL),” arXiv preprint, 2023.
S. Venkatraman, K. Fahd, S. Kaspi, and R. Venkatraman, “SQL Versus NoSQL Movement with Big Data Analytics,” Int. J. Information Technology and Computer Science (IJITCS), vol. 8, no. 12, pp. 59–66, 2016.
Performance Benchmarks for SQL vs NoSQL Databases Under High Load Scenarios, peerdh.com, [Online].
NashTech Blog, “Database Load Testing: NoSQL vs SQL Comparison using JMeter,” 2025, [Online].
M. S. Kumar and J. Prabhu, “Comparison of NoSQL Database and Traditional Database – An Emphatic Analysis,” Int. J. on Informatics Visualization, (year not specified). [Repeated for completeness.]
M. Abubakar, S. Abubakar, and U. M. Bello, “Analyzing and Designing an Evaluation Benchmark for SQL and NoSQL Database Systems for some Selected Higher Institution in Zamfara State,” Int. J. Science for Global Sustainability, vol. 10, no. 2, (year not specified).
Floratou et al., “It was noted that NoSQL database was slower than the relational database due to the mass amount of memory usage by the NoSQL database,” I.J. Information Technology and Computer Science, vol. 12, pp. 59–66, (year not specified).