Remote signaling data comparison method and device of transformer substation, electronic equipment and computer program product

Abstract

The invention discloses a remote signaling data comparison method and device of a transformer substation, electronic equipment and a computer program product. The method comprises the steps that a message file of a transformer substation at a preset time node is acquired, and the message file at least comprises a standby remote signaling message of at least one standby channel of the transformer substation; analyzing the standby remote signaling message of any standby channel to obtain a standby item table of the standby channel; acquiring a historical item table of the transformer substation; each main remote signaling item in the historical item table is compared with each standby remote signaling item in the standby item table one by one to obtain a comparison result, the second attribute items are in one-to-one correspondence with the first attribute items, and when any second attribute item of the main remote signaling item is inconsistent with the corresponding first attribute item in the standby remote signaling item, the standby remote signaling item is not consistent with the corresponding second attribute item in the standby remote signaling item. The comparison result shows that the main remote signaling item is inconsistent with the standby remote signaling item. According to the invention, the technical problem of low comparison efficiency of remote signaling data of multiple channels in the prior art is solved.

Description

Technical Field

[0001] The present invention relates to the field of communications, and in particular to a method, a device, an electronic device and a computer program product for comparing telesignaling data of a transformer substation. Background Art

[0002] In order to ensure the safe and stable operation of the power system, it is necessary to collect and monitor the operation data of the power system in real time to meet the needs of centralized monitoring and analysis and calculation. The dispatching automation master station currently uses the dispatching telecontrol channel to realize the real-time communication between each substation and the dispatching automation. In order to ensure the reliability of communication between each substation and the dispatching automation master station, the operation data of the substation can be sent to the master station stably, accurately and quickly. The channel between each substation and the dispatching automation master station needs to adopt a dual-channel or even a three-channel configuration scheme. When the main channel is abnormal, it can automatically switch to the backup channel to ensure that the communication is not interrupted.

[0003] The telecontrol channels for communication between the substation and the master station are mutually configured and do not interfere with each other. Each of them transmits the operation data of the substation to the master station. Among them, the telecontrol signal is the main component of the telecontrol channel sent to the master station. The telecontrol mainly refers to the switch position, protection action, device operation status and other status quantities in the substation. The telecontrol device of the substation can quickly obtain the status of each operating equipment in the substation through the transmission of telecontrol signals, and quickly judge and deal with the operation status and fault status of the power grid. It is a key data quantity in the telecontrol channel. The types of telecontrol signals are mainly divided into COS signals (occurrence events) and SOE signals (event sequence records of events). COS signals are not directly time-stamped. The signals are directly sent to the master station, and the master station records the time stamp. SOE signals are to accurately distinguish the order of each signal, and add the time stamp of the signal triggered by the station device after the signal. Since there may be a delay in the transmission of COS signals, SOE signals can well make up for the disadvantages of COS signals and accurately record the triggering time of telecontrol signals for dispatchers and decision-makers to analyze the order of events in the substation.

[0004] However, due to the coordination of the main and standby telemotors in the station, the telemotor processing mechanism, or the interference of the communication between the telemotors and the measurement and control devices, when the telesignaling data in the substation is sent to the main station through multiple channels, the number of telesignals may be inconsistent. Even due to abnormal coordination or configuration, the telesignaling signals of different channels may be quite different. When the channel is switched, it will have a serious impact on the normal monitoring of the dispatch. The dispatcher may misjudge the operation of the power grid, which directly affects the normal development of the dispatching business.

[0005] At present, the dispatching master station system can provide simple tools to display the real-time data uploaded by multiple channels, but it can only be used for the real-time data status and cannot automatically generate comparison results. The operation and maintenance personnel can only perform manual data comparison through the interface, compare the status of each real-time telesignal point, and finally draw the conclusion that the multi-channel data is inconsistent. However, this method is a static comparison method. It is impossible to check whether each channel has the telesignal change uploaded after the telesignal changes, whether the time of the telesignal change uploaded by each channel is timely, and whether the time scale of the uploaded SOE signal is consistent. In addition, the target area dispatching involves more than 250 substations, and each substation involves an average of 1,500 telesignal data. By manually comparing and viewing the data one by one in the functional interface and forming a conclusion that the data is inconsistent, the workload is huge and the feasibility is low. In actual production, it can only provide a tool for auxiliary judgment, and it has little practical significance.

[0006] With respect to the problem of low efficiency of comparing telesignaling data of multiple channels in the above-mentioned prior art, no effective solution has been proposed yet. Summary of the invention

[0007] The embodiments of the present invention provide a method, device, electronic equipment and computer program product for comparing telesignaling data of a substation, so as to at least solve the technical problem of low efficiency in comparing telesignaling data of multiple channels in the prior art.

[0008] According to one aspect of an embodiment of the present invention, a method for comparing telesignaling data of a substation is provided, comprising: obtaining a message file of the substation at a preset time node, wherein the message file at least comprises: a backup telesignaling message of at least one backup channel of the substation; analyzing the backup telesignaling message of any of the backup channels to obtain a backup matter table of the backup channel, wherein the backup telesignaling message comprises: backup telesignaling data for determining a plurality of backup telesignaling matters, wherein the backup matter table uses a plurality of first attribute items to describe each of the backup telesignaling matters; obtaining the ... A historical event table is provided, wherein the historical event table uses multiple second attribute items to describe multiple main telesignaling events of the main channel of the substation, and the second attribute items correspond to the first attribute items one by one; each of the main telesignaling events in the historical event table is compared one by one with each of the backup telesignaling events in the backup event table to obtain a comparison result, wherein, when any one of the second attribute items of the main telesignaling event is inconsistent with the corresponding first attribute item in the backup telesignaling event, the comparison result indicates that the main telesignaling event is inconsistent with the backup telesignaling event.

[0009] Optionally, analyzing the backup telesignaling message of any one of the backup channels to obtain the backup matters table of the backup channel includes: selecting any one of the backup channels as the channel to be compared from at least one of the backup channels, wherein the backup telesignaling message of the channel to be compared is the telesignaling message to be compared; selecting at least one backup telesignaling data that meets the target type identifier from multiple message data of the telesignaling message to be compared, wherein each of the message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the backup telesignaling data; analyzing each of the backup telesignaling data to obtain the backup telesignaling matters described using multiple first attribute items, wherein the backup telesignaling matters include backup attribute parameters corresponding to each of the first attribute items; filling multiple backup attribute parameters of at least one of the backup telesignaling data into the preset matters table respectively to obtain the backup matters table, wherein multiple first attribute items are pre-set in the preset matters table, and multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset matters table.

[0010] Optionally, each of the backup telesignaling data is analyzed to obtain the backup telesignaling matters described using multiple first attribute items, including: detecting whether the backup telesignaling data is the backup telesignaling displacement data; in the case where the backup telesignaling data is the backup telesignaling displacement data, determining that multiple first attribute items at least include: the telesignaling collection point, the point value and the time when the master station receives the telesignaling displacement; identifying the backup attribute parameters corresponding to each of the first attribute items from the backup telesignaling displacement data; determining multiple backup attribute parameters in the same backup telesignaling displacement data as the backup telesignaling displacement matters, wherein the backup telesignaling displacement matters are the backup telesignaling matters.

[0011] Optionally, each of the backup telesignaling data is analyzed to obtain the backup telesignaling matters described using multiple first attribute items, including: detecting whether the backup telesignaling data is backup event sequence record data; when the backup telesignaling data is the backup event sequence record data, determining that multiple first attribute items at least include: telesignaling collection points, point values ​​and event sequence record timestamps; identifying the backup attribute parameters corresponding to each of the first attribute items in the backup event sequence record data; determining multiple backup attribute parameters in the same backup event sequence record data as the same backup event sequence record matter, wherein the backup event sequence record matter is the backup telesignaling matter.

[0012] Optionally, the first attribute item also includes: a telesignaling collection point and a telesignaling description, wherein the backup attribute parameter corresponding to the telesignaling description is the telesignaling description data, and the telesignaling description data cannot be obtained by analyzing the backup telesignaling data; filling in the multiple backup attribute parameters of at least one of the backup telesignaling data into the preset matter table respectively, and obtaining the backup matter table includes: filling in the multiple backup attribute parameters of at least one of the backup telesignaling data into the preset matter table respectively, and obtaining the pre-processing matter table, wherein the pre-processing matter table includes multiple pre-processing matters, and the multiple backup attribute parameters of each pre-processing matter include at least: the telesignaling point number corresponding to the telesignaling collection point; among the multiple preset attribute parameters recorded in the preset telesignaling point table, querying the preset attribute parameter corresponding to each of the telesignaling point numbers as the telesignaling description data, wherein the preset telesignaling point table records the correspondence between the collection point and the preset attribute parameter using the telesignaling collection point and the telesignaling description; in the pre-processing matter table, filling the telesignaling description data into the pre-processing matter of the same telesignaling point number to obtain the backup matter table.

[0013] Optionally, the historical event table includes at least one of the following: a historical telesignaling change event table, and a historical event sequence record event table; obtaining the historical event table of the substation includes: obtaining the historical telesignaling change event table of the substation, wherein the multiple second attribute items used in the historical telesignaling change event table include at least: telesignaling description, point value and time when the master station receives the telesignaling change; obtaining the historical event sequence record event table of the substation, wherein the multiple second attribute items used in the historical event sequence record event table include at least: telesignaling description, point value and event sequence record timestamp.

[0014] Optionally, each of the main telesignaling items in the historical items table is compared one by one with each of the backup telesignaling items in the backup items table, and the comparison result obtained includes: selecting any one of the main telesignaling items in the historical items table as the main telesignaling item to be compared; traversing the backup telesignaling items corresponding to the main telesignaling item to be compared among the multiple backup telesignaling items recorded in the backup items table as the comparison backup telesignaling items; obtaining the main attribute parameter corresponding to each of the second attribute items in the main telesignaling item to be compared, and obtaining the backup attribute parameter corresponding to each of the first attribute items in the comparison backup telesignaling item; comparing each of the main attribute parameters with the backup attribute parameters based on the corresponding relationship between the first attribute items and the second attribute items, and generating the comparison result, wherein, when any one of the main attribute parameters is inconsistent with the backup attribute parameter, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item, and when the main attribute parameter and the backup attribute parameter are consistent, the comparison result indicates that the main telesignaling item is consistent with the backup telesignaling item.

[0015] According to another aspect of an embodiment of the present invention, a telesignaling data comparison device for a substation is also provided, comprising: a first acquisition module, used to acquire a message file of the substation at a preset time node, wherein the message file at least includes: a backup telesignaling message of at least one backup channel of the substation; an analysis module, used to analyze the backup telesignaling message of any of the backup channels to obtain a backup matter table of the backup channel, wherein the backup telesignaling message includes: backup telesignaling data for determining a plurality of backup telesignaling matters, wherein the backup matter table uses a plurality of first attribute items to describe each of the backup telesignaling matters; a second acquisition module , used to obtain the historical event table of the substation, wherein the historical event table uses multiple second attribute items to describe multiple main telesignaling events of the main channel of the substation, and the second attribute items correspond to the first attribute items one by one; a comparison module, used to compare each of the main telesignaling events in the historical event table with each of the backup telesignaling events in the backup event table one by one, to obtain a comparison result, wherein, in the case where any one of the second attribute items of the main telesignaling event is inconsistent with the corresponding first attribute item in the backup telesignaling event, the comparison result indicates that the main telesignaling event is inconsistent with the backup telesignaling event.

[0016] According to another aspect of an embodiment of the present invention, there is further provided an electronic device, including a memory and a processor, wherein the memory stores a computer program, and the processor is configured to execute the above-mentioned substation telesignaling data comparison method through the computer program.

[0017] According to another aspect of an embodiment of the present invention, there is further provided a computer program product, comprising computer instructions, which, when executed by a processor, implement the steps of the above-mentioned substation telesignaling data comparison method.

[0018] In an embodiment of the present invention, a message file of a substation at a preset time node is obtained, wherein the message file at least includes: a backup telesignal message of at least one backup channel of the substation; the backup telesignal message of any backup channel is analyzed to obtain a backup matter table of the backup channel, wherein the backup telesignal message includes: backup telesignal data for determining a plurality of backup telesignal matters, wherein the backup matter table uses a plurality of first attribute items to describe each backup telesignal matter; a historical matter table of the substation is obtained, wherein the historical matter table uses a plurality of second attribute items to describe a plurality of main telesignal matters of a main channel of the substation, and the second attribute items correspond one to one with the first attribute items; the historical matters are Each main telesignaling item in the table is compared one by one with each backup telesignaling item in the backup item table to obtain a comparison result. Among them, when any second attribute item of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item. Therefore, by using the backup item table and the historical item table, the comparison of multi-channel real-time telesignaling data is converted into a comparison of offline historical items and message items, thereby achieving the purpose of automatically obtaining the comparison result, thereby realizing the technical effect of improving the comparison efficiency, and further solving the technical problem of low efficiency in comparing telesignaling data of multiple channels in the prior art. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0020] Figure 1 is a flow chart of a remote signaling data comparison method for a substation according to an embodiment of the present invention;

[0021] Figure 2 is a schematic diagram of a remote signaling data comparison device for a substation according to an embodiment of the present invention;

[0022] Figure 3 It is a structural block diagram of a computer terminal according to an embodiment of the present invention. DETAILED DESCRIPTION

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

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

[0025] According to an embodiment of the present invention, an embodiment of a remote signaling data comparison method for a substation is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0026] Figure 1 is a flow chart of a remote signaling data comparison method for a substation according to an embodiment of the present invention. Figure 1 As shown, the method comprises the following steps:

[0027] Step S102, obtaining a message file of the substation at a preset time node, wherein the message file at least includes: a standby telesignal message of at least one standby channel of the substation;

[0028] Step S104, analyzing the standby telesignaling message of any standby channel to obtain a standby event table of the standby channel, wherein the standby telesignaling message includes: standby telesignaling data for determining a plurality of standby telesignaling events, and the standby event table uses a plurality of first attribute items to describe each standby telesignaling event;

[0029] Step S106, obtaining a historical event table of the substation, wherein the historical event table uses a plurality of second attribute items to describe a plurality of main remote signaling events of a main channel of the substation, and the second attribute items correspond one to one with the first attribute items;

[0030] Step S108, compare each main telesignaling item in the historical item table with each backup telesignaling item in the backup item table one by one to obtain a comparison result, wherein, when any second attribute item of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item.

[0031] In an embodiment of the present invention, a message file of a substation at a preset time node is obtained, wherein the message file at least includes: a backup telesignal message of at least one backup channel of the substation; the backup telesignal message of any backup channel is analyzed to obtain a backup matter table of the backup channel, wherein the backup telesignal message includes: backup telesignal data for determining a plurality of backup telesignal matters, wherein the backup matter table uses a plurality of first attribute items to describe each backup telesignal matter; a historical matter table of the substation is obtained, wherein the historical matter table uses a plurality of second attribute items to describe a plurality of main telesignal matters of a main channel of the substation, and the second attribute items correspond one to one with the first attribute items; the historical matters are Each main telesignaling item in the table is compared one by one with each backup telesignaling item in the backup item table to obtain a comparison result. Among them, when any second attribute item of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item. Therefore, by using the backup item table and the historical item table, the comparison of multi-channel real-time telesignaling data is converted into a comparison of offline historical items and message items, thereby achieving the purpose of automatically obtaining the comparison result, thereby realizing the technical effect of improving the comparison efficiency, and further solving the technical problem of low efficiency in comparing telesignaling data of multiple channels in the prior art.

[0032] In the above step S102, the preset time node may be one day.

[0033] In the above step S102, the message file may be extracted from a message history storage server of the electric power dispatching automation system.

[0034] In the above step S102, the message file may include messages of telecontrol channels of multiple substations. After acquiring the message file, the substations may be distinguished to obtain the message of each substation.

[0035] In the above step S102, each substation may include a main channel and at least one backup channel.

[0036] Optionally, when there is only one backup channel, the backup telesignaling message of the backup channel is used to generate a backup event table, and then the backup event table is compared with the historical event table to obtain a final comparison result.

[0037] Optionally, in the case of multiple backup channels, a backup telesignaling message of one of the backup channels can be selected from the multiple backup channels to generate a backup matters table, and then the backup matters table can be compared with the historical matters table; then after the comparison of the backup channel is completed, a backup telesignaling message of a different backup channel can be selected from the multiple backup channels again, and the backup matters table can be generated again for comparison until all the backup channels of the substation are compared with the main channel.

[0038] In the above step S104, the message files of each backup channel are translated and analyzed, and the sent messages with the sending type marked as remote signaling COS and SOE mutations in the messages are filtered, all remote signaling COS and SOE mutation messages are retained, and other message data are discarded to obtain the backup remote signaling message.

[0039] In the above step S106, the historical events or data of the substation are generally processed by a dedicated data acquisition and storage system, and the historical event table of the substation can be obtained from the storage system.

[0040] It should be noted that the first attribute item in the backup event table corresponds one-to-one to the second attribute item in the historical event table. When comparing the main telesignaling event in the historical event table with the backup telesignaling event in the backup event table, the corresponding part of the second attribute item in the main telesignaling event, such as the main attribute parameter corresponding to the second attribute item, and the corresponding part of the first attribute item in the backup telesignaling event, such as the backup attribute parameter corresponding to the first attribute item, can be compared for consistency.

[0041] Optionally, when any second attribute item of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item and the backup telesignaling item are inconsistent; when the second attribute item of the main telesignaling item and the corresponding first attribute item in the backup telesignaling item are consistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are consistent.

[0042] As an optional embodiment, the backup telesignaling message of any backup channel is analyzed to obtain the backup matters table of the backup channel, including: selecting any one of the backup channels as the channel to be compared from at least one backup channel, wherein the backup telesignaling message of the channel to be compared is the telesignaling message to be compared; selecting at least one backup telesignaling data that meets the target type identifier from multiple message data of the telesignaling message to be compared, wherein each message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the backup telesignaling data; analyzing each backup telesignaling data to obtain backup telesignaling matters described by multiple first attribute items, wherein the backup telesignaling matters include backup attribute parameters corresponding to each first attribute item respectively; filling multiple backup attribute parameters of at least one backup telesignaling data into the preset matters table respectively to obtain the backup matters table, wherein the preset matters table is pre-set with multiple first attribute items, and multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset matters table.

[0043] In the above-mentioned embodiment of the present application, the standby telesignaling messages of the standby channel are selected one by one as the channel to be compared, and the telesignaling messages to be compared include multiple message data of different types, and each message data is pre-equipped with a corresponding preset type identifier to indicate the type of the message data. Then, when the standby matter table is generated according to the standby telesignaling message, the multiple message data of the standby telesignaling message can be screened to obtain the standby telesignaling data indicated by the target type identifier, and then the standby telesignaling data is analyzed to obtain the standby attribute parameters corresponding to each first attribute item, and then each standby attribute parameter is filled in the preset matter table to obtain the standby matter table, thereby realizing the determination of the standby matter table.

[0044] Optionally, each column of the preset event table represents a first attribute item, each row represents a backup telesignaling event, and each backup telesignaling event is determined according to a corresponding backup telesignaling data.

[0045] As an optional embodiment, each backup telesignaling data is analyzed to obtain backup telesignaling matters described by multiple first attribute items, including: detecting whether the backup telesignaling data is backup telesignaling displacement data; in the case where the backup telesignaling data is backup telesignaling displacement data, determining multiple first attribute items at least including: telesignaling collection point, point value and time when the master station receives the telesignaling displacement; identifying the backup attribute parameters corresponding to each first attribute item in the backup telesignaling displacement data; determining multiple backup attribute parameters in the same backup telesignaling displacement data as backup telesignaling displacement matters, wherein the backup telesignaling displacement matters are backup telesignaling matters.

[0046] In the above embodiments of the present application, the backup telesignaling data may be backup telesignaling position change data (such as COS data of a backup channel). When the backup telesignaling data is backup telesignaling position change data, the multiple first attribute items that need to be determined include at least: the telesignaling collection point, the point value and the time when the master station receives the telesignaling position change (such as the time when the master station receives the COS data). The backup telesignaling items generated are the backup telesignaling position change items.

[0047] Optionally, in the case where the backup telesignaling item is a backup telesignaling position change item, the preset item table is a preset telesignaling position change item table based on "telesignaling collection point, point value and master station receiving telesignaling position change time".

[0048] Optionally, in the case where the backup telesignaling item is a backup telesignaling position change item, the backup item table is a backup telesignaling position change item table based on "telesignaling collection point, point value and master station receiving telesignaling position change time".

[0049] As an optional embodiment, each backup telesignaling data is analyzed to obtain a backup telesignaling matter described by multiple first attribute items, including: detecting whether the backup telesignaling data is a backup event sequence record data; when the backup telesignaling data is a backup event sequence record data, determining that multiple first attribute items at least include: a telesignaling collection point, a point value and an event sequence record time stamp; identifying the backup attribute parameters corresponding to each first attribute item in the backup event sequence record data; and determining multiple backup attribute parameters in the same backup event sequence record data as the same backup event sequence record matter, wherein the backup event sequence record matter is a backup telesignaling matter.

[0050] In the above-mentioned embodiments of the present application, the backup telesignaling data may be backup event sequence record data (such as SOE data of a backup channel). When the backup telesignaling data is backup event sequence record data, the multiple first attribute items that need to be determined include at least: telesignaling collection point, point value and event sequence record time stamp (such as SOE time stamp), and the backup telesignaling items generated are backup event sequence record items, and the backup item table generated based on the backup event sequence record items is the backup event sequence record item table.

[0051] Optionally, in the case where the backup telesignaling data is backup event sequence recording data, the preset event table is a preset event sequence recording event table based on "telesignaling collection points, point values ​​and event sequence recording time stamps".

[0052] Optionally, in the case where the backup telesignaling data is backup event sequence record data, the backup matter table is a backup event sequence record matter table based on "telesignaling collection points, point values ​​and event sequence record time stamps".

[0053] As an optional embodiment, the first attribute item also includes: a telesignaling collection point and a telesignaling description, wherein the backup attribute parameter corresponding to the telesignaling description is the telesignaling description data, and the telesignaling description data cannot be obtained by analyzing the backup telesignaling data; filling in multiple backup attribute parameters of at least one backup telesignaling data into the preset item table respectively, and obtaining the backup item table includes: filling in multiple backup attribute parameters of at least one backup telesignaling data into the preset item table respectively, and obtaining a pre-processing item table, wherein the pre-processing item table includes multiple pre-processing items, and the multiple backup attribute parameters of each pre-processing item include at least: the telesignaling point number corresponding to the telesignaling collection point; among the multiple preset attribute parameters recorded in the preset telesignaling point table, querying the preset attribute parameters corresponding to each telesignaling point number as the telesignaling description data, wherein the preset telesignaling point table records the correspondence between the collection point and the preset attribute parameters using the telesignaling collection point and the telesignaling description; in the pre-processing item table, filling the telesignaling description data into the pre-processing items of the same telesignaling point number to obtain the backup item table.

[0054] In the above-mentioned embodiment of the present application, the preset telesignaling point table includes at least two columns, the first column records the telesignaling point number corresponding to the telesignaling collection point, and the second column records the telesignaling description data corresponding to the telesignaling description. Each row of the preset telesignaling point table represents the correspondence between the collection point and the preset attribute parameters. Since the telesignaling description data corresponding to the telesignaling description cannot be directly obtained from the backup telesignaling data, and the telesignaling point number corresponding to the telesignaling collection point can be obtained by analyzing the backup telesignaling data, after analyzing the backup telesignaling data, the backup attribute parameters of the backup telesignaling data may include the telesignaling point number, and then after filling the backup attribute parameters of the backup telesignaling data into the preset event table, the telesignaling description data corresponding to the telesignaling description can be queried in the preset telesignaling point table according to the telesignaling point number, and then the telesignaling description data of each backup telesignaling data is filled into the corresponding position of the preset event table to obtain the backup event table, thereby determining the backup event table.

[0055] As an optional embodiment, the historical event table includes at least one of the following: a historical telesignaling change event table, and a historical event sequence record event table; obtaining the historical event table of the substation includes: obtaining the historical telesignaling change event table of the substation, wherein the multiple second attribute items used in the historical telesignaling change event table include at least: telesignaling description, point value and the time when the master station received the telesignaling change; obtaining the historical event sequence record event table of the substation, wherein the multiple second attribute items used in the historical event sequence record event table include at least: telesignaling description, point value and event sequence record timestamp.

[0056] In the above-mentioned embodiment of the present application, the historical event table may be a historical telesignaling change event table (used to record COS events of the main channel), and the multiple second attribute items in the historical telesignaling change event table include at least: telesignaling description, point value and the time when the master station receives the telesignaling change (such as the time when the master station receives the COS); the historical event table may also be a historical event sequence recording event table (used to record SOE events of the main channel), and the multiple second attribute items in the historical event sequence recording event table include at least: telesignaling description, point value and event sequence recording time stamp (such as SOE time stamp).

