[LYSW07b]Ziyu Lin, Dongqing Yang, Guojie Song, Tengjiao Wang. User-oriented Materialized View Selection. In Proc. of In Proc. of IEEE 7th International Conference on Computer and Information Technology.(CIT2007), Fukushima, Japan, 2007,PP:133-138. (EI,No.080311031089)[全文PDF下载]
User-oriented Materialized View Selection∗
Ziyu Lin∗ Dongqing Yang∗ Guojie Song‡† Tengjiao Wang∗
∗School of Electronics Engineering and Computer Science, Peking University, Beijing, China
‡State Key Laboratory of Machine Perception, Peking University, Beijing, China
The problem of materialized view selection has been long researched, and many approaches have been proposed to deal with this issue. However, all the methods proposed to date strive toward improving the overall query performance, instead of being user-oriented. In this paper, we propose a new user-oriented method, called SOMES (uSer-Oriented Materialized viEw Selection), aiming at achieving better performance for view selection problem. SOMES takes into account query characteristics of different users, in which, users are classified into different groups according to their query characteristics, and various user groups are provided with their own windows, user view windows containing the views involved in their own query process. Experimental results show that our method can achieve desirable performance improvements over other methods such as BPUS and FPUS.