scholarly journals Dynamic View Selection for OLAP

Author(s):  
Michael Lawrence ◽  
Andrew Rau-Chaplin
2008 ◽  
Vol 4 (1) ◽  
pp. 47-61 ◽  
Author(s):  
Michael Lawrence ◽  
Andrew Rau-Chaplin

2015 ◽  
Vol 27 (1) ◽  
pp. 53-63 ◽  
Author(s):  
Scott Spurlock ◽  
Richard Souvenir

2016 ◽  
Vol 21 (1) ◽  
pp. 17 ◽  
Author(s):  
Rajib Goswami ◽  
Dhruba Kr Bhattacharyya ◽  
Malayananda Dutta ◽  
Jugal K. Kalita

2014 ◽  
Author(s):  
Tristan M. Goss ◽  
P. Werner Barnard ◽  
Haldun Fildis ◽  
Mustafa Erbudak ◽  
Tolga Senger ◽  
...  

Author(s):  
Zohra Bellahsene

There are many motivations for investigating the view selection problem. At first, materialized views are increasingly being supported by commercial database systems and are used to speed up query response time. Therefore, the problem of choosing an appropriate set of views to materialize in the database is crucial in order to improve query processing cost. Another application of the view selection issue is selecting views to materialize in data warehousing systems to answer decision support queries. The problem addressed in this paper is similar to that of deciding which views to materialize in data warehousing. However, most existing view selection methods are static. Moreover, none of these methods have considered the problem of de-materializing the already materialized views. Yet it is a very important issue since the size of storage space is usually restricted. This chapter deals with the problem of dynamic view selection and with the pending issue of removing materialized views in order to replace less beneficial views with more beneficial ones. We propose a view selection method for deciding which views to materialize according to statistic metadata. More precisely, we have designed and implemented our view selection method, including a polynomial algorithm, to decide which views to materialize.


Sign in / Sign up

Export Citation Format

Share Document