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 119
- Downloads 0
Resource Aware Node Authentication Framework for Secure MANET
Abstract: MANET comprises mobile nodes, which are links to each other by wireless connections without any base infrastructure. MANETs are vulnerable to security attack due to their features such as autonomous natur...
The impact of using Gregorian calendar dates in systems that adapt localization: In the case of Ethiopia
Ethiopian calendar has 13 months in which 12 months have 30 days equal and the 13th month has 5 or 6 days length. Date is one of the inputs for web or desktop applications. Java Development Kit(JDK) and JodaTime Date Tim...
Optimizing Neuro-Fuzzy Fault Diagnostic Algorithm for Photovoltaic Systems
Abstract: The main goal of this research is to develop a novel optimum neuro-fuzzy system for diagnosis the complex and dynamic systems. .It has used the Particle Swarm Optimization (PSO) technique for training the Adapt...
KURCS: Key Updating for Removing & replacement ofCompromised Sensor Nodes from Wireless Sensor Networks
Abstract : An energy efficient key management scheme is an important aspect to ensure secure services inresource constrained Wireless Sensor Networks (WSNs). There are two parts of key management scheme, i.e.key distribu...
A Novel approach for Graphical User Interface development and real time Object and Face Tracking using Image Processing and Computer Vision Techniques implemented in MATLAB
Image Processing is an advancement in the Signal processing domain where the input is an image or video and output can be image, video or in any other forms. With daily advances in Human-Computer interaction, I...