DP 900 - Azure Data Stores

Azure Data Stores - 17 Cards

Click here to toggle all cards

Structured Data

Data in Tables - Predefined schema, indexes for OLTP and OLAP use cases.

Semi Structured Data

Flexible schema, stored in NoSQL DBs. Types - Document, Key Value, Graph, Column Family.

Unstructured Data

Data with no structure. Types - Block, File and Object storage.

Semi Structured - Document

Data stored as JSON docs, retrieved by unique id, no strict schema. Cosmos DB SQL API & MongoDB API

Semi Structured - Key Value

Supports simple lookups by keys, used for session store and caching data, Cosmos DB Table API & Table Storage

Semi Structured - Graph

Used to store data with complex relationships, contains nodes and edges. Cosmos DB Gremlin API

Relational OLTP databases

Transactional databases with predefined schema and strong transactional capabilities (Row storage)

Relational OLAP databases

Data warehousing databases for Big Data workloads with columnar storage and predefined schema

NoSQL Databases

Databases for apps with schema-less structures that need quickly evolving data (MongoDB, Cassandra, Gremlin)

In memory databases/caches

Databases for apps that require microsecond responses

Azure SQL Database

Managed Microsoft SQL Server

Azure Database for MySQL

Managed MySQL

Azure Database for PostgreSQL

Managed PostgreSQL

Azure Synapse Analytics

Petabyte-scale distributed data warehouse

Azure Cosmos DB

Fully managed NoSQL database service

Azure Cache for Redis

Fully managed in-memory database/caching service in Azure

Azure Cosmos DB APIs

MongoDB (document), Cassandra (key/value) and Gremlin (graph) etc