A Method of View Materialization Using Genetic Algorithm
Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2016, Vol 18, Issue 2
Abstract
A data warehouse is a very large database system that collects, summarizes and stores data from multiple remote and heterogeneous information sources. Data warehouses are used for supporting decision making operation on an intelligent system. The decision making queries are complex in nature and take a largeamount of time when they are run against a large data warehouse. To reduce the response time, materialized views can be used. Since, all possible views cannot be materialized due to space constraints, an optimal subset of views must be selected for materialization. An approach of selecting such subsets of views using Genetic Algorithms is proposed in this paper. This approach computes the top-T views from a multidimensional lattice and calculates the fitness values for each of them.
Authors and Affiliations
Debabrata Datta , Kashi Nath Dey , Payel Saha , Sayan Mukhopadhyay , Sourav Kumar Mitra
Keywords
Related Articles
- EP ID EP154156
- DOI -
- Views 135
- Downloads 0
Effective utilisation of ICT is the key to Business success: Case Study of SMEs in Zimbabwe
The focus of this paper is to analyse the utilisation of information communication technology (ICT) among small and medium enterprises (SMEs) in Zimbabwe, as one of the major factors contributing to their limited g...
A Flexible Method Using Identity Based Message Key Distribution for Securing Workflow Signatures
Abstract: The increase in advancement of information technology led the migration of workflows from paper based to electronic workflow systems. Basically a workflow consists of a number of tasks and each of these t...
Energy Efficiency in IEEE 802.11 standard WLAN through MWTPP
The main goal of this work is to achieve the energy efficiency in 802.11 WLAN through minimizing the energy consumption in the network. In this proposed study, we introduced a modification in PCF for enhancing...
Loan Approval Prediction based on Machine Learning Approach
Abstract: With the enhancement in the banking sector lots of people are applying for bank loans but the bank has its limited assets which it has to grant to limited people only, so finding out to whom the loan can be gra...
Detection and Prevention of Wormhole Attack in MANET UsingDSR Protocol
Abstract: With the advancement in wireless technologies, wireless networks are developing at a fast rate andso are the MANET’s. Several routing attacks are introduced in the wireless networks due to their dynamical...