slugThe Approaches of Materialize View Maintenance Process in Data Warehousing
Journal Title: International Journal of Management, IT and Engineering - 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 EP18251
- DOI -
- Views 317
- Downloads 13
A Study of Management of Intellectual Property RightsSpecial Reference to Music Industry
Intellectual Property is a strategic asset for industry and public health. It is a key element needed to maintain a competitive edge in the market. For Business growth of any enterprise, it is important to protect the...
slugA Study of Modeling, Simulation and Control Strategies for Marine Control Systems
This paper presents a review of various recent papers on development of models for control systems of large and complex processes of a vessel‘s main and auxiliary systems. The aim of this paper is to bring together the...
slugIT revolution and changing face of rural India
The role of Information Technology to develop agricultural research, education and extension to improve quality of life in rural area is well established. IT can help an average Indian farmer to get relevant informatio...
slugChallenges and Opportunities of Technology Transfer Management
Today, technology has become so rich that many of the developing countries can , t even afford to have all the facilities, It is admitted that these changes and takeovers affected economical, industrial, security, tech...
A Study on Role of Social Media in Agriculture Marketing and its Scope
Social media is the new upcoming area in agricultural marketing that has blogs, microblogs, pages, groups etc.This study adopted a descriptive research and the primary data collection tools were structured questionnair...