CN106095857A - A kind of batch vibrating data analysis method - Google Patents
A kind of batch vibrating data analysis method Download PDFInfo
- Publication number
- CN106095857A CN106095857A CN201610390171.9A CN201610390171A CN106095857A CN 106095857 A CN106095857 A CN 106095857A CN 201610390171 A CN201610390171 A CN 201610390171A CN 106095857 A CN106095857 A CN 106095857A
- Authority
- CN
- China
- Prior art keywords
- data
- wave
- vibration
- waveform
- analysis method
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Measurement Of Mechanical Vibrations Or Ultrasonic Waves (AREA)
Abstract
A kind of batch vibrating data analysis method, it comprises the following steps: 1) Wave data in vibration data and other data are respectively stored into database or other arbitrary preservation forms；2) choose random time section in software or time point does not comprise the vibration data of waveform；3) add vibration data in the container that coordinate or list etc. can comprise multiple object to；4) can switch between difference with dragging or other forms；5) add required analytic function, show in the corresponding way；6) Wave data a little is chosen in inquiry when switching selected point, and sends different analytic functions to and be analyzed；7) 26 are carried out to different collection points) operation of step.
Description
Technical field
The invention belongs to status monitoring field, specifically a kind of batch vibrating data analysis method.
Background technology
CM machine performance monitors (Condition Monitoring): overall or its parts to operating plant equipment
Duty carry out checking monitoring, to judge that its operating is whether normal, have the sign with deterioration without exception, or to abnormal conditions
It is tracked, it was predicted that the trend of its deterioration, determine the degree of its deterioration and abrasion.What conventional failure analytical technology was faced asks
Topic: the excessively huge inquiry of vibration data amount slowly, batch data contrast difficulty, clearly show, no by more being difficult to of analytic function
With the Data Comparison difficulty of analytic function, the Data Comparison difficulty of same observation station different time sections, difference measures the same time
Data Comparison difficulty.
Content of the invention
In order to overcome the deficiency of said method, the present invention proposes a kind of batch vibrating data analysis method, and the method is improved
Demand data inquiry velocity, makes different analytic function data display convenient, and new point of extension on the basis of doing excessive change
Analysis function simultaneously carries out Data Comparison, and same observation station can carry out the Data Comparison of different time, and different measuring points can be entered easily
The Data Comparison of row same time, enables batch data simply to contrast clearly, and the method comprises the following steps:
1) vibration data is gathered by vibrating sensor；
2) vibration data is divided into waveform and non-waveform two classes, and Wave data is generally one group of continuous print real-coded GA,
Non-wave numeric is according to the data variable by vibration be described in addition to Wave data；
3) Wave data is respectively stored into database or other arbitrary preservation forms with non-wave numeric evidence；
4) by writing voluntarily or existing available data query software is (such as SQL Server Management
Studio) the non-waveform vibration data of random time section or time point is obtained, owing to only obtaining non-wave numeric evidence, can be significantly
Reduce the time obtaining needed for data；
5) entering line retrieval to non-waveform data acquisition system, the mode of retrieval can be such as non-waveform by arranging search condition
The holding time of data, amplitude size, if reporting to the police and obtaining data Id of compound condition, Id is the unique identifier of data, Id
Content preserve form according to different types of data can be different；
6) the Id inquiry by non-wave numeric evidence has the Wave data of identical Id, because the waveform of vibration data and non-ripple
Graphic data is synchronization storage, so the data at identical Id can ensure synchronism；
7) by writing voluntarily or existing vibration analysis method (such as time-domain analysis, frequency-domain analysis, order analysis etc.) is to shaking
Dynamic waveform and non-wave numeric evidence are analyzed showing；
8) convert the different data of search condition inquiry to be analyzed.
The advantage of the method for this patent introduction is can quickly to inquire about and to different measuring points or identical measuring point vibration data
It is analyzed contrast, simplify data query by extracting critical index, then specific targets are analysed in depth, and provide
Convenient data exchange operation.
Its advantage is as shown in the table:
| Conventional method | This patent method | |
| Single data query | Easy | Easy |
| Batch data is inquired about | Slowly | Fast |
| Single analytic function is shown | Easy | Easy |
| Multiple analytic functions are shown | Difficulty | Easy |
| Multiple analytic function Data Comparisons | Difficulty | Easy |
Brief description
Accompanying drawing 1 is the vibration data tendency chart not attaching waveform of single measuring point in reading a period of time
Accompanying drawing 2,3,4 for representing three kinds of data analysis functions, time-domain analysis, frequency-domain analysis and analysis of orbit
Accompanying drawing 5 is single measuring point data analysis and contrast
Accompanying drawing 6 is multiple measuring point data analyses and contrast
Detailed description of the invention
Below in conjunction with embodiment, the present invention is further described.
Embodiment 1
A kind of batch vibrating data analysis method, it comprises the following steps:
1) vibration data is gathered by vibrating sensor；
2) vibration data is divided into waveform and non-waveform two classes, and Wave data is generally one group of continuous print real-coded GA,
Non-wave numeric is according to the data variable by vibration be described in addition to Wave data；
3) Wave data is respectively stored into database or other arbitrary preservation forms with non-wave numeric evidence；
4) by writing voluntarily or existing available data query software is (such as SQL Server Management
Studio) the non-waveform vibration data of random time section or time point is obtained, owing to only obtaining non-wave numeric evidence, can be significantly
Reduce the time obtaining needed for data；
5) entering line retrieval to non-waveform data acquisition system, the mode of retrieval can be such as non-waveform by arranging search condition
The holding time of data, amplitude size, if reporting to the police and obtaining data Id of compound condition, Id is the unique identifier of data, Id
Content preserve form according to different types of data can be different；
6) the Id inquiry by non-wave numeric evidence has the Wave data of identical Id, because the waveform of vibration data and non-ripple
Graphic data is synchronization storage, so the data at identical Id can ensure synchronism；
7) by writing voluntarily or existing vibration analysis method (such as time-domain analysis, frequency-domain analysis, order analysis etc.) is to shaking
Dynamic waveform and non-wave numeric evidence are analyzed showing；
8) convert the different data of search condition inquiry to be analyzed.
Fig. 1 tendency chart represents the vibration data tendency chart not attaching waveform reading single measuring point in a period of time, horizontal seat
Being designated as the time, ordinate is vibration amplitude, relatively small owing to not attaching Wave data amount, has reached the effect of quick search data
Really.Tendency chart reflects overall condition by carrying out extracting section to big data, can obtain the base of big data at short notice
This information is in order to subsequent treatment.
Fig. 2,3,4 points of tables represent three kinds of data analysis functions, time-domain analysis, frequency-domain analysis and analysis of orbit.Each point
Functional diagram carries out depth profiling with displaying function to big data by providing detailed analysis, is after tendency chart briefly extracts
The details carrying out are understood.
After having loaded tendency chart, other three kinds of analytic function collection of illustrative plates do not have data, if data analysis to be carried out
Show, drag the red vernier vertical line in tendency chart, after dragging to the arbitrfary point on yellow line, start to load the ripple of current point
Graphic data, and after having loaded, it is transferred to three analytic function modules, only inquire about the waveform of a data point every time, data volume is also
It is relatively small, thus achieve the rapid comparison of the multiple different analytic functions of single measuring point.
It can be removed from container for unwanted analytic function, if it is desired to more analytic function is then by it
Join in container, convenient, flexible.Just do not show after removing orbit of shaft center that the Wave data simultaneously loading also will not in a reservoir
It is transferred to orbit of shaft center function container and provides the space of Data Comparison, facilitate the interpolation of brief introduction to improve loaded down with trivial details with removing operation
Big Data Comparison efficiency the contrast of multiple measuring point datas first can be continued to load other by same step in tendency chart
Data in measuring point a period of time, multiple analytic functions contrast for multiple measuring points, only need to drag red vernier line, now load
The Wave data of two points, and pass to analytic function module.
The foregoing is only one embodiment of the present of invention, not in order to limit the present invention.Every the present invention's
Within spirit and principle, any modification, equivalent substitution and improvement etc. made, should be included within the scope of the present invention.
Claims (2)
1. a batch vibrating data analysis method, it is characterised in that it comprises the following steps:
1) vibration data is gathered by vibrating sensor；
2) vibration data is divided into waveform and non-waveform two classes, and Wave data is generally one group of continuous print real-coded GA, non-ripple
Graphic data is the data variable of vibration be described in addition to Wave data；
3) Wave data is respectively stored into database or other arbitrary preservation forms with non-wave numeric evidence；
4) by writing voluntarily or existing available data query software obtains the non-waveform vibration of random time section or time point
Data, owing to only obtaining non-wave numeric evidence, can be greatly reduced the time obtaining needed for data；
5) entering line retrieval to non-waveform data acquisition system, the mode of retrieval can be by arranging search condition, such as non-wave numeric evidence
Holding time, amplitude size, if report to the police obtain compound condition data Id, Id is the unique identifier of data, and Id's is interior
Holding can be different according to different types of data preservation form；
6) the Id inquiry by non-wave numeric evidence has the Wave data of identical Id, because the waveform of vibration data and non-wave numeric
According to being synchronization storage, so the data at identical Id can ensure synchronism；
7) by write voluntarily or existing vibration analysis method to vibrational waveform and non-wave numeric according to being analyzed showing；
8) convert the different data of search condition inquiry to be analyzed.
2. batch vibrating data analysis method according to claim 1, it is characterised in that described data query software includes
SQL (Server Management Studio), described vibration analysis method includes time-domain analysis, frequency-domain analysis, order analysis.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610390171.9A CN106095857A (en) | 2016-06-06 | 2016-06-06 | A kind of batch vibrating data analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610390171.9A CN106095857A (en) | 2016-06-06 | 2016-06-06 | A kind of batch vibrating data analysis method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106095857A true CN106095857A (en) | 2016-11-09 |
Family
ID=57447666
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610390171.9A Pending CN106095857A (en) | 2016-06-06 | 2016-06-06 | A kind of batch vibrating data analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106095857A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112529036A (en) * | 2020-11-06 | 2021-03-19 | 上海发电设备成套设计研究院有限责任公司 | Fault early warning method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5935187A (en) * | 1996-04-10 | 1999-08-10 | Snap-On Technologies, Inc. | Engine analyzer with pattern library linked to vehicle ID and display scope configuration |
| CN101038231A (en) * | 2006-03-17 | 2007-09-19 | 中国石油天然气股份有限公司 | Gas Turbine Vibration Monitoring and Fault Diagnosis System |
| CN101709995A (en) * | 2009-12-24 | 2010-05-19 | 浙江大学 | Methods for vibration online monitoring and fault diagnosis of power transformer |
| CN104504200A (en) * | 2014-12-23 | 2015-04-08 | 华中科技大学 | Trend curve diagram display method used for online vibration monitoring of rotary mechanism |
-
2016
- 2016-06-06 CN CN201610390171.9A patent/CN106095857A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5935187A (en) * | 1996-04-10 | 1999-08-10 | Snap-On Technologies, Inc. | Engine analyzer with pattern library linked to vehicle ID and display scope configuration |
| CN101038231A (en) * | 2006-03-17 | 2007-09-19 | 中国石油天然气股份有限公司 | Gas Turbine Vibration Monitoring and Fault Diagnosis System |
| CN101709995A (en) * | 2009-12-24 | 2010-05-19 | 浙江大学 | Methods for vibration online monitoring and fault diagnosis of power transformer |
| CN104504200A (en) * | 2014-12-23 | 2015-04-08 | 华中科技大学 | Trend curve diagram display method used for online vibration monitoring of rotary mechanism |
Non-Patent Citations (1)
| Title |
|---|
| 周长斌 等: "振动趋势与频谱分析在设备维护中的应用", 《现代制造工程》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112529036A (en) * | 2020-11-06 | 2021-03-19 | 上海发电设备成套设计研究院有限责任公司 | Fault early warning method, device, equipment and storage medium |
| CN112529036B (en) * | 2020-11-06 | 2023-06-13 | 上海发电设备成套设计研究院有限责任公司 | Fault early warning method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102902752B (en) | Method and system for monitoring log | |
| CN113360554B (en) | Method and equipment for extracting, converting and loading ETL (extract transform load) data | |
| CN103607463B (en) | Location data-storage system and storage method | |
| US20160049019A1 (en) | Methods for generating multiple data reports in vehicles | |
| US9522745B2 (en) | Method and system for preparing aircraft maintenance application data for portable devices | |
| CN105224636A (en) | A kind of data access method and device | |
| CN105224534A (en) | A kind of method and device of asking response | |
| CN110210980A (en) | A kind of driving behavior appraisal procedure, device and storage medium | |
| CN110968380A (en) | Data visualization method and system | |
| CN115862177A (en) | Equipment inspection method and device | |
| CN202956182U (en) | Device vibration state diagnosis remote support system | |
| CN114760289B (en) | Vehicle data acquisition method, device, computer equipment and storage medium | |
| CN105488571A (en) | Maintenance reminding method | |
| CN110611715A (en) | System and method for collecting cloud monitoring information by service link | |
| CN106095857A (en) | A kind of batch vibrating data analysis method | |
| CN102201922A (en) | Data charging method and relevant apparatus | |
| CN111343269B (en) | Data downloading method, device, computer equipment and storage medium | |
| CN105743952A (en) | Business processing method, server and ERP client | |
| CN115880116A (en) | Task scheduling method, system, readable storage medium and computer equipment | |
| CN105868402A (en) | Aircraft maintenance quality analysis oriented QAR (quick access recorder) data preprocessing method and device | |
| CN112406748B (en) | Vehicle data acquisition method and device and vehicle diagnosis system | |
| CN207611243U (en) | Engineering equipment monitoring device | |
| CN105843724A (en) | Monitoring state index compression analysis method of IT (Information Technology) system | |
| CN106570193A (en) | Time series big data loading method | |
| CN104951467A (en) | Statistical method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161109 |
|
| RJ01 | Rejection of invention patent application after publication |