3 ms·
IIUIC, the most significant difference from a materialized view is that the Rama infrastructure recompute only the changed data by checking the relationship bet
by leonidasv 3y ago
IIUIC, the most significant difference from a materialized view is that the Rama infrastructure recompute only the changed data by checking the relationship between fields, while a traditional materialized view recomputes the whole table?
- andrenotgiant 3y agoincremental view maintenance is the database equivalent of: "recompute only the changed data by checking the relationship between fields," Oracle has decent support for incrementally updated materialized views, redshift has some too. Materialize.com is an entire snowflake-like platform built around incrementally maintained materialized views.
- dustingetz 3y agoisn't Materialized performing symbolic differentiation of SQL queries?