CN103559255B - A kind of visualization data processing method of distributed hydraulic system - Google Patents
A kind of visualization data processing method of distributed hydraulic system Download PDFInfo
- Publication number
- CN103559255B CN103559255B CN201310534678.3A CN201310534678A CN103559255B CN 103559255 B CN103559255 B CN 103559255B CN 201310534678 A CN201310534678 A CN 201310534678A CN 103559255 B CN103559255 B CN 103559255B
- Authority
- CN
- China
- Prior art keywords
- data
- circulation
- consumer
- time
- central server
- 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.)
- Active
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/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
The present invention provides the visualization data processing method of a kind of distributed hydraulic system, comprising: step 1, multiple parallel laboratory tables are controlled by a central server, each laboratory table produces multichannel data signal, data signal, the generation time of data signal and unit type are cached the most in real time, then the content stored in local data base is uploaded to by master/slave pattern in the data base of central server；Step 2, builds user interface on Visualization Platform, utilizes this user interface according to the data signal in rights management and Help Center's server, and the time is accurate to the second；Step 3, Visualization Platform is built data analysis interface, data analysis process is placed in the 2nd consumer's circulation in 2 Producers/consumer's circulation, the Wave data created in the 2nd consumer's circulation is as input, carry out multi-functional data analysis while inquiry data, and analysis result is uploaded to central server.
Description
Technical field
The invention belongs to hydraulic system data management field, particularly relate to the visualization number of distributed hydraulic system
According to processing method.
Background technology
Hydraulic system is applied widely in modern production, aggregation of data management hydraulic system test and
Play very important effect during system debug, and data storage, inquiry and data analysis function are several
According to core indispensable in management system.In the face of the data record of magnanimity, staff is difficult to macroscopic view
Integrated treatment and comprehensive analyze, it is impossible to make full use of the value of test data.And strong operability, application spirit
Alive, efficient and convenient, multiple functional data comprehensive management system is increasingly favored by industrial customers.
Along with the function of hydraulic system is on the increase, the data volume gathering and storing increases day by day, and data base
Server is typically deposited the most at the scene, and user's inquiry and analytical data record very inconvenient.Hydraulic pressure at present
Excel data base is mainly concentrated in the data management that system aspects proposes, and uses Office operation software to manage
Reason, the data volume in storage file is very big or user is unfamiliar with sql like language, then find data to be checked
Relatively 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 finds, User working environment distance service device is farther out or network is slower
Time, data storage and query speed cannot ensure, and easily causes the loss of data；Sample rate is bigger
In the case of, the data under the same time can divide a plurality of record to store automatically, arises that the time during inquiry
Repeating the phenomenon of n times, if do not filtered the repetition time, the time period required according to user directly inquires about data,
Then the data record under every identical time can repeat n times so that inquiry confusion, affects user and passes through
Data analysis sums up system moving law；When inquiry velocity is faster than data analysis, if the data inquired are straight
Tap into row data analysis and then easily cause data stacking, thus lose data；The time range of user's inquiry is big
In the case of, if query time, inquiry data, data analysis can not synchronize to carry out, then it is substantially reduced work
Make efficiency.In order to solve above bottleneck, it is proposed that the present invention.
Summary of the invention
For solving the problems referred to above, the present invention provides the visualization data processing method of a kind of distributed hydraulic system,
With the efficiency improving hydraulic system mass data storage, inquire about and analyze.
A kind of visualization data processing method of the distributed hydraulic system of the present invention, comprising:
Multiple parallel laboratory tables are controlled by step 1 by a central server, and each laboratory table produces multichannel
Data signal, by described data signal, the generation time of described data signal and unit type at local data
Storehouse caches in real time, then the content stored in described local data base is uploaded to by master/slave pattern described
In the data base of central server, described central server is connected with Visualization Platform；
Step 2, builds user interface on described Visualization Platform, utilizes this user interface according to rights management
With the data signal inquired about in described central server, and the time be accurate to second, the content of described user interface
Including: querying condition, numerical value display control, numerical value progress bar, speed threshold, confirming button, stop button；
Step 3, builds data analysis interface on described Visualization Platform, and data analysis process is placed on 2
In the 2nd consumer's circulation in Producer/consumer's circulation, with what the 2nd consumer's circulation created
Wave data, as input, carries out multi-functional data analysis while inquiry data, and analysis result is uploaded
To central server, the content at described data analysis interface includes: amplitude-frequency spectrum, phase frequency spectrum, power spectral density,
Signal statistics, signal time and transient response；
Further, described step 2 includes:
Step 21, constructs the circulation of 2 Producers/consumer, and wherein the 1st consumer's circulation is also the simultaneously
2 Producer circulations；
Step 22, in the 1st Producer circulation, input inquiry condition the number to described central server
Send query time order according to storehouse, it is judged that order is the most correct, incorrect, do not perform order and return mistake letter
Breath, the most then perform order and return the time result of inquiry, by described time result through screening, deleting at choosing
Time queue caching is put into after reason；
Step 23, in the 1st consumer's circulation, using described time queue as inquiry data and sample rate
Condition, the data base to described central server sends querying command again, it is judged that whether order correct, no
Correct then do not perform order and return error message, the most then perform order and return Query Result, by described
Query Result puts into data queue's caching after data type conversion；
Step 24, in the 2nd consumer's circulation, falls out described data queue and sample rate and creates ripple
Graphic data, with oscillogram and two kinds of form video datas of array.
The beneficial effects of the present invention is:
1. the data query program of the present invention uses 2 Producers/consumer's circulation, it is achieved that hydraulic pressure monitoring is
System mass data inquiry is synchronization carried out with analysis；Devise speed controlling shelves, make data analysis more flexibly,
Convenient.
2. the local data base of the present invention and remote center's server sync, it is to avoid long-range memory loss data,
Improve storage efficiency, and solve the problem of remote inquiry loss of data and accumulation, improve search efficiency.
And data analysis function is complete, friendly interface.
Accompanying drawing explanation
Fig. 1 is the visualization data processing method schematic flow sheet of the distributed hydraulic system of the present invention；
Fig. 2 is the data analysis schematic diagram of the visualization data processing method of the distributed hydraulic system of the present invention.
Detailed description of the invention
The method for designing that the distributed hydraulic system visualization data that the present invention proposes store, inquire about and analyze,
Including the connection set up between Platform for Visualization Software and data base, database structure design, this design
Method comprises the following steps:
(1) the multiple parallel experimental system in working site is by a central server integrated management, each laboratory table
Produce multichannel different pieces of information signal, Platform for Visualization Software designs program, data, data are produced
The real-time storage such as time (being accurate to the second) time raw, unit type at local data banked cache, then pass through
Master/slave pattern uploads to each data base of central server；
(2) on Visualization Platform, build user interface, in whole experimental system LAN, pass through rights management
The original experiment data of any time in Help Center's server, the time is accurate to the second, and concrete grammar is as follows:
(2-1) by initial time, the querying condition that the user such as time, unit type needs, (these are terminated
Condition is corresponding with the field of the data base of access), and numerical value display control, numerical value progress bar, speed threshold,
Confirming button, stop button etc. collectively forms the main contents of user's query interface；
(2-2) constructing 2 Producers/consumer's circulation, the 1st consumer's circulation is also the 2nd life simultaneously
Product person is circulated；
(2-3) in the 1st Producer circulation, input inquiry condition also sends query time life to data base
Order, it is judged that order is the most correct, incorrect return error message, the most then perform order and return result.Return
The time of repetition is deleted choosing after screening and caches subsequently into time queue by the time returned；
(2-4) in (being also the 2nd Producer circulation) is circulated simultaneously in the 1st consumer, the time falls out
As inquiry data and the condition of sample rate, again send querying command to data base, it is judged that order is the most just
Really, incorrect return error message, the most then perform order and return Query Result, through data type conversion
After, enter data queue's caching；
(2-5), in the 2nd consumer's circulation, data and sample rate are fallen out and create Wave data, with waveform
Figure and two kinds of forms of array show；
(3) building data analysis interface on Visualization Platform, concrete grammar is as follows:
(3-1) composed by amplitude-frequency, phase frequency spectrum, power spectral density, signal statistics, signal time and transient response
Etc. the main contents collectively forming data analysis interface；
(3-2) data analysis is as a separate modular, is placed in the 2nd consumer's circulation, with (2-5)
The Wave data created, as input, carries out multifunctional analysis while inquiry data, and abnormal signal is reported to the police,
What user needed analysis result uploads to central database.
Further, LabVIEW Software Development Platform design program, MySQL database storage information.
Local data base is cleared up the most automatically, the regular automated back-up of central server.Query time, inquiry data with
Data analysis synchronizes to carry out.
Certainly, the present invention also can have other various embodiments, without departing substantially from present invention spirit and the feelings of essence thereof
Under condition, those of ordinary skill in the art work as can make various corresponding change and deformation according to the present invention, but
These change accordingly and deform the protection domain that all should belong to appended claims of the invention.
Claims (1)
1. the visualization data processing method of a distributed hydraulic system, it is characterised in that including:
Multiple parallel laboratory tables are controlled by step 1 by a central server, and each laboratory table produces multichannel
Data signal, by described data signal, the generation time of described data signal and unit type at local data
Storehouse caches in real time, then the content stored in described local data base is uploaded to by master/slave pattern described
In the data base of central server, described central server is connected with Visualization Platform；
Step 2, builds user interface on described Visualization Platform, utilizes this user interface according to rights management
With the data signal inquired about in described central server, and the time be accurate to second, the content of described user interface
Including: querying condition, numerical value display control, numerical value progress bar, speed threshold, confirming button, stop button；
Step 3, builds data analysis interface on described Visualization Platform, and data analysis process is placed on 2
In the 2nd consumer's circulation in Producer/consumer's circulation, with what the 2nd consumer's circulation created
Wave data, as input, carries out multi-functional data analysis while inquiry data, and analysis result is uploaded
To central server, the content at described data analysis interface includes: amplitude-frequency spectrum, phase frequency spectrum, power spectral density,
Signal statistics, signal time and transient response；
Further, described step 2 includes:
Step 21, constructs the circulation of 2 Producers/consumer, and wherein the 1st consumer's circulation is also the simultaneously
2 Producer circulations；
Step 22, in the 1st Producer circulation, input inquiry condition the number to described central server
Send query time order according to storehouse, it is judged that order is the most correct, incorrect, do not perform order and return mistake letter
Breath, the most then perform order and return the time result of inquiry, by described time result through screening, deleting at choosing
Time queue caching is put into after reason；
Step 23, in the 1st consumer's circulation, using described time queue as inquiry data and sample rate
Condition, the data base to described central server sends querying command again, it is judged that whether order correct, no
Correct then do not perform order and return error message, the most then perform order and return Query Result, by described
Query Result puts into data queue's caching after data type conversion；
Step 24, in the 2nd consumer's circulation, falls out described data queue and sample rate and creates ripple
Graphic data, with oscillogram and two kinds of form video datas of array.
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 CN103559255A (en) | 2014-02-05 |
| CN103559255B true 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) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107621368B (en) * | 2017-09-04 | 2020-04-28 | 江西洪都航空工业集团有限责任公司 | Engine expert diagnostic system based on trainer |
| 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 (3)
| 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 |
| CN202041228U (en) * | 2011-01-27 | 2011-11-16 | 华中科技大学 | Building group energy consumption monitoring device based on thermotechnical parameter field monitoring |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100257135A1 (en) * | 2006-07-25 | 2010-10-07 | Mypoints.Com Inc. | Method of Providing Multi-Source Data Pull and User Notification |
-
2013
- 2013-11-01 CN CN201310534678.3A patent/CN103559255B/en active Active
Patent Citations (3)
| 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 |
| CN202041228U (en) * | 2011-01-27 | 2011-11-16 | 华中科技大学 | Building group energy consumption monitoring device based on thermotechnical parameter field monitoring |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103559255A (en) | 2014-02-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110007913A (en) | Visual flow chart of data processing setting method, device, equipment and storage medium | |
| CN105069690B (en) | A kind of grid operation data processing method | |
| CN104036375B (en) | Storage data based on the goods and materials dynamic tracking of bar code processes system and method | |
| CN101354758B (en) | System and method for integrating real-time data and relationship data | |
| CN109710678B (en) | Real-time data system for industrial big data monitoring management and operation method | |
| JP6901243B2 (en) | Systems and methods for optimizing control systems for process environments | |
| CN102023983B (en) | Managing method of statistical space-time database | |
| CN101556666A (en) | Method, device and auditing system for establishing auditing model | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN102708180A (en) | Data mining method in unit operation mode based on real-time historical library | |
| CN106354707B (en) | A kind of provincial power network energy-saving power generation dispatching report dynamic generating system | |
| CN104850635B (en) | Shortage of data automaticly inspects and centralized monitoring method under a kind of multi-data source environment | |
| CN108108459A (en) | Multi-source fusion and the associated dynamic data cleaning method of loop and electronic equipment | |
| CN106325162B (en) | A kind of embedded intelligence electromechanical device state monitoring system | |
| CN103559255B (en) | A kind of visualization data processing method of distributed hydraulic system | |
| CN107480244A (en) | A kind of industrial data collects and processing system and its processing method | |
| CN102855332A (en) | Graphic configuration management database based on graphic database | |
| US11035217B2 (en) | Graphical indexing for life cycle management of drilling system assets | |
| CN107832876A (en) | Subregion peak load Forecasting Methodology based on MapReduce frameworks | |
| CN106055590A (en) | Power grid data processing method and system based on big data and graph database | |
| CN107609794A (en) | A kind of technology maturity evaluation information processing unit | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| CN108415355A (en) | A kind of efficient identification system of big data | |
| EP2990895B1 (en) | Industrial monitoring system | |
| CN103258047A (en) | Data organization method of data warehouse for controlling operation cost of medicine enterprise |
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 |