CN115375084B - Graph database construction method and system based on power data - Google Patents
Graph database construction method and system based on power data Download PDFInfo
- Publication number
- CN115375084B CN115375084B CN202210797625.XA CN202210797625A CN115375084B CN 115375084 B CN115375084 B CN 115375084B CN 202210797625 A CN202210797625 A CN 202210797625A CN 115375084 B CN115375084 B CN 115375084B
- Authority
- CN
- China
- Prior art keywords
- node
- nodes
- attribute
- relation
- data
- 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
- 238000010276 construction Methods 0.000 title claims abstract description 14
- 238000000034 method Methods 0.000 claims abstract description 20
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 abstract description 9
- 230000000694 effects Effects 0.000 abstract description 2
- 238000012986 modification Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 238000009826 distribution Methods 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- 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/06313—Resource planning in a project environment
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Health & Medical Sciences (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biodiversity & Conservation Biology (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a graph database construction method and system based on electric power data, wherein the method comprises the following steps: acquiring a business model corresponding to a target power system; determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node; searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation. According to the invention, the tree structure is adopted to store the electric power data, the data display is clearer, the nodes and edges in the tree diagram are adopted to represent related devices and the relation among the devices, and the effect of each data is clearer, so that the utilization rate of the whole data information is increased.
Description
Technical Field
The invention relates to the technical field of power distribution planning, in particular to a graph database construction method and system based on power data.
Background
Along with the development of economic technology and the improvement of living standard of people, electric energy has become an indispensable energy source in people's production life, and in power system, generally adopts power management system, power Management System, PMS storage data, but this kind of system can't demonstrate data directly perceivedly, query and statistics inefficiency of data, and complicated topological connection relation also can not store and demonstrate.
Disclosure of Invention
The invention aims to: in order to overcome the defects of the prior art, the invention provides a graph database construction method based on electric power data, which solves the problems that the query efficiency is low and complex topological connection relation cannot be stored and displayed.
The technical scheme is as follows: according to a first aspect of the present invention, there is provided a graph database construction method based on power data, the method comprising the steps of:
step S1, acquiring a service model corresponding to a target power system;
step S2, determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment;
and step S3, searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation.
Further, the method comprises the steps of:
the step S2 specifically comprises the following steps:
step S21, acquiring each line and attribute information corresponding to the line, wherein the line is used as a first node, and the attribute information corresponding to the line is used as an attribute of the first node;
step S22, acquiring the grid of the current line, taking the grid as a second node, and taking attribute information corresponding to the grid as the attribute of the second node;
step S23 determines the relation between the line attribute information and the grid attribute information, and obtains the attribute of the first side data and the direction of the first side data according to the relation.
Further, the method comprises the steps of:
the association relation comprises the following steps:
the attribution relation is as follows: province and savingGround city->County ++>Grid->Line->Under-line towers, stations, devices->The tower, the station subordinate equipment and the station internal structure;
the intra-station connection relationship is an association relationship between subordinate devices in the station with the attribution relationship;
the line topological relation is the association relation among the substation station equipment, the subordinate equipment in the station and the off-station equipment;
the electrical connection relationship is the association relationship between the off-site equipment and subordinate equipment in the site and between the two subordinate equipment.
Further, the method comprises the steps of:
the step S3 specifically comprises the following steps:
step S31, obtaining a directly attached device of a line, setting the directly attached device as a child node taking the line as a main node, and setting the attribute and the direction of edge data according to the attribution relation of the line and the device;
step S32, subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices are obtained, the child nodes are used as main nodes, the subordinate devices are used as child nodes, and the attribute and the direction of edge data are set according to the relations;
step S33, other facilities associated with subordinate devices of the corresponding devices of the sub-nodes in step S32 are obtained, and corresponding node and edge data are set according to the relation;
step S34 searches nodes in the topological graph obtained in the steps S2 to S3, if the orphan node exists, whether the association relation exists between the current orphan node and other nodes is searched, if the association relation exists, the orphan node is connected with the nodes with the association relation, otherwise, the other nodes are continuously searched until the interconnection of all the nodes with the association relation is completed.
Further, the method comprises the steps of:
in step S31, the directly attached devices of the line include a transformer substation, a site and an off-site device, and the relationship with the line node is a home relationship;
in step S32, the subordinate device includes an intra-station switch and a bus, the edge data attribute between the station and the bus is a home relation, the edge data attribute between the station and the intra-station switch is a home relation and a line topological relation, the direction is that the station includes the intra-station switch and the bus, and the edge data attribute between the intra-station switch and the bus is an intra-station connection relation.
Further, the method comprises the steps of:
the coordinate information and other information which is not required as a search condition are taken as independent nodes, the site node is taken as a main node, and the independent nodes are not taken as main nodes of other nodes.
According to a second aspect of the present invention, there is provided a graph database construction system based on power data, the system comprising:
the service model acquisition module is used for acquiring a service model corresponding to the target power system;
the initial node setting module is used for determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment;
and the other node setting module is used for searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation.
Further, the method comprises the steps of:
an initial node setting module, comprising:
the first node setting unit is used for acquiring each line and attribute information corresponding to the lines, wherein the lines are used as first nodes, and the attribute information corresponding to the lines is used as the attribute of the first nodes;
a second node setting unit, configured to obtain a grid to which the current line belongs, and use the grid as a second node, where attribute information corresponding to the grid is used as an attribute of the second node;
and the side data setting unit is used for determining the relation between the line attribute information and the grid attribute information and obtaining the attribute of the first side data and the direction of the first side data according to the relation.
Further, the method comprises the steps of:
the association relation comprises the following steps:
the attribution relation is as follows: province and savingGround city->County ++>Grid->Line->Under-line towers, stations, devices->The tower, the station subordinate equipment and the station internal structure;
the intra-station connection relationship is an association relationship between subordinate devices in the station with the attribution relationship;
the line topological relation is the association relation among the substation station equipment, the subordinate equipment in the station and the off-station equipment;
the electrical connection relationship is the association relationship between the off-site equipment and subordinate equipment in the site and between the two subordinate equipment.
Further, the method comprises the steps of:
other node setting modules specifically include:
the device node setting unit is used for acquiring a directly attached device of a circuit, setting the directly attached device as a child node taking the circuit as a main node, and setting the attribute and the direction of edge data according to the attribution relation between the circuit and the device;
the device node setting unit is used for acquiring subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices, taking the child nodes as main nodes, taking the subordinate devices as child nodes, and setting the attribute and the direction of the edge data according to the relations;
the facility node setting unit is used for acquiring other facilities associated with subordinate equipment of the sub-node corresponding device in the initial node setting module and setting corresponding node and edge data according to the relation;
and the connection confirmation unit is used for searching nodes in the topological graph, searching whether the current orphan node and other nodes have an association relationship or not if the orphan node exists, connecting the orphan node with the nodes with the association relationship if the orphan node exists, and continuously searching other nodes if the orphan node exists, until the interconnection of all the nodes with the association relationship is completed.
The beneficial effects are that: the invention adopts the graph database to represent the data in the power system, and maps the model into the database based on the graph database model, thereby optimizing the query efficiency; according to the invention, the tree structure is adopted to store the electric power data, so that the data display is clearer, and the nodes and edges in the tree diagram are adopted to represent related devices and the relation among the devices, so that the effect of each data is clearer, and the utilization rate of the whole data information is increased; representing power data based on graph data, more complex topologies may be stored for presentation and computation.
Drawings
FIG. 1 is a flowchart of a graph database construction method according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating the configuration of a first node and a second node according to an embodiment of the present invention;
FIG. 3 is a flow chart of adding other nodes to a topology according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an independent node added to a topology according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of first and second nodes added to a topology according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of adding a node at a site to a topology according to an embodiment of the present invention;
fig. 7 is a schematic diagram of adding an out-of-station device node to a topology according to an embodiment of the present invention;
FIG. 8 is a schematic diagram of a topology according to an embodiment of the present invention;
fig. 9 is a schematic diagram of a graph database construction system according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
First, the present invention provides, according to a first aspect of the present invention, a graph database construction method based on power data, as shown in fig. 1, the method comprising the steps of:
step S1, acquiring a service model corresponding to a target power system;
the business model is stored in the PMS and includes all the power data and relationships between the data that need to be stored in the graph database, where the power data includes the relevant components used during the operation of the grid equipment system.
Step S2, determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment.
Before that, an independent node needs to be added to the topology, and step S2 specifically includes:
in step S21, as shown in fig. 4, information and coordinate information which are not required as search conditions in the information originally stored in the node are extracted to form independent information nodes and coordinate nodes, so that the pressure during searching is reduced, and the performance is improved. The coordinate information and other information which does not need to be used as search conditions are used as independent nodes and recorded as Cor nodes and Info nodes, the site node Station is used as a main node, the independent nodes are not used as main nodes of other nodes, the edge data attribute of the site node Station and Cor nodes is the coordinate COR_L, the edge data attribute of the site node Station and Info nodes is specific information INFO_L, and the site is mainly used as power conversion and distribution nodes of various power equipment in a power grid, such as a power distribution Station, a transformer substation, an switching Station and the like.
Step S22, obtaining each Line and attribute information corresponding to the Line, wherein the Line is used as a first node, and the attribute information corresponding to the Line is used as an attribute of the first node;
step S23, acquiring the Grid of the current line, taking the Grid as a second node, and taking attribute information corresponding to the Grid as the attribute of the second node;
step S24, determining the association relation between the line attribute information and the grid attribute information, and obtaining the attribute of the first side data and the direction of the first side data according to the association relation, wherein the association relation between the line attribute information and the grid attribute information is the attribution relation BELONG_L.
The grid information comprises the information of the city, district and county to which the line belongs and the grid as nodes. The line information includes a mark number, a name, a preset attribute, and the like of the line. These nodes are abstract, non-physical. Other nodes such as: nodes such as towers and equipment are all objects and buildings which exist in practice. The grid information and the line information are abstracted into nodes of a graph library, and meanwhile, the equipment information is stored into the graph database and connected by using attribution relation edges, so that a tree structure from top to bottom, which is formed by the grid to subordinate facilities and equipment through the line, is formed.
Wherein, the association relation includes:
(1) The home relationship BELONG_L is: province and savingGround city->County ++>Grid->Line->Under-line towers, stations, devices->The tower, the station subordinate equipment and the station internal structure;
(2) The intra-station connection relationship sub_l is an association relationship between subordinate devices in the station with the attribution relationship;
(3) The line topology relation route_l is an association relation among substation equipment, subordinate equipment in the substation and equipment outside the substation;
(4) The electrical connection relation ele_l is an association relation between an off-site device and a subordinate device in a site and between two subordinate devices.
The association relation calculating method is calculated by adopting SVG files in a service model, and specifically comprises the following steps:
according to cge GLink_Ref information, the front-back connection relation among all devices is analyzed by matching with GlobeID, and relationship-json data is generated; each piece of data represents a device, and an ObjectId represents the current device, meanwhile, there is linkObjectIdList information representing the connection relation between the current device and other devices, and the linkObjectIdList is stored in the linkObjectIdList and is the objectId of other devices, so that the objectId and the linkObjectIdList can be used for matching in the program, and the two devices are equal, and whether the two devices are connected or in-station connection relation is judged.
The GlobeID is the original data in the svg information, each device has its own GlobeID and is different, meanwhile, the GlobeID is the specific id of the device in the PMS system, and the PMS system assigns the unique id value in the database to the GlobeID when generating the svg graph, so that the unique corresponding device information can be queried in the PMS database through the GlobeID. Therefore, matching is performed according to the GlobeID in the relationship-json data and the local PMS data, if the same PMS data exists, the objectName data is parsed into the mysql relational database, and meanwhile, the topology data, namely, the connection relational data in the relationship-json, is parsed.
The relationship-json topology analysis comprises the following steps: analyzing all cable segments, namely routes, and generating corresponding segment nodes in a graph database; analyzing all other devices except the line, generating corresponding device nodes in the graph database, and connecting the associated line segment nodes; reading the generated equipment nodes, line segment nodes and association relations among the line segment nodes, and generating a basic line topology; generating a circuit topology and an electrical topology according to the basic circuit topology; the basic line topology refers to the topology formed by connecting all lines, substations and tower equipment in the SVG file.
And step S3, searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation.
The method specifically comprises the following steps:
step S31, obtaining a directly attached device of a line, setting the directly attached device as a child node taking the line as a main node, and setting the attribute and the direction of edge data according to the attribution relation of the line and the device;
the directly attached devices of the Line include Substation, station and equipment outside the Station, and the relationship with the Line node Line is the home relationship BELONG_L, as shown in FIG. 5.
Step S32, subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices are obtained, the child nodes are used as main nodes, the subordinate devices are used as child nodes, and the attribute and the direction of the edge data are set according to the relations;
the subordinate equipment comprises an intra-station Switch and a bus bar, the edge data attribute between the station and the bus bar is a home relation BELONG_L, the edge data attribute between the station and the intra-station Switch is a home relation and a line topological relation ROUTE_L, the direction is that the station comprises the intra-station Switch and the bus bar, and the edge data attribute between the intra-station Switch and the bus bar is an intra-station connection relation SUB_L.
Specifically, the substation, the station structures of facilities such as a branch box and a ring main unit are added, all buses subordinate to the facilities are used as main nodes of the station structures, and a main station topology is formed by associating circuits, switches and other equipment. A busbar refers to a common passage to which a plurality of devices are connected in parallel branches, and specifically refers to a portion of a cable belonging to a facility as a main passage. And the formed intra-station topology is divided into two parts: abstract attribution relation, wherein the most basic is that a switch, a cable and a transformer are attributed to the site; the actual connection relationship is that current enters the bus through the incoming line Switch and then is supplied to the outside through the outgoing Switch, as shown in fig. 6, which is a tree diagram of the intra-Station structure information, a BELONG_L relationship is formed between Station and Switch, a BELONG_L relationship is formed between Station and bus, and an edge data attribute between the intra-Station Switch and bus is an intra-Station connection relationship SUB_L.
Step S33, other facilities associated with subordinate devices of the corresponding devices of the sub-nodes in step S32 are obtained, and corresponding node and edge data are set according to the relation;
in addition, the association relation between facility nodes such as towers, cable wells, switching stations and the like and newly added equipment nodes is increased, so that the whole topology of equipment inside and outside a transformer substation through cables, station facilities and the like is formed, and the whole topology is created as a line topology side and is used as the whole domain connection relation of all facilities and equipment on the whole line.
And the association relation between the electrical equipment is increased, abstract nodes irrelevant to the electrical equipment and physical site facility nodes are removed on the basis of circuit topology, adjacent electrical equipment is directly associated, so that an electrical topology edge is created, various electrical index data are conveniently calculated, as shown in fig. 7, the relation between Station and Switch is BELONG_L and ROUTE_L, the relation between Device and Switch is ELE_L, and the relation between Station and Device is ROUTE_L.
Step S34 searches nodes in the topological graph obtained in the step S2 to the step S3, if the orphan node exists, whether the association relation exists between the current orphan node and other nodes is searched, if the association relation exists, the orphan node is connected with the nodes with the association relation to form corresponding edge data, otherwise, the other orphan nodes are continuously searched.
And step S35, if no orphan node exists, searching the nodes in the topological graph obtained in the step S34, if the association relation exists between the two nodes but the edge data attribute is not determined, adding the edge data attribute and updating the model, otherwise, continuing to search other nodes. As shown in fig. 8, the above modification is performed on the original basic model of the physical topology to form a final model.
Creating a database based on the final model: and reading original topology data (including transformer substations, towers, cable wells, ring main units, branch boxes, switching stations, distribution room nodes, overhead and cable edges and expected related information) of a graph database, and creating transformer Substation node substations, station node stations and line foundation connection BASIC_L.
The Grid, line and equipment information stored in mysql is read, grid nodes Grid, line nodes, off-site equipment node equipment (including off-site switches, public transformers and private transformers), on-site equipment SUB equipment (including buses, switches, transformers and other equipment which do not participate in calculation), on-site equipment SSequipment (mainly including buses, outlet switches, internal connection switches, transformers and other equipment), and home relation BELONG_L and on-site connection relation SUB_L among grids, substations, lines, sites and equipment are created. Adding circuit association with substation station equipment, station equipment and off-station equipment to create a line topology route_L according to the BASIC topology and equipment connection relation BASIC_L; based on the line topology, the site node and the specific left are ignored, and only the electric devices are connected to create the electric topology ELE_L.
Data application: obtaining a line basic topological structure, and using: the method comprises the steps of line-facility (pole tower, cable well, switching station and the like), equipment (switch, transformer and the like), line-coordinate, facility-coordinate, equipment-coordinate, and obtaining the node and topological relation of the line.
Inquiring line and equipment facility information, using: line, facility, equipment and information, and then all information of the line subordinate can be obtained.
Statistical line electrical attribute data, using: line- & gt equipment- & gt (electrical topology) & gt equipment can query the line electrical topology for calculation.
In addition, the invention also provides a service model acquisition module, as shown in fig. 9, which is used for acquiring a service model corresponding to the target power system;
the initial node setting module is used for determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment;
and the other node setting module is used for searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation.
An initial node setting module, comprising:
the first node setting unit is used for acquiring each line and attribute information corresponding to the lines, wherein the lines are used as first nodes, and the attribute information corresponding to the lines is used as the attribute of the first nodes;
a second node setting unit, configured to obtain a grid to which the current line belongs, and use the grid as a second node, where attribute information corresponding to the grid is used as an attribute of the second node;
and the side data setting unit is used for determining the relation between the line attribute information and the grid attribute information and obtaining the attribute of the first side data and the direction of the first side data according to the relation.
The association relation comprises the following steps:
the attribution relation is as follows: province and savingGround city->County ++>Grid->Line->Under-line towers, stations, devices->The tower, the station subordinate equipment and the station internal structure;
the intra-station connection relationship is an association relationship between subordinate devices in the station with the attribution relationship;
the line topological relation is the association relation among the substation station equipment, the subordinate equipment in the station and the off-station equipment;
the electrical connection relationship is the association relationship between the off-site equipment and subordinate equipment in the site and between the two subordinate equipment.
Other node setting modules specifically include:
the device node setting unit is used for acquiring a directly attached device of a circuit, setting the directly attached device as a child node taking the circuit as a main node, and setting the attribute and the direction of edge data according to the attribution relation between the circuit and the device;
the device node setting unit is used for acquiring subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices, taking the child nodes as main nodes, taking the subordinate devices as child nodes, and setting the attribute and the direction of the edge data according to the relations;
the facility node setting unit is used for acquiring other facilities associated with subordinate equipment of the sub-node corresponding device in the initial node setting module and setting corresponding node and edge data according to the relation;
and the connection confirmation unit is used for searching nodes in the topological graph, searching whether the current orphan node and other nodes have an association relationship or not if the orphan node exists, connecting the orphan node with the nodes with the association relationship if the orphan node exists, and continuously searching other nodes if the orphan node exists, until the interconnection of all the nodes with the association relationship is completed.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various modifications and variations can be made to the embodiments of the present invention without departing from the spirit or scope of the embodiments of the invention. Thus, if such modifications and variations of the embodiments of the present invention fall within the scope of the claims and the equivalents thereof, the present invention is also intended to include such modifications and variations.
Claims (5)
1. The graph database construction method based on the power data is characterized by comprising the following steps of:
step S1, acquiring a service model corresponding to a target power system, wherein the service model is stored in a PMS and comprises all power data required to be stored in a graph database and relations among the data, and the power data comprises related devices used in the operation process of a power grid equipment system;
step S2, determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment;
step S3, searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation;
the step S2 specifically comprises the following steps:
step S21, extracting information and coordinate information which are not required to be used as search conditions from information originally stored on the nodes to form independent information nodes and coordinate nodes, namely, taking the coordinate information and other information which are not required to be used as search conditions as independent nodes, marking the independent nodes as Cor nodes and Info nodes, taking a Station node as a main node, taking the independent nodes as main nodes of other nodes, taking the side data attribute of the Station node Station and Cor nodes as coordinates COR_L, and taking the side data attribute of the Station node Station and Info nodes as specific information INFO_L;
step S22, obtaining each Line and attribute information corresponding to the Line, wherein the Line is used as a first node, and the attribute information corresponding to the Line is used as an attribute of the first node;
step S23, acquiring the Grid of the current line, taking the Grid as a second node, and taking attribute information corresponding to the Grid as the attribute of the second node;
step S24, determining the association relation between the line attribute information and the grid attribute information, and obtaining the attribute of the first side data and the direction of the first side data according to the association relation, wherein the association relation between the line attribute information and the grid attribute information is the attribution relation BELONG_L;
the method for calculating the association relation is obtained by calculating SVG files in a service model, and specifically comprises the following steps:
according to cge GLink_Ref information, the front-back connection relation among all devices is analyzed by matching with GlobeID, and relationship-json data is generated; each piece of data represents a device, and has an ObjectId representing the current device, and meanwhile, there is linkObjectIdList information representing the connection relation between the current device and other devices, and the linkObjectIdList is stored in the linkObjectId and is the objectId of other devices, so that the objectId and the linkObjectIdList can be used for matching in a program, and the two devices are equal to represent that the two devices are connected, and whether the attribution relation or the in-station connection relation is judged;
the GlobeID is original data in svg information, each device has own GlobeID and is different, meanwhile, the GlobeID is a specific id of a device in a PMS system, the PMS system assigns a unique id value in a database to the GlobeID when generating an svg graph, therefore, unique corresponding device information can be queried in the PMS database through the GlobeID, matching is carried out according to the GlobeID in the relation-json data with the local PMS data, if the same PMS data exists, the objectName data is resolved into a mysql relational database, and meanwhile, connection relation data in the topology data, namely the relation-json, is resolved;
the step S3 specifically comprises the following steps:
step S31, obtaining a directly attached device of a line, setting the directly attached device as a child node taking the line as a main node, and setting the attribute and the direction of edge data according to the attribution relation of the line and the device;
step S32, subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices are obtained, the child nodes are used as main nodes, the subordinate devices are used as child nodes, and the attribute and the direction of edge data are set according to the relations;
step S33, other facilities associated with subordinate devices of the corresponding devices of the sub-nodes in step S32 are obtained, and corresponding node and edge data are set according to the relation;
step S34 searches nodes in the topological graph obtained in the steps S2 to S3, if the orphan node exists, whether the association relation exists between the current orphan node and other nodes is searched, if the association relation exists, the orphan node is connected with the nodes with the association relation, otherwise, the other nodes are continuously searched until the interconnection of all the nodes with the association relation is completed.
2. The power data-based graph database construction method according to claim 1, wherein the association relation includes:
attribution relation：
The intra-station connection relationship is an association relationship between subordinate devices in the station with the attribution relationship;
the line topological relation is the association relation among the substation station equipment, the subordinate equipment in the station and the off-station equipment;
the electrical connection relationship is the association relationship between the off-site equipment and subordinate equipment in the site and between the two subordinate equipment.
3. The method for constructing a graph database based on electric power data according to claim 1, wherein in step S31, directly attached devices of a line include a substation, a site, and an off-site device, and a relationship with the line node is a home relationship; in step S32, the subordinate device includes an intra-station switch and a bus, the edge data attribute between the station and the bus is a home relation, the edge data attribute between the station and the intra-station switch is a home relation and a line topological relation, the direction is that the station includes the intra-station switch and the bus, and the edge data attribute between the intra-station switch and the bus is an intra-station connection relation.
4. A graph database construction system based on power data, comprising:
the service model acquisition module is used for acquiring a service model corresponding to the target power system, wherein the service model is stored in the PMS and comprises all power data required to be stored in a graph database and relations among the data, and the power data comprises related devices used in the operation process of the power grid equipment system;
the initial node setting module is used for determining a first node and a second node of a topological structure according to each device in the service model, determining the attribute of the first node and the attribute of the second node according to the device attribute, and determining the attribute of first side data to be added by utilizing the association relation between the first node and the second node, wherein the device attribute comprises attribute information of a line, a device associated with the line, subordinate equipment of the device and other facilities associated with the equipment;
the other node setting module is used for searching other devices in the service model, acquiring the association relation between the other devices and the first node, the second node or the other devices, storing the association relation as other nodes, and finally determining corresponding edge data and attributes according to the association relation;
an initial node setting module, comprising:
a first node setting unit, configured to extract information and coordinate information that are not required to be used as search conditions from information originally stored on a node, to form an independent information node and a coordinate node, that is, coordinate information and other information that are not required to be used as search conditions are used as independent nodes, denoted as Cor node and Info node, and a Station node Station is used as a main node, the independent nodes are not used as main nodes of other nodes, the edge data attribute of the Station node Station and Cor node is coordinate cor_l, and the edge data attribute of the Station node Station and Info node is specific information info_l; acquiring each line and attribute information corresponding to the line, wherein the line is used as a first node, and the attribute information corresponding to the line is used as an attribute of the first node;
a second node setting unit, configured to obtain a grid to which the current line belongs, and use the grid as a second node, where attribute information corresponding to the grid is used as an attribute of the second node;
the side data setting unit is used for determining the association relation between the line attribute information and the grid attribute information and obtaining the attribute of the first side data and the direction of the first side data according to the association relation;
the method for calculating the association relation is obtained by calculating SVG files in a service model, and specifically comprises the following steps:
according to cge GLink_Ref information, the front-back connection relation among all devices is analyzed by matching with GlobeID, and relationship-json data is generated; each piece of data represents a device, and has an ObjectId representing the current device, and meanwhile, there is linkObjectIdList information representing the connection relation between the current device and other devices, and the linkObjectIdList is stored in the linkObjectId and is the objectId of other devices, so that the objectId and the linkObjectIdList can be used for matching in a program, and the two devices are equal to represent that the two devices are connected, and whether the attribution relation or the in-station connection relation is judged;
the GlobeID is original data in svg information, each device has own GlobeID and is different, meanwhile, the GlobeID is a specific id of a device in a PMS system, the PMS system assigns a unique id value in a database to the GlobeID when generating an svg graph, therefore, unique corresponding device information can be queried in the PMS database through the GlobeID, matching is carried out according to the GlobeID in the relation-json data with the local PMS data, if the same PMS data exists, the objectName data is resolved into a mysql relational database, and meanwhile, connection relation data in the topology data, namely the relation-json, is resolved;
other node setting modules specifically include:
the device node setting unit is used for acquiring a directly attached device of a circuit, setting the directly attached device as a child node taking the circuit as a main node, and setting the attribute and the direction of edge data according to the attribution relation between the circuit and the device;
the device node setting unit is used for acquiring subordinate devices of the devices corresponding to the child nodes and connection relations among the subordinate devices, taking the child nodes as main nodes, taking the subordinate devices as child nodes, and setting the attribute and the direction of the edge data according to the relations;
the facility node setting unit is used for acquiring other facilities associated with subordinate equipment of the sub-node corresponding device in the initial node setting module and setting corresponding node and edge data according to the relation;
and the connection confirmation unit is used for searching nodes in the topological graph, searching whether the current orphan node and other nodes have an association relationship or not if the orphan node exists, connecting the orphan node with the nodes with the association relationship if the orphan node exists, and continuously searching other nodes if the orphan node exists, until the interconnection of all the nodes with the association relationship is completed.
5. The power data based graph database construction system of claim 4, wherein the association relationship includes:
the attribution relation is as follows:
the intra-station connection relationship is an association relationship between subordinate devices in the station with the attribution relationship;
the line topological relation is the association relation among the substation station equipment, the subordinate equipment in the station and the off-station equipment;
the electrical connection relationship is the association relationship between the off-site equipment and subordinate equipment in the site and between the two subordinate equipment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210797625.XA CN115375084B (en) | 2022-07-08 | 2022-07-08 | Graph database construction method and system based on power data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210797625.XA CN115375084B (en) | 2022-07-08 | 2022-07-08 | Graph database construction method and system based on power data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115375084A CN115375084A (en) | 2022-11-22 |
| CN115375084B true CN115375084B (en) | 2023-11-28 |
Family
ID=84060958
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210797625.XA Active CN115375084B (en) | 2022-07-08 | 2022-07-08 | Graph database construction method and system based on power data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115375084B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117591539B (en) * | 2023-12-07 | 2024-05-14 | 中国长江电力股份有限公司 | Multi-data integration and application integrated system and method based on electric power big data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108494575A (en) * | 2018-01-19 | 2018-09-04 | 全球能源互联网研究院有限公司 | A kind of power telecom network method of operation modeling method and system based on chart database |
| CN109284346A (en) * | 2018-09-20 | 2019-01-29 | 南方电网科学研究院有限责任公司 | Cloud computing-based power distribution network planning method and device |
| CN110134833A (en) * | 2019-05-09 | 2019-08-16 | 南京邮电大学 | Diagram data modeling and method towards power network topology management |
| CN111309836A (en) * | 2020-02-11 | 2020-06-19 | 国网江西省电力有限公司电力科学研究院 | Automatic mapping method and system for single line diagram of 10kV distribution line |
-
2022
- 2022-07-08 CN CN202210797625.XA patent/CN115375084B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108494575A (en) * | 2018-01-19 | 2018-09-04 | 全球能源互联网研究院有限公司 | A kind of power telecom network method of operation modeling method and system based on chart database |
| CN109284346A (en) * | 2018-09-20 | 2019-01-29 | 南方电网科学研究院有限责任公司 | Cloud computing-based power distribution network planning method and device |
| CN110134833A (en) * | 2019-05-09 | 2019-08-16 | 南京邮电大学 | Diagram data modeling and method towards power network topology management |
| CN111309836A (en) * | 2020-02-11 | 2020-06-19 | 国网江西省电力有限公司电力科学研究院 | Automatic mapping method and system for single line diagram of 10kV distribution line |
Non-Patent Citations (1)
| Title |
|---|
| 基于图数据库的电力通信网络运行方式建模技术;柴博等;《电力信息与通信技术》;第第16卷卷(第第10期期);第13-18页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115375084A (en) | 2022-11-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN106650161B (en) | Electrical single line diagram mapping method and system based on power grid GIS | |
| CN102521398B (en) | Modeling method for substation-dispatching center two-level distributed type power grid | |
| CN102411765B (en) | Three-dimensional power grid construction method and device | |
| CN101930481B (en) | Method used for generating CIM model describing power grid change in designated time slot and system thereof | |
| CN104156835A (en) | Wide-area distributed integrated topology analysis method for large power grid | |
| CN102403718B (en) | Generating method for power grid topological relationship based on Arcgis | |
| CN104133943A (en) | Distribution network pattern automatic generating method based on target guide | |
| CN112507499A (en) | GIS-based power distribution network line loss data acquisition method and related device | |
| CN102375828A (en) | Physical storage and optimization method of power grid topology in relational database | |
| CN115375084B (en) | Graph database construction method and system based on power data | |
| CN112990538A (en) | Method, device and equipment for determining current collection circuit of mountain photovoltaic power station | |
| CN112685570A (en) | Multi-label graph-based power grid network frame knowledge graph construction method | |
| CN111192010A (en) | Standing book data processing method and device | |
| CN109871566B (en) | Loop construction method based on power grid topology technology and storage medium | |
| CN113343396B (en) | Incremental distribution method from single line diagram of power distribution network to geographical wiring diagram | |
| CN112990560B (en) | Automatic generation method and device for power grid geographical wiring diagram | |
| CN112308736A (en) | Information processing method and device for complex environment of transformer area | |
| CN114818632B (en) | Method and device for compiling power limit sequence table for super-planning | |
| CN114336638B (en) | Medium-voltage active power distribution network dynamic reconstruction method based on bubbling model | |
| Li et al. | Distribution feeder one-line diagrams automatic generation from geographic diagrams based on GIS | |
| CN114996535A (en) | Data retrieval method and system for power equipment in power grid and electronic equipment | |
| CN113486487B (en) | Automatic acquisition method for geographical wiring logic structure diagram based on digital power grid | |
| CN113158392A (en) | Power distribution graphical monitoring and computing system | |
| CN114818631A (en) | Method and device for compiling over-plan power utilization and power limiting line modification table |
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 |