CN104299171B - A kind of dissemination method of electricity distribution network model method based on model cluster - Google Patents
A kind of dissemination method of electricity distribution network model method based on model cluster Download PDFInfo
- Publication number
- CN104299171B CN104299171B CN201410563784.9A CN201410563784A CN104299171B CN 104299171 B CN104299171 B CN 104299171B CN 201410563784 A CN201410563784 A CN 201410563784A CN 104299171 B CN104299171 B CN 104299171B
- Authority
- CN
- China
- Prior art keywords
- model
- relation
- cluster
- graph
- triggering
- 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
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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06312—Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
-
- 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
Abstract
The present invention relates to a kind of dissemination method of electricity distribution network model method based on model cluster, it is characterised in that:The model issue request of client is processed by model issuing service;Model issuing service is according to total triggering graph of a relation and total foreign key constraint graph of a relation, it is triggering graph of a relation and foreign key constraint graph of a relation by model table tissue construction to be synchronized in request, so as to model table to be synchronized has been carried out into sequence tissue by triggering and foreign key constraint relation;According to triggering graph of a relation and foreign key relationship figure, the model cluster for being organized as one by one by all differences model description information has reached and for relevant differential pattern description information to be organized as an effect for unit;In units of model cluster, it is SQL statement to change corresponding model difference description information.One model cluster one SQL statement block of correspondence, so as to reach the synchronous effect in units of model cluster.Carry out model issue in units of model cluster, when there is mistake, current model bunch is by overall rollback, it is to avoid model is imperfect.
Description
Technical field
The invention belongs to Automation of Electric Systems electricity distribution network model administrative skill field, espespecially a kind of matching somebody with somebody based on model cluster
Electric network model dissemination method.
Background technology
For power distribution network network and change in topology frequently situation, the wind of model maintenance is carried out in runtime to reduce
Danger, general processing mode is that model maintenance is carried out in debugging system at present, after the completion of transfer portion is published to fortune again
In row system.
Existing model published method is typically carried out by table, and this published method logic is relatively simple.But due to table and table
Between there is triggering, foreign key constraint etc., if occurring mistake in issuing process, may result in runtime appearance
The incomplete problem of model.
The content of the invention
It is an object of the invention to provide a kind of dissemination method of electricity distribution network model method based on model cluster, debugging system is solved to fortune
The incomplete problem of model being likely to occur in the model issuing process of row system.
To achieve these goals, the technical solution used in the present invention is:A kind of electricity distribution network model based on model cluster
Dissemination method, it is characterised in that comprise the following steps:
(1)The model issue request of client is received and processed by model issuing service;
(2)Model issuing service builds total triggering graph of a relation according to the triggering between model table to be synchronized, according to
Foreign key constraint relation between model table to be synchronized builds total foreign key constraint graph of a relation;
(3)Differential pattern description information in debugging system and runtime is submitted to model issuing service by client, poor
Anomalous mode type description information is divided into several logical blocks by table, and is configured to differences model table;
(4)The table name of all differences model table is updated in total triggering graph of a relation, tissue obtains differences model table correspondence
Triggering graph of a relation;The table name of all differences model table is updated in total foreign key constraint graph of a relation, tissue obtains differential pattern
The corresponding foreign key constraint graph of a relation of table;
(5)According to triggering graph of a relation and foreign key constraint graph of a relation, differential pattern description information is organized as several models
Cluster;In units of model cluster, the corresponding model difference description information of the model of model cluster is converted into SQL statement;
(6)All model clusters of foreign key constraint relation synchronous first;Inerrancy, resynchronizes all models of triggering
Cluster;It is synchronous to stop if mistake synchronously occurs in foreign key constraining relational model bunch in synchronizing process;If triggering model cluster synchronization
Error, current model bunch integrally retracts, and continues synchronous next model cluster.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(1)In, it is resident in debugging system
Model issuing service process, request is issued with the model for being responsible for treatment client.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(5)In, single model cluster will be relevant
The differential pattern description information of connection relation is organized as a unit, and the differential pattern description information is in debugging system and operation
Discrepant model description information in system, each differential pattern description information includes domain name and certain equipment in debugging system and fortune
Corresponding property value in row system." incidence relation " should refer to triggering or foreign key constraint relation.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(2)In, total triggering graph of a relation is by more
Individual relational tree composition, model table corresponds to the node of relational tree, and the parent table and sublist in each triggering correspond to tree respectively
Father node and child node;Total foreign key constraint graph of a relation is made up of multiple relational trees, the foreign-key table in each foreign key constraint relation and
Major-key table corresponds to the father node and child node of tree respectively.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(3)In, included in each logical block
Several belong to the same differential pattern description information of differences model table.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(4)In, in triggering graph of a relation
Some differences model tables will not add foreign key constraint graph of a relation.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(5)In, according to triggering graph of a relation and
The method of foreign key constraint graph of a relation tissue model cluster is:According to triggering graph of a relation, with the corresponding difference of the root node of each relational tree
Different model table is starting point, is reviewed to leaf node direction, in units of the differential pattern description information of this table, organizes all models
Cluster;According to foreign key constraint graph of a relation, with the corresponding differences model table of the leaf node of each relational tree as starting point, to root node direction
Review, in units of the differential pattern description information of starting point table, organize all model clusters." differences model table " refers to just at two
Discrepant model table in system.
Foregoing a kind of dissemination method of electricity distribution network model method based on model cluster, in step(5)In, single model cluster correspondence one
Individual SQL statement block.
Operation principle of the invention is:
Model issuing service builds total triggering graph of a relation according to the triggering between model table, according between model table
Foreign key constraint relation builds total foreign key constraint graph of a relation, after receiving client request, by the differences model table in request by total pass
System's figure builds the triggering graph of a relation and foreign key constraint graph of a relation of differences model table in request respectively.There is redundancy shadow to avoid model
Model issue is rung, existing table will not add foreign key constraint graph of a relation in triggering graph of a relation.Again by differential pattern description information
By triggering graph of a relation and foreign key constraint graph of a relation tissue model cluster.
It is SQL statement by the corresponding model difference description information of model in model cluster after the completion of model cluster tissue.One
Model cluster one SQL statement block of correspondence.The synchronous priority of table is higher than the table in triggering graph of a relation in foreign key constraint graph of a relation.
Treat that foreign key constraining relational model bunch is smoothly synchronously completed, resynchronize triggering model cluster.In synchronizing process, if foreign key constraint
Synchronously there is mistake in relational model bunch, synchronous to stop, if triggering model cluster synchronously malfunctions, current model bunch is returned overall
Move back, and continue synchronization.
Reached beneficial effect of the invention:
Using the method for the present invention, model issue is carried out in units of model cluster, when model is issued to malfunction, the model cluster
By overall rollback.Avoid the imperfection of model in runtime, at the same can quick alignment error model, facilitate user to this
Mistake makes amendment or other necessary measures.
Brief description of the drawings
Fig. 1 is the model cluster schematic diagram of a triggering of the invention.
Fig. 2 is the model cluster schematic diagram of a foreign key constraint relation of the invention.
Fig. 3 is a kind of dissemination method of electricity distribution network model method flow chart based on model cluster of the invention.
Specific embodiment
The invention will be further described below in conjunction with the accompanying drawings.Following examples are only used for clearly illustrating the present invention
Technical scheme, and can not be limited the scope of the invention with this.
The present invention provides a kind of dissemination method of electricity distribution network model method based on model cluster.Model cluster refers to specific in the present invention
The set of model, the set has two types:The set of triggering object and the set of foreign key constraint relationship object.Triggering is closed
It is that the set of object refers to certain model as starting point, triggers all models of generation, as shown in Figure 1;The collection of foreign key constraint object
Conjunction refers to certain model as starting point, is the corresponding model of external key table search its major-key table with current table, until all outer in the set
Model corresponding to the major-key table of key table is included in the set, as shown in Figure 2.This method is comprised the steps of:
1) model issuing service process is resident in debugging system, is responsible for treatment model issue request.
2) total triggering graph of a relation is built according to the triggering between model table after model issuing service starts.The figure is by more
Individual relational tree composition.Model table corresponds to the node of relational tree, and the parent table and sublist in each triggering correspond to tree respectively
Father node and child node.
3) total foreign key constraint graph of a relation is built according to the foreign key constraint relation between model table.The figure is by multiple relational tree groups
Into foreign-key table and major-key table in each foreign key constraint relation correspond to the father node and child node of tree respectively.
4) client is by two systems(Debugging system and runtime)In discrepant model description information submit to mould
Type issuing service.Different information is divided into several logical blocks by table, and same model is belonged to comprising several in each logical block
The differential pattern description information of table, each description information includes domain name and the corresponding value in two systems.
5) table name of all differences model table is updated in total triggering graph of a relation, it is corresponding that tissue obtains differences model table
Triggering graph of a relation.
6) table name of all differences model table is updated in total foreign key constraint graph of a relation, tissue obtains differences model table pair
The foreign key constraint graph of a relation answered.Existing table will not add foreign key constraint graph of a relation in triggering graph of a relation.
7) according to triggering graph of a relation, the model table corresponding to the root node of each relational tree as starting point, to leaf node side
To reviewing, in units of the differential pattern description information of this table, all model clusters are organized.
8) according to foreign key constraint graph of a relation, with the corresponding model table of the leaf node of each relational tree as starting point, to root node
Direction is reviewed, and in units of the differential pattern description information of starting point table, organizes all model clusters.
9) the corresponding model difference description information of model in model cluster is converted into SQL statement.One model cluster correspondence
One SQL statement block.All model clusters of foreign key constraint relation synchronous first.Inerrancy, resynchronizes all moulds of triggering
Type cluster.It is synchronous to stop if mistake synchronously occurs in foreign key constraining relational model bunch in synchronizing process;If triggering model cluster is same
Mistake is walked out of, overall rollback is continued synchronous next model cluster by current model bunch.
The principle of the model dissemination method based on model cluster is as shown in Figure 3.Model issuing service can support that debugging system is arrived
The model issue of runtime, it is also possible to have the system of model data issue demand for other:Model maintenance is carried out
System(Equivalent to debugging system)With the system of model to be synchronized(Equivalent to runtime).
Model issuing service receives the model issue request from client, parses difference mould synchronous needed for the request
Type description information.Triggering graph of a relation and foreign key constraint graph of a relation are built according to model table to be synchronized respectively, then by difference mould
Type description information presses triggering graph of a relation and foreign key constraint graph of a relation tissue model cluster.After the completion of all model cluster tissues, by model
The corresponding model difference description information of each model is converted to SQL statement in cluster.One model cluster one SQL statement block of correspondence.
The synchronous priority of table is higher than the table in triggering graph of a relation in foreign key constraint graph of a relation.Treat that foreign key constraining relational model bunch is smooth
Synchronously complete, resynchronize triggering model cluster.In synchronizing process, if synchronously there is mistake in foreign key constraining relational model bunch,
Synchronous to stop, if triggering model cluster synchronously malfunctions, overall rollback is continued synchronous next model by current model bunch
Cluster.Service routine can to client return error message, including corresponding model cluster description information, to facilitate user to check.
General principle of the invention, principal character and advantage has been shown and described above.The technical staff of the industry should
Understand, the present invention is not limited to the above embodiments, simply original of the invention is illustrated described in above-described embodiment and specification
Reason, without departing from the spirit and scope of the present invention, various changes and modifications of the present invention are possible, these changes and improvements
All fall within the protetion scope of the claimed invention.The claimed scope of the invention is by appending claims and its equivalent circle.
It is fixed.
Claims (7)
1. a kind of dissemination method of electricity distribution network model method based on model cluster, it is characterised in that comprise the following steps:
(1)The model issue request of client is received and processed by model issuing service;
(2)Model issuing service builds total triggering graph of a relation according to the triggering between model table to be synchronized, same according to treating
Foreign key constraint relation between the model table of step builds total foreign key constraint graph of a relation;
(3)Differential pattern description information in debugging system and runtime is submitted to model issuing service, difference mould by client
Type description information is divided into several logical blocks by table, and is configured to differences model table;
(4)The table name of all differences model table is updated in total triggering graph of a relation, it is corresponding tactile that tissue obtains differences model table
Hair graph of a relation;The table name of all differences model table is updated in total foreign key constraint graph of a relation, tissue obtains differences model table pair
The foreign key constraint graph of a relation answered;
(5)According to triggering graph of a relation and foreign key constraint graph of a relation, differential pattern description information is organized as several model clusters;With
Model cluster is unit, and the corresponding model difference description information of the model of model cluster is converted into SQL statement;In step(5)In, it is single
Relevant differential pattern description information is organized as a unit by individual model cluster, the differential pattern description information be
Discrepant model description information in debugging system and runtime, each differential pattern description information includes domain name and certain equipment
Property value in debugging system and runtime;
(6)All model clusters of foreign key constraint relation synchronous first;Inerrancy, resynchronizes all model clusters of triggering;Together
It is synchronous to stop if mistake synchronously occurs in foreign key constraining relational model bunch during step;If triggering model cluster synchronously malfunctions,
Current model bunch integrally retracts, and continues synchronous next model cluster.
2. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(1)In, model issuing service process is resident in debugging system, request is issued with the model for being responsible for treatment client.
3. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(2)In, total triggering graph of a relation is made up of multiple relational trees, and model table corresponds to the node of relational tree, in each triggering
Parent table and sublist correspond to the father node and child node of tree respectively;Total foreign key constraint graph of a relation is made up of multiple relational trees, outside each
Foreign-key table and major-key table in key constraint relation correspond to the father node and child node of tree respectively.
4. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(3)In, belong to the same differential pattern description information of differences model table comprising several in each logical block.
5. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(4)In, existing differences model table will not add foreign key constraint graph of a relation in triggering graph of a relation.
6. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(5)In, the method according to triggering graph of a relation and foreign key constraint graph of a relation tissue model cluster is:According to triggering graph of a relation, with each
The corresponding differences model table of root node of relational tree is starting point, is reviewed to leaf node direction, and letter is described with the differential pattern of this table
It is unit to cease, and organizes all model clusters;According to foreign key constraint graph of a relation, with the corresponding differential pattern of the leaf node of each relational tree
Table is starting point, is reviewed to root node direction, in units of the differential pattern description information of starting point table, organizes all model clusters.
7. a kind of dissemination method of electricity distribution network model method based on model cluster according to claim 1, it is characterised in that in step
(5)In, one SQL statement block of single model cluster correspondence.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410563784.9A CN104299171B (en) | 2014-10-21 | 2014-10-21 | A kind of dissemination method of electricity distribution network model method based on model cluster |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410563784.9A CN104299171B (en) | 2014-10-21 | 2014-10-21 | A kind of dissemination method of electricity distribution network model method based on model cluster |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104299171A CN104299171A (en) | 2015-01-21 |
CN104299171B true CN104299171B (en) | 2017-07-11 |
Family
ID=52318892
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410563784.9A Active CN104299171B (en) | 2014-10-21 | 2014-10-21 | A kind of dissemination method of electricity distribution network model method based on model cluster |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104299171B (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101937435A (en) * | 2009-07-01 | 2011-01-05 | 北京科东电力控制系统有限责任公司 | Online synchronized method of distributed real-time database confronting power system |
CN102185383A (en) * | 2011-05-16 | 2011-09-14 | 广东电网公司深圳供电局 | Method and system for realizing data sharing between power distribution main station system and power distribution GIS (Geographic Information System) |
CN103294878A (en) * | 2012-02-26 | 2013-09-11 | 杭州市电力局 | Unified modeling method of multidimensional grid models based on DMS (database management system) |
CN103577936A (en) * | 2013-11-15 | 2014-02-12 | 国家电网公司 | Distributed maintenance and global sharing system for power grid model and implementation method thereof |
-
2014
- 2014-10-21 CN CN201410563784.9A patent/CN104299171B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101937435A (en) * | 2009-07-01 | 2011-01-05 | 北京科东电力控制系统有限责任公司 | Online synchronized method of distributed real-time database confronting power system |
CN102185383A (en) * | 2011-05-16 | 2011-09-14 | 广东电网公司深圳供电局 | Method and system for realizing data sharing between power distribution main station system and power distribution GIS (Geographic Information System) |
CN103294878A (en) * | 2012-02-26 | 2013-09-11 | 杭州市电力局 | Unified modeling method of multidimensional grid models based on DMS (database management system) |
CN103577936A (en) * | 2013-11-15 | 2014-02-12 | 国家电网公司 | Distributed maintenance and global sharing system for power grid model and implementation method thereof |
Also Published As
Publication number | Publication date |
---|---|
CN104299171A (en) | 2015-01-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104391948B (en) | The data normalization construction method and system of data warehouse | |
CN104143127B (en) | CIM-based three-diagram linkage processing method for distribution network | |
CN102403718B (en) | Generating method for power grid topological relationship based on Arcgis | |
CN105184482B (en) | A kind of transformer account data verification system and its method | |
CN109710647B (en) | Power grid standing book data fusion method and device based on keyword search | |
CN112270550A (en) | New energy electric power source tracing method and system based on block chain | |
CN104484470B (en) | A kind of data-base cluster metadata management method | |
CN104484469B (en) | One kind supports more non-stop-machine expansion methods of hash map data base cluster systems | |
CN104134173A (en) | Main and distribution network graph/model/data integrated system based on remote retrieval and information interaction | |
CN105162855A (en) | Incremental data synchronization method and device | |
CN106656712A (en) | Bus abnormality processing method and robot controller | |
CN102693129A (en) | Model transformation method of IEC61850 to IEC61970 and apparatus thereof | |
CN103078920A (en) | Online information verification system based on international electrotechnical commission (IEC) 61968 enterprise service bus (ESB) | |
CN103336788A (en) | Humanoid robot added Internet information acquisition method and system | |
CN106709607A (en) | Intelligent operation and maintenance monitoring system of distributed photovoltaic power station | |
CN107193917A (en) | Whole station CONFIG.SYS lossless data update method based on IID | |
CN104462435A (en) | Lateral extension method of distributed database | |
CN104599068A (en) | Method for positioning user fault through comprehensive analysis of repair request information | |
CN107633101A (en) | A kind of learning information correction processing method and information processing system | |
CN104299171B (en) | A kind of dissemination method of electricity distribution network model method based on model cluster | |
CN104218572B (en) | A kind of real-time stipulations of CIM model topology and modification method based on fuzzy reasoning | |
CN107766521A (en) | A kind of method of Electric Power Network Planning versions of data control | |
CN106776275A (en) | A kind of testing process automatic generation method based on Packet Multiplexing | |
CN112214602B (en) | Humor-based text classification method and device, electronic equipment and storage medium | |
CN109271350A (en) | A kind of database and information point table automatic comparison and synchronous method based on telemechanical communication |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |