Re: [HACKERS] Materialized views proposal

2003-11-30 Thread Sailesh Krishnamurthy
> "Hannu" == Hannu Krosing <[EMAIL PROTECTED]> writes: Hannu> Neil Conway kirjutas P, 30.11.2003 kell 02:18: >> Jonathan Gardner <[EMAIL PROTECTED]> writes: > 3) We >> would implement some sort of differential view update scheme > >> based on the paper "Efficiently Updating Mat

Re: [HACKERS] Materialized views proposal

2003-11-30 Thread Hannu Krosing
Neil Conway kirjutas P, 30.11.2003 kell 02:18: > Jonathan Gardner <[EMAIL PROTECTED]> writes: > > 3) We would implement some sort of differential view update scheme > >based on the paper "Efficiently Updating Materialized Views"[1]. Maybe the TelegraphCQ engine can give some ideas http://tele

Re: [HACKERS] Materialized views proposal

2003-11-29 Thread Neil Conway
Jonathan Gardner <[EMAIL PROTECTED]> writes: > 3) We would implement some sort of differential view update scheme >based on the paper "Efficiently Updating Materialized Views"[1]. One resource on this topic that appears to be quite authoritative is "Materialized Views: Techniques, Implementati

Re: [HACKERS] Materialized views proposal

2003-11-29 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 26 November 2003 10:58 am, Jonathan Gardner wrote: > On Wednesday 26 November 2003 09:19, Hannu Krosing wrote: > > What is needed is good algorithms. Writing C code is secondary to that. > > > > Similar problem has kept us from implementin

Re: [HACKERS] Materialized views proposal

2003-11-28 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 26 November 2003 09:19, Hannu Krosing wrote: > > First, You could start by implementing materialized views manually, > using tables and triggers, to get the feel of what should be generated. > > Next, still working from frontend, try to ma

Re: [HACKERS] Materialized views proposal

2003-11-26 Thread Hannu Krosing
Jonathan Gardner kirjutas K, 26.11.2003 kell 19:03: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I apologize if this post is inappropriate. > > Doing some development work, me and my co-worker discussed some > optimizations strategies. One of the ideas that came up was materialized > v

[HACKERS] Materialized views proposal

2003-11-26 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I apologize if this post is inappropriate. Doing some development work, me and my co-worker discussed some optimizations strategies. One of the ideas that came up was materialized views. Trading disk space to summarize queries, and paying for a trig