CN109116818B - Real-time data dump method and device during SCADA system upgrade - Google Patents

Real-time data dump method and device during SCADA system upgrade Download PDF

Info

Publication number
CN109116818B
CN109116818B CN201810898847.4A CN201810898847A CN109116818B CN 109116818 B CN109116818 B CN 109116818B CN 201810898847 A CN201810898847 A CN 201810898847A CN 109116818 B CN109116818 B CN 109116818B
Authority
CN
China
Prior art keywords
task
data
dump
dumping
real
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
Application number
CN201810898847.4A
Other languages
Chinese (zh)
Other versions
CN109116818A (en
Inventor
杭小林
刘晓龙
刘晗
邓博
高振峰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xinzhi Energy System Control Co Ltd
Original Assignee
Xinzhi Energy System Control Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xinzhi Energy System Control Co Ltd filed Critical Xinzhi Energy System Control Co Ltd
Priority to CN201810898847.4A priority Critical patent/CN109116818B/en
Publication of CN109116818A publication Critical patent/CN109116818A/en
Application granted granted Critical
Publication of CN109116818B publication Critical patent/CN109116818B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B19/00Programme-control systems
    • G05B19/02Programme-control systems electric
    • G05B19/418Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
    • G05B19/4183Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by data acquisition, e.g. workpiece identification
    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B2219/00Program-control systems
    • G05B2219/20Pc systems
    • G05B2219/24Pc safety
    • G05B2219/24215Scada supervisory control and data acquisition
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/02Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Landscapes

  • Engineering & Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Manufacturing & Machinery (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Automation & Control Theory (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The embodiment of the invention discloses a real-time data dump method and a device during SCADA system upgrade, wherein the method comprises the following steps: establishing a SCADA system real-time data dump task queue, wherein the queue comprises a first dump task T1 and a second dump task T2; real-time data are collected through a first dumping task T1 and a second dumping task T2 and stored into corresponding buffer data files; applying for acquiring data dump right and executing normal data dump by a first dump task T1; when the first dumping task T1 has a fault caused by program upgrading, the second dumping task T2 carries out breakpoint transmission; when the second dump task T2 has a fault due to the program upgrade, or the first dump task T1 has been upgraded and completed, breakpoint resuming is performed by the first dump task T1. The embodiment scheme solves the problem of data interruption caused by program upgrading in the process of real-time data dump of the SCADA system, and improves the stability of the real-time data dump of the SCADA system.

Description

Real-time data dump method and device during SCADA system upgrade
Technical Field
The embodiment of the invention relates to a data dump technology, in particular to a real-time data dump method and a real-time data dump device during upgrading of an SCADA (supervisory control and data acquisition) system.
Background
In the field of industrial automation Control, SCADA (Supervisory Control And data acquisition And monitoring Control) is commonly used for acquiring data And monitoring field operation equipment, various instruments And communication equipment are installed on the field, a SCADA system acquires data through a communication protocol, And due to the fact that the SCADA system has a data storage function, historical data trend of a data item to be monitored can be checked And analyzed through a SCADA system software module, And due to the fact that an upper data analysis module needs to calculate And analyze bottom layer data to obtain various summarized data such as metering data And operation indexes, basic data need to be dumped into a relational database in real time through the SCADA system, And the data are accessed by upper application software And are calculated And then subjected to business analysis.
The SCADA system real-time data dump operating environment generally comprises: the SCADA server runs an SCADA software system and a real-time data dump program, the database server runs a relational database, the application server runs upper-layer industry application software and the like.
The SCADA software system collects real-time data from field equipment, and a real-time data dump program accesses a real-time database through an interface or a conventional communication protocol to obtain the data and provides the data for a relational database accessible by application software in the upper industry.
At present, the commonly used data dump measures of the SCADA system include:
(1) ADO data processing script
And embedding an ADO data processing script in the SCADA timing script, and directly writing the real-time SCADA variable data into a historical library.
ADO (ActiveX Data objects): a program object for representing data structures and contained data in a user database, using ADO objects to create or modify tables and queries, check the database, or access external data sources.
(2) ODBC data dump component
The ODBC data dump component acquires data by accessing an internal interface through an SDK of an SCADA manufacturer and dumping real-time data into a relational database in a certain format at regular time through an ODBC mode.
ODBC (Open Database Connectivity Open Database interconnection) is a component of microsoft corporation Open Services Architecture (WOSA), which builds a set of specifications and provides a set of standard APIs (application programming interfaces) for Database access.
SDK (Software Development Kit Software Development tool) is a collection of Development tools used by Software engineers to create application Software for a specific Software package, Software framework, hardware platform, operating system, etc., and the patent uses an application program interface API provided for SCADA Software vendors to access SCADA real-time databases through the interface.
(3) OPC data acquisition and storage software
And deploying OPC data acquisition and storage software, acquiring SCADA real-time data by the software in an OPC mode, acquiring the real-time data by the software at regular time and writing the real-time data into a relational database in an ODBC mode.
OPC (object connection and embedding for Process Control) is a specification designed to solve a communication standard between a field management layer and a Process Control layer based on Microsoft COM/DCOM (Distributed component object model) technology and DNA (Distributed internet Application) framework, and provides a standard mechanism for data communication between a Process management Application and a field automation Control system and devices.
However, the current SCADA system data dump has the following disadvantages:
(1) ADO data processing script
Because the ADO script is complex and inconvenient to maintain, and the operation process can affect the operation efficiency of the SCADA system software, the use is less.
(2) Data loss caused by SCADA system upgrade often occurs in the process of using ODBC data dump component or OPC data acquisition and storage software:
the SCADA system upgrading can comprise system upgrading such as SCADA system data acquisition item adjustment upgrading, OPC data acquisition and storage software configuration item and software upgrading, and OPC data acquisition and storage software needs to be restarted after the configuration item is adjusted, so that data loss is caused.
In order to solve the above problems, the conventional solutions are as follows:
the traditional solution is to restart and activate the software function by monitoring whether the process is abnormal or not, detecting whether the data stops dumping or not, and manually maintaining and completing the data (inquiring the data record of the SCADA historical database and manually completing the data). However, the following problems still exist with these current solutions:
(1) data are interrupted for a long time, and the workload of filling up is large;
(2) partial data are incomplete, so that the result of timing data calculation is deviated;
(3) the data maintenance cost is high;
(4) affecting upper layer data calculation and analysis processing application functions.
Disclosure of Invention
In order to solve the technical problem, embodiments of the present invention provide a method and an apparatus for real-time data dump during the update of a SCADA system by data acquisition and monitoring control, which can solve the problem of data interruption caused by software update and maintenance during the real-time data dump of the SCADA system, avoid the behavior of fault recovery and historical data completion caused by faults, and ensure the sequential write-in of data dump, thereby improving the stability of real-time data dump of the SCADA system. .
In one embodiment of the present invention, there is provided:
(1) a real-time data dump method during SCADA system upgrade can include:
establishing a real-time data dump task queue of the SCADA system; the real-time data dump task queue at least comprises: a first dumping task T1 and a second dumping task T2;
starting the first dumping task T1 and the second dumping task T2, continuously collecting real-time data through the first dumping task T1 and the second dumping task T2 respectively, and storing the real-time data into a corresponding first buffer data file and a corresponding second buffer data file;
applying for acquiring a data dump right by the first dump task T1, and executing normal data dump so as to write the real-time data into a preset relational database data table;
when a fault caused by program upgrading occurs in the process of performing data dump by the first dump task T1, performing breakpoint resume by the second dump task T2 according to the real-time data stored in the second buffer data file, so as to implement automatic fault recovery; when the second dumping task T2 has a fault caused by program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming according to the real-time data stored in the first buffered data file.
In various other embodiments of the invention:
(2) the method for real-time data dump during upgrading of SCADA system according to (1), wherein the establishing of the real-time data dump task queue of SCADA system may include:
setting a dump task configuration table;
configuring the first dumping task T1 and the second dumping task T2 in the dumping task configuration table;
wherein, the dump task configuration table comprises: task numbering and collecting and dumping configuration information; the task numbers of the first dumping task T1 and the second dumping task T2 are different, and the acquisition and dumping configuration information are the same.
(3) The method for real-time data dump during upgrading of the SCADA system according to (2), wherein the acquisition and dump configuration information may include one or more of the following: task name, task type, data collection and dump program path, data collection and dump program name, collection task number and dump destination data table name.
(4) The method for dumping real-time data during upgrading of the SCADA system in (1), further comprising: after a SCADA system real-time data dump task queue is established, setting the main-standby relationship between the first dump task T1 and the second dump task T2;
the first dump task T1 is a main task, and the second dump task T2 is a standby task.
(5) The method for real-time data dump during SCADA system upgrade according to (1), wherein the starting the first dumping task T1 and the second dumping task T2 may include:
respectively starting a first data acquisition and dump program A1 corresponding to the first dumping task T1 and a second data acquisition and dump program A2 corresponding to the second dumping task T2;
the operation information is accessed and recorded to the preset task synchronization table Y1 through the first data collecting and dumping program A1 and the second data collecting and dumping program A2.
(6) The method for real-time data dump during SCADA system upgrade according to (5), wherein the task synchronization table Y1 may include: task coding, task state, state change time and data dump time point;
wherein the task encoding comprises: a first code M1 representing the main task and a second code M2 representing the standby task;
the task states include: an operation state X1, a fault state X2, an application state X3, a continuous transmission state X4 and a working state X5.
(7) The method for real-time data dump during upgrade of a SCADA system according to (6), wherein the applying for obtaining a data dump right by the first dumping task T1 and executing a normal data dump to write the real-time data into a preset relational database data table may include:
setting the task state of the first dumping task T1 in the task synchronization table Y1 to be an application state X3 through the first data collecting and dumping program A1 so as to apply for the data dumping right;
after the data dump right is acquired, executing a normal data dump task process through the first data acquisition and dump program A1, and writing acquired real-time data into a preset first relational database data table W1; and setting the task state in the task synchronization table Y1 to be the working state X5, and updating the data dump time point and the state change time.
(8) The method for real-time data dump during SCADA system upgrade according to (7), wherein, when a failure occurs during data dump due to program upgrade in the first dumping task T1, performing breakpoint resuming by the second dumping task T2 according to the real-time data stored in the second buffered data file includes:
the second dumping task T2 judges the fault of the first dumping task T1 through the task state of the task synchronization table Y1 and applies for acquiring the data dumping right;
acquiring a first data breakpoint B1 of the first dumping task T1 from a data dumping time point and a state change time of the task synchronization table Y1; the first data breakpoint B1 is a data breakpoint that was generated prior to the upgrade of the first data collection and dump program a1 as a result of closing the first data collection and dump program a 1;
and extracting the continuous data queue comprising the first data breakpoint B1 from the second buffer data file and executing a continuous transmission process to perform breakpoint continuous transmission.
(9) The method for dumping real-time data during upgrading of a SCADA system according to (8), wherein the performing, by the first dumping task T1, breakpoint resuming according to the real-time data stored in the first buffered data file when the second dumping task T2 fails due to program upgrade or the first dumping task T1 is upgraded and completed includes:
the first dumping task T1 judges the fault of the second dumping task T2 through the task state of the task synchronization table Y1 and applies for acquiring the data dumping right; acquiring a second data breakpoint B2 of the second dump task T2 from the data dump time point and the state change time of the task synchronization table Y1; the second data breakpoint B2 is a data breakpoint generated by closing the second data acquisition and dump program a2 prior to the upgrade of the second data acquisition and dump program a 2; or the upgraded first dumping task T1 actively applies for acquiring the data dumping right, and the second dumping task T2 exits from the normal data dumping task to generate the second data breakpoint B2;
the first destaging task T1 extracts the contiguous data queue including the second data breakpoint B2 from the first buffered data file and performs a resume process for a breakpoint resume. In another embodiment of the present invention, there is provided:
(10) a real-time data dump device for upgrading a data acquisition and monitoring control SCADA system comprises: the system comprises a processor and a computer readable storage medium, wherein instructions are stored in the computer readable storage medium, and when the instructions are executed by the processor, the method for improving the stability of the real-time data dump of the SCADA system is realized.
The embodiment of the invention comprises the following steps: establishing a real-time data dump task queue of the SCADA system; the real-time data dump task queue at least comprises: a first dumping task T1 and a second dumping task T2; starting the first dumping task T1 and the second dumping task T2, continuously collecting real-time data through the first dumping task T1 and the second dumping task T2 respectively, and storing the real-time data into a corresponding first buffer data file and a corresponding second buffer data file; applying for acquiring a data dump right by the first dump task T1, and executing normal data dump so as to write the real-time data into a preset relational database data table; when a fault caused by program upgrading occurs in the process of performing data dump by the first dump task T1, performing breakpoint resume by the second dump task T2 according to the real-time data stored in the second buffer data file, so as to implement automatic fault recovery; when the second dumping task T2 has a fault caused by program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming according to the real-time data stored in the first buffered data file. Through the scheme of the embodiment, the problem of data interruption caused by faults generated by program upgrading in the real-time data dump process of the SCADA system is solved, the data interruption caused by abnormal data dump process is prevented, the actions that the faults caused by upgrading cannot be automatically recovered and the historical data are filled up are avoided, the sequential write-in of the data dump is ensured, and the stability of the real-time data dump of the SCADA system is improved.
Additional features and advantages of embodiments of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the examples of the application do not constitute a limitation of the embodiments of the invention.
FIG. 1 is a flowchart of a real-time data dump method for monitoring and controlling the upgrading of a SCADA system according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a SCADA system real-time data dump method according to an embodiment of the present invention;
FIG. 3 is a flowchart of a method for initiating a first dump task T1 and a second dump task T2 according to an embodiment of the present invention;
FIG. 4 is a flowchart of a method for applying for acquiring data dump right and executing normal data dump by the first dump task T1 according to an embodiment of the present invention;
FIG. 5 is a flowchart of a method for performing breakpoint resuming by the second dumping task T2 according to the real-time data stored in the second buffered data file when a failure occurs in the first dumping task T1 due to program upgrade during the data dumping process according to the embodiment of the present invention;
fig. 6 is a flowchart of a method for performing breakpoint resuming by the first dumping task T1 according to the real-time data stored in the first buffered data file when the second dumping task T2 has a fault due to program upgrade or the first dumping task T1 is upgraded and completed according to the embodiment of the present invention;
fig. 7 is a block diagram of a real-time data dump device during the upgrade of the SCADA system according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
Example one
A real-time data dump method for upgrading a SCADA system based on data acquisition and monitoring control, as shown in FIG. 1 and FIG. 2, may include S101-S104:
s101, establishing a real-time data dump task queue of the SCADA system; the real-time data dump task queue at least comprises: a first dumping task T1 and a second dumping task T2;
s102, starting the first dumping task T1 and the second dumping task T2, continuously collecting real-time data through the first dumping task T1 and the second dumping task T2 respectively, and storing the real-time data into a corresponding first buffer data file and a corresponding second buffer data file;
s103, applying for acquiring a data dump right by the first dump task T1, and executing normal data dump so as to write the real-time data into a preset relational database data table;
s104, when a fault caused by program upgrading occurs in the process of carrying out data dump by the first dump task T1, carrying out breakpoint resume by the second dump task T2 according to real-time data stored in the second buffer data file, and realizing automatic fault recovery; when the second dumping task T2 has a fault caused by program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming according to the real-time data stored in the first buffered data file.
In the embodiment of the invention, in order to solve the problems in the background technology, a real-time data dump task queue of an SCADA system is established, a plurality of data acquisition and dump programs are operated in parallel, a software synchronous operation mechanism is established, a data buffer mechanism is established, an online operation backup function is provided, and a data dump task uninterruptedly acquires real-time data and writes the real-time data into a buffer data file; the dump task needs to obtain data dump right before executing the dump task; when data collection or dump is abnormal, fault recording and redundancy processing are realized, the dump task realizes automatic fault recovery after upgrading of a data dump program through breakpoint continuous transmission, and the stability of real-time data dump of the SCADA system can be greatly improved.
In the embodiment of the invention, through the service functions of online redundancy of the real-time data dump task of the SCADA system, breakpoint continuous transmission of the real-time data dump of the SCADA system and the like, the invention can solve the problem of the breakpoint of the service data of data acquisition and dump program upgrading, and realize the automatic recovery processing of the service data and the effect of breakpoint-free upgrading.
In embodiments of the present invention, a SCADA system upgrade may include, but is not limited to, any one or more of the following: the method comprises the steps of adjusting and upgrading a data acquisition project of the SCADA system, acquiring OPC data, and storing a software configuration project and software upgrading.
Example two
The embodiment provides a specific implementation way for establishing a real-time data dump task queue of the SCADA system on the basis of the first embodiment.
In this embodiment of the present invention, the establishing a real-time data dump task queue of the SCADA system may include:
setting a dump task configuration table;
configuring the first dumping task T1 and the second dumping task T2 in the dumping task configuration table;
wherein, the dump task configuration table comprises: task numbering and collecting and dumping configuration information; the task numbers of the first dumping task T1 and the second dumping task T2 are different, and the acquisition and dumping configuration information are the same.
In this embodiment of the present invention, a dump task configuration table C2 may be provided, where the two dump tasks in the dump task configuration table C2 are configured as a first dump task T1 and a second dump task T2, respectively. The task numbers of the first dumping task T1 and the second dumping task T2 are different, and the collection and dumping configuration information is the same.
In an embodiment of the present invention, the collecting and dumping configuration information may include one or more of the following: task name, task type, data collection and dump program path, data collection and dump program name, collection task number and dump destination data table name.
In the embodiment of the present invention, the dump task configuration table C2 may include one or more of task number, task name, task type, data collection and dump program path, data collection and dump program name, collection task number, dump destination data table name, and other information items.
In the embodiment of the present invention, the method may further include: after a SCADA system real-time data dump task queue is established, setting the main-standby relationship between the first dump task T1 and the second dump task T2; wherein, the first dump task T1 is a main task (M1), and the second dump task T2 is a standby task (M2).
In the embodiment of the present invention, in the dump task configuration table C2, the task type of the first dump task T1 may be set as the main task (M1), and the task type of the second dump task T2 may be set as the standby task (M2).
In the embodiment of the present invention, before the SCADA system real-time data dump task queue is established, the collection data configuration table C1 may be preset, so as to execute uninterrupted real-time data collection tasks according to the collection data configuration table C1.
In the embodiment of the present invention, the collected data configuration table C1 may include information of data items to be acquired and dumped from the SCADA system, and specifically may include any one or more of the following information: collecting task numbers, collected input/output IO point names, data item names, collection frequency, value taking modes and the like.
EXAMPLE III
This embodiment is based on the first embodiment or the second embodiment, and a specific implementation manner of starting the first dumping task T1 and the second dumping task T2 is given.
In the embodiment of the present invention, as shown in fig. 3, the starting the first dumping task T1 and the second dumping task T2 may include S201 to S202:
s201, respectively starting a first data acquisition and dump program A1 corresponding to the first dumping task T1 and a second data acquisition and dump program A2 corresponding to the second dumping task T2;
s202, accessing and recording the running information to a preset task synchronization table Y1 through the first data collecting and dumping program A1 and the second data collecting and dumping program A2.
In the embodiment of the present invention, a first data collecting and dumping program a1 corresponding to the first dumping task T1 and a second data collecting and dumping program a2 corresponding to the second dumping task T2 may be written in advance; when the first dumping task T1 and the second dumping task T2 are restarted, the first data collecting and dumping program a1 and the second data collecting and dumping program a2 may be started, respectively, the program a1 and the program a2 access and record the running information to the task synchronization table Y1, and record the task state in the task synchronization table Y1 as the X1 (running) state.
In this embodiment of the present invention, the task synchronization table Y1 may include: task coding, task state, state change time and data dump time point;
wherein the task encoding comprises: a first code M1 representing the main task and a second code M2 representing the standby task;
the task states include: an operation state X1, a fault state X2, an application state X3, a continuous transmission state X4 and a working state X5.
In the embodiment of the present invention, task coding (or task type coding) describes: m1 (main): a main task; m2 (stock): and (5) preparing tasks. That is, when the corresponding task code column is set to M1, the corresponding dump task is the main task; when the corresponding task code column is set to M2, the corresponding dump task is referred to as a standby task.
In the embodiment of the present invention, the task code may include, but is not limited to, the letters M1 and M2, and any number, letter, character, etc. other than M1 and M2 may be used.
In the embodiment of the invention, the task state description comprises the following steps:
x1 (run): after the software is started, the task state item of the task synchronization table Y1 is written into the state;
x2 (fault): the software dump is abnormal, and the task state item in the task synchronization table Y1 is written into the state;
x3 (application): applying for executing a data dump task, and when the task state is not dumped (a non-continuous transfer state and a non-working state) or the update time is invalid (such as a record with the update time less than 60 seconds), updating the task state into an application state;
x4 (continuous transmission): executing breakpoint continuous transmission work;
x5 (working): and executing real-time dump work.
In the embodiment of the present invention, the representation manner of the task state may include, but is not limited to, letters X1-X5, and any number, letter, character, etc. other than X1-X5 may be used.
In the embodiment of the invention, the implementation mode of the data collection and dump task program can select an OPC mode or an interface calling mode.
Example four
On the basis of any of the above embodiments, this embodiment provides a specific implementation manner that the real-time data are collected continuously and stored in the corresponding first buffered data file and the corresponding second buffered data file by the first dumping task T1 and the second dumping task T2, respectively.
In the embodiment of the invention, real-time data can be acquired from the SCADA system according to the preset information of the acquisition data configuration table C1, and after the data acquisition and dump program is started, the program can execute uninterrupted real-time data acquisition tasks.
In an embodiment of the present invention, the uninterrupted collection of real-time data by the first dumping task T1 and the second dumping task T2, and the storing of the corresponding first buffered data file and the second buffered data file may specifically include: continuously executing a collecting process K1_1 and a writing buffer data process K3_1 of the first transstorage task T1; the collection process K1_2 and the write buffer data process K3_2 of the second dump task T2 are executed without interruption.
In an embodiment of the present invention, the uninterrupted execution of the collection process K1_1 and the write buffer data process K3_1 of the first dumping task T1 may include: a first data acquisition and dump program A1 of a first dumping task T1 executes an acquisition process K1_1 according to an acquisition data configuration table C1 list, and acquires real-time data from an SCADA real-time base; the K3_1 process is performed to write the real-time data to the first buffered data file F1.
In an embodiment of the present invention, the uninterrupted execution of the collection process K1_2 and the write buffered data process K3_2 of the second dump task T2 may include: a second data acquisition and dump program A2 of a second dump task T2 executes an acquisition process K1_2 according to an acquisition data configuration table C1 list, and acquires real-time data from an SCADA real-time base; the K3_2 process is performed to write the real-time data to the second buffered data file F2.
EXAMPLE five
The embodiment provides a specific implementation manner of the first dumping task T1 applying for acquiring the data dumping right on the basis of any of the above embodiments.
In the embodiment of the present invention, as shown in fig. 4, applying for obtaining a data dump right by the first dumping task T1, and performing a normal data dump to write the real-time data into a preset relational database data table may include S301 to S302:
s301, setting the task state of the first dumping task T1 in the task synchronization table Y1 to be an application state X3 through the first data collecting and dumping program A1 so as to apply for the data dumping right;
s302, after the data dump right is obtained, executing a normal data dump task process through the first data acquisition and dump program A1, and writing acquired real-time data into a preset first relational database data table W1; and setting the task state in the task synchronization table Y1 to be the working state X5, and updating the data dump time point and the state change time.
In the embodiment of the present invention, the data dump right application process K2_1 may be executed by the first data collection and dump program a1, so that the first dump task T1, which is marked as a main task, applies for acquiring data dump right. Specifically, the corresponding task state of the first dumping task T1 in the task synchronization table Y1 may be set to the X3 (application) state by the first data collection and dumping program a1 to apply for data dumping rights.
In the embodiment of the present invention, the data dump right application process K2_2 may also be executed first by the second data acquisition and dump program a2, so that the second dump task T2, which is marked as a secondary task, applies for acquiring the data dump right. The specific definition may be self-defined according to an actual application scenario, and is not particularly limited herein.
In this embodiment of the present invention, after acquiring the data dump right, the first dumping task T1 executes a normal data dump, and writes the real-time data into the relational database data table, which may specifically include: the first data collecting and dumping program a1 of the first dumping task T1 executes a normal data dumping task process K5_1, writes the collected real-time data into a data table W1, sets the task state of the first dumping task T1 in a task synchronization table Y1 to an X5 (working) state, and updates the data dumping time and the state change time. The first dumping task T1 continues to execute the dumping task process K5_1 without interruption.
In the embodiment of the present invention, the data table W1 may include, but is not limited to, any one or more of the following items: IO (input/output) point code, data item name, value, acquisition time and the like
EXAMPLE six
On the basis of the first to fifth embodiments, this embodiment provides a specific implementation manner that when a failure occurs in the first dumping task T1 due to program upgrade during data dumping, the second dumping task T2 continues to transfer the data at the breakpoint.
In this embodiment of the present invention, as shown in fig. 5, when a failure occurs in the first dumping task T1 during data dumping due to program upgrade, the performing, by the second dumping task T2, breakpoint resuming according to the real-time data stored in the second buffered data file may include S401 to S403:
s401, the second dumping task T2 judges the fault of the first dumping task T1 through the task state of the task synchronization table Y1 and applies for acquiring data dumping right;
s402, acquiring a first data breakpoint B1 of the first dump task T1 from a data dump time point and a state change time of the task synchronization table Y1; the first data breakpoint B1 is a data breakpoint that was generated prior to the upgrade of the first data collection and dump program a1 as a result of closing the first data collection and dump program a 1;
and S403, extracting the continuous data queue including the first data breakpoint B1 from the second buffer data file and executing a continuous transmission process to perform breakpoint continuous transmission.
In the embodiment of the present invention, the first data collecting and dumping program a1 of the first dumping task T1 may have a failure of the first dumping task T1 due to the upgrade, before the first data collecting and dumping program a1 is upgraded, the first data collecting and dumping program a1 is turned off, and a failure of the first dumping task T1 occurs, so as to form a third data breakpoint B3.
In the embodiment of the present invention, after the first data collecting and dumping program a1 of the first dumping task T1 performs the data dumping task process K5_1 and has a fault, the fault recording process K4_1 of the first data collecting and dumping program a1 may record the time point of the fault data into the task fault table Y2, the recovery state entry in the task fault table Y2 is marked as not recovered, the task state corresponding to the first dumping task T1 in the task synchronization table Y1 is set to be the X2 (fault) state, and the state change time is updated.
In this embodiment of the present invention, the performing breakpoint resuming by the second dump task T2 to implement the failure recovery process may specifically include:
1. the second dumping task T2 judges the failure of the first dumping task T1 and applies for acquiring the data dumping right; that is, the second dump task T2 accesses the task synchronization table Y1 to determine that the first dump task T1 has a fault, the second dump task T2 applies for and acquires a data dump right, and a task state corresponding to the second dump task T2 in the task synchronization table Y1 is assigned as an X3 (application) state;
2. acquiring a data breakpoint of the first dump task T1 from the task state table Y1, and marking the data breakpoint as a first data breakpoint B1;
3. breakpoint resume is carried out on the first data breakpoint B1, and fault recovery is achieved; that is, the second data collecting and dumping program a2 executes the process of extracting buffered data K3_2, extracting buffered data from the second buffered data file F2, obtaining a continuous data queue including the first data breakpoint B1, and executing the resume process K5_2 (the resume process K5_2 is also a normal data dumping task process of the second dumping task T2); and after the breakpoint continuous transmission is completed, changing the recovery state of the preset task fault table Y2 into recovered state, and updating the data dump time point and the state change time of the task synchronization table Y1.
In the embodiment of the present invention, during the process of executing data dump task K5_2 continuously by the second data collection and dump program a2, the collected real-time data is written into the data table W1, and the task state of the second dump task T2 in the task synchronization table Y1 is set to X5 (working).
In the embodiment of the present invention, the recovery status in the task fault table Y2 may be represented by different status flags, which may include, but are not limited to, values 01 and 02, where 01 may represent not recovered and 02 may represent recovered; in other embodiments, any number, letter, character, etc. other than 01 and 02 may be used.
EXAMPLE seven
On the basis of the sixth embodiment, this embodiment provides a specific implementation manner that when the second dumping task T2 fails due to program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming.
In this embodiment of the present invention, as shown in fig. 6, when the second dumping task T2 has a failure due to program upgrade, or the first dumping task T1 has been upgraded and completed, performing breakpoint resuming by the first dumping task T1 according to the real-time data stored in the first buffered data file may include S501-S502:
s501, the first dumping task T1 judges the fault of the second dumping task T2 through the task state of the task synchronization table Y1 and applies for acquiring the data dumping right; acquiring a second data breakpoint B2 of the second dump task T2 from the data dump time point and the state change time of the task synchronization table Y1; the second data breakpoint B2 is a data breakpoint generated by closing the second data acquisition and dump program a2 prior to the upgrade of the second data acquisition and dump program a 2; or the upgraded first dumping task T1 actively applies for acquiring the data dumping right, and the second dumping task T2 exits from the normal data dumping task to generate the second data breakpoint B2;
s502, the first transstorage task T1 extracts the continuous data queue including the second data breakpoint B2 from the first buffered data file and executes a resume process to perform breakpoint resume.
In the embodiment of the present invention, when the first dumping task T1 is not upgraded, breakpoint resuming by the second dumping task T2 may be continued; when the first dumping task T1 is upgraded, or the second dumping task T2 starts to be upgraded, the first dumping task T1 may reapply the data dumping right, and perform breakpoint transmission according to the real-time data stored in the first buffered data file.
In the embodiment of the present invention, in the process of performing breakpoint resuming on the second dump task T2, after the first data collection and dump program a1 of the first dump task T1 is upgraded, the first data collection and dump program a1 may be resumed, that is, the first dump task T1 reappears the data dumping right, and obtains the second data breakpoint B2 of the second dump task T2, and performs a data dump process K5_1, and performs breakpoint resuming on the basis of the second data breakpoint B2 according to the real-time data stored in the first buffered data file; the collected real-time data is written into a data table W1, the task state of a first dumping task T1 in a task synchronization table Y1 is set to be an X5 (working) state, and the first dumping task T1 executes an uninterrupted dumping process K5_ 1.
In the embodiment of the present invention, similarly, the second data collecting and dumping program a2 of the second dumping task T2 may also have a failure of the second dumping task T2 due to the upgrade, before the second data collecting and dumping program a2 is upgraded, the second data collecting and dumping program a2 is closed, and the failure of the second dumping task T2 occurs, so as to form a data breakpoint.
In the embodiment of the present invention, after the second data collecting and dumping program a2 of the second dumping task T2 executes the normal data dumping task process K5_2 and has a fault, the fault recording process K4_2 of the second data collecting and dumping program a2 may record the time point of the fault data into the task fault table Y2, mark the recovery state entry in the task fault table Y2 as not recovered, set the task state corresponding to the second dumping task T2 in the task synchronization table Y1 as the X2 (fault) state, and update the state change time.
In the embodiment of the present invention, for the above situation, the first dumping task T1 that is recovered to be normal may reapply the data dumping right, acquire the data breakpoint of the second dumping task T2, execute a data dumping process K5_1, and perform breakpoint resuming based on the data breakpoint according to the real-time data stored in the first buffered data file; the collected real-time data is written into a data table W1, the task state of a first dumping task T1 in a task synchronization table Y1 is set to be an X5 (working) state, and the first dumping task T1 executes an uninterrupted dumping process K5_ 1.
Example eight
A real-time data dump device 1 for data acquisition and monitoring control during SCADA system upgrade, as shown in FIG. 7, may include: a processor 11 and a computer-readable storage medium 12, wherein the computer-readable storage medium 12 stores instructions, and when the instructions are executed by the processor 11, the method for improving the stability of the real-time data dump of the SCADA system is implemented.
The embodiment of the invention comprises the following steps: establishing a real-time data dump task queue of the SCADA system; the real-time data dump task queue at least comprises: a first dumping task T1 and a second dumping task T2; starting the first dumping task T1 and the second dumping task T2, continuously collecting real-time data through the first dumping task T1 and the second dumping task T2 respectively, and storing the real-time data into a corresponding first buffer data file and a corresponding second buffer data file; applying for acquiring a data dump right by the first dump task T1, and executing normal data dump so as to write the real-time data into a preset relational database data table; when a fault caused by program upgrading occurs in the process of performing data dump by the first dump task T1, performing breakpoint resume by the second dump task T2 according to the real-time data stored in the second buffer data file, so as to implement automatic fault recovery; when the second dumping task T2 has a fault caused by program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming according to the real-time data stored in the first buffered data file. Through the scheme of the embodiment, the problem of data interruption caused by program upgrading in the real-time data dump process of the SCADA system is solved, the data interruption caused by abnormal data dump process is prevented, the actions that faults caused by upgrading cannot be automatically recovered and historical data is filled up are avoided, the sequential write-in of data dump is ensured, and therefore the stability of the real-time data dump of the SCADA system is improved.
The scheme of the embodiment of the invention at least comprises the following beneficial effects:
1. the embodiment of the invention can reduce the manual maintenance cost and ensure the rationality and the correctness of the upper application data for the data problem caused by upgrading the data dump program of the SCADA system;
the embodiment of the invention can realize the functions of breaking point data buffering and automatic dumping after the fault occurs, has better data guarantee function for guaranteeing the continuous real-time operation data of the SCADA system, improves the fault resistance of the whole application, reduces the cost of manual maintenance through the self-healing function, and can also guarantee the rationality and the correctness of the upper-layer application data.
2. For the SCADA system data service integration system, the upper-layer software of the SCADA system with the service dumping function is frequently required to be upgraded, so that the service upgrading can be quickly realized, and the good and stable continuous historical data dumping function is exerted;
by the service functions of online redundancy of the real-time data dump task of the SCADA system, breakpoint continuous transmission of the real-time data dump of the SCADA system and the like, the invention can solve the problem of the service data breakpoint of data acquisition and dump program upgrading and database migration, and realize the automatic recovery processing and breakpoint-free upgrading effects of the service data.
3. Through the scheme of the embodiment, the upgrading process of the data acquisition and dump program has no data loss: the data dump task is implemented by means of online redundancy, when a data acquisition and dump program is closed and upgraded, the system can automatically judge the breakpoint, automatically realize breakpoint continuous transmission and realize no data loss.
It will be understood by those of ordinary skill in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.

Claims (10)

1. A real-time data dump method for upgrading a data acquisition and monitoring control SCADA system comprises the following steps:
establishing a real-time data dump task queue of the SCADA system; the real-time data dump task queue at least comprises: a first dumping task T1 and a second dumping task T2;
starting the first dumping task T1 and the second dumping task T2, continuously collecting real-time data through the first dumping task T1 and the second dumping task T2 respectively, and storing the real-time data into a corresponding first buffer data file and a corresponding second buffer data file;
applying for acquiring a data dump right by the first dump task T1, and executing normal data dump so as to write the real-time data into a preset relational database data table;
when a fault caused by program upgrading occurs in the process of performing data dump by the first dump task T1, performing breakpoint resume by the second dump task T2 according to the real-time data stored in the second buffer data file, so as to implement automatic fault recovery; when the second dumping task T2 has a fault caused by program upgrade, or the first dumping task T1 is upgraded and completed, the first dumping task T1 performs breakpoint resuming according to the real-time data stored in the first buffered data file.
2. The method for real-time data dump during SCADA system upgrade as claimed in claim 1, wherein said building a SCADA system real-time data dump task queue comprises:
setting a dump task configuration table;
configuring the first dumping task T1 and the second dumping task T2 in the dumping task configuration table;
wherein, the dump task configuration table comprises: task numbering and collecting and dumping configuration information; the task numbers of the first dumping task T1 and the second dumping task T2 are different, and the acquisition and dumping configuration information are the same.
3. A method for real-time data dump during SCADA system upgrade according to claim 2, wherein the collecting and dumping configuration information comprises one or more of the following: task name, task type, data collection and dump program path, data collection and dump program name, collection task number and dump destination data table name.
4. The method for real-time data dump during SCADA system upgrade of claim 1, further comprising: after a SCADA system real-time data dump task queue is established, setting the main-standby relationship between the first dump task T1 and the second dump task T2;
the first dump task T1 is a main task, and the second dump task T2 is a standby task.
5. The method for real-time data dump during SCADA system upgrade of claim 1, wherein the starting the first dumping task T1 and the second dumping task T2 comprises:
respectively starting a first data acquisition and dump program A1 corresponding to the first dumping task T1 and a second data acquisition and dump program A2 corresponding to the second dumping task T2;
the operation information is accessed and recorded to the preset task synchronization table Y1 through the first data collecting and dumping program A1 and the second data collecting and dumping program A2.
6. A method for real-time data dump during SCADA system upgrade according to claim 5, wherein said task synchronization table Y1 comprises: task coding, task state, state change time and data dump time point; wherein the task encoding comprises: a first code M1 representing the main task and a second code M2 representing the standby task; the task states include: an operation state X1, a fault state X2, an application state X3, a continuous transmission state X4 and a working state X5.
7. The method for real-time data dump during upgrade of SCADA system as claimed in claim 6, wherein said applying for obtaining data dump right by said first dumping task T1 and executing normal data dump to write said real-time data into a preset relational database data table comprises:
setting the task state of the first dumping task T1 in the task synchronization table Y1 to be an application state X3 through the first data collecting and dumping program A1 so as to apply for the data dumping right;
after the data dump right is acquired, executing a normal data dump task process through the first data acquisition and dump program A1, and writing acquired real-time data into a preset first relational database data table W1; and setting the task state in the task synchronization table Y1 to be the working state X5, and updating the data dump time point and the state change time.
8. The method for real-time data dump during SCADA system upgrade according to claim 7, wherein the performing breakpoint transmission by the second dumping task T2 according to the real-time data stored in the second buffered data file when the first dumping task T1 fails due to program upgrade during data dump comprises:
the second dumping task T2 judges the fault of the first dumping task T1 through the task state of the task synchronization table Y1 and applies for acquiring the data dumping right;
acquiring a first data breakpoint B1 of the first dumping task T1 from a data dumping time point and a state change time of the task synchronization table Y1; the first data breakpoint B1 is a data breakpoint that was generated prior to the upgrade of the first data collection and dump program a1 as a result of closing the first data collection and dump program a 1;
and extracting the continuous data queue comprising the first data breakpoint B1 from the second buffer data file and executing a continuous transmission process to perform breakpoint continuous transmission.
9. The method for dumping real-time data during upgrading of a SCADA system according to claim 8, wherein the performing of breakpoint resuming by the first dumping task T1 according to the real-time data stored in the first buffered data file when the second dumping task T2 fails due to program upgrade or the first dumping task T1 is upgraded and completed comprises:
the first dumping task T1 judges the fault of the second dumping task T2 through the task state of the task synchronization table Y1 and applies for acquiring the data dumping right; acquiring a second data breakpoint B2 of the second dump task T2 from the data dump time point and the state change time of the task synchronization table Y1; the second data breakpoint B2 is a data breakpoint generated by closing the second data acquisition and dump program a2 prior to the upgrade of the second data acquisition and dump program a 2; or the upgraded first dumping task T1 actively applies for acquiring the data dumping right, and the second dumping task T2 exits from the normal data dumping task to generate the second data breakpoint B2;
the first destaging task T1 extracts the contiguous data queue including the second data breakpoint B2 from the first buffered data file and performs a resume process for a breakpoint resume.
10. A real-time data dump device for upgrading a data acquisition and monitoring control SCADA system comprises: processor and computer readable storage medium, having stored therein instructions, characterized in that when executed by the processor, a real-time data dump method at upgrade of a SCADA system according to any of claims 1-9 is implemented.
CN201810898847.4A 2018-08-08 2018-08-08 Real-time data dump method and device during SCADA system upgrade Active CN109116818B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810898847.4A CN109116818B (en) 2018-08-08 2018-08-08 Real-time data dump method and device during SCADA system upgrade

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810898847.4A CN109116818B (en) 2018-08-08 2018-08-08 Real-time data dump method and device during SCADA system upgrade

Publications (2)

Publication Number Publication Date
CN109116818A CN109116818A (en) 2019-01-01
CN109116818B true CN109116818B (en) 2020-03-17

Family

ID=64853105

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810898847.4A Active CN109116818B (en) 2018-08-08 2018-08-08 Real-time data dump method and device during SCADA system upgrade

Country Status (1)

Country Link
CN (1) CN109116818B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110297860B (en) * 2019-06-18 2024-01-26 杭州数梦工场科技有限公司 Data exchange method and device and related equipment
CN114326631A (en) * 2021-12-30 2022-04-12 苏伊士水务工程有限责任公司 Verification method and verification processing system for upgrading data acquisition and monitoring control system

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9996562B2 (en) * 2013-07-09 2018-06-12 Oracle International Corporation Automated database migration architecture
CN104731956B (en) * 2015-04-02 2019-07-23 北京奇虎科技有限公司 Method, system and the Relational database of synchrodata
CN106557364A (en) * 2015-09-24 2017-04-05 阿里巴巴集团控股有限公司 A kind of method of data synchronization and system
CN107423303B (en) * 2016-05-24 2021-02-26 北京京东尚科信息技术有限公司 Method and system for data synchronization
CN107908472A (en) * 2017-09-30 2018-04-13 平安科技(深圳)有限公司 Data synchronization unit, method and computer-readable recording medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
基于FPGA的高速数据转存系统;张鹏飞;《计算机系统应用》;20140215;第23卷(第6期);第86-90 *

Also Published As

Publication number Publication date
CN109116818A (en) 2019-01-01

Similar Documents

Publication Publication Date Title
CN109116818B (en) Real-time data dump method and device during SCADA system upgrade
CN114584539B (en) Cloud upgrading method and system for industrial field device
CN110063042A (en) A kind of response method and its terminal of database failure
CN115562911B (en) Virtual machine data backup method, device, system, electronic equipment and storage medium
CN112416957B (en) Data increment updating method and device based on data model layer and computer equipment
CN109150596B (en) SCADA system real-time data dump method and device
CN114911492A (en) Inference service deployment method, device, equipment and storage medium
CN109241029B (en) Method and device for realizing smooth migration of SCADA system database
CN113468143A (en) Data migration method, system, computing device and storage medium
US11431571B2 (en) Monitoring time-base policy domain architecture
CN109189599B (en) Method and device for improving real-time data dump stability of SCADA system
CN111209138A (en) Operation and maintenance method and device of data storage system
CN115604086A (en) Monitoring alarm fault self-healing method, device, equipment, medium and program product
CN113836223A (en) Heterogeneous database data synchronization method
CN113986237A (en) Method and device for creating Jenkins compiling task
CN114090541A (en) Database service processing method and device
JP5670935B2 (en) Distributed data management system and operation method thereof
CN116149707B (en) Method and device for detecting and avoiding upgrading risk of distributed system
US7743244B2 (en) Computer system model generation with tracking of actual computer system configuration
CN111159237A (en) System data distribution method and device, storage medium and electronic equipment
CN114841678B (en) Post data exchange method, data exchange system, server and storage medium
US20240070012A1 (en) Self-healing in container orchestration systems
CN112468327B (en) ICOS cluster-based address change method, device and medium
US8825610B1 (en) System management based on goals relevant to a current state of a managed system
CN117632559A (en) Fault disk repairing method and device, storage medium and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant