Optimal View Selection by View Relevance Driven Selection Algorithm
Main Article Content
Abstract
Materialized view selection problem is one of the most important decisions in designing a data warehouse. In order to efficiently solve
the problem, a modified genetic algorithm for how to select a set of views to be materialized so as to achieve both good query performance and
low view maintenance is available. A data warehouse uses multiple materialized views to efficiently process a given set of queries. These views
are accessed by read-only queries and need to be maintained after updates to base tables. Due to the space constraint and maintenance cost
constraint, the materialization of all views is not possible. Therefore, a subset of views needs to be selected we propose a View Relevance Driven
Selection (VRDS) algorithm based on view relevance to select views. We take into consideration the query processing cost and the view
maintenance cost to be materialized.
Keywords: heuristic algorithm, view relevance, data warehouse, views, view selection, materialization
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.