You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting.
Which storage solution should you use?
You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting.
Which storage solution should you use?
Azure SQL Database Hyperscale is designed to support very large databases, scaling up to 100 TB of data, which aligns with the requirement of storing 50 TB. It also supports high throughput and performance, making it well-suited for singleton inserts and updates, which are typical in transactional workloads. The Hyperscale service tier is built using a flexible architecture that separates compute and storage, allowing for rapid scaling and improved performance without impacting the application layer.
correct answer
But isn't Datawarehouse (Synapse Analytics) a right choice considering that we have table geometries (hash distribution) to efficiently perform inserts updates and deletes?
Keyword here is 100TB based on the support link.
No DWH is not a place for singleton updates
azure synapse is better for OLAP purposes while for OLTP, use of Azure SQL is the best choice. as the requirement states it requires to perform insert and update.
can anyone tell what 'singleton inserts, singleton updates' mean? I've been looking on the internet but no solid definition
Go through the ACID concept
Would take that to mean single row inserts, or updates
Singlenton operations = transactional operations, so only relational databases supports it. Hyperscale supports up to 100TB.
synapse support singleton operations...