The best database in Azure to manage real time data operations.

Question

Hello Experts,

I have to manage some real time stock updates between more than 2 online portals and we are thinking to go with Azure Services. And also think to store data in Azure Database services. Hence, we are looking for the database that must be very speedy in Read and Write operations so that we will give a real time synchronization between portals.

Answer 1

Hi Ancy,

If you need a relational model Azure SQL Database is a fully managed relational database service with built-in intelligence.

But I think the best case would be Cosmos DB with "Strong" consistency. Azure Cosmos DB is a globally distributed, multi-model database service designed for high availability and low latency. It offers guaranteed single-digit millisecond response times for both read and write operations at scale. Cosmos DB supports multiple data models, including document, key-value, graph, and columnar. It also provides automatic indexing and the ability to replicate data across Azure regions, making it suitable for real-time synchronization across portals.

Answer 2

You can use CosmosDB. The scenario you are describing is very much of real-time time series scenario same as occur on IoT created data. Here you will find how to build a real-time processing architecture in Azure.

Answer 3

Hi Ancy Thank you for reaching out.

My understanding is that you are looking for the best database for your scenario described above. A database that will provide real time data operations and speed read and write operations.

Azure offers several types of databases to meet different application needs. To list few of them

1. Azure SQL Database
2. Azure Cosmos DB
3. Azure Database for MySQL
4. Azure Database for PostgreSQL
5. Azure Synapse Analytics
6. Azure Cache for Redis
7. Azure Table Storage

Adding on top of Vahid Ghafarpour and @Alberto Morillo

Choose Azure Cosmos DB if:

You are looking to manage real-time operations in Azure. Azure Cosmos DB is a globally distributed, multi-model database service designed for low-latency, high-throughput applications that require real-time data access.

In addition, Azure Cosmos DB is well-suited for IoT (Internet of Things) applications that generate a massive volume of data in real-time. It can handle the ingestion and processing of sensor data, telemetry data, and event streams with low latency.

Choose SQL Server in Azure VMs if:

You are looking to "lift and shift" your database and applications with minimal to no changes.
You prefer having full control over your database server and the VM it runs on.
You already have SQL Server and Windows Server licenses that you intend to use.

Choose Azure SQL Database if:

You are looking to modernize your applications and are migrating to use other PaaS services in Azure.
You do not wish to manage your database server and the VM it runs on.
You do not have SQL Server or Windows Server licenses, or you intend to let licenses you have expired.

Pricing:

It's important to evaluate your specific workload requirements, performance needs, and data storage needs when considering pricing. Azure offers a pricing calculator that can help estimate the costs for different database services based on your requirements. Additionally, regularly monitoring and optimizing your database usage can help control costs and ensure you are only paying for the resources you need. Azure cost Management.

I recommend applying for the AMMP program, which will help you get a free guidance and analysis. Azure.com/ammp

Please do let us know if you want to learn more about the above databases. I can provide you with more details.

Please do not forget to mark as accept answer wherever information provided were helpful.

Regards,

Oury