Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vnedelcu
Starting Member
2 Posts |
 Posted - 2004-01-16 : 14:44:42
|
| Hi Rob,I read a couple of days ago your article on Trees and Hierarchies (see http://www.sqlteam.com/item.asp?ItemID=8866) and I found it very interesting. I read Joe Celko's articles and book before, but I think your approach is very interesting and can be used in many situations were is not really necessary to use the Nested Set Model.Was there any follow up article on this - at this end of the article you are saying about the part two with add/deleting nodses, etc?Thanks,Vasile |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-01-16 : 16:10:11
|
There has been no following articles  up to now. I was also looking forward to the other operations. However, in a database where I implemented this I focused a lot on the ParentNode information. So when you add/move you take the target ParentNode row and add 1 to the depth and take the ParentNode row's Lineage and add the Node(of the ParentNode). After that a lot of the operations became much clearer.We can always hope for the follow up, but Rob's probably very busy. |
 |
|
|
vnedelcu
Starting Member
2 Posts |
Posted - 2004-01-16 : 16:23:52
|
| Hi drymchaser,Thanks for replying. I understand that ParentNode is very important to keep track of modifications, and your appraoch seems interesting - I'll try to see what I can obtain.I am also wondering about sub-tree insertion/deletion since I guess is not trivial.Yes, let's hope Rob will post a follow-up.Vasile |
|
|
|
|
|
|
Rob - Trees article