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 Big Data & Machine Learning Cloud OnBoard 1 2 1 Bigtable is meant for high throughput data where access is primarily 3 for a range of Row Key prefixes 2 5 3 6 5 7 6 Row Key Column data 8 7 9 NASDAQ#1426535612045 MD:SYMBOL: MD:LASTSALE: MD:LASTSIZE: MD:TRADETIME: MD:EXCHANGE: 8 ZXZZT 600.58 300 1426535612045 NASDAQ 10 9 11 ... ... ... ... ... ... 10 12 11 13 12 Tables should be tall and narrow 14 Store changes as new rows 13 15 14 Bigtable will automatically 16 15 compact the table 1716 17 18 38