Design And Implementation Of Data Management And Fault Diagnosis System For HXD2B Locomotive

With the rapid development of economy,the demand of freight locomotives in railway transportation is ever increasing,and the analysis of running state data generated in the running process of locomotives and management and retrieval of fault diagnosis data are attracting more and more attention.In order to improve the status quo that some locomotive models in hefei locomotive depot adopt manual data analysis for fault retrieval and improve the railway informatization degree,it is imperative to develop the locomotive running status data and fault diagnosis data management system for corresponding models.This paper is based on HXD2B locomotive design,and realized locomotive data management and fault diagnosis system.Thus,centralized management and fault diagnosis are carried out for the locomotive operation data of this model.The Hefei,Wuhu and Fuyang locomotives abandoned the original manual conversion,analysis of locomotive data and fault diagnosis.It improved the informatization degree,fault diagnosis accuracy and working efficiency of the locomotive depot.The main research contents of this paper are as follows:(1)System demand analysis.It conducted research from system audience analysis,goal analysis,functional requirements,and non-functional requirements.Through the in-depth research on the data management and fault diagnosis related technologies of railway freight locomotives,the problems and expected goals in the current locomotive depot HXD2B locomotive data management and fault diagnosis process are defined.This system is divided into login and logout module,system management module,typical fault case management module,locomotive basic data management module and one-stop upload,conversion,analysis,encapsulation and fault diagnosis,and has done the demand analysis separately.At the same time,considering the performance bottlenecks and user experience that may be faced in the future,the non-functional requirements that the system needs to meet are proposed.(2)System design.On the basis of system requirement analysis,the system design has carried out.Firstly,the system architecture and technology selection are determined.Next,the design of each functional module is completed.Then the design of the main table in the system database is given.In addition,considering that the system will reach hundreds of millions of data in two years of deployment and will reach the status of one billion data in the future,two redundant tables were designed and the design scheme for horizontal sub-table according to the locomotive model was determined.At the same time,the system has designed with a variety of performance enhancements such as caching,database read and write separation,and load balancing.(3)System implementation.Firstly,XML configuration was adopted to integrate the three frameworks of Spring,SpringMVC and MyBatis,completed the construction of the system platform.After that,each functional module of the system was realized,and the implementation method of core function points of each functional module was mainly studied.Include:front-end and back-end verification of user name and password and the realization of session clearing of logout operation;add and modify operation unique value check and user manual upload function implementation;allow to upload arbitrary format file implementation;implementation of extracting key information and collating document links through python parsing;retrieval of fault information was divided into two parts for matching to improve the efficiency of fault retrieval;the implementation of filtering duplicate data by generating unique identifiers,etc.Finally,the correctness of the system was reflected by test.The HXD2B locomotive data management and fault diagnosis system that designed and developed in this project has been put into use for more than one year,and currently serves hefei,wuhu and fuyang.Through the user usage report returned by Hefei Locomotive Depot of Shanghai Railway Administration,it affirmed the role of the system.At the same time,this research also provided a reference for other types of locomotive research on this aspect.