Closure Table — 2 Technical Articles

Apr 18, 2026 · Backend Development

Efficient Hierarchical Menu Storage in MySQL: Adjacency List vs Closure Table

The article examines common pitfalls of using a simple parent_id column for menu hierarchies, compares three storage models—adjacency list, path enumeration, and closure table—shows their trade‑offs, and provides a SpringBoot/MyBatis‑Plus implementation that combines adjacency and closure tables for optimal read‑write performance.

Adjacency ListClosure TableMyBatis-Plus

0 likes · 14 min read

Efficient Hierarchical Menu Storage in MySQL: Adjacency List vs Closure Table

ITPUB

Jun 12, 2017 · Databases

Choosing the Right Hierarchical Data Model: Adjacency List, Path Enumeration, Nested Set, or Closure Table

This article compares four common database designs for hierarchical data—adjacency list, path enumeration, nested set, and closure table—explaining their structures, query patterns, advantages, drawbacks, and how to decide which model best fits specific application requirements.

Adjacency ListClosure Tablehierarchical data

0 likes · 11 min read

Choosing the Right Hierarchical Data Model: Adjacency List, Path Enumeration, Nested Set, or Closure Table