Re: Looking for Good Product for Materialized View Incremental Refresh

David,

I know of a product that is an alternative to materialized views that you can incrementally refresh, without a delete being performed. It's the OMNIDEX database search engine, which has Aggregation Indexes and Multidimensional Indexes. For more information, see http://www.disc.com/dwhbroch.html or contact me.

Cheryl Grandy
cgrandy_at_disc.com
303 444-4000
www.disc.com/home

In article <39a8d78f_at_news.bezeqint.net>,   "David Donn" <ddonn_at_intersystemsww.com> wrote:
> 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.
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com http://www.deja.com/
Before you buy.