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
- data records
- storing
- 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
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 state of a large alarm group and a small alarm group, wherein the method comprises the following steps: establishing a process control station alarm group record information table, and adding two data records in the process control station information table, wherein one data record represents a large alarm group, and the other 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; a plurality of third and fourth data records are newly added in the measuring point information table, and the third 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 a third data record; the alarm information of the small alarm groups is stored 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 is displayed in real time by reading an online monitoring picture alarm state table.
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)
1. A method of storing a status of a size alarm group, comprising:
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.
2. The method of storing a size alarm group status of claim 1, wherein the addresses of the two data records are different from the original process control station address in the distributed control system.
3. The method of storing a size alarm group status of claim 1, wherein the address of the first data record is different from the address of the second data record.
4. The method of storing a size alarm group status of claim 1, wherein the first data record process control station name field is "large alarm group" and the second data record process control station name field is "small alarm group".
5. The method of storing a size alarm group status of claim 1, wherein a number of third data records are associated with the first data record, with each other in a many-to-one manner.
6. The method of storing a size alarm group status according to claim 1, wherein a number of fourth data records are associated with the second data record, with each other in a many-to-one manner.
7. The method of storing a size alarm group status according to claim 1, wherein the third data record and the fourth data record include a name field, an alarm being present field, an alarm acknowledge field, and an alarm priority field.
8. The method of storing the status of a size alarm group of claim 1, wherein the gauge point information table is a switch gauge point information table or an analog gauge point information table.
9. An apparatus for storing a size alarm group status, comprising at least one processor and a memory, the memory storing computer-executable instructions, the at least one processor executing the computer-executable instructions stored by the memory to perform the method of any of claims 1-8.
10. A computer-readable storage medium, characterized in that a computer-readable storage medium has stored therein program instructions which, when executed by a processor, implement the method of any one of claims 1-8.
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 |
|---|---|---|
| CN113553420B (en) | Power grid fault processing rule recommendation method and system based on knowledge graph | |
| CN113672743B (en) | Fault judging method, device, electronic equipment, storage medium and product | |
| CN105930330A (en) | Portal system page display method and apparatus | |
| CN106126374A (en) | Method for writing data, method for reading data and device | |
| CN105183898A (en) | Data sync method and data sync system | |
| CN111625418A (en) | Process monitoring method and 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 | |
| CN108413997B (en) | Augmented reality instrument system | |
| US8942854B2 (en) | System and method for identifying electrical devices in a power management system | |
| CN103838642A (en) | Data recovery method, device and system | |
| CN105897914B (en) | A kind of system and method for the areas efficient access I of the areas EMS system III information | |
| CN110888949A (en) | Equipment alarm shielding method, device, equipment and medium based on three-dimensional map | |
| CN105847978B (en) | A kind of formation gathering method and system based on smart television | |
| CN110958435A (en) | Digital production monitoring system | |
| CN110532258B (en) | Fault wave transmission method and device | |
| CN113837586A (en) | Virtual-real synchronous operation method and device of digital twin transformer substation | |
| CN112818648A (en) | Automatic leading-in method and system for power grid energy management system signboards | |
| CN111639100A (en) | Method and device for comparing capital construction and capital supply material design inventory and declaration information | |
| CN110704282A (en) | Monitoring information leakage detection method and system | |
| CN106355254A (en) | Power transmission line management method and system | |
| CN117555307B (en) | Multi-source heterogeneous production data acquisition system for aluminum alloy components | |
| JP3711944B2 (en) | Drawing data creation device | |
| CN114237657A (en) | Transformer substation secondary equipment software version control method and system | |
| CN114692224A (en) | Robot unique identifier representation method and device, electronic 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 |
Application publication date: 20210921 |
|
| RJ01 | Rejection of invention patent application after publication |