Roughly speaking, relational databases have historically been used for transactional data, such as bank accounts. With these, consistency and atomicity of transactions is most important. With these databases, the data model is also very stable, it does not change often.
Non-relational databases are more associated with business intelligence, data warehousing, and analytics. Think marketing and customer interaction data. With these, atomicity is not so important, as long as you eventually have all the data in a consistent format. The use-case typically is that you first ingest the data, then later try to apply a data model to that. This acts as kind of a lens through which to look at the data ('torture the data until it confesses').
See also
https://en.wikipedia.org/wiki/ACID------------------------------
Peter HJ van Eijk
CCSK & CCAK trainer
https://www.clubcloudcomputing.com/------------------------------
Original Message:
Sent: Jan 11, 2021 11:59:55 AM
From: Jenna Morrison
Subject: Relational vs. Non-relational Databases
Hello,
In the Security Guidance V4, when talking about databases as one of the main cloud data storage types, they bring up relational and non-relational databases. I was wondering if there are benefits of one over the other? Or is one used to store specific types of data?
Thanks :)
------------------------------
Jenna Morrison
Training Department Intern
Cloud Security Alliance
------------------------------