Database and Expert Systems Integration - Information Systems Reengineering, Integration and Normalization - page 327

Class Name: Personnel
Attributes:
ID: Method(id) /*input part*/
Name: Method(name) /*input part*/
Age: Method(age) /*input part*/
Staff-Type: Method(staff-type) /*input part*/
Directorate: Method(directorate) /*input part*/
Current-Status :Method(current-status) /* input part*/
Average-Mark: Method(average-mark) /*input part*/
Skill-1: Method(skill-1) /*input part*/
Skill-2: Method(skill-2) /*input part*/
Methods :
id():text; {…………}
name():text; {…………}
age():number; {…………}
staff-type():text; {…………}
directorate():text; {…………}
current-status():text; {…………}
average-mark():number; {…………}
skill-1():text; {…………}
skill-2():text; {…………}

Fig. 8.12 Personnel DB coupling class

Standard-Output-Part-Attribute(); <result-data-type>;
{ Request the data from the system (i.e. Request)

Send the data to the external existin system (i.e. Write)}

Standard-Input-Part-Of-Attribute();<result-data-type>;
{ Receive the data from the existing external system

(i.e. Receive)

Save the data to the system (i.e. Save)}

Fig. 8.13 The standard algorithm of the method for the coupling class

The real process of the four generic functions will depend on the coupling situation.
They will represent different process for the different integrating requirements. For
example, the Receive function may involve a SQL statement to request a data from
the external relational database or it processes a RPC (Remote Procedure Call) to
execute an external existing ES. The process of these four generic functions will be
decided in the step 3.

Step 3. Integrate Database System and Expert System
To integrate these two coupling classes, the developer must insert the synonym
information (see Table 8.4 ) into the information resource dictionary system (IRDS)
as an integrated class. IRDS is a repository for the integrated classes. The integrated
class is to integrate and resolve naming conflicts among the coupling classes. The
resultant synonym table (Table 8.4 ) in the form of integrated class is to synchronize
and integrate the coupling classes. The solution is to create two active classes for
the two semantic rules described in Step 1. Figure 8.14 shows the two active classes.