Databases

  AWS Databases

https://www.udemy.com/aws-certified-solutions-architect-associate/learn/v4/t/lecture/2050694?start=0

Relational Databases (OLTP)

A Database is a data structure comprised of any number of Tables. Each table is comprised of any number of rows (records) of data, with any number of columns (fields).  Each row will have the exact same number of columns and each column representing a a specific type of data field (Number, Character, Text,etc.).

ID
Integer		 First Name
Text		 Last Name
Text		 Gender
Character
1 Sofia Roberts F
2 Thomas Roberts M
3 Babaloo Roberts M
4 Baby Roberts F

 

RDS supports the following Relational Databases (Know these!)

  • SQL Server (Microsoft)
  • Oracle
  • MySQL
  • PostgreSQL
  • Aurora (AWS Proprietary)
  • MariaDB

Non-Relational Databases (aka No SQL)

  • DynamoDB
  • Document Oriented databases
    • Collection (Table)
    • Document (Row)
    • Key Value Pairs (Fields)

JSON Example

{
“id”:”1″,
“firstname”:”Sofia”,
“lastname”:”Roberts”,
“age”:”56″,
“address”:[
{“street”:”1813 Rachel Ln”,
“city”:”Round Rock”}
]
}

Database Warehousing (OLAP)

  • Redshift?

Used for business intelligence. Tools like Cognos, Jaspersoft, SQL Server Reporting Services, Oracle Hyperion, SAP NetWeaver.

Used to pull in very large and complex data sets. Usually used by management to do queries on data (such as current performance vs. targets, etc.)

 

OLTP vs OLAP

  • OLTP = Online Transaction Processing
    • Order # 2120121
    • Pulls up a row of data such as Name, Date, Address to Deliver to, Delivery Status, etc.
    • “Light” load on the server.
  • OLAP = Online Analytics Processing
    • Net profit for US and UK for Digital Radio Product.
    • Pulls in a large number of records
      • Sum of radios sold in US
      • Sum of radios sold in UK
      • Unit cost of raido in each region
      • Sales price of each radio
      • Sales price – unit cost

Data Warehousing databases use different type of architecture from both a database perspective and infrastructure layer.

Elasticache

Elasticache is a web service that makes it easy to deploy, operate and scale an in-memory cache in the cloud.  The service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based datasases.  ElastiCache supports two open-source in-memory caching engines:

  • Memcached (Mem cache dee)
  • Redis

DMS (Database Migration Service)

Allows you to migrate your production database to AWS.,  Once the migration has started, AWS manages all of complexities of the migration process like data type transformation, compression, and parallel transfer (for faster data transfer) while ensuring that data changes to the source database that occur during the migration process are automatically replicated to the target.

AWS schema conversion tool automatically converts the source database schema and a majority of the custom code, including views, stored procedures and function, to a format compatible with the target database.

Example

  • Export an Oracle DB (expensive license) to a MySQL DB (free license)

 

Exam Tips

RDS

  • Create a separate Security Group for your Database instances
  • Allow access on Port 3306
  • Allow access to your Web Security Group
  • Access the DB from your Web Server using the DB Instances ‘Endpoint URL’

 

 

LEAVE A COMMENT