A Theory of Attributed Equivalence in Databases with Application to Schema Integration
IEEE Transactions on Software Engineering
Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
View update in entity-relationship approach
Data & Knowledge Engineering
Relational to entity-relationship schema translation using semantic and inclusion dependencies
Integrated Computer-Aided Engineering
PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
Model independent assertions for integration of heterogeneous schemas
The VLDB Journal — The International Journal on Very Large Data Bases
View Integration: A Step Forward in Solving Structural Conflicts
IEEE Transactions on Knowledge and Data Engineering
ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views
Proceedings of the Sixth International Conference on Data Engineering
Generating Object-Oriented Views from an ER-Based Conceptual Schema
Proceedings of the 3rd International Conference on Database Systems for Advanced Applications (DASFAA)
A Normal Form For Entity-Relationship Diagrams
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Abstracting Relational and Hierarchical Data with a Semantic Data Model
Proceedings of the Sixth International Conference on Entity-Relationship Approach
External Schemas of Entity-Relationship Based Data Base Management Systems
Proceedings of the Seventh International Conference on Enity-Relationship Approach: A Bridge to the User
A Method for Translating Relational Schemas into Conceptual Schemas
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Resolving Structural Conflicts in the Integration of Entity Relationship Schemas
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
Hi-index | 0.00 |
It is important to support updates in federated database systems. However, not all updates on the federated schema are possible because some may violate certain constraints in the local databases which are involved in the federation. In this paper, we give a formal framework which characterizes the conditions under which a federated schema object type is updatable. We study the steps involved to systematically map an update request on an external view of a federated schema into the equivalent update(s) on the local databases. We also consider the situation where semantically equivalent object types may not model exactly the same set of objects in the real world. We ensure that the set constraints (EQUAL, SUBSET, DISJOINT) between the instance sets of equivalent object types are not violated after an update.