Skip to content
Menu
e-lo [IT Engineer life]
  • Home
    • Notes
    • Important notes
  • Database
    • T-SQL
    • SQL Server quick
    • SQL server docs
    • MySql quick sheet
    • Postgre
    • InfluxDB
  • Programming
    • MS Azure Powershell
    • MS Azure Command-Line Interface (CLI) doc
    • Python Docs
    • Python Logging
    • Python-cheat-sheet
    • Git-guide
  • Azure
    • MS Windows virtual machines in Azure
    • MS ARM Docs
    • MS ARM Template Docs
    • MS ARM Functions
    • MS Bicep+ARM
    • MS ARM Tutorial
    • MS Deployment scripts (intern/extern)
    • MS Virtual Network
  • Az-nutshell
    • ms-technology-choices-compute-decision-tree
    • ms-data-store-decision-tree
    • ms-data-explorer
    • ms-storage-explorer
    • ms-azure-sql
    • ms-common-data-services
    • ms-azure-mysql-daas
    • ms-sla
    • az paas
    • az glossary-quicksheet
    • az-test-vm-script-quickguide
  • Linux
    • Top CMD’s
    • Useful CMD Linux
    • ss64 Linux
    • Ubuntu
    • 30 things Ubuntu 18.04
    • Bootable Ubuntu USB
    • LinuxFilesystemTreeOverview
  • Sys Admin
    • System Administrator
    • Sys News
    • Packet Sniffers
  • Zen
    • Not thinking about anything is Zen
e-lo [IT Engineer life]

5 min data storage approach in Azure decision tree

Posted on December 2, 2021December 2, 2021 by espenk

Case:

https://docs.microsoft.com/en-us/learn/modules/choose-storage-approach-in-azure/

Data classification:
The key factors to consider in deciding on the optimal storage solution are: how to classify your data, how your data will be used, and how you can get the best performance for your application.

  • Structured (SQL, RDBMS)
  • Semi-structured (key/value, NOSQL, serialization language, XML,JSON, YAML)
  • Unstructured (media, word, text, log)

What are the main operations on the data, ACID-compliant?
OLTP (Online Transaction Processing)
OLAP (Online Analytical Processing)

Correct storage solution can lead to better performance, cost savings, and improved manageability, after data classification.

Data classification: Semi-structured
Azure Cosmos DB
Azure SQL Database

Data classification: Unstructured
Azure Blob storage

Data classification: Structured
Azure SQL Database

Storage service

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview?toc=/azure/storage/blobs/toc.json

Storage service:

Storage account contains all Azure storage data objects: blobs, file shares, queues, tables, and disks.

  • Blob storage, object storage solution, storing massive amounts of unstructured data, text or binary data.
  • Data Lake Storage Gen2, big data analytics, Azure Blob Storage
  • Azure Files. file shares, SMB
  • Queue storage, storing large numbers of messages, commonly used to create a backlog of work to process asynchronously
  • Table storage, non-relational structured data, NoSQL, key/attribute store with a schemaless design.

Data store decision tree – Azure Application Architecture Guide | Microsoft Docs

RSS Azure

  • MLOps Blog Series Part 3: Testing scalability of secure machine learning systems using MLOps June 30, 2022

RSS RabbitMQ

  • RabbitMQ 3.8.15 release

RSS Python

  • PEP 694: Upload 2.0 API for Python Package Repositories June 11, 2022

Tags

5 min (29) Ansible (1) ARM (10) azure (41) cmd (3) Django (4) Docker (1) e-lo (2) Flask (2) Github (9) Grafana (2) Information (7) Information Retrieval (13) JAVA (1) kivy (2) Kotlin (6) linux (15) mobile (2) Natural Language Prossesing (NLP) (2) Net.Core (1) Networking and Security (9) OPC (2) PEP8 (1) Philosophy (3) Python (48) Python Networking and Security (5) Reason (2) RMQ (3) Solr (11) Sql (10) Uncategorized (2) VSC (1) Warframe (2) WMVARE (4) Zabbix (7)

Recent Posts

  • 401 access denied win server (iis), Local Security Policy
  • Callback
  • Share-level permissions IAM Azure AD
  • Packet Sniffers
  • MSA Account

Archives

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Photo by Markus Spiske from Pexels "Matrix"

©2022 e-lo [IT Engineer life] | Powered by WordPress & Superb Themes