Abstract: In the data warehouse system, OLAP query usually involves two operations which are multi-table connection and grouping congregation. To improve the performance of queries has become the key to speed up OI_AP responding.Some time-assuming operations such as table connection and congregation can be calculated and preserved by utilizing materialized view. This investigation is based on the updated arithmetic of materialized view relating query frequency. It makes materialized view is fully utilized and query time can is highly shortened so that the query efficiency is able to be highly elevated.

Key words: Data warehouse, Materialized view, OLAP, Multi-dimension data query, Query optimizing