Re: Looking for Good Product for Materialized View Incremental Refresh

hi David

i am also interested in the job what u r doing. i want to know where can i find some papers about this area. can u give me some advices? thank you.

Hilton Sun

"David Donn" <ddonn_at_intersystemsww.com> wrote in message news:39a8d78f_at_news.bezeqint.net...
> Hi,
>
> does anyone know of a product which incrementally refreshes Materialized
> Views in such a way that each incremental change to the view is always
> "minimal"?
>
> The only product I have experience with is Oracle8i. Using Oracle8i MVs
 for
> example, incrementally refreshing an equi-join MV after update of a row in
 a
> base table always results in a delete, then an insert of the "same" row
 when
> an update is often the "minimal" refresh.
>
> From my research on the web, theory in this area seems quite well
> established yet I've not been able to find many commercial products. Do I
> really have to implement my own algorithm? Please no!
>
> Thanks in advance for any assistance.
>
> David Donn
> Software Engineer
> InterSystems Pty. Ltd.
>
>
Received on Mon Aug 28 2000 - 03:37:40 CEST