Special paper
Using linguistic knowledge in view integration: Toward a third generation of tools

https://doi.org/10.1016/S0169-023X(97)00004-9Get rights and content

Abstract

This paper addresses the problem of view integration in a CASE tool environment which is aiming at the elaboration of a conceptual schema of an application. The previous integration tools were mainly based on syntax and structure comparisons. A new generation of intelligent tools is now arising, assuming that view integration algorithms must also capture the deep semantics of the objects represented in the views. Dealing with the semantics of the objects is now a realistic objective, thanks to the research results obtained in the natural language area. This paper presents the definition of a view integration algorithm enhanced by the use of linguistic knowledge. This algorithm mainly consists of a semantic unification of views which are described using an extended entity-relationship model. It is combined with natural language techniques such as Fillmore's semantic cases and Sowa's conceptual graphs, supported by semantic dictionaries.

References (44)

  • A.P. Ambrosio et al.

    The linguistic level of the Kheops CASE Tool

  • M.H. Antoni-Lay et al.

    A Generic Model for Reusable Lexicons: The Genelex Project, 5, Le projet GENELEX: EUREKA pour les dictionnaires génériques

  • C. Batini et al.

    A Methodology for Data Schema Integration in the E-R Model

    IEEE Transactions on Software Engineering

    (Nov. 84)
  • C. Batini et al.

    A comparative analysis of methodologies for database schema integration

    ACM Computing Surveys

    (Dec. 86)
  • C. Batini et al.

    Conceptual Database Design

    (1992)
  • J. Biskup et al.

    A formal view integration method

  • M. Bonjour et al.

    Concept Bases: A Support to Information Systems Intergration

    CAiSE'94

    (1994)
  • M. Bouzeghoub et al.

    Semantic approach for object-oriented database design

  • M. Bouzeghoub et al.

    Conception de Bases de Données: Etat de l'Art sur la Modélisoation Conceotuelle, l'Intégration de Vues et la Conception Physique

  • M. Bouzeghoub et al.

    View integration by semantic unification and transformation of data structures

  • P. Buitelaar et al.

    The use of a lexicon to interpret ER diagrams: A LIKE Project

  • F. Civelek et al.

    An expert system approach to view definition and integration

  • C. Collet et al.

    Resource integration using a large knowledge base in Carnot

    IEEE Computer

    (December 1991)
  • I. Comyn-Wattiau

    L'intégration des vues dans le système expert SECSI

  • I. Comyn-Wattiau et al.

    Constraint confrontation: An important step in view integration

  • H.S. Delughach

    An exploration into semantic distance

    Lecture Notes in Artificial Intelligence

    (1993)
  • E. Ellmer et al.

    Neural networks technology to support view integration

  • R. Elmasri et al.

    Data model integration using the structural model

  • C. Fillmore

    The Case for Case, Universal in Linguistic Theory

  • R.V. Guha et al.

    CYC: A midterm report

  • M. Hammer et al.

    Database description with SDM: A Semantic Database Model

    ACM Transactions on Database Systems

    (Sept. 1981)
  • S. Hayne et al.

    Multi-user view integration system (MUVIS): An expert system for view integration

    • Cited by (7)

    • A knowledge-based approach for duplicate elimination in data cleaning

      2001, Information Systems
      Citation Excerpt :

      However, research focus of the past has been on the problem of view integration (or sometimes referred to in literature as schema integration), where the aim is the reconciliation of differences at the conceptual level. View integration has been investigated in numerous comprehensive studies on integration frameworks [4,5], mediator systems [6,7] and schematic conflict resolution [8,9]. Data cleaning, which is the next logical step that involves reconciliation of data at the instance level, has received little attention.

    • Towards the Automation of Modeling Language Independent Schema Integration

      2009, Proceedings - International Conference on Information, Process, and Knowledge Management, eKNOW 2009

    • ANDROMEDA: Building e-science data integration tools

      2006, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

    • An Approach for Deriving a Global Representation of Data Sources Having Different Formats and Structures

      2004, Knowledge and Information Systems

    • DIKE: A system supporting the semi-automatic construction of cooperative information systems from heterogeneous databases

      2003, Software - Practice and Experience

    • Ontology-based data cleaning

      2002, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
    View all citing articles on Scopus
    View full text
    Copyright © 1997 Published by Elsevier B.V.