Designing an Expert System to Diagnose & Treat Ear Illnesses

An expert database system is an expert system which is developed using DBMS technology to manage facts and rules. Frame-based expert systems are widely using as the knowledge representation for such expert systems with large knowledge bases. Many systems have the ability to connect to external databases. Facts stored in databases can be loaded into expert system’s knowledge base and inference is performed by the inference engine of the expert system. In many cases, such external facts are required several times for each inference. Thus, a lot of communication traffic takes place. This research work presents the design and implementation of a frame-based object-relational database system which has a tight coupling between the expert system and the external knowledge base. The external knowledge base also use frame as its knowledge representation. Moreover, it has its own inference engine so that inference can be perform on the knowledge base side and the results, are sent back to the expert system for further inference. In this research a medical consultation system is used as an illustrated example and an Oracle 10g object relational DBMS is used as the database platform.