… trees in an SQL database, including the design I call Closure Table. In Closure Table, we store every path in a tree, not only…=InnoDB; Because there isn’t much written about using the Closure Table design, I periodically get questions about how to solve certain…  Everything else takes care of itself. I also wrote about Closure Table in my book, SQL Antipatterns: Avoiding the Pitfalls of Database…

… of all thanks a lot for all your articules about closure table.Also for your book. I´m learning quite a lot… tables: http://www.oreillynet.com/pub/a/network/2002/11/27/bioconf.html I have been doing some changes in our closure table… get the full relationship to represent a graph with a closure table. Can you point me out to read some info about…

Hi Ethan, Yes indeed, depending on the queries we use, the closure table may benefit from additional indexes. I was trying to focus on the logic required for the query, since that’s complex enough for one blog post.

… in your case. You should store the name outside the closure table. And you should pad each name to a fixed-length…

….) I used this query : http://stackoverflow.com/questions/8252323/mysql-closure-table-hierarchical-database-how-to-pull-information-out-in-the-c…

Hi Bill, I’m using the closure table hierarchy to store regions in a database using MySQL and …

…, as you’ve found out. I haven’t tested the Closure Table techniques with DAG structures, since these are used less commonly…

Hi Bill, I’m considering using a closure table to represent a hierarchical model allowing for multiple parents (say …