Optimize Performance with Azure OLTP Solutions
Data management is at the heart of every application. Whether those applications need real-time updates for business-critical functions or asynchronous updates for longer-running processes, Azure offers a wide variety of services that are up to the task. Azure provides many different options for storing structured and non-structured data, such as Azure Blob Storage, Table Storage, Cosmos DB, Azure SQL Database, and Azure Data Lake. While some of these options are meant for big data storage, analytics, and presentation, there are others that are meant for applications that process transactions.
This chapter will focus on various aspects of using transactional data stores, such as Azure SQL Database and other open source databases that are typically used in online transaction processing (OLTP) systems, and will cover the following topics:
- OLTP:
- Properties/traits
- When this solution should be used
- OLTP in Azure:
- Azure SQL
- Azure...