Vadim Tropashko 写过一本《SQL Design Patterns》，里面特别介绍了一些在 SQL 数据库中存储树和图的非平凡方法。我强烈推荐。免费 PDF 版本在这里：https://vadimtropashko.wordpress.com/%E2%80%9Csql-design-pat...
Vadim Tropashko wrote a book "SQL Design Patterns" that, among others, presents non-trivial approaches to storing trees and graphs in SQL databases. I highly recommend it. The PDF version is free here: https://vadimtropashko.wordpress.com/%E2%80%9Csql-design-pat...
I am not sure of performance. What I do know is that Vadim Tropashko's SQL Design Patterns has a few ideas on how to encode a materialized path see http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.102... . Also, bojanz and me have ideas here, see http://bojanz.wordpress.com/2014/04/25/storing-hierarchical-...…
Vadim Tropashko 写过一本《SQL Design Patterns》，里面特别介绍了一些在 SQL 数据库中存储树和图的非平凡方法。我强烈推荐。免费 PDF 版本在这里：https://vadimtropashko.wordpress.com/%E2%80%9Csql-design-pat...
Vadim Tropashko wrote a book "SQL Design Patterns" that, among others, presents non-trivial approaches to storing trees and graphs in SQL databases. I highly recommend it. The PDF version is free here: https://vadimtropashko.wordpress.com/%E2%80%9Csql-design-pat...
所有 Joe Celko 的书，还有 https://www.amazon.com/SQL-Design-Patterns-Programming-Focus...
All of the Joe Celko books and https://www.amazon.com/SQL-Design-Patterns-Programming-Focus...
我不确定性能怎么样。我只知道 Vadim Tropashko 的《SQL Design Patterns》里有几个关于如何对物化路径（materialized path）进行编码的想法，参见 http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.102...。另外，我和 bojanz 在这方面也有一些想法，见 http://bojanz.wordpress.com/2014/04/25/storing-hierarchical-...…
I am not sure of performance. What I do know is that Vadim Tropashko's SQL Design Patterns has a few ideas on how to encode a materialized path see http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.102... . Also, bojanz and me have ideas here, see http://bojanz.wordpress.com/2014/04/25/storing-hierarchical-...…