News for hackers. Stuff that matters.
Re:EventReduce: An algorithm to optimize database queries th... by dahauns on Thursday April 16, 2020 @07:54AM (#22888461)
Sooo...Materialized/Indexed Views?
Re:EventReduce: An algorithm to optimize database queries th... by eventreduce on Thursday April 16, 2020 @07:55AM (#22888467)
No, see the FAQ in the readme:

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.

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...
Re:EventReduce: An algorithm to optimize database queries th... by dfgdghdf on Thursday April 16, 2020 @07:56AM (#22888474)
Correct me if I'm wrong, but Materialized Views have the limitation that you need to refresh the entire view! Often you know which rows will change based on the data you receive.
Re:EventReduce: An algorithm to optimize database queries th... by taffer on Thursday April 16, 2020 @10:09AM (#22889517)
This depends on the RDBMS. Oracle for example has incremental materialized view updates.