Updating Multiple Databases Through Mediators

Mediator is a facility that supports an integrated view over multiple information sources, and allows for queries to be made against the integrated view. In this paper, we extend the mediator architecture to support updates against the integrated view. Updates expressed against the mediator’s integrated view need to be translated into updates of the underlying local databases. We developed algorithms to generate translators for the basic types of mediator update operations. In our approach, a translator is a function that receives an update request and generates the update’s translation. In this paper, we present the algorithm that generates translators for monovalued attribute modification operations.

[1]  Arthur M. Keller,et al.  The Role of Semantics in Translating View Updates , 1986, Computer.

[2]  Stefano Spaccapietra,et al.  View Integration: A Step Forward in Solving Structural Conflicts , 1994, IEEE Trans. Knowl. Data Eng..

[3]  Richard Hull,et al.  Managing semantic heterogeneity in databases: a theoretical prospective , 1997, PODS.

[4]  Marian H. Nodine The InfoSleuth Agent System , 1998, CIA.

[5]  Michael R. Genesereth,et al.  The Basis for Mediation , 1995, International Conference on Cooperative Information Systems.

[6]  Shamkant B. Navathe,et al.  A schema integration facility using object-oriented data model , 1995 .

[7]  Jennifer Widom,et al.  The TSIMMIS Project: Integration of Heterogeneous Information Sources , 1994, IPSJ.

[8]  Timothy W. Finin,et al.  KQML as an agent communication language , 1994, CIKM '94.

[9]  Nicolas Spyratos,et al.  Update semantics of relational views , 1981, TODS.

[10]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[11]  Umeshwar Dayal,et al.  On the correct translation of update operations on relational views , 1982, TODS.

[12]  Larry M. Stephens,et al.  Using a domain-knowledge ontology as a semantic gateway among information resources , 1997 .

[13]  James A. Larson,et al.  Updating relational views using knowledge at view definition and view update time , 1991, Inf. Syst..

[14]  Jeffrey D. Ullman,et al.  MedMaker: a mediation system based on declarative specifications , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[15]  Tok Wang Ling,et al.  View Update in Entity-Relationship Approach , 1996, Data Knowl. Eng..