A substation test data intelligent acquisition and analysis and report automatic generation system

Abstract

This invention discloses an intelligent data acquisition, analysis, and automatic report generation system for substation test data, belonging to the field of intelligent operation and maintenance technology for digital substations. It solves the problems of high manual dependence, inaccurate analysis, cumbersome report compilation, and poor system compatibility in traditional testing operations. The system adopts a three-level cloud-edge-device deployment architecture, including eight modules: mobile acquisition terminal, Dianhong terminal adaptation communication, test data acquisition, intelligent data analysis, automatic report generation, substation operation and maintenance system integration, secure data storage, and fine-grained access control and auditing. Based on the Dianhong operating system and WAPI protocol, the system enables plug-and-play functionality and end-to-end interconnection of test instruments, supporting automatic data acquisition and manual data entry. It incorporates a three-phase discrete quantification algorithm for circuit breaker mechanical characteristics, achieving accurate data analysis and automatic equipment status assessment. Based on a template engine, it automatically generates standardized test reports and achieves closed-loop task management and full-process monitoring with the substation operation and maintenance system.

Description

Technical Field

[0001] This invention belongs to the field of intelligent operation and maintenance technology of digital substations, specifically relating to a substation test data intelligent acquisition, analysis and automatic report generation system. Background Technology

[0002] With the comprehensive advancement of the construction of the new power system, China Southern Power Grid is accelerating the construction of a power Internet of Things ecosystem centered on the Dianhong operating system, and the number of intelligent terminal devices in digital substations is growing exponentially. Routine and preventive tests of core substation equipment such as circuit breakers, instrument transformers, and disconnect switches are key links to ensure the safe and stable operation of the power grid. China Southern Power Grid Guangdong Power Grid Company alone needs to complete more than 100,000 substation equipment tests annually.

[0003] The existing substation testing and maintenance technology system has the following fundamental technical defects, which make it unable to meet the development needs of digital substation electrification transformation and intelligent operation and maintenance:

[0004] 1. Current test data collection still mainly relies on "manual copying + post-entry". The mechanical characteristic test of a single circuit breaker requires manual recording of more than 30 parameters, resulting in a high data entry error rate. In addition, traditional test instruments mostly use RS-232 / 485 wired connections, which cannot be integrated with the Dianhong intelligent terminal and WAPI near-field communication system. Data cannot achieve real-time synchronization between cloud, edge and terminal, resulting in serious test data lag.

[0005] 2. In the existing technology, the interpretation of test data relies entirely on the personal experience of operation and maintenance personnel, and the difference in judgment results of different personnel on the same set of data is high; in particular, the analysis of the differences in key parameters such as the three-phase opening and closing time and bounce time of circuit breakers lacks a unified quantitative calculation standard, which makes it impossible to detect hidden defects of equipment in a timely manner, and the misjudgment rate and missed judgment rate remain high.

[0006] 3. Test reports require manual data compilation, waveform plotting, and layout editing, resulting in a long preparation time for each report; report version management is chaotic, with paper and electronic reports not synchronized, making it impossible to achieve data linkage with the substation operation and maintenance system; the entire process of test tasks from issuance to archiving is invisible and untraceable, which does not meet the requirements of digital power grid management.

[0007] 4. Existing test data processing systems are mostly developed based on the x86 architecture and Windows operating system, which are incompatible with ARM / MIPS heterogeneous computing power, Euler / Kylin domestic operating system and Nanda general database, and cannot meet the requirements of China Southern Power Grid's information technology innovation transformation; and have not been deeply adapted for the Dianhong operating system, so it is impossible to realize plug-and-play and end-to-end interconnection of Dianhong smart terminals.

[0008] 5. Existing systems generally suffer from problems such as unencrypted data transmission, plaintext storage of sensitive data, and lax access control, which do not comply with GB / T22239-2019 "Information Security Technology - Basic Requirements for Network Security Level Protection" and the Southern Power Grid Information Security Assurance System Specifications, posing security risks of data leakage and unauthorized access.

[0009] Therefore, a substation test data intelligent acquisition, analysis, and automatic report generation system is needed to solve the problems of high reliance on manual labor, inaccurate analysis, cumbersome report preparation, and poor system compatibility in traditional test operations. Summary of the Invention

[0010] The purpose of this invention is to provide a substation test data intelligent acquisition, analysis and automatic report generation system to solve the problems mentioned in the background art.

[0011] To achieve the above objectives, the present invention provides the following technical solution: a substation test data intelligent acquisition, parsing, and automatic report generation system, which adopts a three-level cloud-edge-device deployment architecture, including: a mobile acquisition terminal module, a Dianhong terminal adaptation and communication module, a test data acquisition module, a data intelligent parsing module, a test report automatic generation module, a substation operation and maintenance system docking module, a data security storage module, and a fine-grained access control and auditing module;

[0012] The mobile data acquisition terminal module is equipped with the Elec-Tech operating system, which provides an interactive interface for experimental operations and multi-mode identity authentication.

[0013] The Dianhong terminal adapter and communication module is used to achieve plug-and-play, end-to-end interconnection and stable data transmission with Dianhong chemical testing instruments via the WAPI protocol.

[0014] The test data acquisition module is used to realize dual-mode access of automatic test data acquisition and manual supplementation, and to complete data standardization cleaning and verification;

[0015] The intelligent data analysis module is used for preprocessing, feature extraction, three-phase discrete quantification calculation, and automatic equipment status assessment of experimental data.

[0016] The test report automatic generation module is used to automatically generate standardized test reports based on a template engine, and to achieve version management and historical traceability;

[0017] The substation operation and maintenance system docking module is used to achieve automatic synchronization of test tasks and closed-loop data transmission with the substation production and operation support system.

[0018] The data security storage module is used to realize end-to-end encrypted data transmission, encrypted storage, and highly reliable backup.

[0019] The fine-grained access control and auditing module is used to implement four-level role access allocation and full operation audit traceability based on the RBAC model.

[0020] It should be noted in the solution that the mobile data acquisition terminal module supports three login methods: account password, SMS verification code, and facial recognition. Facial recognition has a high accuracy rate. After logging in, it automatically matches the current site information, device access status, and meteorological data, and provides standardized test operation guidance and real-time data preview function.

[0021] It is worth noting that the aforementioned Dianhong terminal adapter and communication module supports automatic discovery and plug-and-play functionality of Dianhong mechanical characteristic testers and loop resistance testers. It establishes wireless communication connections via the WAPI protocol, supports breakpoint resume and automatic reconnection after disconnection, and has a high data transmission success rate.

[0022] Furthermore, it should be noted that the experimental data acquisition module supports high-frequency automatic data acquisition, and the acquired data is automatically associated with experimental tasks, equipment ledgers, and instrument ledgers; at the same time, it provides a standardized manual data supplementation channel with built-in data verification rules for traditional experimental instruments.

[0023] As a preferred implementation, the automatic test report generation module is based on the FreeMarker template engine, with multiple built-in standardized test report templates and supports template customization; it automatically fills in basic test information, collected data, analytical conclusions and waveforms, and supports online report editing, PDF export, electronic signature and multi-version management.

[0024] As a preferred implementation, the circuit breaker mechanical characteristic analysis algorithm in the data intelligent analysis module uses the following formula to calculate the three-phase dispersion and determine the equipment status:

[0025] Let the measured values ​​of the same test parameters for circuit breakers A, B, and C be respectively... , , ;

[0026] Formula for calculating the arithmetic mean of three-phase parameters:

[0027]

[0028] Formula for calculating the relative dispersion of three-phase parameters:

[0029]

[0030] Equipment status determination rules: When When this happens, the equipment status is determined to be normal;

[0031] when When this occurs, the equipment status is determined to be "Caution," requiring enhanced monitoring and tracking.

[0032] when If the equipment is deemed to be in an abnormal state, an immediate power outage and maintenance must be arranged.

[0033] As a preferred implementation, the data security storage module uses the national cryptographic SM4 algorithm to encrypt and store sensitive data, and the transport layer uses HTTPS (TLS1.2+) encryption; it is compatible with Nanda General GBase8s, MySQL database and Redis cache, and adopts a real-time synchronization of master and backup databases + periodic backup strategy, which ensures high data reliability and meets the requirements of Level 3 of the GB / T22239-2019 network security level protection.

[0034] Compared with existing technologies, the intelligent acquisition, analysis, and automatic report generation system for substation test data provided by this invention has at least the following beneficial effects:

