GCP Storage Offerings Flashcards
GCP NoSQL Storage Options
- Cloud Datastore - NoSQL Document Storage
- Cloud Bigtable - NoSQL Wide column
GCP Blob Storage
Cloud Storage - Binary or Object data
GCP SQL offerings
- Cloud SQL - Relational SQL for OLTP (transactional)
- Cloud Spanner - Relational SQL for OLTP (transactional)
- BigQuery - - Relational SQL for OLAP (analytical)
GCP Storage Option Best for:
Getting started and App engine Applications
Cloud Datastore
GCP Storage Option Best for:
“Flat” data, Heavy read/write, events, Analytical data
Cloud Bigtable
GCP Storage Option Best for:
Structured and unstructured data
binary and object data
Cloud Storage
GCP Storage Option Best for:
Web frameworks and existing applications
Cloud SQL
GCP Storage Option Best for:
Large-scale database applications (>~2TB)
Cloud Spanner
GCP Storage Option Best for:
Interactive Querying, offline analytics
BigQuery
GCP Storage Use Cases:
Getting started, app engine applications
Cloud Datastore
GCP Storage Use Cases:
Adtech, financial and IoT data
Cloud Bigtable
GCP Storage Use Cases:
Images, large media files, backups
Cloud Storage
GCP Storage Use Cases:
User credentials, customer orders
Cloud SQL
GCP Storage Use Cases:
Whenever high I/O, global consistency is needed
Cloud Spanner
GCP Storage Use Cases:
Data warehousing
BigQuery
What is Firebase?
Google’s mobile development platform that shares 3 products with GCP:
Cloud Firestore, Cloud Functions, and Cloud Storage
What is Cloud Datastore
(Type/Transactions/Complex Queries/Capacity/Unit Size)
- Type: NoSQL document
- Transactions: Yes
- Complex queries: No
- Capacity: TB+
- Unit Size: 1 MB per entity
What is Bigtable
(Type/Transactions/Complex Queries/Capacity/Unit Size)
Cloud Bigtable stores data in a file system called Colossus, which contains
data structures called Tablets that are used to identify and manage the data. Metadata about the Tablets is what is stored on the VMs in the Bigtable cluster itself.
- Type: NoSQL wide column
- Transactions: Single-Row
- Complex queries: No
- Capacity: PB+
- Unit Size: ~10 MB/Cell; ~100 MB/Row
What is Cloud Storage
(Type/Transactions/Complex Queries/Capacity/Unit Size)
- Type: Blobstore
- Transactions: No
- Complex queries: No
- Capacity: PB+
- Unit Size: 5 TB/object
What is Cloud SQL
(Type/Transactions/Complex Queries/Capacity/Unit Size)
- Type: Relational SQL for OLTP (Transactions)
- Transactions: Yes
- Complex queries: Yes
- Capacity: TB+
- Unit Size: Determined by DB Engine
What is Cloud Spanner
(Type/Transactions/Complex Queries/Capacity/Unit Size)
- Type: Relational SQL for OLTP (transactions)
- Transactions: Yes
- Complex queries: Yes
- Capacity: PB
- Unit Size: 10,240 MiB/Row
What is BigQuery
(Type/Transactions/Complex Queries/Capacity/Unit Size)
- Type: Relational SQL for OLAP (Analytics)
- Transactions: No
- Complex queries: Yes
- Capacity: PB+
- Unit Size: 10 MB/row
What is ACID?
- Atomic - a transaction is all or nothing
- Consistent - a transaction meets all requirements/validation rules
- Isolated - a transaction will not affect, or be affected, by other transactions
- Durability - a transaction that completed is persistent even under failure conditions
What is BASE?
- Basically Available - The database appears to work most of the time
- Soft-state - data stores and replicas do not have to be write-consistent
- Eventual consistency - data stores and replicas will eventually be consistent
