Issue link: https://resources.awscloud.com/i/1496542
©2020 IDC #US47078920 5 AWS Purpose-Built DBMSs Amazon Web Services (AWS) is seeking to serve users by providing a number of managed purpose- built database options that cover most cases. In addition to support for multimodel DBMSs, AWS offers a purpose-built DBMS in each of the key data management model areas, all linked together and interactive through a common method of data interchange and governance. All are optimized to take maximum advantage of the underlying AWS environment and set of resources and are fully managed by AWS. These purpose-built DBMSs are described in the sections that follow. Relational Data Management OLTP (Amazon Aurora and Amazon Relational Database Service) AWS provides full OLTP support with the Amazon Aurora RDBMS, which features scalable ACID (atomicity, consistency, isolation, durability) support for database transactions. It features SQL interfaces that are fully compatible with either MySQL or PostgreSQL to facilitate migration from those platforms and ease of use for users of those platforms. Aurora is also available in a serverless configuration that serves the needs of low-volume, unpredictable or cyclical workloads. Amazon Relational Database Service (Amazon RDS) enables users to platform their favorite RDBMS, whether open source or commercial, on AWS, under AWS management. RDBMSs supported include MySQL, PostgreSQL, MariaDB, Microsoft SQL Server, and Oracle Database. Analytic (Amazon Redshift) Amazon Redshift is a petabyte-scale, fully managed data warehouse service designed for online analytic processing (OLAP) and business intelligence (BI) applications. It uses a massively parallel processing (MPP) clustered columnar RDBMS to carry out complex analytic queries at scale. You can use Amazon Redshift to take a "lake house" approach to data warehousing with features that enable you to query, combine, and save data from your data warehouse, data lake, and operational databases. Key-Value (Amazon DynamoDB) A key-value store enables the storing of blocks of data associated with unique key-value pairs. The format of the data block is under program control and may be in the form of a standard data document, such as JSON. It is very popular for mobile, web, gaming, ad tech, and IoT data management, as well as persistent data caching. Amazon DynamoDB is designed to offer higher performance and scalability with multiregion and multi-active capability. It is fully managed by AWS. Document (Amazon DocumentDB with MongoDB Compatibility) A document database contains explicit support for a particular document type, usually JSON, with tagged search and reporting capability. Amazon DocumentDB (with MongoDB compatibility) is a fully managed document database service that is designed to support MongoDB workloads. It enables aggregations, ad hoc queries, and flexible indexes and has a query processor that enables index intersection. Its scalability is delivered by decoupling storage from compute and allowing each to scale independently. It also replicates six copies of each database across three AWS Availability Zones (AZs).