Power distribution network planning and construction whole process management and control method and system and storage medium

Abstract

The invention provides a power distribution network planning and construction whole process management and control method and system and a storage medium, and relates to the technical field of power systems. The method comprises the following steps: acquiring power grid business data corresponding to the whole process management and control requirements of power distribution network planning and construction from a plurality of heterogeneous business systems; based on a data warehouse technology, performing storage management on the power grid business data to obtain a database corresponding to the management and control requirements of the whole planning and construction process of the power distribution network; according to data statistical analysis requirements, data statistical analysis is carried out on the data in the database, statistical analysis results corresponding to different data statistical analysis requirements are obtained, and the data statistical analysis requirements comprise an early-stage planning requirement, a project implementation progress analysis requirement and a project achievement evaluation analysis requirement; and outputting and displaying statistical analysis results respectively corresponding to different data statistical analysis requirements. The method is used for achieving the effect of improving the data statistics efficiency and accuracy, and then efficient management and control over the whole planning and construction process of the power distribution network are achieved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of power systems, and in particular to a power distribution network planning and construction whole-process management method and system, and a storage medium. BACKGROUND

[0002] With the accelerated promotion of new power system construction, power distribution network planning and construction presents the characteristics of large number of projects, wide coverage, and complex professional collaboration. In the traditional power distribution network management mode, power distribution network infrastructure projects need to go through planning generation, feasibility study review, resource allocation decision, construction implementation, completion acceptance, settlement fixation and other key links, involving the collaborative work of multiple business departments such as planning center and infrastructure department. And the data of each link is scattered in multiple heterogeneous business systems of the power grid, forming a typical "data chimney" phenomenon.

[0003] In related technologies, complete power distribution network infrastructure project data is obtained from multiple independent business systems through manual query, collection and offline communication, and according to the power distribution network infrastructure project data, each stage in the power distribution network planning and construction process is analyzed, counted and screened. However, there are problems of low efficiency and low accuracy, which cannot meet the needs of power distribution network planning and construction management. SUMMARY

[0004] The present application provides a power distribution network planning and construction whole-process management method and system, and a storage medium, to improve the efficiency and accuracy of data statistics, and to realize efficient management and control of the whole process of power distribution network planning and construction, improve the quality of power distribution network planning, and promote power grid business.

[0005] In a first aspect, the present application provides a power distribution network planning and construction whole-process management method, comprising:

[0006] Obtaining power grid business data corresponding to power distribution network planning and construction whole-process management needs from multiple heterogeneous business systems;

[0007] Based on data warehouse technology, the power grid business data is stored and managed to obtain a database corresponding to the power distribution network planning and construction whole-process management needs;

[0008] According to the data statistical analysis needs, the data in the database is subjected to data statistical analysis to obtain statistical analysis results corresponding to different data statistical analysis needs, and the data statistical analysis needs include early planning needs, project implementation progress analysis needs and project achievement evaluation analysis needs;

[0009] Output and display the statistical analysis results corresponding to different data statistical analysis needs.

[0010] In one possible implementation, the data statistical analysis corresponding to the early planning needs comprises:

[0011] According to the early planning requirement, determine the first data required by the early planning requirement in the database;

[0012] According to the set time dimension and the region identifier, determine the power grid problem set of the region identifier in the set time dimension in the first data;

[0013] According to the problem state label, classify the power grid problem set to obtain a statistical analysis result containing power grid problems corresponding to different problem state labels, and the problem state label includes new, solved and unsolved.

[0014] In a possible implementation, the data statistical analysis corresponding to the project achievement evaluation analysis requirement includes:

[0015] According to the project achievement evaluation analysis requirement, determine the second data required by the project achievement evaluation analysis requirement in the database;

[0016] Based on the second data, according to the set early warning dimension, region identifier and project identifier, determine the statistical analysis result of the early warning information generated in the implementation process of the project associated with the project identifier under the region identifier, to provide a basis for the project achievement evaluation, and the set early warning dimension includes at least one of early warning type, early warning level, early warning region and early warning time.

[0017] In a possible implementation, the project implementation progress analysis requirement includes resource allocation plan completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0018] According to the resource allocation plan completion degree analysis requirement, determine the third data required by the resource allocation plan completion degree analysis requirement in the database;

[0019] Based on the third data, according to the project identifier and the region identifier, determine the resource allocation total amount and the resource actual completion amount corresponding to the project associated with the project identifier under the region identifier;

[0020] According to the resource allocation total amount and the resource actual completion amount, determine the statistical analysis result containing the resource allocation plan completion degree corresponding to the project identifier.

[0021] In a possible implementation, the project implementation progress analysis requirement includes milestone plan completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0022] According to the milestone plan completion degree analysis requirement, determine the fourth data required by the milestone plan completion degree analysis requirement in the database;

[0023] Based on the fourth data, according to the project identifier and the area identifier, the milestone node planned completion quantity and the milestone node actual completion quantity corresponding to the project associated with the project identifier under the area identifier are determined;

[0024] According to the milestone node planned completion quantity and the milestone node actual completion quantity, a statistical analysis result containing the milestone plan completion degree corresponding to the project identifier is determined.

[0025] In a possible implementation, the project implementation progress analysis requirement includes a project commissioning completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0026] According to the project commissioning completion degree analysis requirement, fifth data required by the project commissioning completion degree analysis requirement is determined in the database;

[0027] Based on the fifth data, according to the area identifier, the project commissioning plan quantity and the project actual commissioning quantity corresponding to the area identifier are determined;

[0028] According to the project commissioning plan quantity and the project actual commissioning quantity, a statistical analysis result containing the project commissioning completion degree corresponding to the area identifier is determined.

[0029] In a possible implementation, based on the data warehouse technology, the power grid business data is stored and managed to obtain a database corresponding to the power distribution network planning and construction whole-process management and control requirement, including:

[0030] The power grid business data is preprocessed to obtain processed business data, and the preprocessing includes data cleaning and data integration;

[0031] Based on the data warehouse technology, the processed business data is stored and managed to obtain a database corresponding to the power distribution network planning and construction whole-process management and control requirement.

[0032] In a second aspect, the present application provides a power distribution network planning and construction whole-process management and control system, including:

[0033] The acquisition module is configured to acquire power grid business data corresponding to the power distribution network planning and construction whole-process management and control requirement from a plurality of heterogeneous business systems;

[0034] The processing module is configured to store and manage the power grid business data based on the data warehouse technology to obtain a database corresponding to the power distribution network planning and construction whole-process management and control requirement;

[0035] The statistical module is configured to perform data statistical analysis on the data in the database according to the data statistical analysis requirement to obtain statistical analysis results corresponding to different data statistical analysis requirements respectively, and the data statistical analysis requirement includes the early planning requirement, the project implementation progress analysis requirement and the project achievement evaluation analysis requirement;

[0036] an output module configured to output and display the statistical analysis results corresponding to different data statistical analysis requirements respectively.

[0037] In a third aspect, the present application provides an electronic device, comprising: a memory, a processor;

[0038] The memory stores computer-executable instructions.

[0039] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the first aspect and / or various possible implementation manners of the first aspect.

[0040] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are executed by a processor to implement the first aspect and / or various possible implementation manners of the first aspect.

[0041] In a fifth aspect, the present application provides a computer program product, comprising a computer program, wherein the computer program is executed by a processor to implement the first aspect and / or various possible implementation manners of the first aspect.

[0042] The power distribution network planning and construction whole-process management and control method and system and storage medium provided by the present application obtain power grid business data corresponding to power distribution network planning and construction whole-process management and control requirements from multiple heterogeneous business systems; based on data warehouse technology, the power grid business data is stored and managed to obtain a database corresponding to power distribution network planning and construction whole-process management and control requirements; according to data statistical analysis requirements, data statistical analysis is performed on the data in the database to obtain statistical analysis results corresponding to different data statistical analysis requirements respectively, and the data statistical analysis requirements include early planning requirements, project implementation progress analysis requirements and project achievement evaluation analysis requirements; the statistical analysis results corresponding to different data statistical analysis requirements are output and displayed. The present application realizes data intercommunication between systems by uniformly and integrally managing power grid business data scattered in multiple independent systems, and improves data statistical efficiency. For each stage in the power distribution network planning and construction process, effective data statistical analysis schemes are provided respectively, and based on an automated manner, management and control efficiency and accuracy are improved, efficient management and control of the whole process of power distribution network planning and construction is realized, a solid foundation is laid for improving the work efficiency and information control ability of project management personnel, and thus the quality of power distribution network planning is improved, and power grid business is promoted. In addition, the data warehouse technology is used to store and manage multi-source power grid business data, realize multi-source heterogeneous data fusion, improve data integration capability, provide a reliable data basis for subsequent data analysis, and thus improve the reliability and efficiency of power distribution network planning and construction whole-process management and control. The statistical analysis results are displayed visually, which facilitates users to intuitively understand the information of the whole process of power distribution network planning and construction, and improves user experience. BRIEF DESCRIPTION OF DRAWINGS

