Relational Database ModelDatabase Model
Database models are different approaches to structuring and managing data in DatabaseDatabase
Databases are computer systems designed for storing data.
This note serves as a link to connect database-related notes.
[[ACID]]
[[Optimistic Locking]]/[[Pessimistic Locking]]
[[Database I...s.
It’s not possible to say in general which data model leads to simpler application code; it depends on th... is an approach to structuring and managing data in DatabaseDatabase
Databases are computer systems designed for storing data.
This note serves as a link to connect database-related notes.
[[ACID]]
[[Optimistic Locking]]/[[Pessimistic Locking]]
[[Database I...s.
Data is stored in tables (also called relations) with predefined schemas (columns with specific data types). Foreign keys define relationships between the tables.
| The stored data is Data Normalization | normalized to avoid redundancy and ensure consistency when updating data. |
Biggest advantage of relational model compared to Document Database ModelDocument Database Model
Document [[Database Model]] is an approach to structuring and managing data in [[Database]]s.
Data is stored as documents (usually JSON or BSON) inside collections. Documents can be self-contained... is that it provides better support for joins, and many-to-one / many-to-many relationships.
Status: #📥
References: