Fri Dec 15 08:28:23 GMT 2006

model tree in set

We usually format tree structure using adjacency list, however, it also able to present in a set. Which spend more work on [create, delete, update] operations, but achieve much better query performance.

http://searchdatabase.techtarget.com[..]com/tip/1,289483,sid13_gci537290,00.html
http://searchdatabase.techtarget.com[..]com/tip/1,289483,sid13_gci801943,00.html
http://www.onlamp.com/lpt/a/5007
http://www.google.com[..]firefox-a&rls=org.mozilla:en-US:official
http://www.anarchogeek.com/archives/000173.html

Java example - http://threebit.net/tutorials/nestedset/tutorial1.html


(google search) (amazon search)
1 2 3 second