AWS Certified Solution Architect — Associate: Databases

There are 7 database services

  1. Amazon Aurora
  2. RDS: Managed Relational Database Service
  3. DynamoDB : Managed NoSQL Database
  4. ElasticCache: In-Memory Cache
  5. Redshift: Fast, Simple, Cost-effective Data Warehouse
  6. DMS: Managed Database Migration Service
  7. Amazon Neptune

What is Relational Database?

It is like a spreadsheet/table that comes with Rows and Columns.

Relational Database Types in RDS

SQL Server, Oracle, MySQL Server, PostgreSQL, Aurora, MariaDB

Non Relational Database?

It is a database consists of Collection, Document, or Key Value Pairs.

Those three concepts are identical to Table, Row, and Fields in RDB.

What is Data Warehousing?

It is used for business intelligence tools like Cognos, Jaspersoft, SQL Server Reporting services, Oracle Hyperion, SAP Netweaver. It’s used to pull in very large and complex datasets.

Two Type of Data Warehousing

OLTP: Online Transaction Processing

OLAP: Online Analytics Processing

Amazon Aurora

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL and up to three times better performance than PostgreSQL with the security, availability, and reliability of a commercial database at one-tenth the cost. New for Aurora, is Aurora serverless, that simplifies administration, reduces costs, and delivers capacity on demand by automatically scaling up or scaling down without manual provisioning. Aurora also features multi-master to scale out both reads and writes by creating multiple read and write master nodes across availability zones for better performance and zero downtime. Both of these features are available in preview.

Amazon RDS

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business. Amazon RDS provides you six familiar database engines to choose from, including Amazon Aurora, Oracle, Microsoft SQL Server, PostgreSQL, MySQL and MariaDB.

Amazon DynamoDB

Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed cloud database and supports both document and key-value store models. Its flexible data model and reliable performance make it a great fit for mobile, web, gaming, ad tech, IoT, and many other applications. New for DynamoDB is global tables, which fully automate the replication of tables across AWS regions for a fully managed, multi-master, multi-region database. DynamoDB also adds support for on-demand and continuous backups for native data protection.

Amazon Redshift

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools. You can start small for $0.25 per hour with no commitments and scale to petabytes for $1,000 per terabyte per year, less than a tenth the cost of traditional solutions.

Amazon ElastiCache

Amazon ElastiCache makes it easy to deploy, operate, and scale an in-memory data store or cache in the cloud. The service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based databases. ElastiCache for Redis offers fully managed Redis and ElastiCache for Memcached offers fully managed Memcached in the cloud.

For more information visit the Amazon ElastiCache product page.

Amazon Neptune

Amazon 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. Amazon Neptune supports popular graph models Apache TinkerPop and W3C’s RDF, and their associated query languages TinkerPop Gremlin and RDF SPARQL, allowing you to easily build queries that efficiently navigate highly connected datasets. Neptune powers graph use cases such as recommendation engines, fraud detection, knowledge graphs, drug discovery, and network security.

For more information visit the Amazon Neptune product page.

AWS DMS

AWS Database Migration Services (DMS) helps you migrate databases to AWS easily and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to RDS for Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to RDS for MySQL.

For more information visit the AWS DMS product page.

Suggestion depending on need
Suggestion depending on application type

I love my life, my wife, my daughter. I am a passionate life engineer.