Database Services

Data Types

• Structured - Data that can be represented using tables with very strict schema. Each row must follow defined schema. Some tables have defined relationships between them. Typically used in relational databases.
• Semi-structured - Data that can be represented using tables but without strict defined schema. Rows must only have unique key identifier.
• Unstructured - Any files in any format. Like binary files, application files, images, movies, etc.

Cosmos DB

• Globally distributed NoSQL (semi-structured data) Database service
• Schema-less
• Multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table Storage)
• Designed for
  • Highly responsive (real time) applications with super low latency responses <10ms
  • Multi-regional applications

SQL Database

• Relational database service in the cloud (PaaS) (DBaaS - Database as a Service)
• Structured data service defined using schema and relationships
• Rich Query Capabilities (SQL)
• High-performance, reliable, fully managed and secure database for building - applications

Azure SQL product family

• Azure SQL Database – Reliable relational database based on SQL Server
• Azure Database for MySQL – Azure SQL version for MySQL database engine
• Azure Database for PostgreSQL – Azure SQL version for PostgreSQL database engine
• Azure SQL Managed Instance – Fully fledged SQL Server managed by cloud provider
• Azure SQL on VM – Fully fledged SQL Server on IaaS
• Azure SQL DW (Synapse) – Massively Parallel Processing (MPP) version of SQL Server

◀ PREVIOUS EPISODE