Proactive Caching)

Currently, BI presentation is generally based on historical data analysis. To achieve real-time BI, it is not impossible to achieve it. Some time ago, due to work needs, Microsoft's Active cache mechanism was specifically verified.
I. Basic concepts:
Microsoft's storage modes for cubes include MOLAP, ROLAP, and HOLAP. This section briefly introduces three formats:
1. MOLAP: Data and aggregation of measurement value groups are stored in multi-dimensional format files;
2. ROLAP: Data and aggregation of measurement value groups are stored in relational databases;
3. HOLAP: Metric value group data is stored in relational databases, while aggregated data is stored in multi-dimensional files.
To balance the advantages of MOLAP (high query performance) and ROLAP (strong real-time performance), Microsoft provides active caching.
Ii. Active Cache Mechanism
For example, the technical architecture diagram of Microsoft's Active cache processing:

NOTE: If active Cache is enabled, the Cache in the Cube is read before the new Cache is generated.

If the old version of the Cache exists, the new Cache is under construction and can read the old version of the Cache.

Delete the old version Cache. The new Cache overwrites the old version Cache and reads the relational database data;

After overwriting, read the new Cache.

1 2 Next Page