Re: What to call this operator?
Date: Fri, 1 Jul 2005 11:11:57 +0200
In article <1120066601.412830.82070_at_g47g2000cwa.googlegroups.com>,
> > However, the symmetry/duality is lost in the semantics of the
> > operations---the relation predicate of the result. If relvars A and B
> > have predicates PA and PB, respectively, the expression A JOIN/<AND> B
> > has the predicate PA AND PB (logical and) in both D&D and Tropashko.
> > However, D&D's A <OR> B has the predicate PA OR PB (logical or), while
> > Tropashko's A UNION B has a rather more complicated and less intuitive
> > predicate (on first glance).
> I look at it this way:
> (I'll call Tropashko's operator "generalized union.")
> A natural join B: the union of the columns and the intersection of the
> A generalized union B: the intersection of the columns and union of the
> Quite symmetric, as I see it.
Whereas the predicate POAB(x,y,z) of A <OR> B is "employee x works in department y, or department y is led by manager z".
Questions of usefulness may of course be raised; I am merely pointing out that there is a lack of symmetry from this viewpoint.
-- JonReceived on Fri Jul 01 2005 - 11:11:57 CEST