the data dossier...appliance o e cloud dataflow cloud dataproc bigquery cloud ml cloud vision api...
TRANSCRIPT
Choosing a Managed Database
The Data Dossier
Choose a Lesson
Cloud SQL Basics
Return to Table of Contents
Importing Data
SQL Query Best Practices
Text
Choosing a Managed Database
Big picture perspective:- At minimum, know which managed database is the best solution
for any given use case:- Relational, non-relational?- Transactional, analytics?- Scalability?- Lift and shift?
Next
Relational Non-relationalObject -
UnstructuredData
Warehouse
Cloud SQL Cloud SpannerCloud
DatastoreCloud Bigtable Cloud Storage BigQuery
Structured dataWeb framework
RDBMS+scaleHigh transactions
Semi-structuredKey-value data
High throughput analytics
Unstructured dataHolds everything
Mission critical apps
Scale+consistency
Medical recordsBlogs
Global supply chainRetail
Product catalogGame state
GraphsIoT
Finance
MultimediaAnalytics
Disaster recovery
Large data analytics
Processing using SQL
Use
Case
e.g.
Choosing a Managed Database
The Data Dossier
Choose a Lesson
Cloud SQL Basics
Return to Table of Contents
Importing Data
SQL Query Best Practices
Text
Choosing a Managed Database
Decision tree criteria:- Structured (database) or unstructured?- Analytical or transactional?- Relational (SQL) or non-relational (NoSQL)?- Scalability/availability/size requirements?
Previous