[0057] Optionally, when each main telesignaling item in the historical event table is compared one by one with each backup telesignaling item in the backup event table, the historical telesignaling change event table of the main channel can be compared with the backup telesignaling change event table of the backup channel; the historical event sequence record event table of the main channel can also be compared with the backup event sequence record event table.

[0058] As an optional embodiment, each main telesignaling item in the historical item table is compared one by one with each backup telesignaling item in the backup item table, and the comparison result includes: selecting any main telesignaling item in the historical item table as the main telesignaling item to be compared; traversing the backup telesignaling items corresponding to the main telesignaling item to be compared among the multiple backup telesignaling items recorded in the backup item table as the comparison backup telesignaling items; obtaining the main attribute parameter corresponding to each second attribute item in the main telesignaling item to be compared, and obtaining the backup attribute parameter corresponding to each first attribute item in the comparison backup telesignaling item; comparing each main attribute parameter with the backup attribute parameter based on the correspondence between the first attribute item and the second attribute item, and generating a comparison result, wherein, when any main attribute parameter is inconsistent with the backup attribute parameter, the comparison result indicates that the main telesignaling item and the backup telesignaling item are inconsistent, and when the main attribute parameter and the backup attribute parameter are consistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are consistent.

[0059] In the above embodiment of the present application, the main telesignaling items in the historical items table are carefully compared one by one with the multiple backup telesignaling items in the backup items table. The principle of the comparison is to compare the main attribute parameter corresponding to each second attribute item in the main telesignaling item with the backup attribute parameter corresponding to each first attribute item in the backup telesignaling item for consistency. For example, when comparing the main attribute parameter corresponding to the second attribute item, the first attribute item corresponding to the second attribute item can be determined, and the backup attribute parameter corresponding to the first attribute item can be obtained, and then the main attribute parameter and the backup attribute parameter are compared for consistency. Then, when the main attribute parameter corresponding to each second attribute item in the main telesignaling item is consistent with the backup telesignaling item corresponding to the first attribute item in the backup items table, it is determined that the comparison result indicates that the main telesignaling item is consistent with the backup telesignaling item; otherwise, when there is at least one main attribute parameter corresponding to the second attribute item in the main telesignaling item, which is inconsistent with the backup telesignaling item corresponding to the first attribute item in the backup items table. It is determined that the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item, and the consistency comparison is achieved.

[0060] The present invention also provides an optional embodiment, which provides a remote control multi-channel telesignaling consistency comparison method based on substation offline messages, converts the comparison of multi-channel real-time telesignaling data into a comparison of offline historical events and message events, and automatically obtains the comparison results, automatically analyzes the data points that may have inconsistent data in the substation remote control multi-channel, and outputs them to operation and maintenance personnel for timely investigation and processing.

[0061] The technical solution provided by the present application extracts offline messages, filters out the remote signaling COS and SOE data of each standby channel of each substation from the offline messages of the previous day every day, and forms a list of matters (such as a standby matter list), compares the remote signaling list of the standby channel of the substation channel (such as the standby matter list) with the historical matter list of the main channel, and evaluates whether the standby channel between the substation and the dispatching automation master station is consistent in remote signaling. The method includes the following steps:

[0062] Step S201, extracting the message files of the telecontrol channels of each substation on the previous day from the message history storage server of the electric power dispatching automation system, and distinguishing them according to different substations to obtain message files.

[0063] Step S202, initialization forms two temporary data tables of message COS items and SOE items,

[0064] Table 1 is a message COS event data table of the present embodiment. As shown in Table 1, the format of the COS event table (such as the preset telesignal change event table) mainly consists of five columns (such as the first attribute item), telesignal collection point, corresponding description (i.e. telesignal description), point value, COS received time at the master station, and whether it matches.

[0065] Table 1

[0066] Remote signal collection point Corresponding description Point Value Master station receives COS time Match

[0067] Table 2 is a message SOE event data table of the present embodiment. As shown in Table 2, the format of the SOE event table (such as the preset event sequence record event table) mainly consists of five columns (such as the first attribute item), telesignal collection point, corresponding description (i.e. telesignal description), point value, SOE time stamp, and whether it matches.

[0068] Table 2

[0069] Remote signal collection point Corresponding description Point Value SOE Time Scale Match

[0070] Step S203, obtain the relationship between the main channel and the backup channel in the substation, translate and analyze the message files of each backup channel (such as backup telesignal messages), filter the messages with the upload type marked as telesignal COS and SOE mutations, retain all telesignal COS and SOE messages, discard other message data, and obtain backup telesignal data.

[0071] Step S204, analyze the telesignal COS and SOE messages (such as backup telesignal messages), and write the COS matters (such as backup telesignal change matters) and SOE matters (such as backup event sequence record matters) of the backup channel of the station into the COS table (such as the preset telesignal change matters table) and SOE table (such as the preset event sequence record matters table) created in step S202 according to the message order.

[0072] Table 3 is a schematic table of an example of message COS matter data message analysis writing in this embodiment. As shown in Table 3, taking the backup channel message of the test station on June 1, 2024 as an example, the analysis results are written into the data table to generate a pre-processing matter table for COS.

[0073] Table 3

[0074]

[0075]

[0076] Table 4 is a schematic table of a sample of message SOE matter data message analysis writing in this embodiment. As shown in Table 4, taking the backup channel message of the test station on June 1, 2024 as an example, the analysis results are written into the data table to generate a pre-processing matter table for SOE.

[0077] Table 4

[0078] Remote signal collection point Corresponding description Point Value SOE Time Scale Match 14 1 2024 / 6 / 1 06:03:26:101 14 0 2024 / 6 / 1 06:05:33:876 92 1 2024 / 6 / 1 09:14:51:043 75 1 2024 / 6 / 1 18:43:11:579 75 0 2024 / 6 / 1 18:47:40:865

[0079] Step S205, read the telesignal point table of the station in the SCADA database (such as the preset telesignal point table), confirm the correspondence between the telesignal point number and the telesignal description, and complete the telesignal description according to the telesignal point data (such as the telesignal point number) filled in step S204. Taking the test station as an example, the correspondence between the telesignal collection point number (such as the telesignal point number) and the description is confirmed by querying the database.

[0080] Table 5 is a schematic table of a sample of message COS event data message analysis and writing in this embodiment. As shown in Table 5, the sample of message COS event data message analysis and writing shown in Table 3 is completed to obtain a standby remote signal change event table.

[0081] Table 5

[0082]

[0083]

[0084] Table 6 is a schematic table of a sample of message SOE event data message analysis and writing in this embodiment. As shown in Table 6, the sample of message SOE event data message analysis and writing shown in Table 4 is completed to obtain a backup event sequence record event table.

[0085] Table 6

[0086]

[0087] Step S206, read the historical events of the substation yesterday (the historical events are formed by the data of the main channel), analyze the action / closed position words as the corresponding value 1, and analyze the reset / open position words as the corresponding value 0, and form the historical event COS table (such as the historical telesignal change event table) and SOE table (such as the historical event sequence record event table) respectively. The COS historical event table consists of four fields (such as the second attribute item): telesignal description, corresponding point value, master station received COS time, whether it matches, and the SOE historical event table consists of four fields (such as the second attribute item): telesignal description, corresponding point value, SOE time stamp, whether it matches.

[0088] Table 7 is a SCADA system COS historical event table of the present embodiment. As shown in Table 7, taking the SCADA historical events of the test station on June 1, 2024 as an example, the analysis results are written into the data table to obtain the historical telesignal change event table.

[0089] Table 7

[0090]

[0091] Table 8 is a SCADA system SOE historical event table of the present embodiment. As shown in Table 8, taking the SCADA historical events of the test station on June 1, 2024 as an example, the analysis results are written into the data table to obtain the historical telesignal change event table and the historical event sequence record event table.

[0092] Table 8

[0093]

[0094]

[0095] Step S207, COS item consistency comparison, using the data in the SCADA system COS historical item table (such as the historical telesignaling change item table) as a benchmark, the system reads the telesignaling data of each row of the table one by one, and searches for the corresponding COS item in the message COS item data table (such as the standby telesignaling change item table). If the corresponding item can be found, the SCADA system COS historical item table and the message COS item data table will be filled with 1 in the corresponding row match. If the search does not produce any results, the SCADA system COS historical item table will be filled with 0 in the corresponding row match. The specific search principles are:

[0096] Step S31, the time error between the SCADA system COS event and the message COS event is ±1 minute. (That is, if the sending time of the same remote signal backup channel and the main channel differs within 1 minute, it is judged to be consistent).

[0097] Step S32: the telesignaling description of the COS event of the SCADA system is consistent with the telesignaling description of the COS event of the message.

[0098] Step S33, the telesignal point value of the SCADA system COS event is consistent with the point value of the message COS event.

[0099] When the above three conditions are met, the "Whether Match" column of the corresponding row in the SCADA system COS historical event table and the message COS event data table can be filled with 1 at the same time. In other mismatching cases, the "Whether Match" item of the corresponding row in the SCADA system COS historical event table is filled with 0.

[0100] Step S208, SOE item consistency comparison, using the data in the SCADA system SOE historical item table (such as the historical event sequence record item table) as a benchmark, the system reads the telesignal data of each row of the table one by one, and searches for the corresponding SOE item in the message SOE item data table (such as the backup event sequence record item table). If the corresponding item can be searched, the SCADA system SOE historical item table and the message SOE item data table will be filled with 1 in the corresponding row of the match. If the search does not produce any results, the SCADA system SOE historical item table will be filled with 0 in the corresponding row of the match. The specific search principles are:

[0101] Step S41, the time stamp of the SOE event of the SCADA system is consistent with the time stamp in the SOE event of the message.

[0102] Step S42: the telesignaling description of the COS event of the SCADA system is consistent with the telesignaling description of the COS event of the message.

[0103] Step S33, the telesignal point value of the SCADA system COS event is consistent with the point value of the message COS event.

[0104] When the above three conditions are met, the "Whether Match" column of the corresponding row in the SCADA system SOE historical event table and the message SOE event data table can be filled with 1 at the same time. In other mismatching cases, the "Whether Match" item of the corresponding row in the SCADA system COS historical event table is filled with 0.

[0105] Step S209, fill all the empty fields in the "matching" column in the message COS event table (such as the standby telesignaling change event table) and the message SOE event table (such as the standby event sequence record event table) with 0. Taking the test station as an example, after comparing step S207, step S208 and step S209, the following four result tables are obtained.

[0106] Table 9 is a schematic table of an example of message COS event data message comparison results of this embodiment. As shown in Table 9, fill in the "Whether Match" column in the standby remote signal change event table.

[0107] Table 9

[0108]

[0109]

[0110] Table 10 is a schematic table of an example of a message SOE event data comparison result of this embodiment. As shown in Table 10, the "Whether Match" column is filled in the standby remote signal change event table.

[0111] Table 10

[0112]

[0113] Table 11 is a SCADA system COS historical event table of this embodiment. As shown in Table 11, the "Whether Match" column is filled in the historical remote signal change event table.

[0114] Table 11

[0115]

[0116]

[0117] Table 12 is a SCADA system COS historical event table of this embodiment. As shown in Table 12, the "Whether Match" column is filled in the historical event sequence record event table.

[0118] Table 12

[0119]

[0120]

[0121] Step S210, draw a consistency conclusion. Analyze the "Whether Match" column in the message COS event table (such as the standby remote signal change event table) and the SCADA system COS event table (such as the historical remote signal change event table). When the "Whether Match" in the SCADA system COS historical event table (such as the historical remote signal change event table), the SCADA system SOE historical event table (such as the historical event sequence record event table), the message COS event table (such as the standby remote signal change event table), and the message SOE event table (such as the standby event sequence record event table) are all 1, it is judged that the remote signal signal of the standby channel is consistent with that of the main channel; as long as there is a value of 0 in the "Whether Match" in the four tables, it is judged that the remote signal signal of the standby channel is inconsistent with that of the main channel. The comparison results are provided to the operation and maintenance personnel in the form of a list for analysis and the next step of troubleshooting.

[0122] Step S211, in case that a certain substation has multiple backup channels, each backup channel can be analyzed and judged according to steps S203 to S210 to obtain the consistency of the backup channel and the main channel telesignal.

[0123] Step S212, after the program completes the analysis of the multi-channel telesignaling signal of the substation, it continues to analyze the consistency comparison of the telesignaling data of the next substation according to the above steps (ie, execute steps S202-S210).

[0124] The present application proposes a method for comparing the consistency of multi-channel telesignaling data of a substation based on offline messages. By generating a list of telesignaling COS and SOE items of the main channel of the substation, and comparing the list of telesignaling COS and SOE items of the standby channel message, the number of telesignals of different channels, the COS upload time, the consistency of the SOE time scale, etc., the operation status of the channels where the telesignaling data may be inconsistent is obtained, and the abnormal situation is reported in time so that the relevant automation personnel can investigate and deal with it, so as to avoid the occurrence of telesignaling errors, omissions, frequent transmissions, etc. after channel switching, which affects the normal operation of the power grid dispatching business; the method replaces the manual comparison of multi-channel telesignaling information data of each substation by automation personnel through program operation calculation, and can record the substations with abnormal multi-channel telesignaling signals of the previous day every day, and can timely discover the problem of inconsistent transmission of telesignaling signals of substation channels, solving the pain points of large workload and inaccurate comparison results in the past, greatly reducing the burden on staff and ensuring the safe and stable operation of the power system.

[0125] According to an embodiment of the present invention, an embodiment of a telesignaling data comparison device for a substation is also provided. It should be noted that the telesignaling data comparison device for the substation can be used to execute the telesignaling data comparison method for the substation in the embodiment of the present invention, and the telesignaling data comparison method for the substation in the embodiment of the present invention can be executed in the telesignaling data comparison device for the substation.

[0126] Figure 2 is a schematic diagram of a remote signaling data comparison device for a substation according to an embodiment of the present invention, such as Figure 2 As shown, the device may include: a first acquisition module 22, used to acquire a message file of the substation at a preset time node, wherein the message file includes at least: a backup telesignal message of at least one backup channel of the substation; an analysis module 24, used to analyze the backup telesignal message of any backup channel to obtain a backup matter table of the backup channel, wherein the backup telesignal message includes: backup telesignal data for determining multiple backup telesignal matters, and the backup matter table uses multiple first attribute items to describe each backup telesignal matter; a second acquisition module 26, used to acquire a historical matter table of the substation, wherein the historical matter table uses multiple second attribute items to describe multiple main telesignal matters of the main channel of the substation, and the second attribute items correspond to the first attribute items one by one; a comparison module 28, used to compare each main telesignal matter in the historical matter table with each backup telesignal matter in the backup matter table one by one to obtain a comparison result, wherein, when any second attribute item of the main telesignal matter is inconsistent with the corresponding first attribute item in the backup telesignal matter, the comparison result indicates that the main telesignal matter is inconsistent with the backup telesignal matter.

[0127] It should be noted that the first acquisition module 22 in this embodiment can be used to execute step S102 in the embodiment of the present application, the analysis module 24 in this embodiment can be used to execute step S104 in the embodiment of the present application, the second acquisition module 26 in this embodiment can be used to execute step S106 in the embodiment of the present application, and the comparison module 28 in this embodiment can be used to execute step S108 in the embodiment of the present application. The examples and application scenarios implemented by the above modules and corresponding steps are the same, but are not limited to the contents disclosed in the above embodiments.

[0128] In an embodiment of the present invention, a message file of a substation at a preset time node is obtained, wherein the message file at least includes: a backup telesignal message of at least one backup channel of the substation; the backup telesignal message of any backup channel is analyzed to obtain a backup matter table of the backup channel, wherein the backup telesignal message includes: backup telesignal data for determining a plurality of backup telesignal matters, wherein the backup matter table uses a plurality of first attribute items to describe each backup telesignal matter; a historical matter table of the substation is obtained, wherein the historical matter table uses a plurality of second attribute items to describe a plurality of main telesignal matters of a main channel of the substation, and the second attribute items correspond one to one with the first attribute items; the historical matters are Each main telesignaling item in the table is compared one by one with each backup telesignaling item in the backup item table to obtain a comparison result. Among them, when any second attribute item of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item. Therefore, by using the backup item table and the historical item table, the comparison of multi-channel real-time telesignaling data is converted into a comparison of offline historical items and message items, thereby achieving the purpose of automatically obtaining the comparison result, thereby realizing the technical effect of improving the comparison efficiency, and further solving the technical problem of low efficiency in comparing telesignaling data of multiple channels in the prior art.

[0129] As an optional embodiment, the analysis module includes: a first selection unit, used to select any one of the at least one backup channel as the channel to be compared, wherein the backup telesignaling message of the channel to be compared is the telesignaling message to be compared; a second selection unit, used to select at least one backup telesignaling data that meets the target type identifier from multiple message data of the telesignaling message to be compared, wherein each message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the backup telesignaling data; an analysis unit, used to analyze each backup telesignaling data to obtain a backup telesignaling matter described using multiple first attribute items, wherein the backup telesignaling matter includes backup attribute parameters corresponding to each first attribute item respectively; a filling unit, used to fill in multiple backup attribute parameters of at least one backup telesignaling data into a preset matter table respectively to obtain a backup matter table, wherein the preset matter table is pre-set with multiple first attribute items, and multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset matter table.

[0130] As an optional embodiment, the analysis unit includes: a first detection subunit, used to detect whether the backup telesignaling data is the backup telesignaling displacement data; a first determination subunit, used to determine, when the backup telesignaling data is the backup telesignaling displacement data, that a plurality of first attribute items at least include: the telesignaling collection point, the point value and the time when the master station receives the telesignaling displacement; a first identification subunit, used to identify the backup attribute parameters corresponding to each first attribute item from the backup telesignaling displacement data; and a second determination subunit, used to determine a plurality of backup attribute parameters in the same backup telesignaling displacement data as backup telesignaling displacement matters, wherein the backup telesignaling displacement matters are backup telesignaling matters.

[0131] As an optional embodiment, the analysis unit includes: a second detection subunit, used to detect whether the backup telesignaling data is a backup event sequence record data; a third determination subunit, used to determine, when the backup telesignaling data is a backup event sequence record data, multiple first attribute items at least including: telesignaling collection point, point value and event sequence record time stamp; a second identification subunit, used to identify the backup attribute parameters corresponding to each first attribute item from the backup event sequence record data; a fourth determination subunit, used to determine multiple backup attribute parameters in the same backup event sequence record data as the same backup event sequence record item, wherein the backup event sequence record item is a backup telesignaling item.

[0132] As an optional embodiment, the first attribute item also includes: a telesignaling collection point and a telesignaling description, wherein the backup attribute parameter corresponding to the telesignaling description is the telesignaling description data, and the telesignaling description data cannot be obtained by analyzing the backup telesignaling data; the filling unit includes: a first filling subunit, used to fill in multiple backup attribute parameters of at least one backup telesignaling data into the preset matter table respectively to obtain a pre-processing matter table, wherein the pre-processing matter table includes multiple pre-processing matters, and the multiple backup attribute parameters of each pre-processing matter include at least: the telesignaling point number corresponding to the telesignaling collection point; a query subunit, used to query the preset attribute parameters corresponding to each telesignaling point number in the multiple preset attribute parameters recorded in the preset telesignaling point table as the telesignaling description data, wherein the preset telesignaling point table record is used to use the telesignaling collection point and the telesignaling description to describe the correspondence between the collection point and the preset attribute parameters; a second filling subunit, used to fill in the telesignaling description data into the pre-processing matters of the same telesignaling point number in the pre-processing matter table to obtain the backup matter table.

[0133] As an optional embodiment, the historical event table includes at least one of the following: a historical telesignaling change event table, and a historical event sequence record event table; the second acquisition module includes: a first acquisition unit, used to obtain the historical telesignaling change event table of the substation, wherein the multiple second attribute items used in the historical telesignaling change event table include at least: telesignaling description, point value and the time when the master station receives the telesignaling change; a second acquisition unit, used to obtain the historical event sequence record event table of the substation, wherein the multiple second attribute items used in the historical event sequence record event table include at least: telesignaling description, point value and event sequence record timestamp.

[0134] As an optional embodiment, the comparison module includes: a third selection unit, used to select any one main telesignaling item in the historical item table as the main telesignaling item to be compared; a traversal unit, used to traverse the backup telesignaling items corresponding to the main telesignaling item to be compared among the multiple backup telesignaling items recorded in the backup item table as the comparison backup telesignaling items; a third acquisition unit, used to obtain the main attribute parameter corresponding to each second attribute item in the main telesignaling item to be compared, and to obtain the backup attribute parameter corresponding to each first attribute item in the comparison backup telesignaling item; a comparison unit, used to compare whether each main attribute parameter is consistent with the backup attribute parameter based on the correspondence between the first attribute item and the second attribute item, and generate a comparison result, wherein, when any one of the main attribute parameters is inconsistent with the backup attribute parameter, the comparison result indicates that the main telesignaling item and the backup telesignaling item are inconsistent, and when the main attribute parameter and the backup attribute parameter are consistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are consistent.

[0135] An embodiment of the present invention may provide an electronic device, the electronic device being a computer terminal, and the computer terminal may be any computer terminal device in a computer terminal group. Optionally, in this embodiment, the computer terminal may also be replaced by a terminal device such as a mobile terminal.

[0136] Optionally, in this embodiment, the computer terminal may be located in at least one network device among a plurality of network devices of the computer network.

[0137] In this embodiment, the above-mentioned computer terminal can execute the program code of the following steps in the telesignaling data comparison method of the substation: obtaining the message file of the substation at a preset time node, wherein the message file at least includes: the backup telesignaling message of at least one backup channel of the substation; analyzing the backup telesignaling message of any backup channel to obtain the backup matter table of the backup channel, wherein the backup telesignaling message includes: backup telesignaling data for determining multiple backup telesignaling matters, and the backup matter table uses multiple first attribute items to describe each backup telesignaling matter; obtaining the historical matter table of the substation, wherein the historical matter table uses multiple second attribute items to describe multiple main telesignaling matters of the main channel of the substation, and the second attribute items correspond one to one with the first attribute items; comparing each main telesignaling matter in the historical matter table with each backup telesignaling matter in the backup matter table one by one to obtain a comparison result, wherein, when any second attribute item of the main telesignaling matter is inconsistent with the corresponding first attribute item in the backup telesignaling matter, the comparison result indicates that the main telesignaling matter is inconsistent with the backup telesignaling matter.

[0138] Figure 3 is a structural block diagram of a computer terminal according to an embodiment of the present invention. Figure 3 As shown, the computer terminal 30 may include: one or more (only one is shown in the figure) processors 32 , and a memory 34 .

[0139] Among them, the memory can be used to store software programs and modules, such as the program instructions / modules corresponding to the remote signaling data comparison method and device of the substation in the embodiment of the present invention. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory, that is, the remote signaling data comparison method of the substation mentioned above is realized. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory may further include a memory remotely arranged relative to the processor, and these remote memories can be connected to the terminal 30 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0140] The processor can call the information and application programs stored in the memory through the transmission device to perform the following steps: obtain the message file of the substation at a preset time node, wherein the message file at least includes: the backup telesignal message of at least one backup channel of the substation; analyze the backup telesignal message of any backup channel to obtain the backup matter table of the backup channel, wherein the backup telesignal message includes: backup telesignal data for determining multiple backup telesignal matters, and the backup matter table uses multiple first attribute items to describe each backup telesignal matter; obtain the historical matter table of the substation, wherein the historical matter table uses multiple second attribute items to describe multiple main telesignal matters of the main channel of the substation, and the second attribute items correspond one to one with the first attribute items; compare each main telesignal matter in the historical matter table with each backup telesignal matter in the backup matter table one by one to obtain a comparison result, wherein, when any second attribute item of the main telesignal matter is inconsistent with the corresponding first attribute item in the backup telesignal matter, the comparison result indicates that the main telesignal matter is inconsistent with the backup telesignal matter.

[0141] Optionally, the processor may also execute the program code of the following steps: selecting any one of the at least one backup channel as the channel to be compared, wherein the backup telesignaling message of the channel to be compared is the telesignaling message to be compared; selecting at least one backup telesignaling data that meets the target type identifier from multiple message data of the telesignaling message to be compared, wherein each message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the backup telesignaling data; analyzing each backup telesignaling data to obtain a backup telesignaling matter described using multiple first attribute items, wherein the backup telesignaling matter includes backup attribute parameters corresponding to each first attribute item respectively; filling multiple backup attribute parameters of at least one backup telesignaling data into the preset matter table respectively to obtain the backup matter table, wherein the preset matter table is pre-set with multiple first attribute items, and multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset matter table.

[0142] Optionally, the processor may also execute the program code of the following steps: detecting whether the standby telesignaling data is the standby telesignaling position change data; in the case that the standby telesignaling data is the standby telesignaling position change data, determining that a plurality of first attribute items at least include: the telesignaling collection point, the point value and the time when the master station receives the telesignaling position change; identifying the standby attribute parameters corresponding to each first attribute item from the standby telesignaling position change data; determining a plurality of standby attribute parameters in the same standby telesignaling position change data as standby telesignaling position change matters, wherein the standby telesignaling position change matters are standby telesignaling matters.

[0143] Optionally, the processor may also execute the program code of the following steps: detecting whether the backup telesignaling data is backup event sequence record data; in the case that the backup telesignaling data is backup event sequence record data, determining multiple first attribute items including at least: telesignaling collection point, point value and event sequence record time stamp; identifying the backup attribute parameters corresponding to each first attribute item from the backup event sequence record data; determining multiple backup attribute parameters in the same backup event sequence record data as the same backup event sequence record item, wherein the backup event sequence record item is a backup telesignaling item.

[0144] Optionally, the first attribute item also includes: a telesignaling collection point and a telesignaling description, wherein the backup attribute parameter corresponding to the telesignaling description is the telesignaling description data, and the telesignaling description data cannot be obtained by analyzing the backup telesignaling data. The above-mentioned processor can also execute the program code of the following steps: filling in multiple backup attribute parameters of at least one backup telesignaling data into the preset matter table respectively to obtain a pre-processing matter table, wherein the pre-processing matter table includes multiple pre-processing matters, and the multiple backup attribute parameters of each pre-processing matter include at least: the telesignaling point number corresponding to the telesignaling collection point; among the multiple preset attribute parameters recorded in the preset telesignaling point table, querying the preset attribute parameters corresponding to each telesignaling point number as the telesignaling description data, wherein the preset telesignaling point table record is used to use the telesignaling collection point and the telesignaling description to describe the correspondence between the collection point and the preset attribute parameters; in the pre-processing matter table, filling the telesignaling description data into the pre-processing matters of the same telesignaling point number to obtain the backup matter table.

[0145] Optionally, the historical event table includes at least one of the following: a historical telesignaling change event table, and a historical event sequence record event table. The above-mentioned processor can also execute the program code of the following steps: obtaining the historical telesignaling change event table of the substation, wherein the multiple second attribute items used in the historical telesignaling change event table include at least: telesignaling description, point value and the time when the master station receives the telesignaling change; obtaining the historical event sequence record event table of the substation, wherein the multiple second attribute items used in the historical event sequence record event table include at least: telesignaling description, point value and event sequence record time stamp.

[0146] Optionally, the processor may also execute the following steps of program code: selecting any one of the main telesignaling items in the historical items table as the main telesignaling item to be compared; traversing the multiple backup telesignaling items recorded in the backup items table and corresponding to the main telesignaling item to be compared as the comparison backup telesignaling items; obtaining the main attribute parameter corresponding to each second attribute item in the main telesignaling item to be compared, and obtaining the backup attribute parameter corresponding to each first attribute item in the comparison backup telesignaling item; comparing each main attribute parameter with the backup attribute parameter based on the correspondence between the first attribute item and the second attribute item, and generating a comparison result, wherein, when any one of the main attribute parameter and the backup attribute parameter is inconsistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are inconsistent, and when the main attribute parameter and the backup attribute parameter are consistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are consistent.

[0147] It can be understood by those skilled in the art that Figure 3 The structure shown is for illustration only, and the computer terminal may also be a smart phone (such as an Android phone, an iOS phone, etc.), a tablet computer, a handheld computer, a mobile Internet device (Mobile Internet Devices, MID), a PAD, or other terminal devices. Figure 3 The structure of the electronic device is not limited. For example, the computer terminal 30 may also include Figure 3 More or fewer components (such as network interfaces, display devices, etc.) shown in, or having Figure 3 Different configurations are shown.

[0148] A person of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing the hardware related to the terminal device through a computer program. The computer program can be stored in a non-volatile medium. The non-volatile storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.

[0149] The embodiment of the present invention further provides a non-volatile storage medium. Optionally, in this embodiment, the non-volatile storage medium can be used to store the program code executed by the substation telesignaling data comparison method provided in the above embodiment.

[0150] Optionally, in this embodiment, the non-volatile storage medium may be located in any computer terminal in a computer terminal group in a computer network, or in any mobile terminal in a mobile terminal group.

[0151] Optionally, in this embodiment, the non-volatile storage medium is configured to store program code for executing the following steps: obtaining a message file of the substation at a preset time node, wherein the message file includes at least: a backup telesignaling message of at least one backup channel of the substation; analyzing the backup telesignaling message of any backup channel to obtain a backup matter table of the backup channel, wherein the backup telesignaling message includes: backup telesignaling data for determining multiple backup telesignaling matters, and the backup matter table uses multiple first attribute items to describe each backup telesignaling matter; obtaining a historical matter table of the substation, wherein the historical matter table uses multiple second attribute items to describe multiple main telesignaling matters of the main channel of the substation, and the second attribute items correspond one-to-one to the first attribute items; comparing each main telesignaling matter in the historical matter table with each backup telesignaling matter in the backup matter table one by one to obtain a comparison result, wherein, when any second attribute item of the main telesignaling matter is inconsistent with the corresponding first attribute item in the backup telesignaling matter, the comparison result indicates that the main telesignaling matter is inconsistent with the backup telesignaling matter.

[0152] Optionally, in this embodiment, the non-volatile storage medium is configured to store program codes for executing the following steps: selecting any one of the at least one backup channel as the channel to be compared, wherein the backup telesignaling message of the channel to be compared is the telesignaling message to be compared; selecting at least one backup telesignaling data that meets the target type identifier from multiple message data of the telesignaling message to be compared, wherein each message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the backup telesignaling data; analyzing each backup telesignaling data to obtain a backup telesignaling matter described using multiple first attribute items, wherein the backup telesignaling matter includes backup attribute parameters corresponding to each first attribute item respectively; filling multiple backup attribute parameters of at least one backup telesignaling data into the preset matter table respectively to obtain the backup matter table, wherein the preset matter table is pre-set with multiple first attribute items, and multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset matter table.

[0153] Optionally, in this embodiment, the non-volatile storage medium is configured to store program codes for executing the following steps: detecting whether the standby telesignaling data is the standby telesignaling change data; in the case where the standby telesignaling data is the standby telesignaling change data, determining that a plurality of first attribute items at least include: the telesignaling collection point, the point value and the time when the master station receives the telesignaling change; identifying the standby attribute parameters corresponding to each first attribute item from the standby telesignaling change data; determining a plurality of standby attribute parameters in the same standby telesignaling change data as standby telesignaling change matters, wherein the standby telesignaling change matters are standby telesignaling matters.

[0154] Optionally, in this embodiment, the non-volatile storage medium is configured to store program code for executing the following steps: detecting whether the backup telesignaling data is backup event sequence record data; in the case where the backup telesignaling data is backup event sequence record data, determining multiple first attribute items at least including: telesignaling collection point, point value and event sequence record time stamp; identifying the backup attribute parameters corresponding to each first attribute item from the backup event sequence record data; determining multiple backup attribute parameters in the same backup event sequence record data as the same backup event sequence record item, wherein the backup event sequence record item is a backup telesignaling item.

[0155] Optionally, in this embodiment, the first attribute item also includes: a telesignaling collection point and a telesignaling description, wherein the backup attribute parameter corresponding to the telesignaling description is the telesignaling description data, and the telesignaling description data cannot be obtained by analyzing the backup telesignaling data, and the non-volatile storage medium is configured to store a program code for executing the following steps: filling in multiple backup attribute parameters of at least one backup telesignaling data into a preset matter table respectively to obtain a pre-processing matter table, wherein the pre-processing matter table includes multiple pre-processing matters, and the multiple backup attribute parameters of each pre-processing matter include at least: a telesignaling point number corresponding to the telesignaling collection point; among the multiple preset attribute parameters recorded in the preset telesignaling point table, querying the preset attribute parameters corresponding to each telesignaling point number as the telesignaling description data, wherein the preset telesignaling point table record is used to use the telesignaling collection point and the telesignaling description to describe the correspondence between the collection point and the preset attribute parameters; in the pre-processing matter table, filling the telesignaling description data into the pre-processing matters of the same telesignaling point number to obtain the backup matter table.

[0156] Optionally, in this embodiment, the historical event table includes at least one of the following: a historical telesignaling change event table, and a historical event sequence record event table, and the non-volatile storage medium is configured to store program code for executing the following steps: obtaining a historical telesignaling change event table of the substation, wherein the multiple second attribute items used in the historical telesignaling change event table include at least: a telesignaling description, a point value, and a time when the master station receives the telesignaling change; obtaining a historical event sequence record event table of the substation, wherein the multiple second attribute items used in the historical event sequence record event table include at least: a telesignaling description, a point value, and an event sequence record timestamp.

