6 AWS Databases that you should know

AWS Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It can scale from a few hundred gigabytes of data and scale to a petabyte or more. This enables you to use your data to acquire new insights for your business and customers. It analyze all of your data with the fastest and most widely used cloud data warehouse.

Following are the features of AWS Redshift :

1. It is one of the fastest and most widely used cloud data warehouse.

2. It has 3x better price-performance than other cloud data warehouses

3. Can handle exabytes of data.

4. It is specifically created for online data processing so, it is not good for transaction based data which most client side databases need.

5. Amazon Redshift stores data in columns, using specialized data compression encodings for optimum memory usage and disk I/O.

6. It is highly available and runs very fast by running a lot of queries in parallel on DB

7. It can be easily integrated with S3 and other AWS analytics services so that we can have all analysis at one place

8. You can easily integrate AWS and third party BI tools to create dashboard on it

AWS Athena

AWS Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is server less, so there is no infrastructure to manage, and you pay only for the queries that you run.

Following are the features of AWS Athena :

1. It is server less you don't have to worry abut servers and it can scale as much as you want

2. You only pay for the queries you run

3. It lets you run SQL on AWS S3 by defining a schema

4. It is really interactive by running huge queries in parallel and gives response in milliseconds

5. You can put your results back in S3 so storage is not a problem

Document DB

AWS DocumentDB with MongoDB compatibility is a database service that is purpose-built for JSON data management at scale, fully managed and integrated with AWS, and enterprise-ready with high durability. It is compatible with MongoDB using AWS data migration service. It supports most of the Mongo DB API but not all

Following are the features of Document DB:

1. It is a NoSQL database

2. It uses JSON data fore returning data from queries

3. It can scale up to millions of requests per second

4. It's a fully managed database with high availability and replication across 3 AZ

5. It scales to 64TiB automatically.

6. It implements the Apache 2.0 open source MongoDB 3.6 and 4.0 APIs by emulating the responses that a MongoDB client expects from a MongoDB server

7. It automatically backs up data for usage

AWS Neptune

AWS Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets. The core of Amazon Neptune is a purpose-built, high-performance graph database engine optimized for storing billions of relationships and querying the graph with milliseconds latency.

Following are the features of AWS Neptune :

1. It is fully managed graph data base so you don't have to worry about database management

2. It is a graph database that so you can use it to create social networks

3. It is a highly available database and stores data across multiple AZ

4. It continuously backs up your data to Amazon S3

5. Can support millions of relations and query them with millisecond latency

AWS QLDB

AWS QLDB is a fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log ‎owned by a central trusted authority. Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time

Following are the features of AWS QLDB :

1. It is a fully managed ledger database mostly used to store financial transactions.

2. It is a fully managed database so we don't need to do database administration

3. It maintains a complete and sequenced history of changes over time.

4. Data on the journal cannot be deleted or modified. It's history can be accessed and you can query and analyze the history to see how your data has changed over time.

5. It uses the SHA 256 to create a secure output file of your data's change history. So that it can be verified tat data is not changed

6. It is a centralized database

7. It's highly available and data is copied across multiple AZ without any extra charges

8. It can stream data using AWS Kinesis

AWS Managed Blockchain

Amazon Managed Blockchain is a fully managed service that makes it easy to join public networks or create and manage scalable private networks using the popular open-source frameworks Hyperledger Fabric and Ethereum.

Following are the features of AWS Managed Blockchain

1. Blockchain makes it possible to build applications without the need of central trusted authority

2. It allows you to join public blockchain networks

3. You can also create your won private blockchains using this

4. It can easily scale your blockchain network as the usage of applications on the network grows over time as it is a fully managed service

With this we have finished the AWS database series. next we will start on container services in AWS.