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 106
- Downloads 0
A Modified Robust Queue Management with Feedback Compensation Technique to Manage the Congestion Control in Wireless Communication Networks
At present there has been a tremendous growth in the computer networks and wireless networks. Due to the enormous growth of voice, audio, video and data applications over the wireless networks, the requirement of congest...
Secure Transmission of Compound Information Using Image Steganography
The security of information handled in real time transmission reception like internet is of paramount consideration, as this information may be confidential. And also, the parameter in concern nowa- days is size as it ma...
Information and Communication Technology for Rural Development
Due to the lack of knowledge and use of ICT in rural areas, development is at a very low rate. Some improvement and advancement in the technologies provided by the government but there is no more effect in the developmen...
Protection of Public Network Communication by using Internet Protocol Security
This paper deals with the issue of the protection of public etwork c description of custom cipher algorithm mplementation method is given. Paper also contains xperiment description with results. In the existing...
MINING THE INVESTOR’S PERCEPTION ABOUT DIFFERENT INVESTMENT OPTIONS USING CLUSTERING ANALYSIS
Investors’ expectation is a very significant factor that needs to be evaluating by all investment alternatives. The achievement of any investment policy depends on how successfully it has been able to convene the investo...