Big Data & Machine Learning Cloud OnBoard 1 2 1 Comparing storage options: technical details 3 2 5 3 6 Cloud Cloud Cloud 5 Bigtable Cloud SQL BigQuery 7 Datastore Storage Spanner 6 8 7 Type NoSQL NoSQL Blobstore Relational Relational Relational 9 document wide column SQL for OLTP SQL for OLTP SQL for OLAP 8 10 9 Transactions Yes Single-row No Yes Yes No 11 10 12 Complex No No No Yes Yes Yes 11 queries 13 12 14 Capacity Terabytes+ Petabytes+ Petabytes+ 500 GB Petabytes Petabytes+ 13 15 14 Unit size 1 MB/entity ~10 MB/cell 5 TB/object Determined 10,240 MiB/ 10 MB/row 16 ~100 MB/row by DB engine row 15 1716 17 18 Big Data & Machine Learning Cloud OnBoard 1 2 1 Comparing storage options: use cases 3 2 5 3 Cloud Bigtable Cloud Cloud SQL Cloud BigQuery 6 Datastore Storage Spanner 5 7 6 Type NoSQL NoSQL Blobstore Relational Relational Relational 8 document wide column SQL for OLTP SQL for OLTP SQL for OLAP 7 9 8 Best for Getting “Flat” data, Structured Web Large-scale Interactive 10 9 started, App Heavy and frameworks, database querying, 11 Engine read/write, unstructured existing applications offline 10 applications events, binary or applications (> ~2 TB) analytics 12 11 analytical object data 13 data 12 14 13 Use cases Getting AdTech, Images, User Whenever Data 15 14 started, App Financial large media credentials, high I/O, warehousing 16 Engine and IoT data files, customer global 15 applications backups orders consistency 1716 is needed 17 18 40