CN106980660B - Storage and generation method for 10KV line grid structure data - Google Patents

Abstract

The invention relates to a method for storing and generating grid structure data of a 10KV line, which specifically comprises the following steps: step S1: storing the grid structure data; step S2: instantiation of the space truss structure object; step S3: and checking the topological information of the grid structure. The invention fully considers the current situation of the current massive planning data and can improve the reading efficiency and the topology display efficiency of the data to a greater extent.

Description

Storage and generation method for 10KV line grid structure data

Technical Field

The invention relates to the technical field of power grid computers, in particular to a method for storing and generating grid structure data of a 10KV line.

Background

With the increasing investment of national grid companies on the construction of power distribution networks, the data volume related to power distribution network planning is larger and larger. With the increasing amount of data, it has not been possible to perform planning data statistics and analysis purely by human intervention. The storage and analysis of massive static data and dynamic operation data of the 10KV line grid structure are realized by a novel information technology storage and display means, and the method becomes an important method for the grid structure.

Disclosure of Invention

In view of this, the present invention provides a method for storing and generating data of a 10KV line grid structure, which fully considers the current situation of the current massive planning data and can improve the efficiency of reading data and displaying topology to a greater extent.

The invention is realized by adopting the following scheme: a method for storing and generating grid structure data of a 10KV line specifically comprises the following steps:

step S1: storing the grid structure data;

step S2: instantiation of the space truss structure object;

step S3: and checking the topological information of the grid structure.

Further, the step S1 specifically includes the following steps:

step S11: establishing a calling standard for graphic information in power grid planning by combining a service calling standard of a power grid GIS spatial information service platform according to a source of power grid network frame data; the power grid GIS is mainly a W3C Web Service framework, and realizes the sharing of Service resources through a release-discovery-access mechanism of the Service resources; the service is described by using a WSDL language, and information acquisition of graphic data of a planned power grid is realized according to a WSDL specification; and sending a GIS graph calling request through an interface request service, wherein the request mainly comprises information such as parameters, Token authorization and the like. GIS SERVICE, the user name and password are verified, if the verification is successful, a response that the request is valid is sent and the request object is returned.

Step S12: the data required by the grid structure is divided into two categories according to static data and dynamic data. The first is static data mainly based on equipment information, mainly including distribution transformer information, line information, column switch information, transformer information and the like, the updating frequency of the static data information is low, and the data reading quantity is small, so that the part of data is uniformly stored in a DataNode database of a single node, and the data reading is convenient. The second is dynamic data mainly based on the operation load, the frequency of data change and update of the second part is high, and the frequency of real-time data update reaches 15 minutes, 10 minutes, 1 minute and even second level; therefore, the data can be stored independently, and the reading performance of the data is improved to the maximum extent.

And S11, reading the relevant data of the network frame structure in the GIS service, storing the relevant data in a distributed database according to the classification of static data and dynamic data, establishing the distributed storage database, and establishing a database cluster frame based on hadoop. And according to the information, the cluster framework at least configures two servers. One of the servers is a NameNode server, and the other server is a DateNode server. The NameNode server manages the metadata information (including file name, size, position, etc.) of the file system file, maintains the corresponding relation between the file and the block and the corresponding relation between the block and the node, and maintains the operation information of the user on the file. The DataNode server is mainly used for storing actual static data and dynamic data. On the storage of static data, relevant hive services are configured in the DataNode server. After the interface request service obtains the topological data in the GIS, the temporary table information is read through the Sqoop assembly, and a corresponding related data structure is also established in the hive, so that the storage of the topological dynamic data and the static data of the grid structure is realized.

Furthermore, the implementation of the topological object in the application mainly comprises points, lines and the scene where the points, lines and scenes are located, and the three components form the environment where the topology exists. The above objects are instantiated, the processed objects have independent attributes, and the objects have restricted association relationship. After the topology data is obtained through the steps, the static data of the topology is instantiated, and the realization of the topology object is completed. The step S2 specifically includes the following steps:

step S21: establishing an instantiation object of the topology according to the attribute and the characteristic information of the topology entity object, and respectively performing instantiation of a point object, instantiation of a line object and instantiation of a scene;

step S22: the 10KV spatial grid structure topological object is presented through Flex front end and Java background application.

The instantiation of the point object is specifically as follows: an ImpNode interface is defined, and node information in the following topology inherits the interface. Wherein attributes NODEID (NODE ID), TOPOID (topology ID), NODENAME (NODE name), NODECOLOR (NODE color), NODECOLOR (NODE picture), NODESIZE (NODE size), nodex _ X (NODE X coordinate), nodex _ Y (NODE Y coordinate), RESOURCE _ ID (RESOURCE object type) included in the ImpNode; the Node realizes the ImpNode interface according to the characteristics of the object and inherits all the attributes of the ImpNode interface. If TRAN _10KV _ NODE is established according to 10KV distribution transformer, the TRAN _10KV _ NODE inherits all attributes in the ImpNode NODE, and the attributes of NPJFH (annual average load), PJFZL (annual average load rate), PBXH (distribution transformer model) and the like which are specific to the TRAN _10KV _ NODE are additionally reflected on the basis of the characteristic of the 10KV distribution transformer;

the instantiation of the line object is specifically as follows: an imhedge interface is also defined as above, and all the line information in the following topology inherits this interface. Attributes included in the imhedge include EDGEID (line ID), TOPOID (topology ID), FROMID (node start ID), TOID (node end ID), EDGELABEL (line tag name), COLOR (line COLOR); and the Edge realizes the ImpEdge interface according to the characteristics of the topological object and inherits all the attributes of the ImpEdge interface. If the Line _10KV _ Edge is established according to the 10KV Line, inheriting all the attributes of the ImpEdge; based on the characteristics of a 10KV Line, attributes such as XLZCD (total length of the Line), JKJYDXCD (length of an overhead insulated wire), JKLDXCD (length of an overhead insulated wire), DLCD (length of a cable) and the like which are specific to the 10KV Line need to be additionally embodied in Line _10KV _ Edge;

the instantiation of the scene specifically includes: an ImpContainer container interface is defined, which is inherited by all scenarios in the following topology. Wherein the attributes contained in the ImpContainer include WIDTH (WIDTH), HEIGHT (length), isnodemovedlindrag (whether to drag into a container), IsNodeMovedOutDrag (whether to drag out of a container by a node), conterminerbackgroupcolor (container background color), Title (container Title), ArrayNodes (point set array), and arrayedge (line set array); the application scene of 10KV line topology realizes an ImpContainer container interface. For example, according to the characteristics of a 10KV line and a distribution transformer, a 10KV network frame scene is established. According to the characteristics of the instantiation objects, the one-to-one correspondence of the corresponding points and the line logic relationship is realized through key feature IDs such as XLID and PBID.

Further, the step S22 specifically includes the following steps:

step S221: object initialization: the instantiated scene is realized through Flex front-end language, the instantiated 10KV distribution and transformation sets are integrated into a list, and distribution and transformation nodes are added into the list to drag and monitor events;

step S222: and executing the action: dragging and dragging out operations of the distribution transformer are completed by adding a dragging and monitoring event in the 10KV distribution transformer set and adding a monitoring event for dragging and entering the distribution transformer in the scene; after the dragging action is finished, the Flex splices the grid structure information into a data format required by the background interface. The method specifically comprises the following steps: and dragging in and dragging out operations of the distribution transformer are completed by adding dragging monitoring events addPbMoveInListener and addPbMoveOutListener into the 10KV distribution transformer set and adding a monitoring event addPbEnterInListener for the distribution transformer dragging in into the scene. When a change is dragged into the scene, the list listen event addPbMoveInListener removes the change from the list. Meanwhile, a monitoring event addPbEnterInListener in the scene receives the PBID of the current drag-and-drop configuration and stores the PBID in the ArrayNodes point set array. Based on the above processing of the association analysis of the topological objects, when the 10KV distribution transformer is dragged into a scene, the corresponding 10KV line is automatically taken out. Meanwhile, a monitoring event addXlEnterInListener in the scene receives a line XLID corresponding to the distribution transformer and stores the line XLID in an ArrayEdges line array. After the dragging action is finished, Flex splices the grid structure information into a data format required by a background interface, wherein the data format comprises coordinate values x and y of a dragged 10KV distribution transformer, ArrayEdges arrays, ArrayNodes arrays, PBID corresponding to 10KV lines and incidence relations among nodes.

