Generation method of booster station equipment information dynamic structure and related device

Abstract

The invention discloses a method for generating a dynamic structure of booster station equipment information and a related device. The method comprises the following steps: acquiring regional information; acquiring equipment ledger information; constructing a region tree according to the region information; the equipment ledger information is added to the corresponding nodes of the area tree to construct the equipment tree, and the method and the related device have the advantages of being high in query efficiency, flexible in structure and timely in information updating.

Description

Technical Field

[0001] This invention belongs to the field of power system equipment management technology, and relates to a method and related apparatus for generating dynamic structures of substation equipment information. Background Technology

[0002] In power systems, step-up substations, as crucial power facilities, undertake key tasks of voltage transformation and power dispatch. Effective management of their equipment information is essential for ensuring the safe and stable operation of the power system. Step-up substations typically contain numerous devices such as transformers, circuit breakers, disconnectors, and instrument transformers. The operating status, parameter information, and logical relationships between these devices directly affect the power system's reliability and operational efficiency. Therefore, accurate and efficient management of step-up substation equipment information is a vital component of power system operation and maintenance.

[0003] Traditional methods for managing equipment information in substations typically employ static tables or databases. This approach was sufficient for basic management needs in the early stages of power systems when the scale was smaller, the number of devices was fewer, and information changes were infrequent. However, with the rapid development of power systems, the scale of substations has continuously expanded, the number of devices has increased dramatically, and equipment information has become increasingly complex and volatile. The limitations of traditional management methods have become increasingly apparent, primarily exhibiting the following problems:

[0004] Delayed Information Updates: When equipment information at the substation changes—such as the addition of new equipment, equipment decommissioning, parameter modifications, or location relocation—traditional static management methods cannot reflect these changes in real time. Administrators must manually update tables or databases, which is not only labor-intensive but also prone to omissions or errors, leading to inconsistencies between equipment information and the actual status, resulting in information lag. This lag can affect maintenance personnel's decision-making and may even cause operational errors, threatening the safe and stable operation of the power system.

[0005] Inflexible Structure: Traditional equipment information management methods typically employ a fixed hierarchical structure, such as categorization by voltage level, equipment type, or region. This fixed structure struggles to adapt to the complex and ever-changing equipment management needs of modern substations. When adjustments to the management structure are required—such as adding new classification dimensions, modifying hierarchical relationships, or performing cross-level queries—traditional static management methods often fall short, necessitating complex database structure modifications or table redesigns, resulting in a large workload and low efficiency.

[0006] Low query efficiency: Traditional query methods are inefficient when faced with massive amounts of equipment information. When maintenance personnel need to query information about specific equipment or areas, they often have to manually sift through a large number of tables or database records, which is not only time-consuming and labor-intensive but also prone to errors. Especially in emergency situations, quickly and accurately obtaining equipment information is crucial for troubleshooting and emergency response, and traditional query methods clearly cannot meet this demand for rapid response. Summary of the Invention

[0007] The purpose of this invention is to overcome the shortcomings of the prior art and provide a method and related apparatus for generating dynamic structures of substation equipment information. This method and related apparatus have the characteristics of high query efficiency, flexible structure, and timely information updates.

[0008] To achieve the above objectives, this invention discloses a method for generating a dynamic structure of information for booster station equipment, comprising:

[0009] Obtain regional information;

[0010] Obtain equipment ledger information;

[0011] Construct a region tree based on region information;

[0012] Add the equipment ledger information to the corresponding node in the region tree to construct the equipment tree.

[0013] A further improvement of the method for generating the dynamic structure of substation equipment information described in this invention lies in:

[0014] Furthermore, the process of obtaining the region information is as follows:

[0015] Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates;

[0016] The basic information of the region, the region level, and the information of its superiors and subordinates are stored in the database.

[0017] Furthermore, the process of obtaining equipment ledger information is as follows:

[0018] Obtain the equipment type, basic information, superior equipment information, and regional information.

[0019] The equipment type, basic information, superior equipment information, and regional information are stored in the database.

[0020] Furthermore, the process of constructing a region tree based on region information is as follows:

[0021] Based on the regional information and equipment ledger information stored in the database, generate regional cache and equipment ledger cache;

[0022] Retrieve the root region ID, root region type, parent region, and region ID information;

[0023] Based on the root region ID, root region type, parent region and region ID information, retrieve region information from the region cache;

[0024] A region tree is constructed based on the region information obtained from the region cache.

[0025] Furthermore, the process of adding the equipment ledger information to the corresponding node in the region tree to construct the equipment tree is as follows:

[0026] Obtain information about the region tree;

[0027] Based on the information in the region tree, retrieve device information from the device ledger cache;

[0028] Add device information to the corresponding node in the region tree to construct the device tree.

[0029] Furthermore, it also includes:

[0030] Automatically remove nodes from the region tree that do not contain device information;

[0031] Query all devices of a subtype under the device type;

[0032] The tree structure hierarchy is dynamically adjusted based on parameters;

[0033] Automatically filter out device information that does not contain business data.

[0034] This invention discloses a system for generating dynamic structures of information on booster station equipment, comprising:

[0035] The first acquisition module is used to acquire regional information;

[0036] The second acquisition module is used to acquire equipment ledger information;

[0037] The first construction module is used to build a region tree based on the region information;

[0038] The second construction module is used to add equipment ledger information to the corresponding nodes of the area tree to construct the equipment tree.

[0039] A further improvement of the system for generating dynamic structures of substation equipment information described in this invention is that:

[0040] Furthermore, the process of obtaining the region information is as follows:

[0041] Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates;

[0042] The basic information of the region, the region level, and the information of its superiors and subordinates are stored in the database.

[0043] This invention discloses a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the steps of a method for generating a dynamic structure of information for a booster station.

[0044] This invention discloses a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the steps of a method for generating a dynamic structure of information about a booster station.

[0045] The present invention has the following beneficial effects:

[0046] In specific operation, the method and related apparatus for generating dynamic structures of substation equipment information described in this invention obtains regional information and equipment ledger information, constructs a regional tree based on the regional information, and adds the equipment ledger information to the corresponding nodes of the regional tree to construct the equipment tree. The substation equipment information is represented in the form of an equipment tree, which has the characteristics of high query efficiency, flexible structure, and timely information updates. Attached Figure Description

[0047] The accompanying drawings, which form part of this specification, are used to provide a further understanding of the invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an undue limitation of the invention. In the drawings:

[0048] Figure 1 This is a flowchart of the method of the present invention. Detailed Implementation

[0049] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0050] In the description of this invention, it should be understood that the terms "comprising" and "including" indicate the presence of the described features, integrals, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components and / or collections thereof.

[0051] It should also be understood that the terminology used in this specification is for the purpose of describing particular embodiments only and is not intended to limit the invention. As used in this specification and the appended claims, the singular forms “a,” “an,” and “the” are intended to include the plural forms unless the context clearly indicates otherwise.

[0052] It should also be further understood that the term "and / or" as used in this specification and the appended claims refers to any combination and all possible combinations of one or more of the associated listed items, and includes such combinations. For example, A and / or B can represent three cases: A alone, A and B simultaneously, and B alone. Additionally, the character " / " in this invention generally indicates that the preceding and following objects have an "or" relationship.

[0053] It should be understood that although terms such as first, second, third, etc., may be used in the embodiments of the present invention to describe the preset range, these preset ranges should not be limited to these terms. These terms are only used to distinguish the preset ranges from one another. For example, without departing from the scope of the embodiments of the present invention, the first preset range may also be referred to as the second preset range, and similarly, the second preset range may also be referred to as the first preset range.

[0054] Depending on the context, the word "if" as used here can be interpreted as "when," "when," "in response to determination," or "in response to detection." Similarly, depending on the context, the phrase "if determination" or "if detection (of the stated condition or event)" can be interpreted as "when determination," "in response to determination," "when detection (of the stated condition or event)," or "in response to detection (of the stated condition or event)."

[0055] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of the present invention. The components of the embodiments of the present invention described and shown in the accompanying drawings can generally be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely to illustrate selected embodiments of the invention. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without inventive effort are within the scope of protection of the present invention.

[0056] The accompanying drawings illustrate various structural schematic diagrams according to embodiments disclosed in this invention. These drawings are not to scale, and some details have been enlarged for clarity, and some details may have been omitted. The shapes of the various regions and layers shown in the drawings, as well as their relative sizes and positional relationships, are merely exemplary and may deviate from reality due to manufacturing tolerances or technical limitations. Furthermore, those skilled in the art can design regions / layers with different shapes, sizes, and relative positions as needed.

[0057] Example 1

