By Topic

Maintaining consistency in partially self-maintainable views at the data warehouse

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Samtani, S. ; Dept. of Comput. Sci. & Telecommun., Missouri Univ., Kansas City, MO, USA ; Kumar, V.

A data warehouse is a global repository, which stores facts originating from multiple, possibly heterogeneous sources in materialized views. Keeping these views up-to-date incrementally in response to the changes in the source data is referred to as incremental view maintenance. In such a dynamic environment, maintaining the consistency of warehouse is challenging because of the heterogeneity of data sources. The paper presents a scheme for maintaining data consistency at the warehouse. It does so by storing some additional information at the data sources as well as at the data warehouse. We achieve partial self-maintainability of materialized views at the data warehouse by exploiting the already existing key dependencies in the views. We identify the problems in maintaining consistency and present an algorithm that minimizes blocking of sequential updates to be installed in a materialized view at the data warehouse and thus reduces the view maintenance time

Published in:

Database and Expert Systems Applications, 1998. Proceedings. Ninth International Workshop on

Date of Conference:

25-28 Aug 1998