Title: Efficient Maintenance of Materialized Mediated Views
Authors: James J. Lu, Guido Moerkotte, Joachime Schue and V.S. Subrahmanian.
Abstract Integrating data and knowledge from multiple heterogeneous sources | like databases, knowledge bases or specific software packages | is often required for answering certain queries. Recently, a powerful framework for defining mediated views spanning multiple knowledge bases by a set of constrained rules (cf. work of Kanellakis et. al. [27]) was proposed [5,26,39]. Within this paper, we investigate the materialization of these views by unfolding the view definition and the efficient maintenance of the resulting materialized mediated view in case of updates. Thereby, we consider two kinds of updates: updates to the view and updates to the underlying sources. For each of these two cases several efficient algorithms maintaining materialized mediated views are given. We improve on previous algorithms like the DRed algorithm [22] and introduce a new fixpoint operator W_P which | opposed to the standard fixpoint operator T_P [19] | allows us to correctly capture the update's semantics without any recomputation of the materialized view.
The paper is going to appear in the Proceedings of the International Conference on Management of Data (Sigmod 95). The postcript version of this paper is available.