Google Cloud Database Services

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 of Cloud Datastore Google Bigtable Cloud Storage Cloud SQL Cloud Spanner
Type Uses NoSQL document NoSQL wide column Blobstore Relational SQL for OLTP Relational SQL for OLTP
Transactions Support No No No Supported Supported
Supports Complex queries No No No Yes it supports Yes it supports
Capacity More than Terabytes More than Petabytes More than Petabytes Terabytes Petabytes
Entity Size 1 MB/entity 10 MB/row 5 TB/object Decided by database engine 10, 240 MiB/row

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.