41. Databases

Relational Database Service (RDS) is not Serverless.
We have 6 relational databases (RDS) on AWS (OTLP).
i) Microsoft SQL Server
ii) Oracle
iii) MySQL Server
iv) PostgreSQL
v) Amazon Aurora
vi) Maria DB

Relational Database Service (RDS) has two key features:
i) Multi AZ – For disaster recovery
ii) Read Replicas – For performance

Non relational databases consist:
i) Collection: Collection is just a table.
ii) Document: Inside collection we have document. Document is simply a row.
iii) Key-Value pairs: These are basically fields/ columns.

Data Warehousing:
Used for BI. Tools like Cognos, Jaspersoft, SQL Server reporting services, Oracle Hyperion, SAP Netweaver etc. Used to pull very large and complex data sets. Usually used by management to do queries on data (such as current performance vs targets etc).

Online Transaction Processing (OLTP):
OLTP differs from Online Analytics Processing (OLAP) in terms of types of queries we will run.
OLTP Example: Pulls up a row of data such as name, date,ship to, deliver to, phone number etc
OLAP Example: Net profit for EMEA and Asia Pacific for the digital radio product. Pulls in large number of records.
Data Warehousing databases use different type of architecture, both from a DB perspective and infra structure layer.
Amazons data warehouse solution is called ‘Redshift’. Redshift is used for Amazons OLAP.
Dynamo DB is Amazons no sql solution.

Read Replica:
Read Replicas allow to have a read only copy of production DB.

Question 1:
What two configuration features are required to create a private database
instance?
A. security group
B. network ACL
C. CloudWatch
D. Elastic IP (EIP)
E. Nondefault VPC
F. DNS
Answer (A,F)