Parallel Simulated Annealing for Materialized View Selection in Data Warehousing Environments

Loading...
Thumbnail Image
File version
Author(s)
Derakhshan, Roozbeh
Stantic, Bela
Korn, Othmar
Dehne, Frank
Griffith University Author(s)
Primary Supervisor
Other Supervisors
Editor(s)

Bourgeois, AG

Zheng, SQ

Date
2008
Size

335026 bytes

File type(s)

application/pdf

Location
License
Abstract

In order to facilitate efficient query processing, the information contained in data warehouses is typically stored as a set of materialized views. Deciding which views to materialize represent a challenge in order to minimize view maintenance and query processing costs. Some existing approaches are applicable only for small problems, which are far from reality. In this paper we introduce a new approach for materialized view selection using Parallel Simulated Annealing (PSA) that selects views from an input Multiple View Processing Plan (MVPP). With PSA, we are able to perform view selection on MVPPs having hundreds of queries and thousands of views. Also, in our experimental study we show that our method provides a significant improvement in the quality of the obtained set of materialized views over existing heuristic and sequential simulated annealing algorithms.

Journal Title

Lecture Notes in Computer science

Conference Title
Book Title
Edition
Volume

5022

Issue
Thesis Type
Degree Program
School
DOI
Patent number
Funder(s)
Grant identifier(s)
Rights Statement
Rights Statement

© 2008 Springer-Verlag. This is the author-manuscript version of this paper. Reproduced in accordance with the copyright policy of the publisher. The original publication is available at www.springerlink.com

Item Access Status
Note
Access the data
Related item(s)
Subject

History, heritage and archaeology

Persistent link to this record
Citation
Collections