CN110941617A - Power grid GIS data storage method based on version control - Google Patents
Power grid GIS data storage method based on version control Download PDFInfo
- Publication number
- CN110941617A CN110941617A CN201911174836.2A CN201911174836A CN110941617A CN 110941617 A CN110941617 A CN 110941617A CN 201911174836 A CN201911174836 A CN 201911174836A CN 110941617 A CN110941617 A CN 110941617A
- Authority
- CN
- China
- Prior art keywords
- data
- state
- power grid
- time
- ground
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/2462—Approximate or statistical queries
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas 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
- 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
Abstract
The invention discloses a power grid GIS data storage method based on version control, which comprises the following steps: the method comprises the following steps: dividing power grid data into power grid network frame layer data and power grid operation data, analyzing space, attribute, time and behavior characteristics of the data, and establishing a database table to store the information; step two: setting correction state time and establishing a ground state snapshot; step three: storing the base state snapshot in a database; establishing a basic state index table, a history basic state table and a current state table; step four: performing version iteration on the ground state snapshot; updating the correction state of the ground state periodically according to the set correction state event; step five: and inquiring and browsing the power grid data at any moment through different ground state time. The invention can effectively solve the problems of concurrency and combination in the data version updating process, ensure the consistency and the integrity of the data and improve the management level of the historical data.
Description
Technical Field
The invention belongs to the technical field of power GIS mass data storage and query, and particularly relates to a power grid GIS data storage method based on version control.
Background
With the increasing of the scale of the power grid, the development and transition process of the power grid is accelerated, and how to accurately and intuitively display the development and transition conditions of the scale and the wiring of the power grid is realized to predict the planning and construction rule of the future power grid. The traditional GIS system can only reflect the state of the power grid in the recent period of time, and lacks effective support in the aspects of historical information tracing and future power grid development prediction.
The temporal GIS utilizes the direct incidence relation of a power grid model and a time model, and integrates a temporal semantic SQL technology to realize the quick query and browse of historical data, so that the GIS system enters a four-dimensional era, the historical transition of the power grid network frame topology is quickly displayed through time playback, the difference of two historical nodes of a power grid is analyzed through the comparison of the power grid network frames in different time periods, the occurrence of the historical nodes plays an important role in the operation management and planning prediction of the power grid, and the status and the value of the power GIS as a data source in the power grid information system are improved.
Disclosure of Invention
Based on the defects of the prior art, the invention provides a power grid GIS data storage method based on version control.
The invention is realized by the following technical scheme.
A power grid GIS data storage method based on version control is used for supporting reliable storage of electric power mass monitoring data, fast multi-condition query analysis and historical data query,
the method comprises the steps of dividing power grid data into power grid structure layer data and power grid operation data; the power grid resource graph-model data in the temporal GIS adopts temporal and multilevel version technology of basic-state version control, supports the full-life cycle management of the power grid model, and meets the requirements of recording the historical evolution process and planning and designing application of the power grid model; the method comprises the following specific steps:
the method comprises the following steps: dividing power grid data into power grid network frame layer data and power grid operation data, analyzing space, attribute, time and behavior characteristics of the data, and establishing a database table to store the information;
step two: setting correction state time and establishing a ground state snapshot; if the main network data is not changed much, the correction state time is set to be longer; if the data of the distribution network is updated frequently, the correction state time is shortened; the correction events of each ground state data are distinguished and set according to specific service conditions;
step three: storing the base state snapshot in a database; establishing a base state index table, a history base state table and a current state table, setting correction state time according to different characteristics of stored data, establishing base state data, storing the data into the current state table, storing the data stored for the first time into the history base state table, and storing basic information of the base state, base state codes, base state names and layer name information into the index table;
step four: performing version iteration on the ground state snapshot; updating the correction state of the ground state periodically according to the set correction state event;
step five: and inquiring and browsing the power grid data at any moment through different ground state time.
Preferably, the periodic updating of the modified state of the ground state in step four of the present invention specifically comprises: if the data has variation, the original data is removed from the current state table, stored in the history base state table, and the information in the base state index table is updated to form an information chain varying with the time axis.
Preferably, when data are counted each time, as long as the data are changed, a new ground state is formed, the original ground state is changed into a history ground state, and meanwhile, a file describing version difference is formed between the two ground states; meanwhile, a version difference file between the ground states of any two times can be generated through configuration.
Preferably, the specific query method in the fifth step of the present invention is: inquiring through a base state index table and a current state table and inquiring through a historical state table and the current state table; data needing to be inquired can be quickly inquired and positioned through the ground state index table and the current state table; through the historical state table and the current state table, the difference of data of each time period can be compared, the change condition of the data can be counted, and the trend and the development trend of future data can be predicted.
The formed latest data version is stored in the latest data version database, the historical data versions are stored in the historical data version database, the later query is facilitated, the redundant data are merged by triggering the redundancy merging transition, the problems of concurrence and merging in the data version updating process are effectively solved, the consistency and the integrity of the data are ensured, and the management level of the historical data is effectively improved.
Drawings
FIG. 1 is a flow chart of the present invention;
FIG. 2 is a schematic diagram of a ground state snapshot storage of the present invention;
fig. 3 is an iterative schematic diagram of version update of the present invention.
Detailed Description
Embodiments of the present invention will now be described with reference to the accompanying drawings. The power grid GIS data storage method based on version control is used for supporting reliable storage, rapid multi-condition query analysis and historical data query of power mass monitoring data, but not limited to the method, and can also be used in other same or similar technologies.
Referring to fig. 1, the present invention provides a power grid GIS data storage method based on version control, which divides power grid data into power grid frame layer data and power grid operation data; the power grid resource graph-model data in the temporal GIS adopts temporal and multilevel version technology of basic-state version control, supports the full-life cycle management of the power grid model, and meets the requirements of recording the historical evolution process and planning and designing application of the power grid model; the method comprises the following specific steps:
the method comprises the following steps: dividing power grid data into power grid network frame layer data and power grid operation data, analyzing space, attribute, time and behavior characteristics of the data, and establishing a database table to store the information;
step two: setting correction state time and establishing a ground state snapshot; if the main network data is not changed greatly, the correction state time is set to be longer, for example, data statistical analysis is performed once every first day every year; if the data of the distribution network is updated frequently, the correction state time is shortened, and if the data of the distribution network is updated frequently, analysis can be performed once a quarter; the correction events of each ground state data are distinguished and set according to specific service conditions;
step three: storing the base state snapshot into a database, wherein the storage principle is as shown in FIG. 2; the storage of the ground state is not only to store the current information, but also to store the historical state of each ground state, so as to facilitate the later query processing, a ground state index table, a historical ground state table and a current state table need to be established, the modified state time is set according to different characteristics of the stored data, the ground state data is established and stored in the current state table, meanwhile, the data stored for the first time is stored in the historical ground state table, and the basic information, the ground state code, the ground state name and the layer name information of the ground state are stored in the index table;
step four: performing version iteration on the ground state snapshot, wherein the version updating iteration principle is shown in fig. 3; updating the correction state of the ground state periodically according to the set correction state event;
step five: and inquiring and browsing the power grid data at any moment through different ground state time.
Optionally, in an embodiment, the periodically updating the modified state of the base state in the fourth step is specifically: if the data are changed, removing the original data from the current state table, storing the original data into a history base state table, and updating the information in the base state index table to form an information chain changed by a time shaft; when data are counted each time, as long as the data are changed, a new ground state is formed, the original ground state is changed into a history ground state, and meanwhile a file describing version difference is formed between the two ground states; meanwhile, a version difference file between the ground states of any two times can be generated through configuration.
Optionally, in an embodiment, the specific query manner in step five is: inquiring through a base state index table and a current state table and inquiring through a historical state table and the current state table; data needing to be inquired can be quickly inquired and positioned through the ground state index table and the current state table; through the historical state table and the current state table, the difference of data of each time period can be compared, the change condition of the data can be counted, and the trend and the development trend of future data can be predicted.
The above disclosure is not intended to limit the scope of the invention, which is defined by the claims, but is intended to cover all modifications within the scope and spirit of the invention.
Claims (4)
1. A power grid GIS data storage method based on version control is used for supporting reliable storage, rapid multi-condition query analysis and historical data query of electric power mass monitoring data, and is characterized in that:
the method comprises the steps of dividing power grid data into power grid structure layer data and power grid operation data; the power grid resource graph-model data in the temporal GIS adopts temporal and multilevel version technology of basic-state version control, supports the full-life cycle management of the power grid model, and meets the requirements of recording the historical evolution process and planning and designing application of the power grid model; the method comprises the following specific steps:
the method comprises the following steps: dividing power grid data into power grid network frame layer data and power grid operation data, analyzing space, attribute, time and behavior characteristics of the data, and establishing a database table to store the information;
step two: setting correction state time and establishing a ground state snapshot; if the main network data is not changed much, the correction state time is set to be longer; if the data of the distribution network is updated frequently, the correction state time is shortened; the correction events of each ground state data are distinguished and set according to specific service conditions;
step three: storing the base state snapshot in a database; establishing a base state index table, a history base state table and a current state table, setting correction state time according to different characteristics of stored data, establishing base state data, storing the data into the current state table, storing the data stored for the first time into the history base state table, and storing basic information of the base state, base state codes, base state names and layer name information into the index table;
step four: performing version iteration on the ground state snapshot; updating the correction state of the ground state periodically according to the set correction state event;
step five: and inquiring and browsing the power grid data at any moment through different ground state time.
2. The power grid GIS data storage method based on version control as claimed in claim 1, wherein the modified state of the base state is periodically updated in step four, specifically: if the data has variation, the original data is removed from the current state table, stored in the history base state table, and the information in the base state index table is updated to form an information chain varying with the time axis.
3. The power grid GIS data storage method based on version control as claimed in claim 1 or 2, characterized in that: when data are counted each time, as long as the data are changed, a new ground state is formed, the original ground state is changed into a history ground state, and meanwhile a file describing version difference is formed between the two ground states; meanwhile, a version difference file between the ground states of any two times can be generated through configuration.
4. The power grid GIS data storage method based on version control as claimed in claim 1, wherein the concrete query mode of the fifth step is as follows: inquiring through a base state index table and a current state table and inquiring through a historical state table and the current state table; data needing to be inquired can be quickly inquired and positioned through the ground state index table and the current state table; through the historical state table and the current state table, the difference of data of each time period can be compared, the change condition of the data can be counted, and the trend and the development trend of future data can be predicted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911174836.2A CN110941617A (en) | 2019-11-26 | 2019-11-26 | Power grid GIS data storage method based on version control |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911174836.2A CN110941617A (en) | 2019-11-26 | 2019-11-26 | Power grid GIS data storage method based on version control |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110941617A true CN110941617A (en) | 2020-03-31 |
Family
ID=69908563
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911174836.2A Pending CN110941617A (en) | 2019-11-26 | 2019-11-26 | Power grid GIS data storage method based on version control |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110941617A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111582745A (en) * | 2020-05-14 | 2020-08-25 | 昆明能讯科技有限责任公司 | Power grid planning data dynamic digital map control method based on temporal GIS |
| CN112596826A (en) * | 2020-12-01 | 2021-04-02 | 国网浙江省电力有限公司绍兴供电公司 | Graph-model import optimization method and system for power distribution network system |
| CN113836185A (en) * | 2021-09-27 | 2021-12-24 | 云南电网有限责任公司 | Power grid model version control and tracing management method and device |
| CN115117887A (en) * | 2022-08-09 | 2022-09-27 | 中国电力科学研究院有限公司 | Power grid regulation and control operation simulation time sequence tidal current simulation method, device, equipment and medium |
| CN116975399A (en) * | 2023-09-22 | 2023-10-31 | 南京南瑞信息通信科技有限公司 | Historical state power grid geographic diagram display method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101593208A (en) * | 2009-07-09 | 2009-12-02 | 浙江大学 | A kind of ancestor ground space-time data storage means of the dynamic correction extended model based on ground state |
| US20130326388A1 (en) * | 2012-05-31 | 2013-12-05 | State Grid Corporation Of China | Power grid visualization system and method based on three-dimensional gis technology |
| CN108628958A (en) * | 2018-04-13 | 2018-10-09 | 云南电网有限责任公司信息中心 | A kind of power grid GIS date storage method based on tense |
| CN108763256A (en) * | 2018-03-30 | 2018-11-06 | 云南电网有限责任公司信息中心 | A kind of electric power GIS Temporal Model construction method based on Dike-pond modes |
| CN108876876A (en) * | 2018-07-10 | 2018-11-23 | 云南电网有限责任公司信息中心 | A kind of roller shutter methods of exhibiting of Temporal GIS edition data comparison |
-
2019
- 2019-11-26 CN CN201911174836.2A patent/CN110941617A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101593208A (en) * | 2009-07-09 | 2009-12-02 | 浙江大学 | A kind of ancestor ground space-time data storage means of the dynamic correction extended model based on ground state |
| US20130326388A1 (en) * | 2012-05-31 | 2013-12-05 | State Grid Corporation Of China | Power grid visualization system and method based on three-dimensional gis technology |
| CN108763256A (en) * | 2018-03-30 | 2018-11-06 | 云南电网有限责任公司信息中心 | A kind of electric power GIS Temporal Model construction method based on Dike-pond modes |
| CN108628958A (en) * | 2018-04-13 | 2018-10-09 | 云南电网有限责任公司信息中心 | A kind of power grid GIS date storage method based on tense |
| CN108876876A (en) * | 2018-07-10 | 2018-11-23 | 云南电网有限责任公司信息中心 | A kind of roller shutter methods of exhibiting of Temporal GIS edition data comparison |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111582745A (en) * | 2020-05-14 | 2020-08-25 | 昆明能讯科技有限责任公司 | Power grid planning data dynamic digital map control method based on temporal GIS |
| CN112596826A (en) * | 2020-12-01 | 2021-04-02 | 国网浙江省电力有限公司绍兴供电公司 | Graph-model import optimization method and system for power distribution network system |
| CN113836185A (en) * | 2021-09-27 | 2021-12-24 | 云南电网有限责任公司 | Power grid model version control and tracing management method and device |
| CN115117887A (en) * | 2022-08-09 | 2022-09-27 | 中国电力科学研究院有限公司 | Power grid regulation and control operation simulation time sequence tidal current simulation method, device, equipment and medium |
| CN116975399A (en) * | 2023-09-22 | 2023-10-31 | 南京南瑞信息通信科技有限公司 | Historical state power grid geographic diagram display method and system |
| CN116975399B (en) * | 2023-09-22 | 2023-12-26 | 南京南瑞信息通信科技有限公司 | Historical state power grid geographic diagram display method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110941617A (en) | Power grid GIS data storage method based on version control | |
| US10229129B2 (en) | Method and apparatus for managing time series database | |
| CN113179173B (en) | Operation and maintenance monitoring system for expressway system | |
| CN113609139A (en) | Monitoring data management method and device, electronic equipment and storage medium | |
| US20200201863A1 (en) | Workflow driven database partitioning | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| WO2020033446A1 (en) | Techniques for maintaining statistics in a database system | |
| EP3751427A1 (en) | Rules-based dataset cleaning | |
| CN114116716A (en) | Hierarchical data retrieval method, device and equipment | |
| CN108628958A (en) | A kind of power grid GIS date storage method based on tense | |
| CN111523004B (en) | Storage method and system for edge computing gateway data | |
| CN110706125A (en) | Water conservancy big data analysis information service system and platform service system | |
| CN116601624A (en) | Method for improving global inquiry performance in edge network | |
| Cejka et al. | Java embedded storage for time series and meta data in Smart Grids | |
| CN112328702A (en) | Data synchronization method and system | |
| CN106780157B (en) | Ceph-based power grid multi-temporal model storage and management system and method | |
| CN111125171A (en) | Monitoring data access method, device, equipment and readable storage medium | |
| CN111046081A (en) | Access method and system for industrial time sequence data | |
| CN112965882B (en) | Data fault analysis method and device | |
| CN114153809A (en) | Parallel real-time incremental statistic method based on database logs | |
| CN109918363B (en) | Method for carrying out data model consistency management based on view cross-database type | |
| CN112905732A (en) | Method and device for acquiring reading success rate of electric meter | |
| CN117076426A (en) | Traffic intelligent engine system construction method and device based on flow batch integration | |
| CN111414355A (en) | Offshore wind farm data monitoring and storing system, method and device | |
| CN104714956A (en) | Comparison method and device for isomerism record sets |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200331 |