AWS Database Services

0

AWS provide a wide range of database solutions to its users.

Depending upon the nature of the data, security and the cost constraints of the customers various database types serve all users accordingly.

These Databases allow users to build use-case-specific data models, including relational, graph, wide-column, etc. AWS fully manages these databases, freeing users from some maintenance tasks such as server provisioning, patching, and backup, which are time-consuming.

Advantages:

• Fully Managed: AWS Database services are fully managed services that release many of the setup, management, and monitoring responsibilities from customers.
• Scalable: AWS provides a set of Databases that are highly scalable. This is true for both the relational and non-relational databases.
• Highly available: considering its global infrastructure setup and fault tolerance mechanism, AWS provides highly available and reliable services across the globe.
• Security: Provides secure services due to the implementation of multi-level security systems like network isolation and end-to-end encryption.

Database	Use cases	AWS services
Relational	Traditional applications, enterprise resource planning (ERP), customer relationship management (CRM), Ecommerce	Amazon Aurora — Designed for unparalleled high performance and availability at global scale with full MySQL and PostgreSQL compatibility
		Amazon RDS — Set up, operate, and scale a relational database in the cloud with just a few clicks
		Amazon Redshift — Accelerate your time to insights with fast, easy, and secure cloud data warehousing at scale
Key-value	High-traffic web applications, ecommerce systems, gaming applications	Amazon DynamoDB — Fast, flexible NoSQL database service for single-digit millisecond performance at any scale
In-memory	Caching, session management, gaming leaderboards, geospatial applications	Amazon ElastiCache — Unlock microsecond latency and scale with in-memory caching
		Amazon MemoryDB for Redis — Redis-compatible, durable, in-memory database service for ultra-fast performance
Document	Content management, catalogs, user profiles	Amazon DocumentDB (with MongoDB compatibility) — Scale JSON workloads with ease using a fully managed document database service
Wide column	High-scale industrial apps for equipment maintenance, fleet management, route optimization	Amazon Keyspaces — A scalable, highly available, and managed Apache Cassandra–compatible database service
Graph	Fraud detection, social networking, recommendation engines	Amazon Neptune — Build and run graph applications with highly connected datasets
Time series	Internet of Things (IoT) applications, DevOps, industrial telemetry	Amazon Timestream — Fast, scalable, serverless time series database
Ledger	Systems of record, supply chain, registrations, banking transactions	Amazon Ledger Database Service (QLDB) — Maintain an immutable, cryptographically verifiable log of data changes

Databases	Features
Amazon Aurora	MySQL and PostgreSQL compatible
	five times faster than standard MySQL
	three times faster than standard PostgreSQL
	security, availability, and reliability of commercial databases at 1/10th the cost.
	fully managed by Amazon Relational Database Service (Amazon RDS)
	distributed, fault-tolerant, self-healing storage system that auto-scales up to 128TB per database instance
	15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs)
Amazon DynamoDB	key-value and document database
	single-digit millisecond performance at any scale
	fully managed, multiregion, multimaster database with built-in security, backup and restore, and in-memory caching for internet-scale applications
	key-value and document database for mobile, web, gaming, ad tech, Internet of Things (IoT), and other applications that need low-latency data access at any scale
	10 trillion requests per day and support peaks of more than 20 million requests per second
Amazon ElastiCache	web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud
	service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches
	Redis
	fast, open-source, in-memory key-value data store for use as a database, cache, message broker, and queue
	along with the availability, reliability, and performance
	Both single-node and up to 15-shard clusters are available, enabling scalability to up to 3.55 TiB of in-memory data
	Memcached
	widely adopted memory object caching system
Amazon Keyspaces (for Apache Cassandra)	scalable, highly available, and managed Apache Cassandra–compatible database
	don’t have to provision, patch, or manage servers, and you don’t have to install, maintain, or operate software
	Keyspaces is serverless
	Data is encrypted by default
	back up your table data continuously using point-in-time recovery
	performance, elasticity, and enterprise features
Amazon MemoryDB for Redis	Redis-compatible, durable, in-memory database service that delivers ultra-fast performance
	all of your data is stored in memory, which enables you to achieve microsecond read and single-digit millisecond write latency and high throughput
	stores data durably across multiple Availability Zones using a distributed transactional log to allow fast failover, database recovery, and node restarts
	high-performance primary database for your microservices applications
	eliminating the need to separately manage both a cache and durable database
Amazon Neptune	fast, reliable, fully managed graph database
	easy to build and run applications that work with highly connected datasets
	purpose-built, high-performance graph database engine optimized for storing billions of relationships and querying the graph with milliseconds latency
	powers graph use cases such as recommendation engines, fraud detection, knowledge graphs, drug discovery, and network security
	highly available, with read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across Availability Zones
	support for encryption at rest
Amazon RDS	several database instances types – optimized for memory, performance or I/O
	provides you with six familiar database engines to choose
	Amazon Aurora
	PostgreSQL
	MySQL
	MariaDB
	Oracle Database
	SQL Server
	AWS Database Migration Service
	to easily migrate or replicate your existing databases to Amazon RDS
Amazon RDS on VMware	deploy managed databases in on-premises
	allows you to utilize the same simple interface for managing databases in on-premises VMware environments as you would use in AWS
	enabling low-cost hybrid deployments for disaster recovery, read replica bursting, and optional long-term backup retention in Amazon Simple Storage Service (Amazon S3)
Amazon Quantum Ledger Database (Amazon QLDB)	transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority
	QLDB tracks each and every application data change and maintains a complete and verifiable history of changes over time
	record a history of economic and financial activity in an organization
	database that eliminates the need to engage in the complex development effort of building your own ledger-like applications
	data’s change history is immutable – it cannot be altered or deleted – and using cryptography, you can easily verify that there have been no unintended modifications
Amazon Timestream	fast, scalable, fully managed time series database service for IoT and operational applications
	makes it easy to store and analyze trillions of events per day at 1/10th the cost of relational databases
	Time-series data has specific characteristics such as typically arriving in time order form, data is append-only, and queries are always over a time interval
	automates rollups, retention, tiering, and compression of data, so you can manage your data at the lowest possible cost
	Timestream is serverless
Amazon DocumentDB (with MongoDB compatibility)	fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads
	allowing you to use your existing MongoDB drivers and tools with Amazon DocumentDB
	performance, scalability, and availability you need when operating mission-critical MongoDB workloads at scale
Amazon Lightsail managed databases	separate from compute workloads, so you can build applications and websites on Lightsail instances without interruption
	supports MySQL and PostgreSQL databases, and you can configure them for standard availability for regular workloads or high availability for critical workloads
	Lightsail-managed databases bundle the underlying compute, SSD-based storage, and data transfer bandwidth into a fixed monthly price

With this, I have attempted to brief about various AWS Database services.

Wish now you have a basic insight of it and would help utilize this knowledge in your career path.