[0043] The accompanying drawings, which are incorporated herein and constitute part of this specification, illustrate embodiments consistent with the application and, together with the description, further serve to explain the principles of the application.

[0044] Figure 1 A scenario diagram of the power distribution network planning and construction whole-process management and control method provided by the embodiment of the application;

[0045] Figure 2 A flowchart of the power distribution network planning and construction whole-process management and control method provided by the embodiment of the application;

[0046] Figure 3 A structure diagram of the power distribution network planning and construction whole-process management and control system provided by the embodiment of the application Figure 1 ;

[0047] Figure 4 A structure diagram of the power distribution network planning and construction whole-process management and control system provided by the embodiment of the application Figure 2 ;

[0048] Figure 5 A structure diagram of the electronic device provided by the embodiment of the application.

[0049] Through the above-mentioned drawings, the specific embodiments of the application have been shown, and will be described in more detail hereinafter. These drawings and textual descriptions are not intended to limit the scope of the concept of the application by any means, but to illustrate the concept of the application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION

[0050] The exemplary embodiments will be described in detail herein with reference to the attached drawings. The following description is made with reference to the accompanying drawings in which like reference numerals represent like elements, unless the context of use indicates otherwise. The following description of exemplary embodiments is not representative of all embodiments consistent with the application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of the application as detailed in the appended claims.

[0051] In a traditional power distribution network management mode, power distribution network infrastructure project data is usually stored in multiple independent heterogeneous business systems, data intercommunication is not realized between the business systems, and when carrying out management work on each stage of power distribution network planning and construction, relevant personnel need to obtain complete power distribution network infrastructure project data from multiple independent business systems through manual query, collection and offline communication. For key information such as project progress and resource allocation, manual collection, analysis and summary are also relied on, and data interaction is carried out through Excel, paper documents and other means. Due to the high dependence on manual work, there are problems of low efficiency and low accuracy, which affect the management and control efficiency of the whole process of power distribution network planning and construction and the quality of power distribution network planning.

[0052] To solve the above technical problems, the present application provides a power distribution network planning and construction whole process management and control method, which realizes data intercommunication between systems by integrating power grid business data in multiple independent systems, provides effective data statistical analysis schemes for each stage in the process of power distribution network planning and construction, and realizes efficient management and control of the whole process of power distribution network planning and construction based on an automated manner.

[0053] The technical solutions of the present application and how the technical solutions of the present application solve the above technical problems will be described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes can not be described again in some embodiments. The embodiments of the present application will be described below with reference to the drawings.

[0054] Figure 1 The scene schematic diagram of the power distribution network planning and construction whole process management and control method provided by the embodiments of the present application is provided, and the specific application scene of the present application involves multiple heterogeneous business systems, a computing device 11 and a display device 12. The heterogeneous business systems can be deployed in at least one server, the computing device 11 is deployed with the power distribution network planning and construction whole process management and control method provided by the embodiments of the present application, the computing device 11 is in communication connection with the multiple heterogeneous business systems, different power grid business data can be obtained from the multiple heterogeneous business systems, and the power distribution network planning and construction whole process management and control method provided by the embodiments of the present application can be executed, and finally the statistical analysis results corresponding to different data statistical analysis requirements are output and displayed through the display device 12.

[0055] It should be noted that, Figure 1The application scenarios shown are only illustrative examples. The computing device 11 is a device with a certain computing power, which can be a laptop, a desktop computer, a workstation, a personal digital assistant, etc. The computing device 11 can also be a server, a virtual resource, or a server cluster. In addition, the number of computing devices 11 is not limited in the embodiments of the present application, and multiple computing devices can cooperatively complete the power distribution network planning and construction whole-process management and control method provided by the embodiments of the present application. The display device 12 can be a notebook, a desktop computer, a personal digital assistant, a visual large screen, etc.

[0056] The power distribution network planning and construction whole-process management and control method provided by the embodiments of the present application will be described below in combination with Figure 1 application scenarios, with reference to Figure 2 The power distribution network planning and construction whole-process management and control method provided by the embodiments of the present application is executed by the computing device 11 in Figure 1 It should be noted that the above-mentioned application scenarios are only shown for the purpose of facilitating the understanding of the spirit and principles of the present application, and the implementation manners of the present application are not limited by the application scenarios shown in Figure 1

[0057] Figure 2 The flowchart of the power distribution network planning and construction whole-process management and control method provided by the embodiments of the present application is shown in FIG. 2. It should be noted that the power distribution network planning and construction whole-process management and control method is applied to a power distribution network planning and construction whole-process management and control system (or platform), for example, the power distribution network planning and construction whole-process management and control system (or platform) is deployed on the computing device 11, and the display device 12 provides a visual front-end display interface for the user. As shown in Figure 2 The power distribution network planning and construction whole-process management and control method includes the following steps.

[0058] S201, obtaining power grid business data corresponding to power distribution network planning and construction whole-process management and control requirements from a plurality of heterogeneous business systems.

[0059] The power grid business data includes but is not limited to power grid problem data, user distribution data, line contact data, equipment asset data, project resource allocation data, project milestone node data, project commissioning data, project early warning data, equipment problem data, project problem data, etc.

[0060] For example, different types of power grid business data are generated in different business systems (such as planning systems, operation and maintenance systems, power grid management systems, etc.). The power distribution network planning and construction whole-process management and control system and the plurality of heterogeneous business systems can integrate and share multi-source data through a unified data interface and protocol.

[0061] S202, storing and managing the power grid business data based on data warehouse technology to obtain a database corresponding to the power distribution network planning and construction whole-process management and control requirements.

[0062] ​The data warehouse technology is used for integrating multi-source data, eliminating redundancy, and forming a unified data view. For example, by extracting, transforming, and loading the power grid business data, the data of different types (such as structured data, unstructured data, semi-structured data, time series data, and spatial data related to geographic location) from multiple heterogeneous business systems are unified in format, redundancy is eliminated, data consistency is ensured, the integrated data is stored in partitions, and a database corresponding to the demand for management and control of the whole process of power distribution network planning and construction is obtained.

[0063] By using the high-performance advantage of the data warehouse technology, mass data storage and high-concurrency query are realized, and efficiency is improved.

[0064] In addition, the database can be backed up in various ways such as full backup, incremental backup, etc., to ensure that the power distribution network planning and construction management and control system can be quickly restored and maintain data consistency in the event of a fault.

[0065] S203. According to the data statistical analysis demand, data statistical analysis is performed on the data in the database, and statistical analysis results corresponding to different data statistical analysis demands are obtained. The data statistical analysis demand includes pre-planning demand, project implementation progress analysis demand, and project achievement evaluation analysis demand.

[0066] It can be understood that for the whole process of power distribution network planning and construction involving pre-planning, project implementation progress, and project achievement evaluation, different data statistical analysis demands are involved for different stages, and the data characteristics required by different data statistical analysis demands are different.

[0067] For example, the data required by the pre-planning demand includes power grid problems (problem type, distribution area, problem source, verification degree, etc.), single-line diagram user distribution data (low-voltage user quantity, distribution area, user detailed information on branch line, etc.), and line contact diagram information (operation state of device or line node, device model, etc.); the data required by the project implementation progress analysis demand includes project information (quantity, time of issuance, type, belonging area, total budget, etc.), resource allocation information (resource allocation plan, resource usage, etc.), milestone plan completion information (milestone node completion time, milestone node planned time, responsible person corresponding to the milestone node, etc.), and project commissioning information; and the data required by the project achievement evaluation analysis demand includes project evaluation data (evaluation problem quantity, evaluation device, etc.), project implementation process warning information (warning project name, warning reason, warning influence range, measures taken, etc.).

[0068] By extracting valuable information from the database for statistical analysis, scientific data support is provided for power distribution network planning.

[0069] S204, output and display the statistical analysis result corresponding to different data statistical analysis requirements respectively.

[0070] For example, on the front-end interface of the display device 12, the statistical analysis result involved in the whole process of power distribution network planning and construction is intuitively displayed to the business personnel in the form of charts, maps, reports and the like, so as to assist the business personnel in comprehensively managing and controlling the whole process of power distribution network planning and construction.

[0071] Alternatively, the business personnel can also perform data filtering, drilling down, exporting and the like through the interactive interface, so as to obtain more detailed and personalized power distribution network planning information.

[0072] In the embodiments of the present application, the power grid business data scattered in multiple independent systems is uniformly integrated and managed, data intercommunication between systems is realized, and data statistical efficiency is improved. For each stage in the process of power distribution network planning and construction, an effective data statistical analysis scheme is respectively provided, and based on an automated manner, management and control efficiency and accuracy are improved, efficient management and control of the whole process of power distribution network planning and construction is realized, a solid foundation is laid for improving the work efficiency and information control ability of project management personnel, and then the quality of power distribution network planning is improved, and power grid business is promoted. In addition, the data warehouse technology is adopted to store and manage the multi-source power grid business data, multi-source heterogeneous data fusion is realized, data integration capability is improved, a reliable data basis is provided for subsequent data analysis, and then the reliability and efficiency of management and control of the whole process of power distribution network planning and construction are improved. The statistical analysis result is visually displayed, it is convenient for users to intuitively understand the information of the whole process of power distribution network planning and construction, and user experience is improved.

[0073] In some embodiments, the data statistical analysis corresponding to the early planning requirement includes:

[0074] Step 1.1, according to the early planning requirement, determining first data required by the early planning requirement in the database.

[0075] The database stores a large amount of power grid business data from different business systems, including real-time data and historical data. In order to improve data applicability and statistical efficiency when performing data statistical analysis, the most directly related data fields can be preliminarily filtered from the database as the basis data of the target requirement according to the target requirement (herein referred to as the early planning requirement).

[0076] For example, according to the filtering rule predefined according to the early planning requirement, the first data satisfying the filtering rule is filtered out in the database, and the first data mainly includes various power grid problems in the power distribution network coverage area, and the first data is equivalent to a problem library.

[0077] Step 1.2, according to the set time dimension and the region identifier, determining a power grid problem set of the region identifier in the set time dimension in the first data.

[0078] The region identifier can uniquely represent a specific region in the entire power distribution network coverage, such as a city, a county, or a street. The time dimension includes month, week, year, day, and the like.

[0079] For example, in the month dimension, the power grid problems of each month for different region identifiers are counted respectively to obtain a monthly power grid problem set corresponding to different region identifiers.

[0080] Step 1.3, classify the power grid problem set according to the problem state label to obtain a statistical analysis result containing power grid problems corresponding to different problem state labels, including new, solved, and unsolved.

[0081] The power grid problem set can contain power grid problems in different states, such as solved, unsolved, and new. In order to intuitively and clearly present the problem situation of various states, the power grid problem set is classified according to the problem state label, and a statistical analysis result containing new problems, solved problems, and unsolved problems is obtained.

[0082] For example, in the month or week time dimension, the new power grid problems are counted. The number of new problems in different time periods can also be clearly presented through time filtering to help business personnel timely grasp the problem new dynamic. Alternatively, the number of solved and unsolved power grid problems is counted respectively, so that business personnel can evaluate the progress and effect of problem solving by comparing the number of solved and unsolved problems in different time periods.

[0083] The embodiments of the present application automatically analyze various power grid problems in the power distribution network coverage area, which facilitates business personnel to timely grasp the problem new dynamic and evaluate the progress and effect of problem solving, provides strong data support for problem closed-loop rectification, realizes efficient management and control of the power distribution network planning and construction pre-planning stage, and improves the work efficiency and information control ability of project management personnel.

[0084] In some embodiments, the data statistical analysis corresponding to the project achievement evaluation and analysis requirement includes:

[0085] Step 2.1, according to the project achievement evaluation and analysis requirement, determine the second data required by the project achievement evaluation and analysis requirement in the database.

[0086] For example, according to the filtering rule predefined according to the project achievement evaluation and analysis requirement, the second data satisfying the filtering rule is filtered out in the database, and the second data mainly includes early warning information in the implementation process of each project in the power distribution network coverage area.

[0087] Step 2.2, based on the second data, according to the set early warning dimension, region identifier and project identifier, determine the statistical analysis result of the early warning information generated in the implementation process of the project associated with the project identifier under the region identifier, to provide basis for project achievement evaluation, and set the early warning dimension including at least one of early warning type, early warning level, early warning region and early warning time.

[0088] In practical application, there may be multiple regions (counties, cities) implementing the same project, therefore, a specific project can be uniquely determined through the project identifier and the region identifier. The early warning information is not limited to including early warning project name, early warning reason, early warning influence range, and measures taken.

[0089] For example, taking the early warning type and the early warning level as the dimension, the early warning information generated in the implementation process of each project identifier under different region identifiers is respectively counted, to obtain the early warning information corresponding to each project identifier associated with the project under different region identifiers.

[0090] In the embodiments of the present application, the early warning information in the implementation process of the project is statistically analyzed, which facilitates business personnel to discover and solve potential problems in time, and further develop effective coping strategies. In addition, the early warning information in the implementation process of the project is comprehensively statistically analyzed through multiple dimensions, which facilitates business personnel to master the overall distribution and change trend of early warning, provides a macroscopic perspective for early warning processing, and realizes efficient management and control of the achievement evaluation stage of the power distribution network planning and construction project.

[0091] In some embodiments, the project implementation progress analysis requirement includes resource allocation plan completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0092] Step 3.1, according to the resource allocation plan completion degree analysis requirement, determine the third data required for the resource allocation plan completion degree analysis requirement in the database.

[0093] For example, according to the screening rule predefined according to the resource allocation plan completion degree analysis requirement, the third data meeting the screening rule is screened out in the database, and the third data mainly includes the total amount of resource allocation (such as planned cost) and the actual completed resource amount (such as cost actually invested) of each project in the power distribution network coverage area.

[0094] Step 3.2, based on the third data, according to the project identifier and the region identifier, determine the total amount of resource allocation and the actual completed resource amount corresponding to the project associated with the project identifier under the region identifier.

[0095] A specific project can be uniquely determined by the project identifier and the region identifier. The total resource allocation and the actual resource completion of the project corresponding to each project identifier under different region identifiers are counted respectively, and the total resource allocation and the actual resource completion of the project corresponding to each project identifier under different region identifiers are obtained.

[0096] Step 3.3, determining the statistical analysis result of the resource allocation plan completion degree corresponding to the project identifier according to the total resource allocation and the actual resource completion.

[0097] For example, the total resource allocation corresponding to the project identifier X is A, and the actual resource completion is B. The resource allocation plan completion degree corresponding to the project identifier X is B / A.

[0098] Optionally, the statistics can be classified according to the region and the project batch, and the statistical report can be generated and displayed subsequently. The resource allocation plan completion degree of the project corresponding to each region identifier can also be statistically analyzed in a set time dimension, so as to evaluate the execution effect and the resource allocation efficiency of the resource allocation plan by comparing the resource allocation plan completion degrees at different times.

[0099] In the embodiments of the present application, the resource allocation plan completion degrees of the projects in the power distribution network coverage area are statistically analyzed, so that the business personnel can comprehensively understand the resource allocation execution, master the project implementation progress, and then timely adjust the project management strategy, improve the project management efficiency, and realize efficient management and control of the project implementation progress stage of the power distribution network planning and construction project.

[0100] In some embodiments, the project implementation progress analysis requirement includes the milestone plan completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0101] Step 4.1, determining the fourth data required by the milestone plan completion degree analysis requirement in the database according to the milestone plan completion degree analysis requirement.

[0102] For example, the fourth data satisfying the filtering rule is filtered out in the database according to the filtering rule predefined according to the milestone plan completion degree analysis requirement. The fourth data mainly includes the milestone nodes of the projects in the power distribution network coverage area, the actual completion time of the milestone nodes, the planned time of the milestone nodes, the planned completion amount of the milestone nodes, and the actual completion amount of the milestone nodes.

[0103] Step 4.2, determining the planned completion amount of the milestone node and the actual completion amount of the milestone node corresponding to the project associated with the project identifier under the region identifier according to the project identifier and the region identifier based on the fourth data.

[0104] The milestone node planned completion quantity and the milestone node actual completion quantity corresponding to each project identifier associated with different region identifiers are respectively counted, to obtain the milestone node planned completion quantity and the milestone node actual completion quantity corresponding to each project identifier associated with different region identifiers.

[0105] Step 4.3. Determine the statistical analysis result containing the milestone plan completion degree corresponding to the project identifier according to the milestone node planned completion quantity and the milestone node actual completion quantity.

[0106] For example, the milestone node planned completion quantity corresponding to the project identifier y is C, and the milestone node actual completion quantity is D. The milestone plan completion degree corresponding to the project identifier y is D / C.

[0107] According to the statistical analysis of the milestone plan completion degree of each project in the power distribution network coverage area, the business personnel can comprehensively understand the milestone plan execution, master the project implementation progress, and then timely adjust the project management strategy, improve the project management efficiency, and realize the efficient management and control of the power distribution network planning and construction project implementation progress stage.

[0108] In some embodiments, the project implementation progress analysis requirement includes a project commissioning completion degree analysis requirement, and the data statistical analysis corresponding to the project implementation progress analysis requirement includes:

[0109] Step 5.1. Determine the fifth data required by the project commissioning completion degree analysis requirement in the database according to the project commissioning completion degree analysis requirement.

[0110] For example, according to the screening rule predefined according to the project commissioning completion degree analysis requirement, the fifth data satisfying the screening rule is screened out in the database. The fifth data mainly includes the commissioning data of the project in the power distribution network coverage area, and the commissioning data is not limited to including the planned commissioning time, the actual commissioning time, the commissioning type, the commissioning distribution, the commissioning scale, etc.

[0111] Step 5.2. Determine the project commissioning plan quantity and the project actual commissioning quantity corresponding to the region identifier based on the fifth data according to the region identifier.

[0112] The actual commissioning time and the planned commissioning time of all projects under the region identifier are respectively counted, to obtain the project actual commissioning quantity and the project commissioning plan quantity.

[0113] Step 5.3. Determine the statistical analysis result containing the project commissioning completion degree corresponding to the region identifier according to the project commissioning plan quantity and the project actual commissioning quantity.

[0114] For example, the project commissioning plan quantity corresponding to the region identifier z is E, and the actual project commissioning quantity is F. The project commissioning completion degree corresponding to the region identifier z is F / E.

[0115] Optionally, the project commissioning completion degrees of different region identifiers can be compared and analyzed to generate a project commissioning completion degree comparison chart, further analyze the reasons for the differences in the project commissioning completion degrees, and provide improvement suggestions.

[0116] In the embodiments of the present application, the commissioning data of the projects in the distribution network coverage area are analyzed, which facilitates business personnel to comprehensively understand the commissioning of the projects, and further adjust the project management strategy in a timely manner, improve the project management efficiency, and realize efficient management and control of the implementation progress stage of the distribution network planning and construction project.

[0117] In some embodiments, based on data warehouse technology, power grid business data is stored and managed to obtain a database corresponding to the whole-process management and control requirement of the distribution network planning and construction, including: preprocessing the power grid business data to obtain processed business data, the preprocessing including data cleaning and data integration; based on data warehouse technology, the processed business data is stored and managed to obtain a database corresponding to the whole-process management and control requirement of the distribution network planning and construction.

[0118] The data cleaning includes missing value processing, abnormal value detection, and duplicate data processing. The data integration includes data merging (such as merging data of different tables and data of different time ranges) and unit unification (such as unifying power units to KW).

[0119] Further, after the data preprocessing link is completed, in order to effectively realize the storage and management of data, data warehouse technology is used for data integration and storage. The specific implementation manner is as follows:

[0120] Step 6.1, data warehouse architecture building: based on the whole-process management and control requirement of the distribution network planning and construction, a reasonable data model is designed, including dimension tables and fact tables, to support multi-dimensional data analysis. According to the data time attribute factor, a data partitioning strategy is formulated to reasonably distribute data on different physical storages.

[0121] Step 6.2, data loading and storage: using batch loading tools, the preprocessed data is efficiently loaded into the data warehouse.

[0122] Step 6.3, data warehouse management: a metadata management system is established to record the source, processing process, storage location and other information of the data, providing support for the maintenance and management of the data warehouse. And using backup tools for data backup, ensuring the safety and recoverability of the data.

[0123] The embodiments of the present application ensure the quality and consistency of data by preprocessing the power grid business data from multiple sources, and improve the efficiency and accuracy of subsequent statistical analysis. The data warehouse technology is used to integrate and store the processed business data, improve the data integration capability, provide a reliable data basis for subsequent data analysis, and further improve the reliability and efficiency of the whole process management and control of distribution network planning and construction.

[0124] Figure 3 Structure of the whole process management and control system of distribution network planning and construction provided by the embodiments of the present application Figure 1 As shown in Figure 3 The whole process management and control system of distribution network planning and construction 30 includes an acquisition module 31, a processing module 32, a statistical module 33 and an output module 34. Among them:

[0125] The acquisition module 31 is configured to acquire power grid business data corresponding to the whole process management and control requirement of distribution network planning and construction from multiple heterogeneous business systems;

[0126] The processing module 32 is configured to store and manage the power grid business data based on the data warehouse technology, and obtain a database corresponding to the whole process management and control requirement of distribution network planning and construction;

[0127] The statistical module 33 is configured to perform data statistical analysis on the data in the database according to data statistical analysis requirements, and obtain statistical analysis results corresponding to different data statistical analysis requirements respectively, wherein the data statistical analysis requirements include early planning requirements, project implementation progress analysis requirements and project achievement evaluation analysis requirements;

[0128] The output module 34 is configured to output and display the statistical analysis results corresponding to different data statistical analysis requirements respectively.

[0129] In one possible implementation, the statistical module 33 is specifically configured to: determine first data required by the early planning requirement in the database according to the early planning requirement; determine a set of power grid problems of the regional identifier within the set time dimension in the first data according to the set time dimension and the regional identifier; and classify the set of power grid problems according to a problem state label to obtain a statistical analysis result containing power grid problems corresponding to different problem state labels, wherein the problem state label includes new, solved and unsolved.

[0130] In a possible implementation, the statistical module 33 is further configured to: determine, according to the project result evaluation analysis requirement, second data required by the project result evaluation analysis requirement in the database; and determine, based on the second data, a statistical analysis result of generating early warning information in an implementation process of a project associated with the project identifier under the region identifier, according to the set early warning dimension, the region identifier and the project identifier, to provide a basis for the project result evaluation, wherein the early warning dimension comprises at least one of an early warning type, an early warning level, an early warning region and an early warning time.

[0131] In a possible implementation, the project implementation progress analysis requirement comprises a resource allocation plan completion degree analysis requirement, and the statistical module 33 is further configured to: determine, according to the resource allocation plan completion degree analysis requirement, third data required by the resource allocation plan completion degree analysis requirement in the database; determine, based on the third data, a total resource allocation amount and an actual resource completion amount corresponding to the project associated with the project identifier under the region identifier, according to the project identifier and the region identifier; and determine a statistical analysis result comprising a resource allocation plan completion degree corresponding to the project identifier, according to the total resource allocation amount and the actual resource completion amount.

[0132] In a possible implementation, the project implementation progress analysis requirement comprises a milestone plan completion degree analysis requirement, and the statistical module 33 is further configured to: determine, according to the milestone plan completion degree analysis requirement, fourth data required by the milestone plan completion degree analysis requirement in the database; determine, based on the fourth data, a milestone node plan completion amount and a milestone node actual completion amount corresponding to the project associated with the project identifier under the region identifier, according to the project identifier and the region identifier; and determine a statistical analysis result comprising a milestone plan completion degree corresponding to the project identifier, according to the milestone node plan completion amount and the milestone node actual completion amount.

[0133] In a possible implementation, the project implementation progress analysis requirement comprises a project commissioning completion degree analysis requirement, and the statistical module 33 is further configured to: determine, according to the project commissioning completion degree analysis requirement, fifth data required by the project commissioning completion degree analysis requirement in the database; determine, based on the fifth data, a project commissioning plan amount and a project actual commissioning amount corresponding to the region identifier, according to the region identifier; and determine a statistical analysis result comprising a project commissioning completion degree corresponding to the region identifier, according to the project commissioning plan amount and the project actual commissioning amount.

[0134] In a possible implementation, the processing module 32 is specifically configured to: perform preprocessing on the power grid business data to obtain processed business data, wherein the preprocessing comprises data cleaning and data integration; and perform storage management on the processed business data based on a data warehouse technology to obtain the database corresponding to the power distribution network planning and construction whole-process management requirement.

[0135] It is worth mentioning that from the perspective of system architecture, the statistical module and the output module can be further replaced by the preliminary planning module, the project implementation progress analysis module and the project achievement evaluation analysis module. The data transmission and interaction between the modules in the power distribution network planning and construction whole process management system are carried out through standardized interfaces, so as to ensure the stability and scalability of the system.

[0136] Therefore, next, by Figure 4 The power distribution network planning and construction whole process management system is further described, Figure 4 The structure of the power distribution network planning and construction whole process management system provided by the embodiment of the present application is shown Figure 2 .

[0137] As Figure 4 shown, the power distribution network planning and construction whole process management system 30 includes an acquisition module 31, a processing module 32, a preliminary planning module 35, a project implementation progress analysis module 36 and a project achievement evaluation analysis module 37. Among them:

[0138] The preliminary planning module 35 includes a problem library collection sub-module 351, a single-line diagram user distribution sub-module 352, a line connection sketch sub-module 353 and an asset level device information sub-module 354.

[0139] The problem library collection sub-module 351 is used to statistically and display the overall and newly added situation of the target area (the whole city, each district and county bureau) in the aspect of power grid problem collection. Specifically, the following functional units are covered:

[0140] The problem total number analysis unit is used to statistically analyze the total number of all power grid problems collected in the problem library, accurately calculate the total number of various types of power grid problems contained in the current problem library, and provide basic data for subsequent analysis. The problem total number analysis unit automatically scans the problem library, aggregates the number of various types of problems, generates total number statistical results and displays them.

[0141] The newly added problem statistical unit is used to statistically analyze the newly added power grid problems in a set time dimension (such as a month or a week). Through time filtering, the number change trend of newly added problems in different time periods is clearly presented, helping business personnel to timely master the problem addition dynamics. In addition, when the business personnel selects the time dimension of month or week, the newly added problem statistical unit counts and displays the number of newly added problems in the selected time range.

[0142] The solved and unsolved problem statistics unit is used to respectively count the number of solved and unsolved power grid problems in a set time dimension (such as a month or a week). By comparing the changes in the number of solved and unsolved problems in different time periods, the progress and effect of problem solving work can be evaluated. In addition, when the business personnel selects the time dimension of a month or a week, the solved and unsolved problem statistics unit respectively counts and displays the number of solved and unsolved problems in the selected time range.

[0143] The analysis data export unit is used to support exporting analysis data of each dimension (such as the total number of problems, new problems, solved and unsolved problems, etc.) into common file formats (such as Excel, CSV, etc.), facilitating further data processing, analysis, or sharing with others by business personnel. Business personnel select the data dimension and file format to be exported in the system and click the export button, and the analysis data export unit automatically generates and downloads the corresponding file.

[0144] The large screen index drilling function unit is used to provide index drilling function in large screen display mode. When the business personnel clicks on a certain index, the large screen index drilling function unit can display detailed information of the index, such as the specific type of the problem, the distribution area, etc., helping the business personnel to fully understand the problem situation. Business personnel click on the index of interest on the large screen, and the large screen index drilling function unit automatically pops up a detailed information display window to display detailed data and related analysis of the index.

[0145] The content filtering box unit is used to set the content filtering box, allowing business personnel to filter problems in the problem library according to problem type, problem source, problem severity, etc., quickly locate the required problem information, and improve information retrieval efficiency. Business personnel select the corresponding filtering conditions in the filtering box, and the content filtering box unit automatically filters and displays the problem information that meets the requirements according to the conditions.

[0146] The line chart user distribution submodule 352 is used to count and display the distribution of users of each section and branch line of the specific line in the target area (the whole city, each district and county bureau), specifically covering the following function units:

[0147] The medium and low voltage user analysis unit is used to analyze the medium and low voltage users in the line in detail, count the number and distribution area of different types of medium and low voltage users, etc., and provide data support for user distribution in power grid planning, operation and maintenance, etc. The medium and low voltage user analysis unit automatically collects the data of medium and low voltage users in the line, calculates and analyzes according to the preset analysis rules, generates analysis results and displays them.

[0148] The data information export unit is configured to support exporting relevant data of the single-line graph user distribution into a file format, so as to facilitate business personnel to use the data in other analysis tools or share the data. The business personnel selects data content to be exported in the system and clicks an export button, and the data information export unit automatically generates and downloads a corresponding file.

[0149] The information drilling function unit is configured to provide an information drilling function. When the business personnel clicks a line segment or a branch line, the information drilling function unit can deeply display detailed information of users on the segment or the branch line, such as user types and power consumption, to help the business personnel deeply understand user distribution details. The business personnel clicks a segment or a branch line of interest on the single-line graph, and the information drilling function unit automatically pops up a detailed information display window to display detailed data of users on the segment or the branch line.

[0150] The region screening unit is configured to set a region screening function, allowing the business personnel to screen the single-line graph user distribution according to different regions and quickly view user distribution information of a specific region. The business personnel selects a corresponding region in a screening box, and the system automatically displays the single-line graph user distribution of the region according to the selection.

[0151] The main line and branch line filtering unit is configured to provide a main line and branch line filtering function. The business personnel can select to display or hide user distribution information of the main line or the branch line according to needs, so that the display is clearer and more targeted. The business personnel selects a corresponding filtering condition in the system, and the system automatically adjusts the display of user distribution information of the main line or the branch line on the single-line graph according to the condition.

[0152] The line connection diagram sub-module 353 is configured to process and display a connection diagram of a specific line in a target region (the whole city, a district or county bureau). The following function units are included:

[0153] The information drilling function unit is configured to provide an information drilling function when displaying the line connection diagram. When the business personnel clicks a device or a line node in the diagram, the system can deeply display detailed information of the device or the node, such as a device model and a running state, to help the business personnel comprehensively understand the line connection. The business personnel clicks a device or a node of interest on the connection diagram, and the system automatically pops up a detailed information display window to display detailed data of the device or the node.

[0154] The data information export unit is configured to support exporting relevant data of the line connection diagram into a file format, so as to facilitate the business personnel to use the data for other purposes or share the data. The business personnel selects data content to be exported in the system and clicks an export button, and the system automatically generates and downloads a corresponding file.

[0155] The time range screening unit is configured to set a time range screening function, allowing business personnel to view changes in the line connection diagram according to different time ranges and understand the status of the line connection in different time periods. The business personnel selects a corresponding time range in the screening box, and the system automatically displays the line connection diagram in the time period according to the selection.

[0156] The keyword search unit is configured to provide a keyword search function, and the business personnel can quickly locate the relevant line connection diagram information by inputting device names, line numbers, and other keywords, thereby improving the information retrieval efficiency. The business personnel inputs a keyword in the search box, and the system automatically searches and displays the line connection diagram information related to the keyword.

[0157] The asset-level device information submodule 354 is configured to query and display asset card information of asset-level devices. The following functional units are specifically covered:

[0158] The device classification unit is configured to classify and display asset-level devices, classify device information according to classification standards such as device type (e.g., transformer, switch cabinet, etc.) and purpose, and facilitate business personnel to quickly find the required device information. The device classification unit automatically classifies device information according to preset classification rules, and the business personnel selects a corresponding device type in the classification list, and the system displays the asset card information of the device of the type.

[0159] The device information drilling unit is configured to provide a device information drilling function. When the business personnel clicks on an asset card of a device, the device information drilling unit can display detailed information of the device, such as device parameters, operation records, and maintenance history, to help the business personnel fully understand the device. The business personnel clicks on a device of interest in the device list, and the system automatically pops up a detailed information display window to display detailed data of the device.

[0160] The device information analysis unit is configured to analyze information of asset-level devices, such as statistics of device operation time, failure rate, and maintenance cost, to provide data support for device management and update decisions. The device information analysis unit automatically collects device information, calculates and analyzes the information according to preset analysis rules, generates analysis results, and displays the results.

[0161] The project implementation progress analysis module 36 includes a resource allocation plan issuance module 361, a resource allocation plan completion module 362, a milestone plan completion module 363, a project overall commissioning module 364, a project classification commissioning module 365, and a project implementation module 366.

[0162] The resource allocation plan issuance module 361 is configured to statistically display the overall and newly issued project situation of the target area (the whole city, the district and county bureau). The following functional units are specifically covered:

[0163] The number of projects issued statistics unit is used to accurately count the number of projects issued in the target area (the whole city, each district and county bureau), covering the total number of projects issued and the number of projects in different time periods (such as newly issued projects), providing data basis for comprehensively understanding the scale of project issuance. The number of projects issued statistics unit automatically scans the project issuance records, aggregates the number of projects in different regions and time periods, generates statistical results and displays.

[0164] The number of industry expansion and emergency projects analysis unit is used to deeply analyze the number of industry expansion and emergency projects, and compare the distribution differences of the two in different regions and time periods, which helps to evaluate the business expansion demand and emergency project processing pressure. The number of industry expansion and emergency projects analysis unit respectively counts the number of industry expansion and emergency projects according to the project type label, and conducts comparative analysis in the region and time dimension, and displays the analysis results.

[0165] The annual resource allocation quota analysis unit is used to analyze the resource allocation quota of each annual project in detail, and count the total annual resource allocation amount in different regions and the allocation of the total resource allocation amount in different project types, providing reference for resource allocation decision. The annual resource allocation quota analysis unit collects project resource allocation quota data, classifies and aggregates according to the year and region, analyzes the distribution and trend of resource allocation quota, and displays the analysis report.

[0166] The information drilling function unit provides information drilling function. When the business personnel clicks on the issued project information of a certain region or time period, the system can deeply display the detailed information of the specific project in that region or time period, such as project name, resource allocation quota, project type, etc., to facilitate the business personnel to deeply understand the project issuance details. When the business personnel clicks on the region or time period of interest on the display interface, the system automatically pops up a detailed information display window to display the detailed data of the specific project in that region or time period.

[0167] The resource allocation plan completion module 362 is used to statistically display the total and each batch of project resource allocation completion in the target area (the whole city, each district and county bureau). Specifically, it includes the following function units:

[0168] The resource allocation quota statistics unit is used to respectively count the total resource allocation amount and the actual completion amount of each batch of projects in the target area, and intuitively display the execution of the resource allocation plan and the use of the resource allocation. The resource allocation quota statistics unit extracts the total resource allocation amount and the actual completion amount from the database, classifies and aggregates according to the region and batch, generates a statistical report and displays it.

[0169] Annual resource allocation completion analysis unit: analyzes the resource allocation plan completion of each regional project by year as the time dimension. By comparing the resource allocation plan completion of different years, the execution effect and resource allocation efficiency of the resource allocation plan are evaluated. The annual resource allocation completion analysis unit calculates the resource allocation plan completion of each regional project in each year (resource actual completion amount / resource allocation total amount), generates an annual resource allocation plan completion analysis chart, and displays the analysis results.

[0170] The information export unit is used to support the export of resource allocation plan completion related data to common file formats (such as Excel, CSV, etc.), facilitating further data processing, analysis, or sharing with others by business personnel. Business personnel select the data content and file format to be exported in the system and click the export button. The system automatically generates and downloads the corresponding file.

[0171] The resource allocation situation drilling function unit is used to provide resource allocation situation drilling function. When business personnel click on the resource allocation plan completion information of a certain region or batch, the system can deeply display the resource allocation plan completion details of specific projects within the region or batch, such as resource allocation progress and resource usage details, helping business personnel to fully understand the resource allocation plan execution situation. Business personnel click on the region or batch of interest on the display interface, and the system automatically pops up a detailed information display window to display the resource allocation plan completion detailed data of specific projects within the region or batch.

[0172] Milestone plan completion module 363 is used to statistically display the milestone plan completion of target regions (the whole city, each district and county bureau). It specifically covers the following functional units:

[0173] The milestone detailed analysis unit is used to analyze the milestone plan of the project in detail, including the setting of the milestone node, the actual completion time, the deviation from the planned time, etc., to evaluate the execution of the project milestone plan. The milestone detailed analysis unit collects project milestone plan data and actual completion data, conducts comparative analysis, generates a milestone detailed analysis report, and displays the analysis results.

[0174] The milestone completion degree statistical unit is used to statistically display the milestone plan completion degree of the target region, i.e. the ratio of the actual completion amount of the milestone node to the planned completion amount of the milestone node, directly reflecting the completion degree of the project milestone plan. The milestone completion degree statistical unit calculates the milestone plan completion degree of each regional project, generates a milestone plan completion degree statistical chart, and displays the statistical results.

[0175] The target area screening unit is configured to set a target area screening function, allowing business personnel to screen the milestone plan completion according to different target areas, and quickly view the project milestone plan completion of a specific target area. The business personnel selects the corresponding target area in the screening box, and the system automatically displays the project milestone plan completion of the target area according to the selection.

[0176] The detail drilling function unit is configured to provide a detail drilling function. When the business personnel clicks the milestone plan completion information of a project, the system can deeply display the specific milestone node completion details of the project, such as the completion time, responsible person, and completion condition description of each milestone node, to facilitate the business personnel to deeply understand the project milestone execution details. The business personnel clicks the interested project on the display interface, and the system automatically pops up a detailed information display window to display the specific milestone node completion details of the project.

[0177] The data result exporting unit is configured to support exporting the related data of the milestone plan completion into a file format, to facilitate the business personnel to use the data in other analysis tools or for data sharing. The business personnel selects the data content to be exported in the system, and clicks the export button, and the system automatically generates and downloads the corresponding file.

[0178] The project overall commissioning module 364 is configured to statistically display the overall and batch project commissioning completion of the target area (the whole city, and each district and county bureau). The following function units are specifically covered:

[0179] The project commissioning situation analysis unit is configured to comprehensively analyze the commissioning situation of the project, including the number, type, and distribution area of the commissioned projects, to evaluate the overall scale and effect of the project commissioning. The project commissioning situation analysis unit collects the project commissioning data, performs classification statistics and analysis, generates a project commissioning situation analysis report, and displays the analysis result.

[0180] The commissioning completion degree comparison unit is configured to compare the commissioning completion degrees of different regions and different batches of projects, to find out the regions or batches with higher and lower commissioning completion degrees, analyze the reasons, and propose improvement measures. The commissioning completion degree comparison unit calculates the commissioning completion degrees (actual commissioning amount / project commissioning plan amount) of each region and each batch of projects, performs comparison analysis, generates a commissioning completion degree comparison chart, and displays the comparison result.

[0181] The commissioned project query unit is configured to provide a commissioned project query function, allowing the business personnel to query specific commissioned project information according to the project name, project type, commissioning time, and other conditions, to facilitate the business personnel to quickly obtain the required information. The business personnel inputs the corresponding query conditions in the query box, and the commissioned project query unit automatically searches and displays the commissioned project information meeting the requirements according to the conditions.

[0182] The data details exporting unit is configured to support exporting the data related to the overall operation of the project into a file format, so as to facilitate further data processing, analysis or sharing with others by the business personnel. The business personnel selects the data content and the file format to be exported in the system, and clicks the export button, so that the system automatically generates and downloads the corresponding file.

[0183] The project classification operation module 365 is configured to statistically display the operation completion of various types of label special projects in the target area (the whole city, each district and county bureau). Specifically, the following functional units are covered:

[0184] The label classification project statistics unit is configured to statistically count the operation quantity and operation time of various types of label projects according to the classification of the project label (such as special projects, key projects, etc.), and directly display the operation of different label projects. The label classification project statistics unit extracts the project label and operation data from the database, classifies and summarizes according to the project label, generates a statistical report and displays it.

[0185] The analysis of special operation completion rate unit is configured to analyze the operation completion rate of various types of special projects, evaluate the execution effect and operation progress of the special projects, and provide a basis for the management and decision-making of the special projects. The system calculates the operation completion rate of various types of special projects (the number of special operation projects / the number of planned special operation projects), generates a special operation completion rate analysis chart, and displays the analysis results.

[0186] The drilling details function unit is configured to provide a drilling details function. When the business personnel clicks the operation information of a label special project, the drilling details function unit can deeply display the specific operation project details of the label special project, such as the project name, operation time, project scale, etc., so as to facilitate the business personnel to deeply understand the operation details of the special project. The business personnel clicks the label special project of interest on the display interface, and the system automatically pops up a detailed information display window to display the specific operation project details of the label special project.

[0187] The data result exporting unit is configured to support exporting the data related to the operation of the project classification into a file format, so as to facilitate the business personnel to use the data in other analysis tools or share the data. The business personnel selects the data content to be exported in the system, and clicks the export button, so that the system automatically generates and downloads the corresponding file.

[0188] The project implementation module 366 is configured to statistically display the operation and construction scale of the overall and each batch of projects in the target area (the whole city, each district and county bureau). Specifically, the following functional units are covered:

[0189] The analysis of the line and the scale of the area unit for the operation is used for analyzing the line and the scale of the area for the operation of the project in detail, counting the length of the line, the number of the area, and other information of the project in different regions and different batches, and evaluating the construction scale and effect of the project implementation. The analysis of the line and the scale of the area unit collects the line and the scale of the area information in the project operation data, carries out classified statistics and analysis, generates an analysis report, and displays.

[0190] The comparative analysis unit for the project operation is used for comparing the operation of the project in different regions and different batches, including the number of the project, the scale of the operation, the operation time, and other indicators, finding out the differences and analyzing the reasons, and providing a reference for the management and optimization of the project implementation. The comparative analysis unit for the project operation extracts the operation data of the project in different regions and different batches, carries out comparative analysis, generates comparative analysis charts, and displays the comparative results.

[0191] The index drilling function unit is used to provide the index drilling function. When the business personnel click on an index (such as the scale of the operation line and the scale of the area), the system can display the detailed information of the index in different regions and different batches of projects, such as the length of the line and the number of the area of the specific project, so as to facilitate the business personnel to understand the details of the project implementation. The business personnel click on the index of interest on the display interface, and the system automatically pops up a detailed information display window to display the detailed data of the index in different regions and different batches of projects.

[0192] The index result export unit is used to support exporting the index data of the project implementation into a file format, so as to facilitate the business personnel to further process, analyze, or share with others. The business personnel select the index data to be exported and the file format in the system, click the export button, and the system automatically generates and downloads the corresponding file.

[0193] The project achievement evaluation analysis module 37 includes an implementation effect evaluation module 371 and an implementation process early warning module 372.

[0194] The implementation effect evaluation module 371 is used to statistically analyze various project evaluation problems. Specifically, the following function units are covered:

[0195] The project evaluation situation analysis unit is used to comprehensively and deeply analyze the evaluation situation of various projects, comprehensively consider various factors such as the number of project evaluation problems and the equipment of evaluation problems, evaluate the pros and cons of the project implementation effect, and provide a basis for subsequent project improvement. The project evaluation situation analysis unit automatically collects project evaluation data, processes the data using a data analysis algorithm, generates a project evaluation situation analysis report, and intuitively displays the overall situation and existing problems of the project evaluation.

[0196] The equipment and problem number dimension analysis unit is configured to provide a function of analyzing the project evaluation situation from two dimensions of equipment and problem number. By counting the number of evaluation problems of different equipment, the performance of the equipment in the project implementation process is analyzed, and the types of equipment prone to problems are found out. At the same time, the number of problems of different projects is compared to evaluate the quality and stability of the project implementation. The equipment and problem number dimension analysis unit counts the number of problems of equipment and projects respectively according to the equipment tag and the project identification, generates dimension analysis charts, and clearly shows the correlation between equipment and problem number, providing data support for equipment management and project optimization.

[0197] The equipment and problem number detail positioning unit is configured to quickly locate and display the detailed information corresponding to the equipment or problem number when a business personnel clicks on the equipment or problem number, including equipment model, project, problem description, problem severity, etc., to facilitate the business personnel to deeply understand the problem root cause and develop targeted solutions. The business personnel clicks on the equipment or problem number of interest on the display interface, and the system automatically pops up a detailed information display window to display all related data of the equipment or problem number, providing detailed basis for problem solving.

[0198] The result data export unit is configured to support exporting the related data of the implementation effect evaluation situation into common file formats (such as Excel, CSV, etc.), so as to facilitate the business personnel to use the data for further processing in other analysis tools, or share the data with team members and superiors to jointly explore project improvement measures. The business personnel selects the data content and file format to be exported in the system, and clicks on the export button, and the system automatically generates and downloads the corresponding file.

[0199] The implementation process warning module 372 is configured to display the warning information in the target area (the whole city, each district and county bureau) in the project implementation process to assist the business personnel to timely find and solve potential problems. The following function units are specifically covered:

[0200] The warning situation dimension display unit is configured to comprehensively display the warning situation of the project implementation process from multiple warning dimensions (such as warning type, warning level, warning area, warning time, etc.), so that the business personnel can intuitively understand the overall distribution and trend of the warning, and provide a macroscopic perspective for warning processing. The warning situation dimension display unit collects the warning information in the project implementation process, classifies and displays the warning information according to the preset warning dimensions, generates warning situation dimension display charts, and clearly presents the warning situation under different dimensions.

[0201] The early warning information drilling unit is configured to provide an early warning information drilling function. When a business personnel clicks on a certain early warning information, the system can show detailed content of the early warning information, including an early warning item name, an early warning reason, an early warning influence range, and a taken measure, to help the business personnel comprehensively understand the early warning situation and formulate an effective response strategy. The business personnel clicks on the early warning information of interest on a display interface, and the system automatically pops up a detailed information display window to show all related data of the early warning information, thereby providing detailed basis for early warning processing.

[0202] The early warning information exporting unit is configured to support exporting related data of an implementation process early warning situation into a file format, so as to facilitate the business personnel to use the early warning information for internal communication, reporting or archiving, and to ensure effective transmission and management of the early warning information. The business personnel selects early warning information content and a file format to be exported in the system, and clicks on an export button, so that the system automatically generates and downloads a corresponding file.

[0203] In summary, the power distribution network planning and construction whole-process management and control system constructed in the embodiments of the present application integrates data visualization, data analysis and mining, interactive visualization and real-time data processing technologies. Through the data visualization technology, complex data is converted into intuitive charts. Through the data analysis and mining technology, potential patterns and trends in the data are found. The interactive visualization function enables users to customize data exploration. The real-time data processing technology ensures that the system can process a large amount of real-time data streams, and realizes real-time updating and display of data.

[0204] Figure 5 A structural schematic diagram of an electronic device provided in the embodiments of the present application is shown in FIG. 5. As shown in FIG. 5, the electronic device 50 provided in the embodiments of the present application includes at least one processor 501 and a memory 502. Optionally, the device 50 further includes a communication component 503. The processor 501, the memory 502 and the communication component 503 are connected through a bus 504. Figure 5

[0205] In the specific implementation process, the at least one processor 501 executes computer execution instructions stored in the memory 502, so that the at least one processor 501 executes the method described above.

[0206] The specific implementation process of the processor 501 can refer to the method embodiments described above, which has similar implementation principles and technical effects, and will not be described here again in the embodiments.

[0207] ​In the above embodiments, it should be understood that the processor can be a central processing unit (CPU), and can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (ASIC), etc. The general-purpose processor can be a microprocessor or any conventional processor, etc. The steps of the method disclosed in combination with the application can be directly embodied as hardware processor execution, or executed by a combination of hardware and software modules in the processor.

[0208] The memory can include a random access memory (RAM), and can also include a non-volatile memory (NVM), such as at least one disk memory.

[0209] The bus can be an industry standard architecture (ISA) bus, a peripheral component (PCI) bus, or an extended industry standard architecture (EISA) bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, the bus in the drawings of the present application does not limit to only one bus or one type of bus.

[0210] The embodiments of the present application also provide a computer program product, comprising a computer program, which is executed by a processor to implement the above method.

[0211] The embodiments of the present application also provide a computer readable storage medium, which stores computer execution instructions, and when a processor executes the computer execution instructions, the above method is implemented.

[0212] The above readable storage medium can be implemented by any type of volatile or non-volatile storage device or their combination, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk. The readable storage medium can be any available medium that can be accessed by a general-purpose or special-purpose computer.

[0213] An example readable storage medium is coupled to the processor such that the processor can read information from the readable storage medium and can write information to the readable storage medium. Of course, the readable storage medium can also be a part of the processor. The processor and the readable storage medium can be located in an application specific integrated circuit (ASIC). Of course, the processor and the readable storage medium can also exist as discrete components in the device.

[0214] The division of units is only a logical functional division, and in actual implementation, there can be another division manner, for example, a plurality of units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the coupling or direct coupling or communication connection between the units shown or discussed can be indirect coupling or communication connection through some interfaces, devices or units, and can be electrical, mechanical or other forms.

[0215] The units described as separate components can or can not be physically separated, and the components shown as units can or can not be physical units, that is, can be located in one place, or can be distributed on a plurality of network units. Part or all of the units can be selected according to actual needs to achieve the purpose of the embodiment scheme.

[0216] In addition, the functional units in each embodiment of the present application can be integrated in one processing unit, or each unit can be physically present separately, or two or more units can be integrated in one unit.

[0217] If the functions are realized in the form of software function units and sold or used as independent products, they can be stored in a computer readable storage medium. Based on this understanding, the technical solutions of the present application or the part of the present application that essentially contributes to the prior art or the part of the technical solutions can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes a plurality of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the embodiments of the present application. The foregoing storage medium includes a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and various program code storage media.

[0218] Those skilled in the art can understand that all or part of the steps of the above-mentioned method embodiments can be completed by program instruction related hardware. The foregoing program can be stored in a computer readable storage medium. The program executes to perform the steps of the above-mentioned method embodiments; and the foregoing storage medium includes various media capable of storing program codes, such as ROM, RAM, magnetic disk, or optical disk.

[0219] Finally, it should be noted that other embodiments of the present application will readily occur to those skilled in the art upon consideration of the specification and practice of the present application disclosed herein. The present application is intended to include all such variations as fall within the general scope of the application, and includes the generic principles disclosed and the best mode known to the inventors to be currently practiced as well as variations thereof, without departing from the scope of the present application as defined by the claims. The specification and examples give the best application of the present application as known to at least one of the inventors at the time of the filing hereof and it is to be understood that the scope of the present application is to be given by the claims and it is intended to claim all changes and modifications that come within the meaning and range of equivalents of the claims.

Claims

1. A power distribution network planning and construction whole-process management and control method, characterized in that, The method comprises the following steps: obtaining power grid business data corresponding to the whole-process management and control requirements of power distribution network planning and construction from a plurality of heterogeneous business systems; storing and managing the power grid business data based on data warehouse technology to obtain a database corresponding to the whole-process management and control requirements of power distribution network planning and construction; performing data statistical analysis on the data in the database according to data statistical analysis requirements to obtain statistical analysis results corresponding to different data statistical analysis requirements, wherein the data statistical analysis requirements include pre-planning requirements, project implementation progress analysis requirements, and project achievement evaluation analysis requirements; outputting and displaying the statistical analysis results corresponding to different data statistical analysis requirements.

2. The power distribution network planning and construction whole-process management and control method according to claim 1, characterized in that, The data statistical analysis corresponding to the pre-planning requirements comprises the following steps: determining first data required by the pre-planning requirements in the database according to the pre-planning requirements; determining a set of power grid problems of the regional identifier within the set time dimension in the first data according to the set time dimension and the regional identifier; classifying the set of power grid problems according to problem state labels to obtain statistical analysis results containing power grid problems corresponding to different problem state labels, wherein the problem state labels include new, solved, and unsolved.

3. The power distribution network planning and construction whole-process management and control method according to claim 2, characterized in that, The data statistical analysis corresponding to the project achievement evaluation analysis requirements comprises the following steps: determining second data required by the project achievement evaluation analysis requirements in the database according to the project achievement evaluation analysis requirements; determining statistical analysis results of warning information generated in the implementation process of a project associated with a project identifier under a regional identifier based on the second data, a set warning dimension, the regional identifier, and the project identifier to provide a basis for project achievement evaluation, wherein the set warning dimension includes at least one of warning type, warning level, warning area, and warning time.

4. The power distribution network planning and construction whole-process management and control method according to any one of claims 1 to 3, characterized in that, The project implementation progress analysis requirements include resource allocation plan completion degree analysis requirements, and the data statistical analysis corresponding to the project implementation progress analysis requirements comprises the following steps: determining third data required by the resource allocation plan completion degree analysis requirements in the database according to the resource allocation plan completion degree analysis requirements; determining a total amount of resource allocation and an actual amount of resource completion corresponding to a project associated with a project identifier under a regional identifier based on the third data and the project identifier and the regional identifier; determining statistical analysis results containing resource allocation plan completion degrees corresponding to the project identifier according to the total amount of resource allocation and the actual amount of resource completion.

5. The power distribution network planning and construction whole-process management and control method according to any one of claims 1 to 3, characterized in that, The project implementation progress analysis requirements include milestone plan completion degree analysis requirements, and the data statistical analysis corresponding to the project implementation progress analysis requirements comprises the following steps: determining fourth data required by the milestone plan completion degree analysis requirements in the database according to the milestone plan completion degree analysis requirements; determining a planned completion amount of a milestone node and an actual completion amount of a milestone node corresponding to a project associated with a project identifier under a regional identifier based on the fourth data and the project identifier and the regional identifier; According to the milestone node plan completion amount and the milestone node actual completion amount, a statistical analysis result of a milestone plan completion degree corresponding to the project identifier is determined.

6. The power distribution network planning and construction whole-process management and control method according to any one of claims 1 to 3, characterized in that, The project implementation progress analysis requirement includes a project commissioning completion degree analysis requirement, and data statistical analysis corresponding to the project implementation progress analysis requirement includes: According to the project commissioning completion degree analysis requirement, fifth data required by the project commissioning completion degree analysis requirement is determined in the database; Based on the fifth data, according to the region identifier, a project commissioning plan amount and a project actual commissioning amount corresponding to the region identifier are determined; According to the project commissioning plan amount and the project actual commissioning amount, a statistical analysis result of a project commissioning completion degree corresponding to the region identifier is determined.

7. The power distribution network planning and construction whole-process management and control method according to any one of claims 1 to 3, characterized in that, The storage management of the power grid business data based on the data warehouse technology obtains the database corresponding to the power distribution network planning and construction whole-process management and control requirement, including: The power grid business data is preprocessed to obtain processed business data, and the preprocessing includes data cleaning and data integration; The storage management of the processed business data based on the data warehouse technology obtains the database corresponding to the power distribution network planning and construction whole-process management and control requirement.

8. A power distribution network planning and construction whole-process management and control system, characterized in that, Including: An acquisition module is configured to acquire power grid business data corresponding to the power distribution network planning and construction whole-process management and control requirement from a plurality of heterogeneous business systems; A processing module is configured to store and manage the power grid business data based on the data warehouse technology to obtain the database corresponding to the power distribution network planning and construction whole-process management and control requirement; A statistical module is configured to perform data statistical analysis on data in the database according to data statistical analysis requirements to obtain statistical analysis results corresponding to different data statistical analysis requirements, and the data statistical analysis requirements include early planning requirements, project implementation progress analysis requirements, and project achievement evaluation analysis requirements; An output module is configured to output and display statistical analysis results corresponding to different data statistical analysis requirements.

9. An electronic device, comprising: Including: A processor and a memory in communication connection with the processor; The memory stores computer execution instructions; The processor executes the computer execution instructions stored in the memory to implement the method in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer execution instructions, and the computer execution instructions are executed to implement the method in any one of claims 1 to 7.

Images