CN103559255A - Visual data processing method of distributed hydraulic system - Google Patents
Visual data processing method of distributed hydraulic system Download PDFInfo
- Publication number
- CN103559255A CN103559255A CN201310534678.3A CN201310534678A CN103559255A CN 103559255 A CN103559255 A CN 103559255A CN 201310534678 A CN201310534678 A CN 201310534678A CN 103559255 A CN103559255 A CN 103559255A
- Authority
- CN
- China
- Prior art keywords
- data
- time
- central server
- consumer
- query
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract 3
- 230000000007 visual effect Effects 0.000 title claims abstract 3
- 238000007405 data analysis Methods 0.000 claims abstract description 22
- 238000012800 visualization Methods 0.000 claims abstract description 10
- 238000004458 analytical method Methods 0.000 claims abstract description 8
- 238000000034 method Methods 0.000 claims abstract description 8
- 238000005070 sampling Methods 0.000 claims description 7
- 238000001228 spectrum Methods 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 230000001052 transient effect Effects 0.000 claims description 3
- 230000003595 spectral effect Effects 0.000 claims 1
- 238000012360 testing method Methods 0.000 abstract description 5
- 238000013523 data management Methods 0.000 description 5
- 238000013500 data storage Methods 0.000 description 4
- 238000002474 experimental method Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000007726 management method Methods 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 238000004220 aggregation Methods 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 238000003556 assay Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000739 chaotic effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
Images
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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明提供一种分布式液压系统的可视化数据处理方法，其包括：步骤1，将多个并行实验台通过一台中心服务器控制，每个实验台产生多路数据信号，将数据信号、数据信号的产生时间及设备型号在本地数据库中实时缓存，然后将本地数据库中储存的内容通过主/从模式上传到中心服务器的数据库中；步骤2，在可视化平台上搭建用户界面，利用该用户界面根据权限管理和查询中心服务器中的数据信号，且时间精确到秒；步骤3，在可视化平台上搭建数据分析界面，将数据分析过程放在2个生产者/消费者循环中的第2个消费者循环中，以该第2个消费者循环中创建的波形数据作为输入，查询数据的同时进行多功能数据分析，并将分析结果上传到中心服务器。
The present invention provides a visual data processing method of a distributed hydraulic system, which includes: step 1, a plurality of parallel test benches are controlled by a central server, each test bench generates multiple data signals, and the data signal, data signal The generation time and device model of the device are cached in the local database in real time, and then the content stored in the local database is uploaded to the database of the central server through the master/slave mode; step 2, build a user interface on the visualization platform, use the user interface according to Authority management and query data signals in the central server, and the time is accurate to the second; step 3, build a data analysis interface on the visualization platform, and place the data analysis process on the second consumer in the two producer/consumer loops In the loop, the waveform data created in the second consumer loop is used as input, and multifunctional data analysis is performed while querying the data, and the analysis results are uploaded to the central server.
Description
Technical field
The invention belongs to hydraulic system data management field, relate in particular to the visualized data disposal route of distributed hydraulic system.
Background technology
Hydraulic system is applied very extensive in modern production, aggregation of data management plaing a part in hydraulic system test and system debug process is very important, and data storage, inquiry and data analysis function are cores indispensable in data management system.In the face of the data recording of magnanimity, staff is difficult to macroscopical overall treatment and comprehensive analysis, cannot make full use of the value of test figure.And strong operability, applying flexible, efficient and convenient, multiple functional aggregation of data management system are more and more subject to user's favor in the industry.
Along with the function of hydraulic system is on the increase, the data volume that gathers and store increases day by day, and database server is not generally deposited at the scene, and user's inquiry and analysis data recording is very inconvenient.Excel database is mainly concentrated in the data management that at present hydraulic system aspect proposes, and adopts Office function software to manage, and the very large or user of the data volume in storage file is unfamiliar with sql like language, finds the data that will check more difficult.
The present invention comes from project < < locked cylinder digital hydraulic test total management system IMS-DHT-I > >.In realizing process of the present invention, inventor's discovery, when User working environment distance service device is far or network is slower, data storage and query speed cannot guarantee, and easily cause the loss of data; In the larger situation of sampling rate, data under the same time automatically minute many records are stored, during inquiry, will repeat the phenomenon of N time by time of occurrence, if do not filtered the repetition time, according to direct data query of the time period of customer requirements, the data recording under every same time can repeat N time, makes inquiry chaotic, affects user and sums up system moving law by data analysis; When inquiry velocity is faster than data analysis, if the data that inquire are directly carried out data analysis, easily cause data stacking, thus obliterated data; In the large situation of the time range of user inquiry, if query time, data query, data analysis can not synchronously carry out, greatly reduce work efficiency.In order to solve above bottleneck, the present invention has been proposed.
Summary of the invention
For addressing the above problem, the invention provides a kind of visualized data disposal route of distributed hydraulic system, with the efficiency that improves hydraulic system mass data storage, inquiry and analyze.
The visualized data disposal route of a kind of distributed hydraulic system of the present invention, it comprises:
Step 1, a plurality of parallel experiment tablees are controlled by a central server, each experiment table produces multichannel data signal, the real-time buffer memory in local data base by the generation time of described data-signal, described data-signal and unit type, then the content storing in described local data base is uploaded to by master/slave pattern in the database of described central server, described central server is connected with Visualization Platform;
Step 2, on described Visualization Platform, build user interface, utilize this user interface according to the data-signal in rights management and the described central server of inquiry, and the time is accurate to second, the content of described user interface comprises: querying condition, numerical value show control, numerical value progress bar, speed threshold, confirming button, stop button;
Step 3, on described Visualization Platform, build data analysis interface, data analysis process is placed in the 2nd consumer's circulation in 2 producers/consumer circulation, the Wave data that the 2nd consumer of usining creates in circulating is as input, in the time of data query, carry out multi-functional data analysis, and analysis result is uploaded to central server, the content at described data analysis interface comprises: amplitude-frequency spectrum, phase frequency spectrum, power spectrum density, signal statistics, signal time and transient response;
Further, described step 2 comprises:
Step 21, constructs 2 producers/consumer circulation, wherein the 1st consumer to circulate be also the 2nd producer's circulation simultaneously;
Step 22, in the 1st producer's circulation, input inquiry condition is also sent query time order to the database of described central server, whether judgement order is correct, incorrect fill order return to error message not, correct fill order is also returned to the time result of inquiry, by described time result through screening, delete after choosing is processed and put into time queue buffer memory;
Step 23, in the 1st consumer's circulation, using described time queue as data query with the condition of sampling rate, database to described central server sends querying command again, whether judgement order is correct, incorrect fill order return to error message not, correctly fill order return to Query Result is put into data queue's buffer memory by described Query Result after data type conversion;
Step 24, in the 2nd consumer's circulation, falls out described data queue and sampling rate create Wave data, with oscillogram and two kinds of forms of array, shows data.
Beneficial effect of the present invention is:
1. data query program of the present invention adopts 2 producers/consumer circulation, has realized the inquiry of hydraulic pressure supervisory system mass data and has synchronizeed and carry out with analysis; The speed that designed is controlled shelves, makes data analysis more flexibly, conveniently.
2. local data base of the present invention and remote center's server sync, avoided remote storage obliterated data, improved storage efficiency, and solved the problem of remote inquiry loss of data and accumulation, improved search efficiency.And data analysis function is complete, friendly interface.
Accompanying drawing explanation
Fig. 1 is the visualized data process flow schematic diagram of distributed hydraulic system of the present invention;
Fig. 2 is the data analysis schematic diagram of the visualized data disposal route of distributed hydraulic system of the present invention.
Embodiment
Distributed hydraulic system visualized data storage, inquiry and the method for designing of analyzing that the present invention proposes, comprise set up being connected between Platform for Visualization Software and database, database structure designs, this method for designing comprises the following steps:
(1) a plurality of parallel experimental systems in working site are by a central server integrated management, each experiment table produces multichannel different pieces of information signal, on Platform for Visualization Software, design program, the real-time storage such as time when data, data are produced (being accurate to second), unit type are at local data banked cache,, then upload to each database of central server by master/slave pattern;
(2) on Visualization Platform, build user interface, in whole experimental system LAN (Local Area Network), by the original experiment data of any time in rights management Help Center server, the time is accurate to second, and concrete grammar is as follows:
(2-1) querying condition being needed by users such as initial time, termination time, unit types, (Related fields of the database of these conditions and access), and numerical value shows control, numerical value progress bar, speed threshold, confirming button, the common main contents that form user's query interface such as stop button;
(2-2) construct 2 producers/consumer circulation, it is also the 2nd producer's circulation that the 1st consumer circulated simultaneously;
(2-3) in the 1st producer circulation, input inquiry condition is also sent query time order to database, and whether judgement order is correct, incorrectly returns to error message, correctly fill order returning results.The time of returning deletes the time of repetition to select then entry time queue buffer memory after screening;
(2-4) in the 1st consumer's circulation (being also the 2nd producer's circulation) simultaneously, time falls out as the condition of data query and sampling rate, again to database, send querying command, whether judgement order is correct, incorrectly return to error message, correct fill order return to Query Result, through data type conversion Hou，Ru data queue buffer memory;
(2-5), in the 2nd consumer's circulation, data and sampling rate are fallen out and are created Wave data, with oscillogram and two kinds of forms of array, show;
(3) on Visualization Platform, build data analysis interface, concrete grammar is as follows:
(3-1) by amplitude-frequency, composed phase frequency spectrum, power spectrum density, signal statistics, the main contents of the common composition data assay surface such as signal time and transient response;
(3-2) data analysis is as a separate modular, be placed in the 2nd consumer circulation, using Wave data that (2-5) create as input, in the time of data query, carry out multifunctional analysis, abnormal signal is reported to the police, user need analysis result upload to central database.
Further, LabVIEW Software Development Platform is designed program, MySQL database stores information.The regular Automatic clearance of local data base, the regular automated back-up of central server.Query time, data query are synchronizeed and are carried out with data analysis.
Certainly; the present invention also can have other various embodiments; in the situation that not deviating from spirit of the present invention and essence thereof; those of ordinary skill in the art are when making according to the present invention various corresponding changes and distortion, but these corresponding changes and distortion all should belong to the protection domain of the appended claim of the present invention.
Claims (1)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310534678.3A CN103559255B (en) | 2013-11-01 | 2013-11-01 | A kind of visualization data processing method of distributed hydraulic system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310534678.3A CN103559255B (en) | 2013-11-01 | 2013-11-01 | A kind of visualization data processing method of distributed hydraulic system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103559255A true CN103559255A (en) | 2014-02-05 |
| CN103559255B CN103559255B (en) | 2017-01-04 |
Family
ID=50013502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310534678.3A Active CN103559255B (en) | 2013-11-01 | 2013-11-01 | A kind of visualization data processing method of distributed hydraulic system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103559255B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107621368A (en) * | 2017-09-04 | 2018-01-23 | 江西洪都航空工业集团有限责任公司 | A kind of engine expert diagnostic system based on trainer aircraft |
| CN109525632A (en) * | 2018-09-30 | 2019-03-26 | 珠海派诺科技股份有限公司 | Gateway data uploads database connection digital control method, device, equipment and medium |
| CN113626187A (en) * | 2021-07-31 | 2021-11-09 | 浙江省机电产品质量检测所有限公司 | Method and device for processing measurement data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2005098655A2 (en) * | 2004-02-21 | 2005-10-20 | Datallegro, Inc. | Ultra-shared-nothing parallel database |
| CN101702179A (en) * | 2009-12-01 | 2010-05-05 | 百度在线网络技术（北京）有限公司 | Method and device for removing duplication from data mining |
| US20100257135A1 (en) * | 2006-07-25 | 2010-10-07 | Mypoints.Com Inc. | Method of Providing Multi-Source Data Pull and User Notification |
| CN202041228U (en) * | 2011-01-27 | 2011-11-16 | 华中科技大学 | A monitoring device for building energy consumption based on thermal parameter field monitoring |
-
2013
- 2013-11-01 CN CN201310534678.3A patent/CN103559255B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2005098655A2 (en) * | 2004-02-21 | 2005-10-20 | Datallegro, Inc. | Ultra-shared-nothing parallel database |
| US20100257135A1 (en) * | 2006-07-25 | 2010-10-07 | Mypoints.Com Inc. | Method of Providing Multi-Source Data Pull and User Notification |
| CN101702179A (en) * | 2009-12-01 | 2010-05-05 | 百度在线网络技术（北京）有限公司 | Method and device for removing duplication from data mining |
| CN202041228U (en) * | 2011-01-27 | 2011-11-16 | 华中科技大学 | A monitoring device for building energy consumption based on thermal parameter field monitoring |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107621368A (en) * | 2017-09-04 | 2018-01-23 | 江西洪都航空工业集团有限责任公司 | A kind of engine expert diagnostic system based on trainer aircraft |
| CN109525632A (en) * | 2018-09-30 | 2019-03-26 | 珠海派诺科技股份有限公司 | Gateway data uploads database connection digital control method, device, equipment and medium |
| CN113626187A (en) * | 2021-07-31 | 2021-11-09 | 浙江省机电产品质量检测所有限公司 | Method and device for processing measurement data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103559255B (en) | 2017-01-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105005274B (en) | Big data in management process control system | |
| CN108764610B (en) | Standard process engineering project construction management method based on big data and storage medium | |
| CN103646149A (en) | Knowledge-engineering-based automatic scheme generation and evaluation system and method | |
| CN104361022A (en) | Method based on collected data statistics and foreground display | |
| CN109683911A (en) | A kind of system for realizing automation application deployment and impact analysis | |
| CN102855332A (en) | Graphic configuration management database based on graphic database | |
| CN102739783B (en) | The method that conferencing information merges automatically | |
| CN112540975B (en) | Multi-source heterogeneous data quality detection method and system based on petri net | |
| CN106354707B (en) | A dynamic generation system for energy-saving power generation dispatch reports in provincial power grids | |
| CN106845935A (en) | A kind of method and system of engineering project flow template | |
| CN103559255A (en) | Visual data processing method of distributed hydraulic system | |
| CN110222407A (en) | A kind of fusion method and device of BIM data | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| CN112053429A (en) | Transformer substation construction management and control platform based on GIM three-dimensional design model | |
| CN108241566A (en) | A kind of data-base performance monitoring method based on configuration | |
| CN108268437A (en) | The method and device of formula manipulation | |
| CN106484591A (en) | A kind of collecting method based on distributed system and acquisition system | |
| CN108182204A (en) | The processing method and processing device of data query based on house prosperity transaction multi-dimensional data | |
| CN104537168A (en) | Integrated supervisory control simulating training system model data management method for equipment functions | |
| CN103399844A (en) | Report generation method and generation device | |
| CN110209722A (en) | A kind of data-interface for data exchange | |
| CN105574002A (en) | SQL database-data file transmission method | |
| CN104731051A (en) | Method for achieving sensor point position objectification | |
| RU2568383C2 (en) | Scenario dynamic simulation of feasibility indicators of power production structure life cycle and hardware-software complex to this end | |
| CN104391847A (en) | Hotel ordering method based on user action, cloud server and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |