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 121
- Downloads 0
Literature Review on Patient Scheduling Techniques
Patients need to undergo several checkups, tests, surgery and treatments according to their illness. This paper describes the challenges of patient scheduling and patient scheduling techniques. An efficient scheduling te...
Global Chaos Synchronization of Hyperchaotic Lorenz and Hyperchaotic Chen Systems by Adaptive Control
In this paper, we apply adaptive control method to derive new results for the global chaos synchronization of identical hyperchaotic Lorenz systems (2007), identical hyperchaotic Chen systems (2010) and non-identical hyp...
Model based approach for Detection of Architectural Distortions and Spiculated Masses in Mammograms
This paper investigates detection of Architectural Distortions (AD) and spiculated masses in mammograms based on their physical characteristics. We have followed a model based approach which separates the abnormal patter...
An Efficient Algorithm for Reliability Upper Bound of Distributed Systems with Unreliable Nodes
Abstract— The reliability of distributed systems in which the communication links are considered reliable while the computing nodes may fail with certain probabilities have been modeled by a probabilistic network or a gr...
A Review on sensor based communication kit for impaired society
A gesture is used to classify and recognize a signal that enables communication among the impaired community. It is a technique that has been in use to make people feel comfortable just like the normal people behave. In...