CN113032428B - Method for realizing power grid simulation efficiency by optimizing database technology - Google Patents
Method for realizing power grid simulation efficiency by optimizing database technology Download PDFInfo
- Publication number
- CN113032428B CN113032428B CN202011609286.5A CN202011609286A CN113032428B CN 113032428 B CN113032428 B CN 113032428B CN 202011609286 A CN202011609286 A CN 202011609286A CN 113032428 B CN113032428 B CN 113032428B
- Authority
- CN
- China
- Prior art keywords
- data
- power grid
- calculation
- comdb
- grid
- 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
- 238000000034 method Methods 0.000 title claims abstract description 39
- 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 44
- 238000013523 data management Methods 0.000 claims abstract description 31
- 238000011282 treatment Methods 0.000 claims abstract description 4
- 238000002360 preparation method Methods 0.000 claims abstract description 3
- 238000005192 partition Methods 0.000 claims description 28
- 230000001174 ascending effect Effects 0.000 claims description 2
- 238000004422 calculation algorithm Methods 0.000 claims description 2
- 238000007689 inspection Methods 0.000 claims description 2
- 230000006870 function Effects 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000010365 information processing Effects 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
- 230000003319 supportive effect Effects 0.000 description 2
- 238000013524 data verification Methods 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
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 realizing the simulation efficiency of a power grid by optimizing a database technology, wherein a power grid special data management database comdb adopts a linked list mode to inquire and store power grid data in a universal database Mysql, a binary search method is used for searching appointed data, validity and rationality check is carried out on the read data in the comdb and the read data are independently stored, a data topological structure is established after the data preparation is completed, different treatments are carried out according to calculation types, if trend calculation is carried out, a trend calculation program is carried out, after calculation is completed, the power grid special data management database comdb updates own content according to calculation result information, a final result is updated into the universal database Mysql, and the result information is displayed by a report; if the calculation is of other types, a corresponding calculation file is generated according to the calculation file format, other calculation programs read the calculation file to calculate and generate a result file, and the general database Mysql is directly updated according to the information of the result file and is displayed 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 a database technology to achieve power grid simulation efficiency.
Background
The power industry is the most important basic industry of the country, plays an extremely important role in daily life and social production of people, and in recent years, the comprehensive national force of the country is rapidly improved, the power demand is also larger and larger, and in order to meet the power demands in all aspects, the power system is required to be continuously improved, and new technologies are researched. However, with the rapid construction of the power grid and the use of various new electric power facilities, the power grid is increasingly bulky and complicated. This results in a rapid increase in the amount of data in the grid simulation software.
In the power grid simulation software, a database is generally used for storing massive data. Most of the current mainstream database technologies are general database technologies, namely: the efficiency of adding, deleting and modifying is balanced, the efficiency of transaction processing, fault recovery, parallelism, data security and the like are balanced, the score is high in the aspect of comprehensive performance, but in the aspect of a certain characteristic, the score is possibly lower. In the power grid simulation, most of data cannot be changed too much, and more data are subjected to continuous fine adjustment to realize various simulations. Therefore, if the universal database technology is adopted to realize the power grid simulation, the simulation speed is exponentially reduced according to the characteristics of the power grid simulation along with the continuous increase of the data volume, and the user experience and the working efficiency are seriously affected.
Disclosure of Invention
Aiming at the characteristics of power grid data and simulation, the power grid data is stored into a memory, and a special mathematical method and a special computer method are combined to discard some very common functions, optimize the efficiency of some common functions and realize a special efficient database of a power grid.
The invention aims to solve the technical problems that a method is adopted to realize the function similar to a database, can more rapidly perform operations such as adding, deleting, checking, topology, checking and the like of data, can be used as a core data hub of the whole program, and provides support for graphic display of the program, calculation of various modules and module interaction, thereby improving the execution efficiency of the simulation program under the condition of continuously increasing data quantity.
The first step is to store the power grid data in a lasting way through a general database Mysql stored in a hard disk of a computer.
Secondly, inquiring and accessing the power grid data in the universal database Mysql by using a power grid special data management database comdb, storing the power grid data in a linked list mode by using the power grid special data management database comdb, and distributing the power grid data for each record; and ordering the data according to the names, copying the data into the managed memory field by field for use, and because the data read into the memory is the data ordered according to the names, a binary search method can be used when searching the specified data.
Thirdly, checking the validity and rationality of the partitions, the areas, the stations, the nodes and the data of each element read into the power grid special data management database comdb; for example, checking the partition, checking whether the partition name is empty for each piece of partition information, if so, outputting the information to a log, and skipping the subsequent operation; if the data is correct, the station information corresponding to the partition is searched by adopting a dichotomy, if the corresponding area information is not found, the information is output to a log, and the subsequent operation is skipped, otherwise, the found area information is recorded in the partition. If the partition has corresponding region information, the relationship between the partition and the region is also required to be stored separately for subsequent searching; after the inspection operation is completed, 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, and between the nodes and the elements are stored independently.
Fourth, after data preparation is completed, a data topological structure is established, an auxiliary topological table bs for storing calculation nodes and an auxiliary topological table bsl for storing the relation of the whole power grid are added to a power grid special data management database comdb, 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.
And fifthly, after the whole power grid search is completed, the power grid can be divided into one or more independent areas according to the relation among the devices, each area is numbered, each area is searched one by one, and whether a generator or a load exists in the area is judged to judge whether the area is an active area or a dead area. And finally, saving the information in the bsl to other records for subsequent processing.
Step six, carrying out different treatments according to the current calculation type, if the current calculation type is adopted, the comdb opens up a new memory, and copies data into the new memory according to the format required by the current calculation program, so as to carry out the current calculation program, after the calculation is finished, the power grid special data management database comdb updates the content according to the calculation result information, the content in the new memory is the calculated result information, the final result is updated into the general database Mysql, and the result information is displayed by a report; if the calculation is of other types, a corresponding calculation file is generated according to the calculation file format, other calculation programs read the calculation file to calculate and generate a result file, and the general database Mysql is directly updated according to the information of the result file and is displayed by using a report.
Technical effects
The power grid information processing is carried out on the power grid special data management database Comdb, so that the speed is high, the expansibility is good, and the method is simple and easy to use.
The grid-specific data management database Comdb is strongly supportive for other applications.
The database can quickly construct a power grid topological structure, quickly find out appointed information, store topological power grid structural information, and prevent topology from being used for subsequent processing, so that simulation efficiency is improved.
The method can rapidly topology the power grid structure, analyze the relation between power grid equipment, manage and maintain the 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
Exemplary embodiments of the present invention may be more completely understood in consideration of the following drawings:
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 examples described herein, which are provided to fully and completely disclose the present invention and fully convey the scope of the 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, like elements/components are referred to by like reference numerals.
Unless otherwise indicated, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art. In addition, it will be understood that terms 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.
Embodiments of the present invention are described in detail below, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to like or similar elements or elements having like or similar functions throughout. The embodiments described below by referring to the drawings are illustrative and intended to explain the present invention and should not be construed as limiting the invention.
With the rapid construction of the power grid and the use of various new electric power facilities, the power grid is increasingly huge and complicated. This results in a rapid increase in the amount of data in the grid simulation software.
In the power grid simulation software, a database is generally used for storing massive data. Most of the current mainstream database technologies are general database technologies, namely: the efficiency of adding, deleting and modifying is balanced, the efficiency of transaction processing, fault recovery, parallelism, data security and the like are balanced, the score is high in the aspect of comprehensive performance, but in the aspect of a certain characteristic, the score is possibly lower. In the power grid simulation, most of data cannot be changed too much, and more data are subjected to continuous fine adjustment to realize various simulations. Therefore, if the universal database technology is adopted to realize the power grid simulation, the simulation speed is exponentially reduced according to the characteristics of the power grid simulation along with the continuous increase of the data volume, and the user experience and the working efficiency are seriously affected.
Aiming at the characteristics of power grid data and simulation, the power grid data is stored into a memory, and a special mathematical method and a special computer method are combined to discard some very common functions, optimize the efficiency of some common functions and realize a special efficient database of a power grid.
The invention aims to solve the technical problems that a method is adopted to realize the function similar to a database, can more rapidly perform operations such as adding, deleting, checking, topology, checking and the like of data, can be used as a core data hub of the whole program, and provides support for graphic display of the program, calculation of various modules and module interaction, thereby improving the execution efficiency of the simulation program under the condition of continuously increasing data quantity.
The power grid specific data management database comdb is a set of power grid specific data management databases which are independently developed and store data in the memory, so that the performance of the power grid specific data management databases is improved through the high-speed memory. The power grid data is characterized in that the searching operation is more, the adding and deleting operations are less, so that the data searching performance is mainly optimized by adopting a binary searching method, the structural information of the power grid is additionally stored, the repeated searching operation is avoided, the efficiency is improved, the binary searching method is a basic algorithm in mathematics, the basic idea is that one data is not black and white, for ordered data, the ascending order is assumed, if given data X is to be searched, the data X is compared from the middle position of the sequence, and if the data of the middle position is X, the searching is successful; if X is smaller than the data of the intermediate position, the data is positioned between the actual position and the intermediate position, the data after the intermediate position is not involved in comparison any more, the initial position is taken as a new sequence from the intermediate position to the intermediate position, and the method is used for searching again; similarly, if X is greater than the data at the intermediate position, the data must be located between the intermediate position and the end position, then the data before the intermediate position is no longer involved in the comparison, the intermediate position and the end position are regarded as a new sequence, and the method is used again to search, and half of the data can be discarded each time of the comparison, so that the method is very suitable for being adopted when the data amount is very large and the data is ordered.
And carrying out persistent storage on the power grid data through a universal database Mysql stored in a computer hard disk.
The power grid data in the general database Mysql is queried and accessed by the power grid special data management database comdb, the power grid special data management database comdb stores the power grid data in a linked list mode, and because the power grid data volume is large, the comdb occupies more memory, if the power grid special data management database is stored in an array mode, the whole memory with the corresponding size cannot be found in the memory, and the memory allocation fails. Therefore, when storing the power grid data, a linked list mode is adopted to carry out memory allocation for each record, so that the problem of memory allocation failure is avoided. Each record is allocated and sorted according to names, and data is copied into the managed memory field by field for use, and because the data read into the memory is the data sorted according to names, a binary search method can be used when searching the specified data.
The data read into comdb needs to be verified. During verification, validity and rationality checking needs to be carried out on data such as partitions, areas, stations, nodes, elements and the like. For example, checking the partition, checking whether the partition name is empty for each piece of partition information, if so, outputting the information to a log, and skipping the subsequent operation; if the data is correct, the station information corresponding to the partition is searched by adopting a dichotomy, if the corresponding area information is not found, the information is output to a log, and the subsequent operation is skipped, otherwise, the found area information is recorded in the partition. If the partition has corresponding region information, the relationship between the partition and the region is also required to be stored separately for subsequent searching.
Similarly, the other data is similar to the checking operation, and the relations of the subareas and the factory stations, the factory stations and the buses, the factory stations and the elements, the buses and the nodes, the nodes and the elements are independently stored. So far, once data verification is finished, the data relationship between the power grids is processed, and the existing data relationship can be directly used without inquiring again in the subsequent use.
At this time, comdb adds two auxiliary topology tables, bs and bsl, respectively, where bs is used to store the computing nodes and bsl is used to store the relationship of the whole grid. The bs table is initialized firstly, the bs table is initialized in sequence according to the node information, and if the computing node to which a certain node belongs exists in bs, the node is skipped. After the bs are initialized, the nodes in the bs are numbered in sequence, then the whole power grid is traversed according to the breadth search method, and the searched power grid relation is stored in bsl.
After the whole power grid search is completed, the power grid can be divided into one or more independent areas according to the relation among the devices, each area is numbered, each area is searched one by one, and whether a generator or a load exists in the area is judged to judge whether the area is an active area or a dead area. And finally, saving the information in the bsl to other records for subsequent processing.
According to the current calculation type, different treatments are carried out, if the current calculation type is adopted, the comdb opens up a new memory, data is copied into the new memory according to a format required by a power flow calculation program, the power flow calculation program is carried out, after the calculation is finished, the power grid special data management database comdb updates own content according to calculation result information, the content in the new memory is calculated result information, a final result is updated into a general database Mysql, and the result information is displayed by a report; if the calculation is of other types, a corresponding calculation file is generated according to the calculation file format, other calculation programs read the calculation file to calculate and generate a result file, and the general database Mysql is directly updated according to the information of the result file and is displayed by using a report.
Technical effects
The power grid information processing is carried out on the power grid special data management database Comdb, so that the speed is high, the expansibility is good, and the method is simple and easy to use.
The grid-specific data management database Comdb is strongly supportive for other applications.
The database can quickly construct a power grid topological structure, quickly find out appointed information, store topological power grid structural information, and prevent topology from being used for subsequent processing, so that simulation efficiency is improved.
The method can rapidly topology the power grid structure, analyze the relation between power grid equipment, manage and maintain the 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 to achieve grid simulation efficiency, the method comprising:
the general database Mysql stores power grid data;
the power grid data in the universal database Mysql is queried and ordered according to the name by the power grid special data management database comdb, the power grid special data management database comdb stores the power grid data in a linked list mode, each record is allocated, the data is copied into the managed memory field by field for use, and a binary search method is used for searching the appointed data;
checking the validity and rationality of the partitions, the areas, the stations, the nodes and the data of each element read into the power grid special data management database comdb; after the inspection operation is finished, the relations between the partitions and the factory stations, between the factory stations and the bus, between the factory stations and each element, between the bus and the node, and between the node and each element are independently stored;
after data preparation is completed, a data topology structure is established, an auxiliary topology table bs for storing computing nodes and an auxiliary topology table bsl for storing the relation of the whole power grid are added to a power grid special data management database comdb, the auxiliary topology table bs is initialized in sequence according to node information, the nodes in the auxiliary topology 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 topology table bsl;
after the whole power grid search is completed, the power grid can be divided into one or more independent areas according to the relation among the devices, and then each area is numbered and searched one by one;
carrying out different treatments according to the current calculation type, if the current calculation type is the current calculation, carrying out a current calculation program, updating the content of the power grid special data management database comdb according to calculation result information after the calculation is finished, updating the final result into a general database Mysql, and displaying the result information by using a report; if the calculation is of other types, a corresponding calculation file is generated according to the calculation file format, other calculation programs read the calculation file to calculate and generate a result file, and the general database Mysql is directly updated according to the information of the result file and is displayed by using a report.
2. The method according to claim 1, characterized in that the grid data features more searching operations and less adding and deleting operations, so that the performance of data searching is optimized by adopting a binary search method, structural information of the grid is additionally stored, repeated searching operations are avoided, so that the efficiency is improved, the binary search method is a basic algorithm in mathematics, the basic idea is that one data is not black and white, for the ordered data, the ascending order is assumed, if given data X is to be searched, the comparison is started from the middle position of the sequence, and if the data of the middle position is X, the searching is successful; if X is smaller than the data of the intermediate position, the data is positioned between the actual position and the intermediate position, the data after the intermediate position is not involved in comparison any more, the initial position is taken as a new sequence from the intermediate position to the intermediate position, and the method is used for searching again; similarly, if X is greater than the data at the intermediate position, the data must be located between the intermediate position and the end position, then the data before the intermediate position is no longer involved in the comparison, the intermediate position and the end position are regarded as a new sequence, and the method is used again to search, and half of the data can be discarded each time of the comparison, so that the method is very suitable for being adopted when the data amount is very large and the data is ordered.
3. Method according to claim 1, characterized in that the checking of validity, rationality, of the partitions, areas, stations, nodes and various element data read into the grid-specific data management database comdb is performed, further comprising, for example, a partition check, checking for each piece of partition information, if the partition name is empty, outputting this information to a log and skipping the following operations; if the data is correct, the station information corresponding to the partition is searched by adopting a dichotomy, if the corresponding area information is not found, the information is output to a log, and the subsequent operation is skipped, otherwise, the searched area information is recorded to the partition, if the partition has the corresponding area information, the relationship between the partition and the area is also required to be independently saved for subsequent searching, and similarly, other data is similarly checked, and the relationship between the partition and the station, the station and the bus, the station and each element, the bus and node and each element is independently saved.
4. The method of claim 1, wherein the nodes in the auxiliary topology table bs are numbered sequentially according to the sequential initialization of the auxiliary topology table bs, and further comprising skipping a node if the computing node to which the node belongs already exists in the auxiliary topology table bs.
5. The method according to claim 1, wherein when the power flow calculation is performed, the grid-specific data management database comdb opens up a new memory, copies data into the new memory according to a format required by the power flow calculation program, and transmits the data to the power flow program for performing the power flow calculation, after the calculation is completed, the content in the new memory is calculated result information, and the grid-specific data management database comdb updates its content according to the result information, because the grid-specific data management database comdb is temporarily stored, and the final result also needs to be updated into the general database Mysql.
6. The method of claim 1, wherein the grid-specific data management database comdb is an autonomously developed grid-specific data management database that stores data in memory to enhance its own performance at high speed.
7. The method of 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 grid-specific data management database comdb is stored in an array manner, a whole memory with a corresponding size cannot be found in the memory, so that memory allocation fails; therefore, when storing the power grid data, a linked list mode is adopted to carry out memory allocation for each record, so that the problem of memory allocation failure is avoided.
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 CN113032428A (en) | 2021-06-25 |
| CN113032428B true 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 |
|---|
| 电力系统潮流图自动生成软件的设计与实现;徐蔚;任雷;徐政;;电力系统及其自动化学报;20080831(第04期);第46-50页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113032428A (en) | 2021-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022100233A1 (en) | Graph database-based power grid retrieval method and system | |
| CN102663117B (en) | OLAP (On Line Analytical Processing) inquiry processing method facing database and Hadoop mixing platform | |
| CN104484472B (en) | A kind of data-base cluster and implementation method of a variety of heterogeneous data sources of mixing | |
| CN104361113B (en) | A kind of OLAP query optimization method under internal memory flash memory mixing memory module | |
| CN106569896B (en) | A kind of data distribution and method for parallel processing and system | |
| CN108921728B (en) | Distributed real-time library system based on power grid dispatching system | |
| CN112015741A (en) | Method and device for storing massive data in different databases and tables | |
| Naheman et al. | Review of NoSQL databases and performance testing on HBase | |
| CN107330098B (en) | Query method, computing node and query system for custom report | |
| US11886410B2 (en) | Database live reindex | |
| Kan et al. | Topology modeling and analysis of a power grid network using a graph database | |
| CN114329096A (en) | Method and system for processing native map database | |
| CN111858730A (en) | Data importing and exporting device, method, equipment and medium of graph database | |
| US8639657B2 (en) | Reorganizing table-based data objects | |
| CN103365987A (en) | Clustered database system and data processing method based on shared-disk framework | |
| US20130041887A1 (en) | Adding entries to an index based on use of the index | |
| US20170270149A1 (en) | Database systems with re-ordered replicas and methods of accessing and backing up databases | |
| CN113032428B (en) | Method for realizing power grid simulation efficiency by optimizing database technology | |
| CN110990340B (en) | Big data multi-level storage architecture | |
| CN111930862A (en) | SQL interactive analysis method and system based on big data platform | |
| CN111666302A (en) | User ranking query method, device, equipment and storage medium | |
| CN112000666B (en) | Database management system of facing array | |
| He et al. | SLC-index: A scalable skip list-based index for cloud data processing | |
| CN112434010A (en) | Interaction method for master station database of electricity consumption information acquisition system | |
| CN107515867A (en) | The generation method and device that data storage, querying method and the device and a kind of rowKey of a kind of NoSQL databases combine entirely |
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 |