Please enable JavaScript.
Coggle requires JavaScript to display documents.
Design Patterns of Data Bases - Coggle Diagram
Design Patterns of Data Bases
Graph, Trees and Hierarchies Overview
Trees
hierarchy
graph
Adjacency List Model
single-table representation
Data Manipulation
removal is difficult
selection is a problem
adding elements
single table works best
Nested Sets Model
SQL is a set-oriented language
left and right nested sets
Data Manipulation
adding are extremely costly
removing is a costly
selection is the purpose
Materialized Path
denormalized table
Data manipulation
removal doesn’t involve
selection is the strength
adding is more difficult