Analyzing the Impact of Database Architecture on Performance: SQL vs NoSQL
Summary
No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.
Summarise with VIRAT Free to try with your Science Catalogs account.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.
Fields of Study & Subjects
Advanced Database Systems and Queries
Cloud Computing and Resource Management
Software System Performance and Reliability
Publication details
- Journal / source
- INTERNATIONAL JOURNAL OF MATHEMATICS AND COMPUTER RESEARCH
- Volume
- 14
- Issue
- 03
- Publication date
- 28 March 2026
- Language
- EN