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.
It is one of the fastest and most widely used cloud data warehouse.
It has 3x better price-performance than other cloud data warehouses
Can handle exabytes of data.
It is specifically created for online data processing so, it is not good for transaction based data which most client side databases need.
Amazon Redshift stores data in columns, using specialized data compression encodings for optimum memory usage and disk I/O.
It is highly available and runs very fast by running a lot of queries in parallel on DB
It can be easily integrated with S3 and other AWS analytics services so that we can have all analysis at one place
You can easily integrate AWS and third party BI tools to create dashboard on it
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.
It is server less you don't have to worry abut servers and it can scale as much as you want
You only pay for the queries you run
It lets you run SQL on AWS S3 by defining a schema
It is really interactive by running huge queries in parallel and gives response in milliseconds
You can put your results back in S3 so storage is not a problem
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
It is a NoSQL database
It uses JSON data fore returning data from queries
It can scale up to millions of requests per second
It's a fully managed database with high availability and replication across 3 AZ
It scales to 64TiB automatically.
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
It automatically backs up data for usage
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.
It is fully managed graph data base so you don't have to worry about database management
It is a graph database that so you can use it to create social networks
It is a highly available database and stores data across multiple AZ
It continuously backs up your data to Amazon S3
Can support millions of relations and query them with millisecond latency
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
It is a fully managed ledger database mostly used to store financial transactions.
It is a fully managed database so we don't need to do database administration
It maintains a complete and sequenced history of changes over time.
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.
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
It is a centralized database
It's highly available and data is copied across multiple AZ without any extra charges
It can stream data using AWS Kinesis
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.
Blockchain makes it possible to build applications without the need of central trusted authority
It allows you to join public blockchain networks
You can also create your won private blockchains using this
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.