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.

Comment
Share
Share this post
Relational vs Non-Relational Databases
www.factoftheday1.com

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

© 2022 Fact of the Day 1
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing