User-Oriented Materialized View Selection

  • Authors:

  • Ziyu Lin;Dongqing Yang;Guojie Song;Tengjiao Wang

  • Affiliations:

  • Peking University, Beijing, China;Peking University, Beijing, China;Peking University, Beijing, China;Peking University, Beijing, China

  • Venue:
  • CIT '07 Proceedings of the 7th IEEE International Conference on Computer and Information Technology
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

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 perfor- mance, instead of being user-oriented. In this paper, we propose a new user-oriented method, called SOMES (uSer- Oriented Materialized viEw Selection), aiming at achiev- ing better performance for view selection problem. SOMES takes into account query characteristics of different users, in which, users are classified into different groups accord- ing 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 de- sirable performance improvements over other methods such as BPUS and FPUS.