Substation secondary cable design system based on three-layer architecture and cable lofting verification

Abstract

The invention relates to a transformer substation secondary cable design system based on a three-layer architecture and cable lofting verification. The transformer substation secondary cable design system comprises a user interaction layer, a business logic layer and a data access layer, the user interaction layer is used for interacting with a user; the data access layer is used for interacting with external data; the business logic layer is specifically divided into a data import module which is used for importing basic data of a cable; the cable management module is used for adding, deleting, modifying and checking cable types and editing cable parameters; the cable path calculation module is used for calculating a cable lofting path and generating a corresponding path model line; the cable lofting module is used for carrying out cable lofting; the cable verification module is used for judging whether the cable lofting meets the standard requirement or not according to the preset design requirement; and the data export module is used for exporting lofting cable data. Compared with the prior art, the method has the advantages that the cable design efficiency and accuracy are improved, multi-information integration and optimization are achieved, and later maintenance is facilitated.

Description

Technical Field

[0001] This invention relates to the field of cable design technology, and in particular to a substation secondary cable design system based on a three-layer architecture and cable layout verification. Background Technology

[0002] Secondary cables in substations are a crucial component connecting various secondary equipment, and their design quality directly affects the safe and stable operation of the substation. With the continuous development of power systems and the expansion of substation scale, the number of secondary cables has increased dramatically, leading to greater complexity in cable laying design. Traditional substation secondary cable design relies heavily on manual experience, resulting in low efficiency and a high risk of errors.

[0003] Currently, there are some technical solutions in the field of substation secondary cable design. For example, Chinese patent CN118797923A discloses an intelligent design method for substation electrical secondary cables. This method constructs an intelligent cable design model based on the cable location and cable channel, uses the A* algorithm to calculate the optimal cable laying path, and performs cable laying through an automatic cable arrangement algorithm.

[0004] In terms of three-dimensional digital design of secondary equipment, Chinese patent CN114970084A introduces a three-dimensional digital design and management method for secondary equipment in substations. This method imports the operating conditions and wiring diagrams of the secondary equipment in the substation into a three-dimensional library of secondary equipment, performs three-dimensional layout optimization design of the secondary equipment, and realizes the visualization simulation of construction plans and construction progress.

[0005] However, existing technologies still have some shortcomings. First, traditional substation secondary cable design methods are inefficient, prone to errors due to manual operation, and difficult to guarantee design quality. Second, existing systems lack complete cable data management and parameter editing functions, making it impossible to flexibly address the design requirements of different types of cables. Third, existing technologies do not comprehensively consider the specifications for cable bending radius, arrangement and support configuration, fixing and joint layout during cable route calculation and layout, making it difficult to ensure that the design results meet relevant standards. Fourth, existing systems lack an effective cable verification mechanism, making it impossible to promptly identify and correct design problems. Finally, existing technologies have limited data import and export functions, making it difficult to effectively interface with other systems, resulting in insufficient information integration and optimization, and hindering later maintenance and upgrades.

[0006] Therefore, there is an urgent need for a substation secondary cable design system based on a three-layer architecture and cable layout verification that can improve design efficiency, reduce human error, and ensure design quality, in order to meet the needs of modern substation construction. Summary of the Invention

[0007] The purpose of this invention is to overcome the problems of low efficiency, high human error, insufficient information integration and optimization in the existing technology, which makes it difficult to adapt to complex environments and special needs, inconvenient for later maintenance and upgrades, and lack of standardization and normalization. In this invention, we provide a substation secondary cable design system based on a three-layer architecture and cable layout verification.

[0008] The objective of this invention can be achieved through the following technical solutions:

[0009] A substation secondary cable design system based on a three-layer architecture and cable layout verification includes a user interaction layer, a business logic layer, and a data access layer.

[0010] The user interaction layer is used to interact with the user;

[0011] The data access layer is used to interact with external data;

[0012] The business logic layer is used to handle business rules and data transformation, and is specifically divided into:

[0013] The data import module is used to import basic cable data;

[0014] The cable management module is used to add, delete, modify, and query cable types, and to edit cable parameters;

[0015] The cable path calculation module is used to calculate the cable layout path based on the basic cable data and generate the corresponding path model line.

[0016] A cable layout module is used to perform cable layout according to the cable layout path.

[0017] The cable inspection module is used to determine whether the cable layout meets the specifications based on preset design requirements.

[0018] The data export module is used to export the layout cable data.

[0019] Furthermore, the cable verification module specifically verifies and checks the operations performed by the data import module, cable management module, cable path calculation module, and cable layout module. If the verification passes, the data export module is executed; if the verification fails, the process backtracks to the cable path calculation module and performs path planning and layout operations again until all requirements are met.

[0020] Furthermore, the data export module is also used for calculating the material inventory.

[0021] Furthermore, the substation secondary cable design system based on a three-layer architecture and cable layout verification adopts C language as the main programming language for the background.

[0022] The user interaction layer adopts an HTML+CSS+JavaScript architecture.

[0023] Furthermore, the cable layout process must meet the cable's allowable bending radius requirement, which is that the cable's minimum bending radius meets a preset bending radius standard.

[0024] Furthermore, the cable laying process must meet the requirements for cable arrangement and support configuration, which specifically include:

[0025] Cables should be laid in a neat and orderly manner.

[0026] Power cables and control cables are not mounted on the same layer of support;

[0027] High and low voltage power cables, high-voltage control cables, and low-voltage control cables are arranged in layers in sequence from top to bottom.

[0028] When the working and backup cables of the same important circuit are fire-resistant separated, they should be installed on supports on different sides or different floors.

[0029] The clearance between parallel-laid cables meets the preset design requirements.

[0030] Control cables shall not exceed two layers on ordinary supports; control cables shall not exceed three layers on cable trays.

[0031] AC three-core power cables shall not be laid in more than one layer on ordinary supports and hangers, and shall not be laid in more than two layers on cable trays;

[0032] AC single-core power cables are laid on the same side bracket and fixed in place.

[0033] Furthermore, the cable laying process must meet the requirements for cable fixing and joint arrangement, which specifically include:

[0034] When 35kV and below cables are laid in the open, the fixed positions for horizontal laying shall be set at the beginning and end of the cable line, at bends, and on both sides of the joints, and at a distance of not less than 100m on straight sections.

[0035] When cables are laid in the open, they are supported and secured along their entire length using cable brackets, cable trays, hooks, or ropes.

[0036] Furthermore, the cable laying process must meet phase sequence configuration requirements, which specifically include:

[0037] The normal induced voltage of the cable's metal sheath does not exceed the corresponding preset allowable value.

[0038] Furthermore, the cable layout process must meet the requirements for vertical shaft cable installation, which specifically include:

[0039] Cables with corrugated metal sheaths laid in cable shafts are provided with measures to prevent relative displacement between the conductor and the metal sheath.

[0040] Compared with the prior art, the present invention has the following advantages:

[0041] (1) Improve design efficiency and accuracy: By automating the processing of large amounts of data, including cable thickness, bending radius, path planning, etc., the time for manual input and calculation is significantly reduced. Through advanced algorithms and models, cable parameters are accurately calculated and paths are optimized, reducing human error.

[0042] (2) Achieve multi-dimensional information integration and optimization: comprehensively consider various factors such as cable thickness, bending radius, path length, and environmental factors, perform global optimization, and automatically adjust the cable layout design scheme to achieve the optimal cable layout and performance, and reduce redundancy and waste.

[0043] (3) Adapt to complex environments and special needs: Fully consider the impact of environmental factors on cable performance, provide customized design solutions, and meet the diverse needs of users;

[0044] (4) Improved ease of maintenance and upgrades: The cable system has a clearer and more reasonable structure, which facilitates maintenance and repair work. It also has sufficient interfaces and expansion space, making upgrades more convenient.

[0045] (5) Promote standardization and normalization: Promote the standardization and normalization of electrical secondary cable design, reduce differences between different projects or design teams, and improve the overall quality and reliability of cable systems. Attached Figure Description

[0046] Figure 1 This is a schematic diagram of a substation secondary cable design system based on a three-layer architecture and cable layout verification provided in an embodiment of the present invention;

[0047] Figure 2 This is a schematic diagram of the processing flow of a substation secondary cable design system based on a three-layer architecture and cable layout verification, provided in an embodiment of the present invention. Detailed Implementation

[0048] 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 embodiments of the present invention, and not all embodiments. 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.

[0049] Therefore, the following detailed description of the embodiments of the 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 invention without inventive effort are within the scope of protection of the invention.

[0050] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, it does not need to be further defined or explained in subsequent drawings.

[0051] In the description of this invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings, or the orientation or positional relationship in which the product of this invention is usually placed during use. They are only for the convenience of describing this invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this invention.

[0052] It should be noted that the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Therefore, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this application, "multiple" means two or more, unless otherwise explicitly specified.

[0053] Furthermore, terms such as "horizontal" and "vertical" do not imply that components must be absolutely horizontal or suspended, but rather that they can be slightly tilted. For example, "horizontal" simply means that its direction is more horizontal than "vertical," and does not mean that the structure must be completely horizontal, but can be slightly tilted.

[0054] Example 1

[0055] like Figure 1 and Figure 2 As shown, this embodiment provides a substation secondary cable design system based on a three-layer architecture and cable layout verification, including a user interaction layer, a business logic layer, and a data access layer.

[0056] The user interaction layer is used to interact with users, providing a user-friendly interface, receiving user input commands and data, and presenting the processing results to users in a visual manner.

[0057] The data access layer is used to interact with external data, and is responsible for reading, storing and managing data, ensuring that the system can efficiently access and process various types of cable data.

[0058] The business logic layer, located between the user interaction layer and the data access layer, is used to handle business rules and data transformation and is the core part of the system.

[0059] The business logic layer is specifically divided into six functional modules: data import module, cable management module, cable path calculation module, cable layout module, cable verification module, and data export module.

[0060] The data import module is used to import basic cable data. This module offers multiple import methods, including Excel spreadsheet import, CSV file import, and direct database connection import. Imported basic cable data includes cable model, specifications, application, start and end points, cable length, cable material, and cable cross-sectional area.

[0061] The data import module also has a data preprocessing function, which can perform format conversion, data cleaning and preliminary verification on the imported data to ensure that the imported data is in the correct format and complete in content.

[0062] The cable management module is used to add, delete, modify, and query cable types, and edit cable parameters. This module provides cable type library management functions, allowing users to add new cable types, delete unwanted cable types, modify parameters of existing cable types, and query cable types under specific conditions.

[0063] The cable parameter editing function allows users to set and adjust various technical parameters of the cable, such as rated voltage, rated current, insulation material, sheath material, conductor material, conductor cross-sectional area, outer diameter, mass per unit length, and minimum bending radius.

[0064] The cable management module also provides a parameter template function, allowing users to create and save commonly used cable parameter configurations for quick application in new design projects.

[0065] The cable path calculation module is used to calculate the cable layout path based on the basic cable data and generate the corresponding path model line. This module first analyzes the starting and ending points of the cable, and then, in conjunction with the substation layout structure, automatically calculates the optimal cable laying path.

[0066] The path calculation considers multiple factors, including the principle of minimizing path length, avoiding obstacles, and meeting cable laying specifications. After the calculation is completed, the system generates a 3D model of the cable path, visually displaying the spatial orientation of the cable.

[0067] The cable path calculation module also provides path optimization functions, which can adjust and optimize cable laying paths according to users' specific needs or constraints, such as avoiding specific areas or following preset cable tray routes.

[0068] The cable layout module is used to perform cable layout based on the cable layout path. This module converts the calculated path model lines into actual cable layout results, generating a detailed cable laying plan.

[0069] During cable layout, the system considers the physical characteristics of the cable, such as bending radius, cable spacing, and cable fixing method, to ensure that the layout results meet the actual needs of the project. The cable layout module also provides an interactive layout function, allowing users to manually adjust the layout based on automatic layout to adapt to special project requirements or site conditions.

[0070] The cable verification module is used to determine whether the cable layout meets the specifications based on preset design requirements. This module performs a comprehensive check on the cable layout results to verify whether they meet all technical specifications and design standards.

[0071] The verification includes whether the cable bending radius meets the requirements, whether the cable spacing meets the regulations, whether the cable laying method is correct, and whether the cable fixing points are set reasonably.

[0072] The cable verification module specifically verifies and checks the operations performed by the data import module, cable management module, cable route calculation module, and cable layout module. If the verification passes, the data export module is executed; if the verification fails, the process backtracks to the cable route calculation module and redoes the route planning and layout operations until all requirements are met.

[0073] During the verification process, the system will generate a detailed verification report, indicating the specific items and locations that do not meet the requirements, and providing improvement suggestions.

[0074] Preferably, the cable verification module not only verifies the final layout result, but also monitors and checks each stage of the entire design process in real time.

[0075] Specifically, the cable verification module verifies the format and content of the data imported by the data import module to ensure the integrity and accuracy of the data; it checks the rationality of the cable parameters edited by the cable management module to avoid subsequent design problems caused by improper parameter settings; it optimizes and analyzes the paths generated by the cable path calculation module to verify whether the paths meet the requirements of shortest distance and obstacle avoidance; and it conducts a comprehensive check on the layout results of the cable layout module to ensure compliance with all technical specifications.

[0076] When the verification detects any non-compliance, the system will immediately notify the user and determine the handling method based on the nature of the problem. For issues such as incorrect data format or unreasonable parameter settings, the system will require the user to make corrections; for problems in path planning and layout operations, the system will automatically backtrack to the cable path calculation module and re-perform the path planning and layout operations.

[0077] The system will continuously execute the verification and correction process until all requirements are met before allowing the data export module to be executed, ensuring that the final output design fully complies with the specifications.

[0078] The data export module is used to export cable layout data. This module exports the final cable layout results in various formats, including CAD drawings, 3D model files, Excel spreadsheets, PDF reports, etc., facilitating subsequent project implementation and document management for users.

[0079] The data export module is also used to perform material inventory calculations, automatically calculating the quantity, specifications, and total length of various cables and accessories used in the design scheme, generating a detailed material list, and providing an accurate basis for project budgeting and material procurement.

[0080] The material inventory calculation function supports statistics according to different classification methods, such as by cable type, by laying area, by voltage level, etc., to meet material management needs from different perspectives.

[0081] Preferably, in addition to the basic cable layout data export function, the data export module also provides a detailed material list calculation function. This function can automatically calculate the required quantity and specifications of various materials based on the final determined cable layout plan, including the total length of different types of cables, the number of cable joints, the number of fasteners, and the bracket requirements.

[0082] The materials inventory calculation function supports multiple statistical methods, allowing for categorization and statistics based on different dimensions such as cable type, laying area, and voltage level, generating a detailed materials list. The system can also automatically generate procurement suggestions based on the materials list, including recommended suppliers, estimated prices, and delivery cycles, providing comprehensive support for subsequent project implementation.

[0083] In addition, the data export module also provides a cost estimation function, which can automatically calculate the material costs of a project based on the bill of materials and current market prices, helping users to control budgets and optimize costs. The system supports exporting reports and charts in various formats, including Excel spreadsheets, PDF documents, and CAD drawings, to meet document needs in different scenarios.

[0084] This substation secondary cable design system, based on a three-layer architecture and cable layout verification, uses C language as the main programming language for the backend, giving full play to the high efficiency, stability and portability of C language to ensure the high-performance operation of the system's core functions.