[0157] Optionally, in this embodiment, the non-volatile storage medium is configured to store program codes for executing the following steps: selecting any one main telesignaling item in the historical item table as the main telesignaling item to be compared; traversing the backup telesignaling items corresponding to the main telesignaling item to be compared among the multiple backup telesignaling items recorded in the backup item table as the comparison backup telesignaling items; obtaining the main attribute parameter corresponding to each second attribute item in the main telesignaling item to be compared, and obtaining the backup attribute parameter corresponding to each first attribute item in the comparison backup telesignaling item; comparing each main attribute parameter with the backup attribute parameter based on the correspondence between the first attribute item and the second attribute item, and generating a comparison result, wherein, when any one of the main attribute parameters is inconsistent with the backup attribute parameter, the comparison result indicates that the main telesignaling item and the backup telesignaling item are inconsistent, and when the main attribute parameter and the backup attribute parameter are consistent, the comparison result indicates that the main telesignaling item and the backup telesignaling item are consistent.

[0158] The embodiment of the present invention further provides a computer program product, including a computer program. Optionally, in this embodiment, when the computer program is executed by a processor, the steps of the substation telesignaling data comparison method provided in the above embodiment are implemented.

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

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

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

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

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

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

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

Claims

1. A remote signaling data comparison method for a substation, characterized in that: include: Acquire a message file of the substation at a preset time node, wherein the message file at least includes: a standby telesignal message of at least one standby channel of the substation; Analyze the standby telesignaling message of any one of the standby channels to obtain a standby event table of the standby channel, wherein the standby telesignaling message includes: standby telesignaling data for determining a plurality of standby telesignaling events, and the standby event table uses a plurality of first attribute items to describe each of the standby telesignaling events; Acquire a historical event table of the substation, wherein the historical event table uses a plurality of second attribute items to describe a plurality of main remote signaling events of a main channel of the substation, and the second attribute items correspond one-to-one to the first attribute items; Each of the main telesignaling items in the historical items table is compared one by one with each of the backup telesignaling items in the backup items table to obtain a comparison result, wherein, when any of the second attribute items of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item.

2. The method according to claim 1, characterized in that Analyzing the standby telesignal message of any standby channel to obtain the standby event table of the standby channel includes: From at least one of the standby channels, select any one of the standby channels as the channel to be compared, wherein the standby telesignaling message of the channel to be compared is the telesignaling message to be compared; Selecting at least one piece of standby telesignaling data that meets the target type identifier from the plurality of pieces of message data of the telesignaling message to be compared, wherein each piece of the message data is pre-configured with a corresponding preset type identifier, and the target type identifier is used to indicate the message data belonging to the standby telesignaling data; Analyze each piece of the backup remote signaling data to obtain the backup remote signaling items described by using a plurality of the first attribute items, wherein the backup remote signaling items include backup attribute parameters corresponding to each of the first attribute items; Fill the multiple backup attribute parameters of at least one of the backup telesignaling data into the preset event table respectively to obtain the backup event table, wherein the preset event table is pre-set with multiple first attribute items, and the multiple backup attribute parameters of the same backup telesignaling data are filled in the same row of the preset event table.

3. The method according to claim 2, characterized in that Each piece of the backup remote signaling data is analyzed to obtain the backup remote signaling items described by using a plurality of the first attribute items, including: Detecting whether the standby remote signaling data is standby remote signaling displacement data; In the case where the standby telesignaling data is the standby telesignaling position change data, determining the plurality of the first attribute items at least includes: a telesignaling collection point, a point value and a time when the master station receives the telesignaling position change; From the standby remote signal change data, identifying the standby attribute parameters corresponding to each of the first attribute items; The plurality of the backup attribute parameters in the same backup telesignaling change data are determined as the backup telesignaling change items, wherein the backup telesignaling change items are the backup telesignaling items.

4. The method according to claim 2, characterized in that: Each piece of the backup remote signaling data is analyzed to obtain the backup remote signaling items described by using a plurality of the first attribute items, including: Detecting whether the standby telesignaling data is standby event sequence record data; In the case where the standby telesignaling data is the standby event sequence record data, determining the plurality of the first attribute items at least includes: telesignaling collection points, point values ​​and event sequence record time stamps; identifying the standby attribute parameters corresponding to each of the first attribute items from the standby event sequence record data; The plurality of backup attribute parameters in the same backup event sequence record data are determined as the same backup event sequence record item, wherein the backup event sequence record item is the backup telesignaling item.

5. The method according to claim 2, characterized in that: The first attribute item also includes: a remote signal collection point and a remote signal description, wherein the backup attribute parameter corresponding to the remote signal description is remote signal description data, and the remote signal description data cannot be obtained by analyzing the backup remote signal data; multiple backup attribute parameters of at least one backup remote signal data are respectively filled into a preset event table, and the backup event table includes: Filling the plurality of the backup attribute parameters of at least one piece of the backup telesignaling data into the preset event table respectively to obtain a pre-processing event table, wherein the pre-processing event table includes a plurality of pre-processing events, and the plurality of the backup attribute parameters of each pre-processing event at least include: the telesignaling point number corresponding to the telesignaling collection point; Among the multiple preset attribute parameters recorded in the preset telesignaling point table, query the preset attribute parameter corresponding to each telesignaling point number as the telesignaling description data, wherein the preset telesignaling point table record is used to describe the corresponding relationship between the collection point and the preset attribute parameter using the telesignaling collection point and the telesignaling description; In the pre-processing items table, the telesignaling description data is filled into the pre-processing items of the same telesignaling point number to obtain the standby items table.

6. The method according to claim 1, characterized in that The historical event table includes at least one of the following: a historical remote signal change event table, and a historical event sequence record event table; obtaining the historical event table of the substation includes: Acquire the historical telesignaling change event table of the substation, wherein the plurality of second attribute items used in the historical telesignaling change event table at least include: telesignaling description, point value and telesignaling change time received by the master station; The historical event sequence record item table of the substation is obtained, wherein the historical event sequence record item table uses a plurality of the second attribute items including at least: remote signal description, point value and event sequence record time stamp.

7. The method according to claim 1, characterized in that Each of the main remote signaling items in the historical items table is compared with each of the backup remote signaling items in the backup items table one by one, and the comparison results include: Select any one of the main remote signaling events in the historical event table as the main remote signaling event to be compared; Among the plurality of the backup telesignaling items recorded in the backup item table, traverse the backup telesignaling items corresponding to the main telesignaling items to be compared as comparison backup telesignaling items; Obtaining a main attribute parameter corresponding to each of the second attribute items in the main remote signaling item to be compared, and obtaining a backup attribute parameter corresponding to each of the first attribute items in the backup remote signaling item to be compared; According to the correspondence between the first attribute item and the second attribute item, each of the main attribute parameters is compared to see whether it is consistent with the backup attribute parameter, and the comparison result is generated, wherein, when any one of the main attribute parameters is inconsistent with the backup attribute parameter, the comparison result indicates that the main remote signaling matter is inconsistent with the backup remote signaling matter, and when the main attribute parameter is consistent with the backup attribute parameter, the comparison result indicates that the main remote signaling matter is consistent with the backup remote signaling matter.

8. A remote signaling data comparison device for a substation, characterized in that: include: A first acquisition module is used to acquire a message file of the substation at a preset time node, wherein the message file at least includes: a standby telesignal message of at least one standby channel of the substation; An analysis module, used for analyzing the standby telesignaling message of any standby channel to obtain a standby event table of the standby channel, wherein the standby telesignaling message includes: standby telesignaling data for determining a plurality of standby telesignaling events, and the standby event table uses a plurality of first attribute items to describe each of the standby telesignaling events; A second acquisition module is used to acquire a historical event table of the substation, wherein the historical event table uses a plurality of second attribute items to describe a plurality of main remote signaling events of a main channel of the substation, and the second attribute items correspond one-to-one to the first attribute items; A comparison module is used to compare each of the main telesignaling items in the historical event table with each of the backup telesignaling items in the backup event table one by one to obtain a comparison result, wherein, when any of the second attribute items of the main telesignaling item is inconsistent with the corresponding first attribute item in the backup telesignaling item, the comparison result indicates that the main telesignaling item is inconsistent with the backup telesignaling item.

9. An electronic device, comprising a memory and a processor, characterized in that: The memory stores a computer program, and the processor is configured to execute the remote signaling data comparison method for a substation according to any one of claims 1 to 7 through the computer program.

10. A computer program product comprising computer instructions, characterized in that: When the computer instructions are executed by the processor, the steps of the remote signaling data comparison method for a substation described in any one of claims 1 to 7 are implemented.

Images