The design of a prototype personal computer database for the Expert System Advisor for Aircraft Maintenance Scheduling (ESAAMS)

Abstract

The Expert System Advisor for Aircraft Maintenance Scheduling (ESAAMS) was originally proposed in 1985 to assist in the scheduling of maintenance discrepancy repair in the organizational squadron environment. This dynamic environment produces a continuous flow of maintenance documentation from each maintenance action. Presently there exists no single system for the maintenance expert to retrieve this information to assist him, or her, in the critical maintenance decision making process. This theis addresses the design of the ESAAMS database which is of paramount importance to the expert system. Research on the use of the Naval Aviation Logistics Data Analysis (NALDA) database for a personal computer-based database, is documented. Review of other existing naval aviation database systems are included in this research. Based on interviews with experienced fleet aviation maintenance managers, a prototype database design is produced. This thesis concludes with recommendations for further study based upon the findings of this research.