CN107146166B - Distribution network planning auxiliary system - Google Patents
Distribution network planning auxiliary system Download PDFInfo
- Publication number
- CN107146166B CN107146166B CN201710271919.8A CN201710271919A CN107146166B CN 107146166 B CN107146166 B CN 107146166B CN 201710271919 A CN201710271919 A CN 201710271919A CN 107146166 B CN107146166 B CN 107146166B
- Authority
- CN
- China
- Prior art keywords
- data
- distribution network
- planning
- configuration table
- project
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000009826 distribution Methods 0.000 title claims abstract description 244
- 238000013439 planning Methods 0.000 title claims abstract description 152
- 238000007726 management method Methods 0.000 claims abstract description 55
- 238000003860 storage Methods 0.000 claims abstract description 20
- 238000013523 data management Methods 0.000 claims abstract description 13
- 238000012937 correction Methods 0.000 claims abstract description 7
- 238000004458 analytical method Methods 0.000 claims description 55
- 238000012795 verification Methods 0.000 claims description 38
- 238000011156 evaluation Methods 0.000 claims description 27
- 238000007619 statistical method Methods 0.000 claims description 20
- 230000009466 transformation Effects 0.000 claims description 11
- 238000013524 data verification Methods 0.000 claims description 9
- 238000007689 inspection Methods 0.000 claims description 8
- 238000000034 method Methods 0.000 claims description 8
- 238000013507 mapping Methods 0.000 claims description 6
- 238000004364 calculation method Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 claims description 5
- 230000000694 effects Effects 0.000 claims description 3
- 238000000605 extraction Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 238000007405 data analysis Methods 0.000 claims description 2
- 238000013075 data extraction Methods 0.000 claims description 2
- 238000012986 modification Methods 0.000 claims description 2
- 230000004048 modification Effects 0.000 claims description 2
- 239000000126 substance Substances 0.000 claims 8
- 239000011248 coating agent Substances 0.000 claims 1
- 238000000576 coating method Methods 0.000 claims 1
- 238000002360 preparation method Methods 0.000 claims 1
- 230000008439 repair process Effects 0.000 abstract description 4
- 238000004519 manufacturing process Methods 0.000 description 7
- 238000013506 data mapping Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000035945 sensitivity Effects 0.000 description 1
- 238000005728 strengthening Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention discloses a distribution network planning auxiliary system, which comprises an application server, a database server and a client: the application server is provided with a distribution network basic data management module which comprises: the data interface unit is used for acquiring a configuration table; the data matching and replacing unit is used for matching the basic data of the standard distribution network in the standard configuration table with the basic data of the distribution network to be matched in the configuration table to be matched and replacing the corresponding basic data of the distribution network to be matched in the configuration table to be matched with the corresponding basic data of the standard distribution network according to the matching relation; the data correction unit is used for correcting the basic data of the distribution network in the configuration table; and the data interface unit is also used for sending the corrected configuration table to a database server for storage. The invention can ensure the consistency of data from different sources and verify and repair wrong data, thereby improving the accuracy of data management and further improving the efficiency and quality of distribution network management work.
Description
Technical Field
The invention relates to the technical field of power grid management, in particular to a distribution network planning auxiliary system.
Background
With the continuous development of the overall configuration of the power system in China, the power distribution network is rapidly developed while the main network planning continues to be applied deeply. Compared with the main network planning, the power distribution network planning has the characteristics of small project, multiple projects, wide related range, quick demand, large change and the like, and a large amount of power distribution network planning data need to be managed in the power distribution network planning process, so that the current power distribution network planning informatization faces urgent needs.
At present, a unified and normative data management mode is not provided for managing the power distribution network planning data, the power distribution network planning data management is weak, errors (such as mutual contradiction between data or error data) are easy to occur in the process of managing the power distribution network planning data, and the quality of power distribution network management work is affected. If come to carry out the check-up one by one to distribution network planning data through artificial mode, waste time and energy to can influence the efficiency of distribution network management work.
Disclosure of Invention
In view of the above problems, an object of the present invention is to provide a distribution network planning assistance system, which can ensure consistency between data from different sources, and can verify and repair wrong data, so as to improve accuracy of data management, and further improve efficiency and quality of power distribution network management work.
In order to achieve the above object, the present invention provides a distribution network planning assistance system, which includes an application server, a database server for providing application data to the application server and storing processing data of the application server, and a client for accessing the application server: the application server comprises a distribution network basic data management module, and the distribution network basic data management module is provided with:
the data interface unit is used for acquiring configuration tables which are sent from all the clients and respectively store corresponding distribution network basic data; the configuration table is divided into standard configuration tables of different data sources and a configuration table to be matched;
the data matching and replacing unit is used for matching the basic data of the standard distribution network in the standard configuration table with the basic data of the corresponding distribution network to be matched in the corresponding configuration table to be matched and replacing the basic data of the corresponding distribution network to be matched in the configuration table to be matched with the basic data of the corresponding standard distribution network according to the matching relation; and the number of the first and second groups,
the data correction unit is used for verifying the data in the matched corresponding configuration table and correcting the basic data of the distribution network in the corresponding configuration table according to the verification result;
and the data interface unit is also used for sending the corrected configuration table to the database server for storage.
According to the distribution network planning auxiliary system provided by the embodiment of the invention, the data matching and replacing unit can match the acquired standard configuration table and the acquired to-be-matched configuration table sent by each client, and automatically replace the corresponding to-be-matched distribution network basic data in the to-be-matched configuration table with the corresponding standard distribution network basic data according to the matching relation, so that the data in the to-be-matched configuration table is ensured to be consistent with the corresponding data in the standard configuration table, and the inconsistency of the data in the plurality of configuration tables is avoided; and meanwhile, the data in the matched configuration table is verified through the data correction unit so as to correct the error data in the configuration table. Therefore, the embodiment of the invention can ensure the consistency of the data from different sources, and can verify and repair the wrong data, thereby improving the accuracy of data management and not needing to verify the data one by one in a manual mode. Therefore, the embodiment of the invention can improve the efficiency and quality of the power distribution network management work.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic structural diagram of a distribution network planning assistance system according to an embodiment of the present invention;
fig. 2 is a network topology diagram of a distribution network planning assistance system according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of a distribution network planning project management module shown in fig. 1;
fig. 4 is a schematic structural diagram of the system management module shown in fig. 1.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of the present invention provides a distribution network planning assistance system, which includes an application server 1, a database server 2 for providing application data to the application server 1 and storing processing data of the application server 1, and a client 3 for accessing the application server 1: the application server 1 comprises a distribution network basic data management module 10, wherein the distribution network basic data management module 10 is provided with a data interface unit 100, a data matching and replacing unit 101 and a data correcting unit 102:
the data interface unit 100 is configured to obtain configuration tables sent from the clients 3 and respectively storing corresponding distribution network basic data. The configuration table can be divided into a standard configuration table and a configuration table to be matched, and the data sources of the standard configuration table and the configuration table to be matched are different. The standard configuration table stores various distribution network basic data such as power supply enterprise profile data, distribution network basic account data, distribution network operation data, distribution network basic parameter data or special data of the corresponding regional distribution network according to the type of the configuration table, and similarly, the configuration table to be matched stores various distribution network basic data such as power supply enterprise profile data, distribution network basic account data, distribution network operation data, distribution network basic parameter data or special data of the corresponding regional distribution network according to the type of the configuration table. Preferably, the standard configuration table is a configuration table set by a user or a configuration table approved by the user, and the configuration table to be matched is a configuration table not approved by the user.
The data matching and replacing unit 101 is configured to match the standard distribution network basic data in the standard configuration table with the corresponding distribution network basic data to be matched in the corresponding configuration table to be matched, and replace the corresponding distribution network basic data to be matched in the configuration table to be matched with the corresponding standard distribution network basic data according to a matching relationship. That is, a user selects a standard configuration table and one or more configuration tables to be matched, then the data matching and replacing unit 101 matches (one-to-one matching or one-to-many matching) the standard distribution network basic data in the standard configuration table with the corresponding distribution network basic data to be matched in the corresponding configuration table to be matched according to the data matching operation of the user, and after the matching is completed, the corresponding distribution network basic data to be matched in the configuration table to be matched is replaced with the corresponding standard distribution network basic data, so that the distribution network basic data in the two configuration tables are consistent.
The data correction unit 102 is configured to verify data in the matched corresponding configuration table, and correct the distribution network basic data in the corresponding configuration table according to a verification result.
The data interface unit 100 is further configured to send the configuration table after data verification to the database server 2 for storage.
In the embodiment of the present invention, preferably, referring to fig. 2, the data interface unit 100 may further obtain configuration tables derived from each distribution network service system and respectively storing corresponding distribution network basic data. For example, the data interface unit 100 may obtain a corresponding configuration table derived and sent by a marketing analysis and aid decision making system, a production management system, a production real-time management and control system, a marketing service application system, a power consumption information acquisition system, an energy management system, an electric energy metering system, and other distribution network service systems of each distribution network. When the configuration table sent by each distribution network service system is acquired, the table format of the acquired configuration table may be converted and converted into a required table format (for example, into an excel table format).
In this embodiment of the present invention, preferably, the sources of the configuration table sent from the client 3 may be two types: one is that a user fills in basic data of the distribution network in a corresponding configuration table template file displayed in a current operation interface of a client 3, and then saves the configuration table template file filled with the basic data of the distribution network as a corresponding configuration table and sends the configuration table to the application server 1 (or the database server 2); the other is that the user first fills in the basic data of the distribution network on the template file of the configuration table on another device (e.g. a notebook computer, a tablet computer, etc.), and then imports the basic data into the client 3 and sends the basic data to the application server 1 (or the database server 2).
In the embodiment of the present invention, preferably, the matching and replacing unit includes an obtaining subunit, a matching subunit, and a replacing subunit; wherein:
and the obtaining subunit is used for obtaining the corresponding standard configuration table and the configuration table to be matched.
The matching subunit is configured to map and match the standard distribution network basic data in the corresponding standard configuration table with the corresponding distribution network basic data to be matched in the corresponding configuration table to be matched, and store the matched standard distribution network basic data and the distribution network basic data to be matched in the corresponding data mapping relationship table according to the mapping matching relationship of the data. That is, the matching subunit performs mapping matching (one-to-one matching or one-to-many matching) on the standard distribution network basic data in the standard configuration table and the corresponding distribution network basic data to be matched in the corresponding configuration table to be matched according to the data matching operation of the user, and stores the matched standard distribution network basic data and the matched distribution network basic data in the corresponding data mapping relationship table according to the mapping matching relationship of the data.
And the replacing subunit is used for replacing the corresponding distribution network basic data to be matched in the configuration table to be matched with the corresponding standard distribution network basic data in the data mapping relation table according to the data mapping matching relation.
Here, the above preferred embodiments are exemplified: for example, one of the configuration tables derived from the production management system is used as a standard configuration table, one of the configuration tables derived from the marketing service application system of a corresponding type is used as a configuration table to be matched, then the matching subunit matches the data of the two configuration tables, after the matching is successful, the corresponding distribution network basic data of the configuration table derived by the production management system is not deleted, and the basic data of the distribution network matched by the marketing service application system disappears and the basic data of the distribution network corresponding to the production management system is stored in the data mapping relation table, at the moment, a user can click a mapping replacement button on the data mapping relation interface, the replacement subunit will then replace the corresponding distribution network basis number of the marketing service application system with the corresponding distribution network basis data of the production management system, therefore, the matched data naming standard of the marketing service application system is consistent with the data naming standard of the production management system. In addition, corresponding prompts appear in the distribution network basic data which are not successfully matched in the standard configuration table and the configuration table to be matched.
In the embodiment of the present invention, preferably, the verification module includes a configuration table obtaining subunit, a verification object generating subunit, a verification task establishing subunit, and a verification subunit; wherein:
and the configuration table acquiring subunit is used for acquiring a configuration table which needs to be subjected to data verification. Wherein, the configuration table needing data verification is selected by a user.
And the verification object generation subunit is used for generating a corresponding verification object according to the table name and the table attribute of the acquired configuration table. That is, the user can fill in the table name of the configuration table and the table attribute of the configuration table that need to be subjected to data verification in the verification object editing interface, and then click the editing button, and the verification object generation subunit can generate the corresponding verification object and store the generated verification object. For example, if the table name of the configuration table selected by the user is "substation equipment substation", the table attribute of the configuration table may be "substation name", then the description name of the verification object generated by the verification object generation subunit is "substation equipment substation # substation name", and the verification object is "@ REP _ JX _ PW _ SUB # subbname @". The field check under each table name starts with @ and ends with @, the table name and the table attribute are separated by # and a plurality of table name fields are checked and then used'; ' spacing; for example, if a configuration table for verification needs to be additionally provided, and the table name of the configuration table is "raw data _ dedicated substation", and the table attribute is "substation name", the description names of verification objects generated according to the two configuration tables are: "@ REP _ JX _ PW _ VC _ DESUB # SUBNAME @; @ REP _ JX _ PW _ VC _ DESUB # SUBNAME @ ", the verification object is the name of the transformer equipment substation # transformer substation; raw data _ dedicated substation # substation name ".
The inspection task establishing subunit is used for respectively establishing a mapping relation between different inspection objects and corresponding inspection rules so as to establish corresponding inspection tasks; the check rule is preset, and the check rule may be a data out-of-limit check rule or a data null check rule, and the like, and is not specifically limited herein.
The checking subunit is used for running the checking task to check the corresponding checking object according to the checking rule; when the fact that the distribution network basic data in the configuration table corresponding to the verification object do not accord with the corresponding verification rules is detected, the distribution network basic data which do not accord with the verification rules in the configuration table are marked, and the marked distribution network basic data are corrected according to the modification operation of a user. The verification subunit verifies the corresponding verification object according to the verification rule, and when detecting that the distribution network basic data in the configuration table corresponding to the verification object do not accord with the corresponding verification rule, the verification subunit performs red marking on the cell where the distribution network basic data which does not accord with the verification rule in the configuration table; the system also displays the error items of the configuration table after verification to the user, displays the error items on the uppermost row of the red marked cells, and displays the error number of the data below the cells. The user can modify the marked distribution network basic data.
In the embodiment of the present invention, preferably, referring to fig. 1 and fig. 2, the distribution network planning assistance system further includes a workstation 4 for accessing and maintaining the application server 1 by means of a browser. The workstation 4 may also access the application server 1 to perform the distribution network planning assistance work described above. Wherein the workstation 4 accesses the application server 1 using the IE8 browser and accessing the system login address via HTTP, using the correct username and password login.
Preferably, the database server 2 is an Oracle database server, and the application server 1 accesses the Oracle database server by using JDBC.
It should be noted that each client 3 may access the application server 1 by a browser (that is, the network architecture of the distribution network planning assistance system is a B/S structure), or may access the application server 1 by an application program (that is, the network architecture of the distribution network planning assistance system is a C/S structure). It is understood that the client 3 may be divided into a county-level client 3, a city-level client 3, a provincial-level client 3, and the like according to the distribution network management area, and the access rights of the clients 3 in different areas to the application server 1 are different, for example, the access rights of the provincial-level client 3 may be higher than those of the county-level client 3 and the city-level client 3.
In summary, in the embodiment of the present invention, the data matching and replacing unit 101 may perform data matching on the standard configuration tables and the configuration tables to be matched, which are different data sources, and replace the corresponding distribution network basic data to be matched in the configuration tables to be matched with the corresponding standard distribution network basic data according to a matching relationship, so as to ensure that the data in the configuration tables to be matched are consistent with the corresponding data in the standard configuration tables, thereby avoiding inconsistency between the data in the plurality of configuration tables; meanwhile, the data in the matched configuration table is verified by the data correction unit 102, so as to correct the error data in the configuration table. Therefore, the embodiment of the invention can ensure the consistency of the data from different sources, and can verify and repair the wrong data, thereby improving the accuracy of data management and not needing to verify the data one by one in a manual mode. Therefore, the embodiment of the invention can improve the efficiency and quality of the power distribution network management work.
In the embodiment of the present invention, referring to fig. 1, the application server 1 further includes a distribution network present index management module 11, where the distribution network present index management module 11 is configured to perform data statistical analysis on each distribution network index on the obtained verified configuration table, and generate present analysis data of each distribution network index according to a statistical analysis result. That is, the distribution network current status indicator management module 11 performs data statistical analysis on the distribution network basic data in the obtained verified configuration table according to the type of the distribution network current status indicator, so as to obtain a statistical analysis result of each distribution network current status indicator. The distribution network current state indexes comprise regional profiles, high-voltage equipment statistics, medium-voltage equipment statistics, operation index statistics (such as capacity-load ratio, single-line or single-transformer station proportion, proportion meeting N-1 main transformer proportion and the like), problem statistics and the like. In addition, the data interface unit 100 is further configured to send the presence analysis data of each distribution network indicator to the database server 2 for storage.
In the embodiment of the present invention, referring to fig. 1, the application server 1 further includes an electric quantity load prediction module 12, where the electric quantity load prediction module 12 is configured to perform statistical analysis on the acquired historical data of the electric quantity load in the verified configuration table, and obtain electric quantity load prediction data of each power distribution network and total electric quantity load prediction data according to a statistical analysis result. The electric quantity load prediction module 12 is used for predicting the loads of the regional distribution network and the whole network by combining the distributed power supply conditions through an elasticity coefficient method, a natural growth rate calculation method and the like. In addition, the data interface unit 100 is further configured to send the corresponding electric quantity load prediction data to the database server 2 for storage.
In the embodiment of the present invention, referring to fig. 1, the application server 1 further includes a power balance management module 13, where the power balance management module 13 is configured to obtain a load increase rate of each distribution network according to a statistical analysis result of the historical data of the power loads, select variable capacitance-to-load ratio data corresponding to each distribution network according to the load increase rate of the distribution network, and obtain variable capacitance data, which is required by each distribution network and is even the number of feeder lines, according to the power load prediction data of each distribution network. The data interface unit 100 is further configured to send the variable capacitance/load ratio data and the variable capacitance data to the database server 2 for storage.
In the embodiment of the present invention, referring to fig. 1, the data interface unit 100 is further configured to obtain a distribution network planning item report table, which is sent by each client 3 and stores corresponding distribution network planning item data, and the application server 1 further includes a distribution network planning item management module 14 configured to manage the distribution network planning item report table; referring to fig. 3, the distribution network planning project management module 14 includes an investment estimation and investment analysis unit 140, an investment data calculation unit 141, a project comparison unit 142, a project library statistical analysis unit 143, and a project library comparison unit 144; wherein:
the investment estimation and analysis unit 140 is configured to perform data statistical analysis on the distribution network planning investment data in each distribution network planning project report to obtain declared investment data of each distribution network planning project and investment evaluation analysis data of each distribution network planning project. The corresponding investment evaluation analysis data obtained by analyzing the investment sensitivity of the distribution network planning investment data in each distribution network planning project report can be the initial investment amount, the investment benefit, the investment recovery period and the like.
The investment data calculating unit 141 is configured to calculate planning investment data (i.e., confirmed planning investment amount) of the planning project of each distribution network according to the historical investment amount of each distribution network in the distribution network planning project report and the declared investment data of the planning project of each distribution network.
The project rating unit 142 is configured to perform project priority rating on the planning projects of each distribution network according to project attributes (e.g., problem severity, engineering attribute weight, policy guide attribute, etc.) of the planning projects of each distribution network, and add the planning projects of the distribution networks with high priority to a preset planning project library. Meanwhile, the user can manually increase or decrease the project of the planning project library according to the requirement.
The project library statistical analysis unit 143 is configured to perform statistical analysis on various planning indexes of the planning project library. According to the different screening conditions of each planning index, the statistical analysis data of each planning index also changes correspondingly. It should be noted that the planning index may be a high-voltage distribution network planning project index, a medium-voltage distribution network planning project index, or a distributed power access project index in the planning project library.
The project library comparison unit 144 is configured to compare the current planning project library with the added or removed planning project, and obtain a difference condition of the planning index between the two project libraries according to the comparison result.
In addition, the data interface unit 100 is further configured to store the acquired planning project report into the planning project library preset by the database server 2, and send the declared investment data, the investment evaluation analysis data, and the planning investment data to the database server 2 for storage.
In the embodiment of the present invention, referring to fig. 1, the data interface unit 100 is further configured to obtain, from the database server 2, distribution network basic data of a corresponding distribution network index in the verified configuration table, the current situation analysis data of the distribution network index, and distribution network planning project data in the distribution network planning project report, so that the application server 1 further includes a distribution network planning index management module 15; the distribution network planning index management module 15 is configured to perform data analysis on the acquired distribution network basic data, current situation analysis data, and distribution network planning project data to obtain engineering scale data of each planning index of a planning project of each distribution network; the project scale data of the planning index are divided into partial voltage grades (such as 110kV, 35kV and 10 kV), years, project categories (such as transformer substation, transformer, transformation capacity and net capacity), and project categories (such as power supply in a non-electric area, strengthening connection with a main network, networking of a city and county power grid in an isolated network operation, and the like). In addition, the data interface unit 100 is further configured to send the project scale data of each planning index to the database server 2 for storage.
In the embodiment of the present invention, referring to fig. 1, the data interface unit 100 is further configured to obtain, from the database server 2, distribution network basic data of a corresponding distribution network index, the current state analysis data of the distribution network index, transformation capacity data required by each distribution network, and engineering scale data of each planning index of a planning project of each distribution network in the verified configuration table, so that the application server 1 further includes a distribution network planning result management module 16; the distribution network planning result management module 16 is configured to perform data statistics and analysis on the obtained distribution network basic data, current situation analysis data, transformation capacity data, and engineering scale data to obtain evaluation analysis data of each planning index of each distribution network, and generate a corresponding solution according to the evaluation analysis data of each planning index. The planning indexes of the distribution networks are preferably planning indexes of 110kV and the following distribution networks, and the evaluation analysis data may be proportions of the planning indexes of the distribution networks of 110kV and the following distribution networks, for example, the planning indexes of the distribution networks of 110kV and the following distribution networks may be: the proportion of the N-1 main transformer, the proportion of the N-1 line and the proportion of the number of high-loss distribution transformers are met. Or the evaluation analysis data can be evaluation analysis of the overall indexes of the power distribution network of 110kV and below, such as power supply reliability, comprehensive line loss rate, one-household-one-meter rate and the like. And the distribution network planning outcome management module 16 may perform statistical display on the problems existing in the current year and various planning indexes of the planning year, and perform investment analysis on different planning projects according to different problem types and engineering attributes. In addition, the data interface unit 100 is further configured to send evaluation analysis data of each planning index of each distribution network to the database server 2 for storage, and send the solution to the corresponding client 3 for display.
In the embodiment of the present invention, referring to fig. 1, the application server 1 further includes a system report management module 17, where the system report management module 17 is configured to store the current situation analysis data, the corresponding electric quantity load prediction data, the power transformation capacity data, the distribution network planning project data, the investment evaluation analysis data, the engineering scale data, and the evaluation analysis data in a corresponding outline table, and generate a corresponding planning outline report according to the current situation analysis data, the corresponding electric quantity load prediction data, the power transformation capacity data, the distribution network planning project data, the investment evaluation analysis data, the engineering scale data, or the evaluation analysis data; the outline table is divided into a current state analysis table for storing the current state analysis data, a load prediction table for storing the electric quantity load prediction data, a power balance table for storing the transformation capacity data, a power grid planning table for storing the distribution network planning project data, an investment estimation analysis table for storing the investment evaluation analysis data, a planning index management table for storing the engineering scale data and a planning effect management table for storing the evaluation analysis data. In addition, the data interface unit 100 is further configured to send the corresponding outline table and the corresponding planning outline report to the database server 2 for storage, and send the corresponding outline table and the corresponding planning outline report to the client 3 for display. It should be noted that the planning report may be displayed in a text form, a table form or a graphic form.
In the embodiment of the present invention, further, please refer to fig. 1, the application server 1 further includes a system management module 18 for configuring and managing basic parameters of various tools, please refer to fig. 4, the system management module 18 includes a user menu management unit 180, a user operation log unit 181, a table extraction formula calculation unit 182, a data verification configuration unit 183, a data table quantity statistics unit 184, a data table basic table configuration unit 185, and a data collection and task flow unit 186; wherein:
the user menu management unit 180 is configured to control display contents of the operation menus of different users according to the access right levels of the users. For example, the access rights of the provincial client 3 are higher than those of the county client 3 and the city client 3, and the provincial client 3 can exhibit more contents.
The user operation log unit 181 is configured to record an operation log of the user on the system data.
The table extraction formula calculating unit 182 is configured to configure a data extraction formula corresponding to each field of the table.
The data verification configuration unit 183 is configured to configure a verification rule of the distribution network basic data.
The data table number counting unit 184 is configured to count the number of types of tables of each type.
And the data table base table configuration unit 185 is used for configuring the field sequence of the corresponding table and the display sequence of each table, and adding an enumeration field option for the corresponding table.
The data acquisition and task flow unit 186 is configured to issue a data task to a next-level system (or the client 3) or report a data task to an upper-level system (or the client 3) through the data interface unit 100.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
Claims (10)
1. A distribution network planning auxiliary system is characterized by comprising an application server, a database server and a client, wherein the database server is used for providing application data for the application server and storing processing data of the application server, and the client is used for accessing the application server: the application server comprises a distribution network basic data management module, and the distribution network basic data management module is provided with:
the data interface unit is used for acquiring configuration tables which are sent from all the clients and respectively store corresponding distribution network basic data; the configuration table is divided into standard configuration tables of different data sources and a configuration table to be matched; the standard configuration table is a configuration table set by a user or a configuration table checked by the user, and the configuration table to be matched is a configuration table not checked by the user;
the data matching and replacing unit is used for matching the basic data of the standard distribution network in the standard configuration table with the basic data of the corresponding distribution network to be matched in the corresponding configuration table to be matched and replacing the basic data of the corresponding distribution network to be matched in the configuration table to be matched with the basic data of the corresponding standard distribution network according to the matching relation; and the number of the first and second groups,
the data correction unit is used for verifying the data in the matched corresponding configuration table and correcting the basic data of the distribution network in the configuration table according to the verification result;
the data interface unit is also used for sending the configuration table subjected to data verification to the database server for storage;
wherein the data correction unit includes:
the configuration table acquiring subunit is used for acquiring a configuration table which needs to be subjected to data verification;
the verification object generation subunit is used for generating a corresponding verification object according to the table name and the table attribute of the acquired configuration table;
the inspection task establishing subunit is used for respectively establishing mapping relations between different inspection objects and corresponding inspection rules so as to establish corresponding inspection tasks; wherein the check rule is preset; and a process for the preparation of a coating,
the checking subunit is used for running the checking task to check the corresponding checking object according to the checking rule; when the fact that the distribution network basic data in the configuration table corresponding to the verification object do not accord with the corresponding verification rules is detected, the distribution network basic data which do not accord with the verification rules in the configuration table are marked, and the marked distribution network basic data are corrected according to the modification operation of a user.
2. The distribution network planning assistance system of claim 1, wherein the application server further comprises a distribution network current status indicator management module, the distribution network current status indicator management module is configured to perform data statistical analysis on each distribution network indicator on the obtained configuration table after verification, and generate current status analysis data of each distribution network indicator according to a statistical analysis result; wherein the content of the first and second substances,
and the data interface unit is also used for sending the current state analysis data of each distribution network index to the database server for storage.
3. The distribution network planning assistance system according to claim 2, wherein the application server further comprises an electric quantity load prediction module, the electric quantity load prediction module is configured to perform statistical analysis on the acquired historical data of the electric quantity load in the verified configuration table, and obtain electric quantity load prediction data of each distribution network and total electric quantity load prediction data according to a statistical analysis result; wherein the content of the first and second substances,
and the data interface unit is also used for sending the corresponding electric quantity load prediction data to the database server for storage.
4. The distribution network planning assistance system according to claim 3, wherein the application server further comprises a power balance management module, the power balance management module is configured to obtain a load increase rate of each distribution network according to a statistical analysis result of the historical data of the power load, select variable capacitance-to-load ratio data corresponding to each distribution network according to the load increase rate of the distribution network, and obtain variable capacitance data required by each distribution network according to the power load prediction data of each distribution network; wherein the content of the first and second substances,
and the data interface unit is also used for sending the variable capacitance load ratio data and the variable capacitance data to the database server for storage.
5. The distribution network planning assistance system according to claim 4, wherein the data interface unit is further configured to obtain a distribution network planning project report table, which is sent by each client and stores corresponding distribution network planning project data, and the application server further includes a distribution network planning project management module configured to manage the distribution network planning project report table; the distribution network planning project management module comprises:
the investment estimation and analysis unit is used for carrying out data statistical analysis on the distribution network planning investment data in each distribution network planning project report to obtain declared investment data of the planning projects of each distribution network and investment evaluation analysis data of the distribution network planning projects;
the investment data calculation unit is used for calculating the planning investment data of the planning project of each distribution network according to the historical investment amount of each distribution network in the distribution network planning project report and the declaration investment data of the planning project of each distribution network;
the project evaluation unit is used for evaluating the project priority of the planning projects of the distribution networks according to the project attributes of the planning projects of the distribution networks and adding the planning projects of the distribution networks with high priority to a preset planning project library;
the project library statistical analysis unit is used for performing statistical analysis on various planning indexes of the planning project library; and the number of the first and second groups,
the project library comparison unit is used for comparing the current planning project library with the added or removed planning projects, and acquiring the difference condition of the planning indexes between the two project libraries according to the comparison result; wherein the content of the first and second substances,
the data interface unit is further configured to store the acquired planning project report into the planning project library preset by the database server, and send the declared investment data, the investment evaluation analysis data, and the planning investment data to the database server for storage.
6. The distribution network planning assistance system of claim 5, wherein the data interface unit is further configured to obtain, from the database server, distribution network basic data of a corresponding distribution network index in the verified configuration table, the current state analysis data of the distribution network index, and distribution network planning project data in a distribution network planning project report, and if the application server further includes a distribution network planning index management module; wherein the content of the first and second substances,
the distribution network planning index management module is used for carrying out data analysis on the acquired distribution network basic data, current situation analysis data and distribution network planning project data to obtain engineering scale data of each planning index of the planning project of each distribution network; wherein the content of the first and second substances,
and the data interface unit is also used for sending the project scale data of each planning index to the database server for storage.
7. The distribution network planning assistance system according to claim 6, wherein the data interface unit is further configured to obtain, from the database server, distribution network basic data of a corresponding distribution network index, the current state analysis data of the distribution network index, transformation capacity data required by each distribution network, and engineering scale data of each planning index of a planning project of each distribution network in the verified configuration table, and then the application server further includes a distribution network planning success management module;
the distribution network planning effect management module is used for performing data statistics and analysis on the acquired distribution network basic data, current situation analysis data, transformation capacity data and engineering scale data to obtain evaluation analysis data of each planning index of each distribution network, and generating a corresponding solution according to the evaluation analysis data of each planning index; wherein the content of the first and second substances,
the data interface unit is further configured to send evaluation analysis data of each planning index of each distribution network to the database server for storage, and send the solution to a corresponding client for display.
8. The distribution network planning assistance system according to claim 7, wherein the application server further comprises a system report management module, and the system report management module is configured to store the current situation analysis data, the corresponding power load prediction data, the power transformation capacity data, the distribution network planning project data, the investment evaluation analysis data, the engineering scale data, and the evaluation analysis data in corresponding outline tables, and generate corresponding planning outline reports according to the current situation analysis data, the corresponding power load prediction data, the power transformation capacity data, the distribution network planning project data, the investment evaluation analysis data, the engineering scale data, or the evaluation analysis data; wherein the content of the first and second substances,
the outline table is divided into a current situation analysis table for storing the current situation analysis data, a load prediction table for storing the electric quantity load prediction data, a power balance table for storing the transformation capacity data, a power grid planning table for storing the distribution network planning project data, an investment estimation analysis table for storing the investment evaluation analysis data, a planning index management table for storing the engineering scale data and a planning effect management table for storing the evaluation analysis data;
and the data interface unit is also used for sending the corresponding outline table and the corresponding planning outline report to the database server for storage and sending to the corresponding client for display.
9. The distribution network planning assistance system of claim 8, wherein the application server further comprises a system management module for configuring and managing basic parameters of various tools, the system management module comprising:
the user menu management unit is used for controlling the display contents of the operation menus of different users according to the access authority levels of the users;
the user operation log unit is used for recording an operation log of a user on system data;
the table extraction formula calculation unit is used for configuring a data extraction formula corresponding to each field of the table;
the data verification configuration unit is used for configuring verification rules of the basic data of the distribution network;
the data table quantity counting unit is used for counting the type quantity of the tables of each type;
the data table basic table configuration unit is used for configuring the field sequence of the corresponding table and the display sequence of each table and adding an enumeration field option for the corresponding table; and the number of the first and second groups,
and the data acquisition and task flow unit is used for issuing and reporting the data task through the data interface unit.
10. Distribution network planning assistance system according to one of the claims 1 to 9, further comprising a workstation for accessing and maintaining the application server by means of a browser.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710271919.8A CN107146166B (en) | 2017-04-24 | 2017-04-24 | Distribution network planning auxiliary system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710271919.8A CN107146166B (en) | 2017-04-24 | 2017-04-24 | Distribution network planning auxiliary system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107146166A CN107146166A (en) | 2017-09-08 |
| CN107146166B true CN107146166B (en) | 2020-12-01 |
Family
ID=59774348
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710271919.8A Active CN107146166B (en) | 2017-04-24 | 2017-04-24 | Distribution network planning auxiliary system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107146166B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109034623B (en) * | 2018-07-27 | 2021-11-30 | 国家电网有限公司 | Power grid planning data processing method and terminal equipment |
| CN109635350B (en) * | 2018-11-16 | 2024-01-05 | 海南电网有限责任公司电力科学研究院 | Data replacement method and system for automatically generating simulated power flow section |
| CN112732150B (en) * | 2021-01-08 | 2022-07-19 | 国电南瑞科技股份有限公司 | Special auxiliary display method and system for power grid equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968699A (en) * | 2012-12-12 | 2013-03-13 | 贵州电网公司六盘水供电局 | Power network planning collection data platform |
| CN104156827A (en) * | 2014-08-15 | 2014-11-19 | 国家电网公司 | Technical collaboration and dynamic intelligent management system for power planning |
| CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
| CN105139114A (en) * | 2015-08-14 | 2015-12-09 | 国家电网公司 | Automatic compiling method for annual operation mode of power grid in district or county |
| CN105469188A (en) * | 2015-11-16 | 2016-04-06 | 国网山东省电力公司经济技术研究院 | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method |
| CN105787089A (en) * | 2016-03-15 | 2016-07-20 | 国家电网公司 | Power distribution network scheduling foundation data integrating method |
| CN106205090A (en) * | 2016-07-22 | 2016-12-07 | 汤亮 | A kind of electric power network real-time monitoring system and control method thereof |
-
2017
- 2017-04-24 CN CN201710271919.8A patent/CN107146166B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968699A (en) * | 2012-12-12 | 2013-03-13 | 贵州电网公司六盘水供电局 | Power network planning collection data platform |
| CN104156827A (en) * | 2014-08-15 | 2014-11-19 | 国家电网公司 | Technical collaboration and dynamic intelligent management system for power planning |
| CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
| CN105139114A (en) * | 2015-08-14 | 2015-12-09 | 国家电网公司 | Automatic compiling method for annual operation mode of power grid in district or county |
| CN105469188A (en) * | 2015-11-16 | 2016-04-06 | 国网山东省电力公司经济技术研究院 | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method |
| CN105787089A (en) * | 2016-03-15 | 2016-07-20 | 国家电网公司 | Power distribution network scheduling foundation data integrating method |
| CN106205090A (en) * | 2016-07-22 | 2016-12-07 | 汤亮 | A kind of electric power network real-time monitoring system and control method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107146166A (en) | 2017-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| CN102545213B (en) | System and method for managing line loss of power grid in real time | |
| CN110707692A (en) | Online load analysis and modeling system and method for power system | |
| CN106570784A (en) | Integrated model for voltage monitoring | |
| CN108958216B (en) | Automatic detection system and method for new energy AGC or AVC control system | |
| CN107146166B (en) | Distribution network planning auxiliary system | |
| CN104933631A (en) | Power distribution network operation online analysis and evaluation system | |
| CN105098763A (en) | Transient voltage stable on-line assessment method based on WAMS and EMS | |
| CN107146165B (en) | Distribution network planning data management method and system | |
| CN111999692B (en) | Multi-table error calibration method and device | |
| CN110826228B (en) | Regional power grid operation quality limit evaluation method | |
| CN109657913B (en) | Transmission and distribution network joint risk assessment method considering distributed power supply | |
| CN112288303A (en) | Method and device for determining line loss rate | |
| CN105976262A (en) | Power plant granularity based power grid model version sharing method | |
| CN113723810A (en) | Graph database-based power grid modeling method | |
| CN114519514A (en) | Low-voltage transformer area reasonable line loss value measuring and calculating method, system and computer equipment | |
| CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
| CN111313399B (en) | Method, device and system for confirming topological relation of regional power utilization network | |
| CN115842342A (en) | Topology identification method and device for distributed power distribution network | |
| CN113852204B (en) | Transformer substation three-dimensional panoramic monitoring system and method based on digital twinning | |
| CN114764535A (en) | Power data processing method, device and equipment for simulation and storage medium | |
| WO2019140553A1 (en) | Method and device for determining health index of power distribution system and computer storage medium | |
| CN107169180A (en) | A kind of power grid regulation model center system of two-stage deployment | |
| CN104299065A (en) | Dispatching automation host and backup model correctness checking method | |
| CN106066860B (en) | Method for managing electric energy metering device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |