Tuesday, May 9, 2023

GCP-RELATIONAL DATABASES, CLOUD SQL,CLOUD SPANNER


                   RELATIONAL DATABASES

Google cloud provides another solution is relational databases, we talked about dynamic and static data. The dynamic data that changes like user sign up, product purchase, Gmail account, password. And one of the services is which can relational databases

OTHER SERVICES OF GCP DATABASE. 

Cloud SQL and Cloud Spanner can be used together. 

Cloud Spanner: Is a proprietary database owned by google cloud and it can scale horizontally to the moon (globally). Its great at enterprise application and highly available database guarantee. Its more robust.

Cloud SQL: Is a simpler and more structured database, straightforward, automatic backup and replicate for high availability. Examples of database engine PostgresSQL, MySQL databases

Non-relational databases

This is a database that is not specific, and can adapt based on the input that its receiving. In this regards google cloud use BIGTABLE and DATASTORE. 

BIG TABLE: Is a NoSQL distributed database developed by google. Its design to handle massive amount of data. And it stores data as KEY VALUE PAIRS in real time to access large volume of data. It is built on top of compute infrastructure including file system MapReduce which allow you to scale. 

DATA WARE HOUSE : Is a centralized repository that stores structured and processed data from various sources for easy business flow. Its used to store and manage large volume of data.

For example, In most cases, if an organization is taking advantage of aggregated data for decades like Coca-cola. Data is what keep an organization in business. You can use BIG QUERY to store any amount of data. You can manage your customers data by introducing business intelligence with the use of collected data. Its very cheap. 



Referencing : Questia https://www.blogger.com/blog/post/edit/5428112557550405099/1915938476651859976

Google Documentation

No comments:

Post a Comment

CONFIGURING A PHISHING CAMPAIGN IN MICROSOFT DEFENDER.

Configuring a phishing campaign in Microsoft Defender (specifically Microsoft Defender for Office 365) involves creating a simulated attack ...