> Better, mark this view (or particular rows if it's not too
> expensive) as "dirty" and recompute it only on access, you
> may spare few cycles...
That sort of depends on what you're going for. Typically materialized
views are used for summarizations of hypercubes for OLAP systems (data
marts
2005/10/20, Heikki Tuuri <[EMAIL PROTECTED]>:
> Andrew,
>
> how about using triggers to recompute materialized views? A challenge is to
> write an automatic program that can compute the required triggers based on
> the view definition. The materialized view would be a normal table. Triggers
> would
On 10/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> So... which of the many storage engines are you hoping to extend? It would
> be nice if you could do them all but I think we all anticipate that InnoDB
> will pose special challenges.
After a bit of group consultation, we've decided to
- Original Message -
From: "Andrew Roth" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 19, 2005 6:06 PM
Subject: Re: Input on Materialized Views
Thanks for the clarification and comments. I should reiterate that
for our project, we
How you redefined your project definitely makes your goal much easier to
reach.
As I see it, most of what you need to do is related to figuring out how
to create disk-cached VIEWs and how to invalidate the cache whenever any
of the VIEW's underlying data has changed. This does not necessarily
Thanks for the clarification and comments. I should reiterate that
for our project, we do *not* need to actually implement materialized
views, but only suggest refactoring and/or new components required to
implement them. I think implementing it would too time consuming for
a group of three stude
Just like Jigal, I also had to lookup the term "materialized view". For
the sake of others on the list trying to follow along: a materialized view
is basically a self-updating snapshot of a table (or tables) usually
containing some sort of intermediate statistical computations involving
GROUP B
Andrew Roth wrote:
Hi all,
We are a group of three students in Professor Ric. Holt's Software
Architecture class at the University of Waterloo. As our project, we
would like to examine the MySQL source to determine the best way to
implement materlialized views.
It would be wise to hang around