[0085] The backend adopts a modular design, with each functional module exchanging data and calling functions through standard interfaces, improving the maintainability and scalability of the system.

[0086] The user interaction layer adopts an HTML+CSS+JavaScript architecture to build a responsive web interface that supports access and use on different devices and browsers. The interface design follows human-computer interaction principles, providing intuitive operation processes and clear information display to reduce the learning curve for users.

[0087] The system uses AJAX technology to achieve front-end and back-end data interaction, improving the smoothness of user operation and response speed.

[0088] Agile development methodologies were employed during the development process, and continuous integration and automated testing ensured the system's stability and reliability. The system also integrated version control tools to facilitate collaborative development and code management among multiple developers.

[0089] During the cable layout process, the system strictly follows the allowable bending radius requirements of the cable to ensure that the minimum bending radius of the cable meets the preset bending radius standard.

[0090] For different types of cables, the system automatically calculates the minimum allowable bending radius based on their technical parameters and checks it in real time during path planning and layout to avoid excessive bending that could damage the cable.

[0091] For example, for power cables, the minimum bending radius is generally required to be no less than 10 times the cable's outer diameter. For rubber-insulated power cables, the minimum bending radius is no less than 10 times the cable's outer diameter, and for plastic-insulated power cables, the minimum bending radius is no less than 12 times the cable's outer diameter. For control cables, the minimum bending radius is generally required to be no less than 10 times the cable's outer diameter, but the specific requirements can be set according to different materials and whether the cable is single-core or multi-core.

[0092] During the route planning and layout process, the system monitors the bending of the cable in real time. When the bending radius is detected to be smaller than the preset standard, the system will automatically adjust the route or prompt the user to make manual corrections.

[0093] The system also provides a bending radius visualization function, which intuitively displays the degree of cable bending through color markings, helping users quickly identify potential problem areas.

[0094] Meanwhile, the cable layout process must meet the requirements for cable arrangement and support configuration, specifically including:

[0095] Cables should be laid neatly to avoid crossing and tangling; power cables and control cables should not be placed on the same layer of support to prevent mutual interference.

[0096] High and low voltage power cables, high-voltage control cables, and low-voltage control cables are arranged in sequence and layered from top to bottom to ensure the safety and maintainability of the system.

[0097] When working and backup cables of the same important circuit are fire-resistant separated, they are placed on supports on different sides or different layers to improve the reliability of the system; the net distance between parallel cables meets the preset design requirements to avoid heat accumulation and electromagnetic interference.

[0098] Control cables should not be stacked more than two layers on ordinary supports and more than three layers on cable trays to prevent excessive stacking from affecting heat dissipation.

[0099] Three-core AC power cables should not be placed in more than one layer on ordinary supports and hangers, and not more than two layers on cable trays, to ensure the heat dissipation of the cables;

[0100] AC single-core power cables are laid on the same side bracket and fixed in place to prevent the cables from shifting due to electromagnetic force.

[0101] Through the collaborative work of the above modules, this substation secondary cable design system based on a three-layer architecture and cable layout verification can efficiently and accurately complete the design of substation secondary cables, greatly improving design efficiency and quality, reducing human error, and ensuring that cable laying meets various technical specifications and safety requirements.

[0102] Example 2

[0103] Building upon Example 1, the requirements for cable fixing and joint arrangement during cable laying out are more precise and standardized. The system provides an intelligent fixing point design function, which can automatically calculate and set the fixing point positions based on the cable type, laying method, and route characteristics.

[0104] When cables of 35kV and below are laid in the open, the system will automatically set fixed points at the beginning and end of the cable line, at bends, and on both sides of the joints, and set fixed points at no less than 100m intervals on straight sections.

[0105] The system will also adjust the spacing of the fixing points according to the weight of the cable and the laying environment to ensure the stability of the cable laying.

[0106] The system offers various cable fixing options, including cable supports, cable trays, hooks, or suspenders, and automatically selects the most suitable method based on cable characteristics and installation environment. For vertically laid cables, the system increases the density of fixing points, generally requiring a spacing of no more than 1.5m between fixing points to prevent cable deformation or damage due to its own weight.

[0107] The system also provides a connector layout optimization function to minimize the number of cable connectors and place the necessary connectors in locations that are easy to inspect and maintain.

[0108] For cables that require connectors, the system will automatically calculate the positions of the fixing points on both sides of the connector to ensure that the connector is in a stable state and to avoid damage to the connector due to tension or vibration.

[0109] The preferred embodiments of the present invention have been described in detail above. It should be understood that those skilled in the art can make numerous modifications and variations based on the concept of the present invention without creative effort. Therefore, all technical solutions that can be obtained by those skilled in the art based on the concept of the present invention through logical analysis, reasoning, or limited experimentation on the basis of existing technology should be within the scope of protection defined by the claims.

Claims

1. A substation secondary cable design system based on a three-layer architecture and cable layout verification, characterized in that, It includes a user interaction layer, a business logic layer, and a data access layer; the user interaction layer is used to interact with users; the data access layer is used to interact with external data; the business logic layer is used to handle business rules and data transformation, and is specifically divided into: a data import module, used to import basic cable data; The cable management module is used to add, delete, modify, and query cable types, and to edit cable parameters; The cable path calculation module is used to calculate the cable layout path based on the basic cable data and generate the corresponding path model line. A cable layout module is used to perform cable layout according to the cable layout path. The cable inspection module is used to determine whether the cable layout meets the specifications based on preset design requirements. The data export module is used to export the layout cable data.

2. The substation secondary cable design system based on a three-layer architecture and cable layout verification as described in claim 1, characterized in that, The cable verification module specifically verifies and checks the operations performed by the data import module, cable management module, cable path calculation module, and cable layout module. If the verification passes, the data export module is executed. If the verification fails, the process will backtrack to the cable path calculation module and repeat the path planning and layout operations until all requirements are met.

3. The substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The data export module is also used for calculating the material inventory.

4. The substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The substation secondary cable design system based on a three-layer architecture and cable layout verification uses C language as the main programming language for the backend.

5. A substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The user interaction layer adopts an HTML+CSS+JavaScript architecture.

6. The substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The cable layout process must meet the cable's allowable bending radius requirement, which is that the cable's minimum bending radius meets a preset bending radius standard.

7. A substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The cable layout process must meet the requirements for cable arrangement and support configuration, which specifically include: Cables should be laid in a neat and orderly manner. Power cables and control cables are not mounted on the same layer of support; High and low voltage power cables, high-voltage control cables, and low-voltage control cables are arranged in layers in sequence from top to bottom. When the working and backup cables of the same important circuit are fire-resistant separated, they should be installed on supports on different sides or different floors. The clearance between parallel-laid cables meets the preset design requirements. Control cables shall not exceed two layers on ordinary supports; control cables shall not exceed three layers on cable trays. AC three-core power cables shall not be laid in more than one layer on ordinary supports and hangers, and shall not be laid in more than two layers on cable trays; AC single-core power cables are laid on the same side bracket and fixed in place.

8. A substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The cable laying-out process must meet the requirements for cable fixing and joint arrangement, which specifically include: When 35kV and below cables are laid in the open, the fixed positions for horizontal laying shall be set at the beginning and end of the cable line, at bends, and on both sides of the joints, and at a distance of not less than 100m on straight sections. When cables are laid in the open, they are supported and secured along their entire length using cable brackets, cable trays, hooks, or ropes.

9. A substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The cable laying process must meet phase sequence configuration requirements, which specifically include: The normal induced voltage of the cable's metal sheath does not exceed the corresponding preset allowable value.

10. A substation secondary cable design system based on a three-layer architecture and cable layout verification according to claim 1, characterized in that, The cable layout process must meet the requirements for vertical shaft cable installation, which specifically include: Cables with corrugated metal sheaths laid in cable shafts are provided with measures to prevent relative displacement between the conductor and the metal sheath.

Images