Research and Development of Large Vertical Mill Monitoring Database Management System
Wenliao DU,Lijun LI,Chunhua QIAN,Ansheng LI,Luming ZHANG
DOI: https://doi.org/10.13952/j.cnki.jofmdr.2017.0211
2017-01-01
Abstract:The large-scale vertical mill is one of key large-scale mechanical equipment for slag and cinder.The condition monitoring and fault diagnosis system is an important guarantee for the safe operation of the equipment.However,vertical mill equipment system is complex and its state-related intrinsic data is large.The systems and structures of the vertical mill are complex,and the number of the intrinsic characters relating to the conditions is very large,and these characters have complex interrelationships.Especially,the vertical mill configures a large number of sensors.the establishment of support status monitoring and fault diagnosis of highly efficient and stable data management system is very important.In this paper,the functional model and E-R model of the whole system are established from the requirements analysis of the data flow,information flow and condition monitoring process in the data management of the vertical mill monitoring and fault diagnosis system.The large-scale vertical mill intrinsic database and expert knowledge base,the equipment and the user information base,and the historical database design are realized;In view of the massive data inquiry efficiency low question,according to the signal gathering time and the visit frequency,the technologies to the historical data,such as the hierarchical caching mechanism,minute table partition,the index optimization,the stored procedure and the paging display,are adopted.Based on the C # language and SQL server database,a large-scale vertical mill status monitoring and fault diagnosis database management system is developed.Finally,an example shows that the system realizes the management of large-scale vertical mill industry data,improves the utilization rate of relevant data resources and the query efficiency of data,and provides efficient and stable data support for large-scale vertical mill status monitoring and fault diagnosis.