[0058] refer to Figure 1 The method for generating the dynamic structure of substation equipment information according to the present invention includes the following steps:

[0059] 1) Obtain regional information;

[0060] Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates;

[0061] Store regional information in a database;

[0062] 2) Obtain equipment ledger information;

[0063] Obtain the equipment type, basic information, superior equipment information, and regional information.

[0064] The equipment ledger information is stored in a database.

[0065] 3) Automatically generate regional cache and device ledger cache;

[0066] Based on the regional information and equipment ledger information stored in the database, a regional cache and an equipment ledger cache are generated. The cache contains a child list for quickly building a regional tree and a device tree.

[0067] 4) Construct a region tree;

[0068] Retrieve the root region ID, root region type, parent region, and region ID information.

[0069] Based on the root region ID, root region type, parent region, and region ID information, retrieve region information from the region cache.

[0070] A region tree is constructed based on the region information obtained from the region cache, and the region tree is stored in memory.

[0071] 5) Construct the device tree;

[0072] Obtain information about the region tree.

[0073] Based on the information in the region tree, retrieve device information from the device ledger cache.

[0074] Add device information to the corresponding node in the region tree to construct the device tree.

[0075] 6) Automatically remove nodes from the region tree that do not contain device information;

[0076] Traverse all nodes of the region tree.

[0077] The system automatically removes nodes in the area tree that do not contain device information to ensure the validity of the device tree.

[0078] 7) Query all subtypes of devices under a given device type:

[0079] Input device type;

[0080] Based on the device type, query the device information of all subtypes under that device type from the device ledger cache.

[0081] Return the query results.

[0082] 8) Dynamically adjust the tree structure hierarchy based on parameters, and display different types of device trees;

[0083] Input the hierarchical parameters of the tree structure and the type parameters of the device tree.

[0084] The system dynamically adjusts the hierarchy of the tree structure based on the input parameters and displays the corresponding type of device tree.

[0085] 9) Automatically filter device information that does not contain business data (such as devices without associated locations):

[0086] Traverse device information;

[0087] The system automatically filters out device information that does not contain business data to ensure the accuracy and effectiveness of the displayed device information.

[0088] Through the above implementation methods, the present invention can realize the dynamic generation and management of substation equipment information, thereby improving the efficiency and accuracy of equipment information management.

[0089] It should be noted that the present invention has the following characteristics:

[0090] 1. Improve information update efficiency and ensure data timeliness;

[0091] Traditional static management methods rely on manual maintenance of tables or databases. When equipment information changes, manual updates are required, which is inefficient, error-prone, and leads to information lag. This invention achieves real-time updates of equipment information through a mechanism that automatically generates regional and equipment ledger caches. When regional or equipment ledger information changes, the system automatically triggers the cache update process without manual intervention.

[0092] Cache generation mechanism: The system can be programmed with scheduled tasks to periodically scan for changes in area information and equipment ledger information, and automatically update the cache. Alternatively, an event-driven approach can be used to immediately trigger a cache update when a change in equipment information is detected.

[0093] Real-time data synchronization: After the cache is updated, the present invention will immediately synchronize the latest device information to memory to ensure that subsequent query and display operations can obtain the latest data.

[0094] Reduced manual intervention: The automated cache update mechanism greatly reduces the workload of manual maintenance, lowers the risk of human error, and ensures the accuracy and timeliness of equipment information.

[0095] 2. Enhance structural flexibility to adapt to complex management needs;

[0096] Traditional equipment information management uses a fixed hierarchical structure, which is difficult to adapt to the complex and ever-changing equipment management needs of modern substations. This invention gives the system extremely strong structural flexibility by dynamically adjusting the tree structure hierarchy and displaying different types of equipment trees.

[0097] Dynamic hierarchy adjustment: The system is no longer limited to a preset fixed hierarchy, but can dynamically adjust the hierarchy of the tree structure according to actual management needs. For example, different levels of device trees can be flexibly constructed based on multiple dimensions such as voltage level, equipment type, and management area.

[0098] Multiple Device Tree Display: The system supports displaying various types of device trees, such as area device trees, voltage level device trees, and device type device trees. Users can select and view different types of device trees as needed to meet diverse management requirements.

[0099] Adaptable to complex scenarios: The dynamically adjustable structure enables the present invention to easily cope with various complex scenarios of substation equipment management, such as equipment expansion, regional adjustment, and management strategy changes, thereby improving the system's adaptability and scalability.

