A method and system for visually locating substation file differences based on big data

Abstract

The present invention relates to the field of data processing technology, and in particular to a method and system for visually locating substation file differences based on big data. The method includes: comparing SCD files before and after upgrading, obtaining the newly added intervals and missing intervals and unadded and deleted intervals corresponding to the upgraded SCD files; obtaining the affected intervals; obtaining the IED nodes whose CRC codes have been changed; for the IED nodes whose CRC codes have been changed, screening out the changed joint control type virtual terminals and the changed self-status alarm type virtual terminals; and then obtaining the affected IED nodes; taking the IED nodes in the set consisting of the affected IED nodes and the IED nodes whose CRC codes have been changed as the IED nodes to be compared, and obtaining the ICD files of the IED nodes to be compared; detecting the difference between the IED content of the ICD file corresponding to the IED node to be compared and the IED content of the corresponding upgraded SCD file, and displaying the comparison results. The method of the present invention can greatly improve the detection efficiency of the differences between different substation files.

Description

Technical Field

[0001] The present invention generally relates to the field of data processing technology. More specifically, the present invention relates to a method and system for visually locating substation file differences based on big data. Background Art

[0002] Smart substation is a new type of substation that uses modern electronic technology, communication technology, computer technology and automatic control technology to upgrade traditional substations. It aims to improve the safe, reliable, economical and efficient operation of the power system. In today's society, with the development of science and technology, traditional substations are gradually being replaced by smart substations. In smart substations, IED devices play a vital role, and their main functions include: data acquisition, status monitoring, protection control, remote control, communication function, fault diagnosis, event recording, etc. Smart substations usually use substation files to store and display the configuration information of all IED devices in the substation. Due to the expansion and reconstruction of the substation or the upgrading of IED equipment, the content of the substation file will change. In order to ensure the stable operation of the smart substation, it is very important to detect the differences between different substation files. The existing substation file difference detection method usually requires the IED content corresponding to all IED nodes in the substation file, resulting in low efficiency in detecting differences between substation files. Summary of the invention

[0003] In order to solve the technical problem that the existing substation file difference detection method has low efficiency when detecting the difference between different substation files, the present invention provides solutions in the following aspects.

[0004] In a first aspect, the present invention provides a method for visually locating substation file differences based on big data, comprising:

[0005] Compare the SCD files before and after the upgrade to obtain the newly added intervals and the missing intervals and the unadded and undeleted intervals corresponding to the upgraded SCD file; obtain the intervals electrically associated with the newly added intervals and the missing intervals, and record them as affected intervals;

[0006] According to the SCD files before and after the upgrade, the IED nodes that have not been added or deleted in the interval that has not been added or deleted and the interval that has been affected are obtained, and the CRC codes of the IED nodes that have not been added or deleted are compared, so as to obtain the IED nodes whose CRC codes have been changed;

[0007] For the IED nodes whose CRC codes are changed, the changed joint control virtual terminals and the changed self-status alarm virtual terminals are screened out according to the SCD files before and after the upgrade; and then the affected IED nodes are obtained according to the two types of virtual terminals;

[0008] Taking the IED nodes in the set consisting of the affected IED nodes and the IED nodes whose CRC codes are changed as the IED nodes to be compared, and obtaining the ICD files of the IED nodes to be compared;

[0009] Detect the difference between the IED content of the ICD file corresponding to the IED node to be compared and the IED content of the corresponding upgraded SCD file, and display the comparison result.

[0010] Preferably, the acquisition of affected IED nodes includes: for a changed joint management type virtual terminal, acquiring an IED node associated with it, and recording it as a first type of affected IED node; for a changed self-status alarm type virtual terminal, acquiring an IED node on its sending side, and recording it as a second type of affected IED node, and taking the IED nodes in the set consisting of the first type of affected IED nodes and the second type of affected IED nodes as affected IED nodes.

[0011] Preferably, obtaining the non-added or deleted IED nodes in the non-added or deleted interval and the affected interval comprises:

[0012] Compare the IED nodes in the unadded and deleted intervals in the SCD file before the upgrade with the IED nodes in the unadded and deleted intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the unadded and deleted intervals; compare the IED nodes in the affected intervals in the SCD file before the upgrade with the IED nodes in the affected intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the affected intervals;

[0013] The IED nodes that have not been added or deleted are obtained according to the IED node addition or deletion information corresponding to the interval that has not been added or deleted and the IED node addition or deletion information corresponding to the affected interval.

[0014] Preferably, detecting the difference between the IED content of the ICD file corresponding to the IED node to be compared and the IED content of the corresponding upgraded SCD file comprises:

[0015] Parse the descendant contents of each level of the IED node to be compared on the ICD side and store them in the first linked list; parse the descendant contents of each level of the IED node to be compared on the SCD side and store them in the second linked list; starting from the head end of the linked list, compare the label names and key attribute values ​​of the descendant nodes of the same level in the first linked list and the second linked list level by level, and compare the lengths of the first linked list and the second linked list;

[0016] In response to the fact that the first linked list and the second linked list have the same length and that there are both sibling descendant nodes with different label names and key attribute values ​​and sibling descendant nodes with the same label name and key attribute values ​​in the first linked list and the second linked list, the sibling descendant nodes with different label names and key attribute values ​​are marked and displayed.

[0017] Preferably, it also includes: in response to the first linked list and the second linked list having the same length and there being no descendant nodes of the same level with the same tag name and key attribute value in the first linked list and the second linked list, marking the descendant nodes at all levels in the second linked list as "newly added", marking the descendant nodes at all levels in the first linked list as "deleted", and displaying the descendant nodes at all levels in the first linked list and the second linked list on the interface.

[0018] Preferably, the method further comprises: in response to the length of the first linked list being less than the length of the second linked list and there not being any descendant node of the same level with different tag names and key attribute values ​​in the first linked list and the second linked list, searching the second linked list for any descendant node with the same tag name and key attribute value as the head node of the first linked list;

[0019] In response to the presence of a descendant node in the second linked list having the same tag name and key attribute value as the head node of the first linked list, the descendant node in the second linked list is recorded as the first node, and the tag names and key attribute values ​​of the descendant nodes of the same level as the head node of the first linked list are compared level by level to see whether the first node and the head node of the first linked list have the same tag name and key attribute value;

[0020] In response, the tag names and key attribute values ​​of the descendant nodes of the same level as the first node and the head node of the first linked list are the same, and the nodes before the first node in the second linked list are marked and displayed.

[0021] Preferably, it also includes: in response to the length of the first linked list being less than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, the number N of descendant nodes in the first linked list is obtained, and the descendant nodes from the N+1th level in the second linked list to the last level in the second linked list are marked as "newly added", and displayed on the display interface.

[0022] Preferably, the method further comprises: in response to the length of the first linked list being greater than the length of the second linked list and there not being any descendant node of the same level with the same tag name and key attribute value in the first linked list and the second linked list, searching the first linked list for any descendant node with the same tag name and key attribute value as the head node of the second linked list;

[0023] In response to the presence of a descendant node in the first linked list having the same tag name and key attribute value as the head node of the second linked list, the descendant node in the first linked list is recorded as a second node, and the tag names and key attribute values ​​of the second node and the same-level descendant nodes of the head node of the second linked list are compared level by level to see whether they are the same;

[0024] In response, the label names and key attribute values ​​of the descendant nodes at all levels of the second node and the head node of the second linked list are the same, and the nodes before the second node in the first linked list are marked and displayed.

[0025] Preferably, it also includes: in response to the length of the first linked list being greater than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, then obtaining the descendant node level M in the second linked list, marking the descendant nodes from the M+1th level in the first linked list to the last level in the first linked list as "deleted", and displaying them on the display interface.

[0026] In a second aspect, the present invention provides a substation file difference visualization positioning system based on big data, comprising a memory and a processor, wherein the memory stores computer program instructions, and when the computer program instructions are executed by the processor, the substation file difference visualization positioning method based on big data of the present invention is implemented.

