Fact of the Day 1

Share this post

Relational vs Non-Relational Databases

www.factoftheday1.com

Relational vs Non-Relational Databases

Source: Izenda Published: October 2019

Danny Sheridan
May 22, 2020
1
Share this post

Relational vs Non-Relational Databases

www.factoftheday1.com

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.

Share this post

Relational vs Non-Relational Databases

www.factoftheday1.com
Comments
TopNewCommunity

No posts

Ready for more?

© 2023 Fact of the Day 1
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing