Re:EventReduce: An algorithm to optimize database queries th...
by dahauns on Saturday April 18, 2020 @08:44AM
(#22907317)
Others have pointed this out already: This is wholly dependent on the RDBMS used, and Oracle offers incremental refresh on demand.
I have to admit though that I mistakenly thought that MSSQL would as well...
Materialized views solve a similar problem but in a different way with different trade-offs. When you have many users, all subscribing to different queries, you cannot create that many views because they are all recalculated on each write access to the database. EventReduce however has a better scalability because I does not affect write performance and the calculation is done when the fresh query results are requested not beforehand.