View updates for an extended entity-relationship model
Information Sciences: an International Journal
View update in entity-relationship approach
Data & Knowledge Engineering
Managing semantic heterogeneity in databases: a theoretical prospective
PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Update semantics of relational views
ACM Transactions on Database Systems (TODS)
On the correct translation of update operations on relational views
ACM Transactions on Database Systems (TODS)
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
View Integration: A Step Forward in Solving Structural Conflicts
IEEE Transactions on Knowledge and Data Engineering
MedMaker: A Mediation System Based on Declarative Specifications
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
A Rigorous Approach to Schema Restructuring
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
| Hi-index | 0.00 |
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. The novel aspects of our algorithms are that the translators are generated based on the correspondence assertions that formally specify the relationships between the mediator schema and the local databases schemas. Our formalism allows us to identify, precisely, the situations where the ambiguities can be solved at mediator definition time and the criteria for choosing the most appropriate translator. In this paper, we show that, by using our formalism, it is possible to define rigorously the correct translation for mediator update operations for cases where concepts in the mediator schema are represented differently in the local databases schemas.