Fire-fighting water pool monitoring and alarming method and system in transformer substation

Abstract

The application discloses a kind of substation fire-fighting pool monitoring alarm method and system, it is related to Internet of Things technical field.Wherein, the method includes: obtaining target monitoring record from monitoring auxiliary database, wherein, monitoring auxiliary database is at least used to store ultrasonic sensor monitoring data reported by edge gateway, ultrasonic sensor monitoring data is obtained after using ultrasonic sensor to measure the water level of substation fire-fighting pool;Alarm analysis is carried out to target monitoring record, and analysis result is obtained;Based on analysis result, target office equipment is controlled to send Ethernet connection alarm message to target object.The application solves the technical problems of time-consuming and labor-consuming caused by manual regular on-site inspection in related technologies, and hidden danger to the safe operation of substation.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of Internet of Things, in particular to a substation fire-fighting pool monitoring and alarming method and system. BACKGROUND

[0002] The substation fire-fighting pool as the main fire-fighting water source in the substation, the sufficiency of its water level is directly related to the water supply capacity of the fire-fighting system. By regularly detecting the water level, it can be ensured that the water quantity in the pool always remains above the standard that meets the fire-fighting demand, so as to provide sufficient fire-fighting water when a fire occurs. In the face of sudden fire, in order to respond quickly and accurately, regular detection of the water level of the fire-fighting pool is crucial. The traditional way can only be achieved by artificial regular on-site patrol.

[0003] Artificial regular on-site patrol needs to patrol back and forth between each substation, which is time-consuming and laborious, and only water level detection is carried out by using simple tools such as water level gauge and water gauge, which may have certain errors and inconvenience. In the rainy season or dry season, the detection frequency may need to be increased to cope with water level fluctuations. This periodic patrol may not be able to find defects in time, which may cause hidden dangers to the safe operation of the substation. SUMMARY

[0004] The substation fire-fighting pool monitoring and alarming method and system provided by the embodiments of the present application can at least solve the technical problems that the related art causes time-consuming and laborious and hidden dangers to the safe operation of the substation by artificial regular on-site patrol.

[0005] According to one of the embodiments of the present application, a substation fire-fighting pool monitoring and alarming method 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 is obtained by measuring the water level height of the substation fire-fighting pool by using an ultrasonic sensor; performing alarm analysis on the target monitoring record to obtain an analysis result; and based on the analysis result, controlling a target office equipment to send an Ethernet connection alarm message to a target object.

[0006] Optionally, at least a telemetry data table is stored in the monitoring auxiliary database, and obtaining the target monitoring record from the monitoring auxiliary database comprises: obtaining the target monitoring record from the telemetry data table of the monitoring auxiliary database that meets a preset collection condition according to a preset period, wherein the preset collection condition is determined according to the data type and the collection time.

[0007] Optionally, the monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table, and an alarm analysis is performed on the target monitoring record to obtain an analysis result, including: obtaining, from the alarm rule configuration table, a telemetry point coding data record corresponding to the target monitoring record; in response to the collection value of the target monitoring record being greater than a first upper limit value of the telemetry point coding data record, obtaining, from the alarm record table, a query record associated with an alarm rule identifier being an identifier of the telemetry point coding data record and not being archived; and performing an alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point coding data record, and the query record to obtain the analysis result.

[0008] Optionally, the alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point coding data record, and the query record to obtain the analysis result includes: performing the alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point coding data record, and the query record to obtain an alarm type of the target monitoring record; and determining whether the alarm type meets an alarm requirement to obtain the analysis result.

[0009] Optionally, based on the target monitoring record, the telemetry point coding data record and the query record, the target monitoring record is subjected to alarm analysis to obtain an alarm type of the target monitoring record, including: in response to the collection value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record is upgraded from the alarm beyond the first upper limit to the alarm beyond the second upper limit after the reset of the alarm beyond the first upper limit, updating the alarm value beyond the second upper limit of the query record to the collection value of the target monitoring record, updating the time beyond the second upper limit of the query record to the collection time of the query record, and marking the record type of the query record as a frequent signal; in response to the collection value of the target monitoring record being greater than the second 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 upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record continuously alarms beyond the second upper limit after the reset of the last alarm, and marking the record type of the query record as a second frequent signal; in response to the collection value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record is converted to the alarm beyond the second upper limit during the unreset period of the alarm beyond the first upper limit, updating the alarm value beyond the second upper limit of the query record to the collection value of the target monitoring record, and updating the time beyond the second upper limit of the query record to the collection time of the query record; in response to the collection value of the target monitoring record being greater than the second 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 greater than the second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record continuously alarms beyond the second upper limit; and in response to the collection value of the target monitoring record being greater than the second upper limit value of the telemetry point coding data record, and the last alarm and the alarm value beyond the second upper limit of the query record both being empty, determining that the alarm type is that the collection value of the target monitoring record is a first alarm beyond the second upper limit, updating the alarm value beyond the second upper limit of the query record to the collection value of the target monitoring record, and updating the time beyond the second upper limit of the query record to the collection time of the query record.

[0010] Optionally, based on the target monitoring record, the telemetry point coding data record and the query record, the target monitoring record is subjected to alarm analysis to obtain an alarm type of the target monitoring record, including: in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry 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 second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record is temporarily reset after sending the second alarm and the current collection value exceeds the first upper limit value again, updating the first alarm time of the query record to the collection time of the query record, recording the first alarm frequency of the query record as 0, and marking the record type of the query record as a frequent signal; in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record is temporarily reset after sending the first alarm and the current collection value exceeds the first upper limit value again, updating the reset time of the query record to empty, recording the first alarm value of the query record as the collection value of the target monitoring record, updating the alarm time of the query record to the collection time of the query record, and marking the record type of the query record as a frequent signal; in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time of the query record being empty, the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determining that the alarm type is that the collection value of the target monitoring record exceeds the second upper limit value of the telemetry point coding data record and then falls below the first upper limit value of the telemetry point coding data record, and in response to the second alarm value of the query record being not empty, recording the first alarm value of the query record as the collection value of the target monitoring record, and updating the alarm time of the query record to the collection time of the query record; in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time and the alarm time of the query record being empty, determining that the alarm type is that the collection value of the target monitoring record exceeds the first upper limit value of the telemetry point coding data record, and no alarm has been sent temporarily.

[0011] Optionally, based on the target monitoring record, the telemetry point coding data record, and the query record, the target monitoring record is subjected to alarm analysis, and an alarm type of the target monitoring record is obtained, including: in response to the collection value of the target monitoring record being less than the first 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 collection value of the target monitoring record is reset in this collection after the alarm is issued, updating the first alarm value of the query record to the collection value of the target monitoring record, and updating the collection time and the reset time of the query record to the collection time of the target monitoring record; in response to the collection value of the target monitoring record being less than the first 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 both being not empty, determining that the alarm type is that the collection value of the target monitoring record has been reset, but the time of issuing the reset alarm has not been reached; in response to the collection value of the target monitoring record being less than the first 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 both being empty, determining that the alarm type is that the collection value of the target monitoring record has been reset before the reset time delay of the telemetry point coding data record is reached, and updating the archiving flag of the query record.

[0012] Optionally, the alarm rule configuration table and the alarm record table are further stored in the monitoring auxiliary database, the target monitoring record is subjected to alarm analysis, and an analysis result is obtained, including: obtaining the telemetry point coding 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 second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is associated with the identification of the telemetry point coding data record and has not been archived, recording the collection value of the target monitoring record as exceeding the second upper limit value of the telemetry point coding data record, and generating first alarm content based on the target monitoring record to obtain the analysis result; in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is associated with the identification of the telemetry point coding data record and has not been archived, recording the collection value of the target monitoring record as exceeding the first upper limit value of the telemetry point coding data record, and generating second alarm content based on the target monitoring record to obtain the analysis result.

