AWS Database Definitions Flashcards
Become very familiar with AWS database terms
Amazon RDS (Relational Database Service)
_____________ is a fully managed relational database service offered by AWS. It supports several popular database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. With _____________, users can easily deploy, operate, and scale relational databases in the cloud without worrying about infrastructure management tasks such as hardware provisioning, software installation, patching, backups, and monitoring.
Amazon DynamoDB
_____________ is a fully managed NoSQL database service provided by AWS. It offers seamless scalability and low-latency performance for applications requiring fast and predictable data access. _____________ is designed to handle large-scale, high-traffic workloads with automatic scaling, built-in fault tolerance, and single-digit millisecond response times. It supports both document and key-value data models and provides features like encryption at rest, in-transit, and fine-grained access control.
Amazon Redshift
_____________ is a fully managed data warehousing service offered by AWS. It is designed for analyzing large datasets using SQL queries and business intelligence tools. _____________ is built for high-performance, scalable data analytics with petabyte-scale data storage, columnar storage, parallel processing, and automatic optimization features. It allows users to run complex analytical queries across structured and semi-structured data stored in Amazon S3, Amazon DynamoDB, and other data sources.
Amazon DocumentDB (with MongoDB compatibility)
_____________ is a fully managed document database service compatible with MongoDB. It offers a scalable, highly available, and performant solution for storing, querying, and indexing JSON-like documents. _____________ is designed to provide the flexibility and ease of use of MongoDB along with the reliability, scalability, and security of AWS infrastructure. It supports features like ACID transactions, encryption at rest, and point-in-time recovery.
Amazon Neptune
_____________ is a fully managed graph database service provided by AWS. It is optimized for storing and querying highly connected data with complex relationships, such as social networks, recommendation engines, and fraud detection systems. _____________ supports both property graph and RDF graph models and provides features like multi-tenancy, high availability, and encryption at rest. It is compatible with popular graph query languages like Gremlin and SPARQL.
Amazon ElastiCache
_____________ is a fully managed in-memory caching service provided by AWS. It supports popular open-source in-memory data stores like Redis and Memcached, offering high-performance, low-latency data access for applications requiring fast read and write operations. _____________ helps improve application performance and scalability by offloading database and application servers, reducing database load, and improving response times.
Amazon Keyspaces (for Apache Cassandra)
_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ supports automatic scaling, built-in encryption, and point-in-time recovery, making it suitable for applications requiring high throughput, low latency, and continuous availability.
Amazon Timestream
_____________ is a fully managed time-series database service provided by AWS. It is designed for storing and analyzing time-series data at scale, such as IoT telemetry, application logs, and operational metrics. _____________ offers features like automatic data retention, tiered storage, and built-in analytics functions for analyzing time-series data efficiently. It supports SQL-like queries and integrates seamlessly with other AWS services for data ingestion and visualization.
Amazon Quantum Ledger Database (QLDB)
_____________ is a fully managed ledger database service provided by AWS. It provides a transparent, immutable, and cryptographically verifiable transaction log for tracking changes to application data over time. _____________ is designed to provide a centralized, trusted source of truth for applications requiring an auditable record of all transactions. It supports SQL-like querying and integrates with AWS services like AWS Key Management Service (KMS) for data encryption.
Amazon Managed Apache Cassandra Service
_____________ is a fully managed Apache Cassandra-compatible database service provided by AWS. It offers the scalability, availability, and performance of Apache Cassandra with the ease of use and reliability of AWS infrastructure. _____________ handles routine tasks like hardware provisioning, software installation, patching, backups, and monitoring, allowing developers to focus on building applications.
Amazon Aurora Serverless
_____________ is an on-demand, auto-scaling version of Amazon Aurora, a high-performance relational database service provided by AWS. _____________ automatically scales compute capacity up or down based on actual application usage, allowing users to pay only for the resources consumed. It is well-suited for unpredictable or intermittent workloads, reducing costs and management overhead.
Amazon Aurora Multi-Master
_____________ is a feature of Amazon Aurora that allows users to create multiple read/write master instances in a cluster, enabling high availability and scalability for write-intensive workloads. _____________ provides synchronous replication and automatic failover capabilities, ensuring continuous availability and data consistency across multiple database instances.
Amazon Aurora Global Database
_____________ is a feature of Amazon Aurora that enables global replication and deployment of Aurora database clusters across multiple AWS regions. It allows users to create read replicas in different regions for low-latency access to data and disaster recovery purposes. _____________ provides fast, synchronous replication and automatic failover, ensuring data consistency and high availability across regions.
Amazon Aurora Parallel Query
_____________ is a feature of Amazon Aurora that accelerates analytical queries by pushing processing down to the Aurora storage layer. It enables faster query performance and better utilization of resources by parallelizing query execution across multiple storage nodes. _____________ is particularly beneficial for analytics and reporting workloads with large datasets, reducing query response times and improving overall system efficiency.
Apache Cassandra
_____________ is an open-source, distributed NoSQL database management system designed to handle large volumes of structured data across multiple commodity servers, providing high availability, fault tolerance, and linear scalability.
_____________ is a fully managed relational database service offered by AWS. It supports several popular database engines, including MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. With _____________, users can easily deploy, operate, and scale relational databases in the cloud without worrying about infrastructure management tasks such as hardware provisioning, software installation, patching, backups, and monitoring.
Amazon RDS (Relational Database Service)