CN113420040A - Method, device and storage medium for storing large and small alarm group states - Google Patents
Method, device and storage medium for storing large and small alarm group states Download PDFInfo
- Publication number
- CN113420040A CN113420040A CN202110978622.1A CN202110978622A CN113420040A CN 113420040 A CN113420040 A CN 113420040A CN 202110978622 A CN202110978622 A CN 202110978622A CN 113420040 A CN113420040 A CN 113420040A
- Authority
- CN
- China
- Prior art keywords
- alarm
- alarm group
- group
- small
- data record
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000005259 measurement Methods 0.000 claims abstract description 16
- 238000012544 monitoring process Methods 0.000 claims abstract description 7
- 238000004886 process control Methods 0.000 claims description 27
- 238000010276 construction Methods 0.000 claims description 7
- 238000012790 confirmation Methods 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G08—SIGNALLING
- G08B—SIGNALLING OR CALLING SYSTEMS; ORDER TELEGRAPHS; ALARM SYSTEMS
- G08B21/00—Alarms responsive to a single specified undesired or abnormal condition and not otherwise provided for
- G08B21/18—Status alarms
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00002—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by monitoring
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Emergency Management (AREA)
- Power Engineering (AREA)
- Alarm Systems (AREA)
Abstract
本发明公开了一种存储大小报警组状态的方法、装置及存储介质，包括：构建过程控制站报警组记录信息表，采用在过程控制站信息表中新增两个数据记录，一个数据记录表示大报警组，另一个数据记录表示小报警组；基于测点信息表分别构建大、小报警组项表；采用在测点信息表中新增若干第三、第四数据记录，并将第三数据记录与第一数据记录关联，第四数据记录与第二数据记录关联；大报警组的报警信息存储在第三数据记录；小报警组的报警信息存储在若干第四数据记录中，每个报警组项存储对应报警项的报警状态信息，并由后台程序进行实时更新，通过读取在线监视画面报警状态表，实时显示各个报警组的状态。
The invention discloses a method, a device and a storage medium for storing the status of large and small alarm groups. Large alarm group, another data record represents the small alarm group; based on the measurement point information table, the large and small alarm group item tables are constructed respectively; a number of third and fourth data records are added in the measurement point information table, and the third and third data records are added to the measurement point information table. The data record is associated with the first data record, and the fourth data record is associated with the second data record; the alarm information of the large alarm group is stored in the third data record; the alarm information of the small alarm group is stored in several fourth data records, each of which is stored in the fourth data record. The alarm group item stores the alarm status information corresponding to the alarm item, and is updated in real time by the background program. By reading the alarm status table of the online monitoring screen, the status of each alarm group is displayed in real time.
Description
Technical Field
The invention relates to the technical field of monitoring and alarming of automatic control technology of a thermal power generating unit, in particular to a method, a device and a storage medium for realizing the storage of alarming states of large and small alarming groups based on an information table structure of a process control station and an information table structure of a measuring point.
Background
According to engineering requirements, the distributed control system configures measuring points to belong to a small alarm group, a plurality of small alarm groups belong to a large alarm group, the system has m large alarm groups and n small alarm groups, and m is larger than or equal to n. If one measuring point is in an alarm state, the small alarm group to which the measuring point belongs and the large alarm group to which the small alarm group belongs are in the alarm state, and the monitoring picture carries out alarm prompt according to the alarm state of the large alarm group and the small alarm group.
The alarm state information for each alarm group includes: whether the alarm group gives an alarm or not, whether the alarm group has been confirmed, and the priority of the alarm and the alarm confirmation, wherein the information needs to be stored in a real-time database and updated in real time by a background program so that an online monitoring picture can read the state of each alarm group.
In order to store the alarm states of the alarm groups of different sizes, a state data table of the alarm group and a state data table of the small alarm group are newly added in a real-time database to respectively store the alarm states of the alarm groups of different sizes and update data in real time, so that the maintenance cost of the database is increased by a method of adding an additional data table.
Disclosure of Invention
In order to solve the above-mentioned defects in the prior art, the present invention aims to provide a method, an apparatus and a storage medium for storing the status of large and small alarm groups based on process control stations and measurement point information tables.
The invention is realized by the following technical scheme.
In a first aspect of the invention, a method for storing the status of a large alarm group and a small alarm group based on a process control station and a measurement point information table is provided, which comprises the following steps:
constructing a process control station alarm group record information table, comprising:
two data records are newly added in a process control station information table, wherein the first data record represents a large alarm group, and the second data record represents a small alarm group;
respectively constructing a large alarm item list and a small alarm item list based on the measuring point information list, wherein the large alarm item list and the small alarm item list comprise the measuring point information list;
the large alarm group item table construction process: adding a plurality of third data records in the measuring point information table, and associating the third data records with the first data records;
the small alarm group item table construction process: adding a plurality of fourth data records in the measuring point information table, and associating the fourth data records with the second data records;
correspondingly storing the alarm information of the large alarm group in a plurality of third data records; correspondingly storing the alarm information of the small alarm group in a plurality of fourth data records; and each alarm group item stores the alarm state information of the corresponding alarm item, is updated in real time by a background program, and displays the state of each alarm group in real time by reading the alarm state table of the online monitoring picture.
With respect to the above technical solutions, the present invention has a further preferable solution:
preferably, the addresses of the two data records are different from the original process control station addresses in the decentralized control system.
Preferably, the address of the first data record is different from the address of the second data record.
Preferably, the first data record process control station name field is a "large alarm group" and the second data record process control station name field is a "small alarm group".
Preferably, a plurality of third data records are associated with the first data record in a many-to-one manner.
Preferably, a plurality of fourth data records are associated with the second data record in a many-to-one manner.
Preferably, the third data record and the fourth data record include a name field, an alarm present field, an alarm acknowledge field, and an alarm priority field.
Preferably, the measurement point information table is a switch measurement point information table or an analog measurement point information table.
In a second aspect of the present invention, there is provided an apparatus for storing a size alarm group status, comprising a processor and a memory, the memory storing computer-executable instructions, and the processor executing the computer-executable instructions stored in the memory to perform the method of the first aspect.
In a third aspect of the invention, a computer-readable storage medium is provided, in which program instructions are stored, which program instructions, when executed by a processor, implement the method of the first aspect.
Due to the adoption of the technical scheme, the invention has the following beneficial effects:
the alarm group record table is based on the process control station information table, the large alarm group item table and the small alarm item table are based on the measuring point information table, and the process control station information table and the measuring point information table can be modified.
By adopting the method, an alarm group state table is not additionally arranged in the real-time database, so that the maintenance expense of the database is reduced, and the safety of the system is ensured.
The advantage of using the process control station information table and the measurement point information table is that: fields set in the measuring point information table can be matched with the alarm information of the large alarm group and the small alarm group, so that the storage requirement is met; the alarm group record table and the alarm group item table can be updated in real time through a data acquisition program, storage of alarm information is met, accuracy of a storage result is guaranteed, and timeliness of storage of the alarm information is guaranteed.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the principles of the invention:
FIG. 1 is a flow chart of the method of the present invention;
FIG. 2 is a schematic structural diagram of a device for implementing the large and small alarm group status storage according to the present invention;
FIG. 3 is a flow chart of an embodiment of the present invention.
Detailed Description
The present invention will now be described in detail with reference to the drawings and specific embodiments, wherein the exemplary embodiments and descriptions of the present invention are provided to explain the present invention without limiting the invention thereto.
As shown in fig. 1, the method for implementing a state storage of a large alarm group based on a process control station and a station information table according to the first aspect of the present invention includes the following steps:
step 1, constructing an alarm group record table; wherein the alarm group record table is based on a process control station information table;
the construction process comprises the following steps: two data records are newly added in an information table of the process control station, wherein the first data record represents a large alarm group, the name field of the process control station is a large alarm group, the second data record represents a small alarm group, and the name field of the process control station is a small alarm group.
The addresses of the two data records are different from the original process control station address in the distributed control system, and the address of the first data record is different from the address of the second data record.
Step 2, respectively constructing a large alarm item list and a small alarm item list; wherein, the large alarm group item table and the small alarm item table are both based on the measuring point information table.
The large alarm group item table construction process: and adding a plurality of third data records in the measuring point information table, and associating the third data records with the first data records (in one embodiment, associating the third data records with the first data records in a many-to-one manner).
The small alarm group item table construction process: and adding a plurality of fourth data records in the measuring point information table, and associating the fourth data records with the second data records (in one embodiment, associating the fourth data records with the second data records in a many-to-one manner).
Step 3, correspondingly storing the alarm information of the large alarm group in a plurality of third data records; and correspondingly storing the alarm information of the small alarm groups in a plurality of fourth data records. Each alarm group item stores the alarm state information of the corresponding alarm item, the alarm state information is updated in real time by a background program, and the state of each alarm group can be displayed in real time by reading the alarm state table of the online monitoring picture.
The third data record and the fourth data record comprise a name field, an alarm-in-progress field, an alarm confirmation field and an alarm priority field.
The measuring point information table is a switch measuring point information table or an analog measuring point information table.
The process control station information table and the measurement point information table are given below
1) Process control station information sheet
OID (object identifier) is used to uniquely identify a database object throughout the database.
2) Measuring point information table
The second aspect of the present invention, including the means for storing the status of the size alarm group used in the method, is shown in fig. 2 and includes a processor 21 and a memory 22, the memory storing computer-executable instructions, the processor executing the computer-executable instructions stored in the memory to perform the method described herein. The computer readable storage medium has stored therein program instructions that, when executed by a processor, implement the method described.
The invention is further illustrated by the following specific example.
And storing the alarm group item information by adopting a switch measurement point information table.
The alarm state for the large alarm group name "large alarm 1 group" is updated, as shown in FIG. 3, giving an alarm group update procedure.
And traversing the process control station alarm group record information table, and if the name field of the current record is not the large alarm group, continuing to search the next record until the record with the name field of the process control station as the large alarm group is found.
And finding out all large alarm items associated with the large alarm group in the large alarm group item table, and acquiring all large alarm group items recorded by the large alarm group.
And traversing the large alarm group item, if the currently recorded measuring point name field is not a large alarm 1 group, continuously searching the next record until the record with the measuring point name field being a large alarm 1 group is found, and updating the alarm field, the alarm confirmation field and the alarm priority field of the record.
It can be seen from the above embodiments that, the present invention stores the status information of the large and small alarm groups by using the process control station information table and the measurement point information table, and the updating of the large and small alarm groups can be rapidly realized without additionally adding an alarm group status table in the real-time database, thereby reducing the maintenance overhead of the database.
The present invention is not limited to the above-mentioned embodiments, and based on the technical solutions disclosed in the present invention, those skilled in the art can make some substitutions and modifications to some technical features without creative efforts according to the disclosed technical contents, and these substitutions and modifications are all within the protection scope of the present invention.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110978622.1A CN113420040A (en) | 2021-08-25 | 2021-08-25 | Method, device and storage medium for storing large and small alarm group states |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110978622.1A CN113420040A (en) | 2021-08-25 | 2021-08-25 | Method, device and storage medium for storing large and small alarm group states |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113420040A true CN113420040A (en) | 2021-09-21 |
Family
ID=77719418
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110978622.1A Pending CN113420040A (en) | 2021-08-25 | 2021-08-25 | Method, device and storage medium for storing large and small alarm group states |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113420040A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108958959A (en) * | 2017-05-18 | 2018-12-07 | 北京京东尚科信息技术有限公司 | The method and apparatus for detecting hive tables of data |
| CN109299121A (en) * | 2018-09-13 | 2019-02-01 | 南京国电南自轨道交通工程有限公司 | A kind of efficient querying method of SCADA system history alarm |
| CN112132994A (en) * | 2020-09-22 | 2020-12-25 | 深圳市森克普科技有限公司 | Monitoring method and system for analyzing driver behavior based on real-time data |
| CN112565686A (en) * | 2020-11-25 | 2021-03-26 | 航天银山电气有限公司 | Intelligent substation video linkage monitoring method, system and medium |
| CN112783102A (en) * | 2019-11-06 | 2021-05-11 | 中国石油化工股份有限公司 | Memory, refining device operation risk early warning method, system and device |
-
2021
- 2021-08-25 CN CN202110978622.1A patent/CN113420040A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108958959A (en) * | 2017-05-18 | 2018-12-07 | 北京京东尚科信息技术有限公司 | The method and apparatus for detecting hive tables of data |
| CN109299121A (en) * | 2018-09-13 | 2019-02-01 | 南京国电南自轨道交通工程有限公司 | A kind of efficient querying method of SCADA system history alarm |
| CN112783102A (en) * | 2019-11-06 | 2021-05-11 | 中国石油化工股份有限公司 | Memory, refining device operation risk early warning method, system and device |
| CN112132994A (en) * | 2020-09-22 | 2020-12-25 | 深圳市森克普科技有限公司 | Monitoring method and system for analyzing driver behavior based on real-time data |
| CN112565686A (en) * | 2020-11-25 | 2021-03-26 | 航天银山电气有限公司 | Intelligent substation video linkage monitoring method, system and medium |
Non-Patent Citations (2)
| Title |
|---|
| 刘传峰: "船舶机舱监控报警系统软件设计与实现", 《中国优秀硕士学位论文全文数据库》 * |
| 蔡宇,蔡婷，霍敏霞: "《Web应用程序设计 ASP.NET》", 29 February 2016 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8805760B2 (en) | Historians embedded in industrial units | |
| CN113672743B (en) | Fault judging method, device, electronic equipment, storage medium and product | |
| CN106126374A (en) | Method for writing data, method for reading data and device | |
| CN112632342A (en) | Data query method and device, storage medium and electronic equipment | |
| JP2004199258A (en) | Process monitoring device | |
| CN114254008B (en) | Information generation method and device and electronic equipment | |
| CN113420040A (en) | Method, device and storage medium for storing large and small alarm group states | |
| CN111367924A (en) | Data synchronization method and device, electronic equipment and storage medium | |
| CN103838642A (en) | Data recovery method, device and system | |
| CN205608465U (en) | Operation and maintenance system based on information code recognition technology | |
| CN111522850A (en) | Data object storage and query method, device, equipment and storage medium | |
| CN110309144A (en) | A kind of method and device with redis building tree form data structure | |
| CN110768859A (en) | A method for automatic detection of application health based on time series data | |
| CN114529677A (en) | Scene temperature cloud chart generation method and device, storage medium and electronic equipment | |
| CN108737774A (en) | a network security system | |
| CN110958435A (en) | Digital production monitoring system | |
| JP2007233567A (en) | Plant monitoring system | |
| CN117097599B (en) | Network service detection method, device, computer equipment and storage medium | |
| JP2011175530A (en) | Plant operation support device | |
| JP2018106565A (en) | Display method, display program, and display system | |
| CN118779503A (en) | A port display method, device and medium based on image recognition | |
| JPWO2020046916A5 (en) | ||
| CN116841960A (en) | Device file management method and device | |
| CN115048399A (en) | Database information processing method and device, storage medium and electronic equipment | |
| CN115905404A (en) | High-timeliness data intelligent synchronization method, system, equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210921 |