A mechanism for view consistency in a data warehousing system

Jorng Tzong Horng, Chi Wei Chen

Research output: Contribution to journalArticlepeer-review

2 Scopus citations

Abstract

A data warehouse is a repository of integrated information from distributed, autonomous and heterogeneous information sources. Materialized views in the data warehouse must be maintained when updating the data in the information sources. The conventionally used incremental view maintenance algorithm causes the problem of anomalies. In addition, previous attempts to solve anomalies focus on compensating the changes of the view. In this work, a novel method which uses the information already available at the data warehouse instead of performing the compensation is presented. Rules are used to predict information deemed necessary to maintain a materialized view. The information is stored as auxiliary views. The proposed method does not require any data transmission between the information sources and warehouse when a change of a materialized view from an updated message occurs in information sources. Moreover, the method proposed herein saves a significant amount of time when materialized views are incrementally maintained.

Original languageEnglish
Pages (from-to)23-37
Number of pages15
JournalJournal of Systems and Software
Volume56
Issue number1
DOIs
StatePublished - 1 Feb 2001

Fingerprint

Dive into the research topics of 'A mechanism for view consistency in a data warehousing system'. Together they form a unique fingerprint.

Cite this