Dynamic Selection of Materialized Views of Multi Dimensional Data with a Multi-Users and Multi Windows Method

Dynamic selection of materialized views of multi dimensional data is one of the most researched aspects in the field of data warehouse; With the increasing use of data warehouse, there will be accordingly more and more different kinds of users making use of OLAP tools to complete their analytical work; The existing methods being used to select views do not take into account the characteristic of various kinds of users, and therefore have some defects; A multi users and multi windows method is presented here, which considers the disparity among various users and makes use of the rule of the users’ queries In the method, all users are divided into three groups with different grade and each user is accordingly endowed with user view window of certain grade Such method leads to the reasonable use of the limited space resource and also speeds up the response of query, which stipulates satisfying some special needs of certain user; Some related conceptions and MUMW algorithm are also put forward here, and at the same time, the advantages of this method are described