Method and system for monitoring and alarming fire pool in transformer substation

Abstract

The invention discloses a method and a system for monitoring and alarming a fire pool in a transformer substation, and relates to the technical field of Internet of Things. The method comprises the steps that a target monitoring record is acquired from a monitoring auxiliary database, the monitoring auxiliary database is at least used for storing ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained after the water level height of a fire pool in a transformer substation is measured through an ultrasonic sensor; performing alarm analysis on the target monitoring record to obtain an analysis result; and controlling the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis result. The technical problems that time and labor are consumed due to manual regular on-site inspection in the prior art, and hidden dangers are brought to safe operation of the transformer substation are solved.

Description

Technical Field

[0001] The present invention relates to the technical field of Internet of Things, and in particular to a fire water pool monitoring and alarming method and system in a substation. Background Art

[0002] The fire water pool in the substation is the main fire water source in the substation. The adequacy of its water level is directly related to the water supply capacity of the fire protection system. By regularly testing the water level, it can be ensured that the amount of water in the pool is always above the standard that meets the fire protection needs, so that sufficient fire water can be quickly provided when a fire occurs. In the face of sudden fires, it is crucial to regularly test the water level of the fire water pool in order to respond quickly and accurately. The traditional way is to conduct regular on-site inspections manually.

[0003] Manual regular on-site inspections require round-trip inspections between substations, which is time-consuming and laborious. In addition, water level detection using simple tools such as water level gauges and water gauges may result in certain errors and inconveniences. During rainy or dry seasons, the frequency of inspections may need to be increased to cope with water level fluctuations. This periodic inspection will result in defects not being discovered in time, posing a hidden danger to the safe operation of the substation. Summary of the invention

[0004] The embodiment of the present invention provides a fire water pool monitoring and alarm method and system in a substation, so as to at least solve the technical problems of related technologies that are time-consuming and labor-intensive due to regular manual on-site inspections, and bring hidden dangers to the safe operation of the substation.

[0005] According to one embodiment of the present invention, a fire water tank monitoring and alarm method in a substation is provided, comprising: obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, the ultrasonic sensor monitoring data being obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor; performing alarm analysis on the target monitoring record to obtain an analysis result; and controlling a target office device to send an Ethernet connection alarm message to a target object based on the analysis result.

[0006] Optionally, at least a telemetry data table is stored in the monitoring auxiliary database, and obtaining target monitoring records from the monitoring auxiliary database includes: obtaining target monitoring records that meet preset collection conditions from the telemetry data table of the monitoring auxiliary database according to a preset period, wherein the preset collection conditions are determined based on the data type and the collection time.

[0007] Optionally, the monitoring auxiliary database also stores an alarm rule configuration table and an alarm record table, and performs alarm analysis on the target monitoring record to obtain analysis results including: obtaining the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the collection value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, obtaining the associated alarm rule identifier as the identifier of the telemetry point coded data record and the unarchived query record from the alarm record table; based on the target monitoring record, the telemetry point coded data record and the query record, perform alarm analysis on the target monitoring record to obtain analysis results.

[0008] Optionally, based on the target monitoring records, telemetry point coded data records and query records, an alarm analysis is performed on the target monitoring records, and the analysis results include: based on the target monitoring records, telemetry point coded data records and query records, an alarm analysis is performed on the target monitoring records to obtain the alarm type of the target monitoring records; determine whether the alarm type meets the alarm requirements to obtain the analysis results.

[0009] Optionally, based on the target monitoring record, the telemetry point coded data record and the query record, an alarm analysis is performed on the target monitoring record, and the alarm type of the target monitoring record is obtained, including: in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, the reset time of the query record is not empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetry point coded data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetry point coded data record, it is determined that the alarm type is that the acquisition value of the target monitoring record is upgraded to a second-order upper limit alarm after resetting to a first-order upper limit, and the query record is reset to a second-order upper limit alarm. The second-order alarm value is updated to the acquisition value of the target monitoring record, the second-order crossing time of the query record is updated to the acquisition time of the query record, and the record type of the query record is marked as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, and the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coding data record, the alarm type is determined to be that the acquisition value of the target monitoring record continues to cross the second-order upper limit alarm after the last alarm reset, and the record type of the query record is marked as a second-order frequent signal; in response to the acquisition value of the target monitoring record is greater than the second-order upper limit value of the telemetering point coded data record, the reset time of the query record is empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetering point coded data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetering point coded data record, the alarm type is determined to be that the acquisition value of the target monitoring record is converted to a second-order upper limit alarm during the non-reset period of the first-order upper limit, the second-order alarm value of the query record is updated to the acquisition value of the target monitoring record, and the second-order time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coded data record The second-order upper limit value, the reset time of the query record is empty, the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coded data record, and the alarm type is determined to be the acquisition value of the target monitoring record continuously crossing the second-order upper limit alarm; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, the last alarm and the second-order alarm value of the query record are both empty, and the alarm type is determined to be the acquisition value of the target monitoring record crossing the second-order upper limit alarm for the first time, the second-order alarm value of the query record is updated to the acquisition value of the target monitoring record, and the second-order time of the query record is updated to the acquisition time of the query record.

[0010] Optionally, based on the target monitoring record, the telemetry point coded data record and the query record, an alarm analysis is performed on the target monitoring record, and the alarm type of the target monitoring record is obtained, including: in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coded data record, the reset time of the query record is not empty, and the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coded data record, it is determined that the alarm type is that the acquisition value of the target monitoring record briefly resets after sending the second-order alarm and this acquisition exceeds the first-order upper limit value, and the query record is The first-order alarm time is updated to the collection time of the query record, the number of first-order alarms of the query record is recorded as 0, and the record type of the query record is marked as a frequent signal; in response to the collection value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the collection value of the target monitoring record is less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, and the last alarm value of the query record is less than the second-order upper limit value of the telemetry point coding data record, it is determined that the alarm type is that the collection value of the target monitoring record briefly resets after sending the first-order alarm and this collection exceeds the first-order upper limit value, and the reset time of the query record is The query record is updated to be empty, the first-order alarm value of the query record is recorded as the acquisition value of the target monitoring record, the alarm time of the query record is updated to the acquisition time of the query record, and the record type of the query record is marked as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record being empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetry point coding data record, the alarm type is determined to be after the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coding data record Reduced to the first-order upper limit value of the telemetering point coded data record, and in response to the second-order alarm value of the query record being not empty, the first-order alarm value of the query record is recorded as the acquisition value of the target monitoring record, and the alarm time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetering point coded data record, and the reset time and alarm time of the query record are both empty, it is determined that the alarm type is that the acquisition value of the target monitoring record exceeds the first-order upper limit value of the telemetering point coded data record, and no alarm has been issued yet.

[0011] Optionally, based on the target monitoring record, the telemetry point coded data record and the query record, an alarm analysis is performed on the target monitoring record, and the alarm type of the target monitoring record is obtained, including: in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coded data record, the reset time of the query record is empty, the alarm time of the query record is not empty, determining that the alarm type is that the acquisition value of the target monitoring record is reset in this acquisition after the alarm is issued, updating the first-order alarm value of the query record to the acquisition value of the target monitoring record, and updating both the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record ; In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both not empty, and the alarm type is determined to be that the acquisition value of the target monitoring record has been reset, but the time for issuing a reset alarm has not been reached; In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both empty, and the alarm type is determined to be that the acquisition time of the target monitoring record has not reached the reset delay of the telemetry point coding data record and has been reset, and the archive mark of the query record is updated.

[0012] Optionally, the monitoring auxiliary database also stores an alarm rule configuration table and an alarm record table, and performs alarm analysis on the target monitoring record to obtain the analysis result, including: obtaining the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, and there is no query record in the alarm record table whose associated alarm rule identifier is the identifier of the telemetry point coded data record and is not archived, recording the acquisition value of the target monitoring record as the second-order upper limit value of the telemetry point coded data record, and generating a first alarm content based on the target monitoring record to obtain the analysis result; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and there is no query record in the alarm record table whose associated alarm rule identifier is the identifier of the telemetry point coded data record and is not archived, recording the acquisition value of the target monitoring record as the first-order upper limit value of the telemetry point coded data record, and generating a second alarm content based on the target monitoring record to obtain the analysis result.

