Development Of Vibration And Noise Data Management System For Urban Rail Transit

At present,urban rail transit is developing rapidly in China,but the environmental vibration brought by urban rail transit operation can not be ignored to the surrounding people,buildings and precision instruments.In order to improve these problems,we need to combine with the actual situation of China’s urban rail transit,in-depth analysis of the impact of rail transit vibration and noise factors.At present,the system software used to analyze the vibration and noise data of urban rail transit on the market has the limitations of inconsistent vibration data standards,independent storage and analysis functions,and encryption of the analysis software,which brings many troubles to the staff when analyzing and processing the vibration and noise data.Therefore,it is urgent for software developers to develop a new vibration and noise data analysis software in combination with the needs of staff,so as to solve the work troubles of staff and provide technical support and services for relevant staff.In this paper,based on the analysis of the staff needs,research has developed a set of vibration noise data storage,retrieval,data display and data management function of graphical analysis of the system software,this paper starts with the background and current situation of the development of system,analyzes the limitations of the system software on the market,understand the demand of the workers,the function of the software for the system design,then the basis of the background to the software is introduced in detail.Then main work revolves around the function of the system software,first of all,according to the requirements of the staff working environment with single sex Sqlite as the database of the system software,and understand the basic requirements and basic structure of database system,build a has the original data and the basic information storage,data management function and make the stable operation of the database.Then,on the basis of window function,the syntax and calculation method of window function are understood,and the data retrieval and queryfunction of the software system is realized.Then through the analysis of more commonly used graphics display technology,finally oxyplot graphics display technology to achieve data chart display.According to the analysis and display requirements of the staff,the original data are transformed into different analysis domains by fast Fourier transform algorithm and one-third octave algorithm for graphic display.Finally,based on the graph display and correlation analysis,this paper makes a basic analysis of the original data.In this paper,all the system interface is based on the Win Form form design,in the way of interface to achieve the entry of basic information,system function selection,system operation tips,system data graphic display.The system has been tested by the staff of Beijing Institute of Labor Protection science for many times.The system runs stably and the function of the software system meets the staff’s needs,which can solve the staff’s troubles.The main programming language of this system software is C#,and the development platform is visual studio 2019.