Re: Materialized views (Was Re: Improving count(*))

Поиск
Список
Период
Сортировка
От Nicolas Barbier
Тема Re: Materialized views (Was Re: Improving count(*))
Дата
Msg-id b0f3f5a10511210619p5f37ca00h9a7f044e3aab61ef@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Materialized views (Was Re: Improving count(*))  (Heikki Linnakangas <hlinnaka@iki.fi>)
Ответы Re: Materialized views (Was Re: Improving count(*))  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: plpython and bytea
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [PATCHES] drop database if exists