Google Cloud Veri Tabanları

Google Cloud ve AWS karşılaştırması şöyle

QUESTION					AWS					GOOGLE CLOUD
How do you create relational OLTP databases?	Amazon RDS (Amazon Aurora)		Cloud SQL, Cloud Spanner
What is the relational data warehouse solution?	Amazon Redshift				BigQuery
What are the NoSQL database options?		Amazon DynamoDB, Amazon DocumentDB	Datastore/Firestore, Cloud Bigtable
How do you cache data from a database?		Amazon ElastiCache			Memorystore

Relational OLTP Veri Tabanı

1. Cloud SQL. Açıklaması şöyle

MySQL, PostgreSQL, SQL server DBs

2. Cloud Spanner. Açıklaması şöyle

Unlimited scale and 99.999% availability for global applications with horizontal scaling

Relational OLAP Veri Tabanı - Datawarehouse İçindir

BigQuery 

No SQL Veri Tabanı

1. Cloud Firestore - NoSQL Document Database

2. Cloud BigTable - Wide Column NoSQL Veri Tabanı

In memory Veri Tabanı/caches

Cloud Memorystore. Açıklaması şöyle. Altta Redis kullanır. Yani Microsoft Azure Cache for Redis gibidir

A fully managed Redis service in the Google Cloud Platform

BigQuery - Datawarehouse

Datawarehouse içindir. Açıklaması şöyle. Serverless bir servis olduğu için otomatik olarak ölçeklenir

The service can rapidly analyze terabytes to petabytes of data.

Unlike Redshift, BigQuery doesn’t require upfront provisioning and automates various back-end operations such as data replication or scaling of computing resources. It encrypts data at rest and in transit automatically.

The BigQuery architecture consists of several components. Borg is the overall compute part, while Colossus is the distributed storage. The execution engine is called Dremel, and Jupiter is the network.

Şeklen şöyle