02.Various Data Models

No-SQL vs NewSQL Pasted image 20250905172718.png Pasted image 20250905172909.png Pasted image 20250905173013.png In more detail:

Single table model

CSV
Excel

Document model

Json
XML

Relational Data -> SQL

SQL is the defintion and query language, while RD is the concept of structuring the data in Entities and Relationships.

Non-relational Data

Specialised for specific query types and data

Arrays for genome databases
Unbounded for handling data streams and huge amounts of data
Graphs for handling knowledge networks and reasoning