Powered by OpenAIRE graph
Found an issue? Give us feedback
ZENODOarrow_drop_down
ZENODO
Other literature type . 2026
License: CC BY
Data sources: Datacite
ZENODO
Other literature type . 2026
License: CC BY
Data sources: Datacite
versions View all 2 versions
addClaim

A Comparative Study of SQL and NoSQL Databases for Cloud-Based Web Applications: Performance, Scalability, and Use Case Analysis

Authors: K Gnana Harish Babu, Dr K Venkata Naganjaneyulu, S Rama Krishna Sarma A, S. Narasimha Murthy, M Chathurya, M Vyshnavi;

A Comparative Study of SQL and NoSQL Databases for Cloud-Based Web Applications: Performance, Scalability, and Use Case Analysis

Abstract

Picking the right database for a cloud application sounds simple until you actually have to do it. SQL systems like MySQL have been the go-to for decades, and for good reason — but as applications started dealing with more varied data at larger scale, NoSQL systems like MongoDB began showing up in more and more production stacks. The question was never really which one is better. It’s which one actually fits your situation. This paper grew out of that frustration. We wanted something more concrete than the usual “it depends” answer, so we put both systems through real tests on the same dataset — 100,000 e-commerce records — and measured what actually happened: query speeds, read and write throughput, storage consumption, and how each system held up as data volume grew. MySQL was faster when queries got complicated, particularly joins and aggregations. MongoDB pulled ahead on write speed and handled document-style data more naturally, though it used noticeably more storage for the same records. We also cover the theory — ACID, CAP, BASE — not to pad the paper, but because those concepts genuinely explain why the benchmarks turned out the way they did. The goal is simple: give developers and architects a clear enough picture to make this call confidently for their own application.

Keywords

SQL, NoSQL, MySQL, MongoDB, Cloud Databases, Query Optimization, ACID Properties, CAP Theorem, Benchmarking, Distributed Systems, Scalability, Web Applications

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
Upload OA version
Are you the author of this publication? Upload your Open Access version to Zenodo!
It’s fast and easy, just two clicks!