Data storage and retrieval

Data Science for Business

Michael Chow

Data Scientist

Parallel storage solutions

The cloud

Types of data storage

Unstructured

• Email
• Text
• Video and audio files
• Web pages
• Social media

Document Database

Types of data storage

Unstructured

• Email
• Text
• Video and audio files
• Web pages
• Social media

 

Document Database

Tabular

Customer Name	Customer Address	...
Jane Doe	123 Maple St.	...

   

Relational Database

Data querying

Data querying

Data Type	Query Language
Document Database	NoSQL
Relational Database	SQL

Putting it all together: Location

• On-premises cluster
• Cloud provider:
  • Azure
  • AWS
  • Google Cloud

Putting it all together: Data type

Putting it all together: Data type

 

Data Type	Storage Solution
Unstructured	Document Database
Tabular	Relational Database

Putting it all together: Queries

Putting it all together: Queries

 

Data Type	Query Language
Document Database	NoSQL
Relational Database	SQL

Let's practice!

Data Science for Business