data structure with hierarchy data in SQL - 2020/09/25 tags: tech workshop 主要有四種 Adjacency list Path enumeration / Materialized Path Nested sets Subsets / Closure table 參考 卡米: https://hackmd.io/_qXRfwYbR9ugADy0239ttw?both https://columns.chicken-house.net/2019/06/01/nested-query/#%E5%B0%8F%E7%B5%90-%E4%B8%89%E7%A8%AE%E6%96%B9%E6%A1%88%E6%AF%94%E8%BC%83 https://www.slideshare.net/billkarwin/models-for-hierarchical-data