Book Image

Google Cloud Platform for Architects

By : Vitthal Srinivasan, Loonycorn , Judy Raj
Book Image

Google Cloud Platform for Architects

By: Vitthal Srinivasan, Loonycorn , Judy Raj

Overview of this book

Using a public cloud platform was considered risky a decade ago, and unconventional even just a few years ago. Today, however, use of the public cloud is completely mainstream - the norm, rather than the exception. Several leading technology firms, including Google, have built sophisticated cloud platforms, and are locked in a fierce competition for market share. The main goal of this book is to enable you to get the best out of the GCP, and to use it with confidence and competence. You will learn why cloud architectures take the forms that they do, and this will help you become a skilled high-level cloud architect. You will also learn how individual cloud services are configured and used, so that you are never intimidated at having to build it yourself. You will also learn the right way and the right situation in which to use the important GCP services. By the end of this book, you will be able to make the most out of Google Cloud Platform design.
Table of Contents (19 chapters)
13
Logging and Monitoring

Relational databases, SQL, and schemas

The heart of the RDBMS is the relational data model; data is expressed in rows and columns within tables. The names and types of the columns are defined up-front and are collectively called the schema. The rows represent the data stored in the RDBMS and can be accessed using a very popular language called SQL.

In the preceding tables, each account holder has two accounts, one savings account and one current account, and each has different balances. This can be expressed in RDBMS like in the example given below. Here you can see that each account holder is given a unique key (Customer_ID), which makes querying for savings or current account balance a lot easier and faster:

In these tables, the column definitions are the schemas: for instance, the schemas of both relations Current Accounts and Savings Accounts have three columns named Acc_ID...