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 117
- Downloads 0
Multi-Criteria Genetic Algorithms for Solving Pig Food Problems
This paper presents an algorithm based on genetic algorithms (GAs) for multi-criteria problems to solve pig food problems. The proposed algorithm called Era-GAs scheme forms pig food formulations with the aim of finding...
Recognition of Isolated Handwritten Kannada Numerals based on Decision Fusion Approach
combining classifiers appears as a natural step forward when a critical mass of knowledge of single classifier models has been accumulated. Although there are many unanswered questions about matching classifiers to real-...
A Comparison and SWOT Analysis of Towards 4G Technologies: 802.16e and 3GPP-LTE
In recent years, there has been a plenty of paradigm shifts occurring in the way people across the world could connect and collaborate. Nowadays, wireless connectivity is almost everywhere and getting highly affordable e...
Modeling a production system based on flow-shop electrical system
Improving the competitiveness of a company amounts to control its workflow. The purpose of industries is to provide customer satisfaction and maximum production with a minimal cost, which requires the provision of a scie...
WaveCluster for Remote Sensing Image Retrieval
Wave Cluster is a grid based clustering approach. Many researchers have applied wave cluster technique for segmenting images. Wave cluster uses wave transformation for clustering the data item. Normally it uses Haar, Dau...