Data storage and retrieval

Understanding Data Science

Sara Billen

Curriculum Manager

The data science workflow

Things to consider when storing data

• Location
• Data type
• Retrieval

Location: Parallel storage solutions

Location: 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

Retrieval: Data querying

Retrieval: 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!

Understanding Data Science