CN113836185A - Power grid model version control and tracing management method and device - Google Patents
Power grid model version control and tracing management method and device Download PDFInfo
- Publication number
- CN113836185A CN113836185A CN202111138885.8A CN202111138885A CN113836185A CN 113836185 A CN113836185 A CN 113836185A CN 202111138885 A CN202111138885 A CN 202111138885A CN 113836185 A CN113836185 A CN 113836185A
- Authority
- CN
- China
- Prior art keywords
- power grid
- grid model
- version
- data
- file
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 33
- 238000013507 mapping Methods 0.000 claims abstract description 25
- 238000000034 method Methods 0.000 claims abstract description 20
- 238000004458 analytical method Methods 0.000 claims abstract description 17
- 238000004422 calculation algorithm Methods 0.000 claims abstract description 12
- 238000004364 calculation method Methods 0.000 claims abstract description 12
- 230000008520 organization Effects 0.000 claims abstract description 12
- 238000012545 processing Methods 0.000 claims description 8
- 230000005540 biological transmission Effects 0.000 claims description 2
- 239000013589 supplement Substances 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 11
- 238000004590 computer program Methods 0.000 description 10
- 238000012217 deletion Methods 0.000 description 7
- 230000037430 deletion Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000013461 design Methods 0.000 description 2
- 239000003550 marker Substances 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012546 transfer 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- 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/2455—Query execution
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Mathematical Physics (AREA)
- Human Resources & Organizations (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (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)
Abstract
The invention relates to a power grid model version control and tracing management method and a device, comprising the steps of obtaining a power grid model file; analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation; inquiring and acquiring a corresponding version model of a corresponding date according to the data table; and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment calculation on the corresponding file by adopting a shipment algorithm. The invention provides a power grid model adding, editing, deleting, inquiring full-flow and closed-loop version control method, which supplements and perfects the version operation that only supports incremental data and does not support power grid model editing and deleting in the existing power grid model management method, effectively supports the requirements of the power grid model management storage and accurate restoration of the power grid model management in the power spot market, and improves the efficiency and accuracy of spot shipment.
Description
Technical Field
The invention belongs to the technical field of power markets, and particularly relates to a power grid model version control and tracing management method and device.
Background
With the fact that spot shipment test operation is started successively in the first 8 test-point areas in the country, spot shipment market clearing settlement is more frequent, how to guarantee spot shipment clearing efficiency and accuracy becomes a problem that a market builder and a market participant pay close attention to, wherein version storage and restoration modes of electric network model data are important factors influencing spot shipment clearing accuracy and efficiency.
In the field of the existing power industry, a power grid model data version control method mainly realizes increment control of a power grid model through two types of database tables, wherein one type of database table is a version information table (namely a VersionInfo table) and records version numbers and version submission time, the other type of database table is a data and version submission time table and correlates cim file data rows with version submission time, the version submission time can be inquired through the version number of the VersionInfo table, then, all data records less than or equal to the time are inquired through the version submission time, only the storage and the inquiry of the incremental data of the power grid model are realized, for the edition and deletion of the model data, version control and management are not performed, the change of the model data cannot be managed, and the requirements of the existing power spot shipment on the accurate record, storage and restoration of the model data version cannot be met, so that the problems of low efficiency and low accuracy of the power spot shipment in the power spot shipment market are caused.
Disclosure of Invention
In view of the above, the present invention aims to overcome the defects of the prior art, and provide a method and a device for power grid model version control and trace management, so as to solve the problem that the prior art cannot meet the requirements of accurate recording, storage and restoration of the model data version in the existing power spot shipment, which results in low efficiency and accuracy in the existing power spot shipment.
In order to achieve the purpose, the invention adopts the following technical scheme: a power grid model version control and tracing management method comprises the following steps:
acquiring a power grid model file;
analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table created in a database according to a preset mapping relation;
inquiring and acquiring a corresponding version model of a corresponding date according to the data table;
and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment inventory calculation on the corresponding file by adopting an inventory algorithm.
Further, based on a security file transmission protocol, the latest power grid model file is obtained from the power grid model source file storage position, and the power grid model file is transmitted to the local server.
Further, the analyzing the power grid model file to obtain power grid model data and storing the power grid model data in a database includes:
reading the power grid model file from a local server and analyzing to obtain the attribute of the power grid model file;
mapping each data component of the power grid model file into a database through a database middleware according to a preset mapping relation; and the mapping relation is the mapping between the data component of the power grid model file and a database table in the database.
Further, the power grid model file is analyzed through an xml analysis tool.
Further, before each data component is stored in a database table in the database, the method further includes:
judging the attribute of the data; the attribute comprises newly added and edited data or deleted data in the database;
carrying out corresponding processing on the data according to the attribute of the data;
and storing the processed data into a corresponding database table.
Further, the database table includes:
the model table, the maximum version table and the date version are relatively against the table.
Further, the constraint relationship includes:
maximum output, minimum output, maximum power, minimum power, whether power constraints are considered.
The embodiment of the application provides a power grid model version control and tracing management device, includes:
the acquisition module is used for acquiring a power grid model file;
the analysis module is used for analyzing the power grid model file and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation;
the query module is used for querying and acquiring a corresponding version model of a corresponding date according to the data table;
and the computing module is used for combining the constraint relation of the corresponding version model according to a preset data organization rule, generating a corresponding file and carrying out spot shipment clearing computation on the corresponding file by adopting a clearing algorithm.
By adopting the technical scheme, the invention can achieve the following beneficial effects:
the invention provides a power grid model version control and tracing management method and device, which comprises the steps of obtaining a power grid model file; analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table created in a database according to a preset mapping relation; inquiring and acquiring a corresponding version model of a corresponding date according to the data table; and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment calculation on the corresponding file by adopting a shipment algorithm. The invention provides a power grid model adding, editing, deleting, inquiring full-flow and closed-loop version control method, which supplements and perfects the version operation that only supports incremental data and does not support power grid model editing and deleting in the existing power grid model management method, effectively supports the requirements of the power grid model management storage and accurate restoration of the power grid model management in the power spot market, and improves the efficiency and accuracy of spot shipment.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic diagram of steps of a power grid model version control and traceability management method of the present invention;
FIG. 2 is a diagram illustrating the mapping relationship between the contents of a model file and the design of a database table according to the present invention;
FIG. 3 is a query hit Gantt graph provided by the present invention;
fig. 4 is a schematic structural diagram of the power grid model version control and traceability management apparatus of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be described in detail below. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the examples given herein without any inventive step, are within the scope of the present invention.
A specific power grid model version control and trace back management method provided in the embodiments of the present application is described below with reference to the accompanying drawings.
As shown in fig. 1, the method for power grid model version control and trace-back management provided in the embodiment of the present application includes:
s101, obtaining a power grid model file;
s102, analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation;
s103, inquiring and acquiring a corresponding version model of a corresponding date according to the data table;
and S104, combining the constraint relations of the corresponding version models according to a preset data organization rule to generate corresponding files, and performing spot shipment clearing calculation on the corresponding files by adopting a clearing algorithm.
The working principle of the power grid model version control and tracing management method is as follows: the implementation of the invention mainly comprises the following 4 steps: and acquiring a power grid model file, analyzing and warehousing power grid model data, inquiring a power grid model of a corresponding date, organizing the data and sending the data to the spot shipment. Specifically, a power grid model file is obtained; analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation; inquiring and acquiring a corresponding version model of a corresponding date according to the data table; and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment calculation on the corresponding file by adopting a shipment algorithm.
The version management design record based on the database is version snapshots, different snapshots correspond to different versions and are submitted for updating, when model data are saved, the model data are mainly used for making a snapshot for all data at the time, a matching strategy is provided for finding the version snapshot, and in order to be efficient, if the model data are not modified, the data cannot be stored again, but can still be matched through the matching strategy.
The invention provides a brand-new power grid model data version control management method, realizes a full-flow closed-loop version control method for power grid model addition, edition, deletion and query, supplements and perfects the version operation which only supports incremental data and does not support power grid model edition and deletion in the existing power grid model management method, effectively supports the requirements of the power spot market on storage and accurate reduction of power grid model management, and improves the efficiency and accuracy of spot shipment.
In some embodiments, based on a security file transfer protocol, a latest power grid model file is obtained from a power grid model source file storage location, and the power grid model file is transferred to a local server.
Preferably, the analyzing the power grid model file to obtain power grid model data and storing the power grid model data in a database includes:
reading the power grid model file from a local server and analyzing to obtain the attribute of the power grid model file;
mapping each data component of the power grid model file into a database through a database middleware according to a preset mapping relation; and the mapping relation is the mapping between the data component of the power grid model file and a database table in the database. And analyzing the power grid model file through an xml analyzing tool.
Preferably, before each data component is stored in a database table in the database, the method further includes:
judging the attribute of the data; the attribute comprises newly added and edited data or deleted data in the database;
carrying out corresponding processing on the data according to the attribute of the data;
and storing the processed data into a corresponding database table.
Preferably, the database table includes:
the model table, the maximum version table and the date version are relatively against the table.
Specifically, a file is read from a local server to a memory, attributes of the model file are obtained through an xml analysis tool, and then each data component is mapped to be stored through a database middleware, wherein the mapping relation is shown in fig. 2. The specific details of the storage can be distinguished as adding or editing data, and comparing with inventory model data to find deleted data, then performing corresponding data operation according to the corresponding operation, and then storing the corresponding data into a corresponding database table, wherein the table name definitions of the database table are pmm _ mark _ xxx, and xxx can be replaced by a specific model name, such as unit, substation of a power plant and the like.
Wherein, the model table is shown in table 1:
| field(s) | Type (B) | Whether or not to make a key | Note |
| ID | int | Is that | Unique id |
| NAME | varchar | Whether or not | Name of electric network model |
| r | decimal | Whether or not | Attribute r |
| x | decimal | Whether or not | Attribute x |
| … | … | Whether or not | Other omitted attributes |
| START_VERSION | bigint | Whether or not | Starting version number |
| END_VERSION | bigint | Whether or not | Ending version number |
Table 1 model table the maximum version table is shown in table 2:
| field(s) | Type (B) | Whether or not to make a key | Note |
| ID | int | Is that | Unique id |
| CREATE_TIME | datetime | Whether or not | Creation time |
| UPDATE_TIME | datetime | Whether or not | Update time |
| VERSION | bigint | Whether or not | Maximum version |
Table 2 maximum version table date version is shown in table 3:
| field(s) | Type (B) | Whether or not to make a key | Note |
| ID | int | Is that | Unique id |
| CREATE_TIME | datetime | Whether or not | Creation time |
| UPDATE_TIME | datetime | Whether or not | Update time |
| VERSION | bigint | Whether or not | Version(s) |
| HISTORY_DAY | datetime | Whether or not | Date |
TABLE 3 date version comparison table
Wherein, the logic of adding, editing and deleting is as follows:
the addition, deletion, and modification all increment the global maximum VERSION number (i.e., the VERSION field in table 3, the same applies hereinafter) by + 1;
the add, delete, modify processing logic is as follows:
increase: the global maximum version number is incremented by +1, the start version number of the newly added record is set to the global maximum version after incrementing by +1, and the end version number is set to long.
And (3) deleting: the deleted record version number is set to the current global maximum version number, which is incremented by + 1.
Modifying: splitting an original record into two records, wherein one record records a historical version and sets an ending version number as a current global maximum version number; the other is to record the latest version, the start version number is set as the global maximum version number incremented by +1, and the end version number is set as long.
The rule of inquiry is as follows: let X be the query version, hit the data as long as the following formula is satisfied, and start version ═ X ═ end version.
The specific database table operation logic is illustrated below with specific examples:
TABLE 4a 2021-01-01 initialization
TABLE 4b 2021-01-01 initialization
TABLE 4c 2021-01-01 initialization
Step 2: 2021-02-01, model data is put in storage, and two pieces of data, u1 and u2, are added. The data states of the three tables of the date version comparison table tsie _ max _ version _ of _ day, the maximum version table tsie _ max _ version and the pmm _ mark _ xxx are shown in tables 5a, 5b and 5c, one piece of data is added in the date version comparison table tsie _ max _ version _ of _ day, the version is 1, the date is 2021-02-01, the version in the maximum version table tsie _ max _ version is 1, the current version number is 1, two pieces of data are added in the pmm _ mark _ xxx table, 1 piece is u1, the start version is 1, the end version is loving.max, 1 piece is u2, the start version is 1 and the end version is long.
TABLE 5a 2021-02-01 with two data added u1 and u2
| Table name: maximum version table tsie _ max _ |
| version |
| 1 |
TABLE 5b 2021-02-01 data u1 and u2
Table 5c 2021-02-01 data u1 and u2
And step 3: 2021-03-01, delete u2 this data, tsie _ max _ version _ of _ day, maximum version table tsie _ max _ version, pmm _ mark _ xxx table three table data states as shown in table 6a, table 6b, table 6c, date version comparison table tsie _ max _ version _ of _ day add a data, version 2, date 2021-03-01, modify u2 this row of data in pmm _ mark _ xxx table, modify its end version number to 1, version in maximum version table tsie _ max _ version to 2, current version number to 2.
TABLE 6a 2021-03-01 deletion u2
| Table name: maximum version table tsie _ max _ version |
| version |
| 2 |
TABLE 6b 2021-03-01 deletion of u2
TABLE 6c 2021-03-01 deletion u2
And 4, step 4: 2021-04-01, modifying u1, wherein the data states of tsie _ max _ version _ of _ day, maximum version table tsie _ max _ version, pmm _ mark _ xxx are shown in table 7, adding a piece of data to the date version comparison table tsie _ max _ version _ of _ day, the version is 3, the date is 2021-04-01, copying one row for the row of u1 in the pmm _ mark _ xxx table, modifying the ending version in the old u1 data to 2, modifying the starting version in the new u1 data row to 3, modifying the version in the maximum version table tsie _ max _ version to 3, and the current version number to 3.
TABLE 7a 2021-04-01 modifications u1
| Table name: maximum version table tsie _ max _ version |
| version |
| 3 |
TABLE 7b 2021-04-01 modifications u1
TABLE 7c 2021-04-01 modifications u1
The gantt chart of the data query over the time period is shown in fig. 3:
let the current date have reached No. 4/5 2021, make the following query:
when the VERSION of 2021-01-05 is queried, the date VERSION comparison table tsie _ max _ VERSION _ of _ day is queried first, the maximum date row of the data rows smaller than the date is obtained, that is, the VERSION is 0, the history _ day is 2021-01-01, the VERSION is 0, then the data rows meeting START _ VERSION < 0 > END _ VERSION in pmm _ mark _ xxx are queried, and the obtained data is empty.
When the VERSION of 2021-02-05 is queried, the date VERSION comparison table tsie _ max _ VERSION _ of _ day is queried, the maximum date row of the data row smaller than the date is obtained, that is, the VERSION is 1, the history _ day is 2021-02-01, the VERSION is 1, then the data rows satisfying START _ VERSION < ═ 1< ═ END _ VERSION in pmm _ marker _ xxx are queried, and the data rows [ u 11012 ] and [ u 22011 ] are obtained.
When the VERSION of 2021-03-05 is queried, the date VERSION comparison table tsie _ max _ VERSION _ of _ day is queried first, the maximum date row of the data row smaller than the date is obtained, that is, the VERSION is 2, the history _ day is 2021-03-01, the VERSION is 2, then the data row satisfying START _ VERSION < ═ 2< ═ END _ VERSION in pmm _ marker _ xxx is queried, and the data row [ u 11012 ] is obtained.
When the VERSION of 2021-04-05 is queried, the date VERSION comparison table tsie _ max _ VERSION _ of _ day is queried first, the maximum date row of the data row smaller than the date is obtained, that is, VERSION is 3, history _ day is 2021-04-01, and the VERSION is 3, or the current VERSION 3 can be directly obtained from the maximum VERSION table tsie _ max _ VERSION, and then the data row satisfying START _ coverage < 3 > END _ coverage in pmm _ mark _ xxx is queried, and the data behavior [ u 1203 long.
In some embodiments, the constraint relationship comprises:
maximum output, minimum output, maximum power, minimum power, whether power constraints are considered.
After the corresponding date corresponding model is obtained, organizing various constraint relations of the corresponding version model according to an agreed data organization rule, wherein the constraint relations include maximum output, minimum output, maximum electric quantity, minimum electric quantity, whether electric power constraint is considered or not, whether electric quantity constraint is considered or not and the like, generating a corresponding file, and sending the corresponding file to a clearing algorithm calling program for carrying out the clear calculation of the spot goods.
As shown in fig. 4, an embodiment of the present application provides a power grid model version control and tracing management apparatus, including:
an obtaining module 401, configured to obtain a power grid model file;
the analysis module 402 is configured to analyze the power grid model file, and store each data component of the power grid model file obtained through analysis into a data table created in a database according to a preset mapping relationship;
a query module 403, configured to query and obtain a version model corresponding to the date according to the data table;
and the calculation module 404 is configured to combine the constraint relations of the corresponding version models according to preset data organization rules to generate corresponding files, and perform spot shipment calculation on the corresponding files by using a shipment algorithm.
The working principle of the power grid model version control and tracing management device provided by the embodiment of the application is that the obtaining module 401 obtains a power grid model file; the analysis module 402 analyzes the power grid model file, and stores each data component of the power grid model file obtained by analysis into a data table created in a database according to a preset mapping relation; the query module 403 queries and obtains a corresponding version model of a corresponding date according to the data table; the calculation module 404 combines the constraint relations of the corresponding version models according to preset data organization rules to generate corresponding files, and performs spot shipment calculation on the corresponding files by using a shipment algorithm.
The embodiment of the application provides computer equipment, which comprises a processor and a memory connected with the processor;
the memory is used for storing a computer program, and the computer program is used for executing the power grid model version control and tracing management method provided by any one of the above embodiments;
the processor is used to call and execute the computer program in the memory.
In summary, the present invention provides a power grid model version control and trace management method and apparatus, the method includes obtaining a power grid model file; analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation; inquiring and acquiring a corresponding version model of a corresponding date according to the data table; and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment calculation on the corresponding file by adopting a shipment algorithm. The invention provides a power grid model adding, editing, deleting, inquiring full-flow and closed-loop version control method, which supplements and perfects the version operation that only supports incremental data and does not support power grid model editing and deleting in the existing power grid model management method, effectively supports the requirements of the power grid model management storage and accurate restoration of the power grid model management in the power spot market, and improves the efficiency and accuracy of spot shipment.
It is to be understood that the embodiments of the method provided above correspond to the embodiments of the apparatus described above, and the corresponding specific contents may be referred to each other, which is not described herein again.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (8)
1. A power grid model version control and tracing management method is characterized by comprising the following steps:
acquiring a power grid model file;
analyzing the power grid model file, and storing each data component of the power grid model file obtained through analysis into a data table created in a database according to a preset mapping relation;
inquiring and acquiring a corresponding version model of a corresponding date according to the data table;
and combining the constraint relation of the corresponding version models according to a preset data organization rule to generate a corresponding file, and performing spot shipment inventory calculation on the corresponding file by adopting an inventory algorithm.
2. The method of claim 1,
and based on a security file transmission protocol, obtaining the latest power grid model file from the power grid model source file storage position, and transmitting the power grid model file to a local server.
3. The method of claim 2, wherein analyzing the grid model file to obtain grid model data and storing the grid model data in a database comprises:
reading the power grid model file from a local server and analyzing to obtain the attribute of the power grid model file;
mapping each data component of the power grid model file into a database through a database middleware according to a preset mapping relation; and the mapping relation is the mapping between the data component of the power grid model file and a database table in the database.
4. The method of claim 3,
and analyzing the power grid model file through an xml analyzing tool.
5. The method of claim 3, wherein each data component is stored in a database before a database table in the database, further comprising:
judging the attribute of the data; the attribute comprises newly added and edited data or deleted data in the database;
carrying out corresponding processing on the data according to the attribute of the data;
and storing the processed data into a corresponding database table.
6. The method of claim 1, wherein the database table comprises:
the model table, the maximum version table and the date version are relatively against the table.
7. The method of claim 1, wherein the constraining relationship comprises:
maximum output, minimum output, maximum power, minimum power, whether power constraints are considered.
8. The utility model provides a power grid model version control and trace back management device which characterized in that includes:
the acquisition module is used for acquiring a power grid model file;
the analysis module is used for analyzing the power grid model file and storing each data component of the power grid model file obtained through analysis into a data table established in a database according to a preset mapping relation;
the query module is used for querying and acquiring a corresponding version model of a corresponding date according to the data table;
and the computing module is used for combining the constraint relation of the corresponding version model according to a preset data organization rule, generating a corresponding file and carrying out spot shipment clearing computation on the corresponding file by adopting a clearing algorithm.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111138885.8A CN113836185A (en) | 2021-09-27 | 2021-09-27 | Power grid model version control and tracing management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111138885.8A CN113836185A (en) | 2021-09-27 | 2021-09-27 | Power grid model version control and tracing management method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113836185A true CN113836185A (en) | 2021-12-24 |
Family
ID=78970668
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111138885.8A Pending CN113836185A (en) | 2021-09-27 | 2021-09-27 | Power grid model version control and tracing management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113836185A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114443644A (en) * | 2021-12-28 | 2022-05-06 | 武汉中海庭数据技术有限公司 | Data increment storage method for different versions in different areas |
| CN117573199A (en) * | 2024-01-16 | 2024-02-20 | 成都安世赛斯特软件技术有限公司 | Model difference comparison analysis method, device, equipment and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN102855271A (en) * | 2012-07-05 | 2013-01-02 | 中国电力科学研究院 | Storage and traceable management method for multi-version power grid model |
| CN110941617A (en) * | 2019-11-26 | 2020-03-31 | 昆明能讯科技有限责任公司 | Power grid GIS data storage method based on version control |
| CN111784205A (en) * | 2020-07-28 | 2020-10-16 | 南方电网能源发展研究院有限责任公司 | Electric power wholesale market mode assessment and risk analysis method, device and system |
| CN113204864A (en) * | 2021-04-14 | 2021-08-03 | 中国电力科学研究院有限公司 | Method and system suitable for transmission network simulation data version control |
-
2021
- 2021-09-27 CN CN202111138885.8A patent/CN113836185A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6516326B1 (en) * | 2000-10-30 | 2003-02-04 | Stone And Webster Consultants, Inc. | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database |
| CN102855271A (en) * | 2012-07-05 | 2013-01-02 | 中国电力科学研究院 | Storage and traceable management method for multi-version power grid model |
| CN110941617A (en) * | 2019-11-26 | 2020-03-31 | 昆明能讯科技有限责任公司 | Power grid GIS data storage method based on version control |
| CN111784205A (en) * | 2020-07-28 | 2020-10-16 | 南方电网能源发展研究院有限责任公司 | Electric power wholesale market mode assessment and risk analysis method, device and system |
| CN113204864A (en) * | 2021-04-14 | 2021-08-03 | 中国电力科学研究院有限公司 | Method and system suitable for transmission network simulation data version control |
Non-Patent Citations (1)
| Title |
|---|
| 闫湖等: "多维度电网模型一体化存储与管理技术", 电力系统自动化 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114443644A (en) * | 2021-12-28 | 2022-05-06 | 武汉中海庭数据技术有限公司 | Data increment storage method for different versions in different areas |
| CN117573199A (en) * | 2024-01-16 | 2024-02-20 | 成都安世赛斯特软件技术有限公司 | Model difference comparison analysis method, device, equipment and medium |
| CN117573199B (en) * | 2024-01-16 | 2024-04-16 | 成都安世赛斯特软件技术有限公司 | Model difference comparison analysis method, device, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113836185A (en) | Power grid model version control and tracing management method and device | |
| US20130066882A1 (en) | Data storage method and system | |
| CN111160658B (en) | Collaborative manufacturing resource optimization method, system and platform | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN104657387A (en) | Data query method and device | |
| CN105630934A (en) | Data statistic method and system | |
| CN105787808A (en) | IEC61968 standard document generation system and method based on generic programming and reflection mechanism | |
| CN102799651B (en) | Query processing device and method | |
| CN111798330A (en) | Electric power spot market monitoring data management method, device and equipment | |
| CN114968739A (en) | Operation and maintenance task management method, operation and maintenance method, device, equipment and medium | |
| CN113641651A (en) | Business data management method, system and computer storage medium | |
| CN111522729A (en) | Method, device and system for determining rule release | |
| EP2568399A2 (en) | Data storage method and system | |
| US7523361B2 (en) | Error condition handling | |
| CN112102028B (en) | Unified configuration and verification method and system for service data | |
| CN111460021B (en) | Data export method and device | |
| CN111259082B (en) | Method for realizing full data synchronization in big data environment | |
| CN115114325A (en) | Data query method and device, electronic equipment and storage medium | |
| CN114218216A (en) | Resource management method, device, equipment and storage medium | |
| CN115455059A (en) | Method, device and related medium for analyzing user behavior based on underlying data | |
| CN115375430A (en) | Method, device and equipment for batch analysis and loading of additional data of bank | |
| CN114490652A (en) | Method, system, equipment and storage medium for offline processing of mobile assets | |
| CN112380164B (en) | Electric power system scene data management method, device and system based on snapshot technology | |
| CN115328536A (en) | Version management method, device, equipment and medium for periodic machine account | |
| CN109726468B (en) | Method for realizing crop simulation platform |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211224 |
|
| RJ01 | Rejection of invention patent application after publication |