A natural language interface to a multiple databased office information system

As an organization grows through mergers and acquisitions and through the integration of independently designed information sub-systems, it could find itself faced with a collection of databases implemented on heterogeneous database management systems. This paper presents a system to provide integrated access to multiple, independently designed databases through a portable natural language front-end and a multiple database access system back-end.The overall system is divided into a natural language interface (NLI) front-end and a multiple database access system (MDAS) back-end. The MDAS integrates the various conceptual views into a single global external schema. In a prototype of the overall system, the NLI will accept a natural language query and produce a relational calculus query expression over a global external schema. The MDAS will construct the response to the query by accessing the separate constituent databases through the local database management systems (DBMS's).

[1]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[2]  W. Shipman David,et al.  The functional data model and the data language DAPLEX , 1988 .

[3]  Maurizio Lenzerini,et al.  A Methodology for Data Schema Integration in the Entity Relationship Model , 1984, IEEE Transactions on Software Engineering.

[4]  Levent V. Orman.  Nested set languages for functional databases , 1984, Inf. Syst..

[5]  Jano Moreira de Souza.  SIS - A Schema Integration System , 1986, BNCOD.

[6]  S. Misbah Deen,et al.  Data Integration in Distributed Databases , 1987, IEEE Transactions on Software Engineering.

[7]  Ralph Grishman,et al.  Isolating Domain Dependencies In Natural Language Interfaces , 1983, ANLP.

[8]  Yuri Breitbart,et al.  Database integration in a distributed heterogeneous database system , 1986, 1986 IEEE Second International Conference on Data Engineering.

[9]  S. Jerrold Kaplan,et al.  Designing a Portable Natural Language Database Query System , 1984, TODS.

[10]  Peter P. Chen.  The entity-relationship model: a basis for the enterprise view of data , 1986, AFIPS '77.

[11]  Ramez Elmasri,et al.  Relationship Merging in Schema Integration , 1984, VLDB.

[12]  David W. Shipman.  The functional data model and the data language DAPLEX , 1979, SIGMOD '79.

[13]  Frederick B. Thompson,et al.  Introducing ASK, A Simple Knowledgeable System , 1983, ANLP.

[14]  Levent V. Orman.  Design criteria for functional data bases , 1985, Inf. Syst..

[15]  Gary G. Hendrix,et al.  Transportable Natural-Language Interfaces to Databases , 1981, ACL.

[16]  Jerrold M. Ginsparg.  A Robust Portable Natural Language Data Base Interface , 1983, ANLP.

[17]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[18]  Barbara J. Grosz,et al.  TEAM: A Transportable Natural-Language Interface System , 1983, ANLP.

[19]  Toshiaki Yoshino,et al.  A knowledge-based approach to design a portable natural language interface to database systems , 1986, 1986 IEEE Second International Conference on Data Engineering.

[20]  Umeshwar Dayal,et al.  View Definition and Generalization for Database Integration in a Multidatabase System , 1984, IEEE Transactions on Software Engineering.

[21]  Roger King,et al.  Semantic Data Models , 1985, Principles of Database Design.

[22]  John D. Burger,et al.  Problems in Natural-Language Interface to DBMS With Examples From EUFID , 1983, ANLP.

[23]  Frederick B. Thompson,et al.  ASK is transportable in half a dozen ways , 1985, TOIS.

[24]  Candace E Kalish.  A Portable Natural Language Interface. , 1987 .

[25]  John Mylopoulos,et al.  A language facility for designing database-intensive applications , 1980, TODS.

[26]  Douglas E. Appelt,et al.  TEAM: An Experiment in the Design of Transportable Natural-Language Interfaces , 1987, Artif. Intell..