论文部分内容阅读
为了适应压路机结构复杂,诊断难度高的状况,介绍了压路机智能故障诊断系统的核心硬件结构和体系结构,并在此基础上着重研究了智能故障诊断系统的数据库子系统。详细分析了数据库中的数据组成,运用关系实体模型对数据库进行了概念模型设计,根据3范式将关系实体模型转化为数据库的关系模式并分别给出了数据库中4个关系表的属性,探讨了数据库存储实时参数以及诊断信息的流程,最后针对压路机硬件限制,对数据库实现的3个主要技术:数据库与数据源的链接技术、数据库中汉字的存储技术、数据库的安全技术进行了讨论。样机试验表明,该数据库切实可行,基本满足了压路机智能故障诊断的存储推理中间结果、提供解释信息等要求,该设计方案为开发压路机智能故障诊断系统提供了一条方便快捷的路径。
In order to meet the complicated structure and high diagnosis difficulty of rollers, the core hardware structure and architecture of the intelligent fault diagnosis system for roller are introduced. Based on this, the database subsystem of intelligent fault diagnosis system is emphatically studied. The data composition in database was analyzed in detail. The conceptual model of database was designed by using relational entity model. According to the 3-paradigm, the relational entity model was transformed into the relational model of database and the attributes of 4 relational tables in database were given respectively. Finally, aiming at the hardware limitation of roller, the paper discusses the three main technologies of the database: link technology of database and data source, storage technology of Chinese character in database, and security technology of database. The prototype test shows that this database is feasible and can basically meet the intermediate reasoning of storage reasoning for intelligent diagnosis of road rollers and provide the explanation information. The design provides a convenient and fast path for the development of road roller intelligent fault diagnosis system.