Re: transitive closure

"mAsterdam" <mAsterdam_at_vrijdag.org> wrote in message news:42dd0e6f$0$65378$e4fe514c_at_news.xs4all.nl...
> 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?

No. Received on Wed Jul 20 2005 - 15:29:39 CEST