CN102855271B - The storage of a kind of multi-version power grid model and traceable management method - Google Patents
The storage of a kind of multi-version power grid model and traceable management method Download PDFInfo
- Publication number
- CN102855271B CN102855271B CN201210231859.4A CN201210231859A CN102855271B CN 102855271 B CN102855271 B CN 102855271B CN 201210231859 A CN201210231859 A CN 201210231859A CN 102855271 B CN102855271 B CN 102855271B
- Authority
- CN
- China
- Prior art keywords
- model
- data base
- distributed data
- version
- management
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 44
- 238000003860 storage Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 10
- 238000012423 maintenance Methods 0.000 claims description 4
- 238000005538 encapsulation Methods 0.000 claims description 3
- 238000013507 mapping Methods 0.000 claims description 3
- 238000003825 pressing Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000739 chaotic effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000005405 multipole Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Abstract
The present invention provides storage and the traceable management method of a kind of multi-version power grid model, comprises the following steps: creates model library table in distributed data base, and safeguards model library table information；The initial model in area and the initial model of the whole network are imported distributed data base；If somewhere model is changed, then generating SQL delta file, batch performs SQL operation and stores redaction regional model and the whole network model to described distributed data base；Can tracing management multi-version power grid model.Multi-version power grid model can be managed by method that the present invention provides effectively, and only stores increment, does not has redundancy；Additionally, data distributed storage, when model library table data volume increases, queried access speed can significantly improve.
Description
Technical field
The invention belongs to technical field of electric power system control, be specifically related to the storage of a kind of multi-version power grid model with can tracing management
Method.
Background technology
Electric network model reflects the connection status of electrical network physical equipment, and when physical equipment occurs to change, model is also required to make accordingly
Amendment.In production environment, it is common that carry out the amendment of off-line, and by legal model and correspondence thereof after completing a series of verification
Data base, picture, concordance list etc. put into on-line operation.Production process will produce the model library of many versions, and traditional method is
Model library table is exported to file, then according to the time is named, but this method on the one hand version is the most chaotic, another
Aspect data redundancy amount is big.
Additionally, support the dispatching technique at different levels support system of big operation architecture according to State Grid Corporation of China " three collection five big " System Construction
The requirement of system, unified, completely, accurately electric network model be its basic condition.Current each control centre sets up the biography of electric network model
System method is Independent modeling, external network equivalent and Multi-pole Model splicing, there is partial model exchange too late during actual motion is new
Time, the problem such as model does not mates with real time data, model combination is inefficient.
Therefore, it is achieved the unified storage of multi-version power grid model and management have important meaning to the lexical analysis level promoting whole electrical network
Justice.
Summary of the invention
In order to overcome above-mentioned the deficiencies in the prior art, the present invention provide the storage of a kind of multi-version power grid model with can tracing management side
Method, can be managed multi-version power grid model effectively, and only stores increment, does not has redundancy；Additionally, data distribution
Formula stores, and when model library table data volume increases, queried access speed can significantly improve.
In order to realize foregoing invention purpose, the present invention adopts the following technical scheme that:
The storage of a kind of multi-version power grid model and traceable management method, said method comprising the steps of:
Step 1: create model library table in distributed data base, and safeguard model library table information；
Step 2: the initial model in area and the initial model of the whole network are imported distributed data base；
Step 3: if regional model change, then generate SQL delta file, utilize the batch SQL language that distributed data base provides
Sentence interface performs SQL operation, redaction regional model and the whole network model is stored to described distributed data base；
Step 4: can tracing management multi-version power grid model.
In described step 1, in distributed data base, create model library table according to the SQL access interface that distributed data base provides
Structure.
The structure of described model library table is fixed, and during system initialization, creates area statically with complete in described distributed data base
Pessimistic concurrency control storehouse table, is managed model library table information with tableInfo table simultaneously.
In described step 2, the initial model in area and the initial model of the whole network are imported distributed data base by CIM/E form.
Described distributed data base realizes based on building PostgreSQL database Hbase on Hadoop, with key-value pair < rowkey,
Value > form stores data.
Can the attribute of described tableInfo table includes for sky, data type, data length and whether major key；Described rowkey
Name form be<domain name+model library table name+row name>.
Described distributed data base encapsulation Hbase Basic API, it is provided that stsndard SQL access interface, with standard SQL language in institute
State distributed data base is carried out table create and data increasing, delete, change and look into.
In described step 3, the distributed data base realized based on Hbase utilizes the row TimeStamp of Hbase to realize the time
The management of dimensional model version；When carrying out redaction regional model and the storage operation of the whole network model, press to the incremental data of redaction
Stamp unified TimeStamp according to version submission time, and separately create table in order to maintenance release submission time and the mapping of version number
Relation.
In described step 4, can including time dimension, Spatial Dimension and application dimension by tracing management of multi-version power grid model
Management.
Being carried out by time dimension can be in tracing management, temporally during management multi-version electric network model, directly accesses described distributed
Model library table corresponding in data base, carries out data scanning according to timestamp；During by version number's management multi-version electric network model, first
Access VersionInfo table, the submission time that inquiry version number is corresponding, visit again model library table corresponding in distributed data base and obtain
Take model data.
Being carried out by Spatial Dimension can be in tracing management, and in described distributed data base, the name form of table is < homophony name+model library
Table name >, distributed data base provides the interface pressing regional information access electric network model, supports different regions model and the whole network model
Lower dress, issue and calculate service.
Being carried out by application dimension can be in tracing management, and distributed data base provides single table access interface and configurable access multilist
Interface, to different application by correlation table corresponding to configuration access arbitrary old version different application, it is achieved application dimension can
Tracing management.
Compared with prior art, the beneficial effects of the present invention is:
1. realize each department and the unified storage of the whole network model and unified access；
2. meet the electric network model management of retrospective multi version；
3. the miscellaneous editions of electric network model only stores increment, does not has redundancy；
4. data distributed storage, when model library table data volume increases, queried access speed can significantly improve；
5. support multi-version power grid model based on unified storage lower dress, issue, the service such as calculating；
6. method is simple and reliable, easily performs.
Accompanying drawing explanation
Fig. 1 is the storage of multi-version power grid model and traceable management method schematic diagram in the embodiment of the present invention；
Fig. 2 is model library table maintenance of information schematic diagram in distributed data base in the embodiment of the present invention；
Fig. 3 is model library and the data mapping graph of distributed data base in the embodiment of the present invention；
Fig. 4 is that carried out multi-version power grid model by time dimension in the embodiment of the present invention can the schematic diagram of tracing management；
Fig. 5 is that carried out multi-version power grid model by Spatial Dimension in the embodiment of the present invention can the schematic diagram of tracing management.
Detailed description of the invention
Below in conjunction with the accompanying drawings the present invention is described in further detail.
Such as Fig. 1-Fig. 5, the storage of a kind of multi-version power grid model and traceable management method, said method comprising the steps of:
Step 1: create model library table in distributed data base, and safeguard model library table information；
Step 2: the initial model in area and the initial model of the whole network are imported distributed data base；
Step 3: if regional model change, then generate SQL delta file, utilize the batch SQL language that distributed data base provides
Sentence interface performs SQL operation, redaction regional model and the whole network model is stored to described distributed data base；
Step 4: can tracing management multi-version power grid model.
In described step 1, in distributed data base, create model library table according to the SQL access interface that distributed data base provides
Structure.
The structure of described model library table is fixed, during system initialization, and static establishment area and the whole network in described distributed data base
Model library table, is managed model library table information with tableInfo table simultaneously.
In described step 2, the initial model in area and the initial model of the whole network are imported distributed data base by CIM/E form.
Described distributed data base realizes based on building PostgreSQL database Hbase on Hadoop, its key assignments with < rowkey,
Value > form stores data.
Can the attribute of described tableInfo table includes for sky, data type, data length and whether major key；Described rowkey
Name form be<domain name+model library table name+row name>.
Described distributed data base encapsulation Hbase Basic API, it is provided that stsndard SQL access interface, with standard SQL language in institute
State distributed data base is carried out table create and data increasing, delete, change and look into.
In described step 3, the distributed data base realized based on Hbase utilizes the row TimeStamp of Hbase to realize the time
The management of dimensional model version；When carrying out redaction regional model and the storage operation of the whole network model, press to the incremental data of redaction
Stamp unified TimeStamp according to version submission time, and separately create table in order to maintenance release submission time and the mapping of version number
Relation.
In described step 4, can including time dimension, Spatial Dimension and application dimension by tracing management of multi-version power grid model
Management.
Being carried out by time dimension can be in tracing management, temporally during management multi-version electric network model, directly accesses described distributed
Model library table corresponding in data base, carries out data scanning according to timestamp；During by version number's management multi-version electric network model, first
Access VersionInfo table, the submission time that inquiry version number is corresponding, visit again model library table corresponding in distributed data base and obtain
Take model data.
Being carried out by Spatial Dimension can be in tracing management, and in described distributed data base, the name form of table is < homophony name+model library
Table name >, distributed data base provides the interface pressing regional information access electric network model, supports different regions model and the whole network model
Lower dress, issue and calculate service.
Being carried out by application dimension can be in tracing management, and distributed data base provides single table access interface and configurable access multilist
Interface, to different application by correlation table corresponding to configuration access arbitrary old version different application, it is achieved application dimension can
Tracing management.
Finally should be noted that: above example is only in order to illustrate that technical scheme is not intended to limit, although reference
The present invention has been described in detail by above-described embodiment, those of ordinary skill in the field it is understood that still can to this
Invention detailed description of the invention modify or equivalent, and without departing from spirit and scope of the invention any amendment or etc.
With replacing, it all should be contained in the middle of scope of the presently claimed invention.
Claims (1)
1. the storage of a multi-version power grid model and traceable management method, it is characterised in that: said method comprising the steps of:
Step 1: create model library table in distributed data base, and safeguard model library table information；
Step 2: the initial model in area and the initial model of the whole network are imported distributed data base；
Step 3: if regional model change, then generate SQL delta file, utilize the batch SQL language that distributed data base provides
Sentence interface performs SQL operation, redaction regional model and the whole network model is stored to described distributed data base；
Step 4: can tracing management multi-version power grid model；
In described step 1, in distributed data base, create model library table according to the SQL access interface that distributed data base provides
Structure；
The structure of described model library table is fixed, and during system initialization, creates area statically with complete in described distributed data base
Pessimistic concurrency control storehouse table, is managed model library table information with tableInfo table simultaneously；
In described step 2, the initial model in area and the initial model of the whole network are imported distributed data base by CIM/E form；
Described distributed data base realizes based on building PostgreSQL database Hbase on Hadoop, with key-value pair < rowkey,
Value > form stores data；
Can the attribute of described tableInfo table includes for sky, data type, data length and whether major key；Described rowkey
Name form be<domain name+model library table name+row name>；
Described distributed data base encapsulation Hbase Basic API, it is provided that stsndard SQL access interface, with standard SQL language in institute
State distributed data base is carried out table create and data increasing, delete, change and look into；
In described step 3, the distributed data base realized based on Hbase utilizes the row TimeStamp of Hbase to realize the time
The management of dimensional model version；When carrying out redaction regional model and the storage operation of the whole network model, press to the incremental data of redaction
Stamp unified TimeStamp according to version submission time, and separately create table in order to maintenance release submission time and the mapping of version number
Relation；
In described step 4, can including time dimension, Spatial Dimension and application dimension by tracing management of multi-version power grid model
Management；
Being carried out by time dimension can be in tracing management, temporally during management multi-version electric network model, directly accesses described distributed
Model library table corresponding in data base, carries out data scanning according to timestamp；During by version number's management multi-version electric network model, first
Access VersionInfo table, the submission time that inquiry version number is corresponding, visit again model library table corresponding in distributed data base and obtain
Take model data；
Being carried out by Spatial Dimension can be in tracing management, and in described distributed data base, the name form of table is < homophony name+model library
Table name >, distributed data base provides the interface pressing regional information access electric network model, supports different regions model and the whole network model
Lower dress, issue and calculate service；
Being carried out by application dimension can be in tracing management, and distributed data base provides single table access interface and configurable access multilist
Interface, to different application by correlation table corresponding to configuration access arbitrary old version different application, it is achieved application dimension can
Tracing management.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210231859.4A CN102855271B (en) | 2012-07-05 | 2012-07-05 | The storage of a kind of multi-version power grid model and traceable management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210231859.4A CN102855271B (en) | 2012-07-05 | 2012-07-05 | The storage of a kind of multi-version power grid model and traceable management method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102855271A CN102855271A (en) | 2013-01-02 |
| CN102855271B true CN102855271B (en) | 2016-09-21 |
Family
ID=47401859
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210231859.4A Active CN102855271B (en) | 2012-07-05 | 2012-07-05 | The storage of a kind of multi-version power grid model and traceable management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102855271B (en) |
Families Citing this family (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150202B (en) * | 2013-03-15 | 2017-04-19 | 汉柏科技有限公司 | Method for allowing CloudStack to be compatible with virtual machine existing in vCenter |
| CN103577936B (en) * | 2013-11-15 | 2016-08-31 | 国家电网公司 | A kind of distributed maintenance of electric network model and globally shared system and its implementation |
| CN103617492A (en) * | 2013-11-26 | 2014-03-05 | 中国科学院信息工程研究所 | Power grid historical scene retrieval method and system |
| CN104239447A (en) * | 2014-09-01 | 2014-12-24 | 江苏瑞中数据股份有限公司 | Power-grid big time series data storage method |
| US11157517B2 (en) * | 2016-04-18 | 2021-10-26 | Amazon Technologies, Inc. | Versioned hierarchical data structures in a distributed data store |
| CN105912691B (en) * | 2016-04-21 | 2019-08-16 | 国电南瑞科技股份有限公司 | Electric network model multi version multi-tenant management system and method based on distributed storage |
| CN106067071B (en) * | 2016-05-27 | 2020-01-10 | 国网陕西省电力公司经济技术研究院 | Multi-state model management method based on segmented coding |
| CN106156338A (en) * | 2016-07-12 | 2016-11-23 | 复旦大学无锡研究院 | The date storage method of a kind of INFORMATION DISCOVERY server and INFORMATION DISCOVERY method |
| CN106484906B (en) * | 2016-10-21 | 2020-01-10 | 焦点科技股份有限公司 | Distributed object storage system flash-back method and device |
| US10860550B1 (en) | 2017-03-30 | 2020-12-08 | Amazon Technologies, Inc. | Versioning schemas for hierarchical data structures |
| US10671639B1 (en) | 2017-03-30 | 2020-06-02 | Amazon Technologies, Inc. | Selectively replicating changes to hierarchial data structures |
| CN107341237A (en) * | 2017-07-04 | 2017-11-10 | 北京百度网讯科技有限公司 | Method and apparatus for processing information |
| CN107357900A (en) * | 2017-07-14 | 2017-11-17 | 国电南瑞科技股份有限公司 | A kind of control method and device of electric power system model versions of data |
| CN108090165B (en) * | 2017-12-13 | 2021-12-28 | 美林数据技术股份有限公司 | Method for acquiring map change difference based on embedded graph database |
| CN113468149B (en) * | 2021-09-02 | 2021-11-12 | 北京宇信科技集团股份有限公司 | Data model development platform |
| CN113836185A (en) * | 2021-09-27 | 2021-12-24 | 云南电网有限责任公司 | Power grid model version control and tracing management method and device |
| CN114493531A (en) * | 2022-01-27 | 2022-05-13 | 广州智算信息技术有限公司 | Intelligent model multi-person cooperation management platform based on AI big data |
| CN116975399B (en) * | 2023-09-22 | 2023-12-26 | 南京南瑞信息通信科技有限公司 | Historical state power grid geographic diagram display method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1524239A (en) * | 2001-06-01 | 2004-08-25 | ���Ĺ��ʹ�˾ | Consistent read in a distributed database environment |
| CN101661499A (en) * | 2009-03-25 | 2010-03-03 | 福建省电力有限公司 | Electric power application support system and distributed real-time data center thereof |
| CN101807267A (en) * | 2009-12-09 | 2010-08-18 | 北京科东电力控制系统有限责任公司 | Method for realizing distributed collaborative modeling in integrated data platform |
| CN102419764A (en) * | 2010-10-20 | 2012-04-18 | 微软公司 | Distributed transaction management for database systems with multiversioning |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8010887B2 (en) * | 2001-09-21 | 2011-08-30 | International Business Machines Corporation | Implementing versioning support for data using a two-table approach that maximizes database efficiency |
| US7287034B2 (en) * | 2003-05-08 | 2007-10-23 | Oracle International Corporation | On-demand multi-version data dictionary to support distributed applications |
-
2012
- 2012-07-05 CN CN201210231859.4A patent/CN102855271B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1524239A (en) * | 2001-06-01 | 2004-08-25 | ���Ĺ��ʹ�˾ | Consistent read in a distributed database environment |
| CN101661499A (en) * | 2009-03-25 | 2010-03-03 | 福建省电力有限公司 | Electric power application support system and distributed real-time data center thereof |
| CN101807267A (en) * | 2009-12-09 | 2010-08-18 | 北京科东电力控制系统有限责任公司 | Method for realizing distributed collaborative modeling in integrated data platform |
| CN102419764A (en) * | 2010-10-20 | 2012-04-18 | 微软公司 | Distributed transaction management for database systems with multiversioning |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102855271A (en) | 2013-01-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102855271B (en) | The storage of a kind of multi-version power grid model and traceable management method | |
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| CN103699638B (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN102609417B (en) | Engine device and method for data integration and exchange of building information mode based on IFC (industry foundation classes) standards | |
| CN104134173A (en) | Main and distribution network graph/model/data integrated system based on remote retrieval and information interaction | |
| CN102194018B (en) | System and method for predictive analysis of energy consumption of building based on cloud computing | |
| CN102799620A (en) | IEC 61850 universal database information model and design method for interface of IEC 61850 universal database information model | |
| CN102750358A (en) | Mapping method and system of system data model to common information model (CIM) | |
| CN104317957B (en) | A kind of open platform of report form processing, system and report processing method | |
| CN104317864A (en) | Automatic identification method of information model based on IEC61850 logical nodes | |
| CN102073762A (en) | High-accuracy mold design method and mold manufacturing management system | |
| CN108108517A (en) | A kind of Electric Power Network Planning intelligence aided analysis method based on big data | |
| CN105405070A (en) | Distributed memory power grid system construction method | |
| CN103646051A (en) | Big-data parallel processing system and method based on column storage | |
| CN109783886A (en) | Emerging system and method for GIM model and IFC model | |
| Izsó et al. | IncQuery-D: incremental graph search in the cloud. | |
| CN114281790B (en) | Multi-type load resource aggregator access system and method | |
| CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
| CN103020869B (en) | Cloud-distribution power grid model version management system | |
| Zhang et al. | Research on data integration of smart grid based on iec61970 and cloud computing | |
| CN106327405A (en) | Intelligent city management system based on cloud platform | |
| CN102521333B (en) | Field perception temporal information management method based on internet of services | |
| Wang et al. | Network manufacturing technology based on cloud computing | |
| CN106557601A (en) | A kind of transmission line of electricity emulation mode | |
| CN104657426A (en) | Unified-view-based row and column hybrid data storage model establishment method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |