Efficient maintenance of materialized mediated views
- 22 May 1995
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 24 (2) , 340-351
- https://doi.org/10.1145/568271.223850
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 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 W P which -- opposed to the standard fixpoint operator T P [9] -- allows us to correctly capture the update's semantics without any recomputation of the materialized view.Keywords
This publication has 13 references indexed in Scilit:
- Hybrid knowledge basesIEEE Transactions on Knowledge and Data Engineering, 1996
- Function materialization in object bases: design, realization, and evaluationIEEE Transactions on Knowledge and Data Engineering, 1994
- Maintaining views incrementallyPublished by Association for Computing Machinery (ACM) ,1993
- Reactive consistency control in deductive databasesACM Transactions on Database Systems, 1991
- On the efficient computation of the difference between consecutive database statesPublished by Springer Nature ,1991
- Constraint query languages (preliminary report)Published by Association for Computing Machinery (ACM) ,1990
- Updating derived relations: detecting irrelevant and autonomously computable updatesACM Transactions on Database Systems, 1989
- A performance analysis of view materialization strategiesPublished by Association for Computing Machinery (ACM) ,1987
- Constraint logic programmingPublished by Association for Computing Machinery (ACM) ,1987
- Maintenance of viewsACM SIGMOD Record, 1984