EUVIMEDEUVIMED entdecken
Crossref

Analyzing the Impact of Database Architecture on Performance: SQL vs NoSQL

Dipali Jawale, Shivangi Shelke, Sapna Yadav

International Journal of Mathematics And Computer Research · 28.03.2026 · 14 (03)

DOI: 10.47191/ijmcr/v14ispc3.13 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Mathematics And Computer Research, online erschienen am 28.03.2026. Verfasst von Dipali Jawale und 2 weiteren Autor:innen.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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.

Zitieren

APA

Jawale, D., Shelke, S., & Yadav, S. (2026). Analyzing the Impact of Database Architecture on Performance: SQL vs NoSQL. International Journal of Mathematics And Computer Research, 14(03). https://doi.org/10.47191/ijmcr/v14ispc3.13

Vancouver

Jawale D, Shelke S, Yadav S. Analyzing the Impact of Database Architecture on Performance: SQL vs NoSQL. International Journal of Mathematics And Computer Research. 2026;14(03). doi:10.47191/ijmcr/v14ispc3.13

BibTeX
@article{Jawale2026,
  author = {Jawale, Dipali and Shelke, Shivangi and Yadav, Sapna},
  title = {Analyzing the Impact of Database Architecture on Performance: SQL vs NoSQL},
  journal = {International Journal of Mathematics And Computer Research},
  year = {2026},
  volume = {14},
  number = {03},
  doi = {10.47191/ijmcr/v14ispc3.13}
}
Kostenlos starten →