From the course: Complete Guide to Analytics Engineering

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Nonrelational databases

Nonrelational databases

From the course: Complete Guide to Analytics Engineering

Start my 1-month free trial Buy for my team

Nonrelational databases

“

- [Narrator] If relational databases are used for storing nice, neat data, non-relational databases are used for storing data that is much different in nature. In this video, we'll explore the unique qualities of a non-relational database. We'll compare and contrast the two and go over real world examples of when you'd use a non-relational database and a non-relational database. You might find yourself storing data in documents like JSON or XML, neither of which utilizes rows and columns to organize the actual data. The advantage of such data structures is they can save storage space. For example, take our sales data from the last video we had one row for every item sold. Notice how a lot of data ends up getting repeated. We have to store the name of the item sold, the data was sold, and the person who sold it on a new line for each sale. But what if we could list the date and the person who sold it just once, and then just list the names of the items that were sold in an array?…

Contents