Skip to content
Related Articles

Related Articles

Google Cloud Database Services

View Discussion
Improve Article
Save Article
Like Article
  • Difficulty Level : Hard
  • Last Updated : 29 May, 2020

Storage is the first-factor we choose while designing an application. Every application needs a reliable storage structure for the proper function of the software. The diversity of data may be as to be streamed or store the account-related data. It is a point that Dragonite has more than 2600 CP, which they need to manage.

The type of data storage can be different depending upon what the application is going to process. Google comes with a variety of options to store, analyze, and process this data. We know that google cloud previously has persistent disks to store huge data but to meet the customer’s new requirements they included some core storage options into their cloud infrastructure.

Let me drive you to the options they offer and you can pick from below that satisfies your applications need –

  1. Cloud Storage :
    Google Storage is a service offered by Google for storing the data objects into Google Cloud. A data object can be termed as an immutable entity that consists of data of any file irrespective of the format. It is best for the applications containing structured data objects, for example, large media files and images. Unstructured type data objects are also supported which is used for backups.

  2. Cloud Spanner :
    Google Spanner is the first of its kind data storage option, which supports relational database structure with a non-relational horizontal scale. It is highly scalable which consistent SQL support and is available at a high rate. It is best for applications having a large database for example e-commerce, trading, etc.

  3. Cloud SQL :
    Cloud SQL is a bundled service that is offered by Google Cloud. This supports relational database services for MySQL, SQL Server, and PostgreSQL. This is used to store the client’s credentials and orders which are placed by the customers.

  4. Google Big Table :
    Google Big Table is Google’s Big Data services. It is used in many known google applications such as Maps, Search, and Gmail. it is also used where the analysis work and heavy read and write cases.

  5. Cloud Data Store :
    Google Datastore is the best suited for the applications where the data is structured and applications process that type of data.his data store is highly used by software developers who are intended to work with structured data.

Difference between Services :

Basis ofCloud DatastoreGoogle BigtableCloud StorageCloud SQLCloud Spanner
TypeUses NoSQL documentNoSQL wide columnBlobstoreRelational SQL for OLTPRelational SQL for OLTP
Transactions SupportNoNoNoSupportedSupported
Supports Complex queriesNoNoNoYes it supportsYes it supports
CapacityMore than TerabytesMore than PetabytesMore than PetabytesTerabytesPetabytes
Entity Size1 MB/entity10 MB/row5 TB/objectDecided by database engine10, 240 MiB/row

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!