[0035] (1) This invention breaks the inefficient mode of traditional test operations that is "manually dominated and segmented," and constructs a fully automated closed loop of "automatic task assignment - automatic data collection - intelligent algorithm analysis - automatic report generation - automatic data archiving." By automatically collecting data to replace manual copying and input, using standardized algorithms to replace manual experience-based interpretation, and using templates to replace manual layout and compilation, it achieves seamless connection and unmanned operation of each link of the test, greatly shortens the overall operation cycle, and significantly reduces the repetitive and mechanical labor intensity of maintenance personnel. The built-in process engine of the system can automatically complete tasks such as task association, data verification, and status transition, promoting the transformation of substation testing from the traditional manual-driven mode to the data-driven intelligent operation mode, and providing core support for the upgrade of the digital substation operation and maintenance system.

[0036] (2) This invention ensures quality from the source of data. The automatic data acquisition mode completely eliminates problems such as typos and omissions caused by manual data entry, ensuring the originality and accuracy of the test data. The data intelligent analysis module eliminates noise interference through a standardized preprocessing process, extracts multi-dimensional feature parameters, and uses a unified three-phase discrete quantification algorithm to evaluate the equipment status, avoiding the subjective differences of manual interpretation and greatly improving the consistency and reliability of the evaluation results. The system can accurately identify early hidden defects of equipment, realize the transformation from "post-event maintenance" to "pre-event warning", effectively reduce the risk of equipment failure, and ensure the safe and stable operation of the power grid.

[0037] (3) This invention is the first batch of test operation systems deeply adapted to the Southern Power Grid's Dianhong operating system. It makes full use of the core features of Dianhong's distributed soft bus and unified equipment model to realize plug-and-play and end-to-end interconnection of Dianhong-based test instruments. It builds a safe and stable near-field communication network through the WAPI wireless communication protocol, which solves the problems of cumbersome wiring and poor flexibility of traditional wired connections. It realizes real-time synchronization and bidirectional flow of test data in the terminal, edge, and cloud. The application of this invention not only improves the intelligence level of the test operation itself, but also provides a typical demonstration for the promotion and application of Dianhong's ecosystem in the field of substation production, and promotes the unification and improvement of power Internet of Things standards.

[0038] (4) This invention fully realizes the adaptation of domestic IT innovation from the underlying hardware to the upper-level application, supports multiple heterogeneous computing architectures such as ARM, X86, and MIPS, is compatible with domestic operating systems such as Euler and Kylin, mainstream databases such as Nanda General and MySQL, and open source middleware such as Tomcat and Nginx, and can be seamlessly integrated into the existing domestic IT innovation technology system of China Southern Power Grid; the system adopts a microservice architecture design, with loose coupling of each module and independent upgradeability, and has good scalability and maintainability; the full-stack domestic IT innovation adaptation completely gets rid of the dependence on foreign software and hardware products, realizes the independent control of core technologies, effectively avoids the risk of "bottleneck", and provides a safe and reliable technical foundation for the digital transformation of the power grid.

[0039] (5) This invention constructs a four-in-one full-link data security protection system of "transmission encryption - storage encryption - access control - operation auditing"; the transmission layer adopts the HTTPS (TLS1.2+) encryption protocol and disables all insecure old version protocols; the storage layer adopts the national cryptographic SM4 algorithm to encrypt and store sensitive data to ensure that the data is not illegally stolen; fine-grained access control is implemented based on the RBAC model, and users with different roles can only access data and functions within the authorized scope; the full operation log recording and audit traceability function can monitor all user behaviors throughout the process and trace them afterward; this security system fully complies with the network security level protection 2.0 and the information security protection system of China Southern Power Grid, effectively ensuring the security and confidentiality of power production data.

[0040] (6) By accumulating and analyzing historical test data, this invention can uncover the operating patterns of equipment, optimize test cycles and maintenance strategies, and improve the scientificity and accuracy of operation and maintenance decisions. At the same time, the open interface architecture of the system can achieve data sharing and collaboration with other business systems of the power grid, thereby promoting the overall operation and maintenance efficiency of digital substations. Attached Figure Description

[0041] Figure 1 This is a block diagram of a substation test data intelligent acquisition, analysis, and automatic report generation system according to the present invention. Detailed Implementation

[0042] The present invention will be further described below with reference to embodiments.

[0043] Please see Figure 1 This invention provides a substation test data intelligent acquisition, parsing and automatic report generation system, which adopts a three-level cloud-edge-device deployment architecture, including: a mobile acquisition terminal module, a Dianhong terminal adaptation and communication module, a test data acquisition module, a data intelligent parsing module, a test report automatic generation module, a substation operation and support system docking module, a data security storage module, and a fine-grained permission control and auditing module;

[0044] The mobile data acquisition terminal module is equipped with the Elec-Tech operating system, which provides an interactive interface for experimental operations and multi-mode identity authentication.

[0045] Specifically, the mobile data acquisition terminal module supports three login methods: account password, SMS verification code, and facial recognition. Facial recognition has a high accuracy rate. After logging in, it automatically matches the current site information, device access status, and meteorological data, providing standardized test operation guidance and real-time data preview functions.

[0046] The Dianhong terminal adapter and communication module is used to achieve plug-and-play, end-to-end interconnection and stable data transmission with Dianhong chemical testing instruments via the WAPI protocol.

[0047] Specifically, the Elec-Hong terminal adapter and communication module supports automatic discovery and plug-and-play functionality of Elec-Hong mechanical characteristic testers and loop resistance testers, establishes wireless communication connections via the WAPI protocol, supports breakpoint resume and automatic reconnection after disconnection, and has a high data transmission success rate.

[0048] The test data acquisition module is used to realize dual-mode access of automatic test data acquisition and manual supplementation, and to complete data standardization cleaning and verification.

[0049] Specifically, the test data acquisition module supports high-frequency automatic data acquisition, and the acquired data is automatically associated with test tasks, equipment ledgers, and instrument ledgers; at the same time, it provides a standardized manual data supplementation channel with built-in data verification rules for traditional test instruments.

[0050] The intelligent data analysis module is used to preprocess test data, extract features, perform three-phase discrete quantification calculations, and automatically assess equipment status.

[0051] Specifically, the circuit breaker mechanical characteristic analysis algorithm in the data intelligent analysis module uses the following formula to calculate the three-phase dispersion and determine the equipment status:

[0052] Let the measured values ​​of the same test parameters for circuit breakers A, B, and C be respectively... , , ;

[0053] Formula for calculating the arithmetic mean of three-phase parameters:

[0054]

[0055] Formula for calculating the relative dispersion of three-phase parameters:

[0056]

[0057] Equipment status determination rules: When When this happens, the equipment status is determined to be normal;

[0058] when When this occurs, the equipment status is determined to be "Caution," requiring enhanced monitoring and tracking.

[0059] when If the equipment is deemed to be in an abnormal state, an immediate power outage and maintenance must be arranged.

[0060] The automatic test report generation module is used to automatically generate standardized test reports based on a template engine, and to achieve version management and historical traceability.

[0061] Specifically, the automatic test report generation module is based on the FreeMarker template engine, has multiple built-in standardized test report templates, and supports template customization; it automatically fills in basic test information, collected data, analytical conclusions and waveforms, and supports online report editing, PDF export, electronic signature and multi-version management.

[0062] The substation operation and maintenance system docking module is used to achieve automatic synchronization of test tasks and closed-loop data transmission with the substation production and operation support system.

[0063] The data security storage module is used to achieve end-to-end encrypted data transmission, encrypted storage, and highly reliable backup.

[0064] Specifically, the data security storage module uses the national cryptographic SM4 algorithm to encrypt and store sensitive data, and the transmission layer uses HTTPS (TLS1.2+) encryption; it is compatible with Nanda General GBase8s, MySQL database and Redis cache, and adopts a real-time synchronization of master and standby databases + regular backup strategy, which ensures high data reliability and meets the requirements of Level 3 of the GB / T22239-2019 network security level protection.

[0065] The fine-grained access control and auditing module is used to implement four-level role access allocation and full operation audit traceability based on the RBAC model.

[0066] In summary, the substation test data intelligent acquisition, analysis, and automatic report generation system provided by this invention is based on a three-level cloud-edge-device deployment architecture. Through the coordinated linkage of eight core modules, it deeply integrates the Dianhong operating system and WAPI near-field communication technology to construct an integrated intelligent operation and maintenance system covering test task synchronization, data acquisition, intelligent analysis, report generation, safety management and control, and full-process supervision.

[0067] This invention fundamentally solves common technical problems in the industry, such as high reliance on manual labor, large data acquisition errors, strong subjectivity in condition assessment, low efficiency in report preparation, poor system adaptability, and non-compliance with data security in traditional substation testing operations. It realizes intelligent, standardized, and closed-loop management of the entire substation testing operation process, while fully meeting the core requirements of China Southern Power Grid's Electric Power Ecosystem construction, information technology innovation adaptation, and network security level protection.

[0068] The technical solution of this invention is mature, highly practical, and innovative. It can be widely adapted to core operation and maintenance scenarios such as circuit breaker mechanical characteristic testing and loop resistance testing in various digital substations. It can effectively improve the operation and maintenance efficiency and status assessment accuracy of power equipment, and provide stable, reliable, and safe technical support for the construction of new power systems and the intelligent upgrading of digital substations. It has significant engineering application value and industry promotion significance.

[0069] In conclusion, the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A substation test data intelligent acquisition, analysis, and automatic report generation system, characterized in that: The system adopts a three-tier deployment architecture: cloud, edge, and terminal, including: mobile data acquisition terminal module, Dianhong terminal adaptation and communication module, test data acquisition module, intelligent data parsing module, automatic test report generation module, substation operation and maintenance system docking module, data security storage module, and fine-grained access control and auditing module. The mobile data acquisition terminal module is equipped with the Elec-Tech operating system, which provides an interactive interface for experimental operations and multi-mode identity authentication. The Dianhong terminal adapter and communication module is used to achieve plug-and-play, end-to-end interconnection and stable data transmission with Dianhong chemical testing instruments via the WAPI protocol. The test data acquisition module is used to realize dual-mode access of automatic test data acquisition and manual supplementation, and to complete data standardization cleaning and verification; The intelligent data analysis module is used for preprocessing, feature extraction, three-phase discrete quantification calculation, and automatic equipment status assessment of experimental data. The test report automatic generation module is used to automatically generate standardized test reports based on a template engine, and to achieve version management and historical traceability; The substation operation and maintenance system docking module is used to achieve automatic synchronization of test tasks and closed-loop data transmission with the substation production and operation support system. The data security storage module is used to realize end-to-end encrypted data transmission, encrypted storage, and highly reliable backup. The fine-grained access control and auditing module is used to implement four-level role access allocation and full operation audit traceability based on the RBAC model.

2. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The mobile data acquisition terminal module supports three login methods: account password, SMS verification code, and facial recognition. Facial recognition has a high accuracy rate. After logging in, it automatically matches the current site information, device access status, and meteorological data, providing standardized test operation guidance and real-time data preview functions.

3. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The Dehong terminal adapter and communication module supports automatic discovery and plug-and-play functionality for Dehong mechanical characteristic testers and loop resistance testers. It establishes wireless communication connections via the WAPI protocol, supports breakpoint resume and automatic reconnection after disconnection, and boasts a high data transmission success rate.

4. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The test data acquisition module supports high-frequency automatic data acquisition, and the acquired data is automatically associated with test tasks, equipment ledgers, and instrument ledgers; at the same time, it provides a standardized manual data supplementation channel with built-in data verification rules for traditional test instruments.

5. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The automatic test report generation module is based on the FreeMarker template engine, with multiple built-in standardized test report templates and supports template customization; it automatically fills in basic test information, collected data, analytical conclusions and waveforms, and supports online report editing, PDF export, electronic signature and multi-version management.

6. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The circuit breaker mechanical characteristic analysis algorithm in the data intelligent analysis module uses the following formula to calculate the three-phase dispersion and determine the equipment status: Let the measured values ​​of the same test parameters for circuit breakers A, B, and C be respectively... , , ; Formula for calculating the arithmetic mean of three-phase parameters: Formula for calculating the relative dispersion of three-phase parameters: Equipment status determination rules: When When this happens, the equipment status is determined to be normal; when When this occurs, the equipment status is determined to be "Caution," requiring enhanced monitoring and tracking. when If the equipment is deemed to be in an abnormal state, an immediate power outage and maintenance must be arranged.

7. The intelligent acquisition, analysis, and automatic report generation system for substation test data according to claim 1, characterized in that: The data security storage module uses the national cryptographic SM4 algorithm to encrypt and store sensitive data, and the transmission layer uses HTTPS encryption; it is compatible with Nanda General GBase8s, MySQL database and Redis cache, and adopts a real-time synchronization of master and standby databases + regular backup strategy, which ensures high data reliability and meets the requirements of Level 3 of the GB / T22239-2019 network security level protection.

Images