From: | ana_cata_hylo(at)yahoo(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Google Summer of Code: Full Disjunctions |
Date: | 2006-05-08 23:50:59 |
Message-ID: | 1147132259.147694.171690@j33g2000cwa.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> First, i have no knowledge of anyone that have implemented full disjunctions(ever) aside
> from the theoretical works of my colleagues.
> With the exception of a corner case of it, that I believe was a simulation in 96.
> (A. Rajaman and J.D. Ullman Integrating information by outerjoins and full-disjunctions).
> I'd love to hear about any implementation out there (aside from my colleagues work, which
> is mine also: cohen,sagiv, kimelfeld,kanza)
I didn't mean to imply there was. It was the Rajaraman & Ullman paper
that got me interested in FD's and then I've looked at the "Computing
Full Disjunctions" paper by Kanza & Sagiv which gives a general
solution.
Obviously from the second paper it's clear that implementing full
disjunction (efficiently) is a non-trivial exercise.
> It can never be a binary operation since at the heart of the matter is that you need to take
> each subset of the relations and join them. i.e.:
...
> Usually binary operations allow for a bottom up computation approach, but FD is a TOP down approach
> (Galindo-Legaria, C. outerjoins as disjunctions).
Right, thanks for clarifying.
>From a data analysis perspective I would like to be able to look at
various subsets, eg. FD(A,B,C), FD(B,C,D), FD(A,B,C,D) etc and so this
just means that each subset has too be computed independantly. I can
live with that but wasn't sure if I had missed something.
In any case, the difficulty of implementing FD precludes me from
experimenting with it just yet.
Regards
Lee
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-05-09 00:22:49 | Re: What is your favorite front end for user interaction |
Previous Message | Tom Lane | 2006-05-08 23:42:18 | Re: pg_restore duplicate key violations |