Work

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

Year: 2026
Type: article
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.
Language: English
Open Access status: green
OpenAlex ID: W7236760618
FWCI:
Cites:
Cited by:
Related to: 10