【作者】 曾岳；

【导师】 严新平；

【作者基本信息】 武汉理工大学 ， 载运工具运用工程， 2004， 硕士

【摘要】 油液监测技术是近来工业界采用的监测与诊断技术之一。油液监测的方法很多，如：光谱油料分析法、红外光谱分析法、颗粒计数法、油品理化分析法等。通过这些方法所获得的数据能够从一方面或多方面反映油品的性能和磨粒的特性，从而得到机器故障信息。一个油样完成一次完整的油液分析，所获得的数据量是很大的，数据种类是很多的，科技工作者很难从这些纷繁芜杂的数据中获得有用的信息，这已成为油液监测技术发展的一个瓶颈问题。另一方面，现在的油液监测数据管理系统很多，而这些系统都是基于手工方式获得数据，从而给科研工作者增加了劳动量，有时也会带来一定的误差。 本文以上述为研究目的，以武汉理工大学可靠性工程研究所油液监测中心为工作平台，利用当前先进的计算机技术、网络技术、数据库技术和动态网页技术，探讨了基于网络化的油液监测实验室的自动化改造方案。研究了多种油液监测数据采集方法，重点探讨了基于RS-232C串口协议的全自动数据采集方法、文本文件的半自动采集方法、局域网的图像采集方法和远程数据采集方法；利用数据流技术开发了图像的采集与传输系统；针对不同类型的监测实验设备和数据采集接口的特点，编写了相应的数据采集、转换和传输程序，以解决数据用手工输入进库的问题；利用SQL SERVER数据库服务器建立了油液监测中央数据库，开发了基于C／S模式油液监测数据库管理软件，对油液监测实验数据、监测设备基本情况以及油品分析标准等进行有效地管理；利用当前先进的B／S模式数据库管理技术，开发了基本B／S模式的电子磨粒图谱，用户可以在线查询并根据不同的设置权限对图像资源进行相应的更新和修改。在此基础上，建立以数据库服务器为数据维护工具的监测计算机软硬网络。经试验，该方法为油液监测实验室自动化改造探索了一个可行的途径。更多还原

【Abstract】 Oil monitoring is one of monitoring and diagnosis technology used widely in industry. There are several kinds of oil monitoring, for example: Infrared spectrum analysis, oil spectrum analysis, contamination analysis, oil physical chemistry analysis and so on. The acquired data by the above methods can reflect oil performance and characteristic of particles, and be further analyzed to the faults in a monitoring machine. The data from all oil sample analysis tests is numerous and data type is also different. It is very difficult for the person to extract useful data from these so much data. This becomes main problem for the development of oil monitoring. On the other hand, the oil monitoring data management systems are all based on inputting data into the base by hand.The oil monitoring center of Wuhan university of Technology is selected as the research platform. This research uses the advanced technology such as compute, network, active server page to study the software of automatic oil monitoring lab. Many oil monitoring collection ways are studied, and the way of the automobile data collection based on RS-232C protocol, of the text file collection, of the binary data collection, and of the data remote collection are studied carefully. The data stream technology is used to develop a image data collection and transfer system. The data collection, conversion and transfer program corresponding to output device and interface is worked out to let data from oil monitoring device input into the remote database; The oil monitoring database based on SQL Server is finished; The oil monitoring database management system based on Client/Server(C/S) is work out to manage the oil monitoring data, device and oil sample standard; The advanced Browse/Server (B/S) database management technology is used to developed image of wear particle management system. The network user can browse, modify, update and edit the image of wear particle. This manage system has user’s limitation powerin order to prevent user from transcending the limitation power to manage the picture system. In a conclusion, this paper has explored ways to automate the oil-monitoring lab.更多还原