[0013] Optionally, determining whether the alarm type meets the alarm requirement and obtaining an analysis result includes: in response to the alarm type being that the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coding data record, the difference between the acquisition time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coding data record, the number of second-order alarms sent in the query record is less than the number of second-order alarms recorded in the telemetry point coding data record, generating a third alarm content based on the target monitoring record to obtain an analysis result; in response to the alarm type being that the acquisition value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record The upper limit value, the difference between the acquisition time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coding data record, the number of first-order alarms sent in the query record is less than the number of first-order alarms recorded in the telemetry point coding data record, and a fourth alarm content is generated based on the target monitoring record to obtain an analysis result; in response to an alarm reset of the target monitoring record whose alarm type is an alarm reset, the difference between the acquisition time of the target monitoring record and the reset time of the query record is greater than or equal to the reset delay of the telemetry point coding data record, and a fifth alarm content is generated based on the target monitoring record to obtain an analysis result.

[0014] According to one embodiment of the present invention, there is also provided a fire water tank monitoring and alarm system in a substation, including: a monitoring auxiliary analysis device, an Ethernet connection control device, an edge gateway and an ultrasonic sensor; the ultrasonic sensor is used to measure the water level height of the fire water tank in the substation to obtain ultrasonic sensor monitoring data; the edge gateway is used to report the ultrasonic sensor monitoring data to the monitoring auxiliary database to generate target monitoring records; the monitoring auxiliary analysis device is used to obtain the target monitoring records from the monitoring auxiliary database, and perform alarm analysis on the target monitoring records to obtain analysis results; the Ethernet connection control device is used to control the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis results.

[0015] According to one embodiment of the present invention, there is also provided a fire water tank monitoring and alarm device in a substation, including: an acquisition module, used to obtain target monitoring records from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of the fire water tank in the substation using an ultrasonic sensor; an analysis module, used to perform alarm analysis on the target monitoring records to obtain analysis results; and a control module, used to control the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis results.

[0016] Optionally, the acquisition module is also used to obtain target monitoring records that meet preset collection conditions from the telemetry data table of the monitoring auxiliary database according to a preset period, wherein the preset collection conditions are determined based on the data type and the collection time.

[0017] Optionally, the acquisition module is also used to obtain the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the collection value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, obtain the query record whose associated alarm rule identifier is the identifier of the telemetry point coded data record and which is not archived from the alarm record table; based on the target monitoring record, the telemetry point coded data record and the query record, perform alarm analysis on the target monitoring record to obtain analysis results.

[0018] Optionally, the analysis module is also used to perform alarm analysis on the target monitoring records based on the target monitoring records, telemetry point coding data records and query records, obtain the alarm type of the target monitoring records; determine whether the alarm type meets the alarm requirements, and obtain analysis results.

[0019] Optionally, the analysis module is also used to respond to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetry point coding data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetry point coding data record, determine that the alarm type is that the acquisition value of the target monitoring record is upgraded to a second-order upper limit alarm after resetting to the first-order upper limit, update the second-order alarm value of the query record to the acquisition value of the target monitoring record, and update the second-order time of the query record to the query record. In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, and the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coding data record, the alarm type is determined to be the acquisition value of the target monitoring record continuing to cross the second-order upper limit alarm after the last alarm reset, and the record type of the query record is marked as a second-order frequent signal; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, and the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is determined to be the acquisition value of the target monitoring record continuously crossing ... The return time is empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetering point coded data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetering point coded data record, and the alarm type is determined to be that the acquisition value of the target monitoring record is converted to a second-order upper limit alarm during the non-reset period of crossing the first-order upper limit, and the second-order alarm value of the query record is updated to the acquisition value of the target monitoring record, and the second-order time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coded data record, the query record is reset. The return time is empty, the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coded data record, and the alarm type is determined to be the target monitoring record's acquisition value continuously crossing the second-order upper limit alarm; in response to the target monitoring record's acquisition value being greater than the second-order upper limit value of the telemetry point coded data record, the last alarm and the second-order alarm value of the query record are both empty, and the alarm type is determined to be the target monitoring record's acquisition value crossing the second-order upper limit alarm for the first time, and the second-order alarm value of the query record is updated to the target monitoring record's acquisition value, and the second-order time of the query record is updated to the acquisition time of the query record.

[0020] Optionally, the analysis module is further used to respond to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetry point coding data record, determine that the alarm type is that the acquisition value of the target monitoring record is temporarily reset after sending the second-order alarm and this acquisition exceeds the first-order upper limit value, update the first-order alarm time of the query record to the acquisition time of the query record, and record the number of first-order alarms in the query record as 0, And mark the record type of the query record as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetry point coding data record, determine that the alarm type is that the acquisition value of the target monitoring record briefly resets after sending the first-order alarm and this acquisition exceeds the first-order upper limit value, update the reset time of the query record to empty, and record the first-order alarm value of the query record as the target monitoring record. The acquisition value of the query record is updated to the acquisition time of the query record, and the record type of the query record is marked as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record is empty, and the last alarm value of the query record is less than the second-order upper limit value of the telemetering point coding data record, it is determined that the alarm type is the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetering point coding data record and then drops to the value of the telemetering point coding data record. , and in response to the query record's second-order alarm value being not empty, the first-order alarm value of the query record is recorded as the acquisition value of the target monitoring record, and the alarm time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and the reset time and the alarm time of the query record are both empty, it is determined that the alarm type is that the acquisition value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coded data record, and no alarm has been issued yet.

[0021] Optionally, the analysis module is also used to, in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record being empty, and the alarm time of the query record being not empty, determine that the alarm type is that the acquisition value of the target monitoring record is reset in the current acquisition after the alarm is issued, update the first-order alarm value of the query record to the acquisition value of the target monitoring record, and update the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record; in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record being not empty, determine that the alarm type is that the acquisition value of the target monitoring record has been reset, but has not reached the time for issuing the reset alarm; in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record being empty, determine that the alarm type is that the acquisition time of the target monitoring record has not reached the reset delay of the recorded telemetry point coding data record and has been reset, and update the archiving mark of the query record.

[0022] Optionally, the analysis module is also used to obtain the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table whose associated alarm rule is identified as the identifier of the telemetry point coded data record and which is not archived, the acquisition value of the target monitoring record is recorded as the second-order upper limit value of the telemetry point coded data record, and a first alarm content is generated based on the target monitoring record to obtain an analysis result; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table whose associated alarm rule is identified as the identifier of the telemetry point coded data record and which is not archived, the acquisition value of the target monitoring record is recorded as the first-order upper limit value of the telemetry point coded data record, and a second alarm content is generated based on the target monitoring record to obtain an analysis result.

[0023] Optionally, the analysis module is also used to generate a third alarm content based on the target monitoring record to obtain an analysis result in response to the alarm type being that the collection value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coding data record, the difference between the collection time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coding data record, and the number of times the second-order alarm of the query record has been sent is less than the number of second-order alarms of the telemetry point coding data record; in response to the alarm type being that the collection value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record, the target monitoring The difference between the recorded collection time and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coded data record, the number of first-order alarms sent in the query record is less than the number of first-order alarms recorded in the telemetry point coded data record, and a fourth alarm content is generated based on the target monitoring record to obtain an analysis result; in response to an alarm reset whose alarm type is a target monitoring record, the difference between the collection time of the target monitoring record and the reset time of the query record is greater than or equal to the reset delay of the telemetry point coded data record, and a fifth alarm content is generated based on the target monitoring record to obtain an analysis result.

[0024] According to one embodiment of the present invention, a computer-readable storage medium is further provided, in which a computer program is stored, wherein the computer program is configured to execute any of the above-mentioned methods for monitoring and alarming a fire water tank in a substation when running on a computer or a processor.

[0025] According to one embodiment of the present invention, there is also provided an electronic device, including a memory and a processor, wherein the memory stores a computer program, and the processor is configured to run the computer program to execute any of the above methods for monitoring and alarming a fire water pool in a substation.

[0026] According to one embodiment of the present invention, there is also provided a computer program product, including a computer program, which implements any of the above-mentioned fire water pool monitoring and alarm methods in a substation when executed by a processor.

[0027] In an embodiment of the present invention, target monitoring records are obtained from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor; an alarm analysis is performed on the target monitoring records to obtain an analysis result; based on the analysis result, the target office equipment is controlled to send an Ethernet connection alarm message to the target object, thereby achieving the purpose of effectively reducing the labor intensity of personnel and improving the safety and reliability of substation operation, thereby achieving the technical effect of using an automatic water level detection device to realize real-time monitoring of water levels, intelligent alarms and data aggregation through equipment such as ultrasonic sensors and edge gateways, thereby solving the technical problems of related technologies that are time-consuming and labor-intensive due to regular manual on-site inspections, and that pose hidden dangers to the safe operation of substations. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0029] Figure 1 is a flow chart of a method for monitoring and alarming a fire water pool in a substation according to one embodiment of the present invention;

[0030] Figure 2 This is a data flow diagram of a fire water pool monitoring and alarm method in a substation according to one embodiment of the present invention;

[0031] Figure 3 is a flowchart of a method for monitoring and alarming a fire water pool in a substation according to one embodiment of the present invention;

[0032] Figure 4 It is a structural block diagram of a fire water pool monitoring and alarm device in a substation according to one embodiment of the present invention. DETAILED DESCRIPTION

[0033] To facilitate understanding, some descriptions of concepts related to the embodiments of the present invention are exemplarily provided for reference.

[0034] As shown below:

[0035] Fire pool monitoring and alarm system: a device used to monitor the water level, water quality, temperature and other parameters of the fire pool. Once an abnormal situation is detected, it will immediately send out an alarm signal so that firefighters can deal with it in time.

[0036] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0037] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In the description of this embodiment, unless otherwise specified, the meaning of "multiple" is two or more. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0038] According to one embodiment of the present invention, an embodiment of a fire water pool monitoring and alarm method in a substation is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0039] The method embodiment can be executed in an electronic device including a memory and a processor, a similar control device or a system. Taking an electronic device as an example, the electronic device may include one or more processors and a memory for storing data. Optionally, the electronic device may also include a communication device and a display device for communication functions. It can be understood by a person of ordinary skill in the art that the above structural description is only illustrative and does not limit the structure of the above electronic device. For example, the electronic device may also include more or fewer components than the above structural description, or have a configuration different from the above structural description.

[0040] The processor may include one or more processing units. For example, the processor may include a central processing unit (CPU), a graphics processing unit (GPU), a digital signal processing (DSP) chip, a microcontroller unit (MCU), a field-programmable gate array (FPGA), a neural network processor (NPU), a tensor processing unit (TPU), an artificial intelligence (AI) type processor, and the like. Among them, different processing units may be independent components or integrated into one or more processors. In some instances, the electronic device may also include one or more processors.

[0041] The memory can be used to store computer programs, for example, to store the computer program corresponding to the fire water pool monitoring and alarm method in the substation in the embodiment of the present invention. The processor implements the above-mentioned fire water pool monitoring and alarm method in the substation by running the computer program stored in the memory. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory may further include a memory remotely arranged relative to the processor, and these remote memories can be connected to the electronic device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0042] The communication device is used to receive or send data via a network. The specific example of the above network may include a wireless network provided by a communication provider of the mobile terminal. In one example, the communication device includes a network adapter (network interface controller, NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the communication device can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0043] The display device may be, for example, a touch screen type liquid crystal display (LCD) and a touch display (also referred to as a "touch screen" or "touch display screen"). The liquid crystal display may enable a user to interact with a user interface of a mobile terminal. In some embodiments, the mobile terminal has a graphical user interface (GUI), and a user may interact with the GUI by finger contact and / or gestures on a touch-sensitive surface, wherein the human-computer interaction functions here may optionally include the following interactions: creating web pages, drawing, word processing, making electronic documents, games, video conferencing, instant messaging, sending and receiving emails, call interfaces, playing digital videos, playing digital music and / or web browsing, etc. The executable instructions for executing the above human-computer interaction functions are configured / stored in a computer program product or a readable storage medium executable by one or more processors.

[0044] In this embodiment, a fire water tank monitoring and alarm method in a substation running on an electronic device is provided. Figure 1 FIG. 1 is a flow chart of a method for monitoring and alarming a fire water pool in a substation according to one embodiment of the present invention. Figure 1 As shown, the process includes the following steps:

[0045] Step S10, obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is used to store at least ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor;

[0046] In the embodiment of the present invention, the monitoring auxiliary database can be understood as a database storing data related to the fire water tank in the substation. Exemplarily, the monitoring auxiliary database contains a personnel information table, an alarm rule configuration table, an alarm record table, a transmission information record table, a telemetry data table, a frequent signal table, etc., wherein the telemetry data table stores various data collected from the substation, including the water level height data of the fire water tank, which is not limited here.

[0047] The target monitoring record can be understood as the monitoring data or information about the water level of the fire water tank obtained through the monitoring equipment or system. For example, the target monitoring record can be the water level height of the fire water tank, which is not limited here.

[0048] The edge gateway can be understood as a device for monitoring and managing the status and water level of the fire water pool and reporting monitoring data. For example, the edge gateway can receive data collected by the ultrasonic sensor and send the data to the monitoring auxiliary database and store it in the telemetry data table, which is not limited here.

[0049] The ultrasonic sensor can be understood as a device for collecting the status and water level data of the fire water pool. For example, the ultrasonic sensor can be installed on the fire water pool and used to measure the height of the water level in the fire water pool, which is not limited here.

[0050] The water level can be understood as a data indicator that reflects whether there is sufficient water in the fire water tank.

[0051] Acquiring target monitoring records from the monitoring auxiliary database can be understood as querying and extracting record information of specific monitoring targets through the database system. Exemplarily, the water level height data of the fire water tank is queried and extracted through the database system, which is not limited here.

[0052] In an embodiment of the present invention, target monitoring records are obtained from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor. Thus, the monitoring data stored in the database can be used for data analysis to find out the changing trend of the water level height, predict possible problems, and take measures in advance.

[0053] Step S11, performing alarm analysis on the target monitoring record to obtain analysis results;

[0054] In the embodiment of the present invention, the alarm analysis can be understood as an analysis of whether the target monitoring record meets the preset fire pool water level condition. Exemplarily, the abnormal situation or trend in the monitoring record is analyzed based on the relevant data of the fire pool, which is not limited here.

[0055] The analysis result can be understood as the conclusion obtained after the alarm analysis of the target monitoring record. For example, the analysis result can include information such as whether the water level of the fire water pool is normal, which is not limited here.

[0056] Performing alarm analysis on the target monitoring record and obtaining the analysis result can be understood as analyzing whether the target monitoring record meets the preset fire pool water level condition and giving the analysis conclusion. For example, the abnormal situation or trend in the monitoring record can be analyzed and the alarm information can be generated to draw a conclusion whether the fire pool water level is normal, which is not limited here.

[0057] In the embodiment of the present invention, the relevant data of the fire water pool is monitored and recorded, and an alarm analysis is performed on it so as to timely discover and solve possible problems or risks. Through the analysis results, the operation of the fire water pool can be better understood, abnormal situations can be handled in time, and the normal operation and safety of the fire water pool can be ensured.

[0058] Step S12: Based on the analysis result, the target office device is controlled to send an Ethernet connection alarm message to the target object.

[0059] In the embodiment of the present invention, the target office equipment can be understood as a device for sending alarm information.

[0060] The target object can be understood as the relevant person who receives the alarm information.

[0061] The Ethernet connection alarm message can be understood as a way of sending alarm information. For example, ELINK can be used to send the Ethernet connection alarm message to the target object, which is not limited here.

[0062] Controlling the target office equipment to send Ethernet connection alarm messages to the target object based on the analysis results can be understood as controlling the equipment used to send alarm information to send ELINK alarm messages to relevant personnel based on the conclusion drawn after alarm analysis of the target monitoring records, which is not restricted here.

[0063] In an embodiment of the present invention, the target office equipment is controlled to send an Ethernet connection alarm message to the target object based on the analysis results, so that relevant personnel can be informed of various conditions of the fire water pool in a timely manner, and the staff can deal with the safety hazards of the fire water pool in a timely manner, thereby ensuring the normal operation and safety of the fire water pool.

[0064] By obtaining the target monitoring record from the monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store the ultrasonic sensor monitoring data reported by the edge gateway, the ultrasonic sensor monitoring data is obtained by measuring the water level of the fire water tank in the substation using the ultrasonic sensor, so that the monitoring data stored in the database can be used for data analysis to find out the changing trend of the water level, predict possible problems, and take measures in advance. The relevant data of the fire water tank is monitored and recorded, and an alarm analysis is performed on it to timely discover and solve possible problems or risks. Through the analysis results, the operation of the fire water tank can be better understood, abnormal situations can be handled in time, and the normal operation and safety of the fire water tank can be ensured. Based on the analysis results, the target office equipment is controlled to send an Ethernet connection alarm message to the target object, so that the various situations of the fire water tank can be promptly informed to the relevant personnel, and the staff can promptly deal with the safety hazards of the fire water tank, ensuring the normal operation and safety of the fire water tank.

[0065] Through the above steps, the target monitoring records are obtained from the monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store the ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of the fire water tank in the substation using the ultrasonic sensor; an alarm analysis is performed on the target monitoring records to obtain the analysis results; based on the analysis results, the target office equipment is controlled to send an Ethernet connection alarm message to the target object, thereby achieving the purpose of effectively reducing the labor intensity of personnel and improving the safety and reliability of substation operation, thereby realizing the technical effect of using automatic water level detection devices to realize real-time monitoring of water levels, intelligent alarms and data aggregation through equipment such as ultrasonic sensors and edge gateways, thereby solving the technical problems that the relevant technologies are time-consuming and labor-intensive due to regular manual on-site inspections, and bring hidden dangers to the safe operation of the substation.

[0066] Figure 2 FIG. 1 is a data flow diagram of a method for monitoring and alarming a fire water pool in a substation according to one embodiment of the present invention. Figure 2 As shown, a technology and architecture for intelligent monitoring and alarming of fire water pools in substations is realized, which mainly includes monitoring auxiliary database and monitoring auxiliary analysis module in zone 3, electronic link (ELINK) control module and office machines in zone 4, edge gateway in zone 3, ultrasonic sensor and fire water pool. Among them, the monitoring auxiliary database contains personnel information table, alarm rule configuration table, alarm record table, information sending record table, telemetry data table, frequent signal table, etc. The contents of the alarm rule configuration table may include [identification number], [telemetry point code], [plant station code], [lower limit value], [first-order upper limit value], [second-order upper limit value], [sending personnel], [sending method], [crossing first-order delay], [crossing second-order delay], [first-order alarm number], [second-order alarm number], [alarm interval duration], and [reset delay]; the contents of the alarm record table may include [alarm record identification number], [associated alarm rule identification number (identification number of the alarm rule configuration table)], [alarm value], [alarm time], [crossing second-order alarm value], [crossing second-order time], [last alarm value], [last alarm time], [reset time], [first-order alarm value], [second ... The contents of the sending information record table may include [record identification number], [sending object], [sending content], [sending time], [whether sent], [sending method], and [associated alarm record table identification number]. The contents of the frequent information table may include [frequent signal code], [collection value], [collection time], and [record type]. The contents of the telemetry data table may include [telemetry point code], [data type], [name of the plant or station to which it belongs], [collection time], and [collection value]. The telemetry data table stores various data collected from the station, including the water level data of the fire water tank.

[0067] On the one hand, the monitoring auxiliary analysis module can obtain various storage data from the monitoring auxiliary database for alarm analysis, and on the other hand, it can store the analysis results in the monitoring auxiliary database. The ELINK control module can obtain the result data analyzed by the monitoring auxiliary analysis module, and control the fourth zone office machine to send ELINK alarm information to the designated group. The fourth zone office machine is an office host with ELINK office software installed inside. The edge gateway can receive the data collected by the ultrasonic sensor, and send the data to the third zone monitoring auxiliary database and store it in the telemetry data table. The ultrasonic sensor is a device installed on the fire water tank, which is used to measure the height of the water level in the fire water tank.

[0068] Figure 3 FIG. 1 is a flowchart of a method for monitoring and alarming a fire water pool in a substation according to one embodiment of the present invention. Figure 3 As shown, the process steps of the fire water pool monitoring and alarm method in the substation are mainly divided into five steps. First, the fire data is screened, then the fire data is judged to have exceeded the limit level, then the alarm demand is judged, and the alarm content is generated, and finally the alarm is issued through the electronic link module. The specific content is shown in the following steps:

[0069] Optionally, in step S10, the monitoring auxiliary database stores at least a telemetry data table, and obtaining the target monitoring record from the monitoring auxiliary database may include the following execution steps:

[0070] According to the preset period, target monitoring records that meet the preset collection conditions are collected from the telemetry data table of the monitoring auxiliary database, where the preset collection conditions are determined based on the data type and the collection time.

[0071] In the embodiment of the present invention, target monitoring records that meet preset collection conditions are collected from the telemetry data table of the monitoring auxiliary database according to a preset period, wherein the preset collection conditions are determined according to the data type and the collection time, and can be understood as follows: Figure 2 The edge gateway of the third zone of the station continuously receives the water level information of the fire pool collected by the ultrasonic sensor through the power carrier technology, and then sends the information to the third zone power grid monitoring auxiliary system. After conversion, the data is stored in the telemetry data table of the power grid monitoring auxiliary database. The monitoring auxiliary analysis module will periodically obtain the data record set T with the data type of "fire pool" and the collection time as the latest time from the telemetry data table of the monitoring auxiliary database, which is not restricted here.

[0072] Optionally, in step S10, the monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table, and performing alarm analysis on the target monitoring record to obtain the analysis result may include the following execution steps:

[0073] Step S101, obtaining the telemetry point code data record corresponding to the target monitoring record from the alarm rule configuration table;

[0074] Step S102, in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point code data record, obtaining from the alarm record table an unarchived query record whose associated alarm rule identifier is the identifier of the telemetering point code data record;

[0075] Step S103, based on the target monitoring records, telemetry point coding data records and query records, an alarm analysis is performed on the target monitoring records to obtain an analysis result.

[0076] In an embodiment of the present invention, a telemetering point code data record corresponding to a target monitoring record is obtained from an alarm rule configuration table. In response to a collection value of the target monitoring record being greater than a first-order upper limit value of the telemetering point code data record, a query record whose associated alarm rule identifier is an identifier of the telemetering point code data record and which has not been archived is obtained from the alarm record table. Based on the target monitoring record, the telemetering point code data record and the query record, an alarm analysis is performed on the target monitoring record to obtain an analysis result. It can be understood that the monitoring auxiliary analysis module analyzes the data in the record set T one by one. Now, take the analysis of one of the records R as an example: the monitoring auxiliary analysis module obtains a data record R2 of the telemetering point code of the record R from the alarm rule configuration table, and then determines whether the collection value of the record R is greater than a first-order upper limit value of the record R2. If this condition is met, the alarm record table of the monitoring auxiliary database is queried for an identification number of the associated rule identification number of the record R2 to determine whether the record R3 with a "no" is archived; otherwise, the next record in the record set T is executed. Based on the target monitoring records, telemetry point coding data records and query records, alarm analysis is performed on the target monitoring records and analysis results are obtained, which are not limited here.

[0077] Optionally, in step S103, based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is subjected to alarm analysis, and obtaining the analysis result may include the following execution steps:

[0078] Step S1031, based on the target monitoring record, the telemetry point code data record and the query record, an alarm analysis is performed on the target monitoring record to obtain the alarm type of the target monitoring record;

[0079] Step S1032, determine whether the alarm type meets the alarm requirement and obtain the analysis result.

[0080] In an embodiment of the present invention, based on the target monitoring records, telemetry point coded data records and query records, an alarm analysis is performed on the target monitoring records, the alarm type of the target monitoring records is obtained, and it is determined whether the alarm type meets the alarm requirements, and the analysis results are obtained. It can be understood exemplarily that an alarm analysis is performed on the target monitoring records through the target monitoring records, telemetry point coded data records and query records, so as to obtain the alarm type of the target monitoring records, and determine whether the alarm type meets the alarm requirements, and finally obtain the analysis results, which are not limited here.

[0081] Optionally, in step S1031, based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record may include the following execution steps:

[0082] In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being not empty, the last alarm value of the query record being greater than the first-order upper limit value of the telemetering point coding data record, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is upgraded to a second-order upper limit alarm after resetting to the first-order upper limit, updating the second-order alarm value of the query record to the acquisition value of the target monitoring record, updating the second-order time of the query record to the acquisition time of the query record, and marking the record type of the query record as a frequent signal;

[0083] In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point coding data record, determining the alarm type as the acquisition value of the target monitoring record continuously exceeding the second-order upper limit alarm after the last alarm reset, and marking the record type of the query record as a second-order frequent signal;

[0084] In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being empty, the last alarm value of the query record being greater than the first-order upper limit value of the telemetering point coding data record, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is converted into a second-order upper limit alarm during a non-reset period of crossing the first-order upper limit, updating the second-order alarm value of the query record to the acquisition value of the target monitoring record, and updating the second-order time of the query record to the acquisition time of the query record;

[0085] In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point coding data record, the alarm type is determined to be the acquisition value of the target monitoring record continuously exceeding the second-order upper limit alarm;

[0086] In response to the collection value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, the last alarm and the second-order alarm value of the query record are both empty, and the alarm type is determined to be the first second-order upper limit alarm for the collection value of the target monitoring record, the second-order alarm value of the query record is updated to the collection value of the target monitoring record, and the second-order time of the query record is updated to the collection time of the query record.

[0087] In the embodiment of the present invention, the monitoring auxiliary analysis module compares whether the collected value of record R is greater than the second-order upper limit value of record R2. If this condition is met, the following judgment is performed, which can be understood as follows:

[0088] If the record R3 exists, and the reset time of record R3 is not empty, and the last alarm value of record R3 is greater than the first-order upper limit value of record R2, but less than the second-order upper limit value of record R2, it means that the acquisition value of record R is upgraded to the second-order upper limit alarm after the reset of the first-order upper limit, so the second-order alarm value of record R3 is updated to the acquisition value of record R, and the second-order time is the acquisition time of record R. At the same time, signal R3 is marked as a frequent signal (corresponding to the record type in the frequent signal table) and stored in the frequent signal table. There is no restriction here.

[0089] If the record R3 exists, and the reset time of the record R3 is not empty, and the last alarm value of the record R3 is greater than the second-order upper limit value of the record R2, it means that the collection value of the record R continues to exceed the second-order upper limit value after the last alarm reset, so the signal R3 is marked as a second-order frequent signal (corresponding to the record type in the frequent signal table) and stored in the frequent signal table, and is not restricted here;

[0090] If the record R3 exists, and the reset time of record R3 is empty, and the last alarm value of record R3 is greater than the first-order upper limit value of record R2, but less than the second-order upper limit value of record R2, it means that the collection value of record R has changed to the second-order upper limit alarm during the non-reset period of crossing the first-order upper limit, so the second-order alarm value of record R3 is updated to the collection value of record R, and the second-order time is the collection time of record R, which is not restricted here;

[0091] If the record R3 exists, and the reset time of the record R3 is empty, and the last alarm value of the record R3 is greater than the second-order upper limit value of the record R2, it means that the collection value of the record R continues to exceed the second-order upper limit, and it is not restricted here;

[0092] If the record R3 exists, and the last alarm of record R3 is empty, and the second-order alarm value of record R3 is empty, it means that the collection value of record R crosses the second-order upper limit for the first time, so the second-order alarm value of record R3 is updated to the collection value of record R, and the second-order time is the collection time of record R, which is not restricted here.

[0093] Optionally, in step S1031, based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record further includes the following execution steps:

[0094] In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is reset briefly after sending the second-order alarm and this acquisition exceeds the first-order upper limit value, updating the first-order alarm time of the query record to the acquisition time of the query record, recording the number of first-order alarms of the query record as 0, and marking the record type of the query record as a frequent signal;

[0095] In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is temporarily reset after sending the first-order alarm and the current acquisition exceeds the first-order upper limit value, updating the reset time of the query record to empty, recording the first-order alarm value of the query record as the acquisition value of the target monitoring record, updating the alarm time of the query record to the acquisition time of the query record, and marking the record type of the query record as a frequent signal;

[0096] In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being null, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is reduced to the first-order upper limit value of the telemetering point coding data record after exceeding the second-order upper limit value of the telemetering point coding data record, and in response to the second-order alarm value of the query record being not null, recording the first-order alarm value of the query record as the acquisition value of the target monitoring record, and updating the alarm time of the query record to the acquisition time of the query record;

[0097] In response to the collected value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the collected value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, and the return time and alarm time of the query record are both empty, it is determined that the alarm type is that the collected value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record, and no alarm has been issued yet.

[0098] In the embodiment of the present invention, if the monitoring auxiliary analysis module analyzes that the collection value of record R is greater than the first-order upper limit value of record R2, but less than the second-order upper limit value of record R2, the following judgment is performed, which can be understood as follows:

[0099] If the record R3 exists, and the reset time of the record R3 is not empty, and the last alarm value of the record R3 is greater than the second-order upper limit value of the record R2, it means that the collection value of the record R is temporarily reset after sending the second-order alarm, and the current collection value exceeds the first-order limit value, so the first-order alarm time of the record R3 is updated to the collection time of the record R and the first-order alarm number of the record R3 is 0, and the signal R3 is marked as a frequent signal (corresponding to the record type in the frequent signal table), and stored in the frequent signal table, which is not restricted here;

[0100] If the record R3 exists, and the reset time of the record R3 is not empty, and the last alarm value of the record R3 is less than the second-order upper limit value of the record R2, it means that the collection value of the record R is temporarily restored after the first-order alarm is issued, and the current collection value exceeds the first-order limit value, so the reset time of the record R3 is updated to be empty, the alarm value of the record R3 is the collection value of the record R, and the alarm time of the record R3 is the collection time of the record R, and the signal R3 is marked as a frequent signal (corresponding to the record type in the frequent signal table) and stored in the frequent signal table, which is not restricted here;

[0101] If the record R3 exists, and the reset time of record R3 is empty, and the last alarm value of record R3 is less than the second-order upper limit value of record R2, it means that the collection value of record R will cross the first-order upper limit after crossing the second-order upper limit of record R2. If the second-order alarm value of record R3 is not empty, the first-order alarm value of record R3 is updated to the collection value of record R and the first-order alarm event of record R3 is the collection time of record R, which is not restricted here;

[0102] If the record R3 exists, and the reset time of the record R3 is empty, and the alarm time is also empty, it means that the collection value of the record R exceeds the first-order upper limit value of the record R2, but no alarm is issued yet, and it is not restricted here.

[0103] Optionally, in step S1031, based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record further includes the following execution steps:

[0104] In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record being empty, and the alarm time of the query record being not empty, determining that the alarm type is that the acquisition value of the target monitoring record is reset in this acquisition after the alarm is issued, updating the first-order alarm value of the query record to the acquisition value of the target monitoring record, and updating both the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record;

[0105] In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both not empty, and it is determined that the alarm type is that the acquisition value of the target monitoring record has been reset, but the time for issuing the reset alarm has not been reached;

[0106] In response to the collection value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both empty, and the alarm type is determined to be that the collection time of the target monitoring record has not reached the reset delay of the recorded telemetry point coding data record and has been reset, and the archive mark of the query record is updated.

[0107] In the embodiment of the present invention, if the monitoring auxiliary analysis module analyzes that the collection value of the record R does not exceed the first-order upper limit of the record R2, the following judgment is performed, which can be understood as follows:

[0108] In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record is empty, and the alarm time of the query record is not empty, the alarm type is determined to be that the acquisition value of the target monitoring record is reset in this acquisition after the alarm is issued, and the first-order alarm value of the query record is updated to the acquisition value of the target monitoring record, and the acquisition time and reset time of the query record are both updated to the acquisition time of the target monitoring record. It can be understood that if the record R3 exists, and the reset time of record R3 is empty, and the alarm time is not empty, it means that the current acquisition point resets in this acquisition after the alarm is issued. Therefore, the alarm value of record R3 is updated to the acquisition value of record R, the acquisition time of record R3 is the acquisition time of record R, and the reset time of record R is the acquisition time of record R, and then the alarm demand judgment is performed, which is not restricted here;

[0109] In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both not empty, and the alarm type is determined to be that the acquisition value of the target monitoring record has been reset, but the time for issuing a reset alarm has not been reached. It can be understood that if there is a record R3, and the reset time of record R3 is not empty, and the alarm time is not empty, it means that the acquisition value of record R has been reset, but the time for issuing a reset alarm has not been reached, and then the alarm demand judgment is performed, which is not limited here;

[0110] In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both empty, and the alarm type is determined to be that the acquisition time of the target monitoring record has not reached the reset delay of the recorded telemetry point coding data record and has been reset, and the archiving mark of the query record is updated. It can be understood that if the record R3 exists, and the reset time of record R3 is empty, and the alarm time is empty, it means that the acquisition time of record R has not reached the reset delay of record R2 and has been reset, so whether the record R3 is archived is updated to "yes", and then continue to analyze the next record in the record set T, which is not restricted here.

[0111] Optionally, the monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table, and performing alarm analysis on the target monitoring record to obtain the analysis result may include the following execution steps:

[0112] Obtain the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table;

[0113] In response to the collected value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coded data record, and the absence of an unarchived query record in the alarm record table whose associated alarm rule identifier is the identifier of the telemetering point coded data record, the collected value of the target monitoring record is recorded as the second-order upper limit value of the telemetering point coded data record, and a first alarm content is generated based on the target monitoring record to obtain an analysis result;

[0114] In response to the fact that the collected value of the target monitoring record is greater than the first-order upper limit value of the telemetry point coded data record, the collected value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and there is no query record in the alarm record table whose associated alarm rule is identified as the identifier of the telemetry point coded data record and is not archived, the collected value of the target monitoring record is recorded as the first-order upper limit value of the telemetry point coded data record, and a second alarm content is generated based on the target monitoring record to obtain an analysis result.

[0115] In the embodiment of the present invention, after obtaining the telemetry point code data record corresponding to the target monitoring record from the alarm rule configuration table, the following judgment steps may also be included, which may be understood as follows:

[0116] When the monitoring auxiliary analysis module analyzes that the collection value of record R is greater than the first-order upper limit value of record R2, but less than the second-order upper limit value of record R2, that is, if record R3 does not exist, it means that record R exceeds the limit for the first time, that is, it exceeds the second-order upper limit of record R2, so record R is generated as an alarm record R4 and stored in the alarm record table, which is not restricted here.

[0117] When the monitoring auxiliary analysis module analyzes that the collection value of record R is less than the first-order upper limit value of record R2 and also less than the second-order upper limit value of record R2, that is, if the record R3 does not exist, the collection value of record R is the first time to cross the first-order upper limit of record R2, so record R is generated as an alarm record R5 and stored in the alarm record table, which is not restricted here.

[0118] Optionally, determining whether the alarm type meets the alarm requirement and obtaining the analysis result may include the following execution steps:

[0119] In response to the alarm type being that the collection value of the target monitoring record exceeds the second-order upper limit value of the telemetering point coded data record, the difference between the collection time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetering point coded data record, and the number of times the second-order alarm of the query record has been sent is less than the number of second-order alarms of the telemetering point coded data record, a third alarm content is generated based on the target monitoring record to obtain an analysis result;

[0120] In response to the alarm type being that the collection value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coded data record, the difference between the collection time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coded data record, and the number of first-order alarms sent for the query record is less than the number of first-order alarms for the telemetry point coded data record, a fourth alarm content is generated based on the target monitoring record to obtain an analysis result;

[0121] In response to the alarm reset of the target monitoring record, the difference between the acquisition time of the target monitoring record and the reset time of the query record is greater than or equal to the reset delay of the telemetry point coded data record, and the fifth alarm content is generated based on the target monitoring record to obtain the analysis result.

[0122] In the embodiment of the present invention, the monitoring auxiliary analysis module determines whether the alarm requirement is met according to different alarm types. It can be understood as follows: when the alarm type is that the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coded data record, if there is a record R acquisition time - record R3 last alarm time ≥ record R2 alarm interval duration, and the second-order alarm number of record R3 has been sent < the second-order alarm number of record R2, then the alarm content is generated, otherwise continue to analyze the next record in the record set T, which is not limited here;

[0123] When the alarm type is that the acquisition value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coded data record, if there is a record R acquisition time - record R3 last alarm time ≥ record R2 alarm interval duration, and the number of first-order alarms sent for record R3 < the number of first-order alarms for record R2, then generate alarm content, otherwise continue to analyze the next record in the record set T, which is not restricted here;

[0124] When the alarm type is the alarm return of the target monitoring record, if the acquisition time of record R - the return time of record R3 ≥ the return delay of record R2, the alarm content is generated, otherwise the next record in the record set T is analyzed, which is not restricted here.

[0125] After the monitoring auxiliary analysis module determines the alarm demand, it starts to generate alarm content, for example:

[0126] When the alarm type is that the collected value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coded data record, an alarm message is generated: [Fire water tank water level alarm] XX (record R's collection time), XX station (record R's plant station name) Fire water tank ultrasonic sensor water level: XX meters (record R's collection value), exceeds the second-order upper limit value: XX (record R2's second-order upper limit value), no restriction here;

[0127] When the alarm type is that the collected value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record, an alarm message is generated: [Fire water tank water level alarm] XX (record R collection time), XX station (record R to which the plant station name belongs) Fire water tank ultrasonic sensor water level: XX meters (record R collection value), exceeds the first-order upper limit value: XX (record R2 first-order upper limit value), no restriction here;

[0128] When the alarm type is the alarm reset of the target monitoring record, the alarm reset information is generated: [Fire water tank water level alarm reset] XX (record R collection time), XX station (name of the plant station to which record R belongs) fire water tank ultrasonic sensor water level reset, current value: XX meters (record R collection value), no restrictions here;

[0129] Then the monitoring auxiliary analysis module records the sender of R2 as the occurrence object, the alarm content as the sending content, the alarm time of R3 as the occurrence time, and the sending method of R2 into the sending information record table of the monitoring auxiliary database, which is not restricted here.

[0130] The ELINK control module will send a request to the monitoring auxiliary analysis module every minute to obtain the ELINK alarm notification. After receiving the request, the ELINK control module will obtain the record T2 with "No" and "ELINK" as the sending method from the sending information record table of the monitoring auxiliary database, and then send the record T2 to the ELINK control module. At the same time, the "No" and "ELINK" fields of the records in the sending information record table with "No" and "ELINK" as the sending method are all updated to "Yes". After receiving the record T2, the ELINK control module controls the ELINK software of the office machine to send the sending content information to the sender in the record T2, which is not limited here.

[0131] Through the description of the above implementation methods, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, a magnetic disk, or an optical disk), and includes a number of instructions for enabling a terminal device (which can be a mobile phone, a computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present invention.

[0132] According to one embodiment of the present invention, there is also provided a fire water tank monitoring and alarm system in a substation, including: a monitoring auxiliary analysis device, an Ethernet connection control device, an edge gateway and an ultrasonic sensor; the ultrasonic sensor is used to measure the water level height of the fire water tank in the substation to obtain ultrasonic sensor monitoring data; the edge gateway is used to report the ultrasonic sensor monitoring data to the monitoring auxiliary database to generate target monitoring records; the monitoring auxiliary analysis device is used to obtain the target monitoring records from the monitoring auxiliary database, and perform alarm analysis on the target monitoring records to obtain analysis results; the Ethernet connection control device is used to control the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis results.

[0133] In this embodiment, a fire water pool monitoring and alarm device in a substation is also provided, which is used to implement the above-mentioned embodiments and preferred implementation modes, and the descriptions that have been made will not be repeated. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceivable.

[0134] Figure 4 FIG. 1 is a structural block diagram of a fire water pool monitoring and alarm device in a substation according to one embodiment of the present invention. Figure 4 As shown, a fire water tank monitoring and alarm device 400 in a substation is used as an example, and the device includes: an acquisition module 401, which is used to obtain target monitoring records from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of the fire water tank in the substation using an ultrasonic sensor; an analysis module 402, which is used to perform alarm analysis on the target monitoring record to obtain analysis results; a control module 403, which is used to control the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis results.

[0135] Optionally, the acquisition module 401 is further used to obtain target monitoring records that meet preset collection conditions from the telemetry data table of the monitoring auxiliary database according to a preset period, wherein the preset collection conditions are determined based on the data type and the collection time.

[0136] Optionally, the acquisition module 401 is also used to obtain the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the collection value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, obtain the associated alarm rule identifier as the identifier of the telemetry point coded data record and the unarchived query record from the alarm record table; based on the target monitoring record, the telemetry point coded data record and the query record, perform alarm analysis on the target monitoring record to obtain analysis results.

[0137] Optionally, the analysis module 402 is also used to perform alarm analysis on the target monitoring records based on the target monitoring records, telemetry point coding data records and query records, obtain the alarm type of the target monitoring records; determine whether the alarm type meets the alarm requirements, and obtain analysis results.

[0138] Optionally, the analysis module 402 is further used to respond to the fact that the acquisition value of the target monitoring record is greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetry point coding data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetry point coding data record, determine that the alarm type is that the acquisition value of the target monitoring record is upgraded to a second-order upper limit alarm after resetting to the first-order upper limit, update the second-order alarm value of the query record to the acquisition value of the target monitoring record, and update the second-order time of the query record to the query record. The acquisition time of the query record is determined, and the record type of the query record is marked as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record is not empty, and the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coding data record, the alarm type is determined to be the acquisition value of the target monitoring record continuing to cross the second-order upper limit alarm after the last alarm reset, and the record type of the query record is marked as a second-order frequent signal; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coding data record, the query record The reset time is empty, the last alarm value of the query record is greater than the first-order upper limit value of the telemetering point coded data record, and the last alarm value of the query record is less than the second-order upper limit value of the telemetering point coded data record. The alarm type is determined to be that the acquisition value of the target monitoring record is converted to a second-order upper limit alarm during the non-reset period of the first-order upper limit, and the second-order alarm value of the query record is updated to the acquisition value of the target monitoring record, and the second-order time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coded data record, the query record The reset time is empty, the last alarm value of the query record is greater than the second-order upper limit value of the telemetry point coded data record, and the alarm type is determined to be the target monitoring record's acquisition value continuously crossing the second-order upper limit alarm; in response to the target monitoring record's acquisition value being greater than the second-order upper limit value of the telemetry point coded data record, the last alarm and the second-order alarm value of the query record are both empty, and the alarm type is determined to be the target monitoring record's acquisition value crossing the second-order upper limit alarm for the first time, and the second-order alarm value of the query record is updated to the target monitoring record's acquisition value, and the second-order time of the query record is updated to the acquisition time of the query record.

[0139] Optionally, the analysis module 402 is further used to respond to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetry point coding data record, determine that the alarm type is that the acquisition value of the target monitoring record is temporarily reset after sending the second-order alarm and this acquisition exceeds the first-order upper limit value, update the first-order alarm time of the query record to the acquisition time of the query record, and record the number of first-order alarms of the query record as 0, and mark the record type of the query record as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetry point coding data record, determining that the alarm type is the acquisition value of the target monitoring record briefly resets after sending the first-order alarm and this acquisition exceeds the first-order upper limit value, updating the reset time of the query record to empty, and recording the first-order alarm value of the query record as the target monitoring record. The acquisition value of the target monitoring record is updated to the acquisition time of the query record, and the record type of the query record is marked as a frequent signal; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record is empty, and the last alarm value of the query record is less than the second-order upper limit value of the telemetering point coding data record, it is determined that the alarm type is the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetering point coding data record and then drops to the value of the telemetering point coding data record. , and in response to the query record's second-order alarm value being not empty, the first-order alarm value of the query record is recorded as the acquisition value of the target monitoring record, and the alarm time of the query record is updated to the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and the reset time and the alarm time of the query record are both empty, it is determined that the alarm type is that the acquisition value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coded data record, and no alarm has been issued yet.

[0140] Optionally, the analysis module 402 is further used to, in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record being empty, and the alarm time of the query record being not empty, determine that the alarm type is that the acquisition value of the target monitoring record is reset in the current acquisition after the alarm is issued, update the first-order alarm value of the query record to the acquisition value of the target monitoring record, and update the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record; in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record being not empty, determine that the alarm type is that the acquisition value of the target monitoring record has been reset, but has not reached the time for issuing the reset alarm; in response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record being empty, determine that the alarm type is that the acquisition time of the target monitoring record has not reached the reset delay of the recorded telemetry point coding data record and has been reset, and update the archiving mark of the query record.

[0141] Optionally, the analysis module 402 is also used to obtain the telemetry point coded data record corresponding to the target monitoring record from the alarm rule configuration table; in response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table whose associated alarm rule is identified as the identifier of the telemetry point coded data record and which is not archived, the acquisition value of the target monitoring record is recorded as the second-order upper limit value of the telemetry point coded data record, and a first alarm content is generated based on the target monitoring record to obtain an analysis result; in response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table whose associated alarm rule is identified as the identifier of the telemetry point coded data record and which is not archived, the acquisition value of the target monitoring record is recorded as the first-order upper limit value of the telemetry point coded data record, and a second alarm content is generated based on the target monitoring record to obtain an analysis result.

[0142] Optionally, the analysis module 402 is further used to generate a third alarm content based on the target monitoring record to obtain an analysis result in response to the alarm type being that the collection value of the target monitoring record exceeds the second-order upper limit value of the telemetry point coding data record, the difference between the collection time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point coding data record, and the number of second-order alarms sent in the query record is less than the number of second-order alarms recorded in the telemetry point coding data record; in response to the alarm type being that the collection value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record, the target monitoring The difference between the acquisition time of the measurement record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetering point coded data record, the number of first-order alarms sent for the query record is less than the number of first-order alarms for the telemetering point coded data record, and a fourth alarm content is generated based on the target monitoring record to obtain an analysis result; in response to an alarm reset of a target monitoring record whose alarm type is an alarm reset, the difference between the acquisition time of the target monitoring record and the reset time of the query record is greater than or equal to the reset delay of the telemetering point coded data record, and a fifth alarm content is generated based on the target monitoring record to obtain an analysis result.

[0143] It should be noted that the above modules can be implemented by software or hardware. For the latter, it can be implemented in the following ways, but not limited to: the above modules are all located in the same processor; or the above modules are located in different processors in any combination.

[0144] An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored. The computer program is configured to execute the steps of any of the above method embodiments when running on a computer or a processor.

[0145] Optionally, in this embodiment, the computer-readable storage medium may be configured to store a computer program for performing the following steps:

[0146] Step S10, obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is used to store at least ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor;

[0147] Step S11, performing alarm analysis on the target monitoring record to obtain analysis results;

[0148] Step S12: Based on the analysis result, the target office device is controlled to send an Ethernet connection alarm message to the target object.

[0149] Optionally, in this embodiment, the above-mentioned computer-readable storage medium may include but is not limited to: a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk, and other media that can store computer programs.

[0150] An embodiment of the present invention further provides an electronic device, including a memory and a processor, wherein a computer program is stored in the memory, and the processor is configured to run the computer program to execute the steps in any one of the above method embodiments.

[0151] Optionally, in this embodiment, the processor in the electronic device may be configured to run a computer program to perform the following steps:

[0152] Step S10, obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is used to store at least ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor;

[0153] Step S11, performing alarm analysis on the target monitoring record to obtain analysis results;

[0154] Step S12: Based on the analysis result, the target office device is controlled to send an Ethernet connection alarm message to the target object.

[0155] An embodiment of the invention further provides a computer program product, including a computer program, which implements the steps in any of the above method embodiments when executed by a processor.

[0156] Optionally, in this embodiment, the computer program in the above computer program product may be configured to perform the following steps when executed by a processor:

[0157] Step S10, obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is used to store at least ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level height of a fire water tank in a substation using an ultrasonic sensor;

[0158] Step S11, performing alarm analysis on the target monitoring record to obtain analysis results;

[0159] Step S12: Based on the analysis result, the target office device is controlled to send an Ethernet connection alarm message to the target object.

[0160] Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation modes, and this embodiment will not be described in detail here.

[0161] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0162] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0163] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of the units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0164] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0165] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0166] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM), random access memory (RAM), mobile hard disk, magnetic disk or optical disk, etc., various media that can store program codes.

[0167] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A fire water pool monitoring and alarm method in a substation, characterized in that: include: Obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by an edge gateway, wherein the ultrasonic sensor monitoring data is obtained by measuring the water level of a fire water tank in a substation using an ultrasonic sensor; Performing alarm analysis on the target monitoring record to obtain analysis results; Based on the analysis result, the target office equipment is controlled to send an Ethernet connection alarm message to the target object.

2. The fire water pool monitoring and alarm method in a substation according to claim 1 is characterized in that: The monitoring auxiliary database at least stores a telemetry data table, and obtaining the target monitoring record from the monitoring auxiliary database includes: The target monitoring records that meet the preset collection conditions are collected from the telemetry data table of the monitoring auxiliary database according to a preset period, wherein the preset collection conditions are determined according to the data type and the collection time.

3. The fire water pool monitoring and alarm method in a substation according to claim 1 is characterized in that: The monitoring auxiliary database also stores an alarm rule configuration table and an alarm record table, and performs alarm analysis on the target monitoring record to obtain the analysis results including: Obtaining the telemetry point coding data record corresponding to the target monitoring record from the alarm rule configuration table; In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetry point code data record, obtaining from the alarm record table an unarchived query record whose associated alarm rule identifier is the identifier of the telemetry point code data record; Based on the target monitoring record, the telemetry point coding data record and the query record, an alarm analysis is performed on the target monitoring record to obtain the analysis result.

