Re: storing tree-like structures in tables

Joe Celko routinely recommends a nested set construction for this problem. Here is an explanation. Or search for more articles on it.

Comment on Re: storing tree-like structures in tables

Replies are listed 'Best First'.
Re^2: storing tree-like structures in tables by adrianh (Chancellor) on Nov 28, 2002 at 11:52 UTC
There is now a nice perl introduction to this way of representing trees over on oreillynet - just in case anybody's still interested :-)	[reply]
Re^2: storing tree-like structures in tables by Anonymous Monk on Feb 08, 2004 at 19:41 UTC
Two related documents... Storing Hierarchical Data in a Database Four ways to work with hierarchical data	[reply]
Re^2: storing tree-like structures in tables by adrianh (Chancellor) on Sep 12, 2002 at 07:27 UTC
++ on this. The nested set construction is a really useful technique for representing trees in SQL that I've used several times in the past.	[reply]