Hey Steve, very cool.
I'm trying to figure out if I like the Nested Trees or the animated
tutorials better.
Getting off the topic of CF (and esp. of FuseBox), the Nested Trees model
seems to offer huge benefits in extracting meaningful hierarchical data, but
at a large cost when INSERTing, DELETEing and otherwise re-arranging the
tree.
Have you (or any of us) any real-world tales about the pros and cons of
these trade-offs?
Basically, I have always built my hierarchies as with each node pointing to
its parent. I guess that's the "adjacent list" method? This is
conceptually simple, but can be a real bastard when trying to extract, say,
an ordered list of ancestors. The recursive SQL is just never as elegant as
the pure Platonic form ;-)
Should I be re-thinking my whole data structure? Say Yes at your peril.
Nice work once again, Steve
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
btw, can you START a message with "btw"?
-----Original Message-----
From: Steve Nelson [mailto:[EMAIL PROTECTED]]
btw, I did a killer series (if I do say so myself) ;) on Joe Celko's
"Nested Set Model" from SQL for Smarties. This is something even the
gurus can learn from.
These tutorials will make sense of that ever annoying problem of "How do
you deal with nested trees in a database?"
....
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