[0013] Optionally, the determining whether the alarm type meets the alarm requirement comprises: in response to the alarm type being greater than a second upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval time length of the telemetry point coded data record, and the number of times of sending the second alarm of the query record being less than the number of times of sending the second alarm of the telemetry point coded data record, generating third alarm content based on the target monitoring record to obtain the analysis result; in response to the alarm type being greater than a first upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval time length of the telemetry point coded data record, and the number of times of sending the first alarm of the query record being less than the number of times of sending the first alarm of the telemetry point coded data record, generating fourth alarm content based on the target monitoring record to obtain the analysis result; and in response to the alarm type being alarm reset of the target monitoring record, the difference between the collection time of the target monitoring record and the reset time of the query record being greater than or equal to the reset time delay of the telemetry point coded data record, generating fifth alarm content based on the target monitoring record to obtain the analysis result.

[0014] According to one of the embodiments of the present application, a substation fire pool monitoring and alarming system is also provided, which comprises a monitoring auxiliary analysis device, an Ethernet connection control device, an edge gateway and an ultrasonic sensor. The ultrasonic sensor is configured to measure the water level of the substation fire pool to obtain ultrasonic sensor monitoring data. The edge gateway is configured to report the ultrasonic sensor monitoring data to a monitoring auxiliary database to generate a target monitoring record. The monitoring auxiliary analysis device is configured 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 configured to control a target office device to send an Ethernet connection alarm message to a target object based on the analysis result.

[0015] According to one of the embodiments of the present application, a substation fire pool monitoring and alarming device is also provided, which comprises an obtaining module, an analysis module and a control module. The obtaining module is configured to obtain a target monitoring record from a monitoring auxiliary database. The monitoring auxiliary database is configured to store at least ultrasonic sensor monitoring data reported by an edge gateway. The ultrasonic sensor monitoring data is obtained by measuring the water level of a substation fire pool using an ultrasonic sensor. The analysis module is configured to perform alarm analysis on the target monitoring record to obtain an analysis result. The control module is configured to control a target office device to send an Ethernet connection alarm message to a target object based on the analysis result.

[0016] Optionally, the obtaining module is further configured to obtain, from the telemetry data table of the monitoring auxiliary database, a target monitoring record meeting a preset collection condition according to a preset period. The preset collection condition is determined according to a data type and a collection time.

[0017] Optionally, the acquisition module is further configured to acquire, from the alarm rule configuration table, a telemetry point coding data record corresponding to the target monitoring record; in response to the collection value of the target monitoring record being greater than a first upper limit value of the telemetry point coding data record, acquire, from the alarm record table, a query record associated with an alarm rule identification being the identification of the telemetry point coding data record and not being archived; and perform alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point coding data record, and the query record to obtain an analysis result.

[0018] Optionally, the analysis module is further configured to perform alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point coding data record, and the query record to acquire an alarm type of the target monitoring record; determine whether the alarm type meets an alarm requirement to obtain an analysis result.

[0019] Optionally, the analysis module is further configured to, in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determine the alarm type to be that the acquisition value of the target monitoring record is upgraded to the second upper limit alarm after the first upper limit is reset, update the second upper limit alarm value of the query record to the acquisition value of the target monitoring record, update the second upper limit time of the query record to the acquisition time of the query record, 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 second 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 upper limit value of the telemetry point coding data record, determine the alarm type to be that the acquisition value of the target monitoring record continues the second upper limit alarm after the last alarm is reset, and mark the record type of the query record as a second frequent signal; in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determine the alarm type to be that the acquisition value of the target monitoring record is converted to the second upper limit alarm during the unreset period of the first upper limit, update the second upper limit alarm value of the query record to the acquisition value of the target monitoring record, and update the second upper limit 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 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 greater than the second upper limit value of the telemetry point coding data record, determine the alarm type to be that the acquisition value of the target monitoring record continues the second upper limit alarm; and in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry point coding data record, and the last alarm and the second upper limit alarm value of the query record both being empty, determine the alarm type to be that the acquisition value of the target monitoring record is a first second upper limit alarm, update the second upper limit alarm value of the query record to the acquisition value of the target monitoring record, and update the second upper limit time of the query record to the acquisition time of the query record.

[0020] Optionally, the analysis module is further configured to, in response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry 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 second 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 the current acquisition value exceeds the first upper limit value, update the first alarm time of the query record to the acquisition time of the query record, record the first alarm frequency 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 upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, the last alarm value of the query record being less than the second 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 first order alarm and the current acquisition value exceeds the first upper limit value, update the reset time of the query record to empty, record the first alarm value of the query record as the acquisition value of the target monitoring record, update the alarm time of the query record to the acquisition time of the query record, 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 upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second 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 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 exceeds the second upper limit value of the telemetry point coding data record and then falls below the first upper limit value of the telemetry point coding data record, and in response to the second order alarm value of the query record being not empty, record the first alarm value of the query record as the acquisition value of the target monitoring record, and update the alarm 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 first upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time and the alarm time of the query record being empty, determine that the alarm type is that the acquisition value of the target monitoring record exceeds the first upper limit value of the telemetry point coding data record, and no alarm has been sent temporarily.

[0021] Optionally, the analysis module is further configured to, in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded data record, the reset time of the query record being empty, 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 sent, updating the first alarm value of the query record to the acquisition value of the target monitoring record, and updating 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 upper limit value of the telemetry point coded data record, the reset time of the query record 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 has been reset, but the time for sending the reset alarm has not been reached; in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded data record, the reset time of the query record and the alarm time of the query record being empty, determining that the alarm type is that the acquisition value of the target monitoring record has been reset before the reset delay of the telemetry point coded data record, and updating the archiving flag of the query record.

[0022] Optionally, the analysis module is further configured to acquire 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 upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table that is associated with the alarm rule identifier of the telemetry point coded data record and has not been archived, recording the acquisition value of the target monitoring record as exceeding the second upper limit value of the telemetry point coded data record, and generating first alarm content 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 upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table that is associated with the alarm rule identifier of the telemetry point coded data record and has not been archived, recording the acquisition value of the target monitoring record as exceeding the first upper limit value of the telemetry point coded data record, and generating second alarm content based on the target monitoring record to obtain an analysis result.

[0023] Optionally, the analysis module is further configured to: in response to the alarm type being a second upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval duration of the telemetry point coded data record, the first alarm sending number of the query record being less than the first alarm number of the record telemetry point coded data record, generating third alarm content based on the target monitoring record to obtain an analysis result; in response to the alarm type being a first upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval duration of the telemetry point coded data record, the first alarm sending number of the query record being less than the first alarm number of the record telemetry point coded data record, generating fourth alarm content based on the target monitoring record to obtain an analysis result; in response to the alarm type being alarm reset of the target monitoring record, the difference between the collection time of the target monitoring record and the reset time of the query record being greater than or equal to the reset delay of the telemetry point coded data record, generating fifth alarm content based on the target monitoring record to obtain an analysis result.

[0024] According to one of the embodiments of the present application, a computer readable storage medium is provided, and the computer readable storage medium stores a computer program. When the computer program is executed on a computer or a processor, the substation fire-fighting pool monitoring alarm method in any one of the above embodiments is executed.

[0025] According to one of the embodiments of the present application, an electronic device is provided, which comprises a memory and a processor. The memory stores a computer program, and the processor is configured to execute the computer program to execute the substation fire-fighting pool monitoring alarm method in any one of the above embodiments.

[0026] According to one of the embodiments of the present application, a computer program product is provided, which comprises a computer program. When the computer program is executed on a processor, the substation fire-fighting pool monitoring alarm method in any one of the above embodiments is implemented.

[0027] In this embodiment of the invention, target monitoring records are obtained from a monitoring auxiliary database, which stores at least 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 an ultrasonic sensor. Alarm analysis is performed on the target monitoring records to obtain analysis results. Based on the analysis results, the target office equipment is controlled to send an Ethernet connection alarm message to the target object. This effectively reduces the labor intensity of personnel and improves the safety and reliability of substation operation. Thus, the technical effect of real-time monitoring, intelligent alarm, and data aggregation of water level is achieved by using an automatic water level detection device, ultrasonic sensors, and edge gateways. This solves the technical problems of time-consuming and labor-intensive manual on-site inspections and the potential hazards to the safe operation of substations. Attached Figure Description

[0028] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:

[0029] Figure 1 This is a flowchart of a substation fire water tank monitoring and alarm method according to one embodiment of the present invention;

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

[0031] Figure 3 This is a flowchart illustrating the monitoring and alarm method for fire-fighting water tanks in substations according to one embodiment of the present invention.

[0032] Figure 4 This is a structural block diagram of a substation fire water tank monitoring and alarm device according to one embodiment of the present invention. Detailed Implementation

[0033] For ease of understanding, some concepts related to the embodiments of the present invention are explained by way of example for reference.

[0034] As shown below:

[0035] Fire water tank monitoring and alarm system: A device used to monitor parameters such as water level, water quality, and temperature in fire water tanks. Once an abnormality is detected, it will immediately issue an alarm signal so that firefighters can handle the situation in a timely manner.

[0036] In the following, the technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all the other embodiments obtained by a person of ordinary skill in the art without creative effort should fall into the protective scope of the present application.

[0037] It should be noted that the terms "first", "second" and the like in the description and claims of the present application and the above drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in other than the order illustrated or described herein. In the description of the embodiments, unless otherwise specified, the meaning of "a plurality of" is two or more. In addition, the terms "comprise" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device including a series of steps or units does not have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to these processes, methods, products or devices.

[0038] According to an embodiment of the present application, an embodiment of a substation fire-fighting pool monitoring and alarming method is provided. It should be noted that the steps shown in the flowchart of the 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 herein can be executed in an order different from that shown herein.

[0039] The method embodiment can be executed in an electronic device including a memory and a processor, a similar control device or system. Taking the electronic device as an example, the electronic device can include one or more processors and a memory for storing data. Optionally, the above electronic device can further include a communication device for communication function and a display device. Those skilled in the art can understand that the above structural description is only illustrative, and does not limit the structure of the above electronic device. For example, the electronic device can further include more or less components than the above structural description, or have a different configuration from the above structural description.

[0040] The processor can include one or more processing units. For example, the processor can 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 processing unit (NPU), a tensor processing unit (TPU), an artificial intelligent (AI) type processor, or the like. Different processing units can be independent components or integrated in one or more processors. In some examples, the electronic device can also include one or more processors.

[0041] The memory can be used to store a computer program, for example, a computer program corresponding to the substation fire-fighting pool monitoring and alarming method in the embodiments of the present application. The processor realizes the above-mentioned substation fire-fighting pool monitoring and alarming method by running the computer program stored in the memory. The memory can include a high-speed random access memory, and can also include a non-volatile memory, such as one or more magnetic storage devices, flash memories, or other non-volatile solid-state memories. In some examples, the memory can further include a memory remotely arranged with respect to the processor, which can be connected to the electronic device through 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 a combination thereof.

[0042] The communication device is used to receive or send data via a network. Specific examples of the above-mentioned network can include a wireless network provided by a communication provider of a mobile terminal. In one example, the communication device includes a 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 in a wireless manner.

[0043] The display device can be, for example, a liquid crystal display (LCD) and a touch display (also known as a "touch screen" or "touch display screen") in the form of a touch screen. The liquid crystal display can enable a user to interact with a user interface of the mobile terminal. In some embodiments, the mobile terminal described above has a graphical user interface (GUI), with which a user can interact with the GUI by finger contact and / or gestures on the touch-sensitive surface, where the human-machine interaction functions optionally include one or more of the following: creating web pages, drawing, text editing, preparing electronic documents, games, video conferencing, instant messaging, telephony, video playback, music playback, and / or web browsing, executable instructions for performing the above-mentioned human-machine interaction functions are configured / stored in one or more computer program products or readable storage media executable by the processor.

[0044] In the present embodiment, a substation fire-fighting pool monitoring and alarming method running on an electronic device is provided, Figure 1 is a flow chart of the substation fire-fighting pool monitoring and alarming method according to an embodiment of the present application, as Figure 1 shown, the flow includes the following steps:

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

[0046] In the embodiment of the present application, the monitoring auxiliary database can be understood as a database storing data related to the substation fire-fighting pool. For example, the monitoring auxiliary database contains a personnel information table, an alarm rule configuration table, an alarm record table, a sending information record table, a telemetry data table, and a frequent signal table, etc., wherein the telemetry data table stores various data collected from the substation, including the water level data of the fire-fighting pool, which is not limited here.

[0047] The target monitoring records can be understood as monitoring data or information about the water level of the fire-fighting pool obtained by a monitoring device or system. For example, the target monitoring records can be the water level of the fire-fighting pool, which is not limited here.

[0048] The edge gateway can be understood as a device for monitoring and managing the state and water level of the fire-fighting 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 pool. Illustratively, the ultrasonic sensor can be installed on the fire pool and used to measure the height of the water level in the fire pool, which is not limited here.

[0050] The water level height can be understood as a data index reflecting whether the amount of water in the fire pool is sufficient.

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

[0052] In the embodiment of the present application, the target monitoring record is obtained from the monitoring auxiliary database, wherein the monitoring auxiliary database is used at least 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 pool in the substation using the ultrasonic sensor. Thus, the monitoring data stored in the database can be used for data analysis to find out the change trend of the water level height, predict possible problems, and take measures in advance.

[0053] In step S11, the target monitoring record is analyzed for alarm, and an analysis result is obtained.

[0054] In the embodiment of the present application, the alarm analysis can be understood as an analysis of whether the target monitoring record meets the preset fire pool water level height condition. Illustratively, the abnormal situation or trend in the monitoring record is analyzed according to the related data of the fire pool, which is not limited here.

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

[0056] The alarm analysis of the target monitoring record to obtain the analysis result can be understood as an analysis of whether the target monitoring record meets the preset fire pool water level height condition, and an analysis conclusion is given. Illustratively, the abnormal situation or trend in the monitoring record can be analyzed and alarm information can be generated to conclude whether the fire pool water level is normal, which is not limited here.

[0057] In the embodiment of the present application, the related data of the fire pool is monitored and analyzed for alarm to timely discover and solve possible problems or risks. Through the analysis result, the operation of the fire pool can be better understood, abnormal situations can be handled in time, and the normal operation and safety of the fire pool can be ensured.

[0058] In step S12, the target office equipment is controlled to send an Ethernet connection alarm message to the target object based on the analysis result.

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

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

[0061] The Ethernet connection alarm message can be understood as a sending method of the alarm information. For example, the Ethernet connection alarm message can be sent to the target object using ELINK, which is not limited herein.

[0062] Based on the analysis result, the target office equipment is controlled to send an Ethernet connection alarm message to the target object, which can be understood as a conclusion obtained based on the alarm analysis of the target monitoring record. The device for sending alarm information is controlled to send an ELINK alarm message to the relevant person, which is not limited herein.

[0063] In the embodiment of the present application, based on the analysis result, the target office equipment is controlled to send an Ethernet connection alarm message to the target object. The various situations of the fire pool can be timely informed to the relevant personnel, and the staff can timely handle the safety hazard problems of the fire pool, thereby ensuring the normal operation and safety of the fire pool.

