Edit

Relational database technologies on Azure and AWS

  • Article
  • 2 minutes to read

RDS and Azure relational database services

Azure provides several different relational database services that are the equivalent of AWS' Relational Database Service (RDS). These include:

Other database engines such as SQL Server, Oracle, and MySQL can be deployed using Azure VM Instances.

Costs for AWS RDS are determined by the amount of hardware resources that your instance uses, like CPU, RAM, storage, and network bandwidth. In the Azure database services, cost depends on your database size, concurrent connections, and throughput levels.

See also

Analytics and big data

Azure provides a package of products and services designed to capture, organize, analyze, and visualize large amounts of data consisting of the following services:

  • HDInsight: managed Apache distribution that includes Hadoop, Spark, Storm, or HBase.

  • Data Factory: provides data orchestration and data pipeline functionality.

  • Azure Synapse Analytics: an enterprise analytics service that accelerates time to insight, across data warehouses and big data systems.

  • Azure Databricks: a unified analytics platform for data analysts, data engineers, data scientists, and machine learning engineers.

  • Data Lake Store: analytics service that brings together enterprise data warehousing and big data analytics. Query data on your terms, using either serverless or dedicated resources—at scale.

  • Machine Learning: used to build and apply predictive analytics on data.

  • Stream Analytics: real-time data analysis.

  • Data Lake Analytics: large-scale analytics service optimized to work with Data Lake Store

  • Power BI: a business analytics service that provides the capabilities to create rich interactive data visualizations.

Service comparison

Type AWS Service Azure Service Description
Relational database RDS SQL Database

Database for MySQL

Database for PostgreSQL

Database for MariaDB		 Managed relational database services in which resiliency, scale and maintenance are primarily handled by the Azure platform.
Serverless relational database Amazon Aurora Serverless Azure SQL Database serverless

Serverless SQL pool in Azure Synapse Analytics		 Database offerings that automatically scales compute based on the workload demand. You're billed per second for the actual compute used (Azure SQL)/data that's processed by your queries (Azure Synapse Analytics Serverless).
NoSQL DynamoDB (Key-Value)

SimpleDB

Amazon DocumentDB (Document)

Amazon Neptune (Graph)		 Azure Cosmos DB Azure Cosmos DB is a globally distributed, multi-model database that natively supports multiple data models including key-value pairs, documents, graphs, and columnar.
Caching ElastiCache

Amazon MemoryDB for Redis		 Cache for Redis An in-memory–based, distributed caching service that provides a high-performance store that's typically used to offload nontransactional work from a database.
Database migration Database Migration Service Database Migration Service A service that executes the migration of database schema and data from one database format to a specific database technology in the cloud.

Database architectures

  • Gaming using Azure Cosmos DB
    • 12/16/2019
    • 1 min read

    Elastically scale your database to accommodate unpredictable bursts of traffic and deliver low-latency multi-player experiences on a global scale.

  • Oracle Database Migration to Azure
    • 12/16/2019
    • 2 min read

    Oracle DB migrations can be accomplished in multiple ways. This architecture covers one of these options wherein Oracle Active Data Guard is used to migrate the Database.

view all

See also