Refresher of RDBMS and SQL
An RDBMS is a piece of software that manages data (represented for the end user in tabular form) on physical hard disks and is built using Codd's relational model. Most of the databases that we encounter today are RDBMS. In recent years, there has been a huge industry shift toward a newer kind of database management system, called NoSQL (MongoDB, CouchDB, Riak, and so on). These systems, while they do follow some of the rules of RDBMS in certain aspects, in most cases they reject or modify them.
How Is an RDBMS Structured?
The RDBMS structure consists of three main elements, namely the storage engine, the query engine, and log management. Here is a diagram that demonstrates the structure of an RDBMS:
Figure 8.2: RDBMS structure
The following are the main concepts of any RDBMS structure:
- Storage engine: This is the part of the RDBMS that is responsible for storing data in an efficient way and also retrieving it,...
