Sciweavers

Share
DBA
2006

Simulated Annealing for Materialized View Selection in Data Warehousing Environment

9 years 11 months ago
Simulated Annealing for Materialized View Selection in Data Warehousing Environment
In order to facilitate query processing, the information contained in data warehouses is typically stored as a set of materialized views. Deciding which views to materialize presents a considerable challenge. The task is to select from a very large search space a set of views that minimizes view maintenance and query processing costs. Heuristic methods have been employed to find near optimal solutions and recent genetic algorithms have significantly improved the quality of the obtained solutions. In this paper we introduce a new approach for materialized view selection that is based on Simulated Annealing in conjunction with the use of a Multiple View Processing Plan (MVPP). Our experiments show that our new method provides a further significant improvement in the quality of the obtained set of materialized views, leading to a further significant improvement in query processing time and view maintenance costs for data warehousing systems. KEY WORDS Data warehousing, materialized view ...
Roozbeh Derakhshan, Frank K. H. A. Dehne, Othmar K
Added 30 Oct 2010
Updated 30 Oct 2010
Type Conference
Year 2006
Where DBA
Authors Roozbeh Derakhshan, Frank K. H. A. Dehne, Othmar Korn, Bela Stantic
Comments (0)
books