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
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
/en-gb/azure/storage/storage-table-design-guide