为了满足对起重机进行远程监控及故障诊断的需要,提出了融合远程监控、专家系统、智能诊断功能要求为一体的数据库系统。在需求分析的基础上,基于UML的面向对象建模思想,建立了整个系统的功能模型,完成了系统E-R图的设计。分别建立了起重机运行数据数据库,本征数据库,专家系统知识库,故障诊断模型库等,并依据各部分的数据关系有机组合在一起。最后给出了系统主要模块的实现结果。 In order to meet the need of remote monitoring and fault diagnosis of cranes, a database system integrating the requirements of remote monitoring, expert system and intelligent diagnosis was proposed. On the basis of requirement analysis, the function model of the whole system is established based on the object-oriented modeling idea of ​​UML, and the design of system E-R graph is completed. Crane operation data database, eigen database, expert system knowledge base and fault diagnosis model base are respectively established, and are grouped together according to the data relation of each part. Finally, the realization of the main module of the system is given.