Cloud Computing - Database Introduction

Find code and diagrams at: https://www.EliTheComputerGuy.com

Databases contain the records that are required for most advanced applications to run. Databases themselves only store data, and you need to create a front end and intelligence for users to be able to interact with it.

Finished product are created by having a database, a Frontend Application, and the intelligence created in a programming language for how data should be written to, and read from the database.
Databases only offer data storage. Unlike MS Access most databases do not offer an easy way to interact with data.
Database Software – There are numerous database products available from ServerBbased to Cloud Services.
Database – is the highest level in a Database
Tables – Are containers for “like” information. Such as information about Parts, or Users
Columns/ Fields – within Tables these are the individual types of information such as First Name, Last Name, Address.
Primary Keys – EVERY record needs to be unique within a Table. To make sure this happens you have a Primary Key such as a UserID, or PartID that is absolutely unique within the Table.
Rows/ Records – Rows are the individual Records stored with a Table.
Schema – Is the Column names within Tables. These are set by the Database Administrator and the Database cannot store Data that has not been anticipated by the Schema.
Relational Databases – have the Tables related to each other by Keys. So an Order Record would include the CustomerID, the PartID, and then any additional information.
Clusters – databases servers are setup in clusters so that if one fails the service is still available. They copy information to each other through a Replication Strategy.
Database Servers can be Read/Write, Read, and just Write. This allows administrators to deploy servers to perform best for what is required and for security.