[0027] The technical effect of the present invention is as follows: the traditional substation file difference detection method is to detect the difference between the IED content of the corresponding ICD file and the corresponding IED content in the SCD file for each IED device in the smart substation, and visualize it. The substation file difference visualization positioning method based on big data of the present application first determines the changed joint control type virtual terminals and the changed self-status alarm type virtual terminals in all IED nodes with changed CRC codes when performing file difference detection, and then determines the IED nodes whose IED content may change after the SCD file is upgraded. When detecting the difference between different substation files, only the IED nodes whose IED content may change after the SCD file is upgraded are detected, thereby greatly improving the detection efficiency of the difference between different substation files on the basis of avoiding missed detection.

[0028] Furthermore, when detecting the difference between the content of the ICD file corresponding to the IED node to be compared and the content of the corresponding SCD file, the parsed contents on the ICD side and the SCD side are stored in the form of a linked list, thereby facilitating a step-by-step comparison of the differences between the descendant nodes on the ICD side and the SCD side; during the comparison, only the label names and key attribute values ​​of the descendant nodes are compared, thereby greatly improving the efficiency of the comparison, and the differences between the descendant nodes on the ICD side and the descendant nodes on the SCD side of the IED node to be compared can be quickly located. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] By reading the following detailed description with reference to the accompanying drawings, the above and other objects, features and advantages of the exemplary embodiments of the present invention will become readily understood. In the accompanying drawings, several embodiments of the present invention are shown in an exemplary and non-limiting manner, and the same or corresponding reference numerals represent the same or corresponding parts, wherein:

[0030] Figure 1 The present invention schematically illustrates the process of visually locating substation file differences based on big data according to an embodiment of the present invention. Figure 1 ;

[0031] Figure 2 is a flow chart schematically illustrating a method for comparing an ICD file and an SCD file according to an embodiment of the present invention;

[0032] Figure 3 is a schematic diagram schematically showing a first linked list structure of an embodiment of the present invention;

[0033] Figure 4 It is a schematic diagram showing the structure of a substation file difference visualization positioning system based on big data according to an embodiment of the present invention. DETAILED DESCRIPTION

[0034] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are 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 those skilled in the art without creative work are within the scope of protection of the present invention.

[0035] The specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0036] Embodiment of a method for visually locating substation file differences based on big data:

[0037] like Figure 1 As shown, the substation file difference visualization positioning method based on big data of the present invention includes:

[0038] S101 . Compare the SCD files before and after the upgrade to obtain the newly added intervals, the missing intervals, and the unadded and undeleted intervals corresponding to the upgraded SCD file.

[0039] S102: Obtain an interval electrically associated with the newly added interval and the missing interval, and record it as an affected interval.

[0040] S103, obtaining the IED nodes with changed CRC codes, specifically: obtaining the unadded or deleted IED nodes in the unadded or deleted interval and the affected interval according to the SCD files before and after the upgrade, and comparing the CRC codes of the unadded or deleted IED nodes to obtain the IED nodes with changed CRC codes.

[0041] The IED nodes in the affected interval in the SCD files before and after the upgrade are compared to extract the addition and deletion information of the IED nodes and obtain the IED nodes that have not been added or deleted. The CRC codes of the IED nodes that have not been added or deleted in the SCD files before and after the upgrade are compared to obtain the IED nodes whose CRC codes have been changed.

[0042] Normally, in a smart substation, if the CRC corresponding to an IED node changes, it means that the IED node has changed. Therefore, by comparing the CRC code of the same IED node in the SCD file before and after the upgrade, it is possible to quickly determine whether the IED node has changed. There are usually the following situations when an IED node changes: 1. The configuration parameters of the IED node are updated or modified. 2. Hardware replacement: The original IED device is replaced with a new device due to failure, aging or technical upgrade. 3. Software upgrade: In order to fix known problems and improve the performance of the IED device, the software of the IED node is upgraded or updated. 4. Network structure adjustment: The IP address, communication port or connection relationship of the IED device in the network topology has changed. 5. Function adjustment: The function of the IED node has been redefined or adjusted, such as modifying the protection setting, control logic or monitoring parameters. After the IED node is changed, its various virtual terminals may change, such as adding or deleting virtual terminals, replacing virtual terminals, etc.

[0043] S104, screening relevant virtual terminals, specifically: for the IED nodes whose CRC codes are changed, screening out the changed joint control type virtual terminals and the changed own status alarm type virtual terminals according to the SCD files before and after the upgrade; and then obtaining the affected IED nodes according to the two types of virtual terminals.

[0044] In a smart substation, changes to the joint control virtual terminals of an IED device will affect the associated IEDs, while changes to the self-status alarm virtual terminals will only affect the IED devices on the sending side, and changes to other types of virtual terminals of an IED device usually do not affect other IED devices. Therefore, all affected IED devices due to the upgrade of the SCD file can be determined based on the changed joint control virtual terminals and the changed self-status alarm virtual terminals.

[0045] S105, screening out IED nodes to be compared, specifically: taking IED nodes in a set consisting of the affected IED nodes and the IED nodes whose CRC codes are changed as IED nodes to be compared, and obtaining ICD files of the IED nodes to be compared.

[0046] The IED nodes associated with the changed joint control type virtual terminals and the IED nodes associated with the changed self-status alarm type virtual terminals are both IED nodes affected by the SCD file upgrade, and their corresponding SCD file contents may change after the SCD file upgrade. Since the set composed of the affected IED nodes and the set composed of the IED nodes with changed CRC codes have overlapping parts, the IED nodes in the set composed of the affected IED nodes and the IED nodes with changed CRC codes are used as the IED nodes to be compared, so as to screen out all IED nodes whose IED contents may change after the SCD file upgrade on the basis of avoiding repeated comparisons.

[0047] S106 , performing comparison and displaying the results, specifically: for the IED node to be compared, comparing the difference between the IED content of its corresponding ICD file and the IED content of the IED node to be compared in the upgraded SCD file, and displaying the comparison result.

[0048] The SCD file includes instance configuration information of all IED nodes in the smart substation, and the IED content of the IED node to be compared in the upgraded SCD file refers to the instance configuration information of the IED node to be compared in the upgraded SCD file.

[0049] The traditional substation file difference detection method is to detect the differences between the IED content of the corresponding ICD file and the corresponding IED content in the SCD file for each IED device in the smart substation, and visualize them. The substation file difference visualization positioning method based on big data in the present application first determines the changed joint control type virtual terminals and the changed self-status alarm type virtual terminals in all IED nodes with changed CRC codes when performing file difference detection, and then determines the IED nodes whose IED content may change after the SCD file is upgraded. When detecting the differences between different substation files, only the IED nodes whose IED content may change after the SCD file is upgraded are detected, thereby greatly improving the detection efficiency of the differences between different substation files on the basis of avoiding missed detection.

[0050] In one embodiment, obtaining the non-added or deleted IED nodes in the non-added or deleted interval and the affected interval includes:

[0051] S601, compare the IED nodes in the unadded and deleted intervals in the SCD file before the upgrade with the IED nodes in the unadded and deleted intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the unadded and deleted intervals; compare the IED nodes in the affected intervals in the SCD file before the upgrade with the IED nodes in the affected intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the affected intervals;

[0052] S602: Acquire the IED nodes that have not been added or deleted according to the IED node addition or deletion information corresponding to the interval that has not been added or deleted and the IED node addition or deletion information corresponding to the affected interval.

[0053] In one embodiment, obtaining the affected IED node includes:

[0054] For the changed joint control type virtual terminal, the IED node associated with it is obtained and recorded as the first type of affected IED node; for the changed self-status alarm type virtual terminal, the IED node on its sending side is obtained and recorded as the second type of affected IED node, and the IED nodes in the set consisting of the first type of affected IED nodes and the second type of affected IED nodes are taken as affected IED nodes.

[0055] In one embodiment, for a certain IED node to be compared, comparing the difference between the IED content of the corresponding ICD file and the IED content of the IED node to be compared in the upgraded SCD file includes:

[0056] S201, parse the substation file and obtain the first linked list and the second linked list, specifically: parse the descendants of the IED node to be compared on the ICD side, and store them in the first linked list; parse the descendants of the IED node to be compared on the SCD side, and store them in the second linked list; the direction of the linked list from the head end to the end is the direction of increasing descendant node levels.

[0057] Assuming that the IED node to be compared on the ICD side has 5 levels of descendant nodes, each level of descendant nodes has only one node, and the levels from low to high are A node, B node, C node, D node, and E node, then the schematic diagram of the first linked list structure generated is as follows: Figure 3 shown.

[0058] S202, comparing the contents of the first linked list and the second linked list, specifically: starting from the head end of the linked list, comparing the label names and key attribute values ​​of the descendant nodes of the same level in the first linked list and the second linked list level by level, and comparing the lengths of the first linked list and the second linked list.

[0059] In this embodiment, the length of the linked list refers to the number of levels of descendant nodes included in the linked list. Assuming that there are 5 levels of descendant nodes in the linked list, the length of the linked list is 5. Comparing the label names and key attribute values ​​of the descendant nodes of the same level in the first linked list and the second linked list level by level means comparing the label names and key attribute values ​​of the descendant nodes of the same level in the two linked lists starting from the first level. For example, assuming that the first linked list and the second linked list both contain 5 levels, the first-level descendant nodes of the first linked list and the first-level descendant nodes of the second linked list, the second-level descendant nodes of the first linked list and the second-level descendant nodes of the second linked list, the third-level descendant nodes of the first linked list and the third-level descendant nodes of the second linked list, the fourth-level descendant nodes of the first linked list and the fourth-level descendant nodes of the second linked list, the fifth-level descendant nodes of the first linked list and the fifth-level descendant nodes of the second linked list are compared respectively.

[0060] S203, searching for the same-level descendant nodes whose label names and key attribute values ​​are different in the first linked list and the second linked list and displaying them, specifically: in response to the first linked list and the second linked list having the same length and there being both the same-level descendant nodes whose label names and key attribute values ​​are different and the same-level descendant nodes whose label names and key attribute values ​​are the same in the first linked list and the second linked list, marking and displaying the same-level descendant nodes whose label names and key attribute values ​​are different.

[0061] Descendant nodes in the first linked list and the second linked list that have different tag names and key attribute values ​​may be marked as "different" and displayed on the display interface.

[0062] When detecting the difference between the content of the ICD file corresponding to the IED node to be compared and the content of the corresponding SCD file, the method of this embodiment stores the parsed contents on the ICD side and the SCD side in the form of a linked list, thereby facilitating a step-by-step comparison of the differences between the descendant nodes on the ICD side and the SCD side; during the comparison, only the label names and key attribute values ​​of the descendant nodes are compared, thereby greatly improving the efficiency of the comparison, and being able to quickly locate the differences between the descendant nodes on the ICD side and the descendant nodes on the SCD side of the IED node to be compared.

[0063] In one embodiment, it also includes: in response to the first linked list and the second linked list having the same length and there being no descendant nodes of the same level with the same tag name and key attribute value in the first linked list and the second linked list, marking the descendant nodes at all levels in the second linked list as "newly added", marking the descendant nodes at all levels in the first linked list as "deleted", and displaying the descendant nodes at all levels in the first linked list and the second linked list on the interface.

[0064] If there are no descendant nodes of the same level with the same label name and key attribute value in the first linked list and the second linked list, it means that the descendant nodes at all levels of the IED node to be compared have been modified on the SCD side. Therefore, the descendant nodes at all levels in the second linked list can be marked as "newly added", and the descendant nodes at all levels in the first linked list can be marked as "deleted". The method of this embodiment can quickly detect the situation where the descendant nodes at all levels of the IED node have been modified and intuitively display the IED content before and after the modification.

[0065] In one embodiment, it further includes:

[0066] S301, in response to the length of the first linked list being less than the length of the second linked list and there being no descendant nodes of the same level with the same tag name and key attribute value in the first linked list and the second linked list, searching the second linked list for a descendant node with the same tag name and key attribute value as the head node of the first linked list.

[0067] S302. In response to the presence of a descendant node in the second linked list having the same tag name and key attribute value as the first-level descendant node of the first linked list, the descendant node in the second linked list is recorded as the first node, and the tag names and key attribute values ​​of the descendant nodes of the same level as the first node and the head node of the first linked list are compared level by level to see whether they are the same.

[0068] S303: In response to the fact that the tag names and key attribute values ​​of the descendant nodes of the same level as the first node and the head node of the first linked list are the same, the nodes before the first node in the second linked list are marked and displayed.

[0069] The nodes before the first node refer to nodes whose levels are smaller than the level corresponding to the first node.

[0070] The node before the first node in the second linked list may be marked as “newly added” and displayed on the display interface.

[0071] If the length of the first linked list is less than the length of the second linked list and the label names and key attribute values ​​of the first node and the first level descendant nodes of the first linked list are the same, it means that the modification made on the SCD side is to add several levels of parent nodes only before the first level descendant nodes on the ICD side. For example: the ICD side originally has three levels of descendant nodes, from the first level to the third level are node A, node B and node C, and the modification made on the SCD side is to add two levels of node A's parent nodes before node A, and the added nodes are E and F. Then the levels of the descendant nodes in the corresponding second linked list on the SCD side are node E, node F, node A, node B and node C from high to low.

[0072] The difference detection method between the IED content of the ICD file and the IED content in the upgraded SCD file of this embodiment can quickly detect the situation in which the node level is modified but the node level order remains unchanged and a parent node is added in the SCD file.

[0073] In one embodiment, it also includes: in response to the length of the first linked list being less than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, the number N of descendant nodes in the first linked list is obtained, and the descendant nodes from the N+1th level in the second linked list to the last level in the second linked list are marked as "newly added", and displayed on the display interface.

[0074] The length of the first linked list is smaller than that of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, indicating that the modification made in the SCD file is to add several levels of descendant nodes after the last level of descendant nodes. Therefore, the difference detection method between the IED content of the ICD file of this embodiment and the IED content in the upgraded SCD file can quickly detect the situation where several levels of descendant nodes are added after the last level of descendant nodes.

[0075] In one embodiment, it further includes:

[0076] S401, in response to the length of the first linked list being greater than the length of the second linked list and there being no descendant nodes of the same level with the same tag name and key attribute value in the first linked list and the second linked list, searching the first linked list for a descendant node with the same tag name and key attribute value as the head node of the second linked list.

[0077] S402. In response to the presence of a descendant node in the first linked list having the same tag name and key attribute value as the head node of the second linked list, the descendant node in the first linked list is recorded as a second node, and the tag names and key attribute values ​​of the descendant nodes of the same level as the head node of the second linked list are compared level by level to see whether they are the same.

[0078] S403: In response to the fact that the label names and key attribute values ​​of descendant nodes at all levels of the second node and the head node of the second linked list are the same, the nodes before the second node in the first linked list are marked and displayed.

[0079] The node before the second node in the first linked list may be marked as "deleted" and displayed on the display interface.

[0080] If the length of the first linked list is greater than that of the second linked list and the label names and key attribute values ​​of the descendant nodes at all levels of the second node and the first-level descendant nodes of the second linked list are the same, it means that the modification made on the SCD side is to delete the descendant nodes at all levels before the second node on the ICD side.

[0081] The difference detection method between the IED content of the ICD file and the IED content in the upgraded SCD file of this embodiment can quickly detect the situation in which the parent nodes of all levels before a certain level of descendant nodes on the ICD side are deleted in the SCD file.

[0082] The parent nodes at all levels before a certain level of descendant node refer to descendant nodes whose levels are smaller than the level of the descendant node. For example, for a second-level descendant node, the parent nodes at all levels before it refer to the first-level descendant nodes.

[0083] In one embodiment, it also includes: in response to the length of the first linked list being greater than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, the descendant node level M in the second linked list is obtained, and the descendant nodes from the M+1th level in the first linked list to the last level in the first linked list are marked as "deleted", and displayed on the display interface.

[0084] The length of the first linked list is greater than that of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the second linked list and the descendant nodes at the corresponding level in the first linked list are the same, indicating that the modification made in the SCD file is to delete the descendant nodes after a certain level of descendant nodes on the ICD side. Therefore, the difference detection method between the IED content of the ICD file of this embodiment and the IED content in the upgraded SCD file can quickly detect the deletion of the descendant nodes after a certain level of descendant nodes on the ICD side.

[0085] The descendant nodes of each level after a certain level of descendant node refer to the descendant nodes whose levels are greater than the level of the descendant node. For example, if there are three levels of descendant nodes, for the second level descendant node, the descendant nodes of each level thereafter refer to the third level descendant nodes.

[0086] Embodiment of the substation file difference visualization positioning system based on big data:

[0087] The present invention also provides a substation file difference visualization positioning system based on big data. Figure 4 As shown, the substation file difference visualization positioning system based on big data includes a processor and a memory, and the memory stores computer program instructions. When the computer program instructions are executed by the processor, the substation file difference visualization positioning method based on big data according to the first aspect of the present invention is implemented.

[0088] The big data-based substation file difference visualization positioning system also includes other components familiar to those skilled in the art, such as a communication bus and a communication interface, whose settings and functions are known in the art and will not be described in detail here.

[0089] In the present invention, the aforementioned memory may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, apparatus or device. For example, a computer-readable storage medium may be any suitable magnetic storage medium or magneto-optical storage medium, such as a resistive random access memory RRAM (Resistive Random Access Memory), a dynamic random access memory DRAM (Dynamic Random Access Memory), a static random access memory SRAM (Static Random-Access Memory), an enhanced dynamic random access memory EDRAM (Enhanced Dynamic Random Access Memory), a high-bandwidth memory HBM (High-Bandwidth Memory), a hybrid memory cube HMC (Hybrid Memory Cube), etc., or any other medium that may be used to store the required information and may be accessed by an application, a module, or both. Any such computer storage medium may be part of a device or accessible or connectable to a device. Any application or module described in the present invention may be implemented using computer-readable / executable instructions that may be stored or otherwise maintained by such a computer-readable medium.

[0090] In the description of this specification, "plurality" or "several" means at least two, such as two, three or more, etc., unless otherwise clearly and specifically defined.

[0091] Although this specification has shown and described a number of embodiments of the present invention, it will be apparent to those skilled in the art that such embodiments are provided by way of example only. Those skilled in the art will conceive of many modifications, changes and alternatives without departing from the ideas and spirit of the present invention. It should be understood that in the practice of the present invention, various alternatives to the embodiments of the present invention described herein may be employed.

Claims

1. A method for visually locating substation file differences based on big data, characterized in that: include: Compare the SCD files before and after the upgrade to obtain the newly added intervals and the missing intervals and the unadded and undeleted intervals corresponding to the upgraded SCD file; obtain the intervals electrically associated with the newly added intervals and the missing intervals, and record them as affected intervals; According to the SCD files before and after the upgrade, the IED nodes that have not been added or deleted in the interval that has not been added or deleted and the interval that has been affected are obtained, and the CRC codes of the IED nodes that have not been added or deleted are compared, so as to obtain the IED nodes whose CRC codes have been changed; For the IED nodes whose CRC codes are changed, the changed joint control virtual terminals and the changed self-status alarm virtual terminals are screened out according to the SCD files before and after the upgrade; and then the affected IED nodes are obtained according to the two types of virtual terminals; Taking the IED nodes in the set consisting of the affected IED nodes and the IED nodes whose CRC codes are changed as the IED nodes to be compared, and obtaining the ICD files of the IED nodes to be compared; Detect the difference between the IED content of the ICD file corresponding to the IED node to be compared and the IED content of the corresponding upgraded SCD file, and display the comparison result.

2. The method for visually locating substation file differences based on big data according to claim 1, characterized in that: The obtaining of the affected IED nodes comprises: For the changed joint control type virtual terminal, the IED node associated with it is obtained and recorded as the first type of affected IED node; for the changed self-status alarm type virtual terminal, the IED node on its sending side is obtained and recorded as the second type of affected IED node, and the IED nodes in the set consisting of the first type of affected IED nodes and the second type of affected IED nodes are taken as affected IED nodes.

3. The method for visually locating substation file differences based on big data as claimed in claim 1, characterized in that: Acquiring the unadded or deleted IED nodes in the unadded or deleted interval and the affected interval includes: Compare the IED nodes in the unadded and deleted intervals in the SCD file before the upgrade with the IED nodes in the unadded and deleted intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the unadded and deleted intervals; compare the IED nodes in the affected intervals in the SCD file before the upgrade with the IED nodes in the affected intervals in the SCD file after the upgrade, and extract the IED node addition and deletion information corresponding to the affected intervals; The IED nodes that have not been added or deleted are obtained according to the IED node addition or deletion information corresponding to the interval that has not been added or deleted and the IED node addition or deletion information corresponding to the affected interval.

