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 Next Episode ▶

Adam Marczak

Programmer, architect, trainer, blogger, evangelist are just a few of my titles. What I really am, is a passionate technology enthusiast. I take great pleasure in learning new technologies and finding ways in which this can aid people every day. My latest passion is running an Azure 4 Everyone YouTube channel, where I show that Azure really is for everyone!

Did you enjoy the article?

Share it!

More tagged posts