International Journal of Computer Science Issues

More than a traditional journal...

A data warehouse is system which that support decision-making in production environment .Classical data warehouse management system are often optimized by improving query performance. Such improvement is casually achieved by using caches, indexes and materialized views and required selecting the best set of data structures (materialized views, indexes, etc...). In the cloud based data warehouse performing such selection become more challenging due to the complexity of a cloud computing environment .In this paper we propose a materialized view selection algorithm based on monetary which take in consideration the computation cost, storage cost and transfer cost. By using query prediction our algorithm can perform in a dynamic manner to select the best set of materialized view.