[0064] The target monitoring record is obtained from a monitoring auxiliary database. The monitoring auxiliary database is used to store at least the ultrasonic sensor monitoring data reported by the edge gateway. The ultrasonic sensor monitoring data is obtained by measuring the water level height of the fire pool in the substation using an ultrasonic sensor. Thus, the monitoring data stored in the database can be used for data analysis to find out the change trend of the water level height, predict possible problems, and take measures in advance. The related data of the fire pool is monitored and recorded, and alarm analysis is performed thereon, so as to timely find and solve possible problems or risks. Through the analysis result, the operation of the fire pool can be better understood, and abnormal conditions can be timely handled, thereby ensuring the normal operation and safety of the fire pool. Based on the analysis result, the target office equipment is controlled to send an Ethernet connection alarm message to the target object, which can timely inform the relevant personnel of the various situations of the fire pool, and the staff can timely handle the safety hazard problems of the fire pool, thereby ensuring the normal operation and safety of the fire pool.

[0065] Through the above steps, the target monitoring record is obtained from the monitoring auxiliary database, wherein the monitoring auxiliary database is used for at least storing the ultrasonic sensor monitoring data reported by the edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level of the fire pool in the transformer substation by using the ultrasonic sensor; the target monitoring record is analyzed to obtain an analysis result; and the target office equipment is controlled to send an Ethernet connection alarm message to the target object based on the analysis result, thereby effectively reducing the labor intensity of personnel and improving the safety and reliability of the operation of the transformer substation, so as to achieve the technical effects of realizing real-time monitoring, intelligent alarm and data aggregation of the water level by using the automatic water level detection device, the ultrasonic sensor and the edge gateway and the like, and further solve the technical problems of time-consuming and labor-consuming caused by manual regular on-site patrol and hidden dangers to the safe operation of the transformer substation.

[0066] Figure 2 is a data flow conversion diagram of a transformer substation fire pool monitoring and alarming method according to an embodiment of the present application, as shown in Figure 2 a technical and architectural structure for intelligent monitoring and alarming of a transformer substation fire pool, mainly including a monitoring auxiliary database and a monitoring auxiliary analysis module in the three zones, an electronic link (ELINK) control module and four-zone office machines in the four zones, an edge gateway in the third zone of the station, an ultrasonic sensor and a fire pool. The monitoring auxiliary database contains a personnel information table, an alarm rule configuration table, an alarm record table, a sending information record table, a telemetry data table, a frequent signal table and the like. The content of the alarm rule configuration table can include

identification number

telemetry point code

station code

lower limit value

first-order upper limit value

second-order upper limit value

sending personnel

sending method

one-order delay

two-order delay

one-order alarm number

two-order alarm number

alarm interval duration

reset delay

alarm record identification number

associated alarm rule identification number (identification number of the alarm rule configuration table)

alarm value

alarm time

two-order alarm value

two-order time

last alarm value

last alarm time

reset time

one-order alarm sent number

two-order alarm sent number

whether to archive

record identification number

sending object

sending content

sending time

whether sent

sending method

associated alarm record table identification number

frequent signal code

acquisition value

acquisition time

record type

telemetry point code

data type

associated station name

acquisition time

acquisition value

[0067] The monitoring auxiliary analysis module can obtain various stored data from the monitoring auxiliary database for alarm analysis, and can store the analysis results to the monitoring auxiliary database. The ELINK control module can obtain the result data analyzed by the monitoring auxiliary analysis module, and control the four-zone office machine to send ELINK alarm information to a specified group. The four-zone office machine is an office host with ELINK office software installed therein. The edge gateway can receive the data collected by the ultrasonic sensor, and upload the data to the three-zone monitoring auxiliary database and store the data in the telemetry data table. The ultrasonic sensor is a device installed on the fire pool, used to measure the water level in the fire pool.

[0068] Figure 3 is a flow chart of a substation fire pool monitoring alarm method according to an embodiment of the present application, as shown in Figure 3 The flow steps of the substation fire pool monitoring alarm method mainly include five steps, which are: first, screening the fire data; second, data out-of-limit step judgment on the fire data; third, judging the alarm requirements and generating the alarm content; and finally, alarming through the electronic link module. The specific content is shown in the following steps:

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

[0070] obtaining the target monitoring record from the telemetry data table of the monitoring auxiliary database according to a preset period and a preset collection condition, wherein the preset collection condition is determined according to the data type and the collection time.

[0071] In the embodiment of the present application, the target monitoring record from the telemetry data table of the monitoring auxiliary database according to a preset period and a preset collection condition, wherein the preset collection condition is determined according to the data type and the collection time, which can be understood as an example, 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 power carrier technology, and then uploads the information to the three-zone power grid monitoring auxiliary system, and stores the data in the telemetry data table of the power grid monitoring auxiliary database after conversion. The monitoring auxiliary analysis module will obtain a data record set T with the data type of "fire pool" and the latest collection time from the telemetry data table of the monitoring auxiliary database.

[0072] Optionally, in step S10, the monitoring auxiliary database also stores an alarm rule configuration table and an alarm record table, and the alarm analysis on the target monitoring record can include the following execution steps:

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

[0074] Step S102, in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, obtaining the query record from the alarm record table, the query record being associated with the alarm rule identification being the identification of the telemetry point coding data record and not being archived;

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

[0076] In the embodiment of the application, the telemetry point coding data record corresponding to the target monitoring record is obtained from the alarm rule configuration table, in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the query record is obtained from the alarm record table, the query record being associated with the alarm rule identification being the identification of the telemetry point coding data record and not being archived, and the target monitoring record is analyzed based on the target monitoring record, the telemetry point coding data record and the query 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, and now taking one of the records R as an example: the monitoring auxiliary analysis module obtains the data record R2 of the telemetry point coding corresponding to the telemetry point coding of the record R from the alarm rule configuration table, and then judges whether the collection value of the record R is greater than the first upper limit value of the record R2. If the condition is met, the record R3 of the identification number of the associated rule identification number being the identification number of the record R2 and not being archived is queried from the alarm record table of the monitoring auxiliary database; otherwise, the next record in the record set T is continuously executed. The target monitoring record is analyzed based on the target monitoring record, the telemetry point coding data record and the query record to obtain an analysis result, which is not limited here.

[0077] Optionally, in step S103, the target monitoring record is analyzed based on the target monitoring record, the telemetry point coding data record and the query record to obtain an analysis result, which can include the following execution steps:

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

[0079] Step S1032, determining whether the alarm type meets the alarm requirement to obtain an analysis result.

[0080] In the embodiment of the present application, based on the target monitoring record, the telemetry point coding data record and the query record, the target monitoring record is analyzed for alarm, the alarm type of the target monitoring record is acquired, whether the alarm type meets the alarm requirement is determined, and the analysis result is obtained. It can be understood that, the target monitoring record is analyzed for alarm based on the target monitoring record, the telemetry point coding data record and the query record, the alarm type of the target monitoring record is acquired, whether the alarm type meets the alarm requirement is determined, and the analysis result is obtained. The analysis result is not limited herein.

[0081] Optionally, in step S1031, based on the target monitoring record, the telemetry point coding data record and the query record, the target monitoring record is analyzed for alarm, and the alarm type of the target monitoring record is acquired, which can include the following execution steps:

[0082] In response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, it is determined that the alarm type is that the acquisition value of the target monitoring record is upgraded to the more-than-second-upper-limit alarm after the reset of the more-than-first-upper-limit, the more-than-second-upper-limit alarm value of the query record is updated to the acquisition value of the target monitoring record, the more-than-second-upper-limit 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 the frequent signal;

[0083] In response to the acquisition value of the target monitoring record being greater than the second 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 upper limit value of the telemetry point coding data record, it is determined that the alarm type is that the acquisition value of the target monitoring record continues the more-than-second-upper-limit alarm after the reset of the last alarm, and the record type of the query record is marked as the second frequent signal;

[0084] In response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, it is determined that the alarm type is that the acquisition value of the target monitoring record is converted to the more-than-second-upper-limit alarm during the non-reset period of the more-than-first-upper-limit, the more-than-second-upper-limit alarm value of the query record is updated to the acquisition value of the target monitoring record, and the more-than-second-upper-limit time of the query record is updated 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 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 greater than the second upper limit value of the telemetry point coding data record, it is determined that the alarm type is a second upper limit alarm of the acquisition value of the target monitoring record.

[0086] In response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry point coding data record, the last alarm and the second upper limit alarm value of the query record being empty, it is determined that the acquisition value of the target monitoring record is a first second upper limit alarm, the second upper limit alarm value of the query record is updated to the acquisition value of the target monitoring record, and the second upper limit time of the query record is updated to the acquisition time of the query record.

[0087] In the embodiment of the application, the monitoring auxiliary analysis module compares whether the acquisition value of the record R is greater than the second upper limit value of the record R2. If this condition is met, the following judgment is performed, which can be understood as an example:

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

[0089] If the record R3 exists, the reset time of the record R3 is not empty, and the last alarm value of the record R3 is greater than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R continues to exceed the second upper limit value after the reset of the last alarm, the record R3 is marked as a second frequent signal (corresponding to the record type in the frequent signal table), and is stored in the frequent signal table, which is not limited here.

[0090] If the record R3 exists, the reset time of the record R3 is empty, and the last alarm value of the record R3 is greater than the first upper limit value of the record R2 but less than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R changes to a second upper limit alarm during the non-reset period of the first upper limit alarm, the second upper limit alarm value of the record R3 is updated to the acquisition value of the record R, and the second upper limit time is the acquisition time of the record R, which is not limited here.

[0091] If the record R3 exists, the reset time of the record R3 is empty, and the last alarm value of the record R3 is greater than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R continues to exceed the second upper limit, which is not limited here.

[0092] If the record R3 exists, and the last alarm of the record R3 is null, and the over two-order alarm value of the record R3 is null, it indicates that the collection value of the record R is the first over two-order upper limit, and then the over two-order alarm value of the record R3 is updated to the collection value of the record R, and the over two-order time is the collection time of the record R, which is not limited here.

[0093] Optionally, in step S1031, based on the target monitoring record, the telemetry point coding data record, and the query record, alarm analysis is performed on the target monitoring record, and the alarm type of the target monitoring record is obtained, and the following execution steps are further included:

[0094] 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 being less than the two-order upper limit value of the telemetry point coding data record, the reset time of the query record being not null, and the last alarm value of the query record being greater than the two-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 is temporarily reset after sending a two-order alarm and again exceeds the first-order upper limit value this time, the first-order alarm time of the query record is updated to the collection time of the query record, the first-order alarm frequency of the query record is recorded as 0, and the record type of the query record is marked as a frequent signal.

[0095] 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 being less than the two-order upper limit value of the telemetry point coding data record, the reset time of the query record being not null, and the last alarm value of the query record being less than the two-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 is temporarily reset after sending a first-order alarm and again exceeds the first-order upper limit value this time, the reset time of the query record is updated to null, the first-order alarm value of the query record is recorded as the collection value of the target monitoring record, the alarm time of the query record is updated to the collection time of the query record, and the record type of the query record is marked as a frequent signal.

[0096] 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 being less than the two-order upper limit value of the telemetry 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 two-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 exceeds the two-order upper limit value of the telemetry point coding data record and then falls to the first-order upper limit value of the telemetry point coding data record, and in response to the over two-order alarm value of the query record being not null, the first-order alarm value of the query record is recorded as the collection value of the target monitoring record, and the alarm time of the query record is updated to the collection time of the query record.

[0097] In response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second 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 empty, it is determined that the alarm type is that the acquisition value of the target monitoring record exceeds the first upper limit value of the telemetry point coding data record, and no alarm has been sent.

[0098] In the embodiment of the application, the monitoring auxiliary analysis module analyzes that the acquisition value of the record R is greater than the first upper limit value of the record R2 but less than the second upper limit value of the record R2, and then the following judgment is performed. It can be understood exemplarily as follows:

[0099] If the record R3 exists, the reset time of the record R3 is not empty, and the last alarm value of the record R3 is greater than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R exceeds the first upper limit value after the second alarm is sent and then resets temporarily, and the acquisition value exceeds the first upper limit value again in this acquisition. Therefore, the acquisition time of the record R is updated as the acquisition time of the record R, the first alarm number of the record R 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.

[0100] If the record R3 exists, the reset time of the record R3 is not empty, and the last alarm value of the record R3 is less than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R exceeds the first upper limit value after the first alarm is sent and then resets temporarily, and the acquisition value exceeds the first upper limit value again in this acquisition. Therefore, the reset time of the record R3 is updated as empty, the alarm value of the record R3 is the acquisition value of the record R, and the alarm time of the record R3 is the acquisition 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.

[0101] If the record R3 exists, the reset time of the record R3 is empty, and the last alarm value of the record R3 is less than the second upper limit value of the record R2, it is indicated that the acquisition value of the record R exceeds the second upper limit value of the record R2 and will exceed the first upper limit value. If the second alarm value of the record R3 is not empty, the first alarm value of the record R3 is updated as the acquisition value of the record R, and the first alarm event of the record R3 is the acquisition time of the record R.

[0102] If the record R3 exists, the reset time of the record R3 is empty, and the alarm time is also empty, it is indicated that the acquisition value of the record R exceeds the first upper limit value of the record R2, but no alarm has been sent, and this is not limited.

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

[0104] in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded 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 the current acquisition after the alarm is sent, updating the first alarm value of the query record to the acquisition value of the target monitoring record, and updating 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 upper limit value of the telemetry point coded data record, the reset time of the query record being not 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 has been reset, but the time of sending the reset alarm has not been reached;

[0106] in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded data record, the reset time of the query record being empty, and the alarm time of the query record being empty, determining that the alarm type is that the acquisition value of the target monitoring record has been reset before the reset delay of the telemetry point coded data record is reached, and updating the archiving flag of the query record.

[0107] In the embodiment of the application, the monitoring auxiliary analysis module analyzes that the acquisition value of the record R is not greater than the first upper limit of the record R2, and then the following judgment is performed, which can be understood as an example:

[0108] in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded 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 the current acquisition after the alarm is sent, updating the first alarm value of the query record to the acquisition value of the target monitoring record, and updating the acquisition time and the reset time of the query record to the acquisition time of the target monitoring record, which can be understood as that, if the record R3 exists, and the reset time of the record R3 is empty and the alarm time is not empty, it indicates that the current acquisition point is reset in the current acquisition after the alarm is sent. Therefore, the alarm value of the record R3 is updated to the acquisition value of the record R, the acquisition time of the record R3 is updated to the acquisition time of the record R, the reset time of the record R is updated to the acquisition time of the record R, and then the alarm requirement judgment is performed, which is not limited here;

[0109] In response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coded data record, and the reset time of the query record and the alarm time of the query record both being not empty, it is determined that the alarm type is that the acquisition value of the target monitoring record has been reset, but the time for sending a reset alarm has not been reached. It can be understood that if the record R3 exists, and the reset time of the record R3 is not empty, and the alarm time is not empty, it indicates that the acquisition value of the record R has been reset, but the time for sending a reset alarm has not been reached. Then, 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 upper limit value of the telemetry point coded data record, and the reset time of the query record and the alarm time of the query record both being empty, it is determined that the acquisition time of the target monitoring record has been reset without reaching the reset delay of the telemetry point coded data record, and the archiving flag of the query record is updated. It can be understood that if the record R3 exists, and the reset time of the record R3 is empty, and the alarm time is empty, it indicates that the acquisition time of the record R has been reset without reaching the reset delay of the record R2. Therefore, whether the record R3 is archived is updated to “yes”, and then the next record in the record set T is analyzed, which is not limited here.

[0111] Optionally, the alarm rule configuration table and the alarm record table are further stored in the monitoring auxiliary database. The target monitoring record is subjected to alarm analysis, and the analysis result can include the following execution steps:

[0112] The telemetry point coded data record corresponding to the target monitoring record is obtained from the alarm rule configuration table.

[0113] In response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table that is not archived and has an alarm rule identification associated with the identification of the telemetry point coded data record, the acquisition value of the target monitoring record is recorded as exceeding the second upper limit value of the telemetry point coded data record, and first alarm content is generated based on the target monitoring record to obtain the analysis result.

[0114] In response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetry point coded data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coded data record, and there being no query record in the alarm record table that is not archived and has an alarm rule identification associated with the identification of the telemetry point coded data record, the acquisition value of the target monitoring record is recorded as exceeding the first upper limit value of the telemetry point coded data record, and second alarm content is generated based on the target monitoring record to obtain the analysis result.

[0115] In the embodiment of the application, after the telemetry point coded data record corresponding to the target monitoring record is obtained from the alarm rule configuration table, the following judgment steps can be further included, which can be understood as an example:

[0116] The monitoring auxiliary analysis module analyzes that the collection value of the record R is greater than the first-order upper limit value of the record R2 but less than the second-order upper limit value of the record R2, that is, if the record R3 does not exist, it indicates that the record R is the first time to exceed the first-order upper limit value of the record R2, and the record R is generated as an alarm record R4 and stored in the alarm record table.

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

[0118] Optionally, determining whether the alarm type meets the alarm requirement, and the analysis result can 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 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 being greater than or equal to the alarm interval duration of the telemetry point coded data record, the second-order alarm sending number of the query record being less than the second-order alarm number of the record telemetry point coded data record, generating third alarm content based on the target monitoring record, and obtaining the 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 being greater than or equal to the alarm interval duration of the telemetry point coded data record, the first-order alarm sending number of the query record being less than the first-order alarm number of the record telemetry point coded data record, generating fourth alarm content based on the target monitoring record, and obtaining the analysis result;

[0121] In response to the alarm type being alarm reset of the target monitoring record, the difference between the collection time of the target monitoring record and the reset time of the query record being greater than or equal to the reset time delay of the telemetry point coded data record, generating fifth alarm content based on the target monitoring record, and obtaining the analysis result.

[0122] In the embodiment of the present application, the monitoring auxiliary analysis module judges whether the alarm requirement is reached according to different alarm types. It can be understood exemplarily that when the alarm type is the second upper limit value of the collection value of the target monitoring record exceeding the telemetry point coding data record, if the collection time of the record R-the last alarm time of the record R3 is greater than or equal to the alarm interval time length of the record R2, and the number of times of the second alarm of the record R3 has been sent is less than the number of times of the second alarm of the record R2, the alarm content is generated, otherwise the next record in the record set T is continuously analyzed, which is not limited here.

[0123] When the alarm type is the first upper limit value of the collection value of the target monitoring record exceeding the telemetry point coding data record, if the collection time of the record R-the last alarm time of the record R3 is greater than or equal to the alarm interval time length of the record R2, and the number of times of the first alarm of the record R3 has been sent is less than the number of times of the first alarm of the record R2, the alarm content is generated, otherwise the next record in the record set T is continuously analyzed, which is not limited here.

[0124] When the alarm type is the alarm reset of the target monitoring record, if the collection time of the record R-the reset time of the record R3 is greater than or equal to the reset time delay of the record R2, the alarm content is generated, otherwise the next record in the record set T is continuously analyzed, which is not limited here.

[0125] After the monitoring auxiliary analysis module judges the alarm requirement, the alarm content is generated, exemplarily:

[0126] When the alarm type is the second upper limit value of the collection value of the target monitoring record exceeding the telemetry point coding data record, the alarm information:

fire pool water level alarm

[0127] When the alarm type is the first upper limit value of the collection value of the target monitoring record exceeding the telemetry point coding data record, the alarm information:

fire pool water level alarm

[0128] When the alarm type is the alarm reset of the target monitoring record, the alarm reset information:

fire pool water level alarm reset

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

[0130] The ELINK control module sends a request for obtaining the ELINK alarm notification to the monitoring auxiliary analysis module every minute. After receiving the request, the ELINK control module obtains the record T2 with the not sent field as "No" and the sending mode as "ELINK" from the sending information record table of the monitoring auxiliary database, and then sends the record T2 to the ELINK control module. Meanwhile, the not sent field of the record with the not sent field as "No" and the sending mode as "ELINK" in the sending information record table is updated to "Yes". After receiving the record T2, the ELINK control module controls the ELINK software of the office machine to send the information of the sending content to the sender in the record T2, which is not limited here.

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

[0132] According to one of the embodiments of the present application, a substation fire-fighting pool monitoring and alarming system is also provided, which comprises 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 of the fire-fighting pool 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 a target monitoring record. 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.

[0133] A substation fire-fighting pool monitoring and alarming device is also provided in the embodiment. The device is used to implement the above-mentioned embodiments and preferred embodiments, and will not be described again. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the device described in the following embodiments is preferably implemented in software, implementation of hardware, or a combination of software and hardware, is also possible and contemplated.

[0134] Figure 4 FIG. 1 is a structural diagram of a substation fire-fighting pool monitoring and alarming device according to an embodiment of the present application, as shown in Figure 4 The device 400 includes an acquisition module 401, an analysis module 402, and a control module 403. The acquisition module 401 is configured to acquire target monitoring records from a monitoring auxiliary database. The monitoring auxiliary database is used to store at least ultrasonic sensor monitoring data reported by an edge gateway. The ultrasonic sensor monitoring data is obtained by measuring the water level of a substation fire-fighting pool using an ultrasonic sensor. The analysis module 402 is configured to perform alarm analysis on the target monitoring records to obtain an analysis result. The control module 403 is configured to control a target office equipment to send an Ethernet connection alarm message to a target object based on the analysis result.

[0135] Optionally, the acquisition module 401 is further configured to acquire, from a telemetry data table of the monitoring auxiliary database, target monitoring records that meet preset collection conditions in a preset period. The preset collection conditions are determined according to data types and collection times.

[0136] Optionally, the acquisition module 401 is further configured to acquire, from an alarm rule configuration table, telemetry point code data records corresponding to the target monitoring records. In response to a collection value of the target monitoring records being greater than a first upper limit value of the telemetry point code data records, the acquisition module 401 is further configured to acquire, from an alarm record table, query records that are associated with alarm rule identifiers of the telemetry point code data records and are not archived. The analysis module 402 is further configured to perform alarm analysis on the target monitoring records based on the target monitoring records, the telemetry point code data records, and the query records to obtain the analysis result.

[0137] Optionally, the analysis module 402 is further configured to perform alarm analysis on the target monitoring records based on the target monitoring records, the telemetry point code data records, and the query records to obtain an alarm type of the target monitoring records. The analysis module 402 is further configured to determine whether the alarm type meets an alarm requirement to obtain the analysis result.

[0138] Optionally, the analysis module 402 is further configured to, in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determine the alarm type as the acquisition value of the target monitoring record upgrading from the alarm beyond the first upper limit to the alarm beyond the second upper limit after the reset, update the alarm value beyond the second upper limit of the query record to the acquisition value of the target monitoring record, update the time beyond the second upper limit of the query record to the acquisition time of the query record, 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 second 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 upper limit value of the telemetry point coding data record, determine the alarm type as the acquisition value of the target monitoring record continuously alarming beyond the second upper limit after the reset of the last alarm, and mark the record type of the query record as a second frequent signal; in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry 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 upper limit value of the telemetry point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetry point coding data record, determine the alarm type as the acquisition value of the target monitoring record changing to the alarm beyond the second upper limit during the unreset period of the alarm beyond the first upper limit, update the alarm value beyond the second upper limit of the query record to the acquisition value of the target monitoring record, and update the time beyond the second upper limit 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 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 greater than the second upper limit value of the telemetry point coding data record, determine the alarm type as the acquisition value of the target monitoring record continuously alarming beyond the second upper limit; and in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetry point coding data record, and the last alarm and the alarm value beyond the second upper limit of the query record both being empty, determine the alarm type as the acquisition value of the target monitoring record being the first alarm beyond the second upper limit, update the alarm value beyond the second upper limit of the query record to the acquisition value of the target monitoring record, and update the time beyond the second upper limit of the query record to the acquisition time of the query record.

