Databases architecture design

Database for MariaDB
Database Migration service
Database for MySQL
Database for PostgreSQL

This article provides an overview of the Azure database solutions described in Azure Architecture Center.

Diagram that contrasts relational database management system and big data solutions.

Azure Database solutions include both traditional relational database management system (RDBMS) and big data solutions.

RDBMS workloads include online transaction processing (OLTP) and online analytical processing (OLAP). Data from multiple sources in the organization can be consolidated into a data warehouse. You can use an extract, transform, and load (ETL) process to move and transform the source data.

A big data architecture is designed to handle the ingestion, processing, and analysis of large or complex data. Big data solutions typically involve a large amount of non-relational data, which traditional RDBMS systems aren't well suited to store. This type of database is referred to as NoSQL (not only SQL).

This article provides resources to learn about Azure databases. It outlines paths to implement the architectures that meet your needs, and best practices to keep in mind as you design your solutions.

There are many architectures for you to draw from to address your database needs. We also provide solution ideas for you to build on, which include links to all the components you need.

Learn about databases on Azure

If you're new to databases on Azure, the best place to start is Microsoft Learn. On this free online training platform, you'll find videos and tutorials that offer hands-on learning. Microsoft Learn offers learning paths that are based on your job role, such as developer or data analyst.

You can browse Azure data modules or use this learning path to understand Azure SQL fundamentals.

Here are some Learn modules you might find useful:

Path to production

To find options helpful for dealing with relational data, consider these resources:

A non-relational database doesn't use the tabular schema of rows and columns. For more information, see Non-relational data and NoSQL.

To learn about data lakes, which hold a large amount of data in its native, raw format, see Data lakes.

A big data architecture can handle ingestion, processing, and analysis of data that is too large or too complex for traditional database systems.

A hybrid cloud is an IT environment that combines public cloud and on-premises datacenters. For more information, see Extend on-premises data solutions to the cloud.

Azure Cosmos DB is a fully managed NoSQL database service for modern app development. For more information, see Azure Cosmos DB resource model.

To learn about the options for transferring data to and from Azure, see Transfer data to and from Azure.

Best practices

Review these best practices when designing your solutions.

Best practices Description
Data management patterns Data management is the key element of cloud applications. It influences most quality attributes.
Transactional Outbox pattern with Azure Cosmos DB Learn how to use the Transactional Outbox pattern for reliable messaging and guaranteed delivery of events.
Distribute your data globally with Azure Cosmos DB To achieve low latency and high availability, some applications need to be deployed in datacenters that are close to their users.
Use the best data store for the job Pick the storage technology that is the best fit for your data and how it will be used.
Security in Azure Cosmos DB Security best practices help prevent, detect, and respond to database breaches.
Secure data solutions Address concerns around increased accessibility to data in the cloud and how to secure it.
Continuous backup with point-in-time restore in Azure Cosmos DB Learn about Azure Cosmos DB's point-in-time restore feature.
Achieve high availability with Cosmos DB Cosmos DB provides multiple features and configuration options to achieve high availability.
High availability for Azure SQL Database and SQL Managed Instance The database shouldn't be a single point of failure in your architecture.

Azure SQL Database security baselines

Security is a vital part of any database solution.

Technology choices

There are many options for technologies to use with Azure Databases. These articles help you choose the best technologies for your needs.

Stay current with databases

Refer to Azure updates to keep current with Azure Databases technology.

These architectures use database technologies.

Here are some other resources:

Example solutions

These solution ideas are some of the example approaches that you can adapt to your needs.

Similar database products

If you're familiar with Amazon Web Services (AWS) or Google Cloud, refer to the following comparisons:

Next steps

Refer to the Azure Data Architecture Guide for more details.