Databases Reference
In-Depth Information
Figure 18-3
The typical configuration which we predict users would use is to have the
MOLAP storage mode for the UDM with proactive caching enabled which is
shown in
Figure 18-3
. If users are sending queries to your cube, there is an
existing MOLAP cache of the UDM on your server. If a user sends a query,
data is retrieved from this MOLAP cache. The proactive caching thread looks
for changes in the relational data warehouse based on certain mechanisms,
which you see later in this chapter. As soon as there is a data change made
known to the proactive caching management thread, the thread itself then ini-
tiates rebuilding of a new MOLAP cache and clears the existing MOLAP
cache. Note that you can set properties that control the time at which the cur-
rent MOLAP cache gets cleared and the time at which the new MOLAP cache
needs to be rebuilt.
Search WWH ::
Custom Search