Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> comp.databases.theory -> Re: x*x-1=0

Re: x*x-1=0

From: Jan Hidders <>
Date: 31 Jan 2001 09:49:21 GMT
Message-ID: <958n31$4g2$>

Vadim Tropashko wrote:
> In article <94rr74$l4j$>,
> (Jan Hidders) wrote:
> > Vadim Tropashko wrote:
> > > In article <94mhpf$jdh$>,
> > > (Jan Hidders) wrote:
> > > > Note that if you have ordered tuples then the projection is also
> > > > likely to be slightly different. If you say PROJ[#1,#2](R) then
> > > > that will mean something else than PROJ[#2,#1](R).
> > >
> > > What are unordered tuples: sets or bags?
> >
> > Neither.
> Do tuples have *internal* structure in terms of set/bags theory?

Yes, named tuples are defined as functions that map a name to a value. And, as you probably know, functions can again be defined as a set of pairs, and a pair can also be defined in terms of sets.

> > > > But things get, from an algebraic perspective, a little more
> > > > complicated because the cartesian product does not commute as
> > > > the join does.


> In exercise 6.1 Chris suggests to verify that product (along with some
> other operations) is commutative. On the other page he claims that join
> is commutative as well.

Yes, but note that he talks about the algebra defined on sets of *named* tuples (and, therefore, needs the rename operator) where I was talking about the algebra defined on sets of *ordered* tuples. The operations on these algebras are similar but have different algebraic properties.

> I agree that renaming could be viewed as algebraic operation. I wonder
> 1. if this is a productive definition

Well, for starters, it is definitely something that you need to be able to do, and it is not expressible with the other operators. So by that definition of "productive" it is not only productive but even inescapable.

> 2. how would I define relational algebra without renaming (renaming,
> then, goes into metamodel). The fact that in classic algebras we never
> consider renaming as part of algebra confuses me

Sorry, renaming has to be there. That it confuses you is not the algebra's problem. :-)

> 3. how algebra with renaming operation relates to the one without it

The expressive power becomes greater.

  Jan Hidders
Received on Wed Jan 31 2001 - 03:49:21 CST

Original text of this message