There are different types of databases:
- Relational Databases: Works using different data tables. One can use SQL language to look up something.
- NoSQL Databases: Example :
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).
Advantages of using AWS RDS over EC2 for DB
Amazon Aurora
Note: This service is not part of the free tier. AWS Cloud Optimized
RDS Deployments
RDS read replicas main purpose is scalability.
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.
The table will look like this
Redshift
Good for analytics and data warehousing and also it is not good for Online Transaction Processing (OLTP) rather for OLAP (Online Analytical Processing)
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.
Amazon Athena
It is serverless and performs analytics in S3 objects. Serverless+ SQL capabilities.
Amazon QuickSight
It creates interactive dashboards. Know More
DocumentDB
User case: Can help to set up fully managed MongoDB database
DynamoDB accelerator (DAX) helps in-memory cache to improve up to 10X.
AMAZON Neptune
It is a graph database and is best for networking.
_Amazon QLDB (Quantum Ledger Database) _
Best for Financial transactions and ledger also it is centralized. Immutable ledger database.
Amazon Managed Blockchain
This basically is compatible with Hyperledger Fabric and Ethereum. Also, it is de-centralized.
DMS( Database Migration Service)
For the migration of the database, we use this. You can use the source while migrating.
AWS Glue
To extract, transform and load (ETL ) service we use AWS Glue and which is a serverless service