Founded in 1971 >
Chinese Sci-tech Core Periodicals >
British Science Abstracts (SA, INSPEC) Indexed Journals >
United States, Cambridge Scientific Abstract: Technology (CSA: T) Indexed Journals >
United States, Ulrich's Periodicals Directory(UPD)Indexed Journals >
United States, Cambridge Scientific Abstract: Natural Science (CSA: NS) Indexed Journals >
Poland ,Index of Copernicus(IC) Indexed Journals >
International Standard Serial Number:
ISSN 1001-4551
Sponsor:
Zhejiang University;
Zhejiang Machinery and Electrical Group
Edited by:
Editorial of Journal of Mechanical & Electrical Engineering
Chief Editor:
ZHAO Qun
Vice Chief Editor:
TANG ren-zhong,
LUO Xiang-yang
Tel:
86-571-87041360,87239525
Fax:
86-571-87239571
Add:
No.9 Gaoguannong,Daxue Road,Hangzhou,China
P.C:
310009
E-mail:
meem_contribute@163.com
Abstract: With the deepening integration of new generation information technology and manufacturing industry, it was particularly important to efficiently collect and manage the operation data of key mechanical equipment. To solve the problem of how to efficiently upload the sensor data generated by the high-speed light load gearbox operation monitoring system, a method based on Python cloud storage and multithreading to optimize the upload rate was proposed. Firstly, Alibaba cloud was selected as the target server and MySQL was selected as the target database, so that the acquired data can be stored in the cloud database for users to share and view the data in real time. Then, PyCharm was used as a programming tool to retrieve the data obtained by the upper computer of the monitoring system, and the data was uploaded to the cloud database regularly by writing code. Finally, in order to determine the optimal relationship between the amount of uploaded data and the number of threads, an experiment was conducted to upload high-speed light-load gearbox operation monitoring data based on the gearbox operation monitoring system. The multi-threaded method was used to optimize the transmission rate of different data volume intervals. The experimental results show that the data can be uploaded accurately and efficiently, with an accuracy rate of 99%. In terms of optimizing the upload rate, the transmission rate can reach 0.83 M/min for the small data range. For the interval with large data volume, the maximum upload rate can reach 3.6 M/min. This method can realize accurate and efficient uploading and storage of high-speed rotating machinery operation monitoring data, and lay a data foundation for rotating machinery maintenance and fault diagnosis.
Key words: rotating machinery; equipment operation monitoring system; real time storage; multithread optimization; MySQL; upload rate