APPLICATION OF SELF-MAINTAINABLE MATERIALIZED VIEWS ALGORITHM ON DATA WAREHOUSE FOR BANKING PROBLEM

Abstract

A warehouse is a repository of integrated information drawn from remote data source. Since a warehouse effectively implements materialized views, we must maintain the views when the data sources are updated. There are two kinds of algorithms to maintain the view in consistency with source: one has to send queries back to source and one stores a set of auxiliary views at warehouse and together with the view, they are self-maintainable. This paper introduces a technique applied to simplify auxiliary views by exploiting key and referential integrity constraints to solve the commercial banking problem with n-branch. The software was written by model 3-tiers Java-CORBA/RMI-Oracle.