Text Increase Text Decrease Text Reset

paper 19, Materialized View Selection Using Vector Evaluated Genetic Algorithm

In Session 2 Computer Engineering and Technology from: International Conference on Computer Engineering and Technology, 3rd (ICCET 2011)
Author(s)/Editor(s): Jianhong Zhou
859735 Cover Image
Published: 2011
Author(s)/Editor(s): Seyed Hamid Talebian, Sameem Abdul Kareem
Chapter Page Count: 10 pages

Table of Contents

  • Preview

Chapter Contents

  • Abstract
  • Keywords
  • 1. Introduction
  • 2. Materialized View Selection
  • 3. Related Works
  • 4. Vector Evaluated Genetic Algorithm (VEGA)
  • 5. Constraint Handling
  • 6. Experimental Work
  • 7. Conclusion
  • References

Excerpt

Data Warehousing is an approach in which data from multiple heterogeneous and distributed operational systems (OLTP) are extracted, transformed and loaded into a central repository for the purpose of decision making. Since such database stores huge amounts of historical data, it is necessary to devise methods by which complex OLAP queries can be answered as fast as possible. OLAP is an approach which facilitates analytical queries accessing multidimensional databases. Using materialized views as pre-computed results for time-consuming queries is a common method for speeding up analytical queries. However, some constraints do not allow the systems to save all possible views. Therefore, one of the crucial decisions that data warehouse designers need to make is in the selection of the right set of views to be materialized. This paper focuses on solving the multi-objective view selection problem using a Vector Evaluated Genetic Algorithm (VEGA) approach subject to disk space constraint.



©2011 ASME

PURCHASE CHAPTER (US$25)

Download PDF
View Items in Cart

BOOK DATA

Print ISBN:

9780791859735

Publisher:



close