CN108647268A - Increment updating method for distribution network planning data integration - Google Patents

Increment updating method for distribution network planning data integration Download PDF

Info

Publication number
CN108647268A
CN108647268A CN201810401024.6A CN201810401024A CN108647268A CN 108647268 A CN108647268 A CN 108647268A CN 201810401024 A CN201810401024 A CN 201810401024A CN 108647268 A CN108647268 A CN 108647268A
Authority
CN
China
Prior art keywords
data
update
modification
updated
conflict
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
Application number
CN201810401024.6A
Other languages
Chinese (zh)
Inventor
何禹清
何红斌
陈跃辉
刘聪
詹扬
刘博�
江卓翰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
State Grid Hunan Electric Power Co Ltd
Economic and Technological Research Institute of State Grid Hunan Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Hunan Electric Power Co Ltd
Economic and Technological Research Institute of State Grid Hunan Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, State Grid Hunan Electric Power Co Ltd, Economic and Technological Research Institute of State Grid Hunan Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201810401024.6A priority Critical patent/CN108647268A/en
Publication of CN108647268A publication Critical patent/CN108647268A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy 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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a kind of increment updating method for distribution network planning data integration, including when obtaining data update all each history renewable times initial data;Two adjacent subdatas are compared to obtain variation duration set;All each history renewable times updates the data after acquisition data update;It obtains foundation data when n-th updates and is compared to obtain variable quantity with as-is data;It is updated according to variable quantity and according to data to as-is data, to obtain updated update the data.The present invention carries out landing storage by the initial data to each version of data, variable quantity is obtained by the comparison between version, the modified data of a upper version are updated using variable quantity, the conflict for solving to occur according to more new strategy according to different situations, to realize incremental update, so that data update science is accurate, and reduce human intervention as much as possible.

Description

