No items found.

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

Table 1:

                               
Name Food Preference Trained
Rufus Wet False
Markley Dry True


Table 2:

                               
Name Tag Number Height (inches)
Rufus 934 18
Markley 216 22

Table joining 1 & 2:

                               
Name Food Preference Trained Tag Number Height (inches)
Rufus Wet False 934 18
Markley Dry True 216 22

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.
                                
Key Document
1001 {
“Name”: Rufus ,
“Attributes”: [
 { “Food Preference”: Wet ,
 “Trained”: False , 
}]
“Tag Number”: 934
}
1002 {
“Name”: Markley ,
“Attributes”: [
 { “Food Preference”: Dry ,
 “Trained”: True , 
}]
“Tag Number”: 216
}

Find Similar Facts

Most Shared Facts

View All Facts