Relational vs Non-Relational Databases

Source: Izenda Published: October 2019

Source: Izenda
Published: October 2019

Relational vs Non-Relational Databases

Circulated: May 22, 2020

Relational databases

  • Think of an Excel Spreadsheet

  • Fits nicely into rows and columns (i.e. schema)

  • Stores data in tables

  • Called Structured Query Language (SQL) databases

Non-relational databases

  • Think of a Word Document

  • Does not use a tabular schema of rows and columns

  • More flexible because data doesn’t have to fit into a pre-defined schema

  • Called Not Only SQL databases (NoSQL)

  • Four types
    - Document-oriented databases
    - Key-Value stores
    - Wide-Column stores
    - Graph stores

  • A good rule of thumb: the bigger the data set, the more likely a non-relational database is a better fit.