paper 19, Materialized View Selection Using Vector Evaluated Genetic Algorithm
Table of Contents
- Session 1 Computer Engineering and Technology
- 1. The Impact of Usage Nonverbal Channels on Shared Understanding of Requirements Reached by Developers and Users: A Review
- Session 2 Computer Engineering and Technology
- 11. A New Method for Self-Embedding Image Construction
- Session 3 Computer Engineering and Technology
- 21. Mouth's Action Units Recognition Base on Non-Frontal View 3D Images
- 30. Myocardial Infarction Classification Using Polynomial Approximation and Principal Component Analysis
- Session 4 Computer Engineering and Technology
- 31. Sub-Population Genetic Algorithm II for Multi-Objective Parallel Machine Scheduling Problems
- 32. Linkage Learning by Block Mining in Genetic Algorithm for Permutation Flow-Shop Scheduling Problems
- Session 5 Computer Engineering and Technology
- 41. Design and Optimization of Triple-Band Microstrip Antenna for WiMAX Applications
- 47. Estimation of Optimum Number of Eigen Vectors for Compression of Color Images Using KL Transform
- 49. Design and Optimization of Printed Circular Monopole Antenna with Tapered Base for UWB Applications
- Session 6 Computer Engineering and Technology
- 51. Competent Corner Detectors for Outline Image
- 57. Research on Replicas Consistency Strategies Based on Optimization Replicas Chain in Cloud Storage
- Session 7 of Internet and Web Engineering
- 64. Improved Link Analysis Ranking with Bloom Filter
- Session 8 Software and Information Engineering
- 71. Preprocessing Selection of Enterprise Resource Planning Applications in Small Manufacturing Industry and Its Impact on Business Process Agility
- Session 9 Software and Information Engineering
- 81. A Model Based Approach for White Box Testing
- 84. The Execution Time Overhead of Entering and Exiting Scoped Memory in Real-Time Java Applications
- Session 10 Software and Information Engineering
- 91. How E-Commerce Model Build the Online Hybrid Marketing Channel in Emerging Economics
- 96. The Role of Information and Communications Technologies (ICT) in Education in Developing Countries
- Session 11 Software and Information Engineering
- 100. Automatic Inconsistency Detection for Online Responses
- Session 12 Communication and Broadband Networking
- 106. An Adaptive Dependable Fault-Tolerant Scheme for Distributed Systems
- Session 13 Communication and Broadband Networking
- 116. SENMAN: A Secure Encoder for MANET
- Session 14 Communication and Broadband Networking
- 126. Construction and Analysis of New 1-D Synchronous Codes for Optical CDMA
- Session 15 Communication and Broadband Networking
- 136. Energy Efficient Cluster Routing Algorithm for Wireless Sensor Networks
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


This Publication
Scitation
SPIN
Scitopia
Google Scholar
PubMed