CN109408603A - A kind of platform area topology drawing drawing method based on big data - Google Patents

A kind of platform area topology drawing drawing method based on big data Download PDF

Info

Publication number
CN109408603A
CN109408603A CN201811030398.8A CN201811030398A CN109408603A CN 109408603 A CN109408603 A CN 109408603A CN 201811030398 A CN201811030398 A CN 201811030398A CN 109408603 A CN109408603 A CN 109408603A
Authority
CN
China
Prior art keywords
ammeter
node
platform area
big data
batch meter
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.)
Granted
Application number
CN201811030398.8A
Other languages
Chinese (zh)
Other versions
CN109408603B (en
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
Jinan Power Supply Co of State Grid Shandong Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
Jinan Power Supply Co of State Grid Shandong 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, Jinan Power Supply Co of State Grid Shandong Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201811030398.8A priority Critical patent/CN109408603B/en
Publication of CN109408603A publication Critical patent/CN109408603A/en
Application granted granted Critical
Publication of CN109408603B publication Critical patent/CN109408603B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management
    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications

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

The present invention draws problems of the prior art to solve platform area topological diagram, graph theory and big data digging technology elder generation checking method (apriori algorithm) are applied in the topological diagram drafting of low-voltage platform area " transformer-route-electricity box-electric energy meter-client " by innovation, pass through minimal spanning tree algorithm, realize the automatic displaying drawn and chart is opened with client's key message one of platform area topological diagram, on the one hand by " live general survey, the traditional mode of manual maintenance " is to " automatic to draw, automatic Verification " Mode change, cost is saved, improve drafting accuracy, the battalion of working efficiency and low-voltage platform area is horizontal with concordance rate, it is lack of standardization effectively to solve power grid end data, the unsharp status of structure;On the other hand a large amount of valuable data resources in marketing system are taken full advantage of, precisely service is visualized for platform area manager and provides strong support, family table phase sequence belongs to definitely, sufficiently carries out good application relevant to split-phase load prediction.

Description

A kind of platform area topology drawing drawing method based on big data
Technical field
The present invention relates to the method for drafting of platform area topological diagram, draw more particularly, to a kind of platform area topological diagram based on big data Method processed.
Background technique
End of the low-voltage platform area as power grid is the important foundation of energy internet, is the pass for influencing electric service level Key link.As power system reform is increasingly deepened, the pressure of Utilities Electric Co.'s good service is persistently promoted, how in existence conditions Under, platform area topological diagram is precisely drawn, realizes repairing path visualization, power distribution network repairing duration is effectively reduced, reduces failure and stops transport Duration, accurate calculating split-phase load, Continuous optimization Distributing network structure constantly promote industry and expand matter effect, shorten average duration of applying to install a telephone, Good business environment is constructed, really " customer-centric " is realized, has become the common focus of attention of power supply company.
Mesh foreground partition topological diagram draws existing main problem: first is that there are a large amount of valuable data moneys in marketing system Source, but without clearly " what concrete meaning is ", being on the one hand that customer information is dispersed in existing marketing system, it still cannot be real Existing client's key message one opens the requirement of diagrammatic representation, is on the other hand customer resources positioning achievement and bandwidth carrier communication routing The not yet abundant application station area topological diagram of data, it is difficult to visualize precisely service for platform area manager and provide strong support;Second is that platform family Relationship safeguarded by artificial on-site identification, and platform area topological diagram is mainly after live general survey by manually drawing, and heavy workload, accuracy are not It is high;Third is that table phase sequence ownership in family is indefinite, good application relevant to split-phase load prediction can not be carried out;Fourth is that although high pressure is sought It is horizontal very high with perforation, but low-voltage platform area equipment is more, the complicated network structure, field device variation frequently, battalion is with concordance rate water Flat promotion difficulty is larger, and by taking Jinan Area as an example, 17378, the area in existing of Jinan, client 240.43 ten thousand, run measurement meter 2560000, batch meter 47.67 ten thousand, villages within the city, old residential area are more, and battalion is horizontal lower with perforation, become battalion with perforation work Weak link.
Summary of the invention
The present invention draws problems of the prior art to solve platform area topological diagram, and graph theory and big data are dug in innovation Pick technology elder generation checking method (apriori algorithm) is applied to low-voltage platform area " transformer-route-batch meter-electric energy meter-client " Topological diagram draw, by minimal spanning tree algorithm, realize platform area topological diagram it is automatic draw and with client's key message The displaying of one chart, on the one hand from the traditional mode of " live general survey, manual maintenance " to " automatic draw, automatic Verification " mode Transformation, has saved cost, improves the battalion for drawing accuracy, working efficiency and low-voltage platform area with concordance rate level, effectively solves Certainly power grid end data is lack of standardization, the unsharp status of structure;On the other hand a large amount of preciousnesses in marketing system are taken full advantage of Data resource, for platform area manager visualize precisely service provide strong support, family table phase sequence belong to definitely, sufficiently carry out and The relevant good application of split-phase load prediction.
The present invention provides a kind of platform area topology drawing drawing method based on big data, comprising:
It, will be same by first checking method calculating ammeter characteristic attribute and ammeter in the support and confidence level of same batch meter Ammeter cluster in batch meter is a node;
Using minimal spanning tree algorithm, using transformer as node, failure total degree is relayed as target using each inter-node communication Function solves objective function minimum value, obtained most your pupil using voltage deviation, node space distance between node as constraint condition It is the platform area topological diagram of a certain phase sequence at tree, draws to obtain the platform area topological diagram of other two-phases using same method, realizes The automatic drafting of " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram;
The abnormal core of topology is carried out using the rule that carrier communication trunk information between node only occurs on same branched line It looks into, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area's topological diagram of field condition.
Further, before the first checking method calculates further include: set up and be based on a kind of hadoop (distributed system base Plinth framework) cloud computing big data integrated platform, data resource is integrated, realize big data information collect automatically.
Further, the big data integrated platform of the establishment based on hadoop cloud computing, integrates data resource, Realize that big data information is collected specifically automatically:
The big data integrated platform based on hadoop cloud computing is set up, sales service application system, power information are acquired System, marketing GIS (Geographic Information System or Geo-Information system, i.e., geographical letter Breath system) system, PMS (power production management system, i.e. engineering production management system) system etc. Data resource is integrated, and multidimensional data resource is merged;
Overall planning static attribute and dynamic variable, electrical quantity, abnormal thing laterally comprising customer information and asset of equipments The data categories such as part, geographical location, longitudinal customer resources record sheet for constructing Spatial Dimension, time dimension realize big data letter Breath collects automatically.
Further, the platform area topology drawing drawing method based on big data, further includes: by obtain and field condition Consistent area's topological diagram is visualized in conjunction with customer electricity information, and in same chart.
Further, the support and confidence calculations formula are as follows:
Support=P (a certain characteristic attribute ∩ ammeter of ammeter is in a certain batch meter), indicate a certain characteristic attribute of ammeter with Ammeter in the simultaneous probability of same batch meter,
Confidence level=P (ammeter is in a certain characteristic attribute of a certain Ji Liang Xiang ∣ ammeter) is indicated in a certain characteristic attribute hair of ammeter Ammeter is in the simultaneous probability of same batch meter in raw event,
By a certain characteristic attribute of the available ammeter of the calculating of support and confidence level with ammeter in same batch meter phase The incidence relation tightness degree answered, support are all larger than a certain characteristic attribute of 75% expression ammeter and ammeter same with confidence level Batch meter incidence relation is close, and a certain characteristic attribute of the close ammeter of incidence relation is associated with rule in same batch meter with ammeter Ammeter cluster in same batch meter is a section by the collection conjunction intersection of the ammeter then obtained, as accurate case table relationship Point.
Further, a certain characteristic attribute of the ammeter and the ammeter correlation rule in the incidence relation of same batch meter have Body is:
If ammeter power off time is identical, ammeter is in same batch meter;
If meter voltage fluctuation is identical, ammeter is in same batch meter;
If ammeter electricity consumption address is similar, ammeter is in same batch meter;
If ammeter marketing system case table relationship is identical, ammeter is in same batch meter;
If ammeter periodicity rotation time is identical, ammeter is in same batch meter;
If ammeter load nature of electricity consumed is identical, ammeter is in same batch meter;
If ammeter category of employment is identical, ammeter is in same batch meter.
Further, described to utilize minimal spanning tree algorithm, using transformer as node, is relayed and failed with each inter-node communication Total degree is objective function, and voltage deviation, node space distance are constraint condition between node, solves objective function minimum value, obtains To minimum spanning tree be that the platform area topological diagram of a certain phase sequence is specifically:
Using minimal spanning tree algorithm, using transformer as node 1, bandwidth carrier relaying failure time between node i and node j Number is cij, introduce 0-1 integer variable xijIf xij=1, and i ≠ j is indicated in the Bian Shu from i to j, xij=0 indicates the side Not in tree, each inter-node communication relaying failure total degree z is objective function, and the expression formula of the z is as follows:
Wherein the n in objective function expression formula is positive integer, is constraint item with voltage deviation, node space distance between node Part solves objective function minimum value, and obtained minimum spanning tree is the topological diagram of a certain phase sequence in platform area, with identical method Obtain the platform area topological diagram of other two-phases of platform area.
Further, constraint condition is in the minimal spanning tree algorithm:
In addition to node 1, each point has and only a route is led to, expression formula:
At least a route comes out from node 1, expression formula are as follows:
Voltage deviation is no more than 3V, expression formula between node are as follows:
|ui-uj|≤3V, i=2,3 ..., n, j=2,3 ..., n;
The frequency of failure is relayed between node and is not less than 0, and is no more than 10000, expression formula are as follows:
0≤cij≤ 10000, i=2,3 ..., n, j=2,3 ..., n;
R is earth radius, XiThe latitude where node i, YiThe longitude where node i, XjFor latitude, Y where node jjFor Longitude where node j, space length is no more than 20 meters between node, expression formula are as follows:
R*arccos[cos(Yi)*cos(Yj)*cos(Xi-Xj)+sin(Yi)*sin(Yj)]≤20,
Wherein i=2,3 ..., n, j=2,3 ..., n.
Wherein the n in constraint condition expression formula is positive integer, and obtained minimum spanning tree is opening up for a certain phase sequence in platform area Flutter figure;The platform area topological diagram of other two-phases of platform area is obtained with identical method.
Further, the rule that carrier communication trunk information only occurs on same branched line between the node is opened up Abnormal verification is flutterred, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and field condition consistent Area's topological diagram, specifically:
If on a certain node ammeter and its place branched line node in the area Ruo Tai topological diagram on same branched line Any non-relay generation of ammeter, then this ammeter is not on this branched line;
On-site verification is needed when topological abnormal and the related data for extracting this ammeter again repaints, and is corrected topology and is drawn mould Type relevant constraint, voltage deviation adjusting range relays frequency of failure adjusting range between 0.5V-5V, node between interior joint Space length adjusting range is 15 meters -30 meters between 9000-10000 times, node, until obtaining and consistent area of field condition Topological diagram.
The technical solution adopted by the present invention includes following technical effect:
The present invention draws problems of the prior art to solve platform area topological diagram, and graph theory and big data are dug in innovation Pick technology elder generation checking method (apriori algorithm) is applied to low-voltage platform area " transformer-route-batch meter-electric energy meter-client " Topological diagram draw, by minimal spanning tree algorithm, realize platform area topological diagram it is automatic draw and with client's key message The displaying of one chart, from the traditional mode of " live general survey, manual maintenance " to " automatic draw, automatic Verification " Mode change, It reduces costs, improves the battalion for drawing accuracy, working efficiency and low-voltage platform area with concordance rate level.
Present invention innovation is existed using the first checking method in big data excavation, accurate excavation other data informations of ammeter and ammeter The correlation rule of a certain batch meter, after taking the intersection of correlation rule, the ammeter cluster in same batch meter is a node, is realized The simplification of platform area electric network composition, effectively solves that power grid end data is lack of standardization, the unsharp status of structure, ensures company's items base In the strengthened research of platform area topology business.
The present invention takes full advantage of a large amount of valuable data resources, family table phase sequence in marketing system and belongs to definitely, fill Separately exhibition good application relevant to split-phase load prediction, is opened up by the visualization to platform area user power utilization information and asset of equipments Displaying is flutterred, accelerates breakdown repair speed and power network line distribution in platform area during Business Process System is effectively instructed to move towards Continuous optimization, have Effect shortens average duration of applying to install a telephone.
For the present invention according to platform area three-phase topological diagram, system calculates each phase institute band client's load, power supply management unit root automatically According to A, B, C three-phase load unbalance situation, scene adjusts each phase institute band client, or according to three-phase institute on-load situation, expands in industry When solution formulation, load is assigned to the lesser phase of load up as far as possible, relies on platform area topological diagram to phase where customer capital The accurate identification of sequence, effectively prevention and improvement platform area three-phase imbalance problem.
General description and following detailed description more than it should be understood that be only it is exemplary and explanatory, not It can the limitation present invention.
Detailed description of the invention
Illustrate the embodiment of the present invention or technical solution in the prior art to become apparent from, it below will be to embodiment or existing Attached drawing needed in technical description is briefly described, it is clear that, for those of ordinary skills, Under the premise of not making the creative labor, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is the method flow schematic diagram of embodiment of the method one in the present invention program;
Fig. 2 is correlation rule intersection schematic diagram in the present invention program;
Fig. 3 is the method flow schematic diagram of embodiment of the method two in the present invention program;
Fig. 4 is the method flow schematic diagram of embodiment of the method three in the present invention program;
Fig. 5 is the method flow schematic diagram of embodiment of the method four in the present invention program.
Specific embodiment
In order to clarify the technical characteristics of the invention, below by specific embodiment, and its attached drawing is combined, to this hair It is bright to be described in detail.Following disclosure provides many different embodiments or example is used to realize different knots of the invention Structure.In order to simplify disclosure of the invention, hereinafter the component of specific examples and setting are described.In addition, the present invention can be with Repeat reference numerals and/or letter in different examples.This repetition is that for purposes of simplicity and clarity, itself is not indicated Relationship between various embodiments and/or setting is discussed.It should be noted that illustrated component is not necessarily to scale in the accompanying drawings It draws.Present invention omits the descriptions to known assemblies and treatment technology and process to avoid the present invention is unnecessarily limiting.
Embodiment one
As shown in Figure 1, a kind of platform area topology drawing drawing method based on big data includes following in technical solution of the present invention Step:
S1 will by first checking method calculating ammeter characteristic attribute and ammeter in the support and confidence level of same batch meter Ammeter cluster in same batch meter is a node.
S2, using transformer as node, relays failure total degree as mesh using each inter-node communication using minimal spanning tree algorithm Scalar functions solve objective function minimum value, obtained minimum using voltage deviation, node space distance between node as constraint condition Spanning tree is the platform area topological diagram of a certain phase sequence, draws to obtain the platform area topological diagram of other two-phases using same method, real The automatic drafting of existing " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram.
It is abnormal to carry out topology using the rule that carrier communication trunk information between node only occurs on same branched line by S3 It verifies, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area's topology of field condition Figure.
In step sl, by first checking method calculate ammeter characteristic attribute and ammeter same batch meter support with set Ammeter cluster in same batch meter is that a node is specifically by reliability:
Excavated using first checking method to data resource, data resource includes the characteristic attribute of following ammeter: ammeter is surveyed Electrical quantity (such as voltage, electric current), anomalous event (such as power off time), the corresponding customer electricity property of ammeter, customer electricity of amount Address, batch meter number etc. where ammeter, find a certain characteristic attribute of ammeter and ammeter same batch meter support with set Reliability, the support and confidence calculations formula are as follows:
Support=P (a certain characteristic attribute ∩ ammeter of ammeter is in a certain batch meter), indicate a certain characteristic attribute of ammeter with Ammeter in the simultaneous probability of same batch meter,
Confidence level=P (ammeter is in a certain characteristic attribute of a certain Ji Liang Xiang ∣ ammeter) is indicated in a certain characteristic attribute hair of ammeter Ammeter is in the simultaneous probability of same batch meter in raw event,
By a certain characteristic attribute of the available ammeter of the calculating of support and confidence level with ammeter in same batch meter phase The incidence relation answered, support and confidence level are all larger than a certain characteristic attribute of 75% expression ammeter and ammeter is closed in same batch meter When joining close relation, the i.e. a certain characteristic attribute of ammeter, then probability of the ammeter in same batch meter is close by incidence relation with regard to big The a certain characteristic attribute of ammeter and the collection conjunction intersection of ammeter that is obtained in the correlation rule of same batch meter of ammeter, as accurately Case table relationship, the ammeter cluster in same batch meter is a node.
Wherein a certain characteristic attribute of ammeter and the ammeter correlation rule in the incidence relation of same batch meter are specifically:
Regular A: if ammeter power off time is identical, ammeter is in same batch meter;
Regular B: if meter voltage fluctuation is identical, ammeter is in same batch meter;
Regular C: if ammeter electricity consumption address is similar, ammeter is in same batch meter;
Regular D: if ammeter marketing system case table relationship is identical, ammeter is in same batch meter;
Regular E: if ammeter periodicity rotation time is identical, ammeter is in same batch meter;
Regular D: if ammeter load nature of electricity consumed is identical, ammeter is in same batch meter;
Regular F: if ammeter category of employment is identical, ammeter is in same batch meter.
The electricity that a certain characteristic attribute of the close ammeter of incidence relation and ammeter are obtained in the correlation rule of same batch meter The collection conjunction intersection of table, as accurate batch meter relationship, obtained correlation rule schematic diagram is as shown in Fig. 2, take the intersection to be Seven circular intersections of Fig. 2.Ammeter cluster after first checking method in same batch meter is a node.
In step s 2, total with the relaying failure of each inter-node communication using transformer as node using minimal spanning tree algorithm Number is objective function, and voltage deviation, node space distance are constraint condition between node, solves objective function minimum value, obtains Minimum spanning tree be a certain phase sequence platform area topological diagram, draw to obtain the platform area topology of other two-phases using same method Figure realizes that the automatic drafting of " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram is specifically:
Minimal spanning tree algorithm in application drawing opinion, using transformer as node 1, between node i and node j in bandwidth carrier After the frequency of failure be cij, introduce 0-1 integer variable xijIf xij=1 (and i ≠ j) expression is in the Bian Shu from i to j, xij=0 Indicate the side not in tree;
Failure total degree z is relayed as objective function using each inter-node communication, and the expression formula of the z is as follows:
Wherein the n in objective function expression formula is positive integer, is constraint item with voltage deviation, node space distance between node Part solves objective function minimum value, and obtained minimum spanning tree is the topological diagram of a certain phase sequence in platform area;With identical method Obtain the platform area topological diagram of other two-phases of platform area.
Wherein constraint condition is in minimal spanning tree algorithm:
In addition to node 1, each point has and only a route is led to, expression formula:
At least a route comes out from node 1, expression formula are as follows:
Voltage deviation is no more than 3V, expression formula between node are as follows:
|ui-uj|≤3V, i=2,3 ..., n, j=2,3 ..., n;
The frequency of failure is relayed between node and is not less than 0, and is no more than 10000, expression formula are as follows:
0≤cij≤ 10000, i=2,3 ..., n, j=2,3 ..., n;
R is earth radius, XiThe latitude where node i, YiThe longitude where node i, XjFor latitude, Y where node jjFor Longitude where node j, space length is no more than 20 meters between node, expression formula are as follows:
R*arccos[cos(Yi)*cos(Yj)*cos(Xi-Xj)+sin(Yi)*sin(Yj)]≤20,
Wherein i=2,3 ..., n, j=2,3 ..., n.
Wherein the n in constraint condition expression formula is positive integer.
In step s3, the rule that carrier communication trunk information only occurs on same branched line between node carries out topology It is abnormal to verify, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area of field condition Topological diagram, specifically:
If on a certain node ammeter and its place branched line node in the area Ruo Tai topological diagram on same branched line Any non-relay generation of ammeter, then this ammeter is not on this branched line;
On-site verification is needed when topological abnormal and the related data for extracting this ammeter again repaints, and is corrected topology and is drawn mould Type relevant constraint, voltage deviation adjusting range relays frequency of failure adjusting range between 0.5V-5V, node between interior joint Space length adjusting range is 15 meters -30 meters between 9000-10000 times, node, until obtaining and consistent area of field condition Topological diagram.
It should be noted that needed after on-site verification in this programme by the platform area topological diagram that step S2 is drawn, If drawn platform area topological diagram is consistent with field condition, illustrate that platform area topological diagram is completed;If drawn platform Qu Tuo It is inconsistent with field condition to flutter figure, then needs to carry out constantly to modify constraint condition, carries out trial modeling, regenerates platform area topology Figure, until consistent with field condition, then illustrates that platform area topological diagram is completed.The wherein such as node of the constraint condition in this programme Between voltage deviation be no more than 3V, the relaying frequency of failure is no more than 10000 times between node, and space length range is no more than 20 between node Rice, is the general optimal situation for summarizing the experience out during constantly actually attempting to.
Embodiment two
As shown in figure 3, a kind of platform area topology drawing drawing method based on big data includes following in technical solution of the present invention Step:
S1 is set up the big data integrated platform based on hadoop cloud computing, is integrated to data resource, realizes big data Information is collected automatically.
S2 will by first checking method calculating ammeter characteristic attribute and ammeter in the support and confidence level of same batch meter Ammeter cluster in same batch meter is a node.
S3, using transformer as node, relays failure total degree as mesh using each inter-node communication using minimal spanning tree algorithm Scalar functions solve objective function minimum value, obtained minimum using voltage deviation, node space distance between node as constraint condition Spanning tree is the platform area topological diagram of a certain phase sequence, draws to obtain the platform area topological diagram of other two-phases using same method, real The automatic drafting of existing " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram.
It is abnormal to carry out topology using the rule that carrier communication trunk information between node only occurs on same branched line by S4 It verifies, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area's topology of field condition Figure.
In step sl, the big data integrated platform based on hadoop cloud computing is set up, data resource is integrated, it is real Existing big data information is collected specifically automatically:
The big data integrated platform based on hadoop cloud computing is set up, sales service application system, power information are acquired The data resources such as system, marketing generalized information system, PMS system are integrated, and multidimensional data resource is merged;
Overall planning static attribute and dynamic variable, electrical quantity, abnormal thing laterally comprising customer information and asset of equipments The data categories such as part, geographical location, longitudinal customer resources record sheet for constructing Spatial Dimension, time dimension.
Wherein big data integrated platform by acquisition customer information (family number, name in an account book, address, user's classification, trade classification, Electricity price execute), measuring equipment information (batch meter longitude and latitude, ammeter column locations), power information, (day freezes electricity to amr message Amount, voltage, electric current, anomalous event, bandwidth carrier meter reading routing iinformation) etc. complete.
Embodiment three
As shown in figure 4, a kind of platform area topology drawing drawing method based on big data includes following in technical solution of the present invention Step:
S1 will by first checking method calculating ammeter characteristic attribute and ammeter in the support and confidence level of same batch meter Ammeter cluster in same batch meter is a node.
S2, using transformer as node, relays failure total degree as mesh using each inter-node communication using minimal spanning tree algorithm Scalar functions solve objective function minimum value, obtained minimum using voltage deviation, node space distance between node as constraint condition Spanning tree is the platform area topological diagram of a certain phase sequence, draws to obtain the platform area topological diagram of other two-phases using same method, real The automatic drafting of existing " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram.
It is abnormal to carry out topology using the rule that carrier communication trunk information between node only occurs on same branched line by S3 It verifies, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area's topology of field condition Figure.
S4 will be obtained with consistent area's topological diagram of field condition in conjunction with customer electricity information, and in same chart It is visualized.
Example IV
As shown in figure 5, a kind of platform area topology drawing drawing method based on big data includes following in technical solution of the present invention Step:
S1 is set up the big data integrated platform based on hadoop cloud computing, is integrated to data resource, realizes big data Information is collected automatically.
S2 will by first checking method calculating ammeter characteristic attribute and ammeter in the support and confidence level of same batch meter Ammeter cluster in same batch meter is a node.
S3, using transformer as node, relays failure total degree as mesh using each inter-node communication using minimal spanning tree algorithm Scalar functions solve objective function minimum value, obtained minimum using voltage deviation, node space distance between node as constraint condition Spanning tree is the platform area topological diagram of a certain phase sequence, draws to obtain the platform area topological diagram of other two-phases using same method, real The automatic drafting of existing " transformer-route-power metering tank-electric energy meter-client " platform area topological diagram.
It is abnormal to carry out topology using the rule that carrier communication trunk information between node only occurs on same branched line by S4 It verifies, topological rendering model relevant constraint is corrected when topology is abnormal, until obtaining and consistent area's topology of field condition Figure.
S5 will be obtained with consistent area's topological diagram of field condition in conjunction with customer electricity information, and in same chart It is visualized.
Above-mentioned, although the foregoing specific embodiments of the present invention is described with reference to the accompanying drawings, not protects model to the present invention The limitation enclosed, those skilled in the art should understand that, based on the technical solutions of the present invention, those skilled in the art are not Need to make the creative labor the various modifications or changes that can be made still within protection scope of the present invention.

Claims (9)

1. a kind of platform area topology drawing drawing method based on big data, characterized in that include:
Ammeter characteristic attribute and ammeter are calculated in the support and confidence level of same batch meter, by same metering by first checking method Ammeter cluster in case is a node;
Using minimal spanning tree algorithm, using transformer as node, using each inter-node communication relaying failure total degree as objective function, Using voltage deviation, node space distance between node as constraint condition, objective function minimum value is solved, obtained minimum spanning tree is i.e. For the platform area topological diagram of a certain phase sequence, draws to obtain the platform area topological diagram of other two-phases using same method, realize " transformation The automatic drafting of device-route-power metering tank-electric energy meter-client " platform area topological diagram;
The abnormal verification of topology is carried out using the rule that carrier communication trunk information between node only occurs on same branched line, is opened up Topological rendering model relevant constraint is corrected when flutterring exception, until obtaining and consistent area's topological diagram of field condition.
2. the platform area topology drawing drawing method according to claim 1 based on big data, characterized in that first checked described Before method calculates further include: set up the big data integrated platform based on hadoop cloud computing, integrated to data resource, realized Big data information is collected automatically.
3. the platform area topology drawing drawing method according to claim 2 based on big data, characterized in that the establishment is based on The big data integrated platform of hadoop cloud computing, integrates data resource, realizes that big data information is collected specifically automatically:
Set up the big data integrated platform based on hadoop cloud computing, to sales service application system, power information acquisition system, The data resources such as marketing generalized information system, PMS system are integrated, and multidimensional data resource is merged;
Overall planning static attribute and dynamic variable, laterally the electrical quantity comprising customer information and asset of equipments, anomalous event, The data categories such as position are managed, longitudinal customer resources record sheet for constructing Spatial Dimension, time dimension realizes that big data information is automatic Collect.
4. the platform area topology drawing drawing method according to claim 1 or 2 based on big data, characterized in that further include: it will What is obtained carries out visualization exhibition in conjunction with customer electricity information, and in same chart with consistent area's topological diagram of field condition Show.
5. the platform area topology drawing drawing method according to claim 1 based on big data, characterized in that the support with Confidence calculations formula is as follows:
Support=P (a certain characteristic attribute ∩ ammeter of ammeter is in a certain batch meter) indicates a certain characteristic attribute of ammeter and ammeter In the simultaneous probability of same batch meter,
Confidence level=P (ammeter is in a certain characteristic attribute of a certain Ji Liang Xiang ∣ ammeter) is indicated in a certain characteristic attribute generation of ammeter Ammeter is in the simultaneous probability of same batch meter in event,
It is corresponding in same batch meter with ammeter by a certain characteristic attribute of the available ammeter of the calculating of support and confidence level Incidence relation tightness degree, support and confidence level are all larger than a certain characteristic attribute of 75% expression ammeter and ammeter in same metering Case incidence relation is close, and a certain characteristic attribute of the close ammeter of incidence relation and ammeter are obtained in the correlation rule of same batch meter Ammeter cluster in same batch meter is a node by the collection conjunction intersection of the ammeter arrived, as accurate case table relationship.
6. the platform area topology drawing drawing method according to claim 5 based on big data, characterized in that the ammeter is a certain Characteristic attribute and the ammeter correlation rule in the incidence relation of same batch meter are specifically:
If ammeter power off time is identical, ammeter is in same batch meter;
If meter voltage fluctuation is identical, ammeter is in same batch meter;
If ammeter electricity consumption address is similar, ammeter is in same batch meter;
If ammeter marketing system case table relationship is identical, ammeter is in same batch meter;
If ammeter periodicity rotation time is identical, ammeter is in same batch meter;
If ammeter load nature of electricity consumed is identical, ammeter is in same batch meter;
If ammeter category of employment is identical, ammeter is in same batch meter.
7. the platform area topology drawing drawing method according to claim 1 based on big data, characterized in that described using minimum Spanning tree algorithm relays failure total degree as objective function using each inter-node communication, voltage is inclined between node using transformer as node Difference, node space distance are constraint condition, solve objective function minimum value, obtained minimum spanning tree is the platform of a certain phase sequence Area's topological diagram is specifically:
Using minimal spanning tree algorithm, using transformer as node 1, the bandwidth carrier relaying frequency of failure is between node i and node j cij, introduce 0-1 integer variable xijIf xij=1, and i ≠ j is indicated in the Bian Shu from i to j, xij=0 indicates that the side does not exist In tree, each inter-node communication relaying failure total degree z is objective function, and the expression formula of the z is as follows:
Wherein n is positive integer in objective function expression formula, is asked using voltage deviation, node space distance between node as constraint condition Objective function minimum value is solved, obtained minimum spanning tree is the topological diagram of a certain phase sequence in platform area, is obtained with identical method The platform area topological diagram of other two-phases of platform area.
8. the platform area topology drawing drawing method according to claim 7 based on big data, characterized in that the minimum generation Constraint condition is in tree algorithm:
In addition to node 1, each point has and only a route is led to, expression formula:
At least a route comes out from node 1, expression formula are as follows:
Voltage deviation is no more than 3V, expression formula between node are as follows:
|ui-uj|≤3V, i=2,3 ..., n, j=2,3 ..., n;
The frequency of failure is relayed between node and is not less than 0, and is no more than 10000, expression formula are as follows:
0≤cij≤ 10000, i=2,3 ..., n, j=2,3 ..., n;
R is earth radius, XiThe latitude where node i, YiThe longitude where node i, XjFor latitude, Y where node jjFor node j Place longitude, space length is no more than 20 meters between node, expression formula are as follows:
R*arccos[cos(Yi)*cos(Yj)*cos(Xi-Xj)+sin(Yi)*sin(Yj)]≤20,
Wherein i=2,3 ..., n, j=2,3 ..., n.
Wherein the n in constraint condition expression formula is positive integer, and obtained minimum spanning tree is the topological diagram of a certain phase sequence in platform area; The platform area topological diagram of other two-phases of platform area is obtained with identical method.
9. the platform area topology drawing drawing method based on big data according to claim 1 or 8, characterized in that the node Between the rule that only occurs on same branched line of carrier communication trunk information carry out that topology is abnormal to be verified, topology is corrected when abnormal Topological rendering model relevant constraint, until obtain with consistent area's topological diagram of field condition, specifically:
If a certain node ammeter in the area Ruo Tai topological diagram on same branched line and any on branched line node where it The non-relay generation of ammeter, then this ammeter is not on this branched line;
On-site verification is needed when topological abnormal and the related data for extracting this ammeter again repaints, and corrects topological rendering model phase Constraint condition is closed, voltage deviation adjusting range is to relay frequency of failure adjusting range between 0.5V-5V, node to be between interior joint Space length adjusting range is 15 meters -30 meters between 9000-10000 times, node, until obtaining and consistent Qu Tuo of field condition Flutter figure.
CN201811030398.8A 2018-09-05 2018-09-05 Big data-based method for drawing topological graph of transformer area Active CN109408603B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811030398.8A CN109408603B (en) 2018-09-05 2018-09-05 Big data-based method for drawing topological graph of transformer area

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811030398.8A CN109408603B (en) 2018-09-05 2018-09-05 Big data-based method for drawing topological graph of transformer area

Publications (2)

Publication Number Publication Date
CN109408603A true CN109408603A (en) 2019-03-01
CN109408603B CN109408603B (en) 2021-09-07

Family

ID=65464534

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811030398.8A Active CN109408603B (en) 2018-09-05 2018-09-05 Big data-based method for drawing topological graph of transformer area

Country Status (1)

Country Link
CN (1) CN109408603B (en)

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111078815A (en) * 2019-12-12 2020-04-28 浙江华云信息科技有限公司 Hybrid loading method for power grid data
CN111159897A (en) * 2019-12-31 2020-05-15 新奥数能科技有限公司 Target optimization method and device based on system modeling application
CN111342554A (en) * 2020-02-17 2020-06-26 石家庄学院 Automatic identification system and method for distribution room topology
CN111654392A (en) * 2020-05-11 2020-09-11 国网浙江省电力有限公司电力科学研究院 Low-voltage distribution network topology identification method and system based on mutual information
CN112256929A (en) * 2020-10-23 2021-01-22 全球能源互联网研究院有限公司 Graph database-based electric power industry expansion method and system
CN112285467A (en) * 2020-10-19 2021-01-29 北京前景无忧电子科技有限公司 Method for automatically identifying power supply topology of low-voltage distribution area
CN112562038A (en) * 2020-12-22 2021-03-26 广东电网有限责任公司茂名供电局 Low-voltage distribution network graph generation method based on cluster analysis
CN112910696A (en) * 2021-01-22 2021-06-04 上海三零卫士信息安全有限公司 Automatic modeling analysis method for network topology
CN115221979A (en) * 2022-09-15 2022-10-21 国网江西省电力有限公司电力科学研究院 Power distribution station topology identification method and system based on minimum spanning tree
CN115296295A (en) * 2022-08-10 2022-11-04 国网湖南省电力有限公司 Low-voltage distribution area topology identification method and system based on cluster analysis and graph theory
CN117639280B (en) * 2024-01-25 2024-04-12 国网四川省电力公司天府新区供电公司 Cloud computing-based intelligent power grid fault monitoring system

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012139658A2 (en) * 2011-04-15 2012-10-18 Siemens Aktiengesellschaft Low-voltage distribution system and method for operating the same
CN104573853A (en) * 2014-12-19 2015-04-29 华南理工大学 Systematic solution for voltage quality evaluation and optimization of low-voltage transformer area distribution networks
CN104852470A (en) * 2015-05-11 2015-08-19 国家电网公司 End user selection method based on graphical topology
CN106772499A (en) * 2016-11-16 2017-05-31 湖南华烨智能通信技术股份有限公司 A kind of method and system of automatic acquisition platform area topological diagram
CN106779168A (en) * 2016-11-23 2017-05-31 国网山东省电力公司威海供电公司 A kind of distribution transformer addressing and low pressure rack plan optimization method
CA2915674A1 (en) * 2015-12-17 2017-06-17 Francois Leonard Update of the topology of a distribution network by successive reattribution of counters
CN107196801A (en) * 2017-05-27 2017-09-22 深圳市均方根科技有限公司 A kind of platform area topological automatic identification system
CN107394897A (en) * 2017-08-21 2017-11-24 国网山东省电力公司济南供电公司 A kind of power distribution network intelligence self-healing method and system based on topological diagram

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012139658A2 (en) * 2011-04-15 2012-10-18 Siemens Aktiengesellschaft Low-voltage distribution system and method for operating the same
CN104573853A (en) * 2014-12-19 2015-04-29 华南理工大学 Systematic solution for voltage quality evaluation and optimization of low-voltage transformer area distribution networks
CN104852470A (en) * 2015-05-11 2015-08-19 国家电网公司 End user selection method based on graphical topology
CA2915674A1 (en) * 2015-12-17 2017-06-17 Francois Leonard Update of the topology of a distribution network by successive reattribution of counters
CN106772499A (en) * 2016-11-16 2017-05-31 湖南华烨智能通信技术股份有限公司 A kind of method and system of automatic acquisition platform area topological diagram
CN106779168A (en) * 2016-11-23 2017-05-31 国网山东省电力公司威海供电公司 A kind of distribution transformer addressing and low pressure rack plan optimization method
CN107196801A (en) * 2017-05-27 2017-09-22 深圳市均方根科技有限公司 A kind of platform area topological automatic identification system
CN107394897A (en) * 2017-08-21 2017-11-24 国网山东省电力公司济南供电公司 A kind of power distribution network intelligence self-healing method and system based on topological diagram

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
WHEI-MIN LIN 等: "Application of geographic information system to distribution information support", 《IEEE TRANSACTIONS ON POWER SYSTEMS》 *
王桐: "复杂网络拓扑图的自动绘制", 《2011 2ND ASIA-PACIFIC CONFERENCE ON WEARABLE COMPUTING SYSTEMS》 *

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111078815A (en) * 2019-12-12 2020-04-28 浙江华云信息科技有限公司 Hybrid loading method for power grid data
CN111078815B (en) * 2019-12-12 2023-08-15 浙江华云信息科技有限公司 Hybrid loading method for power grid data
CN111159897A (en) * 2019-12-31 2020-05-15 新奥数能科技有限公司 Target optimization method and device based on system modeling application
CN111159897B (en) * 2019-12-31 2023-11-03 新奥数能科技有限公司 Target optimization method and device based on system modeling application
CN111342554A (en) * 2020-02-17 2020-06-26 石家庄学院 Automatic identification system and method for distribution room topology
CN111342554B (en) * 2020-02-17 2024-01-19 石家庄学院 Automatic identification system and method for topology of transformer area
CN111654392A (en) * 2020-05-11 2020-09-11 国网浙江省电力有限公司电力科学研究院 Low-voltage distribution network topology identification method and system based on mutual information
CN112285467A (en) * 2020-10-19 2021-01-29 北京前景无忧电子科技有限公司 Method for automatically identifying power supply topology of low-voltage distribution area
CN112285467B (en) * 2020-10-19 2023-03-03 北京前景无忧电子科技股份有限公司 Method for automatically identifying power supply topology of low-voltage distribution area
CN112256929A (en) * 2020-10-23 2021-01-22 全球能源互联网研究院有限公司 Graph database-based electric power industry expansion method and system
CN112562038A (en) * 2020-12-22 2021-03-26 广东电网有限责任公司茂名供电局 Low-voltage distribution network graph generation method based on cluster analysis
CN112910696A (en) * 2021-01-22 2021-06-04 上海三零卫士信息安全有限公司 Automatic modeling analysis method for network topology
CN115296295B (en) * 2022-08-10 2023-08-22 国网湖南省电力有限公司 Low-voltage distribution transformer area topology identification method and system based on cluster analysis and graph theory
CN115296295A (en) * 2022-08-10 2022-11-04 国网湖南省电力有限公司 Low-voltage distribution area topology identification method and system based on cluster analysis and graph theory
CN115221979A (en) * 2022-09-15 2022-10-21 国网江西省电力有限公司电力科学研究院 Power distribution station topology identification method and system based on minimum spanning tree
CN117639280B (en) * 2024-01-25 2024-04-12 国网四川省电力公司天府新区供电公司 Cloud computing-based intelligent power grid fault monitoring system

Also Published As

Publication number Publication date
CN109408603B (en) 2021-09-07

Similar Documents

Publication Publication Date Title
CN109408603A (en) A kind of platform area topology drawing drawing method based on big data
Ashkezari et al. Development of an enterprise Geographic Information System (GIS) integrated with smart grid
Ma et al. Resilience enhancement of distribution grids against extreme weather events
Medjroubi et al. Open data in power grid modelling: new approaches towards transparent grid models
US20220115867A1 (en) Advanced power distribution platform
US10652633B2 (en) Integrated solutions of Internet of Things and smart grid network pertaining to communication, data and asset serialization, and data modeling algorithms
CN109635127B (en) Power equipment portrait knowledge map construction method based on big data technology
CN105354680B (en) GIS-based power grid section auxiliary determination analysis method
CN115640935A (en) Method and device for calculating carbon emission of power system and computer equipment
Ye et al. A data driven multi-state model for distribution system flexible planning utilizing hierarchical parallel computing
Ali et al. Generating open-source datasets for power distribution network using openstreetmaps
Dutta Data mining and graph theory focused solutions to smart grid challenges
BR102014015986A2 (en) A non-transient computing device and a device for synchronizing infrastructural information on a network system
Gianluigi et al. The innovative FlexPlan methodology to reap the benefits of including storage and load flexibility in grid planning: methodology and regional study cases
Mathias et al. Developing of a Smart Fraud Detection System in Advanced Metering Infrastructure Using Deep Learning
Nakafuji et al. Distributed resource energy analysis and management system (DREAMS) development for real-time grid operations
Zaidi et al. Information management of a power distribution network in real time through GIS mapping
Hall A simulation tool to guide infrastructure decisions: system-of-systems modeling aids prioritization and uncertainty planning
Marean et al. A Coordinated Utility Emergency Response: Addressing Information-Sharing Barriers for Utilities and Emergency Response Organizations
Haripriya et al. GIS Based Transmission System Planning
CN112952799B (en) Dynamic modeling method for standing book information for intelligent operation and maintenance of power distribution network
Chen et al. Automated data integration of residential and commercial PV systems into DSO SCADA utilising IEC 61850 compliant comprehensive data model
Thacker et al. Characterizing the Vulnerability of Future Configurations of Great Britain's Electricity Network Infrastructure to Climate-related Hazards
Colmenares Quintero et al. Smart Grids to Lower Energy Usage and Carbon Emissions: Case Study Examples from Colombia and Turkey
Martikainen Electrical distribution network asset management from the aspect of authority regulation

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
GR01 Patent grant
GR01 Patent grant