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 277
- Downloads 13
MULTI RESPONSE OPTIMIZATION OF PROCESS PARAMETERS FOR MACHINING TITANIUM WITH EDM
Electrical Discharge Machine (EDM) is the one nonconventional machining process which is used widely in tooling sector. In EDM, it is necessary to optimize the process parameters like a pulse on time, pulse off- time,...
THE ROLES AND RESPON SIBILITIES OF A HUMAN RESOURCE MANAGER IN AN ORGANISATION
This paper reveals about the roles and responsibilities of an HR who plays a vital role for smooth functioning of the Organization. It throws light on the conventional functions and the traditional role of HR managers....
Role and Significance of Values and Beliefs on Organizational Performance in selected Indian Companies
Values & beliefs are a set of expectations and assumptions that influence and guide the behavior of the employees in the organization. The association of employees within the organization has become an important prior...
Organisational Climate: A Conceptual Perspective
Despite the fact that there have been a number of research studies on organisational climate, there has yet been no unanimity on its definition as also on its dimensions. This diversity of opinions has made the organis...
slugConstruction of Mixed Sampling Plans Indexed Through Six Sigma Quality Levels with Chain Sampling Plan-(0,1) as Attribute Plan
Six Sigma is a concept, a process, a measurement, a tool, a quality philosophy, a culture and a management strategy for the improvement in the system of an organization, in order to reduce wastages and increase the pro...