Increment updating method for distribution network planning data integration
Technical field
Present invention relates particularly to a kind of increment updating methods for distribution network planning data integration.
Background technology
With the development and the improvement of people's living standards of national economy technology, electric energy has become the daily production of people With essential secondary energy sources in life, endless facility is brought to the production and life of people.
Power distribution network data source is in multiple professions such as dispatching automation, production management, power grid GIS, sales services (SG186) System, data volume is big, source is complicated.Wherein, equipment (assets) O&M is come from by the equipment account data that data integration obtains Lean management system (PMS2.0), the system in real time safeguard data.Because distribution network planning is designed to the real-time of data Property it is of less demanding, so the frequency of data acquisition be monthly integrated mode, every time obtain a batch data.When some After the completion of batch obtains, device data section can be used as to support distribution network planning design work, user can be to as-is data Data reparation and perfect is carried out, is modified to the data to leave a question open.But it after next lot data is integrated, generally takes as follows Several settling modes:
One replaces original edition data to be direct using all standing mode:But this method causes original modification data complete Complete to lose, all modification needs to present situation power grid manually remodify, and workload is huge.
Second is that the data of two versions are directly compared, the solution of conflict is specified by manually:But distribution Net variation is very fast, data volume is very big, and there will be larger differences for the data of two versions, are manually difficult to identify that two versions Between the reason of making a difference, workload is huge.
Invention content
The purpose of the present invention is to provide one kind capable of effectively reducing manual intervention, and data update science is accurately used In the increment updating method of distribution network planning data integration.
This increment updating method for distribution network planning data integration provided by the invention, includes the following steps:
The initial data of all each history renewable times when S1. obtaining data update, and preserve and form initial data Library O1, O2..., Oi..., On-1, n is natural number, wherein OiInitial data when data update is carried out for ith;I is nature Number, and i≤n-2;
S2. the raw data base obtained according to step S1, by two adjacent subdata OiAnd Oi+1It is compared, to Obtain variation duration set Δ ni+1
S3. all each history renewable time updates the data after obtaining data update, and preserves and form as-is data Library F1, F2..., Fj..., Fn-1, wherein FjFor the updated data of jth time;J is natural number, and j≤n-2;
S4. foundation data P when n-th update is obtainedn, and with as-is data Fn-1It is compared, to obtain variable quantity Δnn
S5. the variation delta n obtained according to step S4nWith foundation data Pn, to as-is data Fn-1It is updated, to F is updated the data after to n-th data updaten
Comparison described in step S2 and S4 specially carries out the data comparison of field level.
Update described in step S5 is specially updated using following rule:
If Δ nnFor newly-increased data, as-is data Fn-1It does not change and data does not conflict, then by Δ nnNewly-increased number It is inserted directly into F according to recordn-1Middle formation updates the data Fn
If Δ nnIt does not change, as-is data Fn-1It has increased data newly and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
If Δ nnFor data modification and as-is data Fn-1For data modification, then directly judge whether data modification conflicts:If Data modification conflict is then updated according to the strategy being previously set;If data modification does not conflict, by Δ nnThe data of modification Directly to Fn-1It is updated and updates the data F to be formedn
If Δ nnFor data modification, as-is data Fn-1It does not change and data does not conflict, then by Δ nnThe data of modification Directly to Fn-1It is updated and updates the data F to be formedn
If Δ nnIt does not change, as-is data Fn-1Do not conflict for data modification and data, then directly by as-is data Fn-1As updating the data Fn
If Δ nnFor data modification, as-is data Fn-1For data delete and data collision, then according to the strategy being previously set It is updated;
If Δ nnIt is deleted for data, as-is data Fn-1For data modification and data collision, then according to the strategy being previously set It is updated;
If Δ nnIt is deleted for data, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
If Δ nnIt is deleted for data, as-is data Fn-1It does not change and data does not conflict, then according to Δ nnMiddle deletion Data, by as-is data Fn-1In corresponding data delete after as updating the data Fn
If Δ nnIt does not change, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
The strategy being previously set, specially by user from update policy selection as described below select one as The strategy being previously set:
R1. by Δ nnThe data of modification are directly to present situation Fn-1It is updated and updates the data F to be formedn
R2. by as-is data Fn-1Directly as updating the data Fn
This increment updating method for distribution network planning data integration provided by the invention, by each version of data This initial data carries out landing storage, and variable quantity is obtained by the comparison between version, updates a upper version using variable quantity This modified data, according to the conflict that different situations solves to occur according to more new strategy, to realize incremental update so that Data update science is accurate, and reduces human intervention as much as possible.
Description of the drawings
Fig. 1 is the method flow diagram of the method for the present invention.
Specific implementation mode
It is the method flow diagram of the method for the present invention as shown in Figure 1:It is provided by the invention this for distribution network planning data Integrated increment updating method, includes the following steps:
The initial data of all each history renewable times when S1. obtaining data update, and preserve and form initial data Library O1, O2..., Oi..., On-1, n is natural number, wherein OiInitial data when data update is carried out for ith;I is nature Number, and i≤n-2;
S2. the raw data base obtained according to step S1, by two adjacent subdata OiAnd Oi+1Carry out field level pair Than to obtain variation duration set Δ ni+1
S3. all each history renewable time updates the data after obtaining data update, and preserves and form as-is data Library F1, F2..., Fj..., Fn-1, wherein FjFor the updated data of jth time;J is natural number, and j≤n-2;
S4. foundation data P when n-th update is obtainedn, and with as-is data Fn-1Field level comparison is carried out, to obtain Variation delta nn
S5. the variation delta n obtained according to step S4nWith foundation data Pn, to as-is data Fn-1Using it is following rule into Row update, to obtain updating the data F after n-th data updaten
If Δ nnFor newly-increased data, as-is data Fn-1It does not change and data does not conflict, then by Δ nnNewly-increased number It is inserted directly into F according to recordn-1Middle formation updates the data Fn
If Δ nnIt does not change, as-is data Fn-1It has increased data newly and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
If Δ nnFor data modification and as-is data Fn-1For data modification, then directly judge whether data modification conflicts:If Data modification conflict is then updated according to the strategy being previously set;If data modification does not conflict, by Δ nnThe data of modification Directly to Fn-1It is updated and updates the data F to be formedn
If Δ nnFor data modification, as-is data Fn-1It does not change and data does not conflict, then by Δ nnThe data of modification Directly to Fn-1It is updated and updates the data F to be formedn
If Δ nnIt does not change, as-is data Fn-1Do not conflict for data modification and data, then directly by as-is data Fn-1As updating the data Fn
If Δ nnFor data modification, as-is data Fn-1For data delete and data collision, then according to the strategy being previously set It is updated;
If Δ nnIt is deleted for data, as-is data Fn-1For data modification and data collision, then according to the strategy being previously set It is updated;
If Δ nnIt is deleted for data, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
If Δ nnIt is deleted for data, as-is data Fn-1It does not change and data does not conflict, then according to Δ nnMiddle deletion Data, by as-is data Fn-1In corresponding data delete after as updating the data Fn
If Δ nnIt does not change, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As updating the data Fn
The strategy being previously set specially voluntarily specifies more new strategy by user:User is according to whether carry out Large-scale data correction and the quality of data, by user from update policy selection as described below select one as being previously set Strategy (by the concrete condition of user according to place power grid and at that time, voluntarily one in the following strategy of selection):
R1. by Δ nnThe data of modification are directly to present situation Fn-1It is updated and updates the data F to be formedn
R2. by as-is data Fn-1Directly as updating the data Fn

Claims (4)

1. a kind of increment updating method for distribution network planning data integration includes the following steps:
The initial data of all each history renewable times when S1. obtaining data update, and preserve and form raw data base O1, O2..., Oi..., On-1, n is natural number, wherein OiInitial data when data update is carried out for ith;I is natural number, and i ≤n-2;
S2. the raw data base obtained according to step S1, by two adjacent subdata OiAnd Oi+1It is compared, to be become Change duration set Δ ni+1
S3. all each history renewable time updates the data after obtaining data update, and preserves and form presence database F1, F2..., Fj..., Fn-1, wherein FjFor the updated data of jth time;J is natural number, and j≤n-2;
S4. foundation data P when n-th update is obtainedn, and with as-is data Fn-1It is compared, to obtain variation delta nn
S5. the variation delta n obtained according to step S4nWith foundation data Pn, to as-is data Fn-1It is updated, to obtain F is updated the data after n times data updaten
2. the increment updating method according to claim 1 for distribution network planning data integration, it is characterised in that step Comparison described in S2 and S4 specially carries out the data comparison of field level.
3. the increment updating method according to claim 1 or 2 for distribution network planning data integration, it is characterised in that step Update described in rapid S5, is specially updated using following rule:
If Δ nnFor newly-increased data, as-is data Fn-1It does not change and data does not conflict, then by Δ nnNewly-increased data note Record is inserted directly into Fn-1Middle formation updates the data Fn
If Δ nnIt does not change, as-is data Fn-1It has increased data newly and data does not conflict, then directly by as-is data Fn-1As Update the data Fn
If Δ nnFor data modification and as-is data Fn-1For data modification, then directly judge whether data modification conflicts:If data Modification conflict, then be updated according to the strategy being previously set;If data modification does not conflict, by Δ nnThe data of modification are direct To Fn-1It is updated and updates the data F to be formedn
If Δ nnFor data modification, as-is data Fn-1It does not change and data does not conflict, then by Δ nnThe data of modification are direct To Fn-1It is updated and updates the data F to be formedn
If Δ nnIt does not change, as-is data Fn-1Do not conflict for data modification and data, then directly by as-is data Fn-1As Update the data Fn
If Δ nnFor data modification, as-is data Fn-1For data deletion and data collision, then carried out according to the strategy being previously set Update;
If Δ nnIt is deleted for data, as-is data Fn-1For data modification and data collision, then carried out according to the strategy being previously set Update;
If Δ nnIt is deleted for data, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As Update the data Fn
If Δ nnIt is deleted for data, as-is data Fn-1It does not change and data does not conflict, then according to Δ nnThe data of middle deletion, By as-is data Fn-1In corresponding data delete after as updating the data Fn
If Δ nnIt does not change, as-is data Fn-1It is deleted for data and data does not conflict, then directly by as-is data Fn-1As Update the data Fn
4. the increment updating method according to claim 3 for distribution network planning data integration, it is characterised in that described The strategy being previously set, specially by user from update policy selection as described below select one as the plan being previously set Slightly:
R1. by Δ nnThe data of modification are directly to present situation Fn-1It is updated and updates the data F to be formedn
R2. by as-is data Fn-1Directly as updating the data Fn
CN201810401024.6A 2018-04-28 2018-04-28 Increment updating method for distribution network planning data integration Pending CN108647268A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810401024.6A CN108647268A (en) 2018-04-28 2018-04-28 Increment updating method for distribution network planning data integration

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810401024.6A CN108647268A (en) 2018-04-28 2018-04-28 Increment updating method for distribution network planning data integration

Publications (1)

Publication Number Publication Date
CN108647268A true CN108647268A (en) 2018-10-12

Family

ID=63748741

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810401024.6A Pending CN108647268A (en) 2018-04-28 2018-04-28 Increment updating method for distribution network planning data integration

Country Status (1)

Country Link
CN (1) CN108647268A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109977128A (en) * 2019-03-21 2019-07-05 国网湖南省电力有限公司 Electric Power Network Planning data fusion method based on tense dimension
CN112131292A (en) * 2020-09-16 2020-12-25 北京金堤征信服务有限公司 Method and device for structural processing of changed data

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103645905A (en) * 2013-12-20 2014-03-19 北京中电普华信息技术有限公司 Incremental data acquisition method and device
CN105677889A (en) * 2016-01-30 2016-06-15 武汉大学 Partial updating and reduction overall incremental updating method for spatial data
CN106250389A (en) * 2016-07-15 2016-12-21 西安测绘研究所 A kind of geographical spatial data method for edition management updated towards dynamic increment
CN106294768A (en) * 2016-08-11 2017-01-04 深圳市宜搜科技发展有限公司 Information search method and information search engine
CN107766521A (en) * 2017-10-25 2018-03-06 中国电力工程顾问集团西南电力设计院有限公司 A kind of method of Electric Power Network Planning versions of data control

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103645905A (en) * 2013-12-20 2014-03-19 北京中电普华信息技术有限公司 Incremental data acquisition method and device
CN105677889A (en) * 2016-01-30 2016-06-15 武汉大学 Partial updating and reduction overall incremental updating method for spatial data
CN106250389A (en) * 2016-07-15 2016-12-21 西安测绘研究所 A kind of geographical spatial data method for edition management updated towards dynamic increment
CN106294768A (en) * 2016-08-11 2017-01-04 深圳市宜搜科技发展有限公司 Information search method and information search engine
CN107766521A (en) * 2017-10-25 2018-03-06 中国电力工程顾问集团西南电力设计院有限公司 A kind of method of Electric Power Network Planning versions of data control

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109977128A (en) * 2019-03-21 2019-07-05 国网湖南省电力有限公司 Electric Power Network Planning data fusion method based on tense dimension
CN109977128B (en) * 2019-03-21 2022-03-01 国网湖南省电力有限公司 Power grid planning data fusion method based on temporal dimension
CN112131292A (en) * 2020-09-16 2020-12-25 北京金堤征信服务有限公司 Method and device for structural processing of changed data
CN112131292B (en) * 2020-09-16 2024-05-14 北京金堤征信服务有限公司 Structured processing method and device for changed data

Similar Documents

Publication Publication Date Title
EP3822880A1 (en) Load prediction method and apparatus based on neural network
CN104881582B (en) The Forecasting Methodology and device of air quality
CN104573231B (en) Wisdom building system and method based on BIM
CN108932383B (en) Engineering construction organization scheme comprehensive aid decision-making method based on BIM technology
CN108876019A (en) A kind of electro-load forecast method and system based on big data
CN106528070A (en) Data table generation method and equipment
CN102624865A (en) Cluster load prediction method and distributed cluster management system
CN108647268A (en) Increment updating method for distribution network planning data integration
CN104638672A (en) Determining method of photovoltaic transmission power limit considering variable correlation
CN112364046A (en) Knowledge graph-based main data management method in heterogeneous environment
CN106202149A (en) A kind of IEC61850 model file conversion method
CN106372787A (en) Progress plan quick compilation method based on BIM and big data
CN104850635A (en) Auto check and centralized monitoring method for missing data in multi-data source environment
CN107798059A (en) A kind of NCO meteorological datas structured storage method and apparatus
CN110109829A (en) Intelligent dialogue automates method of calibration, storage medium
CN115187134A (en) Grid-based power distribution network planning method and device and terminal equipment
CN114707948A (en) Management method, device and storage medium for large surveying and mapping production project
CN112036686B (en) Low-voltage distribution station area line loss evaluation method based on theoretical line loss interval calculation
CN109086331A (en) Method and device for updating data of main network and distribution network and computer readable storage medium
CN109977128A (en) Electric Power Network Planning data fusion method based on tense dimension
WO2021168783A1 (en) Non-linear planning model based production planning system, production planning method and computer-readable storage medium
CN101867185A (en) System and method for automatically maintaining PI measuring point of power system
CN116911767A (en) Normalized three-dimensional data transfer method and system for power transmission and transformation project
CN103366258A (en) Method for evaluating indexes of hydroelectric production management system
CN115187425A (en) Power utilization data processing method based on configuration software and relational database trigger

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: 20181012

RJ01 Rejection of invention patent application after publication