CATEGORY DEEP DIVE
Databases
Introduction
Welcome to Deep Dives - Databases, where we will walk you through an introduction of what databases are and why you may want to consider an AWS database for your applications. We will provide descriptions, videos, and hands-on tutorials to get you started with AWS databases. For advanced users, we also have links to deeper technical content at the end of the page.
What are Databases?
Every application needs a place to store data from users, devices, or even the app itself. Databases are important back-end systems that are used to store data for any type of application, whether it’s a small mobile app or an enterprise app with internet-scale and real-time requirements.
What kind of applications are built using Databases?
Internet-scale applications: Build globally distributed and internet-scale applications that handle millions of requests per second over hundreds of terabytes of data. These databases automatically scale up and down to accommodate your spiky workload.
Real-time applications: Real-time applications such as caching, session stores, gaming leaderboards, ride-hailing, ad-targeting, and real-time analytics need microsecond latency and high throughput to support millions of requests per second.
Open source applications: Some customers prefer open source databases for their low cost, community-backed development and support, and large ecosystems of tools and extensions.
Enterprise applications: Enterprise applications are used to manage core business processes, such as sales, billing, customer service, human resources, and line-of-business processes, such as a reservation system at a hotel chain or a risk management system at an insurance company. These applications need databases that are fast, scalable, secure, available, and reliable.
Database Services
Relational Database
Relational databases store data with predefined schemas and relationships between them. These databases are designed to support ACID transactions, and maintain referential integrity and strong data consistency.
Amazon Aurora
MySQL and PostgreSQL-compatible relational database built for the cloud. Performance and availability of commercial-grade databases at 1/10th the cost
Amazon Relational Database Service (RDS)
Set up, operate, and scale a relational database in the cloud with just a few clicks
Amazon Redshift
The most popular and fastest cloud data warehouse
Key-value Database
Key-value databases are optimized for common access patterns, typically to store and retrieve large volumes of data. These databases deliver quick response times, even in extreme volumes of concurrent requests.
Amazon DynamoDB
Fast and flexible NoSQL database service for any scale
In-memory Database
In-memory databases are used for applications that require real-time access to data. By storing data directly in memory, these databases deliver microsecond latency to applications for whom millisecond latency is not enough.
Amazon ElastiCache for Memcached
Managed, Memcached-compatible, in-memory store. Sub-millisecond latency to power real-time applications
Amazon ElastiCache for Redis
Redis compatible in-memory data store built for the cloud. Power real-time applications with sub-millisecond latency
Document Database
A document database is designed to store semistructured data as JSON-like documents. These databases help developers build and update applications quickly.
Amazon DocumentDB
Fast, scalable, highly available MongoDB-compatible database service
Wide Column Database
A wide column store is a type of NoSQL database. It uses tables, rows, and columns, but unlike a relational database, the names and format of the columns can vary from row to row in the same table.
Amazon Keyspaces (for Apache Cassandra)
Managed Cassandra-compatible database
Graph Database
Graph databases are for applications that need to navigate and query millions of relationships between highly connected graph datasets with millisecond latency at large scale.
Amazon Neptune
Fast, reliable graph database built for the cloud
Time Series Database
Time-series databases efficiently collect, synthesize, and derive insights from data that changes over time and with queries spanning time intervals.
Amazon Timestream
Fast, scalable, fully managed time series database
Ledger Database
Ledger databases provide a centralized and trusted authority to maintain a scalable, immutable, and cryptographically verifiable record of transactions for every application.
Amazon Quantum Ledger Database (QLDB)
Fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log. Owned by a central trusted authorit
Fundamentals
AWS provides the broadest selection of purpose-built databases for all your application needs. Hundreds of thousands of customers rely on AWS databases that are purpose-built, offer performance at scale, fully managed, and are enterprise-class in terms of capability and reliability.
-
Purpose-Built
Choose from 15 purpose-built database engines including relational, key-value, document, in-memory, graph, time series, and ledger databases. AWS’s portfolio of purpose-built databases supports diverse data models and allows you to build use case-driven, highly scalable, distributed applications. By picking the best database to solve a specific problem or a group of problems, you can break away from restrictive one-size-fits-all monolithic databases and focus on building applications to meet the needs of your business.
AWS Databases: Innovate Faster with Purpose-Built databases -
Performance at Scale
AWS provides relational databases that are 3-5X faster than popular alternatives, or non-relational databases that give you microsecond to sub-millisecond latency. Start small and scale as your applications grow. You can scale your database's compute and storage resources easily, often with no downtime. Because purpose-built databases are optimized for the data model you need, your applications can scale and perform better at 1/10 the cost versus commercial databases.
AWS Databases: Improve Performance & Scale -
Fully Managed
With AWS databases, you don’t have to worry about database management tasks such as server provisioning, patching, setup, configuration, backups, or recovery. AWS continuously monitors your clusters to keep your workloads up and running with self-healing storage and automated scaling, so that you can focus on higher value application development.
AWS Databases: Break Free to Save, Grow, and Innovate Faster -
Enterprise-Class
AWS databases are built for business-critical, enterprise workloads, offering high availability, reliability, and security. These databases support multi-region, multi-master replication, and provide full oversight of your data with multiple levels of security, including network isolation using Amazon VPC, encryption-at-rest using keys you create and control through AWS Key Management Service (KMS), as well as encryption-in-transit.
AWS Databases: Save Time & Cost
Tutorials
The below tutorials will cover how to get started on popular database engines in 10 minutes.
Create an Aurora MySQL cluster with database nodes replicated across multiple AZs to gain increased read scalability and failover protection.
Learn how to create a simple table, and add, query, and delete data by using the DynamoDB console.
Learn how to create and configure a Redis Cluster with ElastiCache for Redis.
Key Topics
The below training courses will walk through three popular scenarios in-depth: “Move to managed databases”, “Break free from legacy databases,” and “Purpose-built databases.” Each training course will provide a hands-on lab experience that you can follow along using step-by-step guides.
-
Purpose-Built Databases
This training course will cover how to choose the right tool for the right job by learning about the various use cases and purpose-built databases from AWS. The goals of this training course are:
- Introduce and explain the concept of purpose-built databases
- Include examples of when to use specific databases and basic getting started guides
Coming soon in May 2020 -
Break Free from Legacy Databases
This training course will cover how to modernize an old monolithic application into a serverless database such as Amazon Aurora or Amazon DynamoDB. The goals of this training course are:
- Introduce and explain why you may want to migrate from a legacy database to a modern, cloud-native database
- Explain how to choose between different migration targets
- Provide getting started guides and introductory material for migrating
Coming soon in May 2020 -
Move to Managed Databases
This training course will cover how to migrate an on-premises open source database such MySQL or PostGreSQL to a fully managed cloud database using Amazon RDS. The goals of this training course are:
- Introduce and explain the concept of a fully managed cloud database
- Include best practices of how to migrate to a cloud databases using the same engine
Coming soon in May 2020
Certification
The AWS Certified Database – Specialty exam validates an individual’s expertise in recommending, designing, and maintaining the optimal AWS database solution to improve performance, reduce costs, and enable innovation. This certification is the first to validate technical skill in AWS purpose-built databases.
AWS Database Offerings
This self-paced course provides a basic overview of different database technologies and architectures, and introduces you to the various AWS database services.
Digital | 5.5 hours
Exam Readiness: AWS Certified Database - Specialty
Explore the AWS Certified Database - Specialty exam’s topic areas to learn how they relate to databases on AWS and review foundational areas for future self-study.
Digital | 3.5 hours
AWS Certified Database - Specialty
This certification validates a comprehensive understanding of the breadth of AWS database services and how to accelerate the use of database technology to drive business transformation in your organization.
Exam | 180 minutes