关于这个主题有一本好书：Joe Celko 写的《Joe Celko's Trees and Hierarchies in SQL for Smarties》。http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-... 他在这篇帖子里列出的每个模型都花了一整章来讲解：邻接表模型、路径枚举模型和嵌套集合模型。
A good book on the subject is Joe Celko's Trees and Hierarchies in SQL for Smarties. http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-... He spends a chapter on each of the models outlined in this post: adjacency, path, and nested set models.
想磨炼 SQL 技能的朋友，我觉得这两本书是非常棒的资源。1. Joe Celko 的《Joe Celko's Trees and Hierarchies in SQL for Smarties》 2. Joe Celko 的《Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL》
For those interested in sharpening their SQL skills I have found these two books to be a great resource. 1. Joe Celko's Trees and Hierarchies in SQL for Smarties 2. Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
……服务器组中所有接口的吞吐量 [0] --- 相关书籍：Joe Celko 有一个“SQL for Smarties”书系，结合示例查询覆盖了从基础到高级的 SQL 聚合。Joe Celko 的《Trees and Hierarchies in SQL for Smarties》讲到了与“SQL 语句返回了一个数据库”相关的一些想法？--- [0]: https://dba.stackexchange.com/questions/173044/nested-aggreg... [1] : http://unicon.org/ [2] : https://cs.uwaterloo.ca/~tozsu/courses/CS338/lectures/6%20Ne...
…through put on all interfaces on group of servers [0] --- topic related books: Joe Celko has book series 'SQL for Smarties' that covers basic through advanced aggrecation with sql using example queries. Joe Celko's 'Trees and Hierarchies in SQL for Smarties' covers some of the ideas related to 'SQL statment returned a database'? --- [0]: https://dba.stackexchange.com/questions/173044/nested-aggreg... [1] : http://unicon.org/ [2] : https://cs.uwaterloo.ca/~tozsu/courses/CS338/lectures/6%20Ne...
……特性，特别是如果你的 RDBMS 不支持 Recursive CTEs（递归通用表表达式）的话。其影响在远低于你想象的数据量级下就会显现；几百万行就足以开始拖慢速度了。这本书 [0]（Joe Celko 的《Trees and Hierarchies in SQL For Smarties》）给出了许多其他方案，不过它确实缺少 closure table（闭包表）方法 [1]，而这正是我最推崇的方案。说到这里，我们又回到了数据库与应用层之间长期以来的摩擦这个老问题上了。……
…characteristics, especially if your RDBMS doesn't have Recursive CTEs. This starts to matter at a much lower scale than you might think; several million rows is enough to start showing slowdowns. This book [0] (Joe Celko's Trees and Hierarchies in SQL For Smarties) shows many other options, though it does lack the closure table approach [1], which is my preferred approach. And here, we come full circle back to the long-held friction between DBs and applications.…
关于这个主题有一本好书：Joe Celko 写的《Joe Celko's Trees and Hierarchies in SQL for Smarties》。http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-... 他在这篇帖子里列出的每个模型都花了一整章来讲解：邻接表模型、路径枚举模型和嵌套集合模型。
A good book on the subject is Joe Celko's Trees and Hierarchies in SQL for Smarties. http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-... He spends a chapter on each of the models outlined in this post: adjacency, path, and nested set models.
想磨炼 SQL 技能的朋友，我觉得这两本书是非常棒的资源。1. Joe Celko 的《Joe Celko's Trees and Hierarchies in SQL for Smarties》 2. Joe Celko 的《Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL》
For those interested in sharpening their SQL skills I have found these two books to be a great resource. 1. Joe Celko's Trees and Hierarchies in SQL for Smarties 2. Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
Joe Celko 写的《Joe Celko's Trees and Hierarchies in SQL for Smarties》（书）是深入理解和定义树形结构的绝佳起点。http://a.co/9eVzvji
Joe Celko's Trees and Hierarchies in SQL for Smarties (book) is a good start for better understanding/defining trees. http://a.co/9eVzvji
关于这个主题有一本极好的书——《Joe Celko's Trees and Hierarchies in SQL for Smarties》。
There is an excellent book on this subject, "Joe Celko's Trees and Hierarchies in SQL for Smarties".
……服务器组中所有接口的吞吐量 [0] --- 相关书籍：Joe Celko 有一个“SQL for Smarties”书系，结合示例查询覆盖了从基础到高级的 SQL 聚合。Joe Celko 的《Trees and Hierarchies in SQL for Smarties》讲到了与“SQL 语句返回了一个数据库”相关的一些想法？--- [0]: https://dba.stackexchange.com/questions/173044/nested-aggreg... [1] : http://unicon.org/ [2] : https://cs.uwaterloo.ca/~tozsu/courses/CS338/lectures/6%20Ne...
…through put on all interfaces on group of servers [0] --- topic related books: Joe Celko has book series 'SQL for Smarties' that covers basic through advanced aggrecation with sql using example queries. Joe Celko's 'Trees and Hierarchies in SQL for Smarties' covers some of the ideas related to 'SQL statment returned a database'? --- [0]: https://dba.stackexchange.com/questions/173044/nested-aggreg... [1] : http://unicon.org/ [2] : https://cs.uwaterloo.ca/~tozsu/courses/CS338/lectures/6%20Ne...
……特性，特别是如果你的 RDBMS 不支持 Recursive CTEs（递归通用表表达式）的话。其影响在远低于你想象的数据量级下就会显现；几百万行就足以开始拖慢速度了。这本书 [0]（Joe Celko 的《Trees and Hierarchies in SQL For Smarties》）给出了许多其他方案，不过它确实缺少 closure table（闭包表）方法 [1]，而这正是我最推崇的方案。说到这里，我们又回到了数据库与应用层之间长期以来的摩擦这个老问题上了。……
…characteristics, especially if your RDBMS doesn't have Recursive CTEs. This starts to matter at a much lower scale than you might think; several million rows is enough to start showing slowdowns. This book [0] (Joe Celko's Trees and Hierarchies in SQL For Smarties) shows many other options, though it does lack the closure table approach [1], which is my preferred approach. And here, we come full circle back to the long-held friction between DBs and applications.…