CN113313915A - Method and system for processing graded alarm short message based on gas system - Google Patents
Method and system for processing graded alarm short message based on gas system Download PDFInfo
- Publication number
- CN113313915A CN113313915A CN202110591559.6A CN202110591559A CN113313915A CN 113313915 A CN113313915 A CN 113313915A CN 202110591559 A CN202110591559 A CN 202110591559A CN 113313915 A CN113313915 A CN 113313915A
- Authority
- CN
- China
- Prior art keywords
- alarm
- data
- processed
- time
- processing state
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G08—SIGNALLING
- G08B—SIGNALLING OR CALLING SYSTEMS; ORDER TELEGRAPHS; ALARM SYSTEMS
- G08B21/00—Alarms responsive to a single specified undesired or abnormal condition and not otherwise provided for
- G08B21/02—Alarms for ensuring the safety of persons
- G08B21/12—Alarms for ensuring the safety of persons responsive to undesired emission of substances, e.g. pollution alarms
- G08B21/16—Combustible gas alarms
-
- G—PHYSICS
- G08—SIGNALLING
- G08B—SIGNALLING OR CALLING SYSTEMS; ORDER TELEGRAPHS; ALARM SYSTEMS
- G08B21/00—Alarms responsive to a single specified undesired or abnormal condition and not otherwise provided for
- G08B21/18—Status alarms
- G08B21/182—Level alarms, e.g. alarms responsive to variables exceeding a threshold
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
- H04W4/12—Messaging; Mailboxes; Announcements
- H04W4/14—Short messaging services, e.g. short message services [SMS] or unstructured supplementary service data [USSD]
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks
Landscapes
- Engineering & Computer Science (AREA)
- Emergency Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Combustion & Propulsion (AREA)
- Chemical & Material Sciences (AREA)
- Health & Medical Sciences (AREA)
- Environmental & Geological Engineering (AREA)
- General Health & Medical Sciences (AREA)
- Toxicology (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Alarm Systems (AREA)
- Emergency Alarm Devices (AREA)
Abstract
The invention relates to a method and a system for processing a grading alarm short message based on a gas system. Therefore, even if the client is not beside the PC, the client can obtain the alarm information of the attention point, and can send the alarm information of different levels to the contact persons of different levels according to the configuration of the user, thereby realizing the graded alarm.
Description
Technical Field
The invention belongs to the field of coal mine gas monitoring, and particularly relates to a method and a system for processing a grading alarm short message based on a gas system.
Background
The gas seriously threatens the safe production of coal mines. In order to improve the safety production of coal mines, the informatization of the safety production of mines is promoted. At present, a safety monitoring system is generally applied to a coal mine, and personnel in a dispatching room of the coal mine can monitor real-time data, change trend and alarm data of gas guiding in real time. However, leaders and related personnel who are not in the dispatching room cannot find the alarm information in time and cannot respond in time.
Disclosure of Invention
Aiming at the technical problem, the invention provides a method and a system for processing a grading alarm short message based on a gas system, which can process important alarm information in a safety monitoring system according to a certain rule and then send the important alarm information to a corresponding contact person in time, so that a client can obtain the alarm information of a focus even if the client is not beside a PC (personal computer).
The technical scheme for solving the technical problems is as follows:
in a first aspect, the present invention provides a method for processing a hierarchical alarm short message based on a gas system, including:
step 1, storing alarm data to be processed in an alarm triggering table in a to-be-processed alarm table, and executing step 2;
step 2, judging whether alarm data with the same main key and non-ending processing state exist in the gas real-time alarm table and the alarm table to be processed, wherein the processing state comprises newly added, continuous and ending;
step 3, if the gas real-time alarm table does not have alarm data which is the same as the main key of the alarm data with the newly-added processing state in the alarm table to be processed and has a non-finished processing state, determining the alarm level of the alarm data with the newly-added processing state in the alarm table to be processed, adding the alarm data with the newly-added processing state in the alarm table to be processed into the gas real-time alarm table, and skipping to execute step 7;
if the gas real-time alarm table does not have alarm data which is the same as the main key of the alarm data with continuous processing state in the alarm table to be processed and has non-ending processing state, adding the alarm data with continuous processing state in the alarm table to be processed into the gas real-time alarm table, and skipping to execute the step 7;
step 4, if the gas real-time alarm table and the alarm table to be processed have alarm data which have the same main key and are not processed in the processing state, re-determining the alarm level of the alarm data which are not processed in the processing state in the alarm table to be processed, and executing step 5;
step 5, judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table, if so, executing step 6;
step 6, updating the alarm level of the alarm data with the non-ending processing state in the gas real-time alarm table, and executing step 7;
and 7, sending an alarm short message based on the alarm data in the gas real-time alarm meter.
In a second aspect, the present invention provides a system for processing a hierarchical alarm short message based on a gas system, including:
the data storage module is used for storing the alarm data to be processed in the alarm triggering table into the alarm table to be processed;
the data judgment module is used for judging whether alarm data which has the same main key and is in a non-ending processing state exists in the gas real-time alarm table and the alarm table to be processed, and the processing state comprises newly increased, continued and ended;
the first data adding module is used for determining the alarm level of the newly added alarm data in the alarm table to be processed if the alarm data which is the same as the main key of the alarm data in the alarm table to be processed and has a non-finished processing state does not exist in the gas real-time alarm table, adding the newly added alarm data in the alarm table to be processed in the processing state into the gas real-time alarm table, and calling the short message alarm module;
the short message alarm module is also used for adding the alarm data with the continuous processing state in the alarm table to be processed into the gas real-time alarm table and calling the short message alarm module if the alarm data with the same main key as the alarm data with the continuous processing state in the alarm table to be processed and the non-ending processing state does not exist in the gas real-time alarm table;
the level determining module is used for re-determining the alarm level of the alarm data of which the processing state is not finished in the alarm table to be processed if the alarm data of which the main key is the same and the processing state is not finished exists in the gas real-time alarm table and the alarm table to be processed;
the level comparison module is used for judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table;
the level updating module is used for updating the alarm level of the alarm data with the processing state of non-ending in the gas real-time alarm table and calling the short message alarm to the module;
and the short message alarm module is used for sending an alarm short message based on the alarm data in the gas real-time alarm meter.
In a third aspect, the present invention provides a computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform the above-described method.
In a fourth aspect, the present invention provides a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the method described above when executing the program.
The invention has the beneficial effects that:
1. even if the worker is not beside the PC, the worker can receive the gas alarm information in real time and dispose in time;
2. the hierarchical alarm is realized, the situation that workers are submerged by mass data is avoided, and alarm information of different levels is sent to different workers.
Drawings
Fig. 1 is a flowchart of a method for processing a gas system-based hierarchical alarm short message according to an embodiment of the present invention;
fig. 2 is a thread for saving an alarm of a security monitoring system to a short message system database according to an embodiment of the present invention;
FIG. 3 is a thread for processing real-time alarm data of a security monitoring system according to an embodiment of the present invention;
FIG. 4 is a thread for processing historical alarm data of a security monitoring system according to an embodiment of the present invention;
FIG. 5 is a thread for synchronizing underlying data according to an embodiment of the present invention;
fig. 6 is a flowchart of sending a short message according to an embodiment of the present invention;
fig. 7 is a flowchart of a failed retransmission of a short message according to an embodiment of the present invention.
Detailed Description
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
The method aims to classify the alarm information of the gas system according to the severity of the alarm, generate short messages and send the short messages to coal mine management personnel and supervision unit leaders.
The alarm information defines different alarm levels according to the alarm state, the alarm value range and the duration. The alarm levels are from level 1 to 10, with level 1 being the lowest and level 10 being the highest. When a low-level alarm occurs, only the personnel configuring the level receive the short message, and when a high-level alarm occurs, the contact persons configuring the level and being lower than the level receive the short message (for example, a 3-level alarm occurs, and the contact persons in levels 1, 2 and 3 can receive the short message). Therefore, the method avoids that the management personnel are submerged by massive alarm data, and can manage serious alarm effectively.
The alarm life cycle starts from the generation of the alarm, lasts for a period of time and finally ends. In consideration of the time difference between the servers, the alarms occurring within 1 hour (configurable) before and after the current time are all calculated within the effective time, and short messages can be sent. After the alarm lasts for a period of time, if the alarm level is increased, an upgrade alarm is sent; if the alarm level is unchanged or degraded, sending an alarm continuous short message after the single duration reaches 1 hour (configurable); and after the alarm is finished, a short message can be sent.
Before the program runs, a plurality of configurations are required:
(1) alarm type and short message template configuration: the template is used for configuring the alarm type needing to send the short message and newly adding, continuously ending the alarm short message; an alarm _ type table;
the alarm type alarm _ type table content includes:
| column name | Description of the invention |
| alarm_type_code | Alarm type coding |
| alarm_type_name | Alarm type name |
| sys_code | Alarm system coding |
| unit | Unit of |
| duration_time | Duration of alarm(s) |
| start_template | Template for starting alarm |
| ing_template | Continuous alarm template |
| end_template | Ending alarm template |
| upgrade_template | Upgrade alarm template |
The safety system alarms, and the short message template of the methane alarm type is as follows: a
Wherein before sending the short message [! The content of the format of- … … -is replaced by the content of the corresponding short message alarm. The specific correspondence is as follows:
| [！-alarm_type_name-] | alarm type name |
| [！-mine_shortname-] | Coal mine abbreviation |
| [！-transducer_point-] | Sensor site |
| [！-transducer_code-] | Sensor encoding |
| [！-occur_time-] | Time of occurrence |
| [！-ss_transducer_state-] | Alarm state |
| [！-currentvalue-] | Current alarm value |
| [！-ing_num-] | Retransmission times (Special for continuous alarm) |
| [！-alarm_level-] | Alarm level |
| \r\n | Line feed |
(2) Alarm level configuration: the alarm levels are from 1-10, the lowest level 1 and the highest level 10, the system can initialize the level 1-3 of the methane type, and the user can newly add or adjust the levels according to the alarm state, the numerical range, the alarm type and the duration;
for example: methane alarm 1-3 levels are as follows:
| alarm level | Alarm type name | Alarm state | Range of values | Duration of time |
| Level 1 alarm | Methane | Alarm device | 1 to 1.99 | 30 seconds |
| Level 2 alarm | Methane | Alarm and power off | 2 to 2.99 | 30 seconds |
| 3-level alarm | Methane | Alarm and power off | 3 or more | 30 seconds |
(3) And (3) sensor information configuration: the module is mainly used for shielding the sensor which does not need to send the short message;
the sensor information configuration table comprises the following contents:
| column name | Description of the invention |
| mine_code | Coal mine coding |
| station_code | Substation number |
| transducer_code | Sensor numbering |
| mine_short_name | Coal mine abbreviation |
| alarm_type_code | Alarm type coding |
| transducer_point | Monitoring location |
| unit | Unit of |
| data_time | Time of data generation |
| is_send_msg | Whether to send an alarm |
| transducer_sort | Sensor classification |
(4) And (3) contact person configuration: the method can be directly imported into the original user in the system, and can also be used for manually adding contacts;
(5) and (3) sending group configuration: and configuring a rule that a certain type of receivers take over to automatically send alarm short messages. The method comprises the following steps: the alarm type, the alarm level, the duration of the short message, whether to send the alarm short message or not, and whether to send the alarm release short message or not;
(6) time interval configuration: basic information synchronization time interval gas _ info _ interval, alarm information processing time interval gas _ alarm _ interval and short message processing sending time interval gas _ sms _ interval;
(7) the method comprises the following steps that (1) a basic information data table name and a field name of a safety monitoring system are obtained;
(8) the alarm effective time requirement is as follows:
earliest historical time (minute) (current time pushed ahead) effect _ time _ his
Latest historical time (minutes) (current time pushed backward) effect _ time _ future
(9) The time requirement of continuously alarming and resending the short message is as follows: ing _ duration _ limit
(10) And (3) transmission failure retransmission: retransmission time interval and number of times
(11) Maximum number of pieces sent in bulk
For convenience of reading, the correspondence between the alphabet table name and the chinese table name referred to in the following is described as follows:
| ss_t_alarm_trigger | alarm touch-release table |
| ss_t_alarm_mobile | Alarm meter to be processed |
| gas_alarm_real | Gas real-time alarm meter |
| transducer_define | Sensor meter |
| NewList/InsList | New alarm watch |
| UList | Continuous alarm watch |
| DList/DelList | Alarm watch for ending |
Fig. 1 is a flowchart of a method for processing a gas system-based hierarchical alarm short message according to an embodiment of the present invention, and as shown in fig. 1, the method includes:
s1, storing the alarm data to be processed in the alarm triggering table in the alarm table to be processed, and executing the step S2;
s2, judging whether alarm data which are the same as the main key of the alarm data in the alarm table to be processed and have a non-ending processing state exist in the gas real-time alarm table;
s3, if the gas real-time alarm table does not have alarm data which is the same as the main key of the newly added alarm data in the alarm table to be processed and has a non-finished processing state, determining the alarm level of the newly added alarm data in the alarm table to be processed in the processing state, adding the newly added alarm data in the alarm table to be processed into the gas real-time alarm table, and skipping to execute the step S8;
if the gas real-time alarm table does not have alarm data which is the same as the main key of the continuous alarm data in the alarm table to be processed and has a non-ending processing state, adding the continuous alarm data in the alarm table to be processed into the gas real-time alarm table, and skipping to execute the step S8;
s4, if the gas real-time alarm table has alarm data which are the same as the main keys of the newly added alarm data and the continuous alarm data in the alarm table to be processed and have non-finished processing state, re-determining the alarm levels of the newly added alarm data and the continuous alarm data in the alarm table to be processed, and executing the step S5;
s5, judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table, if yes, executing a step S6;
s6, updating the alarm level of the newly added alarm data and the continuous alarm data in the gas real-time alarm table, and executing the step S8;
s7, judging whether alarm data which are the same as the main key for ending the alarm data in the alarm table to be processed and have non-ending processing state exist in the gas real-time alarm table, if so, updating the processing state of the alarm data in the gas real-time alarm table to be ended, and executing a step S8;
and S8, sending an alarm short message based on the alarm data in the gas real-time alarm table.
Specifically, as shown in fig. 2, which is a flow chart of a short message sending program, the alarm in the ss _ t _ alarm _ mobile table is processed according to new alarm, continuous alarm and end alarm. And executing the short message processing and sending time interval gas _ sms _ interval once every gas _ sms _ interval according to the configured short message processing and sending time interval gas _ sms _ interval. The specific execution steps are as follows:
(1) and reading an ss _ t _ alarm _ mobile table of a security and security monitoring system database, and inquiring all data to be processed, namely operation _ flag, to be 0.
(2) Filtering types which do not exist in the short message system alarm type table alarm _ type; for example: only the methane type is configured in the alarm _ type, and the carbon monoxide type alarm exists in the ss _ t _ alarm _ mobile table, so that the carbon monoxide type alarm needs to be filtered.
(3) And filtering out the sensors which do not exist or are shielded in the sensor table transmitter _ define of the short message system database.
(4) And (3) decomposing the data into 3 lists, namely newly adding NewList, continuously keeping UList and ending DList.
(5) If the same sensor has an alarm with an alarm state of alarm and an alarm with an alarm state of power failure, and the alarm starting times are consistent, the alarm states are combined into power failure data. The reason is that the power failure inevitably alarms, so two data, one alarm and one power failure, are generated in the power failure, and in this case, only one short message needs to be sent, and the power failure state is a relatively serious alarm state, so that the two data are combined into the power failure alarm.
(6) Respectively filtering out alarms which do not meet the time requirement. The time requirement is that ss _ alarm _ still is the alarm starting time, now is the current time, and the following conditions are met: ss _ arm _ still > -not-effect _ time _ hisss _ arm _ still < -not + effect _ time _ future
(7) Circularly processing newly added alarm data of the NewList;
(8) judging whether the same alarm which is not finished (processing state: I-newly added, U: continuous and D: finished) exists in a gas _ alarm _ real table of the short message system, and judging the same standard: the method comprises the following steps of coal mine coding, alarm type, sensor number, substation number, alarm state and alarm starting time, wherein the fields are the same. If yes, executing (15), otherwise, executing (9);
(9) obtaining an alarm level (calculated according to the alarm state, the alarm value, the alarm type and the duration) according to the configuration information, wherein the alarm level is set as follows:
| alarm level | Alarm type name | Alarm state | Range of values | Duration of time |
| Level 1 alarm | Methane | Alarm device | 1 to 1.99 | 30 seconds |
| Level 2 alarm | Methane | Alarm and power off | 2 to 2.99 | 30 seconds |
| 3-level alarm | Methane | Alarm and power off | 3 or more | 30 seconds |
For example, if a methane type alarm, the alarm state is "alarm", the alarm value is 1.1, the alarm type is "methane", the duration is 30 seconds, and the alarm level is a level 1 alarm
(10) Storing the alarm data (with alarm level) to a gas _ alarm _ real in an alarm information table of the short message system;
(11) sending a newly added gas alarm short message (attached to the detailed process);
(12) starting to circularly process continuous alarm in the UList;
(13) judging that the same alarm which is not finished exists in the gas _ alarm _ real table; if yes, executing (14), otherwise executing (15);
(14) newly adding the record into a gas _ alarm _ real table to add 1 newly-added alarm; preparing to send short messages and executing (23);
(15) calculating the alarm level of the record (according to alarm state, alarm value, alarm type, duration)
(16) Comparing with the previous record, judging whether the alarm level is increased, if so, upgrading the alarm, and executing (17); otherwise, executing (18);
(17) updating the gas _ alarm _ real table: alarm grade, update time, alarm value, alarm grade and alarm state, setting the number of times of continuous alarm retransmission, i.e. setting the number of times of continuous alarm retransmission to 0, preparing to send an alarm upgrade short message, and executing (23)
(18) Judging whether the alarm level is reduced, if so, executing (19); otherwise, the alarm level is unchanged, and the step (21) is executed;
(19) updating the gas _ alarm _ real table: updating time, alarm value, duration times and alarm state, and recording the information;
(20) judging whether the duration time exceeds the configured continuous alarm resending short message time ing _ duration _ limit, if so, preparing to send a short message, and executing (23); otherwise, not sending the short message, and executing (22);
(21) judging whether the duration time exceeds the configured continuous alarm resending short message time ing _ duration _ limit, if so, executing (22); otherwise, not sending the short message, and executing (24);
(22) updating the gas _ alarm _ real table: update time, alarm value, duration, alarm state, change time (change _ time);
(23) sending a safe continuous alarm short message;
(24) starting the circulation processing and ending the alarm Dlist;
(25) judging that the alarm exists in a gas _ alarm _ real alarm real-time table and is not ended; if yes, executing (26); otherwise, executing (27);
(26) updating the alarm value in the gas _ alarm _ real table, and ending the alarm state;
(27) sending a safety alarm ending short message;
(28) splicing IDs of all data to be processed
(29) According to the ID, modifying the data processing state operation _ flag in the ss _ t _ alarm _ mobile table to 1;
(30) finishing;
optionally, after step S1, before step S2, the method further comprises:
step a, inquiring alarm data with the processing states of ending and newly added in the alarm triggering table, respectively generating an ending alarm list and a newly added alarm list, and executing step b;
step b, judging whether the alarm ending list and the newly added alarm list have alarm data with the same main key, if so, executing step c, otherwise, executing step d;
step c, adding the alarm data identical to the main key into a continuous alarm list, and deleting the alarm data identical to the main key from the alarm ending list and the newly added alarm list;
and d, inserting the alarm data in the ending alarm list, the newly added alarm list and the continuous alarm list into the alarm list to be processed.
Specifically, the data processing program processes real-time alarm data, and processes data in the ss _ t _ alarm _ trigger table into the ss _ t _ alarm _ mobile table. Merging two data with the same main key (coal mine coding, substation coding, sensor coding, alarm starting time and alarm states (1 alarm and 2 power off)), wherein the flag bits data _ flag of the processing states are I (newly increased alarm) and D (ended alarm), and one flag bit is U (continuous alarm) 1 data. And executing the operation once every gas _ alarm _ interval time according to the configured alarm information processing time interval gas _ alarm _ interval. As shown in fig. 3, the specific steps are as follows:
(1) according to the coal mine coding, circularly inquiring data with an operation flag of 0 and the alarm starting time within the effective time in an alarm triggering table ss _ t _ alarm _ trigger. That is, ss _ alarm _ still is the alarm start time, now is the current time, and the following condition ss _ alarm _ still is satisfied, that is, non-effect _ time _ events _ alarms _ alarm _ still ═ non + effect _ time _ future
(2) Querying an alarm (data _ flag ═ D) triggering deletion in the table into DelList; querying a newly added alarm (data _ flag ═ I) lnist triggered in the table;
(3) circulating the DelList table;
(4) judging the records in the DelList, and if the same records exist in the InsList (judging the same standard: coal mine code, substation number, sensor number, alarm state and alarm starting time), executing (5); otherwise, executing (8);
(5) adding the record to the UList in the continuous alarm list;
(6) delete this record from DelList;
(7) delete this record from InsList;
(8) and (3) splicing SQL: inserting a newly increased alarm in the InsList into an alarm table ss _ t _ alarm _ mobile of a system to be subjected to short message processing, wherein a flag bit data _ flag is I; inserting a UList continuous alarm flag bit data _ flag which is U; a DelList is inserted, and the flag bit data _ flag is D; the operation flag for modifying the part of data in the ss _ t _ alarm _ trigger table is operated to be completed, namely operation _ flag is 1
(9) Executing SQL;
(10) displaying the number of processing records on a window
(11) Finishing;
sometimes, a new alarm received from a coal mine is quickly ended, so that the collected alarm is an ended alarm, and the data can be directly entered into a historical alarm list. In order to avoid missing this part of the alarm data, the data processing program also processes the historical alarm. And processing the data in the history alarm table into the ss _ t _ alarm _ mobile table, wherein the flag bit is D because the alarm is ended. And executing the operation once every gas _ alarm _ interval time according to the configured alarm information processing time interval gas _ alarm _ interval. As shown in fig. 4, the specific steps are as follows:
(1) and circularly inquiring data with an operation flag operation _ flag being 0 and the alarm starting time being within the effective time in the historical alarm data table ss _ t _ history _ alarm according to the mine codes. That is, ss _ alarm _ still is the alarm start time, now is the current time, and the following condition ss _ alarm _ still is satisfied, that is, non-effect _ time _ events _ alarms _ alarm _ still ═ non + effect _ time _ future
(2) And (3) splicing SQL: inserting a DelList ending alarm into a ss _ t _ alarm _ mobile of a system to be subjected to short message processing alarm table, wherein the flag bit data _ flag is D; in the modified ss _ t _ alarm _ mobile table, the operation flag is that the operation is finished, and the operation _ flag is 1
(3) Executing SQL;
(4) displaying the number of processing records on a window
(5) Finishing;
optionally, before performing step S2, the method further comprises:
and e, filtering the alarm data in the alarm triggering table according to a preset alarm type and a sensor table.
Specifically, the sensor basic information data of the synchronous safety monitoring system is divided into two parts, namely analog quantity (basic information comprises coal mines, substations, sensor codes, sensor names, sensor types, units, alarm upper and lower limits, measuring range upper and lower limits and the like) and switching quantity (basic information comprises coal mines, substations, sensor codes, sensor names, sensor types and the like), and is synchronized into a database of a short message system from a database of the safety monitoring system. The synchronization interval gas _ info _ interval is executed once every gas _ info _ interval time according to the configured basic information. As shown in fig. 5, the specific steps are as follows:
(1) reading configured basic information data table names TableList (generally configuring two tables, analog quantity basic information table ss _ t _ analog _ info and switching quantity basic information table ss _ t _ switching _ info), and field names of time to be compared
(2) Filtering out tables from the tableList that are not contained in the security monitoring system database;
(3) judging whether the tableList is not empty, if so, executing (4); otherwise, ending, and executing (16);
(4) circulating according to the table name TableList from a database gas library of the safety monitoring system to obtain data (coal mine codes, table names of the basic information tables and updating time) in each basic information table, and assigning to newRow;
(5) acquiring updating data of a basic information table from a basic information updating table ss _ t _ info _ update table (the content comprises coal mine codes, table names of the basic information table and updating time) in a database gas library of the safety monitoring system, and assigning the updating data to oldRow;
(6) the records in the newRow are circulated, and it is determined whether or not the table in TableList is updated for a certain mine, but the updated table does not exist. If yes, executing (7) in the safety monitoring system; otherwise, judging whether the last updating time is the same or not, and executing (8);
(7) splicing SQL, inserting the record into an ss _ t _ info _ update table in a security monitoring system; splicing the coal mine codes into a variable syncmlecodestr (the coal mine codes recorded in the syncmlecodestr are the coal mine codes with updated basic information, and are used for judging whether the content of a basic information table transmitter _ definition table in a short message system database needs to be updated or not in the subsequent steps); performing (10);
(8) judging whether the last updating time of the record is the same as that of the record in the oldRow, if so, executing (9); otherwise, executing (10);
(9) splicing SQL, namely changing the updating time in a basic information updating table ss _ t _ info _ update of the security monitoring system into the time in newRow, and splicing the coal mine codes into a variable syncMineCodtstr;
(10) judging whether syncMineConstr is empty, and executing (12) if the syncMineConstr is empty; otherwise, executing (11);
(11) processing a short message system database, and deleting all records of coal mine codes in a syncmcinecodestr variable in a basic information table transmitter _ define table; reading a table in a tableList from a safety monitoring system database, and inserting all data corresponding to the coal mine into a transducer _ definition table of a short message system;
(12) looping oldRow, judging whether the record does not exist in newRow (namely judging whether the table in TableList exists, and whether the old update record (oldRow) of a certain mine exists in the update table, but the basic information of the mine is not updated at this time), if so, executing (13); otherwise, executing (14);
(13) and (3) splicing SQL, wherein the time for modifying the basic information update table ss _ t _ info _ update in the database of the security monitoring system is 1900-01-0100: 00: 00 ″ (indicating that the basic information update data of the mine is not found this time), and execution (14);
(14) judging whether the spliced SQL is empty, if so, ending, and executing (16); otherwise, executing (15);
(15) in the safety monitoring system, SQL is executed;
(16) end up
Optionally, step S8 specifically includes:
s81, determining an alarm template according to the processing state of alarm data in the gas real-time alarm table;
s82, writing the information of the alarm data into the alarm template to generate an alarm short message;
s83, determining a corresponding sending group according to the alarm level of the alarm data;
and S84, sending the alarm short message to the contact configured in the sending group.
Specifically, as shown in fig. 6, the specific operation steps of sending the short message are as follows:
(1) judging the type and state of the alarm, finding an alarm template, judging whether the alarm template is empty, if so, ending, and executing (15); otherwise, executing (2); the alarm template is referred to above.
(2) Generating short message content according to the template;
(3) searching a sending group L1 which configures the alarm type and is 'yes' for sending short messages or not;
(4) judging whether the short message is 'alarm release' or not, and if so, executing (5); otherwise, executing (6);
(5) filter out from L1 the send groups that do not send "alarm dismiss";
(6) filtering from L1 to obtain a sending group with a sending group level of null or higher than or equal to the alarm level;
(7) filtering from L1 to obtain sending group with configured contact person or other mobile phone number;
(8) judging whether the L1 sending group list is empty, if so, ending, and executing (15); otherwise, executing (9);
(9) searching the contact information configured by the sending group and other mobile phone numbers;
(10) pushing the maximum number of the pieces to an operator interface in batches according to the batch sending;
(11) judging whether the short message pushing is successful or not, if so, executing (12); otherwise, executing (13);
(12) storing the contact persons into a short message history table one by one, wherein the pushing state is successful; ending, executing (15);
(13) storing the data in batches into a table to be retransmitted;
(14) storing the contact persons into a short message history table one by one, wherein the pushing state is 3 (pushing fails and is to be pushed again);
(15) and (6) ending.
Optionally, step S8 further includes:
and S85, if the sending of the alarm short message fails, retransmitting the alarm short message until the retransmission times exceed the configured retransmission times.
Specifically, the following operations are performed cyclically at set time intervals of failed retransmissions.
As shown in fig. 7, the specific operation steps are as follows:
(1) inquiring the record to be pushed from the table to be retransmitted in failure
(2) Judging whether the time of the data meets the requirement, if so, executing (3); otherwise, ending and executing (9). The time requirement is that ss _ alarm _ time is the alarm start time, now is the current time, and the following condition data _ time > -now-effect _ time _ hisdata _ time < -now + effect _ time _ future is satisfied
(3) Pushing to operator interface in batches according to maximum number of batches sent
(4) Judging whether the short message is pushed successfully or not, if so, executing (5); otherwise, executing (6);
(5) modifying the pushing state in the short message history table to be 1 (pushing is successful), and deleting the record in the table to be replayed; ending, and executing (9);
(6) judging whether the retransmission times is larger than the configured retransmission times or not, if so, executing (7); otherwise, executing (8);
(7) inserting sending failure data in the short message history table according to the batch of the receivers, wherein the pushing state is 2 (pushing failure), and deleting records in the retransmission table; end, execute (9)
(8) Modifying the list to be retransmitted in failure, retransmitting by +1 times, and continuously and circularly trying to retransmit;
(9) finishing;
the embodiment of the invention provides a system for processing graded alarm short messages based on a gas system, which comprises:
the data storage module is used for storing the alarm data to be processed in the alarm triggering table into the alarm table to be processed;
the data judgment module is used for judging whether alarm data which has the same main key and is in a non-ending processing state exists in the gas real-time alarm table and the alarm table to be processed, and the processing state comprises newly increased, continued and ended;
the first data adding module is used for determining the alarm level of the newly added alarm data in the alarm table to be processed if the alarm data which is the same as the main key of the alarm data in the alarm table to be processed and has a non-finished processing state does not exist in the gas real-time alarm table, adding the newly added alarm data in the alarm table to be processed in the processing state into the gas real-time alarm table, and calling the short message alarm module;
the short message alarm module is also used for adding the alarm data with the continuous processing state in the alarm table to be processed into the gas real-time alarm table and calling the short message alarm module if the alarm data with the same main key as the alarm data with the continuous processing state in the alarm table to be processed and the non-ending processing state does not exist in the gas real-time alarm table;
the level determining module is used for re-determining the alarm level of the alarm data of which the processing state is not finished in the alarm table to be processed if the alarm data of which the main key is the same and the processing state is not finished exists in the gas real-time alarm table and the alarm table to be processed;
the level comparison module is used for judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table;
the level updating module is used for updating the alarm level of the alarm data with the processing state of non-ending in the gas real-time alarm table and calling the short message alarm to the module;
and the short message alarm module is used for sending an alarm short message based on the alarm data in the gas real-time alarm meter.
Embodiments of the present invention provide a computer-readable storage medium, comprising instructions, which, when executed on a computer, cause the computer to perform the above-mentioned method.
An embodiment of the present invention provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the method described above.
The reader should understand that in the description of this specification, reference to the description of the terms "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the modules and units in the above described system embodiment may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
While the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. A method for processing a graded alarm short message based on a gas system is characterized by comprising the following steps:
step 1, storing alarm data to be processed in an alarm triggering table in a to-be-processed alarm table, and executing step 2;
step 2, judging whether alarm data with the same main key and non-ending processing state exist in the gas real-time alarm table and the alarm table to be processed, wherein the processing state comprises newly added, continuous and ending;
step 3, if the gas real-time alarm table does not have alarm data which is the same as the main key of the alarm data with the newly-added processing state in the alarm table to be processed and has a non-finished processing state, determining the alarm level of the alarm data with the newly-added processing state in the alarm table to be processed, adding the alarm data with the newly-added processing state in the alarm table to be processed into the gas real-time alarm table, and skipping to execute step 7;
if the gas real-time alarm table does not have alarm data which is the same as the main key of the alarm data with continuous processing state in the alarm table to be processed and has non-ending processing state, adding the alarm data with continuous processing state in the alarm table to be processed into the gas real-time alarm table, and skipping to execute the step 7;
step 4, if the gas real-time alarm table and the alarm table to be processed have alarm data which have the same main key and are not processed in the processing state, re-determining the alarm level of the alarm data which are not processed in the processing state in the alarm table to be processed, and executing step 5;
step 5, judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table, if so, executing step 6;
step 6, updating the alarm level of the alarm data with the non-ending processing state in the gas real-time alarm table, and executing step 7;
and 7, sending an alarm short message based on the alarm data in the gas real-time alarm meter.
2. The method of claim 1, further comprising:
and 8, judging whether alarm data which is the same as the main key of the alarm data with the end processing state in the alarm table to be processed and has a non-end processing state exists in the gas real-time alarm table, if so, updating the alarm data with the end processing state in the gas real-time alarm table, and executing the step 7.
3. The method of claim 1, further comprising, after step 1 and before step 2:
step a, inquiring alarm data with the processing states of ending and newly added in the alarm triggering table, respectively generating an ending alarm list and a newly added alarm list, and executing step b;
step b, judging whether the alarm ending list and the newly added alarm list have alarm data with the same main key, if so, executing step c, otherwise, executing step d;
step c, adding the alarm data identical to the main key into a continuous alarm list, and deleting the alarm data identical to the main key from the alarm ending list and the newly added alarm list;
and d, inserting the alarm data in the ending alarm list, the newly added alarm list and the continuous alarm list into the alarm list to be processed.
4. The method of claim 1, wherein prior to performing step 2, further comprising:
and e, filtering the alarm data in the alarm triggering table according to a preset alarm type and a sensor table.
5. The method according to any one of claims 1 to 4, wherein the step 7 specifically comprises:
7.1, determining an alarm template according to the processing state of alarm data in the gas real-time alarm meter;
step 7.2, writing the information of the alarm data into the alarm template to generate an alarm short message;
7.3, determining a corresponding sending group according to the alarm level of the alarm data;
and 7.4, sending the alarm short message to the contact configured in the sending group.
6. The method according to claim 5, wherein the step 7 specifically comprises:
and 7.5, if the sending of the alarm short message fails, retransmitting the alarm short message until the retransmission times exceed the configured retransmission times.
7. A processing system based on gas system classification alarm short message is characterized by comprising:
the data storage module is used for storing the alarm data to be processed in the alarm triggering table into the alarm table to be processed;
the data judgment module is used for judging whether alarm data which has the same main key and is in a non-ending processing state exists in the gas real-time alarm table and the alarm table to be processed, and the processing state comprises newly increased, continued and ended;
the first data adding module is used for determining the alarm level of the newly added alarm data in the alarm table to be processed if the alarm data which is the same as the main key of the alarm data in the alarm table to be processed and has a non-finished processing state does not exist in the gas real-time alarm table, adding the newly added alarm data in the alarm table to be processed in the processing state into the gas real-time alarm table, and calling the short message alarm module;
the short message alarm module is also used for adding the alarm data with the continuous processing state in the alarm table to be processed into the gas real-time alarm table and calling the short message alarm module if the alarm data with the same main key as the alarm data with the continuous processing state in the alarm table to be processed and the non-ending processing state does not exist in the gas real-time alarm table;
the level determining module is used for re-determining the alarm level of the alarm data of which the processing state is not finished in the alarm table to be processed if the alarm data of which the main key is the same and the processing state is not finished exists in the gas real-time alarm table and the alarm table to be processed;
the level comparison module is used for judging whether the alarm level is upgraded compared with the alarm level recorded in the gas real-time alarm table;
the level updating module is used for updating the alarm level of the alarm data with the processing state of non-ending in the gas real-time alarm table and calling the short message alarm to the module;
and the short message alarm module is used for sending an alarm short message based on the alarm data in the gas real-time alarm meter.
8. The system of claim 7, further comprising:
and the state updating module is used for judging whether alarm data which has the same main key as the alarm data with the end processing state in the alarm table to be processed and has the non-end processing state exists in the gas real-time alarm table, if so, updating the processing state of the alarm data in the gas real-time alarm table to be the end, and calling the short message alarm module.
9. A computer-readable storage medium comprising instructions that, when executed on a computer, cause the computer to perform the method of any of claims 1 to 6.
10. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method according to any of claims 1 to 6 when executing the program.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110190607 | 2021-02-19 | ||
| CN2021101906070 | 2021-02-19 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113313915A true CN113313915A (en) | 2021-08-27 |
| CN113313915B CN113313915B (en) | 2023-05-12 |
Family
ID=77376114
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110591559.6A Active CN113313915B (en) | 2021-02-19 | 2021-05-28 | Method and system for processing classified alarm short messages based on gas system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113313915B (en) |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE3467267D1 (en) * | 1983-10-17 | 1987-12-10 | Cerberus Ag | Alarm signalling method and application device therefor |
| CN104454009A (en) * | 2014-12-03 | 2015-03-25 | 中国中煤能源集团有限公司 | Gas forecasting and early-warning system and method based on sensing network |
| CN105929761A (en) * | 2016-06-28 | 2016-09-07 | 上海衡亮电子科技有限公司 | GPRS network-based LED big screen remote integrated control system |
| CN106292496A (en) * | 2016-08-31 | 2017-01-04 | 浙江浙大中控信息技术有限公司 | A kind of subway monitoring system alarming management method |
| CN107038847A (en) * | 2017-05-15 | 2017-08-11 | 天地（常州）自动化股份有限公司 | A kind of Underwell stepped alarm method, equipment and system |
| CN107829780A (en) * | 2017-10-27 | 2018-03-23 | 山西精英科技股份有限公司 | A kind of gas false alarm recognition methods based on coal mine safety monitoring networked system |
| CN107888414A (en) * | 2017-11-03 | 2018-04-06 | 杭州钛比科技有限公司 | A kind of biogas leakage monitoring system based on NB IoT |
| CN108223011A (en) * | 2018-01-11 | 2018-06-29 | 山东科技大学 | A kind of coal mine typical power disaster alarm method of servicing based on SaaS patterns |
| CN109147283A (en) * | 2018-09-06 | 2019-01-04 | 浙江航天长峰科技发展有限公司 | A kind of short message alarm system and method for safety supervision information |
| CN109377183A (en) * | 2018-11-08 | 2019-02-22 | 合肥帧讯软件有限公司 | Coalmine Safety Supervision intelligence enforcement system |
| CN109854304A (en) * | 2019-03-11 | 2019-06-07 | 天地（常州）自动化股份有限公司 | Coal mine safety monitoring system Grading And Zoning alarm method and safety monitoring system |
| CN209028778U (en) * | 2018-09-10 | 2019-06-25 | 中国石油化工股份有限公司 | A kind of intelligence oil/gas well theft-proof box gas concentration detection warning device |
| CN110118103A (en) * | 2019-05-29 | 2019-08-13 | 精英数智科技股份有限公司 | A kind of coal mine gas prewarning method |
| CN110533887A (en) * | 2019-08-07 | 2019-12-03 | 山东蓝光软件有限公司 | A kind of discrete mode method for early warning of coal and gas prominent disaster based on Real-time Monitoring Data, device and storage medium |
| CN110751815A (en) * | 2019-11-01 | 2020-02-04 | 天地（常州）自动化股份有限公司 | Intelligent control system and method for mine audible and visual alarm |
| CN111835760A (en) * | 2020-07-10 | 2020-10-27 | 广州博冠信息科技有限公司 | Alarm information processing method and device, computer storage medium and electronic equipment |
| CN111899486A (en) * | 2020-08-17 | 2020-11-06 | 航天新长征大道科技有限公司 | Logistics center safety monitoring method, device, equipment and storage medium |
-
2021
- 2021-05-28 CN CN202110591559.6A patent/CN113313915B/en active Active
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE3467267D1 (en) * | 1983-10-17 | 1987-12-10 | Cerberus Ag | Alarm signalling method and application device therefor |
| CN104454009A (en) * | 2014-12-03 | 2015-03-25 | 中国中煤能源集团有限公司 | Gas forecasting and early-warning system and method based on sensing network |
| CN105929761A (en) * | 2016-06-28 | 2016-09-07 | 上海衡亮电子科技有限公司 | GPRS network-based LED big screen remote integrated control system |
| CN106292496A (en) * | 2016-08-31 | 2017-01-04 | 浙江浙大中控信息技术有限公司 | A kind of subway monitoring system alarming management method |
| CN107038847A (en) * | 2017-05-15 | 2017-08-11 | 天地（常州）自动化股份有限公司 | A kind of Underwell stepped alarm method, equipment and system |
| CN107829780A (en) * | 2017-10-27 | 2018-03-23 | 山西精英科技股份有限公司 | A kind of gas false alarm recognition methods based on coal mine safety monitoring networked system |
| CN107888414A (en) * | 2017-11-03 | 2018-04-06 | 杭州钛比科技有限公司 | A kind of biogas leakage monitoring system based on NB IoT |
| CN108223011A (en) * | 2018-01-11 | 2018-06-29 | 山东科技大学 | A kind of coal mine typical power disaster alarm method of servicing based on SaaS patterns |
| CN109147283A (en) * | 2018-09-06 | 2019-01-04 | 浙江航天长峰科技发展有限公司 | A kind of short message alarm system and method for safety supervision information |
| CN209028778U (en) * | 2018-09-10 | 2019-06-25 | 中国石油化工股份有限公司 | A kind of intelligence oil/gas well theft-proof box gas concentration detection warning device |
| CN109377183A (en) * | 2018-11-08 | 2019-02-22 | 合肥帧讯软件有限公司 | Coalmine Safety Supervision intelligence enforcement system |
| CN109854304A (en) * | 2019-03-11 | 2019-06-07 | 天地（常州）自动化股份有限公司 | Coal mine safety monitoring system Grading And Zoning alarm method and safety monitoring system |
| CN110118103A (en) * | 2019-05-29 | 2019-08-13 | 精英数智科技股份有限公司 | A kind of coal mine gas prewarning method |
| CN110533887A (en) * | 2019-08-07 | 2019-12-03 | 山东蓝光软件有限公司 | A kind of discrete mode method for early warning of coal and gas prominent disaster based on Real-time Monitoring Data, device and storage medium |
| CN110751815A (en) * | 2019-11-01 | 2020-02-04 | 天地（常州）自动化股份有限公司 | Intelligent control system and method for mine audible and visual alarm |
| CN111835760A (en) * | 2020-07-10 | 2020-10-27 | 广州博冠信息科技有限公司 | Alarm information processing method and device, computer storage medium and electronic equipment |
| CN111899486A (en) * | 2020-08-17 | 2020-11-06 | 航天新长征大道科技有限公司 | Logistics center safety monitoring method, device, equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 王彩林: "煤矿安全生产中瓦斯监控系统的应用研究", 《当代化工研究》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113313915B (en) | 2023-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107832196B (en) | Monitoring device and monitoring method for abnormal content of real-time log | |
| CN111459770A (en) | Server operation state warning method and device, server and storage medium | |
| CN103001804B (en) | Device-independent alert processing method, device and corresponding network management system | |
| CN111190962B (en) | File synchronization method and device and local terminal | |
| CN113297042B (en) | Method, device and equipment for processing alarm message | |
| CN106878038B (en) | Fault positioning method and device in communication network | |
| CN111782728A (en) | Data synchronization method, device, electronic equipment and medium | |
| CN113313915A (en) | Method and system for processing graded alarm short message based on gas system | |
| CN112398725B (en) | Group message prompting method, system, computer equipment and storage medium | |
| CN106487852B (en) | Method, device, terminal equipment and system for realizing client file synchronization | |
| CN106383900A (en) | Method and system for preventing mistaken deletion of data files in Sybase database | |
| CN113037549A (en) | Operation and maintenance environment warning method | |
| CN113709153B (en) | Log merging method and device and electronic equipment | |
| CN115550138A (en) | Alarm processing method and device, electronic equipment and storage medium | |
| CN112988776B (en) | Method, device and equipment for updating text parsing rule and readable storage medium | |
| CN110474800B (en) | Method for maintaining stability of resource data of transmission comprehensive network management system | |
| CN112087331B (en) | Alarm management system and method based on big data | |
| CN110457323B (en) | Data table processing method and device | |
| CN113676356A (en) | Alarm information processing method and device, electronic equipment and readable storage medium | |
| CN112769729B (en) | Server intrusion alarm method and system | |
| CN106407095B (en) | Fault handling method and device | |
| CN113806188B (en) | Data synchronization alarm method, device, equipment and readable medium | |
| CN110830766B (en) | Method and device for automatically configuring and correcting interval picture of transformer substation monitoring system | |
| CN116909838B (en) | Abnormal log reporting method, system, terminal equipment and storage medium | |
| CN114064101A (en) | Upgrading method, device, server, terminal and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |