Re: transitive closure
Date: Tue, 19 Jul 2005 16:30:04 +0200
David Cressey wrote:
> Marshall Spight wrote:
>>Anyone have any experience with Oracle's CONNECT BY?
I only toyed with it. No production use (AFAIK - maybe some
development team started using it last month, in one of hundreds
of instances I'm not monitoring).
>>Is it the right abstraction? Too narrow? Too broad?
>>Does it work well?
> Oracle's CONNECT BY has worked well for me, at a very practical level.
> However, I prefer to think of it as a PROCESS tool than as a DATA tool. If
> I want the classical model of child parent relationships, I'll use a
> foreign key to the parent. If I want the processing benefits of nested
> sets, I'll use nested sets.
> And if I want to be able to traverse a tree that's represented by a
> child-parent foreign key, I'll use CONNECT BY. I know it's recursive
> internally. But I don't have to think recursively to use it.
> I'm not as concerned about portability as Joe Celko is.
Do you also use it in constraints? Received on Tue Jul 19 2005 - 16:30:04 CEST