Professional SQL Server™ Analysis Services 2005 with MDX

18.1. Proactive Caching

Traditionally, OLAP refers to fast access of aggregate or summarized data, with the source data retrieved from a relational data warehouse and stored in a storage format called MOLAP (Multidimensional OLAP). Relational databases are nonetheless really helpful for detail-level data and also helpful for reporting. You learned that MOLAP storage is optimal and provides the best performance while ROLAP storage provides instant access to the latest data but does not have the same performance as that of MOLAP storage. Proactive caching is an important feature addition in Analysis Services 2005 because it aids the UDM to deliver the best of relational and OLAP worlds, most importantly real time data access with near MOLAP performance. Proactive caching helps UDM to achieve real time data by providing controls that help in data propagation from the source data to the UDM which is then available for users queries. When appropriate proactive caching properties are set then Analysis Services starts building a new MOLAP cache when data in the underlying data source changes. Analysis Services serves users from the existing MOLAP cache. As soon as the new MOLAP cache is rebuilt then all the users are served from the new MOLAP cache and start seeing the new data. You see the use of this concept in action throughout this chapter.

As mentioned earlier, the UDM merges the relational and OLAP worlds. We consider proactive caching to be a management feature that helps the ...