CCSK

 View Only
  • 1.  Relational vs. Non-relational Databases

    Posted Jan 11, 2021 12:00:00 PM

    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
    ------------------------------


  • 2.  RE: Relational vs. Non-relational Databases
    Best Answer

    CSA Instructor
    Posted Jan 18, 2021 12:42:00 AM
    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/
    ------------------------------



  • 3.  RE: Relational vs. Non-relational Databases

    Posted Jan 18, 2021 09:19:00 AM
    Thank you! This helps :)

    ------------------------------
    Jenna Morrison
    Training Department Intern
    Cloud Security Alliance
    ------------------------------