AWS Databases & Analytics
Tags: aws
Published: 2022-05-02 20:17:47

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9z9b6wg8587mf8s2brpp.png)
There are different types of databases:

1. Relational Databases:
Works using different data tables. One can use SQL language to look up something.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3hflx67u81npli7622wi.png)
2. NoSQL Databases: 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6iq80kh0fwqpvaainds7.png)
Example :
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iwvc92fs8flceyq10grv.png)

Shared Responsibility
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/uvtm1t347hpsi9n7f48r.png)


**_AWS RDS( Relational Database Service)__**  
Note: This service is a part of free tier. This database is a managed service with SQL capabilities suited for Online Transaction Processing (OLTP).

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9eupcyvukvcx75xc6h9a.png)

Advantages of using AWS RDS over EC2 for DB
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ovafgxfl3m4yh8o7fort.png)

RDS Solution Architecture
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jgtw46f762bz7zd5i8p1.png)



**_Amazon Aurora_** 
Note: This service is not part of the free tier. AWS Cloud Optimized
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ddino5of3acs6soaq1zg.png)

_RDS Deployments_
RDS read replicas main purpose is scalability. 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/36gkfccy76nsbjz93mk1.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wup84sb32bw4k9bgrguf.png)

**_Amazon ElastiCache_** 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z8b11lho631gb1my125w.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gdla30k65f44q207w7gw.png)

_DynamoDB_
NoSql database, serverless, low latency. It is a NoSQL database that can scale with no downtime and can handle millions of requests per second.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/to2pdhn592mngb6ktpwn.png)
The table will look like this
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fhapw981abr866mhxkrn.png)

_DynamoDB Accelerator-DAX_  
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/m5alegi137pwcbg0x3b1.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8oim9p1dp0298i17ludu.png)

**_Redshift_**
Good for analytics and data warehousing and also it is not good for Online Transaction Processing (OLTP) rather for OLAP (Online Analytical Processing)  
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/c1k8jesx1sgr32kri57u.png)
_Amazon EMR_ 
EMR Stands for Elastic Map Reduce and it helps create Hadoop Clusters (Big Data). 1 cluster can be made of hundreds of EC2 instances.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sup42q4i1jub7qendijy.png)

_Amazon Athena_ 
It is serverless and performs analytics in S3 objects. Serverless+ SQL capabilities.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/27luywy6eytbw5j3sivf.png)

_Amazon QuickSight_
It creates interactive dashboards. [Know More](https://aws.amazon.com/quicksight/)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8l0lfjw7lx0sarhgmxps.png)

_DocumentDB_
User case: Can help to set up fully managed MongoDB database

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/c96964cgl609yc6zostm.png)

DynamoDB accelerator (DAX) helps in-memory cache to improve up to 10X.

_AMAZON Neptune_ 
It is a graph database and is best for networking. 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qj069ygwg97o8ytdpfz8.png)

_Amazon QLDB (Quantum Ledger Database) _ 
Best for Financial transactions and ledger also it is centralized. Immutable ledger database.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fpt7rs6lm0ddovq16owr.png)
 
_Amazon Managed Blockchain_
This basically is compatible with Hyperledger Fabric and Ethereum. Also, it is de-centralized. 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b5s74u2is9h8k29fogc5.png)
_DMS( Database Migration Service)_
For the migration of the database, we use this. You can use the source while migrating.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7a5kcjp67bej3u513540.png)

_AWS Glue_
To extract, transform and load (ETL ) service we use AWS Glue and which is a serverless service
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wo3lope3nzbokiqsxtuk.png)

_Summary_
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lppegwmgiuhm2lvge300.png)