Using an RDBMS for structured data

A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured format, allowing relationships to be made with other data stored within the database while adhering to the Atomicity, Consistency, Isolation, and Durability (ACID) properties of all transactions. Let’s take a look at these properties.

Atomicity

This property means that the transactions are completed in a manner that ensures that all the changes to data are complete or none of them are. For example, if an application transfers money from Account A to Account B, and if the debit from Account A is successful, then it is assumed that Account B will be credited with the money being transferred.

Consistency

This property means that data is in a consistent state throughout the life cycle of the transaction. For example, in the transaction we spoke about in the previous example, if the state of the transaction is collectively...