Further, the step S3 specifically includes the following steps:

step S31: based on the grid structure topology information, controlling the current grid structure topology ID through a JavaScript page front-end scripting language, and transmitting the ID to the JAVA back end to obtain all elements under the current grid structure through the grid structure ID;

step S32: and after the acquisition of the corresponding element set is completed, returning the element set, transmitting the TopoId and the element set to a Flex front-end console through a remote object, and receiving the TopoId and executing corresponding spatial grid structure display by the Flex front-end console.

Particularly, the invention fully considers the massive static data and dynamic data of the grid structure, establishes a dynamic operation data storage mechanism in a hardoop cluster mode and realizes the rapid improvement of data reading performance. Meanwhile, the invention establishes the interface specification in the 10KV line network frame, and realizes the entity establishment of different lines, distribution transformers and scenes by inheriting the specification attribute of the network frame structure based on the object-oriented thought according to different characteristics of the lines. Moreover, the invention is based on the characteristics of Flex language, can flexibly deploy and operate in each browser for the flash file after being compiled, and has excellent compatibility. The quick presentation and flexible editing of the net rack topology are realized through the communication of JAVA language and FLEX language.

Compared with the prior art, the invention has the following beneficial effects: the invention makes full use of the characteristics of a network frame structure in a 10KV line, innovatively introduces a storage mode based on a Hardoop cluster, and greatly improves the data storage and read-write efficiency in the aspect of big data compared with the original storage technology; and through an object-oriented idea, the establishment of the entity object in the grid structure is realized, and finally, a 10KV line grid structure topology is generated. On the basis, functions such as editing and dragging of the grid structure are further realized through personalized configuration, and the use flexibility is improved.

Drawings

FIG. 1 is a schematic diagram of the method in an embodiment of the invention.

Fig. 2 is a diagram illustrating GIS service invocation specification in an embodiment of the present invention.

Fig. 3 is a schematic diagram illustrating storage of topology dynamic data and static data of a grid structure according to an embodiment of the present invention.

Fig. 4 is a schematic diagram of an instantiated object for establishing a topology according to the attribute and characteristic information of a topology entity object in the embodiment of the present invention.

Detailed Description

The invention is further explained below with reference to the drawings and the embodiments.

As shown in fig. 1, the present embodiment provides a method for storing and generating 10KV line grid structure data, which specifically includes the following steps:

step S1: storing the grid structure data;

step S2: instantiation of the space truss structure object;

step S3: and checking the topological information of the grid structure.

In this embodiment, the step S1 specifically includes the following steps:

step S11: establishing a calling standard for graphic information in power grid planning by combining a service calling standard of a power grid GIS spatial information service platform according to a source of power grid network frame data; the power grid GIS is mainly a W3C Web Service framework, and realizes the sharing of Service resources through a release-discovery-access mechanism of the Service resources; the service is described by using a WSDL language, and information acquisition of graphic data of a planned power grid is realized according to a WSDL specification; as shown in fig. 2, the GIS graph call request is sent through the interface request service, and the request mainly includes information such as parameters and Token authorization. GIS SERVICE, the user name and password are verified, if the verification is successful, a response that the request is valid is sent and the request object is returned.

