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 340
- Downloads 6
Simulating Complex Environmental Phenomena Using Cubemap Mapping Technique
concepts of simulation of rain falling effects using: Delta3D Particle System Editor, which renders rain falling effect using two static raindrop textures, and Physical Properties-Based Method which renders rain fallin...
A Study on the Job Stress in Association with Personal Attributes of University Employees in Nepal
The study attempts to examine the association of the perceived job stress with some demographic, economic and job attributes of the university employees in Nepal. The analysis of data collected from the sample of 44 em...
THE PROBLEM OF OUTLIERS IN CLUSTERING
Clustering has been widely used in many applications including data mining, pattern recognition and machine learning. Noise is a major problem in cluster analysis, which degrades the performance of many existing method...
“BRAIN CONTROLLED CAR FOR DISABLED USING ARTIFICIAL INTELLIGENCE”
This paper considers the development of a brain driven car, which would be of great help to the physically disabled people. Since these cars will rely only on what the individual is thinking they will hence not require...
A STUDY ON PERSONAL FINANCIAL PLANNING FOR IT SECTOR INVESTOR IN PUNE
The evaluation of financial planning has been increased through decades, which is best seen in customer rise. Now a day’s investment of saving has assumed great importance. According to the study of the markets, it is...