The Approaches of Materialize View Maintenance Process in Data Warehousing

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

Mapping the Agricultural Geography: A District Wise Pattern in the South-Eastern Part of the Punjab Province in Colonial India.

The South-Eastern part of the Punjab was somewhat backward during 1858-1947. This subregion was also located away from the perennial rivers Punjab and the river Jamuna‘s course was along the eastern boundary of the stat...

A 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...

APPLYING E-SUPPLY CHAIN MANAGEMENT USING INTERNAL AND EXTERNAL AGENT SYSTEM

In the electronic business, supply chain management must deal with globalization, reproducing product mixture, organizational obstacles, and fast information allotment. The tools are required to support supply chain ma...

Network Simulation Based Parametric Analysis of AODV Protocol for Wireless Mobile Ad-hoc Network.

A major aspect of ad-hoc networks is that the nodes can move randomly, which requires the routing protocols. The routing protocol should try to minimize control traffic, such as periodic update messages. Instead the ro...

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...

Download PDF file
  • EP ID EP26630
  • DOI -
  • Views 360
  • Downloads 6

How To Cite

Mr. Sanjay S. Solanki and Dr. Ajay Kumar (2012). The Approaches of Materialize View Maintenance Process in Data Warehousing. International Journal of Engineering, Science and Mathematics, 2(4), -. https://europub.co.uk/articles/-A-26630