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
- circulation
- 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
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
The invention provides a visual data processing method of a distributed hydraulic system. The visual data processing method comprises the following steps of step 1, controlling a plurality of parallel experiment tables through a central server, wherein multiple ways of data signals are generated by each experiment table, caching the data signals, the generation time of the data signals and the equipment type in a local database in a real-time manner, and then uploading the content stored in the local database to the database of the central server through a master/slave mode; step 2, constructing a user interface on a visual interface, managing and searching the data signals in the central server by utilizing the user interface according to the authority, wherein the time is accurate to the second; step 3, constructing a data analysis interface on the visual interface, putting a data analysis process in the second consumer cycle in two producer/consumer cycles so as to take waveform data constructed in the second consumer cycle as an input, carrying out multifunctional data analysis while searching data, and uploading an analysis result 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)
1. a visualized data disposal route for distributed hydraulic system, is characterized in that, comprising:
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.
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 | 华中科技大学 | Building group energy consumption monitoring device based on thermotechnical 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 | 华中科技大学 | Building group energy consumption monitoring device based on thermotechnical 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 |
|---|---|---|
| CN110007913A (en) | Visual flow chart of data processing setting method, device, equipment and storage medium | |
| CN104123369B (en) | A kind of implementation method of the configuration management Database Systems based on graphic data base | |
| CN102930062B (en) | The method of the quick horizontal extension of a kind of database | |
| CN101026633A (en) | IEC 61850 and OPC based heterogeneous power quality monitoring device integrating method and gateway | |
| CN109582695A (en) | Data general-purpose querying method and inquiry system under a kind of micro services framework | |
| CN105809314A (en) | Method and system for asset management | |
| CN103559570A (en) | Fault recording master station information management system | |
| CN106354707B (en) | A kind of provincial power network energy-saving power generation dispatching report dynamic generating system | |
| CN103746831A (en) | Alarm analysis method, device and system | |
| CN102855332A (en) | Graphic configuration management database based on graphic database | |
| CN106055590A (en) | Power grid data processing method and system based on big data and graph database | |
| CN109683911A (en) | A kind of system for realizing automation application deployment and impact analysis | |
| CN103823660A (en) | Method and system for IT (information technology) operation and maintenance configuration management | |
| CN103559255A (en) | Visual data processing method of distributed hydraulic system | |
| CN108241566A (en) | A kind of data-base performance monitoring method based on configuration | |
| CN104901998B (en) | integrated cloud service monitoring method | |
| CN106484591A (en) | A kind of collecting method based on distributed system and acquisition system | |
| WO2016168414A1 (en) | Graphical indexing for life cycle management of drilling system assets | |
| CN109962529B (en) | On-line monitoring and operation and maintenance device of electrical secondary equipment | |
| CN108182204A (en) | The processing method and processing device of data query based on house prosperity transaction multi-dimensional data | |
| CN110390027A (en) | A kind of information system fault model construction method and system based on chart database | |
| CN112035466B (en) | External index development framework for block chain query | |
| CN106302485A (en) | OPC standard and the bi-directional conversion system of power remote agreement | |
| CN111652500B (en) | Automatic on-duty auxiliary system based on scheduling | |
| El Khaouat et al. | Big data based management for smart grids |
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 |