4. The fire water pool monitoring and alarm method in a substation according to claim 3 is characterized in that: Based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is subjected to alarm analysis, and the analysis result obtained includes: Based on the target monitoring record, the telemetry point code data record and the query record, an alarm analysis is performed on the target monitoring record to obtain an alarm type of the target monitoring record; Determine whether the alarm type meets the alarm requirement and obtain the analysis result.

5. The fire water pool monitoring and alarm method in a substation according to claim 4 is characterized in that: Based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record includes: In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point coded data record, the reset time of the query record being not empty, the last alarm value of the query record being greater than the first-order upper limit value of the telemetering point coded data record, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coded data record, determining that the alarm type is that the acquisition value of the target monitoring record is upgraded to a second-order upper limit alarm after resetting to a first-order upper limit, updating the second-order alarm value of the query record to the acquisition value of the target monitoring record, updating the second-order time of the query record to the acquisition time of the query record, and marking the record type of the query record as a frequent signal; In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point code data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point code data record, determining the alarm type as the acquisition value of the target monitoring record continuously exceeding the second-order upper limit alarm after the last alarm reset, and marking the record type of the query record as a second-order frequent signal; In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point code data record, the reset time of the query record being empty, the last alarm value of the query record being greater than the first-order upper limit value of the telemetering point code data record, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point code data record, determining that the alarm type is that the acquisition value of the target monitoring record is converted into a second-order upper limit alarm during a non-reset period of crossing the first-order upper limit, updating the second-order alarm value of the query record to the acquisition value of the target monitoring record, and updating the second-order time of the query record to the acquisition time of the query record; In response to the acquisition value of the target monitoring record being greater than the second-order upper limit value of the telemetering point code data record, the reset time of the query record being empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point code data record, determining that the alarm type is the acquisition value of the target monitoring record continuously exceeding the second-order upper limit alarm; In response to the collection value of the target monitoring record being greater than the second-order upper limit value of the telemetry point coded data record, the previous alarm and the second-order alarm value of the query record are both empty, and the alarm type is determined to be the first second-order upper limit alarm for the collection value of the target monitoring record, the second-order alarm value of the query record is updated to the collection value of the target monitoring record, and the second-order time of the query record is updated to the collection time of the query record.