[0100] 3. Optimize the search function to achieve fast and accurate retrieval.

[0101] Traditional query methods are inefficient when retrieving specific device or region information from massive amounts of device data, failing to meet the need for rapid response. This invention significantly optimizes the query function by constructing region trees and device trees, and supporting querying device information based on device type.

[0102] Tree-structured queries accelerate retrieval: Region trees and device trees organize device information in a tree structure. Utilizing the fast retrieval characteristics of tree structures, query efficiency can be significantly improved. This invention can quickly locate target nodes and obtain relevant device information.

[0103] Precise device type search: The system supports searching by device type. Users can enter keywords related to the device type, and the system will quickly filter out all devices belonging to that type and display detailed device information.

[0104] Meets the need for rapid response: The optimized query function enables maintenance personnel to quickly and accurately obtain the required equipment information, meeting the rapid response needs in scenarios such as fault diagnosis and emergency handling, and improving work efficiency.

[0105] 4. Enhance user experience and create a simple and efficient interface;

[0106] Traditional device information displays often contain a large amount of redundant information, requiring users to spend a significant amount of time filtering out relevant information, resulting in a poor user experience. This invention effectively improves the user experience by automatically filtering device information that does not contain business data.

[0107] Intelligent data filtering: This invention can automatically identify and filter equipment information that does not contain business data, such as equipment that is not in operation, retired equipment, or equipment information that is irrelevant to the current business.

[0108] Concise and clear display: The filtered device information is displayed more concisely and clearly, allowing users to quickly focus on key device information, reducing information interference and improving information acquisition efficiency.

[0109] Enhanced ease of use: The simple and efficient interface allows users to more easily query, browse, and operate device information, improving the overall user experience.

[0110] 5. Dynamic hierarchical structure: Breaking through static limitations and enabling flexible construction;

[0111] This invention overcomes the limitations of the static hierarchical structure in traditional substation equipment information management, achieving dynamic hierarchical management of equipment information. Traditional methods use fixed table or database structures with pre-defined hierarchical relationships, making it difficult to adapt to dynamic changes in equipment information and complex management needs. This invention, however, supports dynamically generating a region tree based on root region ID, region type, and parent region information, and dynamically constructing a device tree based on equipment type. This dynamic construction method allows the hierarchical structure of equipment information to be flexibly adjusted according to actual needs without modifying the underlying data structure, thus adapting to different management scenarios and business requirements.

[0112] 6. Intelligent caching mechanism: Real-time updates and efficient querying.

[0113] Traditional equipment information management methods require manual or periodic refreshes to obtain the latest information after data updates, resulting in low query efficiency. This invention introduces an intelligent caching mechanism that automatically generates regional and equipment ledger caches, enabling real-time updates and efficient queries of equipment information. When regional or equipment ledger information changes, the system automatically triggers a cache update process, ensuring that the data in the cache remains synchronized with the data in the database in real time. Simultaneously, building regional and equipment trees based on cached data significantly improves query efficiency because cached data is stored in memory, resulting in access speeds far faster than direct database queries. This intelligent caching mechanism not only guarantees data real-time performance but also significantly improves system response speed and query performance.

[0114] Example 2

[0115] The system for generating dynamic structures of substation equipment information according to the present invention includes:

[0116] The first acquisition module is used to acquire regional information;

[0117] The second acquisition module is used to acquire equipment ledger information;

[0118] The first construction module is used to build a region tree based on the region information;

[0119] The second construction module is used to add equipment ledger information to the corresponding nodes of the area tree to construct the equipment tree.

[0120] In this embodiment, the process of obtaining regional information is as follows:

[0121] Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates;

[0122] The basic information of the region, the region level, and the information of its superiors and subordinates are stored in the database.

[0123] The module division in this embodiment is illustrative and represents only one logical functional division. In actual implementation, other division methods may be used. Furthermore, the functional modules in each embodiment of this application can be integrated into a single processor, exist as separate physical entities, or be integrated into a single module. The integrated modules described above can be implemented in hardware or as software functional modules.

[0124] Example 3

