Clustering-Based Dynamic Materialized View Selection Algorithm

  • Authors:
  • An Gong;Weijing Zhao

  • Affiliations:
  • -;-

  • Venue:
  • FSKD '08 Proceedings of the 2008 Fifth International Conference on Fuzzy Systems and Knowledge Discovery - Volume 05
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

With the base of proposing materialized view similarity function, the paper proposes clustering-based dynamic materialized view selection algorithm. It firstly clusters materialized views, and then dynamically adjusts materialized view set. So, it eliminates the "jitter", which dynamic materialized view selection algorithm generally has. The experimental results show that the algorithm not only improves the overall query response performance, but also reduces the computational cost which will bespent during updating materialized view.