⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠ You can decompress Drawing data with the command palette: ‘Decompress current Excalidraw file’. For more info check in plugin settings under ‘Saving’
Excalidraw Data
Text Elements
One order — five shapes
Anna (Krems) orders 1 × Keyboard and 2 × Mouse
Relational
customer id | name | city 1 | Anna | Krems
orders id | customer_id 1001 | 1
order_item order_id | product_id | qty 1001 | 1 (Keyboard) | 1 1001 | 2 (Mouse) | 2
split into tables, joined by keys
Document
{ “_id”: 1001, “customer”: { “name”: “Anna”, “city”: “Krems” }, “items”: [ {“product”: “Keyboard”, “qty”: 1}, {“product”: “Mouse”, “qty”: 2} ] }
one aggregate = one document
Key-value
order:1001
▒▒▒▒ blob ▒▒▒▒
store only knows the key — the app must decode the value
Graph
Anna
#1001
Keyboard
Mouse
PLACED
qty: 1
qty: 2
relationships are stored, not computed
Wide-column
anna
1001:Keyboard qty=1
1001:Mouse qty=2
partition key = customer → all her orders live together on one node