Efficient Maintenance of Materialized Mediated Views

James J. Lu, Guido Moerkotte, Joachim Schue, V. S. Subrahmanian

Research output: Contribution to journalArticlepeer-review

37 Scopus citations


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 was proposed [24, 4, 16]. 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 [12] and introduce a new fixpoint operator Wp which — opposed to the standard fixpoint operator Tp [9] — allows us to correctly capture the update' semantics without any recomputation of the materialized view.

Original languageEnglish (US)
Pages (from-to)340-351
Number of pages12
JournalACM SIGMOD Record
Issue number2
StatePublished - May 22 1995
Externally publishedYes

ASJC Scopus subject areas

  • Software
  • Information Systems


Dive into the research topics of 'Efficient Maintenance of Materialized Mediated Views'. Together they form a unique fingerprint.

Cite this