Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Relational Lattice, what is it good for?

Re: Relational Lattice, what is it good for?

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 17 Feb 2006 17:46:31 -0800
Message-ID: <1140227191.170345.95540@z14g2000cwz.googlegroups.com>


Mikito Harakiri wrote:
> ...has a chance to be
> repaired.

Indeed. Withoul loss of generality, we could focus on relations with headers

A(x,u,w,t)
B(y,u,v,t)
C(z,v,w,t)

They don't satisfy Spight criteria, however. The relations that satisfy are

A(x,t)
B(y,v,t)
C(z,v,t)

Working out the left side of distributivity equation we have:

A && (B || C) = { (x,v,t) | A(x,t) and ( exists y B(y,v,t) or exists z C(z,v,t) ) }

while the right side is

(A && B) || (A && C) =
{ (x,v,t) | (exists y A(x,t) and B(y,v,t)) or (exists z A(x,t) and C(z,v,t)) }

They are equivalent since existential quantifier can be moved into the outer most scope.

On the other hand, if we consider the relations, that don't satisfy spight criteria, say

A(x,u,t)
B(y,u,v,t)
C(z,v,t)

Then we'll have the the u variable stuck under existential quantifier in the left side expression and free on the right side. Received on Fri Feb 17 2006 - 19:46:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US