Blog Post

Educator Developer Blog
2 MIN READ

Data on Azure

Lee_Stott's avatar
Lee_Stott
Icon for Microsoft rankMicrosoft
Mar 21, 2019
First published on MSDN on Feb 24, 2017

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

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

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

So what are the key components

•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

•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

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

•2000 messages/sec target throughput

•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

Updated Mar 21, 2019
Version 2.0
No CommentsBe the first to comment