Re: Materialized views (Was Re: Improving count(*)) - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: Materialized views (Was Re: Improving count(*))
Date
Msg-id b0f3f5a10511210619p5f37ca00h9a7f044e3aab61ef@mail.gmail.com
Whole thread Raw
In response to Re: Materialized views (Was Re: Improving count(*))  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Materialized views (Was Re: Improving count(*))  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 11/20/05, Heikki Linnakangas <hlinnaka@iki.fi> wrote:

> On Sat, 19 Nov 2005, Nicolas Barbier wrote:
>
> > You might want to take a look at the pages that I set up to track the
> > progress on my master's thesis:
> >
> > <url:http://www.nicolas.barbier.easynet.be/itsme/thesis/>
> >
> > especially the literature page:
> >
> > <url:http://www.nicolas.barbier.easynet.be/itsme/thesis/literature/>
> >
> > IMO, GL95, Qua97 and GM99 are the ones that are most applicable to
> > view maintenance with bag-semantics (thus, SQL). You should be able to
> > find all these papers with Google (Scholar) in case my computer is
> > shut down, otherwise you can download them directly from me.
>
> Thanks, interesting stuff.
>
> BTW: Does the GL95 algorithm handle outer joins?

No, but GM99 does (although only in the cases where it can be
applied). I guess that a slightly adapted version of the technique
from Qua97 can also be used. Investigating :-).

greetings,
Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html


pgsql-hackers by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: plpython and bytea
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [PATCHES] drop database if exists