多参量状态监测与故障诊断系统数据库技术研究

Technical study on the database of multiparameter state monitor and fault diagnosis system

针对大型往复式压缩机状态监测与故障诊断系统的数据信息特点,通过WinCC组态数据库、Microsoft Access数据库、文件系统管理数据三种数据管理方法对系统的适应性的研究,最终选择文件系统管理数据,同时采用内存对齐规则设计规划了系统数据的存放格式,从而建立一个实时性高、数据量大的数据库来满足工业现场需要。

Based on the data characteristics of large state inspecting and fault diagnosis system, comparing the applicability of WinCC configuration database, Microsoft Access database and file system in managing date to this system, file system was chosen to manage data and memory alignment was adopted to design storing format. Practical application shows that this method can build up a high real-time and large database so as to meet the needs of industrial spots.