Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration

Schema integration is a main step in the database integration process. Since the semantics of a schema is also determined by its integrity constraints, a correct and complete schema integration has to deal with integrity constraints existing in the different schemas to be integrated. In this paper, we present a framework for the correct handling of integrity constraints during schema integration. In particular, we work out the correspondence between local integrity constraints and global extensional assertions. The knowledge about the correspondences between the underlying integrity constraints and extensional assertions can then be utilized for an augmented schema integration process.

[1]  Richard Hull Relative Information Capacity of Simple Relational Database Schemata , 1986, SIAM J. Comput..

[2]  Gunter Saake,et al.  Merging inheritance hierarchies for database integration , 1998, Proceedings. 3rd IFCIS International Conference on Cooperative Information Systems (Cat. No.98EX122).

[3]  Fèlix Saltor,et al.  A Semantic-Discriminated Approach to Integration of Federated Databases , 1995, CoopIS.

[4]  James A. Larson,et al.  A Theory of Attribute Equivalence in Databases with Application to Schema Integration , 1989, IEEE Trans. Software Eng..

[5]  Fèlix Saltor,et al.  Semantic heterogeneity in multidatabase systems , 1995 .

[6]  Gunter Saake,et al.  Deriving Relationships between Integrity Constraints for Schema Comparison , 1998, ADBIS.

[7]  W. Alex Gray,et al.  Integrity Management in an Object-Oriented Federated Database Environment , 1995, BNCOD.

[8]  James A. Larson,et al.  Integrating User Views in Database Design , 1986, Computer.

[9]  Wolfgang Effelsberg,et al.  A rule-based approach for merging generalization hierarchies , 1988, Inf. Syst..

[10]  Peter M. G. Apers,et al.  The Role of Integrity Constraints in Database Interoperation , 1996, VLDB.

[11]  Amar Gupta,et al.  Formulating Global Integrity Constraints During Derivation of Global Schema , 1995, Data Knowl. Eng..

[12]  Ingo Schmitt,et al.  Considering Integrity Constraints During Federated Database Design , 1998, BNCOD.

[13]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.