Start Efficiently updating materialized views dblp

Efficiently updating materialized views dblp

In other words, fresh information is constantly made available in the form of of new data and updates.

LRU-K =-=[22]-=- and 2Q [18], for instance, improve the performance of the traditional LRU eviction policy by tracking multiple past-page references, while ARC [21] shows similar performance improvements without rely...

Citation Context ..pool manager keeps track of disk pages brought in main memory, decides when to write updated pages back to disk, and evicts pages (typically using a LRU policy) when new ones are read.

The Hot Set =-=[25]-=- and DBMIN [6] algorithms rely on explicit hints from the query optimizer on query access patterns.

The usefulness of materialized views is limited when the workload is not always known ahead of time or the workload requirements are likely to change over time. Citation Context ...n the observed importance of different pages.

LRU-K [22] and 2Q [18], for instance, improve the performance of the traditional LRU eviction policy by tracking multiple past-page references, while ARC =-=[21]-=- shows similar performance improvements without relying on tunable parameters.

2.4 Multi-Query Optimization Multiple-query optimization (MQO) [13][27]=-=[24]-=- identifies common subexpressions in query execution plans during optimization, and produces globally-optimal plans.

Since the detection of common subexpressions is done at optimization time, all quer...

Citation Context ...t the expense of potentially significant view maintenance costs.