GBORG NEWS: Announcing Materialized Views (matview) Project (matview)

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/