Performance Optimization of MDX Statement Execution Based on Materialized Views
Dongjin Yu · Jisuanji gongcheng · 2008
The Multi Dimensional Expression(MDX) statements are often used in the process of multi-dimensional analysis of massive data.Howto optimize the statements in order to boost the query speed is one of key issues when constructing the OLAP systems.By the predefinedmaterialized views, the query statements can be rewritten and executed against one single table instead of the join of one fact table and severaldimensional tables.The paper presents the thought of how to select the candidate materialized views and also the experimental results, which showthat the boosting effect is more encouraging while dealing with more data via more complicated MDX statements.