A simple coupler to link expert systems with database systems

Abstract Over the years, there has been a confluence of concepts, tools and techniques from two diverse areas: artificial intelligence (AI) and database (DB) systems. There are several ways to integrate expert systems (ES) and database systems. This paper surveys the related literature and classifies the integrated systems into four classes: enhanced DB, enhanced ES, coupling of existing ES and DB, and expert database system. A new loose coupling approach (Simple Coupler) based on predefined SQLs is then proposed. Its system architecture and system operations are described. The Simple Coupler is compared with the DIFEAD (Dictionary Interface for Expert Systems and Databases) approach and the commercial ES shell approach on the criteria of the independence of the DB, ES, the complexities and future expansibility. This approach has great practical values because of its simplicity. Finally, this paper reports on two prototypes coupling existing systems: accounting DB & financial ES and medical history database & medical diagnosis system, respectively, in the PC window environment.

[1]  Jack Minker,et al.  Logic and Databases: A Deductive Approach , 1984, CSUR.

[2]  Sharma Chakravarthy,et al.  A new perspective on rule support for object-oriented databases , 1993, SIGMOD '93.

[3]  Michael J. Ginzberg,et al.  Artificial Intelligence Applications for Business , 1984 .

[4]  Michael Stonebraker,et al.  The Integration of Rule Systems and Database Systems , 1992, IEEE Trans. Knowl. Data Eng..

[5]  Forouzan Golshani,et al.  Proceedings of the Eighth International Conference on Data Engineering , 1992 .

[6]  David C. Yen,et al.  Enhancing a DBMS Through the Use of an Expert System , 1990 .

[7]  Michael L. Brodie.  On knowledge base management systems: integrating artificial intelligence and database technologies , 2011, Topics in information systems.

[8]  Matthias Jarke,et al.  Database Access Requirements of Knowledge-Based Systems , 1984, Query Processing in Database Systems.

[9]  Jennifer Widom,et al.  Active Database Systems , 1995, Modern Database Systems.

[10]  Paul W. P. J. Grefen,et al.  Integrity Control in Relational Database Systems - An Overview , 1993, Data Knowl. Eng..

[11]  Ali R. Hurson,et al.  Multidatabase Systems: An Advance Solution for Global Information Sharing , 1993 .

[12]  Matthias Jarke,et al.  Logic Programming and Databases , 1984, Expert Database Workshop.

[13]  Heng-Li Yang.  Incorporating semantic integrity constraints in a database schema , 1992 .

[14]  James Clifford,et al.  New Directions for Database Systems , 1986 .

[15]  Ron Seljée,et al.  A New Method for Integrity Constraint Checking in Deductive Database , 1995, Data Knowl. Eng..

[16]  Gio Wiederhold,et al.  Knowledge and Database Management , 1984, IEEE Software.

[17]  Dennis McLeod,et al.  Larry Kerschberg, ed., Expert Database Systems: Proceedings from the Second International Conference , 1991, Artif. Intell..

[18]  Gio Wiederhold,et al.  Knowledge versus Data , 1986, On Knowledge Base Management Systems.

[19]  Lubomir F. Bic,et al.  The Fifth Generation grail: A survey of related research , 1984, ACM '84.

[20]  Charles Kellogg,et al.  From Data Management to Knowledge Management , 1986, Computer.

[21]  Jane Grimson,et al.  Expert systems and database systems: how can they serve each other? , 1987 .

[22]  Tore Risch,et al.  A functional approach to integrating database and expert systems , 1988, CACM.

[23]  Tomasz Imielinski,et al.  Mining association rules between sets of items in large databases , 1993, SIGMOD Conference.

[24]  Efraim Turban,et al.  Decision Support and Expert Systems: Management Support Systems , 1990 .

[25]  Alejandro P. Buchmann,et al.  Building an integrated active OODBMS: requirements, architecture, and design decisions , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[26]  Jane Grimson,et al.  Use of metadata to drive the interaction between database and expert systems , 1988 .

[27]  Michael Stonebraker,et al.  The POSTGRES next generation database management system , 1991, CACM.

[28]  Agnar Aamodt,et al.  Different Roles and Mutual Dependencies of Data, Information, and Knowledge - An AI Perspective on their Integration , 1995, Data Knowl. Eng..

[29]  Larry Kerschberg,et al.  Expert database systems: knowledge/data management environments for intelligent information systems , 1990, Inf. Syst..

[30]  Larry Kerschberg.  Expert Database Systems, Proceedings From the First international Workshop, Kiawah Island, South Carolina, USA, October 24-27, 1984 , 1986 .

[31]  Witold Litwin,et al.  From Database Systems to Multidatabase Systems: Why and How , 1988, BNCOD.

[32]  Amit P. Sheth.  Does loose AI-DBMS coupling stand a chance? , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[33]  Olivia R. Liu Sheng,et al.  An object-oriented methodology for knowledge base/database coupling , 1992, CACM.

[34]  Douglas Stott Parker.  Integrating AI and DBMS through stream processing , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[35]  Matthias Jarke,et al.  Coupling Expert Systems with Database Management Systems , 1983 .

[36]  Lubomir F. Bic,et al.  Learning from AI: New Trends in Database Technology , 1986, Computer.

[37]  Michele Missikoff,et al.  Towards a Unified Approach for Expert and Database Systems , 1984, Expert Database Workshop.

[38]  Michael Stonebraker,et al.  Future Trends in Expert Data Base Systems , 1988, Expert Database Conf..

[39]  Shalom Tsur,et al.  LDL-a technology for the realization of tightly coupled expert database systems , 1988, IEEE Expert.

[40]  Matthias Jarke,et al.  On Integrating Logic Programming and Databases , 1984, Expert Database Workshop.

[41]  Don Batory,et al.  Query Processing in Database Systems , 2011, Topics in Information Systems.

[42]  John Miles Smith,et al.  Expert Database Systems: A Database Perspective , 1984, Expert Database Workshop.

[43]  Arun N. Swami,et al.  Set-Oriented Data Mining in relational Databases , 1995, Data Knowl. Eng..

[44]  Larry Kerschberg,et al.  The role of loose coupling in expert database system architectures , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[45]  Tharam S. Dillon,et al.  Object-Oriented Conceptual Modeling , 1993 .

[46]  Jiawei Han,et al.  Constraint-Based Query Evaluation in Deductive Databases , 1994, IEEE Trans. Knowl. Data Eng..

[47]  Arie Segev,et al.  Rule Management in Expert Database Systems , 1994 .

[48]  Erol Gelenbe,et al.  New applications of data bases , 1984 .

[49]  Philip S. Yu,et al.  Proceedings of the Eleventh International Conference on Data Engineering , 1995 .

[50]  Olivia R. Liu Sheng,et al.  Object-oriented modeling and design of coupled knowledge-base/database systems , 1992, [1992] Eighth International Conference on Data Engineering.