Looking for Good Product for Materialized View Incremental Refresh
Date: Sun, 27 Aug 2000 11:53:00 +0200
Message-ID: <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.