Summary
In this chapter, we have discussed what OLTP systems are, including what constitutes transactional data along with some properties and traits that all OLTP systems share. We’ve explored several different Azure offerings that support OLTP applications, including Azure SQL Database, Azure SQL Managed Instance, Azure Database for PostgreSQL, Azure Cosmos DB, and Azure Database for MySQL. We have inspected the different deployment types for Azure SQL Database, such as single instance, managed instance, and elastic pools. We walked through the different features of Cosmos DB, which is a globally available data store for non-structured data that is OLTP compatible. We’ve looked at the different hardware tiers available to all database services in Azure, including General Purpose, Hyperscale, and Business Critical.
Architects should perform a complete assessment of their requirements and choose the appropriate deployment model. After choosing a deployment model, they...