Discovering interdatabase resemblance of classes for interoperable databases

The integration of database schemas into a federated one involves a detection phase where the similarities that exist among the classes of the different databases must be discovered in order to determine their semantic relationships. This phase is typically characterized by the complexity of the comparison task and the deep knowledge about the semantics of the databases that is required to perform it. The authors present an approach to handle this problem by upgrading the semantic level of the local schemas and guiding the search of the comparison process by the structure of the generalization/specialization semilattices and aggregation graphs of the resulting rich schemas. Unnecessary as well as most promising comparisons are identified and a systematic procedure to analyze the rich component schemas in a meaningful way is given. A reduction of the complexity is achieved. The methodology serves as the basis for a tool that semiautomatizes the process. The expressiveness of the canonical model plays a central role.<<ETX>>

[1]  Fèlix Saltor,et al.  A Canonical Model for the Interoperability Among Object-Oriented and Relational Databases , 1992, IWDOM.

[2]  Félix Enrique Saltor Soler,et al.  The development of semantic concepts in the BLOOM model using an object metamodel , 1991 .

[3]  Fèlix Saltor,et al.  Suitability of datamodels as canonical models for federated databases , 1991, SGMD.

[4]  Fèlix Saltor,et al.  Overcoming Schematic Discrepancies in Interoperable Databases , 1992, DS-5.

[5]  Dennis McLeod,et al.  The semantic data model: a modelling mechanism for data base applications , 1978, SIGMOD Conference.

[6]  Fèlix Saltor,et al.  Discriminated operations for interoperable databases , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[7]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[8]  Clement T. Yu,et al.  Determining relationships among attributes for interoperability of multi-database systems , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[9]  Isabelle Comyn-Wattiau,et al.  View Integration by Semantic Unification and Transformation of Data Structures , 1990, ER.

[10]  James A. Larson,et al.  A tool for integrating conceptual schemas and user views , 1988, Proceedings. Fourth International Conference on Data Engineering.

[11]  Malú Castellanos,et al.  Semantic enrichment of interoperable databases , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[12]  Stephen Hayne,et al.  Multi-user view integration system (MUVIS): an expert system for view integration , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

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