Data on Azure


 

Simply put the choice of database is now huge! Data on Azure is also a huge area with lots of technologies both Microsoft and Open Source being available


Architecture of Data services on Azure

image

Different databases are designed to solve different problems. Using a single database engine for all of the requirements usually leads to non-optimal solutions

“Increasingly we see applications manage their own data using different technologies depending on how the data is used…. this will come at a cost in complexity. Each data storage mechanism introduces a new interface to be learned…”

Here are some typical example of types of way of storing data

 

image

Azure Storage is the cloud storage solution for modern applications that rely on durability, high availability, and scalability. It is highly scalable, elastic, globally accessible, and automatically load-balances your data

Some of the key benefits of Azure Storage

•Massively scalable, highly available data store for hundreds of terabytes of data

•Used by Skype, Office 365, XBox, OneDrive

•Stores more than 120 Trillion objects

•Multiple redundancy options to never loose data

•Encryption at rest, Key Vault integration

 

Typical Architecture of Azure storage

 

image

So what are the key components

 

image

•Blob Storage stores unstructured object data and can be any type of text or binary data, such as a document, media file, etc.

•60 MB/sec or 500 requests/sec target throughput

•Hot storage tier optimized for accessed frequently, cool storage infrequently accessed and long-lived

image

•Table Storage stores structured datasets. Table storage is a NoSQL key-attribute data store, which allows for rapid development and fast access to large quantities of data

•1 MB max size of entity with a max 255 properties

•Single RowKey with additional ParitionKey, 1 KB max size

image

•Queue Storage provides reliable messaging for workflow processing and for communication between components of cloud services

•2000 messages/sec target throughput

image

•File Storage offers shared storage for traditional applications using SMB protocol. Azure virtual machines can share file data via mounted shares

•5 TB max size of file share, 1 TB max size of a file in a share

•60 MB/sec target throughput

Resources

https://docs.microsoft.com/en-gb/azure/storage/storage-table-design-guide

https://docs.microsoft.com/en-gb/azure/storage/storage-table-design-guide

https://docs.microsoft.com/en-gb/azure/storage/storage-scalability-targets

 

Comments (0)

Skip to main content