CN104636352B - SCADA system historical data complement and query processing method based on quality stamp - Google Patents
SCADA system historical data complement and query processing method based on quality stamp Download PDFInfo
- Publication number
- CN104636352B CN104636352B CN201310552244.6A CN201310552244A CN104636352B CN 104636352 B CN104636352 B CN 104636352B CN 201310552244 A CN201310552244 A CN 201310552244A CN 104636352 B CN104636352 B CN 104636352B
- Authority
- CN
- China
- Prior art keywords
- data
- quality
- communication
- backfill
- stamp
- 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
- 230000000295 complement effect Effects 0.000 title claims abstract description 25
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000004891 communication Methods 0.000 claims abstract description 97
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000011084 recovery Methods 0.000 claims description 22
- 238000000034 method Methods 0.000 claims description 7
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 241001269238 Data Species 0.000 claims description 5
- 230000006835 compression Effects 0.000 claims description 4
- 238000007906 compression Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000013500 data storage Methods 0.000 claims description 3
- 238000005259 measurement Methods 0.000 claims description 3
- 230000001105 regulatory effect Effects 0.000 claims description 3
- 230000011664 signaling Effects 0.000 claims description 3
- 241000208340 Araliaceae Species 0.000 claims 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims 1
- 235000003140 Panax quinquefolius Nutrition 0.000 claims 1
- 235000008434 ginseng Nutrition 0.000 claims 1
- 238000007689 inspection Methods 0.000 claims 1
- 238000012544 monitoring process Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 10
- 238000004364 calculation method Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000007812 deficiency Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Maintenance And Management Of Digital Transmission (AREA)
Abstract
A quality stamp-based SCADA system historical data complement and query processing method belongs to the technical field of computers. The quality stamp domain of data in the SCADA system is used for identifying the communication interruption state of the system, the server side of the SCADA system calls interruption missing data from historical data stored in the front-end communication equipment according to interruption time, the quality stamp-based historical data complement processing is realized, and when the client side inquires the historical data, the historical data is subjected to interpolation processing based on the quality stamp and is returned to the client side, so that the processing result can correctly reflect the data value and state in the communication interruption time, and real and accurate data are provided for the monitoring of the SCADA system.
Description
Technical field
The present invention relates to a kind of SCADA system historical data complement and inquiry processing method based on quality stamp, belong to meter
Calculation machine technical field.
Background technology
SCADA (Supervisory Control And Data Acquisition) system, i.e. data acquisition and monitoring
Control system.The present invention is applied in SCADA system, is to be directed to the failure such as network, server in SCADA system to cause data to lack
Mistake problem, a kind of of proposition are stabbed the processing method for carrying out historical data complement and inquiry based on the quality of data, go through SCADA system
History data complement turns into feasible program with inquiry, further solves data integrity and continuity caused by communicating interrupt and asks
Topic.
SCADA system occurs and preposition communication equipment（Preposition communication gate）The situation of interruption, the data of Interruption period between The following article
Do not recorded in SCADA software systems, the result inquired about based on this imperfection data can not reflect that data are true
Real situation of change and the quality of data state, potential safety hazard is brought to normal production run.Such as certain collection measuring point communication is normal
In the case of data variation as shown in figure 1, data point v1~v16 SCADA server ends be compressed storage processing；[t1,
T2] period occur communication disruption, the shortage of data in the period, data variation as shown in Fig. 2 data point v1~v5 and
V15~v16 is compressed storage processing in SCADA server ends；When client carries out the inquiry of historical data request, SCADA
The common processing method of server end is usually to ignore the missing data of t1~t2 periods, enters row interpolation according to compression algorithm and obtains
To numerical value c1 and numerical value c2, the result after difference is returned into client, the Query Result of client is as shown in figure 3, can by Fig. 3
See the simple numerical value and quality shape that can not reflect measuring point using interpolation method processing in the case where characteristic point data lacks
The real change situation of state.
The content of the invention
For overcome the deficiencies in the prior art, the present invention provides a kind of SCADA system historical data based on quality stamp and mended
Number and inquiry processing method.
A kind of SCADA system historical data complement and inquiry processing method based on quality stamp, contain following steps：
Utilize the state of the quality stamp domain identifier system communication disruption of data in SCADA system, SCADA system server end
Missing data is interrupted in calling in the historical data stored according to the break period from preposition communication equipment, realizes going through based on quality stamp
The processing of history data complement, and when client carries out the inquiry of historical data, historical data is based on quality stamp and carries out interpolation processing
And client is returned to, enable data value and state that the result of processing correctly reflects in communication interruption time, be SCADA systems
System monitoring provides true, accurate data.
Preposition communication equipment realize data converge adopt, basic function, the preposition communication such as communication Protocol Conversion and data forwarding are set
It is standby（Typically use preposition communication gate）Nearest a period of time historical data is locally stored, database, text can be used
The modes such as part store；Historical data backfill complement is carried out after communication recovery, SCADA system establishes the link with preposition communication equipment
And data backfill request is sent, communication equipment gives data response；SCADA system is handled the data of backfill, including is accused
Police, logout etc., but without real-time release, and only deposit historical data base；SCADA system to backfill data use with it is real-time
Data identical data storage method, but the quality for backfilling data stabbed and stamp " backfill " mark, for marking the data
It is to be obtained using back-filling way.
Specific steps：
1）SCADA system quality stabs planning step
The business datums such as remote measurement, remote signalling, remote control, remote regulating are used uniformly VQT data by SCADA system（Value（Value）, matter
Amount stamp（Quality）And timestamp（Timestamp）Three domains）It is indicated, historical data base is by data point in time series
On all VQT data instances set carry out archival compression storage；
" quality stamp " domain of VQT data includes several partial informations such as the quality of data, data category；
Quality of data part have recorded the quality state of " value " of VQT data；The quality of data can be divided into three classes：" good " matter
Amount, " bad " quality, " uncertain " quality；The quality of " value " that " good " quality indicates VQT data is good, can be used；
" value " that " bad " quality indicates VQT data for some reason is unavailable；Again can be by " bad " quality according to the reason for different
It is subdivided into：Without special reason, configuration error, data source be not connected, equipment failure, sensor failure, communication disruption, gathers termination
Deng；The quality that " uncertain " quality indicates " value " of VQT data for some reason is uncertain；
Data category part have recorded the classification of VQT data；Need the data recorded in " quality stamp " domain of VQT data
Classification includes：Normal acquisition data, backfill complement data, manual logging data, calculating data, intermediate data etc..
2）Communication disruption quality identification step
During generation communication disruption, SCADA service ends detect communication disruption, then increase by one at the moment and represent in communication
The bad point of disconnected state, the value of the point be the numerical value of last moment record, timestamp to detect at the time of disconnection, quality stamp be
" network interruption "；Equally, during communication recovery, SCADA server ends detect communication recovery, then increase a representative at the moment
The bad point of communication recovery state, the value of the point be the numerical value of last moment record, timestamp to detect communication recovery at the time of,
Quality stamp is " network recovery "；As shown in figure 5, t1 is communication disruption start time, increase " bad point " b1 at t1；T2 is interruption
Recover the moment, increase " bad point " b2 at t2.
3）Backfill quality of data identification of steps
T1' is the previous better timestamp of communication disruption, and t2' is the better timestamp of communication recovery the latter, [t1',
T2'] then as starting of the SCADA server ends to preposition communication device requests backfill complement and end time section；Communicate extensive
After multiple, SCADA server ends are to the data at preposition communication device requests [t1', t2'] moment, and preposition communication equipment is by all times
Number completion sends and is stored on SCADA servers according to " backfill " quality stamp, backfill data are stamped.As shown in Figure 6.
4）Query processing step based on quality stamp
Client sends the inquiry of historical data request to SCADA servers, is looked into for the historical data containing backfill data
Request is ask, it is as follows using the interpolation inquiry processing method stabbed based on quality, step：
For containing mark communication disruption bad point section be abnormal section, as [t1', the t1] in Fig. 7 and [t1,
T1 ' '], abnormal section is without history interpolation calculation；Historical data between v1 and v5 is passed through interpolation algorithm meter by server end
Calculation obtains Part I return value, and part mass stamp is " better "；Using b1 points as Part II return value；By v5' with
Part III return value is calculated by interpolation algorithm in all backfill historical datas between v15', and part mass stamp is
" backfill "；Using b2 as Part IV return value；Historical data between v15 and v16 is calculated by interpolation algorithm
Five part return values, finally return to client using this five part as a whole result.
5）Step display based on quality stamp
Client is based on having two ways during quality stamp display data, and one kind is that " bad point " participates in display, and second is bad
Point is not involved in showing.
The first step display：Client to the data of historical query carry out draw curve or statistics calculate when often for
Bad point in the non-caching period is not involved in line and draws or calculate, as having two matter of b1, b2 respectively in t1 and t2 moment in Fig. 7
Amount stamp for " bad point " state point, then the curve of client displaying can occur two vacuum disconnection bands at t1, t2, interpolation when
Between the big then disconnection band of granularity it is wider, the small then disconnection band of time granularity of interpolation is narrow.As shown in Figure 8.
Original state mark data and backfill data two kinds of version data be present for historical data backfill data, it is aobvious in inquiry
The first display mode can show gap because of the presence of former bad quality stamp data at backfill data both ends when showing, so data show
Show and another way is also provided.
Second of step display, the bad quality point b1 and b2 of the representative communication equipment disconnection of non-caching period is weeded out,
Client can not consider the state mark that communication equipment interrupts when carrying out to the data of historical query and draw curve or statistics calculating
Note, the curve of client displaying are as shown in Figure 9.
The effect of invention uses the historical data complement based on quality stamp to break with inquiry processing method in communication equipment
The situation of change of real reflection communication equipment connection status and data in the case of even, the monitoring of accurate instruction SCADA system with
Dispatcher keeps the safety in production.
Brief description of the drawings
When considered in conjunction with the accompanying drawings, by referring to following detailed description, can more completely more fully understand the present invention with
And easily learn many of which with the advantages of, but accompanying drawing described herein be used for a further understanding of the present invention is provided,
The part of the present invention is formed, schematic description and description of the invention is used to explain the present invention, do not formed to this hair
Bright improper restriction, wherein：
Fig. 1 measuring point data situation of change schematic diagrames;
Fig. 2 measuring point communication disruption data situation schematic diagrames;
Query processing schematic diagram of Fig. 3 measuring points in the case of shortage of data;
Fig. 4 SCADA system general frame schematic diagrames;
Fig. 5 communication disruption quality identification schematic diagrames;
Fig. 6 historical datas complement backfills schematic diagram;
Fig. 7 historical query data processing method schematic diagrames;
Fig. 8 carries the history curve schematic diagram of disconnection mark;
Fig. 9 does not consider the history curve schematic diagram of disconnection mark;
The present invention is further described with reference to the accompanying drawings and examples.
Embodiment
Obviously, those skilled in the art belong to the guarantor of the present invention based on many modifications and variations that spirit of the invention is done
Protect scope.
Embodiment 1：As shown in Figure 1, Figure 2, shown in Fig. 3, Fig. 4, Fig. 5, Fig. 6, Fig. 7, Fig. 8, Fig. 9, it is a kind of based on quality stamp
SCADA system historical data complement and inquiry processing method.
Utilize the state of the quality stamp domain identifier system communication disruption of data in SCADA system, SCADA system server end
Missing data is interrupted in calling in the historical data stored according to the break period from preposition communication equipment, realizes going through based on quality stamp
The processing of history data complement, and when client carries out the inquiry of historical data, historical data is based on quality stamp and carries out interpolation processing
And client is returned to, enable data value and state that the result of processing correctly reflects in communication interruption time, be SCADA systems
System monitoring provides true, accurate data.
SCADA system general frame schematic diagram is as shown in Figure 4.
Preposition communication equipment realize data converge adopt, basic function, the preposition communication such as communication Protocol Conversion and data forwarding are set
It is standby（Typically use preposition communication gate）Nearest a period of time historical data is locally stored, database, text can be used
The modes such as part store.Historical data backfill complement is carried out after communication recovery, SCADA system establishes the link with preposition communication equipment
And data backfill request is sent, communication equipment gives data response.SCADA system is handled the data of backfill, including is accused
Police, logout etc., but without real-time release, and only deposit historical data base.SCADA system to backfill data use with it is real-time
Data identical data storage method, but the quality for backfilling data stabbed and stamp " backfill " mark, for marking the data
It is to be obtained using back-filling way.
Invention specific steps：
The stamp planning of SCADA system quality：
The business datums such as remote measurement, remote signalling, remote control, remote regulating are used uniformly VQT data by SCADA system（Value（Value）, matter
Amount stamp（Quality）And timestamp（Timestamp）Three domains）It is indicated, historical data base is by data point in time series
On all VQT data instances set carry out archival compression storage.
" quality stamp " domain of VQT data includes several partial informations such as the quality of data, data category.
Quality of data part have recorded the quality state of " value " of VQT data.The quality of data can be divided into three classes：" good " matter
Amount, " bad " quality, " uncertain " quality.The quality of " value " that " good " quality indicates VQT data is good, can be used；
" value " that " bad " quality indicates VQT data for some reason is unavailable.Again can be by " bad " quality according to the reason for different
It is subdivided into：Without special reason, configuration error, data source be not connected, equipment failure, sensor failure, communication disruption, gathers termination
Deng.The quality that " uncertain " quality indicates " value " of VQT data for some reason is uncertain.
Data category part have recorded the classification of VQT data.Need the data recorded in " quality stamp " domain of VQT data
Classification includes：Normal acquisition data, backfill complement data, manual logging data, calculating data, intermediate data etc..
Communication disruption quality identification method：
During generation communication disruption, SCADA service ends detect communication disruption, then increase by one at the moment and represent in communication
The bad point of disconnected state, the value of the point be the numerical value of last moment record, timestamp to detect at the time of disconnection, quality stamp be
" network interruption ".Equally, during communication recovery, SCADA server ends detect communication recovery, then increase a representative at the moment
The bad point of communication recovery state, the value of the point be the numerical value of last moment record, timestamp to detect communication recovery at the time of,
Quality stamp is " network recovery ".As shown in figure 5, t1 is communication disruption start time, increase " bad point " b1 at t1；T2 is interruption
Recover the moment, increase " bad point " b2 at t2.
Backfill quality of data identification method：
T1' is the previous better timestamp of communication disruption, and t2' is the better timestamp of communication recovery the latter, [t1',
T2'] then as starting of the SCADA server ends to preposition communication device requests backfill complement and end time section.Communicate extensive
After multiple, SCADA server ends are to the data at preposition communication device requests [t1', t2'] moment, and preposition communication equipment is by all times
Number completion sends and is stored on SCADA servers according to " backfill " quality stamp, backfill data are stamped.As shown in Figure 6.
Inquiry processing method based on quality stamp：
Client sends the inquiry of historical data request to SCADA servers, is looked into for the historical data containing backfill data
Request is ask, it is as follows using the interpolation inquiry processing method stabbed based on quality, method.
For containing mark communication disruption bad point section be abnormal section, as [t1', the t1] in Fig. 7 and [t1,
T1 ' '], abnormal section is without history interpolation calculation.Historical data between v1 and v5 is passed through interpolation algorithm meter by server end
Calculation obtains Part I return value, and part mass stamp is " better "；Using b1 points as Part II return value；By v5' with
Part III return value is calculated by interpolation algorithm in all backfill historical datas between v15', and part mass stamp is
" backfill "；Using b2 as Part IV return value；Historical data between v15 and v16 is calculated by interpolation algorithm
Five part return values, finally return to client using this five part as a whole result.
Display mode based on quality stamp：
Client is based on having two ways during quality stamp display data, and one kind is that " bad point " participates in display, and second is bad
Point is not involved in showing.
The first display mode：Client to the data of historical query carry out draw curve or statistics calculate when often for
Bad point in the non-caching period is not involved in line and draws or calculate, as having two matter of b1, b2 respectively in t1 and t2 moment in Fig. 7
Amount stamp for " bad point " state point, then the curve of client displaying can occur two vacuum disconnection bands at t1, t2, interpolation when
Between the big then disconnection band of granularity it is wider, the small then disconnection band of time granularity of interpolation is narrow.As shown in Figure 8：
Original state mark data and backfill data two kinds of version data be present for historical data backfill data, it is aobvious in inquiry
The first display mode can show gap because of the presence of former bad quality stamp data at backfill data both ends when showing, so data show
Show and another way is also provided.
Second of display mode, the bad quality point b1 and b2 of the representative communication equipment disconnection of non-caching period is weeded out,
Client can not consider the state mark that communication equipment interrupts when carrying out to the data of historical query and draw curve or statistics calculating
Note, the curve of client displaying are as shown in Figure 9.
As described above, embodiments of the invention are explained, as long as but essentially without this hair of disengaging
Bright inventive point and effect can have many deformations, and this will be readily apparent to persons skilled in the art.Therefore, this
The variation of sample is also integrally incorporated within protection scope of the present invention.
Claims (2)
1. a kind of SCADA system historical data complement and inquiry processing method based on quality stamp, it is characterised in that containing following
Step；
Using in SCADA system data quality stamp domain identifier system communication disruption state, SCADA system server end according to
Missing data is interrupted in calling in the historical data that break period stores from preposition communication equipment, realizes the history number based on quality stamp
Handled according to complement, and when client carries out the inquiry of historical data, historical data is based on quality stamp progress interpolation processing and returned
Back to client, enable data value and state that the result of processing correctly reflects in communication interruption time, supervised for SCADA system
Control provides true, accurate data；
Preposition communication equipment realize data converge adopt, communication Protocol Conversion and data forwarding basic function, preposition communication equipment is to most
Nearly a period of time historical data is locally stored, described to be locally stored using database, file mode storage；In communication recovery
Historical data backfill complement is carried out afterwards, and SCADA system establishes the link with preposition communication equipment and sends data backfill and asks, communication
Equipment gives data response；SCADA system is handled the data of backfill, including alarm, logout, but without real-time
Issue, and only deposit historical data base；SCADA system to backfill data use with real time data identical data storage method, but
" backfill " mark is stamped on quality stamp that will be to backfilling data, for marking the data is obtained using back-filling way；
Comprise the following steps that：
1) remote measurement, remote signalling, remote control, remote regulating business datum are used uniformly by SCADA system quality stamp planning step SCADA system
VQT data are indicated, the VQT data include value, quality stamp and three domains of timestamp, historical data base by data point when
Between all VQT data instances set in sequence carry out archival compression storage；" quality stamp " domain of VQT data includes data matter
Amount, data category information；Quality of data part have recorded the quality state of " value " of VQT data；The quality of data can be divided into three classes：
" good " quality, " bad " quality, " uncertain " quality；The quality of " value " that " good " quality indicates VQT data is good, can be made
With；" value " that " bad " quality indicates VQT data for some reason is unavailable；Again can be by " bad " matter according to the reason for different
Amount is subdivided into：Without special reason, configuration error, data source be not connected, equipment failure, sensor failure, communication disruption, in collection
Only；The quality that " uncertain " quality indicates " value " of VQT data for some reason is uncertain；Remember data category part
The classification of VQT data is recorded；The data category for needing to record in " quality stamp " domain of VQT data includes：Normal acquisition data,
Backfill complement data, manual logging data, calculate data, intermediate data；
2) when communication disruption occurs for communication disruption quality identification step, SCADA service ends detect communication disruption, then at the moment
Increase a bad point for representing communication interruption condition, the value of the point is that numerical value, the timestamp recorded last moment is to detect to break
Even at the time of, quality stamp be " network interruption "；Equally, during communication recovery, SCADA server ends detect communication recovery, then exist
The moment increases a bad point for representing communication recovery state, and the value of the point is that numerical value, the timestamp recorded last moment is inspection
At the time of measuring communication recovery, quality stamp be " network recovery "；T1 is communication disruption start time, increases " bad point " at t1
b1；T2 recovers the moment to interrupt, and increases " bad point " b2 at t2；
3) it is the previous better timestamp of communication disruption to backfill quality of data identification of steps t1', and t2' is communication recovery the latter
Better timestamp, [t1', t2'] then backfill starting and the knot of complement as SCADA server ends to preposition communication device requests
Beam time interval；After communication recovery, data from SCADA server ends to preposition communication device requests [t1', the t2'] moment, it is preposition
All backfill data are stamped " backfill " quality stamp by communication equipment, and backfill data send and are stored on SCADA servers；
4) based on quality stamp query processing step client to SCADA servers send the inquiry of historical data request, for containing
There is the inquiry of historical data request of backfill data, it is as follows using the interpolation inquiry processing method stabbed based on quality, step：For containing
The section for having mark communication disruption bad point is abnormal section, and [t1', t1] is with [t1, t1 "] abnormal section without history interpolation meter
Calculate；Part I return value is calculated by interpolation algorithm in historical data between v1 and v5 by server end, the part matter
It is " better " to measure stamp；Using b1 points as Part II return value；All backfill historical datas between v5' and v15' are passed through
Part III return value is calculated in interpolation algorithm, and part mass stamp is " backfill "；Using b2 as Part IV return value；
Part V return value is calculated by interpolation algorithm in historical data between v15 and v16, finally using this five part as
One whole result returns to client；
5) the step display client based on quality stamp is based on having two ways during quality stamp display data, and one kind is " bad point " ginseng
With display, second is that bad point is not involved in showing；The first display mode：Client carries out drawing song to the data of historical query
Often line is not involved in when line or statistics calculate for the bad point in the non-caching period to draw or calculate, in t1 and t2 moment point
There is not state point of the two quality stamps of b1, b2 for " bad point ", then two vacuum can occur at t1, t2 in the curve of client displaying
Disconnection band, the big then disconnection band of time granularity of interpolation is wider, and the small then disconnection band of time granularity of interpolation is narrow；For history
Original state mark data and backfill data two kinds of version data, the first display side in query display be present in data backfill data
Formula is because the presence of former bad quality stamp data can show gap at backfill data both ends, so data show also offer another kind side
Formula；Second of display mode, weed out the bad quality point b1 and b2 of the representative communication equipment disconnection of non-caching period, client
The data of historical query are carried out drawing curve or count the status indication that can not consider that communication equipment interrupts during calculating.
2. a kind of SCADA system historical data complement and inquiry processing method based on quality stamp according to claim 1,
Characterized in that, the preposition communication equipment uses preposition communication gate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310552244.6A CN104636352B (en) | 2013-11-08 | 2013-11-08 | SCADA system historical data complement and query processing method based on quality stamp |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310552244.6A CN104636352B (en) | 2013-11-08 | 2013-11-08 | SCADA system historical data complement and query processing method based on quality stamp |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104636352A CN104636352A (en) | 2015-05-20 |
| CN104636352B true CN104636352B (en) | 2018-02-02 |
Family
ID=53215124
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310552244.6A Active CN104636352B (en) | 2013-11-08 | 2013-11-08 | SCADA system historical data complement and query processing method based on quality stamp |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104636352B (en) |
Families Citing this family (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104850635B (en) * | 2015-05-24 | 2019-02-22 | 华东电网有限公司 | Shortage of data automaticly inspects and centralized monitoring method under a kind of multi-data source environment |
| CN105334827B (en) * | 2015-11-18 | 2018-07-06 | 张发平 | Manufacturing Supervision and quality real-time control system |
| US11621900B2 (en) | 2015-12-23 | 2023-04-04 | Intel Corporation | Selective measurement reporting from internet of things devices |
| CN105759783B (en) * | 2016-02-03 | 2018-09-07 | 中电和瑞科技有限公司 | A kind of method and device for realizing data processing |
| CN105791062A (en) * | 2016-03-11 | 2016-07-20 | 中国联合网络通信集团有限公司 | Method for identifying service, home gateway, and home network system |
| CN105956118B (en) * | 2016-05-05 | 2019-06-04 | 杭州优稳自动化系统有限公司 | A method of realizing real time information quality stamp distribution global data base |
| CN107463568B (en) * | 2016-06-03 | 2020-12-08 | 阿里巴巴集团控股有限公司 | Method and device for acquiring historical access data |
| CN106776855B (en) * | 2016-11-29 | 2020-03-13 | 上海轻维软件有限公司 | Processing method for reading Kafka data based on Spark Streaming |
| CN106708992A (en) * | 2016-12-16 | 2017-05-24 | 浙江中控技术股份有限公司 | Data query method, device and system |
| CN108512874A (en) * | 2017-02-27 | 2018-09-07 | 上海谦问万答吧云计算科技有限公司 | A kind of synchronous method and device of online question-answering data |
| CN109344363A (en) * | 2018-08-28 | 2019-02-15 | 北京双登慧峰聚能科技有限公司 | Data disconnection method for repairing and mending and system for energy storage SCADA system |
| CN109490616A (en) * | 2018-11-22 | 2019-03-19 | 国电南瑞南京控制系统有限公司 | A kind of photovoltaic DC-to-AC converter input electricity calculation method |
| CN111026715A (en) * | 2019-11-14 | 2020-04-17 | 西北工业大学 | Data processing method and device, computer storage medium and electronic equipment |
| JP7104338B2 (en) * | 2020-02-12 | 2022-07-21 | ダイキン工業株式会社 | Data collection system, receiving device, and data collection method |
| CN113093693B (en) * | 2021-03-18 | 2022-04-12 | 北京天玛智控科技股份有限公司 | Online fault diagnosis method for operation state of coal mining machine |
| CN113323698B (en) * | 2021-05-31 | 2023-11-03 | 国能神东煤炭集团有限责任公司 | Fully mechanized coal mining face propulsion distance calculation method, storage medium and electronic equipment |
| CN113702860A (en) * | 2021-08-20 | 2021-11-26 | 北京空间飞行器总体设计部 | Oscilloscope waveform data analysis method for spacecraft power supply system evaluation |
| CN114069847B (en) * | 2021-10-29 | 2024-03-26 | 国电南瑞科技股份有限公司 | Distributed photovoltaic data backfill system and method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1992632A (en) * | 2005-12-28 | 2007-07-04 | 大唐软件技术有限责任公司 | Communication network warning method and warning system |
| CN102118020A (en) * | 2009-12-30 | 2011-07-06 | 上海申瑞电力科技股份有限公司 | Method of power grid fault record real-time data storage selection mode |
| CN102192794A (en) * | 2011-03-07 | 2011-09-21 | 陕西师范大学 | Temperature data acquisition device, and storing and transmitting method thereof |
| CN102768516A (en) * | 2012-07-11 | 2012-11-07 | 广州杰赛科技股份有限公司 | Historical data additional recording method of wireless measurement and control system |
| CN103167517A (en) * | 2011-12-14 | 2013-06-19 | 中国电信股份有限公司 | Method and system for monitoring data recovery in internet of things |
-
2013
- 2013-11-08 CN CN201310552244.6A patent/CN104636352B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1992632A (en) * | 2005-12-28 | 2007-07-04 | 大唐软件技术有限责任公司 | Communication network warning method and warning system |
| CN102118020A (en) * | 2009-12-30 | 2011-07-06 | 上海申瑞电力科技股份有限公司 | Method of power grid fault record real-time data storage selection mode |
| CN102192794A (en) * | 2011-03-07 | 2011-09-21 | 陕西师范大学 | Temperature data acquisition device, and storing and transmitting method thereof |
| CN103167517A (en) * | 2011-12-14 | 2013-06-19 | 中国电信股份有限公司 | Method and system for monitoring data recovery in internet of things |
| CN102768516A (en) * | 2012-07-11 | 2012-11-07 | 广州杰赛科技股份有限公司 | Historical data additional recording method of wireless measurement and control system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104636352A (en) | 2015-05-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104636352B (en) | SCADA system historical data complement and query processing method based on quality stamp | |
| CN111092946B (en) | Data processing method and system applied to edge computing gateway | |
| CN110457190B (en) | Full link monitoring method, device and system based on block chain | |
| CN105790441A (en) | Intelligent transformer substation relay protection inspection system | |
| CN110855012A (en) | Real-time line loss intelligent analysis system for transformer area | |
| CN101170454A (en) | A method and system for monitoring data collection and summary status | |
| CN107395382A (en) | A kind of network quality performance methods of exhibiting and device, system | |
| CN115313625A (en) | Transformer substation monitoring method and system | |
| CN1972287B (en) | Communication protocol record analysis apparatus and its analysis method | |
| CN113506096B (en) | Inter-system interface method based on industrial internet identification analysis system | |
| CN114727166A (en) | Remote online metering instrument state monitoring method and system based on Internet of things | |
| CN113238890B (en) | Current sampling loop abnormity diagnosis method and device based on dynamic record data | |
| CN106199251A (en) | A kind of distribution network failure early warning system analyzed based on adaptive modeling and method | |
| CN113592210A (en) | Internet of things integrated management platform for water supply non-negative-pressure secondary water supply facility | |
| CN116150702B (en) | Data integration method and device for master-slave communication fusion | |
| CN115514099B (en) | Electric power safety inspection system and method | |
| CN116126647A (en) | Data linkage analysis system suitable for digital enterprises | |
| CN111030882A (en) | Network quality measurement method and system based on intelligent substation service message | |
| CN115995880A (en) | Comprehensive monitoring and analyzing method and system for multidimensional state of power distribution automation terminal | |
| CN110532153A (en) | A kind of business level user's operation experience visualization system | |
| CN106603396B (en) | A kind of access gateway of internet of things based on bus-type data exchange | |
| CN104965497A (en) | On-line production data rapid generation and management method and system | |
| CN114268168A (en) | Network security monitoring method applied to power monitoring system | |
| CN201004645Y (en) | Recording and analysis device for communication regulation breach | |
| CN114629236A (en) | Fault recording master station system of cloud-side cooperative architecture and operation method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211111 Address after: Room 08-10, 6 / F, block a, No. 5, Dongtucheng Road, Chaoyang District, Beijing 100013 Patentee after: National Petroleum and natural gas pipeline network Group Co.,Ltd. Address before: 100007 China Petroleum Building, No. 9, Dongzhimen North Street, Dongcheng District, Beijing Patentee before: PetroChina Company Limited |
|
| TR01 | Transfer of patent right |