The Approaches of Materialize View Maintenance Process in Data Warehousing
Journal Title: International Journal of Engineering, Science and Mathematics - Year 2012, Vol 2, Issue 4
Abstract
Materialized view maintenance is a significant issue due to the growing use of warehouse technology for information integration and data analysis. Materialized views are used to speed up query processing on large amounts of data. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. These views need to be maintained in response to updates in the source data. Typically, a view is maintained immediately, as a part of the transaction that updates the base tables called as eager view maintenance. Immediate view maintenance imposes a significant overhead on update transaction that cannot be tolerated in many applications. A materialized view can be maintained lazily as maintenance is postponed until the system has free cycle or after a specific time period called a deferred view maintenance. Experiments using a prototype implementation in Oracle 9i show much faster response times for updates and also significant reduction in maintenance cost when combining updates.
Authors and Affiliations
Mr. Sanjay S. Solanki and Dr. Ajay Kumar
Keywords
Related Articles
- EP ID EP26630
- DOI -
- Views 364
- Downloads 6
An Efficient Centroid Selection Algorithm for K-means Clustering
This paper, we proposes an algorithm for performing data partitioning along the data axis with the highest variance to improve the accuracy. The data partitioning tries to divide data space into small cells or clusters...
A Study on Liquidity, Profitability and Working Capital Management of CoOperative Dudh Sangh.
Working capital management involves the management and control of the gross current assets. Its effective management provision can do much more to the success of the business. Its inefficient management can lead not on...
Privacy and Trust Management in Cloud Computing
Cloud computing is a technology that uses the internet and central remote servers to maintain data and applications. Cloud computing allows consumers and businesses to use applications without installation and access t...
RAIN TECHNOLOGY.
The massive jumps in technology led to the expansion of internet as the most accepted medium for communication. But one of the most prominent problems with this client server based technology is that of maintaining a r...
IMPLIMENTATION OF WIRELESS AD-HOC NETWORK USING AURDINO CONTROLLER
The main aim of the paper is to explain the working of a robot with the use of an Ad-Hoc network. This paper explains major features of the Ad –Hoc network along with the wheel rotational analysis and the DC motor spec...