[0125] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the steps of a method for generating a dynamic structure of information about a booster station equipment. For example, the steps include: acquiring regional information; acquiring equipment ledger information; constructing a regional tree based on the regional information; and adding the equipment ledger information to corresponding nodes in the regional tree to construct the equipment tree. The memory may include main memory, such as high-speed random access memory, and may also include non-volatile memory, such as at least one disk storage device. The processor, network interface, and memory are interconnected via an internal bus, which may be an industry-standard architecture bus, a peripheral component interconnection standard bus, an extended industry-standard architecture bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. The memory stores the program; specifically, the program may include program code, which includes computer operation instructions. The memory may include main memory and non-volatile memory, and provides instructions and data to the processor.

[0126] Example 4

[0127] A computer-readable storage medium stores a computer program that, when executed by a processor, implements the steps of a method for generating a dynamic structure of information about a booster station equipment. For example, the method includes: acquiring regional information; acquiring equipment ledger information; constructing a regional tree based on the regional information; and adding the equipment ledger information to corresponding nodes in the regional tree to construct the equipment tree. Specifically, the computer-readable storage medium includes, but is not limited to, volatile memory and / or non-volatile memory. The volatile memory may include random access memory (RAM) and / or cache memory, etc. The non-volatile memory may include read-only memory (ROM), hard disk, flash memory, optical disk, magnetic disk, etc.

[0128] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0129] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0130] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0131] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0132] Other embodiments of the invention will readily occur to those skilled in the art upon consideration of the specification and disclosure of the invention. This application is intended to cover any variations, uses, or adaptations of the invention that follow the general principles of the invention and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of the invention are indicated by the following claims.

[0133] It should be understood that the present invention is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of the invention is limited only by the appended claims.

[0134] The above description is merely a preferred embodiment of the present invention and does not constitute any limitation on the present invention. Any simple modifications, alterations, or equivalent structural changes made to the above embodiments based on the technical essence of the present invention shall still fall within the protection scope of the present invention.

Claims

1. A method for generating a dynamic structure of information for booster station equipment, characterized in that, include: Obtain regional information; Obtain equipment ledger information; Construct a region tree based on region information; Add the equipment ledger information to the corresponding node in the region tree to construct the equipment tree.

2. The method for generating a dynamic structure of substation equipment information according to claim 1, characterized in that, The process of obtaining regional information is as follows: Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates; The basic information of the region, the region level, and the information of its superiors and subordinates are stored in the database.

3. The method for generating a dynamic structure of substation equipment information according to claim 1, characterized in that, The process of obtaining equipment ledger information is as follows: Obtain the equipment type, basic information, superior equipment information, and regional information; The equipment type, basic information, superior equipment information, and regional information are stored in the database.

4. The method for generating a dynamic structure of substation equipment information according to claim 1, characterized in that, The process of constructing a region tree based on region information is as follows: Based on the regional information and equipment ledger information stored in the database, generate regional cache and equipment ledger cache; Retrieve the root region ID, root region type, parent region, and region ID information; Based on the root region ID, root region type, parent region and region ID information, retrieve region information from the region cache; A region tree is constructed based on the region information obtained from the region cache.

5. The method for generating a dynamic structure of substation equipment information according to claim 1, characterized in that, The process of adding equipment ledger information to the corresponding node in the region tree to construct the equipment tree is as follows: Obtain information about the region tree; Based on the information in the region tree, retrieve device information from the device ledger cache; Add device information to the corresponding node in the region tree to construct the device tree.

6. The method for generating a dynamic structure of substation equipment information according to claim 1, characterized in that, Also includes: Automatically remove nodes from the region tree that do not contain device information; Query all devices of a subtype under the device type; The tree structure hierarchy is dynamically adjusted based on parameters; Automatically filter out device information that does not contain business data.

7. A system for generating dynamic information structures for booster station equipment, characterized in that, include: The first acquisition module is used to acquire regional information; The second acquisition module is used to acquire equipment ledger information; The first construction module is used to build a region tree based on the region information; The second construction module is used to add equipment ledger information to the corresponding nodes of the area tree to construct the equipment tree.

8. The system for generating dynamic structures of substation equipment information according to claim 7, characterized in that, The process of obtaining regional information is as follows: Obtain basic information about the region, its hierarchical level, and information about its superiors and subordinates; The basic information of the region, the region level, and the information of its superiors and subordinates are stored in the database.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the method for generating dynamic structures of substation equipment information as described in any one of claims 1-6.

10. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the steps of the method for generating the dynamic structure of information of the booster station equipment as described in any one of claims 1-6.

Images