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

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

Looking for Good Product for Materialized View Incremental Refresh

From: David Donn <ddonn_at_intersystemsww.com>
Date: Sun, 27 Aug 2000 11:53:00 +0200
Message-ID: <39a8d78f@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 - 04:53:00 CDT

Original text of this message

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