반응형
블로그 이미지
개발자로서 현장에서 일하면서 새로 접하는 기술들이나 알게된 정보 등을 정리하기 위한 블로그입니다. 운 좋게 미국에서 큰 회사들의 프로젝트에서 컬설턴트로 일하고 있어서 새로운 기술들을 접할 기회가 많이 있습니다. 미국의 IT 프로젝트에서 사용되는 툴들에 대해 많은 분들과 정보를 공유하고 싶습니다.
솔웅

최근에 받은 트랙백

글 보관함


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






What is Data Warehousing?


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


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.



What is 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 databases. ElasticCache supports two open-source in-memory caching engines:

- Memcached

- Redis



What is DMS?




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





반응형

Comment