Non-relational Database

  • Data is stored in collections or containers
  • Don’t follow a predefined schema
  • Different types available:
    • Document database
    • Wide-column store
    • Key-value store
    • Graph database
  • Query language differs between systems

Non-Relational Stores

Relational Non-Relational
Strict Schema Schema-agnostic
Transaction Management System IoT Apps, Real-Time Analytics
Scales Vertically Scales Horizontally
Rows, Tables, and Relationships Key-value, Object, Graph, Document
SQL Server, MariaDB, MySQL, PostgreSQL Table Storage, Blob Storage, File Storage, Cosmos DB

References