[AWS Certificate] Developer - Databases Overview & Concepts
2017. 11. 8. 10:36 |
CloudGuru (Udemy lecture)
AWS Certified Developer - Associate 2017
================================================================
============= Databases Overview & Concepts ====================
================================================================
Database 101
This section is not so much in the Exam. This is just for fundamental knowledge on Database.
(DynamoDB is mostly in the Exam and we will learn it from next article)
What is Relational database?
Relational databases are what most of us are all used to. They have been around since the 70's. Think of a traditional spreadsheet
- Database
- Table
- Row
- Fields (Columns)
Relational Database Types
- SQL Server
- Oracle
- MySQL Server
- PostgreSQL
- Aurora
- MariaDB
Non Relational Databases
- Database
: Collection ==> Table
: Document ==> Row
: Key Value Pairs ==> Fields
JSON/NoSQL
Sample
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.)
Online Transaction Processing (OLTP) differs from OLAP Online Analytics Processing (OLAP) in terms of the types of queries run.
OLTP Example:
Order number 2120121
Pulls up a row of data such as Name, Date, Address to Deliver to , Delivery Status etc.
OLAP
OLAP transaction Example:
Net Profit for EMEA and pacific for the Digital Radio Product.
Pulls in large numbers of records
Sum of Radios Sold in EMEA
Sum of Radios Sold in Pacific
Unit Cost of Radio in each region
Sales price of each radio
Sales price - unit cost.
Data Warehousing databases use different type of architecture both from a database perspective and infrastructure layer.
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 databases. ElasticCache supports two open-source in-memory caching engines:
- Memcached
- Redis
Announced at re:Invent 2015, DMS stands for Database Migration Service.
Allows you to migrate your production database to AWS. Once the migration has started, AWS mansges all the 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 functions, to a format compatible with the target database.
AWS Database Types - Summary
RDS - OLTP
: SQL
: MySQL
: PostgreSQL
: Oracle
: Aurora
: MariaDB
DynamoDB - No SQL
Redshift - OLAP
Elasticache - In Memory Caching
: Memcached
: Redis
DMS
'IoT > AWS Certificate' 카테고리의 다른 글
[AWS Certificate] Developer - CloudFormation, Shared Responsibility Model and DNS Basic (0) | 2017.11.21 |
---|---|
[AWS Certificate] Developer - SNS, SWF and Elastic Beanstalk (0) | 2017.11.17 |
[AWS Certificate] Developer - SQS (Simple Queue Service) (0) | 2017.11.16 |
[AWS Certificate] Developer - DynamoDB Summary & Quiz (0) | 2017.11.15 |
[AWS Certificate] Developer - DynamoDB memo (0) | 2017.11.14 |
[AWS Certificate] Developer - S3 Summary and Quiz (1) | 2017.11.07 |
[AWS Certificate] Developer - S3 Memo - from Cloud Guru Lecture (0) | 2017.11.03 |
[AWS Certificate] Developer - EC2 - Summary & Exam TIps (A Cloud Guru) (0) | 2017.10.18 |
[AWS Certificate] Developer - ELB, SDK and Lambda memo (0) | 2017.10.17 |
[AWS Certificate] Developer - AWS CLI memo (0) | 2017.10.12 |