[0139] Optionally, the analysis module 402 is further configured to, in response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry 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 second 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 the current acquisition value exceeds the first upper limit value again, update the first alarm time of the query record to the acquisition time of the query record, record the first alarm frequency 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 upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time of the query record being not empty, the last alarm value of the query record being less than the second 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 first order alarm and the current acquisition value exceeds the first upper limit value again, update the reset time of the query record to empty, record the first alarm value of the query record as the acquisition value of the target monitoring record, update the alarm time of the query record to the acquisition time of the query record, 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 upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second 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 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 exceeds the second upper limit value of the telemetry point coding data record and then falls below the first upper limit value of the telemetry point coding data record, and in response to the second order alarm value of the query record being not empty, record the first alarm value of the query record as the acquisition value of the target monitoring record, and update the alarm 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 first upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, the reset time and the alarm time of the query record being empty, determine that the alarm type is that the acquisition value of the target monitoring record exceeds the first upper limit value of the telemetry point coding data record, and no alarm has been sent temporarily.

[0140] Optionally, the analysis module 402 is further configured to, in response to the collection value of the target monitoring record being less than the first upper limit value of the telemetry point coding data record, the reset time of the query record being empty, the alarm time of the query record being not empty, determining that the alarm type is that the collection value of the target monitoring record is reset in this collection after the alarm is sent, updating the first alarm value of the query record to the collection value of the target monitoring record, and updating the collection time and the reset time of the query record to the collection time of the target monitoring record; in response to the collection value of the target monitoring record being less than the first 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, determining that the alarm type is that the collection value of the target monitoring record has been reset, but the time for sending the reset alarm has not been reached; in response to the collection value of the target monitoring record being less than the first 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, determining that the alarm type is that the collection value of the target monitoring record has been reset before the reset delay of the telemetry point coding data record, and updating the archiving flag of the query record.

[0141] Optionally, the analysis module 402 is further configured to obtain the telemetry point coding 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 second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is associated with the alarm rule identifier of the telemetry point coding data record and has not been archived, recording the collection value of the target monitoring record as exceeding the second upper limit value of the telemetry point coding data record, and generating first alarm content based on the target monitoring record to obtain an analysis result; in response to the collection value of the target monitoring record being greater than the first upper limit value of the telemetry point coding data record, the collection value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is associated with the alarm rule identifier of the telemetry point coding data record and has not been archived, recording the collection value of the target monitoring record as exceeding the first upper limit value of the telemetry point coding data record, and generating second alarm content based on the target monitoring record to obtain an analysis result.

[0142] Optionally, the analysis module 402 is further configured to: in response to the alarm type being a second upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval duration of the telemetry point coded data record, the number of times of sending the second alarm of the query record being less than the number of times of sending the second alarm of the telemetry point coded data record, generating third alarm content based on the target monitoring record to obtain an analysis result; in response to the alarm type being a first upper limit value of the telemetry point coded data record of the collection value of the target monitoring record, the difference between the collection time of the target monitoring record and the last alarm time of the query record being greater than or equal to the alarm interval duration of the telemetry point coded data record, the number of times of sending the first alarm of the query record being less than the number of times of sending the first alarm of the telemetry point coded data record, generating fourth alarm content based on the target monitoring record to obtain an analysis result; and in response to the alarm type being alarm reset of the target monitoring record, the difference between the collection time of the target monitoring record and the reset time of the query record being greater than or equal to the reset delay of the telemetry point coded data record, generating fifth alarm content based on the target monitoring record to obtain an analysis result.

[0143] It should be noted that the above various modules can be implemented by software or hardware, and for the latter, the following implementation manners can be used, but are not limited thereto: the above modules are located in the same processor; or the above various modules are located in different processors in any combination.

[0144] Embodiments of the present application also provide a computer readable storage medium, which stores a computer program, wherein the computer program is configured to execute the steps in any of the above method embodiments when running on a computer or a processor.

[0145] Optionally, in the present embodiment, the above computer readable storage medium can be configured to store a computer program for executing 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 an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level of a fire pool in a transformer substation by using an ultrasonic sensor;

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

[0148] Step S12, controlling the target office equipment to send an Ethernet connection alarm message to the target object based on the analysis result.

[0149] Optionally, in the embodiment, the computer readable storage medium can include, but is not limited to, a U disk, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk, and various media that can store computer programs.

[0150] Embodiments of the present application also provide an electronic device including a memory and a processor, the memory storing a computer program, and the processor being configured to execute the computer program to perform the steps in any of the above method embodiments.

[0151] Optionally, in the embodiment, the processor in the electronic device can be configured to execute the computer program to perform the following steps:

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

[0153] Step S11, performing alarm analysis on the target monitoring records to obtain an analysis result;

[0154] Step S12, controlling a target office equipment to send an Ethernet connection alarm message to a target object based on the analysis result.

[0155] Embodiments of the present application also provide a computer program product including a computer program, the computer program being configured to perform the steps in any of the above method embodiments when executed by a processor.

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

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

[0158] Step S11, performing alarm analysis on the target monitoring records to obtain an analysis result;

[0159] Step S12, controlling a target office equipment to send an Ethernet connection alarm message to a target object based on the analysis result.

[0160] Optionally, the specific examples in the embodiments can refer to the examples described in the above embodiments and optional implementation manners, and the embodiments will not be described here again.

[0161] The sequence numbers of the above embodiments of the present application are only for description, and do not represent the advantages and disadvantages of the embodiments.

[0162] In the above embodiments of the present application, the description of each embodiment has its own focus, and the parts not described in detail in a certain embodiment can be referred to the relevant description of other embodiments.

[0163] In several embodiments provided in the present application, it should be understood that the disclosed technical contents can be implemented by other manners. Among them, the above-described device embodiments are only schematic, for example, the division of the units can be a logical function division, and actual implementation can have another division manner, for example, a plurality of units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the coupling or direct coupling or communication connection between the units or modules shown or discussed can be indirect coupling or communication connection through some interfaces, units or modules, which can be electrical or other forms.

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

[0165] In addition, each functional unit in each embodiment of the present application can be integrated in one processing unit, or each unit can exist physically, or two or more units can be integrated in one unit. The above integrated unit can be realized in the form of hardware or in the form of software functional unit.

[0166] The integrated unit, if implemented in the form of a software function unit and sold or used as an independent product, can be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application, essentially or in other words, the part that contributes to the prior art or the whole or part of the technical solutions can be embodied in the form of a software product. The computer software product is stored in a storage medium, including a number of instructions to make a computer device (which can be a personal computer, a server or a network device, etc.) execute all or part of the steps of the methods described in various embodiments of the present application. The aforementioned storage medium includes: a U disk, a read-only memory (Read-Only Memory, ROM), a random access memory (Random Access Memory, RAM), a mobile hard disk, a magnetic disk or an optical disk, and various media that can store program codes.

[0167] The above is only the preferred embodiment of the present application, it should be pointed out that, for those skilled in the art, without departing from the principles of the present application, can make a number of improvements and refinements, these improvements and refinements should also be considered as the protection scope of the present application.

Claims

1. A method for monitoring and alarming of fire water reservoirs in a substation, characterized by, The method comprises the following steps: obtaining a target monitoring record from a monitoring auxiliary database, wherein the monitoring auxiliary database is used for at least storing ultrasonic sensor monitoring data reported by an edge gateway, and the ultrasonic sensor monitoring data is obtained by measuring the water level of a fire pool in a transformer substation by using an ultrasonic sensor; performing alarm analysis on the target monitoring record to obtain an analysis result; controlling a target office equipment to send an Ethernet connection alarm message to a target object based on the analysis result; The monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table, and the alarm analysis on the target monitoring record to obtain the analysis result comprises the following steps: obtaining a telemetry point code 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 a first upper limit value of the telemetry point code data record, obtaining a query record associated with an alarm rule identification of the telemetry point code data record and not archived from the alarm record table; and performing alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point code data record, and the query record to obtain the analysis result. The monitoring auxiliary database at least stores a telemetry data table, and the obtaining of the target monitoring record from the monitoring auxiliary database comprises the following steps:

2. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, obtaining the target monitoring record from the telemetry data table of the monitoring auxiliary database that meets a preset collection condition according to a preset period, wherein the preset collection condition is determined according to a data type and a collection time. The alarm analysis on the target monitoring record based on the target monitoring record, the telemetry point code data record, and the query record to obtain the alarm type of the target monitoring record comprises the following steps:

3. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, in response to the collection value of the target monitoring record being greater than a second upper limit value of the telemetry point code 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 upper limit value of the telemetry point code data record, the last alarm value of the query record being less than the second upper limit value of the telemetry point code data record, determining that the alarm type is that the collection value of the target monitoring record is upgraded to a second upper limit alarm after the first upper limit reset, updating the second upper limit alarm value of the query record to the collection value of the target monitoring record, updating the second upper limit time of the query record to the collection 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 upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is a second upper limit alarm that is continuously triggered after the last alarm reset, and marking the record type of the query record as a second frequent alarm signal; in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, and the last alarm value of the query record being less than the second upper limit value of the telemetric point coding data record, determining that the alarm type is a second upper limit alarm that is triggered during a non-reset period after a first upper limit alarm, updating the second upper limit alarm value of the query record to the acquisition value of the target monitoring record, and updating the second upper limit alarm 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 upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is a second upper limit alarm that is continuously triggered; in response to the acquisition value of the target monitoring record being greater than the second upper limit value of the telemetric point coding data record, and the last alarm and the second upper limit alarm value of the query record being empty, determining that the alarm type is a first second upper limit alarm, updating the second upper limit alarm value of the query record to the acquisition value of the target monitoring record, and updating the second upper limit alarm time of the query record to the acquisition time of the query record.

4. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, based on the target monitoring record, the telemetric point coding data record, and the query record, performing alarm analysis on the target monitoring record to obtain the alarm type of the target monitoring record, including: in response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetric point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is a second upper limit alarm that is triggered after a short reset after a first alarm and is triggered again after a first upper limit alarm, updating the first alarm time of the query record to the acquisition time of the query record, recording the first alarm frequency of the query record as 0, and marking the record type of the query record as a frequent alarm signal; in response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetric point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record exceeds the first upper limit value of the telemetric point coding data record after sending a first alarm and exceeds the first upper limit value again, updating the reset time of the query record to be empty, recording the first alarm value of the query record as the acquisition value of the target monitoring record, updating the alarm time of the query record as 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 upper limit value of the telemetric point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record exceeds the second upper limit value of the telemetric point coding data record and then falls below the first upper limit value of the telemetric point coding data record, and in response to the second alarm value of the query record being not empty, recording the first alarm value of the query record as the acquisition value of the target monitoring record, and updating the alarm time of the query record as the acquisition time of the query record; in response to the acquisition value of the target monitoring record being greater than the first upper limit value of the telemetric point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetric 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 upper limit value of the telemetric point coding data record, determining that the alarm type is that the acquisition value of the target monitoring record exceeds the second upper limit value of the telemetric point coding data record and then falls below the first upper limit value of the telemetric point coding data record, and in response to the second alarm value of the query record being not empty, recording the first alarm value of the query record as the acquisition value of the target monitoring record, and updating the alarm time of the query record as the acquisition time of the query record; 5. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, based on the target monitoring record, the telemetric point coding data record, and the query record, performing alarm analysis on the target monitoring record to obtain the alarm type of the target monitoring record, including: in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetric 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 resets in the current acquisition after sending an alarm, updating the first alarm value of the query record as the acquisition value of the target monitoring record, and updating the acquisition time and the reset time of the query record as the acquisition time of the target monitoring record; in response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetric point coding data record, the reset time of the query record being not 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 has reset, but has not reached the time for sending a reset alarm; In response to the acquisition value of the target monitoring record being less than the first upper limit value of the telemetry point coding data record, the reset time of the query record being null, and the alarm time of the query record being null, it is determined that the alarm type is that the target monitoring record has been reset before the reset time delay of the telemetry point coding data record, and the archiving flag of the query record is updated.

6. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, The monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table, and the alarm analysis of the target monitoring record includes: acquiring 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 second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is not archived and has an alarm rule identification that is the identification of the telemetry point coding data record, the acquisition value of the target monitoring record is recorded as exceeding the second upper limit value of the telemetry point coding data record, and first alarm content is generated 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 upper limit value of the telemetry point coding data record, the acquisition value of the target monitoring record being less than the second upper limit value of the telemetry point coding data record, and there being no query record in the alarm record table that is not archived and has an alarm rule identification that is the identification of the telemetry point coding data record, the acquisition value of the target monitoring record is recorded as exceeding the first upper limit value of the telemetry point coding data record, and second alarm content is generated based on the target monitoring record to obtain the analysis result.

7. The substation fire water reservoir monitoring and alerting method of claim 1, wherein, In response to the alarm type being that the acquisition value of the target monitoring record exceeds the second 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 being greater than or equal to the alarm interval duration of the telemetry point coding data record, and the number of times of sending the second alarm of the query record being less than the number of times of the second alarm of the telemetry point coding data record, 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 acquisition value of the target monitoring record exceeds the first 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 being greater than or equal to the alarm interval duration of the telemetry point coding data record, and the number of times of sending the first alarm of the query record being less than the number of times of the first alarm of the telemetry point coding data record, fourth alarm content is generated based on the target monitoring record to obtain the analysis result; In response to the alarm type being that the target monitoring record is reset, the difference between the acquisition time of the target monitoring record and the reset time of the query record being greater than or equal to the reset time delay of the telemetry point coding data record, fifth alarm content is generated based on the target monitoring record to obtain the analysis result. ​ 8. A substation fire water reservoir monitoring and alerting system, characterized by, The application relates to a monitoring auxiliary analysis device, an Ethernet connection control device, an edge gateway and an ultrasonic sensor. The ultrasonic sensor is used for measuring the water level of a fire pool in a transformer substation to obtain ultrasonic sensor monitoring data. The edge gateway is used for reporting the ultrasonic sensor monitoring data to a monitoring auxiliary database to generate target monitoring records. The monitoring auxiliary analysis device is used for acquiring the target monitoring records from the monitoring auxiliary database and performing alarm analysis on the target monitoring records to obtain analysis results. The Ethernet connection control device is used for controlling a target office device to send an Ethernet connection alarm message to a target object based on the analysis results. The monitoring auxiliary database further stores an alarm rule configuration table and an alarm record table. The monitoring auxiliary analysis device is further used for acquiring telemetry point coding data records corresponding to the target monitoring records from the alarm rule configuration table, acquiring query records with alarm rule identifiers being the identifiers of the telemetry point coding data records and not being archived from the alarm record table in response to the acquisition values of the target monitoring records being greater than first upper limit values of the telemetry point coding data records, and performing alarm analysis on the target monitoring records based on the target monitoring records, the telemetry point coding data records and the query records to obtain the analysis results. The monitoring auxiliary analysis device is further used for performing alarm analysis on the target monitoring records based on the target monitoring records, the telemetry point coding data records and the query records to acquire alarm types of the target monitoring records. The alarm types are determined to meet alarm requirements to obtain the analysis results.

Images