6. The fire water pool monitoring and alarm method in a substation according to claim 4, characterized in that: Based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record includes: In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coded data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point coded data record, the reset time of the query record being not empty, and the last alarm value of the query record being greater than the second-order upper limit value of the telemetering point coded data record, determining that the alarm type is that the acquisition value of the target monitoring record is reset briefly after sending the second-order alarm and this acquisition exceeds the first-order upper limit value, updating the first-order alarm time of the query record to the acquisition time of the query record, recording the first-order alarm number of the query record as 0, and marking the record type of the query record as a frequent signal; In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point coding data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point coding data record, the reset time of the query record being not empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record is temporarily reset after sending the first-order alarm and this acquisition exceeds the first-order upper limit value, updating the reset time of the query record to empty, recording the first-order alarm value of the query record as the acquisition value of the target monitoring record, updating the alarm time of the query record to the acquisition time of the query record, and marking the record type of the query record as a frequent signal; In response to the acquisition value of the target monitoring record being greater than the first-order upper limit value of the telemetering point code data record, the acquisition value of the target monitoring record being less than the second-order upper limit value of the telemetering point code data record, the reset time of the query record being empty, and the last alarm value of the query record being less than the second-order upper limit value of the telemetering point code data record, determining that the alarm type is that the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetering point code data record and then decreases to the first-order upper limit value of the telemetering point code data record, and in response to the second-order alarm value of the query record being not empty, recording the first-order alarm value of the query record as the acquisition value of the target monitoring record, and updating the alarm time of the query record to the acquisition time of the query record; In response to the fact that the collection value of the target monitoring record is greater than the first-order upper limit value of the telemetry point coding data record, the collection value of the target monitoring record is less than the second-order upper limit value of the telemetry point coding data record, and the reset time and alarm time of the query record are both empty, it is determined that the alarm type is that the collection value of the target monitoring record exceeds the first-order upper limit value of the telemetry point coding data record, and no alarm has been issued yet.

