Azure offers several data stores which can be used with the Particular Service Platform.
Azure Cosmos DB is a globally distributed, multi-model, managed database service. It offers high availability, low latency, and automatic scaling to handle massive workloads across various data models, including document, key-value, graph, and column-family. Cosmos DB relies on partitioning to achieve high performance and scalability. When working with Cosmos DB, it is important to be familiar with the partitioning model.
- Built and optimized for scalability
- Multi-region support for high availability deployment
- Supports multiple data models
- Fully managed
- Cosmos DB Emulator can be used for local development and testing
- Atomic transactions only within the same partition
- Careful partition planning is required
- Fairly expensive
Azure Table Storage is a NoSQL managed database service. It is a cost-effective and scalable solution for storing semi-structured and structured data, using a key-value pair schema. Designed for fast and efficient data retrieval, it is suitable for applications that require high-performance read and write operations, especially for large-scale, low-latency data storage and retrieval needs.
- Partitioning is managed by the service
- Azurite emulator can be used for local development and testing
- Limited number of columns and single entity (row) size
- Limited query capabilities
- Multi-document transactions are limited to the same partition
- No built-in support for complicated relationships
- Fully managed
- Rich built-in scaling options
- Automatic backups and point-in-time restores
- Active Geo-replication and zone-redundancy
- Different pricing tiers for more cost control
- Migrating existing SQL server instances might be challenging
Azure SQL Database is supported via the NServiceBus SQL persistence package.
Azure SQL Managed Instance is a fully managed database service that provides a near-complete compatibility with the Microsoft SQL Server database engine. It offers a managed solution for migrating and modernizing existing SQL Server applications with minimal code changes.
- High degree of compatibility with SQL Server
- Supports cross-database queries
- Predictable performance for large databases due to isolation
- More database configuration options compared to Azure SQL Database
- Higher costs compared to manually managed database servers or Azure SQL Database
Azure SQL Managed Instances is supported via the NServiceBus SQL persistence package.
While the presented storage options provide the best experience and integration with Azure, other storage options are available and may be valid options depending on the specific requirements. Explore all supported data stores.
The following factors should be considered when choosing a data store:
Using existing infrastructure and know-how can significantly speed up the development process and lower the risks associated with using unfamiliar data store technologies. Unless the existing infrastructure and technologies do not meet the architectural requirements, they are a good default choice.
When migrating or modernizing existing applications, data stores that are compatible with currently used protocols and languages simplify the switch to cloud-based services significantly. For example, a data store may understand PostgreSQL, SQL Server, and MongoDB dialects which allow applications using any of these dialects to connect with minimal changes required.
Transaction capabilities can vary considerably between different data stores. Some only provide transactional consistency within the same partition or have limited transaction isolation levels. It is important to consider whether eventual consistency is acceptable or ACID guarantees are required.
Data stores may have different storage models, optimized for different use cases. Data access patterns, the type of information to be stored, and relations between data should be considered when choosing the most appropriate storage model.
It may be important to consider how easily a data store's capacity and performance can be scaled up when required. Scaling requirements may also depend on the expected access patterns (e.g. the number of reads vs writes) or availability goals.
Sometimes, data may be subject to legal requirements (e.g. data privacy) that require additional consideration of how a data store operates to ensure compliance. See the Azure compliance offerings for more detailed information on specific national, regional, and industry-specific regulations.
Data stores can have significantly different pricing models. Charges may be based on a number of factors such as storage size, read/write operations, data transfer, or higher consistency guarantees. Some serverless pricing models may be optimized for when data is accessed infrequently or in bursts. The licensing model for a specific data store may also significantly impact the overall cost.
Some data stores are only available in the cloud, with no on-premises equivalent. This may affect hosting, CI, testing and development. Some data stores support open standards or protocols which allows the use of on-premises or local data stores in those scenarios. For example, Cosmos DB supports PostgreSQL and MongoDB dialects.
Data stores offer various approaches to securing data using authentication and authorization. This may be provided by the data store itself or the data store may integrate with third party security services such as Azure IAM.