Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Looking for Good Product for Materialized View Incremental Refresh

Re: Looking for Good Product for Materialized View Incremental Refresh

From: Hilton Sun <Sunht_at_icst.pku.edu.cn>
Date: Mon, 28 Aug 2000 09:37:40 +0800
Message-ID: <8ocg1r$h2f$1@sunlight.pku.edu.cn>

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 Sun Aug 27 2000 - 20:37:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US