4. The method for visually locating substation file differences based on big data according to claim 1, characterized in that: The difference between the IED content of the ICD file corresponding to the IED node to be compared and the IED content of the corresponding upgraded SCD file includes: Parse the descendant contents of each level of the IED node to be compared on the ICD side and store them in the first linked list; parse the descendant contents of each level of the IED node to be compared on the SCD side and store them in the second linked list; starting from the head end of the linked list, compare the label names and key attribute values ​​of the descendant nodes of the same level in the first linked list and the second linked list level by level, and compare the lengths of the first linked list and the second linked list; In response to the fact that the first linked list and the second linked list have the same length and that there are both sibling descendant nodes with different label names and key attribute values ​​and sibling descendant nodes with the same label name and key attribute values ​​in the first linked list and the second linked list, the sibling descendant nodes with different label names and key attribute values ​​are marked and displayed.

5. The method for visually locating substation file differences based on big data as claimed in claim 4 is characterized in that: Also includes: In response to the fact that the first linked list and the second linked list have the same length and there are no descendant nodes of the same level with the same tag name and key attribute value in the first linked list and the second linked list, the descendant nodes at all levels in the second linked list are marked as newly added, and the descendant nodes at all levels in the first linked list are marked as deleted, and the descendant nodes at all levels in the first linked list and the second linked list are displayed on the interface.

6. The method for visually locating substation file differences based on big data as claimed in claim 4, characterized in that: Also includes: In response to the length of the first linked list being less than the length of the second linked list and the first linked list and the second linked list not having descendant nodes of the same level with different tag names and key attribute values, searching the second linked list for descendant nodes with the same tag name and key attribute value as the head node of the first linked list; In response to the presence of a descendant node in the second linked list having the same tag name and key attribute value as the head node of the first linked list, the descendant node in the second linked list is recorded as the first node, and the tag names and key attribute values ​​of the descendant nodes of the same level as the head node of the first linked list are compared level by level to see whether the first node and the head node of the first linked list have the same tag name and key attribute value; In response, the tag names and key attribute values ​​of the descendant nodes of the same level as the first node and the head node of the first linked list are the same, and the nodes before the first node in the second linked list are marked and displayed.

7. The method for visually locating substation file differences based on big data as claimed in claim 4, characterized in that: Also includes: In response to the fact that the length of the first linked list is less than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, the number N of descendant nodes in the first linked list is obtained, and the descendant nodes from the N+1th level in the second linked list to the last level in the second linked list are marked as newly added, and are displayed on the display interface.

8. The method for visually locating substation file differences based on big data as claimed in claim 4, characterized in that: Also includes: In response to the length of the first linked list being greater than the length of the second linked list and the first linked list and the second linked list not having descendant nodes of the same level with the same tag name and key attribute value, searching the first linked list for descendant nodes with the same tag name and key attribute value as the head node of the second linked list; In response to the presence of a descendant node in the first linked list having the same tag name and key attribute value as the head node of the second linked list, the descendant node in the first linked list is recorded as a second node, and the tag names and key attribute values ​​of the second node and the same-level descendant nodes of the head node of the second linked list are compared level by level to see whether they are the same; In response, the label names and key attribute values ​​of the descendant nodes at all levels of the second node and the head node of the second linked list are the same, and the nodes before the second node in the first linked list are marked and displayed.

9. The method for visually locating substation file differences based on big data as claimed in claim 4, characterized in that: Also includes: In response to the fact that the length of the first linked list is greater than the length of the second linked list and the label names and key attribute values ​​of the descendant nodes at each level in the first linked list and the descendant nodes at the corresponding levels in the second linked list are the same, the number of descendant nodes M in the second linked list is obtained, and the descendant nodes from the M+1th level in the first linked list to the last level in the first linked list are marked as deleted, and displayed on the display interface.

10. A substation file difference visualization positioning system based on big data, comprising a memory and a processor, characterized in that: The memory stores computer program instructions, and when the computer program instructions are executed by the processor, the method for visually locating substation file differences based on big data as described in any one of claims 1 to 9 is implemented.

Images