Step S12: the data required by the grid structure is divided into two categories according to static data and dynamic data. The first is static data mainly based on equipment information, mainly including distribution transformer information, line information, column switch information, transformer information and the like, the updating frequency of the static data information is low, and the data reading quantity is small, so that the part of data is uniformly stored in a DataNode database of a single node, and the data reading is convenient. The second is dynamic data mainly based on the operation load, the frequency of data change and update of the second part is high, and the frequency of real-time data update reaches 15 minutes, 10 minutes, 1 minute and even second level; therefore, the data can be stored independently, and the reading performance of the data is improved to the maximum extent.

And S11, reading the relevant data of the network frame structure in the GIS service, storing the relevant data in a distributed database according to the classification of static data and dynamic data, establishing the distributed storage database, and establishing a database cluster frame based on hadoop. And according to the information, the cluster framework at least configures two servers. One of the servers is a NameNode server, and the other server is a DateNode server. The NameNode server manages the metadata information (including file name, size, position, etc.) of the file system file, maintains the corresponding relation between the file and the block and the corresponding relation between the block and the node, and maintains the operation information of the user on the file. The DataNode server is mainly used for storing actual static data and dynamic data. On the storage of static data, relevant hive services are configured in the DataNode server. As shown in fig. 3, after the interface request service obtains the topology data in the GIS, the temporary table information is read through the Sqoop component, and a corresponding related data structure is also established in the hive, so that the storage of the topology dynamic data and the static data of the grid structure is realized.

In this embodiment, the representation of the topology object in the application mainly includes a point, a line and a scene where the point, the line and the scene are located, and the three components form an environment where the topology exists. The above objects are instantiated, the processed objects have independent attributes, and the objects have restricted association relationship. After the topology data is obtained through the above steps, the static data of the topology is instantiated to complete the implementation of the topology object, as shown in fig. 4. The step S2 specifically includes the following steps:

step S21: establishing an instantiation object of the topology according to the attribute and the characteristic information of the topology entity object, and respectively performing instantiation of a point object, instantiation of a line object and instantiation of a scene;

step S22: the 10KV spatial grid structure topological object is presented through Flex front end and Java background application.

The instantiation of the point object is specifically as follows: an ImpNode interface is defined, and node information in the following topology inherits the interface. Wherein attributes NODEID (NODE ID), TOPOID (topology ID), NODENAME (NODE name), NODECOLOR (NODE color), NODECOLOR (NODE picture), NODESIZE (NODE size), nodex _ X (NODE X coordinate), nodex _ Y (NODE Y coordinate), RESOURCE _ ID (RESOURCE object type) included in the ImpNode; the Node realizes the ImpNode interface according to the characteristics of the object and inherits all the attributes of the ImpNode interface. If TRAN _10KV _ NODE is established according to 10KV distribution transformer, the TRAN _10KV _ NODE inherits all attributes in the ImpNode NODE, and the attributes of NPJFH (annual average load), PJFZL (annual average load rate), PBXH (distribution transformer model) and the like which are specific to the TRAN _10KV _ NODE are additionally reflected on the basis of the characteristic of the 10KV distribution transformer;

the instantiation of the line object is specifically as follows: an imhedge interface is also defined as above, and all the line information in the following topology inherits this interface. Attributes included in the imhedge include EDGEID (line ID), TOPOID (topology ID), FROMID (node start ID), TOID (node end ID), EDGELABEL (line tag name), COLOR (line COLOR); and the Edge realizes the ImpEdge interface according to the characteristics of the topological object and inherits all the attributes of the ImpEdge interface. If the Line _10KV _ Edge is established according to the 10KV Line, inheriting all the attributes of the ImpEdge; based on the characteristics of a 10KV Line, attributes such as XLZCD (total length of the Line), JKJYDXCD (length of an overhead insulated wire), JKLDXCD (length of an overhead insulated wire), DLCD (length of a cable) and the like which are specific to the 10KV Line need to be additionally embodied in Line _10KV _ Edge;

the instantiation of the scene specifically includes: an ImpContainer container interface is defined, which is inherited by all scenarios in the following topology. Wherein the attributes contained in the ImpContainer include WIDTH (WIDTH), HEIGHT (length), isnodemovedlindrag (whether to drag into a container), IsNodeMovedOutDrag (whether to drag out of a container by a node), conterminerbackgroupcolor (container background color), Title (container Title), ArrayNodes (point set array), and arrayedge (line set array); the application scene of 10KV line topology realizes an ImpContainer container interface. For example, according to the characteristics of a 10KV line and a distribution transformer, a 10KV network frame scene is established. According to the characteristics of the instantiation objects, the one-to-one correspondence of the corresponding points and the line logic relationship is realized through key feature IDs such as XLID and PBID.

In this embodiment, the step S22 specifically includes the following steps:

step S221: object initialization: the instantiated scene is realized through Flex front-end language, the instantiated 10KV distribution and transformation sets are integrated into a list, and distribution and transformation nodes are added into the list to drag and monitor events;

step S222: and executing the action: dragging and dragging out operations of the distribution transformer are completed by adding a dragging and monitoring event in the 10KV distribution transformer set and adding a monitoring event for dragging and entering the distribution transformer in the scene; after the dragging action is finished, the Flex splices the grid structure information into a data format required by the background interface. The method specifically comprises the following steps: and dragging in and dragging out operations of the distribution transformer are completed by adding dragging monitoring events addPbMoveInListener and addPbMoveOutListener into the 10KV distribution transformer set and adding a monitoring event addPbEnterInListener for the distribution transformer dragging in into the scene. When a change is dragged into the scene, the list listen event addPbMoveInListener removes the change from the list. Meanwhile, a monitoring event addPbEnterInListener in the scene receives the PBID of the current drag-and-drop configuration and stores the PBID in the ArrayNodes point set array. Based on the above processing of the association analysis of the topological objects, when the 10KV distribution transformer is dragged into a scene, the corresponding 10KV line is automatically taken out. Meanwhile, a monitoring event addXlEnterInListener in the scene receives a line XLID corresponding to the distribution transformer and stores the line XLID in an ArrayEdges line array. After the dragging action is finished, Flex splices the grid structure information into a data format required by a background interface, wherein the data format comprises coordinate values x and y of a dragged 10KV distribution transformer, ArrayEdges arrays, ArrayNodes arrays, PBID corresponding to 10KV lines and incidence relations among nodes.

In this embodiment, the step S3 specifically includes the following steps:

step S31: based on the grid structure topology information, controlling the current grid structure topology ID through a JavaScript page front-end scripting language, and transmitting the ID to the JAVA back end to obtain all elements under the current grid structure through the grid structure ID;

step S32: and after the acquisition of the corresponding element set is completed, returning the element set, transmitting the TopoId and the element set to a Flex front-end console through a remote object, and receiving the TopoId and executing corresponding spatial grid structure display by the Flex front-end console.

Particularly, the invention fully considers the massive static data and dynamic data of the grid structure, establishes a dynamic operation data storage mechanism in a hardoop cluster mode and realizes the rapid improvement of data reading performance. Meanwhile, the invention establishes the interface specification in the 10KV line network frame, and realizes the entity establishment of different lines, distribution transformers and scenes by inheriting the specification attribute of the network frame structure based on the object-oriented thought according to different characteristics of the lines. Moreover, the invention is based on the characteristics of Flex language, can flexibly deploy and operate in each browser for the flash file after being compiled, and has excellent compatibility. The quick presentation and flexible editing of the net rack topology are realized through the communication of JAVA language and FLEX language.

The above description is only a preferred embodiment of the present invention, and all equivalent changes and modifications made in accordance with the claims of the present invention should be covered by the present invention.

Claims (1)

1. A storage and generation method for 10KV line grid structure data is characterized in that: the method comprises the following steps:

step S1: storing the grid structure data;

step S2: instantiation of the space truss structure object;

step S3: looking up the topological information of the grid structure;

wherein, the step S1 specifically includes the following steps:

step S11: establishing a calling standard for graphic information in power grid planning by combining a service calling standard of a power grid GIS spatial information service platform according to a source of power grid network frame data; the power grid GIS is mainly a W3C Web Service framework, and realizes the sharing of Service resources through a release-discovery-access mechanism of the Service resources; the service is described by using a WSDL language, and information acquisition of graphic data of a planned power grid is realized according to a WSDL specification;

step S12: reading the relevant data of the network frame structure in the GIS service through the step S11, storing the relevant data in a distributed database in a classified manner according to static data and dynamic data, establishing the distributed storage database, and realizing the construction of a database cluster frame based on hadoop;

wherein, the step S2 specifically includes the following steps:

step S21: establishing an instantiation object of the topology according to the attribute and the characteristic information of the topology entity object, and respectively performing instantiation of a point object, instantiation of a line object and instantiation of a scene;

step S22: the 10KV spatial grid structure topological object is presented through Flex front end and Java background application;

wherein, the step S22 specifically includes the following steps:

step S221: object initialization: the instantiated scene is realized through Flex front-end language, the instantiated 10KV distribution and transformation sets are integrated into a list, and distribution and transformation nodes are added into the list to drag and monitor events;

step S222: and executing the action: dragging and dragging out operations of the distribution transformer are completed by adding a dragging and monitoring event in the 10KV distribution transformer set and adding a monitoring event for dragging and entering the distribution transformer in the scene; after the dragging action is finished, assembling the grid structure information into a data format required by a background interface by Flex;

the instantiation of the point object is specifically as follows: defining an ImpNode interface, wherein the node information in the following topology inherits the interface; wherein the attributes included in ImpNode include: node ID, topological graph ID, node name, node color, node picture, node size, node X coordinate, node Y coordinate and resource object type; the Node realizes the ImpNode interface according to the characteristics of the object and inherits all the attributes of the ImpNode interface; establishing TRAN _10KV _ NODE according to the 10KV distribution transformer, inheriting all attributes in the ImpNode NODE, and based on the characteristics of the 10KV distribution transformer, the specific attributes comprise: the specific attributes are embodied in TRAN _10KV _ NODE;

the instantiation of the line object is specifically as follows: defining an ImpEdge interface, wherein all line information in the following topology inherits the interface; wherein the attributes included in imhedge are: line ID, topological graph ID, node start ID, node end ID, line label name, line color; the Edge realizes an ImpEdge interface according to the characteristics of the topological object and inherits all the attributes of the ImpEdge interface; establishing a Line _10KV _ Edge according to the 10KV Line, wherein the Line _10KV _ Edge inherits all attributes of the ImpEdge; based on the characteristics of a 10KV line, the special attributes of the cable are as follows: the specific attributes of the total Line length, the length of the overhead insulated conductor and the length of the cable need to be additionally embodied in Line _10KV _ Edge;

the instantiation of the scene specifically includes: defining an ImpContainer container interface, wherein all scenes in the following topology inherit the interface; the attributes contained in the ImpContainer comprise width, length, whether to drag the container, whether to drag the node out of the container, container background color, container title, point set array and line set array; realizing an impContainer container interface in a 10KV line topology application scene; establishing a 10KV network frame scene according to the characteristics of the 10KV line and the distribution transformer;

wherein, the step S3 specifically includes the following steps:

step S31: based on the grid structure topology information, controlling the current grid structure topology ID through a JavaScript page front-end scripting language, and transmitting the ID to the JAVA back end to obtain all elements under the current grid structure through the grid structure ID;

step S32: and after the acquisition of the corresponding element set is completed, returning the element set, transmitting the TopoId and the element set to a Flex front-end console through a remote object, and receiving the TopoId and executing corresponding spatial grid structure display by the Flex front-end console.

Images