CN108628958A - A kind of power grid GIS date storage method based on tense - Google Patents
A kind of power grid GIS date storage method based on tense Download PDFInfo
- Publication number
- CN108628958A CN108628958A CN201810330680.1A CN201810330680A CN108628958A CN 108628958 A CN108628958 A CN 108628958A CN 201810330680 A CN201810330680 A CN 201810330680A CN 108628958 A CN108628958 A CN 108628958A
- Authority
- CN
- China
- Prior art keywords
- data
- ground state
- increment
- power grid
- state
- 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
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000003860 storage Methods 0.000 title claims abstract description 16
- 230000005283 ground state Effects 0.000 claims abstract description 60
- 238000012937 correction Methods 0.000 claims abstract description 10
- 230000008859 change Effects 0.000 claims abstract description 8
- 238000010276 construction Methods 0.000 claims abstract description 5
- 230000009471 action Effects 0.000 claims abstract description 4
- 230000002123 temporal effect Effects 0.000 claims description 8
- 238000013499 data model Methods 0.000 claims description 7
- 230000005611 electricity Effects 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 6
- 230000004048 modification Effects 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 6
- 238000013439 planning Methods 0.000 claims description 5
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 claims description 4
- 238000013461 design Methods 0.000 claims description 4
- 238000007726 management method Methods 0.000 claims description 3
- 230000007704 transition Effects 0.000 claims description 3
- 239000012141 concentrate Substances 0.000 claims description 2
- PMHURSZHKKJGBM-UHFFFAOYSA-N isoxaben Chemical compound O1N=C(C(C)(CC)CC)C=C1NC(=O)C1=C(OC)C=CC=C1OC PMHURSZHKKJGBM-UHFFFAOYSA-N 0.000 claims description 2
- 230000009466 transformation Effects 0.000 claims description 2
- 238000004134 energy conservation Methods 0.000 abstract description 2
- 230000007613 environmental effect Effects 0.000 abstract description 2
- 238000012544 monitoring process Methods 0.000 description 7
- 238000004519 manufacturing process Methods 0.000 description 6
- 238000013500 data storage Methods 0.000 description 5
- 238000009826 distribution Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010835 comparative analysis Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012731 temporal analysis Methods 0.000 description 1
- 238000000700 time series analysis Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- 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
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
A kind of power grid GIS date storage method based on tense, includes the following steps：A, entire electric network data is first divided into power grid GIS data and operation of power networks data；B, it is that power grid GIS data and operation of power networks data establish ground state；C, the time for correcting state is set according to the change frequency of power grid GIS data and operation of power networks data；D, judge whether the data have had ground state according to the amendment state time of setting, if having there is ground state, differential file is merged into corresponding ground state version, form increment amendment state and just establish ground state version on the basis of current state if without ground state；E, every correction time for correcting state just repeats previous action.The present invention can realize science, timely record operation of power networks state, and the construction of power grid is made to be developed towards the direction of science, reasonable, energy conservation and environmental protection, sustainable etc..
Description
Technical field
The present invention relates to electric power GIS mass data storage inquiring technology field, specially a kind of power grid GISs based on tense
Date storage method.
Background technology
Growing with power grid scale, power network development transition process is accelerating, how accurate and visual displaying electricity
Network planning mould, wiring Vicissitude situation, predict the problem of following Electric Power Network Planning construction patterns receive much attention as one.Tradition
Generalized information system can only reflect the state at power grid a certain moment, lack in terms of historical information retrospect and the following power network development prediction
Effective support.And Temporal GIS plays back the historical upheaval of quickly displaying Net Frame of Electric Network topology by the time, passes through different time
The Net Frame of Electric Network comparative analysis of section goes out the difference of two history nodes of power grid, the appearance of Temporal GIS will to Regulation and
Planning forecast plays a significant role, and will promote electric power GIS in grid equipment functional location, topological network data in electric network information
Status as " data source header " and value in system.
Spatial object has 3 basic attributes：Space attribute, thematic attribute and time attribute, traditional GIS are empty in processing
Between object when, only focus on space attribute and thematic attribute, cause traditional GIS that can only handle the current state or a certain of data
The snapshot of historic state, and the dynamic change of data at any time can not be recorded, Time-Series analysis and tense processing can not be carried out.It is geographical
The variation of object is closely related with the time, in order to track and record variation, needs to introduce temporal information in GIS, here it is when
State GIS needs the main problem solved.
Invention content
The present invention is directed to the storage query demand of electrical network mass data, it is proposed that a kind of power grid GIS data based on tense
Storage method is analyzed with the reliable memory and quick multi-condition inquiry of supporting electrical network mass data.
The technical scheme is that：
A kind of power grid GIS date storage method based on tense, includes the following steps：
A, entire electric network data is first divided into power grid GIS data and operation of power networks data；
B, it is that power grid GIS data and operation of power networks data establish ground state；
C, the time for correcting state is set according to the change frequency of power grid GIS data and operation of power networks data；
D, judge whether the data have had ground state according to the amendment state time of setting, if having there is ground state, by difference
In Piece file mergence to corresponding ground state version, forms increment amendment state and just established on the basis of current state if without ground state
Ground state version；
E, every correction time for correcting state just repeats previous action.
The newest operation data of power grid is stored in latest data version repository by the present invention, and historical data version is stored in and is gone through
In history versions of data library, merges transition by triggering redundancy, redundant data is merged, efficiently solves versions of data more
Concurrent, the problem of merging during new, it ensure that the consistency and integrality of data, effectively increase the management of historical data
It is horizontal.
The present invention stores power grid GIS data using temporal extending, multistage version technique, supports electric network data model
Lifecycle management meets the historical evolution for recording electric network data model and planning and design application demand.Raw
Production, scheduling, metering, meteorological, on-line monitoring and GIS geography information are associated.The data of business scope by institutional framework,
Functional location, the fields such as device id are associated with geography information.Creation data is associated with GIS can analyze defect distribution situation,
Scheduling data are associated with the distribution situation that can analyze load with GIS, and continuous data is associated with GIS can analyze electricity consumption distribution
Situation, weather environment are associated with the correlation that can analyze the factors such as equipment and weather environment with on-line monitoring with GIS.
The performance requirement that the present invention is quickly accessed towards historical data, in a manner of " moon baseline+engineering residual quantity ", i.e., every
The moon 1 current state of power network resources is subjected to the storage of full dose snapshot, as the baseline of this month；Each engineering generates later
Incremental data increment stores；Section may be implemented in this way, and laterally inquiry and the longitudinal of device history inquire：
(1) section is laterally inquired
The electric network data for inquiring and browsing any one tense accesses of that month ground state snapshot data and multiple works later
The increment of journey is superimposed engineering increment by ground state snapshot and is obtained with；
(2) device history is inquired
Engineering increment is inquired by equipment, the increment variation feelings for all engineerings that the equipment is participated in can be retrieved
Condition；
(3) incremental model as unit of engineering
On ground state snapshot basis, electric network model is divided by tense electric network model along the variation of time shaft is with engineering
The increment chain of unit corresponds to newly-built, modification and the electric network model deleted the figure that an electricity power engineering generates in each increment
Topology and attribute change；
Using the temporal extending of ground state snapshot+incremental implementation electric network data model, the modification historical process of electric network data from certain
A ground state snapshot 1 starts, and each electricity power engineering is recorded in an increment modification of electric network data model, is followed successively by increasing
2,3 ... i-1, i, j, k are measured to the latest edition of electric network model.The correction time is arranged in each increment, and judging by the correction time should
Whether increment has ground state.If there is ground state, differential file is merged into corresponding ground state version, if without ground state, just with
Ground state version is established on the basis of the increment；
(4) Data Sheet Design
Engineering information table records each capital construction, industry expansion, the information of technological transformation project and the increasing in corresponding increment information table
Measure ID；Ground state SNAPSHOT INFO table stores the ground state snapshot metadata of every month；Increment information table is ground state snapshot or each work
The metadata of Cheng Zengliang；The ground state and incremental data of every month is all stored in a data and concentrates, and divides table to store by device type,
It is divided into power network resources figure table and power network resources attribute list, establishes spatial index and device id index.
The beneficial effects of the invention are as follows：The operation of power networks data of different moments are compared, obtain power grid when different
The operating status at quarter analyzes the variation tendency of the operating status of power grid, using variation tendency, to the maintenance work in power grid future
Accurate Prediction is made, the construction of power grid is made to be developed towards the directions such as science, reasonable, energy conservation and environmental protection, sustainable.
Description of the drawings
Fig. 1 is that the power grid GIS data provided by the invention based on tense store, extract and show process；
Fig. 2 is the power grid GIS data storage procedure provided by the invention based on tense；
Fig. 3 is the power grid GIS data storage principle provided by the invention based on tense；
Fig. 4 is the power grid GIS Data Storage Models provided by the invention based on tense；
Fig. 5 is the power grid GIS datum number storage provided by the invention based on tense according to table structure.
Specific implementation mode
A kind of power grid GIS date storage method based on tense, the temporal feature, space characteristics and attributive character of power grid
Data organization is carried out according to Spatio-Temporal Data Model for Spatial, data displaying is carried out by tense after data storage, extraction and application processing.
Detailed process includes the following steps：
A, it includes that power grid is set entire electric network data to be first divided into power grid GIS data and operation of power networks data power grid GIS data
Standby spatial data, administrative region vector data and administrative region image data, operation of power networks data include production, scheduling, meter
The data such as amount, meteorological, on-line monitoring；
B, it establishes ground state for power grid GIS data and operation of power networks data and inquires putting into operation the time for grid equipment, existing administration
The vector data in region and the creation time of image data establish the ground state version of GIS data on the basis of the time；Inquiry life
The earliest time of the data such as production, scheduling, metering, meteorological, on-line monitoring, establishes the base of operation of power networks data on the basis of the time
State version；
C, the time GIS data update for correcting state is set according to the change frequency of power grid GIS data and operation of power networks data
Frequency is relatively low, and the correction time that 1 year is GIS data is arranged.The data updates frequency such as production, scheduling, metering, meteorological, on-line monitoring
Rate is higher, and the correction time that one month is operation of power networks data is arranged；
D, judge whether the data have had ground state according to the amendment state time of setting, if having there is ground state, by difference
In Piece file mergence to corresponding ground state version, forms increment amendment state and just established on the basis of current state if without ground state
Ground state version using the ground state version time of power grid GIS data as starting point, each year the spatial data and administrative area to grid equipment
Vector data, the image data in domain are modified, and changed data just judge it, are newly-increased data, just with
The ground state version for increasing data newly is established on the basis of the time；It is that the data are just merged into corresponding ground state version by the data changed
In, and establish increment and correct state；Using the ground state version time of the data such as production, scheduling, metering, meteorology, on-line monitoring as starting point,
Each moon is modified operation of power networks data, and changed data just judge it, is newly-increased data, just with
The ground state version for increasing data newly is established on the basis of the time.It is that the data are just merged into corresponding ground state version by the data changed
In, and establish increment and correct state.
E, every correction time for correcting state just repeats previous action.The vector data and image data of administrative region do not have
It is stored in relational database, needs manually per year to be modified it.And the spatial data of grid equipment, the life of power grid
The data such as production, scheduling, metering, meteorological, on-line monitoring are stored in relational database, and configuration data synchronous task is monthly to power grid
Operation data is modified.
Claims (4)
1. a kind of power grid GIS date storage method based on tense, which is characterized in that include the following steps：
A, entire electric network data is first divided into power grid GIS data and operation of power networks data；
B, it is that power grid GIS data and operation of power networks data establish ground state；
C, the time for correcting state is set according to the change frequency of power grid GIS data and operation of power networks data；
D, judge whether the data have had ground state according to the amendment state time of setting, if having there is ground state, by differential file
It is merged into corresponding ground state version, forms increment amendment state and just establish ground state on the basis of current state if without ground state
Version；
E, every correction time for correcting state just repeats previous action.
2. a kind of power grid GIS date storage method based on tense according to claim 1, which is characterized in that will be formed
Newest power grid GIS data and operation data be stored in latest data version repository, historical data version is all stored in history
In versions of data library, merges transition by triggering redundancy, redundant data is merged, makes to obtain in versions of data renewal process
Concurrently, merge, ensure that the consistency and integrality of data.
3. a kind of power grid GIS date storage method based on tense according to claim 1, which is characterized in that power grid GIS
Data and operation data use the temporal extending of Dike-pond modes, multistage version technique, support the Life cycle of electric network model
Management meets the historical evolution for recording electric network model and planning and design application demand.
4. a kind of power grid GIS date storage method based on tense according to claim 1, which is characterized in that described to build
Vertical ground state is to use in a manner of " moon baseline+engineering residual quantity ", i.e., at monthly No. 1, the current state of power network resources is carried out complete
Measure snapshot storage, as the ground state snapshot of this month；The incremental data increment storage that each engineering generates later, to realize section
Laterally longitudinal inquiry of inquiry and device history：
(1) section is laterally inquired
The electric network data for inquiring and browsing any one tense accesses of that month ground state snapshot data and multiple engineerings later
Increment is superimposed engineering increment by ground state snapshot and obtains；
(2) device history is inquired
Engineering increment is inquired by equipment, the increment situation of change for all engineerings that the equipment is participated in can be retrieved；
(3) incremental model as unit of engineering
On ground state snapshot basis, variation of the tense electric network model by electric network model along time shaft is divided into as unit of engineering
Increment chain, correspond to newly-built, modification and the electric network model deleted the graph topology that electricity power engineering generates in each increment
And attribute change；
Using the temporal extending of ground state snapshot+incremental implementation electric network data model, the modification historical process of electric network data is from some base
State snapshot 1 starts, and each electricity power engineering is recorded in an increment modification of electric network data model, be followed successively by increment 2,
3 ... i-1, i, j, k to electric network model latest edition；The correction time is arranged in each increment, judges the increment by the correction time
Whether ground state is had.If there is ground state, differential file is merged into corresponding ground state version, if without ground state, just with the increasing
Ground state version is established on the basis of amount；
(4) Data Sheet Design
Engineering information table records each capital construction, industry expansion, the information of technological transformation project and the increment in corresponding increment information table
ID；Ground state SNAPSHOT INFO table stores the ground state snapshot metadata of every month；Increment information table is ground state snapshot or each engineering
The metadata of increment；The ground state and incremental data of every month is all stored in a data and concentrates, and divides table to store by device type, point
For power network resources figure table and power network resources attribute list, spatial index and device id index are established.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810330680.1A CN108628958A (en) | 2018-04-13 | 2018-04-13 | A kind of power grid GIS date storage method based on tense |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810330680.1A CN108628958A (en) | 2018-04-13 | 2018-04-13 | A kind of power grid GIS date storage method based on tense |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108628958A true CN108628958A (en) | 2018-10-09 |
Family
ID=63705324
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810330680.1A Pending CN108628958A (en) | 2018-04-13 | 2018-04-13 | A kind of power grid GIS date storage method based on tense |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108628958A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110633539A (en) * | 2019-09-24 | 2019-12-31 | 国网重庆市电力公司电力科学研究院 | PSASP data management method and readable storage medium |
| CN110674152A (en) * | 2019-09-24 | 2020-01-10 | 京东数字科技控股有限公司 | Data synchronization method and device, storage medium and electronic equipment |
| CN110941617A (en) * | 2019-11-26 | 2020-03-31 | 昆明能讯科技有限责任公司 | Power grid GIS data storage method based on version control |
| CN111324379A (en) * | 2020-01-15 | 2020-06-23 | 携程旅游网络技术（上海）有限公司 | Model deployment system based on general SOA service |
| CN111582745A (en) * | 2020-05-14 | 2020-08-25 | 昆明能讯科技有限责任公司 | Power grid planning data dynamic digital map control method based on temporal GIS |
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 |
| CN102375827A (en) * | 2010-08-16 | 2012-03-14 | 北京国科恒通电气自动化科技有限公司 | Method for fast loading versioned electricity network model database |
| CN103150366A (en) * | 2013-03-07 | 2013-06-12 | 南京国图信息产业股份有限公司 | Temporal geographic information system (GIS) data management and presentation method |
| CN106250389A (en) * | 2016-07-15 | 2016-12-21 | 西安测绘研究所 | A kind of geographical spatial data method for edition management updated towards dynamic increment |
| US20180006715A1 (en) * | 2015-05-07 | 2018-01-04 | Centre For Development Of Telematics | Gis based centralized fiber fault localization system |
-
2018
- 2018-04-13 CN CN201810330680.1A patent/CN108628958A/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 |
| CN102375827A (en) * | 2010-08-16 | 2012-03-14 | 北京国科恒通电气自动化科技有限公司 | Method for fast loading versioned electricity network model database |
| CN103150366A (en) * | 2013-03-07 | 2013-06-12 | 南京国图信息产业股份有限公司 | Temporal geographic information system (GIS) data management and presentation method |
| US20180006715A1 (en) * | 2015-05-07 | 2018-01-04 | Centre For Development Of Telematics | Gis based centralized fiber fault localization system |
| CN106250389A (en) * | 2016-07-15 | 2016-12-21 | 西安测绘研究所 | A kind of geographical spatial data method for edition management updated towards dynamic increment |
Non-Patent Citations (2)
| Title |
|---|
| 李申章: ""基于基态修正模型的电力GIS时态模型研究"", 《中国管理信息化》 * |
| 齐庆超: ""一种多基态修正时空数据模型改进的方法"", 《测绘科学》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110633539A (en) * | 2019-09-24 | 2019-12-31 | 国网重庆市电力公司电力科学研究院 | PSASP data management method and readable storage medium |
| CN110674152A (en) * | 2019-09-24 | 2020-01-10 | 京东数字科技控股有限公司 | Data synchronization method and device, storage medium and electronic equipment |
| CN110941617A (en) * | 2019-11-26 | 2020-03-31 | 昆明能讯科技有限责任公司 | Power grid GIS data storage method based on version control |
| CN111324379A (en) * | 2020-01-15 | 2020-06-23 | 携程旅游网络技术（上海）有限公司 | Model deployment system based on general SOA service |
| CN111324379B (en) * | 2020-01-15 | 2023-06-09 | 携程旅游网络技术（上海）有限公司 | Model deployment system based on general SOA service |
| CN111582745A (en) * | 2020-05-14 | 2020-08-25 | 昆明能讯科技有限责任公司 | Power grid planning data dynamic digital map control method based on temporal GIS |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108628958A (en) | A kind of power grid GIS date storage method based on tense | |
| CN105278373A (en) | Method for realizing comprehensive information processing system of transformer substation | |
| CN108876019A (en) | A kind of electro-load forecast method and system based on big data | |
| CN102999573A (en) | Cache updating method for stripped GIS (Geographic Information System) map elements | |
| CN107832876A (en) | Subregion peak load Forecasting Methodology based on MapReduce frameworks | |
| CN105205185B (en) | The method of data interaction and data modeling between monitoring system and management information system | |
| JP2019213299A (en) | Energy operation device, method, and system | |
| CN110941617A (en) | Power grid GIS data storage method based on version control | |
| Bugaets et al. | Information system to support regional hydrological monitoring and forecasting | |
| CN104299056A (en) | Distribution network planning basic technology supporting platform | |
| CN105574188A (en) | Method and system for managing data in different dimensions and at different layers | |
| CN111159154A (en) | Energy data warehouse system | |
| CN106845837B (en) | Power transmission and transformation project environment sensitive area monitoring system and method based on big data technology | |
| CN108763256A (en) | A kind of electric power GIS Temporal Model construction method based on Dike-pond modes | |
| CN103955863A (en) | Method for processing power network monitoring device data | |
| CN103279555B (en) | PI point automatic maintenance methods and device based on operation system | |
| CN103345485B (en) | A kind of mainframe platform dynamic statement automatic generation method and system | |
| CN113610661A (en) | Graph database-based power grid topology version management tool and method | |
| CN113807573A (en) | Construction prediction analysis method and system based on data management and three-dimensional search | |
| Kotriwala et al. | Load classification and forecasting for temporary power installations | |
| CN113204534A (en) | SCADA measurement data acquisition and storage method and system based on stream calculation | |
| JP5561643B2 (en) | Demand forecasting device and water operation monitoring system | |
| CN114595839A (en) | Intelligent electric energy meter fault reason analysis method and system | |
| Tang et al. | Short-term work team scheduling models for effective road repair and management | |
| CN107908476A (en) | Data processing method and device based on distributed type assemblies |
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: 20181009 |