3 ms·
Another option for storing tree structures is the closure table [1]. It acts as a sort of "many-to-many" junction table between the tree nodes, storing the rela
by coleifer 12y ago
Another option for storing tree structures is the closure table [1]. It acts as a sort of "many-to-many" junction table between the tree nodes, storing the relationships between each.
[1] https://coderwall.com/p/lixing/closure-tables-for-browsing-trees-in-sql https://coderwall.com/p/lixing/closure-tables-for-browsing-t...
- chdir 12y ago+1, Related reading (all from Bill Karwin of SQL Antipatterns fame): http://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree/192462#192462 http://stackoverflow.com/questions/192220/what-is-the-most-e... http://www.slideshare.net/billkarwin/models-for-hierarchical-data http://www.slideshare.net/billkarwin/models-for-hierarchical... http://karwin.blogspot.in/2010/03/rendering-trees-with-closure-tables.html http://karwin.blogspot.in/2010/03/rendering-trees-with-closu...