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

 Enabling Platform-As-A-Service through a Consolidated Resource Manager

 Abstract: Platform as a Service (PAAS) is a new initiative that is changing the structure of the organizations from traditional infrastructure services to the cloud based services. With the growing demand for these...

 Analysis of Bus Tracking System Using Gps on Smart Phones

Abstract: Public transport networks (PTNs) are difficult to use when the user is unfamiliar with the area they are traveling to. This is true for both infrequent users (including visitors) and regular users who need to t...

Personalized Offers in Local Shops Using Client-Server"

Abstract: Everybody loves shopping, in one way or the other. Some prefer clothes, while others may spend hours, searching for that perfect gadget. Shopping uplifts mood, nobody is unhappy after they have bought something...

 An Improved Hashing Method for the Detection of Image Forgery

 Abstract: Detection of image forgery is always a crucial factor in image forensic and security applications. Usually this detection is possible with the help of local or global features of an image. We can ensure...

 A New Skin Color Based Face Detection Algorithm by CombiningThree Color Model Algorithms

 Abstract: Human face recognition systems have gained a considerable attention during last decade due to itsvast applications in the field of computer and advantages over previous biometric methods. There are manyap...

Download PDF file
  • EP ID EP154156
  • DOI -
  • Views 114
  • Downloads 0

How To Cite

Debabrata Datta, Kashi Nath Dey, Payel Saha, Sayan Mukhopadhyay, Sourav Kumar Mitra (2016).  A Method of View Materialization Using Genetic Algorithm. IOSR Journals (IOSR Journal of Computer Engineering), 18(2), 125-133. https://europub.co.uk/articles/-A-154156