Materialized Views for MySQL
I just read about OLAP4ALL's Materialized Views for MySQL software that "offers the functionality of Materialized Views in MySQL that are not natively supported in the MySQL database.". What nags me about this is the fact that it is "implemented as a separate Java program running on the server where MySQL is installed". The server-side of this should be doable using Stored Procedures and/or Triggers. For the client-side a bit of convenience functionality for query rewriting would be needed. Sounds like an interesting project that I would like to pursue when I find the time. Update: Marcel Oelke has ported this Materialized Views for PostgreSQL implementation to MySQL (see here and here).