mysql - How to get child nodes without grandchildren and great-grandchildren? Closure Table pattern - Stack Overflow
Storing Hierarchical Data in SQL Server (Available Options) – SQLpowered.com
Storing Hierarchical Data in SQL Server (Available Options) – SQLpowered.com
SQL Hierarchies - SQL Smells - Duhallow Grey Geek
GitHub - WillSoss/closure-tree: A closure table implementation in C#/MSSQL.
postgresql - What combination of select query and SQL triggers will return each node's ancestry and depth, with triggers maintaining the closure table? - Stack Overflow
SQL Server Closure Tables - Simple Talk
Extending SQL with Generalized Transitive Closure Functionality | Semantic Scholar
Models for #Hierarchical Data in #SQL and PHP - Bill Karwin - #MySQL Tutorial - YouTube
GitHub - developerworks/hierarchy-data-closure-table: This is a mysql and postgresql store procedure and trigger implementation of closure table in RDBMS about hierarchy data model.
Moving Subtrees in Closure Table Hierarchies
基于Closure Table实现分类目录树存储| Kyle's Blog
database - Closure table equivalent for graph structures in SQL - Stack Overflow
Closure Table Pattern to Model Hierarchies in NoSQL | by Andriy Zabavskyy | Towards Data Science