Data Storage: Storage types

Understanding Modern Data Architecture

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!

Main blob storages offerings from public clouds

Understanding Modern Data Architecture

Blob storage use cases

  • Unstructured data - Media storage
  • Backup and archiving
  • Landing zone
  • Content delivery
Understanding Modern Data Architecture

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
Understanding Modern Data Architecture

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
Understanding Modern Data Architecture

Data warehouses and data lakes

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

Let's practice!

Understanding Modern Data Architecture

Preparing Video For Download...