From: | Chris Ryan <xgbe(at)yahoo(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | GBORG NEWS: Announcing Materialized Views (matview) Project (matview) |
Date: | 2003-12-02 17:17:01 |
Message-ID: | 20031202171701.10384.qmail@web40012.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Latest News from gborg.postgresql.org:
>
> Materialized Views are a feature everyone wants to see in PostgreSQL.
> This project is the beginnings of that feature.
>
> Right now, we are in the early stages of research. Preliminary
> research shows that we are likely going to have only two kinds of
> materialized views: "Snapshot" and "Auto-Updated".
>
> The snapshot materialized views will be updated only when refreshed.
> This is currently implemented in the simplest way possible - just
> delete all the rows from the materialized view and requery.
>
> In the future, optimizations will include doing a differential update
> based only on the changes that have occured to the base relations
> since the last refresh.
>
> Auto-updated materialized views are always in sync with the base
> relations. Individual inserts, updates, and deletes are propagated
> differentially to the materialized view. Optimization strategies do
> exist and are well-documented, but it will take some time to work out
> the exact technical implementations.
>
> The key to auto-updating materialized views (and differentially
> refreshed snapshot materialized views) lie in performing the
> differential update. There are two key elements. First, we must
> identify relevant inserts, updates, and deletes. Then. we must
> calculate the differential effect of the relevant modification.
>
> Version 0.1 (although marked stable) is a development release. It
> provides basic snapshot functionality. It is intended for
> experimentation and meddling. It may not be suited for production
> environments.
>
> Version 0.2 will include a very inefficient auto-updating
> materialized view.
>
> Version 0.3 will include a partially optimized auto-updating
> materialized view.
>
> Join the mailing list and contribute your ideas or understanding of
> relational database theory to our project. Download the sources,
> experiment with them, and make changes.
>
> For more information go to:
> http://gborg.postgresql.org/project/matview/
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ryan | 2003-12-03 13:19:34 | GBORG NEWS: Uniqueidentifier-0.2 is out (uniqueidentifier) |
Previous Message | Robert Treat | 2003-12-01 14:32:06 | == PostgreSQL Weekly News - December 1st 2003 == |