Relational database technologies on Azure and AWS
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
| Architecture | Description |
|---|---|
| Gaming by using Azure Cosmos DB | Elastically scale your database to accommodate unpredictable bursts of traffic and deliver low-latency multi-player experiences on a global scale. |