Data Storage: Storage types

Comprendere la data architecture moderna

Miller Trujillo

Senior Software Engineer

Blob storage

• BLOB = Binary Large Object
• Support all types of data, including non-structured
• Scalable. Virtually unlimited
• Blob storages are cheap!

Blob storage use cases

• Unstructured data - Media storage
• Backup and archiving
• Landing zone
• Content delivery

SQL

	SQL Databases
Use Cases	Transactional applications, applications with complex queries, data consistency and integrity
Types of Data Supported	Structured data (tabular)
Common Offerings	AWS RDS, GCP Cloud SQL, Azure SQL Database - MySQL, PostgreSQL, Data warehouse

NoSQL

	NoSQL Databases
Use Cases	High scalability and demand, eventual consistency
Types of Data Supported	Semi-structured data (JSON, XML, key-value, graph, etc), time series
Common Offerings	MongoDB, AWS DynamoDB, GCP Firestore, Azure Cosmos DB, Hbase

Data warehouses and data lakes

• BigQuery, Redshift, Snowflake, Databricks
• Blob storage (S3, Cloud Storage, Blob storage)
• Logical segregation
• ELT (Extract, load, transform)

Let's practice!

Comprendere la data architecture moderna