7. The fire water pool monitoring and alarm method in a substation according to claim 4, characterized in that: Based on the target monitoring record, the telemetry point code data record and the query record, the target monitoring record is analyzed for alarms, and obtaining the alarm type of the target monitoring record includes: In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point code data record, the reset time of the query record being empty, and the alarm time of the query record being not empty, determining that the alarm type is that the acquisition value of the target monitoring record is reset in this acquisition after the alarm is issued, updating the first-order alarm value of the query record to the acquisition value of the target monitoring record, and updating both the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record; In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point code data record, the reset time of the query record and the alarm time of the query record are both not empty, determining that the alarm type is that the acquisition value of the target monitoring record has been reset, but the time for issuing a reset alarm has not been reached; In response to the acquisition value of the target monitoring record being less than the first-order upper limit value of the telemetry point coding data record, the reset time of the query record and the alarm time of the query record are both empty, and the alarm type is determined to be that the acquisition time of the target monitoring record has not reached the reset delay for recording the telemetry point coding data record and has been reset, and the archive mark of the query record is updated.

8. The fire water pool monitoring and alarm method in a substation according to claim 1, characterized in that: The monitoring auxiliary database also stores an alarm rule configuration table and an alarm record table, and performs alarm analysis on the target monitoring record to obtain the analysis results including: Obtaining the telemetry point coding data record corresponding to the target monitoring record from the alarm rule configuration table; In response to the collected value of the target monitoring record being greater than the second-order upper limit value of the telemetering point code data record, and the absence of an unarchived query record whose associated alarm rule identifier is the identifier of the telemetering point code data record in the alarm record table, the collected value of the target monitoring record is recorded as the second-order upper limit value exceeding the telemetering point code data record, and a first alarm content is generated based on the target monitoring record to obtain the analysis result; In response to the fact that the collected value of the target monitoring record is greater than the first-order upper limit value of the telemetry point coded data record, the collected value of the target monitoring record is less than the second-order upper limit value of the telemetry point coded data record, and there is no query record in the alarm record table whose associated alarm rule identifier is the identifier of the telemetry point coded data record and which is not archived, the collected value of the target monitoring record is recorded as exceeding the first-order upper limit value of the telemetry point coded data record, and a second alarm content is generated based on the target monitoring record to obtain the analysis result.

9. The fire water pool monitoring and alarm method in a substation according to claim 4, characterized in that: Determining whether the alarm type meets the alarm requirement, and obtaining the analysis result includes: In response to the alarm type being that the acquisition value of the target monitoring record exceeds the second-order upper limit value of the telemetry point code data record, the difference between the acquisition time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point code data record, and the number of second-order alarms sent for the query record is less than the number of second-order alarms recorded for the telemetry point code data record, a third alarm content is generated based on the target monitoring record to obtain the analysis result; In response to the alarm type being that the collection value of the target monitoring record exceeds the first-order upper limit value of the telemetry point code data record, the difference between the collection time of the target monitoring record and the last alarm time of the query record is greater than or equal to the alarm interval duration of the telemetry point code data record, and the number of times the first-order alarm of the query record has been sent is less than the number of first-order alarms recorded for the telemetry point code data record, a fourth alarm content is generated based on the target monitoring record to obtain the analysis result; In response to the alarm type being the alarm reset of the target monitoring record, the difference between the acquisition time of the target monitoring record and the reset time of the query record is greater than or equal to the reset delay of the telemetry point coded data record, and a fifth alarm content is generated based on the target monitoring record to obtain the analysis result.

10. A fire water pool monitoring and alarm system in a substation, characterized in that: include: Monitoring auxiliary analysis equipment, Ethernet connection control equipment, edge gateways and ultrasonic sensors; The ultrasonic sensor is used to measure the water level of the fire water tank in the substation to obtain ultrasonic sensor monitoring data; The edge gateway is used to report the ultrasonic sensor monitoring data to the monitoring auxiliary database to generate target monitoring records; The monitoring auxiliary analysis device is used to obtain the target monitoring record from the monitoring auxiliary database, and perform alarm analysis on the target monitoring record to obtain an analysis result; The Ethernet connection control device is used to control the target office device to send an Ethernet connection alarm message to the target object based on the analysis result.

Images