A Framework for the View Selection Problem in Data Warehousing Environment
Journal Title: International Journal on Computer Science and Engineering - Year 2010, Vol 2, Issue 9
Abstract
A set of essential new concepts and tools have evolved into a new technology that makes it possible to access and produce accurate and timely management information for the competitive world. The phrase that has come to characterize this new technology is Data Warehousing (DW). The general problem of selecting an appropriate set of views to materialize is called the materialized view selection problem. In order to acquire a precise and quick response to an analytical query, proper selection of the views to materialize in the data warehouse is crucial. In traditional view selection algorithms, all relations are considered for selection as materialized views. Due to the space constraint and maintenance cost constraint, the materialization of all views is not possible. The primary goal of data warehousing is to select a suitable set of views that minimizes the total cost associated with the materialized views. In this paper, we present a framework, an optimized version of our previous work, for the view selection problem, which intends to achieve the best combination of low query processing cost, low view maintenance cost and good query response. All the cost metrics associated with the materialized views selection that comprise the query execution frequencies, base-relation update frequencies, query access costs, view maintenance costs and the system’s storage space constraints are considered by this framework. This framework optimizes the maintenance, storage and query processing cost and selects the most cost effective views to materialize. Thus, an efficient data warehousing system is the outcome.
Authors and Affiliations
B. Ashadevi , Dr. R. Balasubramanian , Dr. P. Navaneetham
Keywords
Related Articles
- EP ID EP155320
- DOI -
- Views 110
- Downloads 0
Robust Non-Oblivious Dwt-Adaptive Invisible Digital Watermarking
The main idea of this paper is embedding invisible watermark into an image. The advantage of this method over previous works is that it is easy to embed and robust to attacks. Non-oblivious detection technique is used. T...
Facial Expression Recognition
Facial expression analysis is rapidly becoming an area of ntense interest in computer science and human-computer interaction design communities. The most expressive way humans display emotions is through facial expressi...
Generating Customer Profiles for Retail Stores Using Clustering Techniques
The retail industry collects huge amounts of data on sales, customer buying history, goods transportation, consumption, and service. With increased availability and ease of use of modern computing technology and e-commer...
Class hierarchy method to find Change-Proneness
Finding Proneness of software is necessary to identify fault rone and change prone classes at earlier stages of development, so that those classes can be given special ttention. Also to improves the quality and reliabili...
A Survey on Recent Security Trends using Quantum Cryptography
Cryptography is the science of keeping private information from unauthorized access of ensuring data integrity and uthentication, and it is the strongest tool for controlling against much kind of security threats. Role...