A Review of Relational Database Management Systems (RDBMS) and Their Modern Applications

Relational database management systems (RDBMS) remain the usual choice for structured, transaction-oriented data, yet cloud deployment, geographic distribution, and mixed analytical workloads have changed how they are built and selected. This narrative review asks how modern architectures preserve relational correctness while moving computation, logging, and storage; which isolation, recovery, and security duties remain after that move; and how application requirements can become evaluation criteria. Twenty-two scholarly and technical sources are examined; each source carries an evidence grade (passages examined versus abstract only), and every conclusion inherits the lowest grade among its sources. MySQL, PostgreSQL, Oracle Database, and SQL Server are compared on identical criteria: default isolation level, concurrency mechanism, and backup with point-in-time recovery. A secondary analysis of one published Aurora experiment shows database-node network I/Os per transaction falling from 7.4 to 0.95 in a single historical configuration; it is not a product ranking. The review finds that storage elasticity does not establish write scalability, replica consistency does not define application-level isolation, and managed services do not remove retry, secure-query, or backup responsibilities. A requirements-first workflow with a worked example is proposed but not validated. The paper offers an integrated comparison, not a new algorithm or an independent benchmark.

Authors

Institutions

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-11-19
DOI
https://doi.org/10.5281/zenodo.24368840
Primary Topic
Advanced Database Systems and Queries
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

A Review of Relational Database Management Systems (RDBMS) and Their Modern Applications

Monali Soni, Divya Pathak, Shatakshi Gupta, Tanisha Bharti
Zenodo (CERN European Organization for Nuclear Research)
Advanced Database Systems and Queries
article

A Review of Relational Database Management Systems (RDBMS) and Their Modern Applications

Monali Soni, Divya Pathak, Shatakshi Gupta, Tanisha Bharti
article en

Abstract

Relational database management systems (RDBMS) remain the usual choice for structured, transaction-oriented data, yet cloud deployment, geographic distribution, and mixed analytical workloads have changed how they are built and selected. This narrative review asks how modern architectures preserve relational correctness while moving computation, logging, and storage; which isolation, recovery, and security duties remain after that move; and how application requirements can become evaluation criteria. Twenty-two scholarly and technical sources are examined; each source carries an evidence grade (passages examined versus abstract only), and every conclusion inherits the lowest grade among its sources. MySQL, PostgreSQL, Oracle Database, and SQL Server are compared on identical criteria: default isolation level, concurrency mechanism, and backup with point-in-time recovery. A secondary analysis of one published Aurora experiment shows database-node network I/Os per transaction falling from 7.4 to 0.95 in a single historical configuration; it is not a product ranking. The review finds that storage elasticity does not establish write scalability, replica consistency does not define application-level isolation, and managed services do not remove retry, secure-query, or backup responsibilities. A requirements-first workflow with a worked example is proposed but not validated. The paper offers an integrated comparison, not a new algorithm or an independent benchmark.

Zenodo (CERN European Organization for Nuclear Research)
Shree Guru Gobind Singh Tricentenary University (IN)
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon