CN113032428A - Method for optimizing database technology to realize power grid simulation efficiency - Google Patents
Method for optimizing database technology to realize power grid simulation efficiency Download PDFInfo
- Publication number
- CN113032428A CN113032428A CN202011609286.5A CN202011609286A CN113032428A CN 113032428 A CN113032428 A CN 113032428A CN 202011609286 A CN202011609286 A CN 202011609286A CN 113032428 A CN113032428 A CN 113032428A
- Authority
- CN
- China
- Prior art keywords
- data
- calculation
- power grid
- comdb
- information
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000004088 simulation Methods 0.000 title claims abstract description 19
- 238000005516 engineering process Methods 0.000 title claims abstract description 12
- 238000004364 calculation method Methods 0.000 claims abstract description 48
- 238000013523 data management Methods 0.000 claims abstract description 27
- 238000002360 preparation method Methods 0.000 claims abstract description 3
- 238000005192 partition Methods 0.000 claims description 27
- 230000001174 ascending effect Effects 0.000 claims description 2
- 238000004422 calculation algorithm Methods 0.000 claims description 2
- 230000006870 function Effects 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012067 mathematical method Methods 0.000 description 2
- 230000005055 memory storage Effects 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 238000013524 data verification Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E40/00—Technologies for an efficient electrical power generation, transmission or distribution
- Y02E40/70—Smart grids as climate change mitigation technology in the energy generation sector
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Human Resources & Organizations (AREA)
- Probability & Statistics with Applications (AREA)
- Mathematical Physics (AREA)
- Public Health (AREA)
- Fuzzy Systems (AREA)
- General Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Supply And Distribution Of Alternating Current (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for optimizing database technology to realize power grid simulation efficiency, a power grid special data management database comdb queries and stores power grid data in a universal database Mysql in a linked list mode, a binary search method is used for searching specified data, validity and reasonability check and check are carried out on the data read into the comdb and the data are independently stored, after data preparation is completed, a data topological structure is established, different processing is carried out according to calculation types, if load flow calculation is carried out, a load flow calculation program is carried out, after calculation is completed, the power grid special data management database comdb updates self content according to calculation result information, a final result is updated into the universal database Mysql, and result information is displayed by a report; if the Mysql is in other types of calculation, generating a corresponding calculation file according to the calculation file format, reading the calculation file by other calculation programs for calculation, generating a result file, directly updating the Mysql universal database according to the information of the result file, and displaying the Mysql universal database by using a report.
Description
Technical Field
The invention belongs to the field of analysis and calculation of power systems, relates to an application method of a database based on memory storage in power system analysis, and particularly relates to a method for optimizing database technology to achieve power grid simulation efficiency.
Background
The power industry is the most important basic industry of the country, has extremely important effect on daily life and social production of people, and in recent years, the comprehensive national power of China is rapidly improved, the power demand is more and more large, and in order to meet the power demand of all aspects, a power system needs to be continuously improved, and new technology needs to be researched. However, with the rapid construction of power grids and the use of various new power facilities, power grids are becoming increasingly large and complex. This has led to a rapid increase in the amount of data in grid simulation software.
In the power grid simulation software, a database is generally adopted to store mass data. Most of the current mainstream database technologies are general database technologies, that is: the efficiency of increasing, deleting, modifying and checking is balanced, the efficiency of transaction processing, fault recovery, parallelism, data safety and the like is balanced, the score is very high in the aspect of comprehensive performance, but the score may be lower in the aspect of certain characteristic. In the power grid simulation, most data cannot change too much, and more data are continuously finely adjusted to realize various simulations. Therefore, if the power grid simulation is realized by adopting the general database technology, along with the continuous increase of the data volume, the simulation speed is exponentially reduced according to the characteristics of the power grid simulation, and the user experience and the working efficiency are seriously influenced.
Disclosure of Invention
Aiming at the characteristics of power grid data and simulation, the power grid data are stored in a memory, and a specific mathematical method and a computer method are combined, so that some non-common functions are abandoned, the efficiency of some common functions is optimized, and a high-efficiency database special for the power grid is realized.
The invention aims to solve the technical problems that a method is adopted to realize the functions similar to a database, the operations of increasing, deleting, checking, topology, checking and the like of data can be carried out more quickly, and the method can be used as a core data hub of the whole program to provide support for the graphic display of the program, the calculation of various modules and the module interaction, thereby improving the execution efficiency of the simulation program under the condition of continuously increasing data volume.
Firstly, the power grid data are stored persistently through a universal database Mysql stored in a hard disk of a computer.
Secondly, the power grid data in the universal database Mysql is inquired and accessed by the power grid special data management database comdb, the power grid data is stored by the power grid special data management database comdb in a linked list mode, and distribution is carried out on each record; the data are sorted according to the names, and the data are copied into the managed memory field by field for use.
Thirdly, checking validity and reasonableness of the data read into the partitions, areas, stations, nodes and elements in the power grid dedicated data management database comdb; for example, the partition checking is to check whether the name of each partition is null or not, if so, the information is output to the log, and the subsequent operation is skipped; and if the data is correct, searching the station information corresponding to the partition by adopting a dichotomy, if the corresponding area information is not found, outputting the information to a log, skipping subsequent operation, and otherwise, recording the searched area information into the partition. If the partition has corresponding area information, the relation between the partition and the area needs to be separately stored for subsequent searching; and after the checking operation is finished, independently storing the relations between the partitions and the plant station, between the plant station and the bus, between the plant station and each element, between the bus and the node, between the node and each element.
And fourthly, after the data preparation is finished, establishing a data topology structure, adding an auxiliary topology table bs for storing a computing node and an auxiliary topology table bsl for storing the relation of the whole power grid to the power grid special data management database comdb, initializing the auxiliary topology table bs in sequence according to node information, numbering the nodes in the auxiliary topology table bs in sequence, traversing the whole power grid according to a breadth search method, and storing the searched power grid relation to the auxiliary topology table bsl.
And fifthly, after the whole power grid is searched, dividing the power grid into one or more independent areas according to the relation among the devices, numbering each area, searching each area one by one, and judging whether a generator or a load exists in the area so as to judge whether the area is an active area or a dead area. And finally, storing the information in the bsl into other records for subsequent processing.
Sixthly, performing different processing according to the current calculation type, if the load flow calculation is carried out, opening up a new memory by the comdb, copying data into the new memory according to a format required by the load flow calculation program, carrying out the load flow calculation program, updating the content of the comdb according to the calculation result information after the calculation is finished, wherein the content in the new memory is the calculated result information, updating the final result into the universal database Mysql, and displaying the result information by using a report; if the Mysql is in other types of calculation, generating a corresponding calculation file according to the calculation file format, reading the calculation file by other calculation programs for calculation, generating a result file, directly updating the Mysql universal database according to the information of the result file, and displaying the Mysql universal database by using a report.
Technical effects
The power grid special data management database Comdb is used for processing power grid information, and is high in speed, good in expansibility, simple and easy to use.
The power grid special data management database Comdb has strong support for other applications.
The database can quickly establish a power grid topological structure, quickly search specified information, store the topological power grid structural information and improve the simulation efficiency because the topological power grid structural information is not in the topological state for subsequent processing.
The method can quickly topology out the power grid structure, analyze the relation among power grid equipment, and manage and maintain power grid information, and on the basis, the database can also support other applications, such as single line diagram programs and the like, and has strong expansibility and easy maintainability.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
fig. 1 is a flowchart of an application method of a database based on memory storage in power system analysis.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
With the rapid construction of power grids and the use of various new power facilities, power grids are increasingly becoming larger and more complex. This has led to a rapid increase in the amount of data in grid simulation software.
In the power grid simulation software, a database is generally adopted to store mass data. Most of the current mainstream database technologies are general database technologies, that is: the efficiency of increasing, deleting, modifying and checking is balanced, the efficiency of transaction processing, fault recovery, parallelism, data safety and the like is balanced, the score is very high in the aspect of comprehensive performance, but the score may be lower in the aspect of certain characteristic. In the power grid simulation, most data cannot change too much, and more data are continuously finely adjusted to realize various simulations. Therefore, if the power grid simulation is realized by adopting the general database technology, along with the continuous increase of the data volume, the simulation speed is exponentially reduced according to the characteristics of the power grid simulation, and the user experience and the working efficiency are seriously influenced.
Aiming at the characteristics of power grid data and simulation, the power grid data are stored in a memory, and a specific mathematical method and a computer method are combined, so that some non-common functions are abandoned, the efficiency of some common functions is optimized, and a high-efficiency database special for the power grid is realized.
The invention aims to solve the technical problems that a method is adopted to realize the functions similar to a database, the operations of increasing, deleting, checking, topology, checking and the like of data can be carried out more quickly, and the method can be used as a core data hub of the whole program to provide support for the graphic display of the program, the calculation of various modules and the module interaction, thereby improving the execution efficiency of the simulation program under the condition of continuously increasing data volume.
The power grid special data management database comdb is a set of self-developed power grid special data management databases, and the databases store data in the memory to improve the performance of the database at high speed. The power grid data is characterized in that the searching operation is more, the operation of increasing, deleting and modifying is less, therefore, the performance of data searching is optimized by adopting a binary searching method, the structural information of the power grid is additionally stored, the repeated searching operation is avoided, and the efficiency is improved, the binary searching method is a basic algorithm in mathematics, the basic idea is that one datum is not black or white, for the well-ordered datum, the ascending order is assumed, if the given datum X is to be searched, the comparison is started from the middle position of the sequence, and if the datum at the middle position is X, the searching is successful; if X is smaller than the data of the middle position, the data must be positioned between the real position and the middle position, the data behind the middle position do not participate in comparison any more, the initial position to the middle position are used as a new sequence, and the method is used for searching again; similarly, if X is larger than the data at the middle position, the data must be located between the middle position and the end position, the data before the middle position is not involved in the comparison any more, the middle position to the end position is regarded as a new sequence, and the method is used again for searching.
And the power grid data are stored in a universal database Mysql stored in a hard disk of the computer in a persistent mode.
The power grid data in the universal database Mysql is inquired and accessed by the power grid special data management database comdb, and the power grid data is stored by the power grid special data management database comdb in a linked list mode. Therefore, when the power grid data is stored, the memory allocation is performed on each record in a linked list mode, so that the problem of memory allocation failure is solved. And distributing each record, sequencing the record according to the name, copying data into a managed memory field by field for use, and searching for the specified data by using a binary search method because the data read into the memory is the data sequenced according to the name.
The data read into the comdb needs to be verified. During verification, validity and reasonability check of data of partitions, areas, stations, nodes, elements and the like are required. For example, the partition checking is to check whether the name of each partition is null or not, if so, the information is output to the log, and the subsequent operation is skipped; and if the data is correct, searching the station information corresponding to the partition by adopting a dichotomy, if the corresponding area information is not found, outputting the information to a log, skipping subsequent operation, and otherwise, recording the searched area information into the partition. If the partition has corresponding area information, the relationship between the partition and the area needs to be separately stored for subsequent searching.
Similarly, the method also comprises similar checking operation for other data, and the relationship between the partitions and the plant station, between the plant station and the bus, between the plant station and each element, between the bus and the node, and between the node and each element is independently stored. Therefore, once data verification is completed, the data relation between the power grids is processed, and when the device is used subsequently, the existing data relation can be directly used without inquiring again.
At this time, the combb adds two auxiliary topology tables, which are bs and bsl respectively, where bs is used for storing the computing nodes, and bsl is used for storing the relationship of the whole power grid. Firstly, initializing a bs table, sequentially initializing the bs table according to node information, and skipping a certain node if the node to which the node belongs already exists in the bs. After the bs is initialized, nodes in the bs are numbered in sequence, then the whole power grid is traversed according to a breadth search method, and the searched power grid relation is stored in the bsl.
After the whole power grid is searched, the power grid can be divided into one or more independent areas according to the relation between the devices, then each area is numbered, each area is searched one by one, whether a generator or a load exists in the area is judged, and the area is judged to be an active area or a dead area. And finally, storing the information in the bsl into other records for subsequent processing.
According to the current calculation type, different processing is carried out, if load flow calculation is carried out, a new memory is opened up by the comdb, data are copied into the new memory according to a format required by a load flow calculation program, the load flow calculation program is carried out, the content of the comdb in the power grid special data management database is updated according to calculation result information after calculation is finished, the content in the new memory is calculated result information, the final result is updated into the universal database Mysql, and the result information is displayed by a report; if the Mysql is in other types of calculation, generating a corresponding calculation file according to the calculation file format, reading the calculation file by other calculation programs for calculation, generating a result file, directly updating the Mysql universal database according to the information of the result file, and displaying the Mysql universal database by using a report.
Technical effects
The power grid special data management database Comdb is used for processing power grid information, and is high in speed, good in expansibility, simple and easy to use.
The power grid special data management database Comdb has strong support for other applications.
The database can quickly establish a power grid topological structure, quickly search specified information, store the topological power grid structural information and improve the simulation efficiency because the topological power grid structural information is not in the topological state for subsequent processing.
The method can quickly topology out the power grid structure, analyze the relation among power grid equipment, and manage and maintain power grid information, and on the basis, the database can also support other applications, such as single line diagram programs and the like, and has strong expansibility and easy maintainability.
Claims (7)
1. A method for optimizing database technology for grid simulation efficiency, the method comprising:
the universal database Mysql stores power grid data;
the power grid data in the universal database Mysql are inquired by the power grid special data management database comdb and are sorted according to names, the power grid data are stored by the power grid special data management database comdb in a linked list mode, each record is distributed, the data are copied into a managed memory field by field for use, and designated data are searched by a binary search method;
checking validity and reasonableness of the data read into the partitions, areas, stations, nodes and elements in the power grid dedicated data management database comdb; after the checking operation is finished, independently storing the relations between the partitions and the plant stations, between the plant stations and the buses, between the plant stations and the elements, between the buses and the nodes, between the nodes and the elements;
after the data preparation is completed, a data topological structure is established, an auxiliary topological table bs for storing a computing node and an auxiliary topological table bsl for storing the relation of the whole power grid are added to a data management database comdb special for the power grid, the auxiliary topological table bs is initialized in sequence according to node information, the nodes in the auxiliary topological table bs are numbered in sequence, the whole power grid is traversed according to a breadth search method, and the searched power grid relation is stored in the auxiliary topological table bsl;
after the whole power grid is searched, the power grid can be divided into one or more independent areas according to the relation between the devices, and then each area is numbered and searched one by one;
carrying out different processing according to the current calculation type, if the current calculation type is load flow calculation, carrying out a load flow calculation program, updating the content of the power grid special data management database comdb according to the calculation result information after the calculation is finished, updating the final result into a universal database Mysql, and displaying the result information by using a report; if the Mysql is in other types of calculation, generating a corresponding calculation file according to the calculation file format, reading the calculation file by other calculation programs for calculation, generating a result file, directly updating the Mysql universal database according to the information of the result file, and displaying the Mysql universal database by using a report.
2. The method according to claim 1, characterized in that the grid data is characterized by a plurality of searching operations and a small number of operations for increasing and deleting, so that the performance of data searching is optimized by a binary searching method, the structural information of the grid is additionally stored, and repeated searching operations are avoided, thereby improving the efficiency, the binary searching method is a basic algorithm in mathematics, the basic idea is that one data is not black or white, for the data in an ordered sequence, the ascending order is assumed, if the given data X is to be searched, the comparison is started from the middle position of the sequence, and if the data in the middle position is X, the searching is successful; if X is smaller than the data of the middle position, the data must be positioned between the real position and the middle position, the data behind the middle position do not participate in comparison any more, the initial position to the middle position are used as a new sequence, and the method is used for searching again; similarly, if X is larger than the data at the middle position, the data must be located between the middle position and the end position, the data before the middle position is not involved in the comparison any more, the middle position to the end position is regarded as a new sequence, and the method is used again for searching.
3. A method according to claim 1, characterized in that said checking is performed according to validity, rationality checks of the partition, area, station, node and element data read into the grid specific data management database comdb, further comprising, for example, partition checks, for each piece of partition information, checking if the partition name is empty, if it is empty, outputting this information to the log and skipping the subsequent operations; if the data is correct, the plant station information corresponding to the partition is searched by adopting a bisection method, if the corresponding area information is not found, the information is output to a log, the subsequent operation is skipped, otherwise the searched area information is recorded into the partition, if the partition has the corresponding area information, the relation between the partition and the area needs to be separately stored for the subsequent searching, similarly, the similar checking operation is carried out on other data, and the relations between the partition and the plant station, the plant station and the bus, the plant station and the elements, the bus and the nodes, the nodes and the elements are separately stored.
4. The method of claim 1, wherein nodes in the secondary topology table bs are numbered in sequence based on initializing the secondary topology table bs in turn, further comprising skipping a node if the computing node to which the node belongs already exists in the secondary topology table bs.
5. The method as recited in claim 1, characterized in that, when the load flow calculation is performed, the grid-dedicated data management database comdb creates a new memory, and copies the data into the new memory according to the format required by the load flow calculation program, and transmits the data to the load flow program for load flow calculation, after the calculation is completed, the content in the new memory is the result information after the calculation, and the grid-dedicated data management database comdb updates the content thereof according to the result information, because the grid-dedicated data management database comdb is temporarily stored, the final result needs to be updated into the universal database Mysql.
6. The method as recited in claim 1, wherein the grid specific data management database comdb is a set of self-developed grid specific data management databases that store data in memory to improve performance at high speed.
7. The method according to claim 1, wherein the grid-specific data management database comdb occupies a relatively large amount of memory because of a large amount of grid data, and if the data is stored in an array manner, a whole memory with a corresponding size cannot be found in the memory, which results in a failure in memory allocation; therefore, when the power grid data is stored, the memory allocation is performed on each record in a linked list mode, so that the problem of memory allocation failure is solved.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011609286.5A CN113032428B (en) | 2020-12-30 | 2020-12-30 | Method for realizing power grid simulation efficiency by optimizing database technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011609286.5A CN113032428B (en) | 2020-12-30 | 2020-12-30 | Method for realizing power grid simulation efficiency by optimizing database technology |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113032428A true CN113032428A (en) | 2021-06-25 |
| CN113032428B CN113032428B (en) | 2024-02-23 |
Family
ID=76459372
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011609286.5A Active CN113032428B (en) | 2020-12-30 | 2020-12-30 | Method for realizing power grid simulation efficiency by optimizing database technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113032428B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7701877B1 (en) * | 2006-09-28 | 2010-04-20 | Emc Corporation | Methods and apparatus for representing and querying storage area network (SAN) topology |
| CN105373008A (en) * | 2015-11-10 | 2016-03-02 | 中国电力科学研究院 | Full physics model simulation method for electric power system |
| CN107862159A (en) * | 2017-12-06 | 2018-03-30 | 中国电力科学研究院有限公司 | A kind of grid simulation calculates data managing method and system and emulation mode and system |
-
2020
- 2020-12-30 CN CN202011609286.5A patent/CN113032428B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7701877B1 (en) * | 2006-09-28 | 2010-04-20 | Emc Corporation | Methods and apparatus for representing and querying storage area network (SAN) topology |
| CN105373008A (en) * | 2015-11-10 | 2016-03-02 | 中国电力科学研究院 | Full physics model simulation method for electric power system |
| CN107862159A (en) * | 2017-12-06 | 2018-03-30 | 中国电力科学研究院有限公司 | A kind of grid simulation calculates data managing method and system and emulation mode and system |
Non-Patent Citations (1)
| Title |
|---|
| 徐蔚;任雷;徐政;: "电力系统潮流图自动生成软件的设计与实现", 电力系统及其自动化学报, no. 04, 31 August 2008 (2008-08-31), pages 46 - 50 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113032428B (en) | 2024-02-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107688999B (en) | Block chain-based parallel transaction execution method | |
| CN108600321A (en) | A kind of diagram data storage method and system based on distributed memory cloud | |
| CN109522428B (en) | External memory access method of graph computing system based on index positioning | |
| CN103678519A (en) | Mixed storage system and mixed storage method for supporting Hive DML (data manipulation language) enhancement | |
| CN105389367A (en) | Power network graphic multi-tense and multi-level distributed storage method based on Mongo database | |
| CN108009265B (en) | Spatial data indexing method in cloud computing environment | |
| CN102819569A (en) | Matching method for data in distributed interactive simulation system | |
| CN106484815A (en) | A kind of automatic identification optimization method for retrieving scene based on mass data class SQL | |
| CN113326343B (en) | Road network data storage method and system based on multi-level grids and file indexes | |
| CN109189994B (en) | CAM structure storage system for graph computation application | |
| CN113220578A (en) | Method for generating function test case | |
| CN112486959A (en) | Graph database technology-based intelligent identification method for dynamic topological structure of power grid | |
| CN113032428A (en) | Method for optimizing database technology to realize power grid simulation efficiency | |
| CN112817982B (en) | Dynamic power law graph storage method based on LSM tree | |
| CN101556604B (en) | Method for automatically generating optimization strategy orientating complex data warehouse environment | |
| Fu et al. | A modified tabu search algorithm to solve vehicle routing problem | |
| Faiz et al. | Database replica management strategies in multidatabase systems with mobile hosts | |
| CN103366234A (en) | System and method for operation procedure management | |
| CN106844242B (en) | A kind of method for interchanging data and system | |
| CN113434540B (en) | Dependency relationship generation method and system in application driving data generation supporting left external connection | |
| Peng et al. | Query optimization for air quality big data based on hive-orc | |
| Deris et al. | High system availability using neighbor replication on grid | |
| CN116720578B (en) | Storage method of knowledge graph with space-time characteristics | |
| CN114123258B (en) | Parallel optimization method and system for wind-solar energy storage capacity configuration | |
| CN107145548A (en) | A kind of Parallel Sequence mode excavation method based on Spark platforms |
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 |