Relational vs Non-Relational

Let us take the example of keeping a database of users and their comments. What are the differences between a Relational and a Non-Relational database in this scenario

Relational (SQL)

We would start with a table for the users. All new users must follow this same format.

users

id	name	age	city
1	Nick	56	Denver
2	Sarah	34	NYC
3	Dave	15	Paris

and a comments table

comments

id	comment
1	“Great post, thanks.”
2	“Dogs > Cats”
3	“I strongly disagree.”
4	“Happy Birthday friend!”

There is currently no information that is linking the users to the comments. Who said what? To join the two together we need to have a Join Table.

join table

userId	commentId
1	3
1	2
3	1
4	4

The key takeaway here, is that everything is tabular. Tables must be defined ahead of time and are not flexible. If I wanted to add a new piece of information for the users table, like birthday, I could add a column, but I have to put in a value for every single user, even if I don’t know the correct information. This will result in a lot of null values in the database.

users

id	name	age	city	birthday
1	Nick	56	Denver	null
2	Sarah	34	NYC	8/24/85
3	Dave	15	Paris	null

Non-Relational (NoSQL)

In Non-Relational tables we don’t have to define patterns ahead of time. They are much more flexible. There are no tables, and therefore no tabular structure, and data can be nested. It is not “flat”.

Non-Relational databases use a format called BSON (Binary JavaScript Object Notation).

// BSON Data Structure
{
    name: "Dave",
    age: 25,
    city: "Detroit",
    comments: [
        {text: "I'm from Motor City."},
        {text: "I miss the pizza in Chicago."}
    ]
}

Note that the comments are nested inside of the data.

Which Is Better?

One is not better than the other. Relational databases are more common, and will work better in most situations. But there are some situations where a non-relational database will be advantageous.

Automated Amazon Reports

Automatically download Amazon Seller and Advertising reports to a private database. View beautiful, on demand, exportable performance reports.

bidbear.io