Data Flashcards
Cloud Storage High Level
Object. Binary or object data. Ex: images, media servering, backups
Filestore High Level
File. Network Attached Storage (NAS). Ex: Latency sensitive workloads
Cloud SQL High Level
Relational. Web frameworks. Ex: CMS, eCommerce
Cloud Spanner High Level
Relational. RDBMS+scale, HA, HTAP. Ex: User metadata, Ad/Fin/MarTech
Firestore High Level
Non Relational. Hierarchical, mobile, web. Ex: user profiles, game state
Cloud Bigtable High Level
Non Relational. Heavy read +write, events. AdTech, financial, IoT
BigQuery High Level
Warehouse. Enterprise data warehouse. Analytics, dashboards
Storage Decision Chart
Structured Yes? Workload Analytics Yes? Need updates or low latency Yes? = Cloud Bigtable
Structured Yes? Workload Analytics Yes? Do not need updates or low latency? = BigQuery
Structured Yes? Workload Analytics No. Relational Yes? Horizontal Yes? = Cloud Spanner
Structured Yes? Workload Analytics No. Relational Yes? Horizontal No? = Cloud SQL
Structured Yes? Workload Analytics No. Relational No? = Firestore
Structured No? Shared file system Yes? = Filestore
Structured No? Shared file system No? = Cloud Storage