CN112256929A - Graph database-based electric power industry expansion method and system - Google Patents
Graph database-based electric power industry expansion method and system Download PDFInfo
- Publication number
- CN112256929A CN112256929A CN202011150324.5A CN202011150324A CN112256929A CN 112256929 A CN112256929 A CN 112256929A CN 202011150324 A CN202011150324 A CN 202011150324A CN 112256929 A CN112256929 A CN 112256929A
- Authority
- CN
- China
- Prior art keywords
- preset
- transformer
- work order
- graph database
- order 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000009434 installation Methods 0.000 claims abstract description 61
- 238000012216 screening Methods 0.000 claims abstract description 8
- 230000015654 memory Effects 0.000 claims description 38
- 230000003416 augmentation Effects 0.000 claims 3
- 238000004891 communication Methods 0.000 description 8
- 238000012545 processing Methods 0.000 description 6
- 238000011900 installation process Methods 0.000 description 5
- 238000011835 investigation Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000002243 precursor Substances 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9032—Query formulation
-
- 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Marketing (AREA)
- Software Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Mathematical Physics (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention discloses a graph database-based electric power industry expansion method and system, wherein the method comprises the following steps: acquiring power supply transformer information and power grid line information of a preset area, storing the information in a graph database, and acquiring work order data of business expansion installation applied by power users of the preset area; searching transformers meeting the work order data within a preset distance range according to the work order data to obtain a first preset transformer set; if the first preset transformer set is not an empty set, further screening to obtain a second preset transformer set, otherwise, increasing the numerical value of the preset distance, and updating until the first preset transformer set is not an empty set to obtain the second preset transformer set; when the second preset transformer set is not an empty set, the transformer meeting the preset condition is determined as the business expansion target transformer, otherwise, the numerical value of the preset distance is increased, and the first preset transformer set is updated.
Description
Technical Field
The invention relates to the technical field of power information, in particular to a graph database-based power industry expansion method and system.
Background
The electric energy is used as an important energy source closely related to the livelihood of people, and along with the increasing demand of people on the electric energy, for power supply enterprises, the quality of electric power business expansion work is an important guarantee for ensuring smooth and long-term power utilization of customers. At present, in the electric power industry expansion and installation process, the establishment and approval of the electric power industry expansion and installation scheme is the most time-consuming link and is the most critical part for restricting the current business efficiency. The current business expansion scheme is that a professional carries out investigation on site, the investigation time and the power supply scheme after the investigation are very long, and the construction progress of the whole business is greatly slowed down. However, the electric power industry expansion scheme is made by comprehensively considering and judging the data of the laying condition of the existing electric power line, the capacity of the transformer, geographic information and the like obtained by field investigation of an investigator and then making a scheme, and the problems that the processing and judging process of the topological relation between the line and equipment is complex and the query and analysis efficiency is low in the electric power industry expansion process exist.
Disclosure of Invention
Therefore, the graph database-based electric power industry expansion installation method and system provided by the invention overcome the defect of low query and analysis efficiency in the electric power industry expansion installation process in the prior art.
In order to achieve the purpose, the invention provides the following technical scheme:
in a first aspect, an embodiment of the present invention provides a graph database-based electric power industry expansion method, including:
step S1: acquiring and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database;
step S2: acquiring work order data of business expansion installation applied by the power users in the preset area;
step S3: searching transformers meeting the work order data in a preset distance range according to the work order data of business expansion installation applied by the power user to obtain a first preset transformer set, if the first preset transformer set is an empty set, turning to the step S4, and if not, turning to the step S5;
step S4: increasing the numerical value of the preset distance, further searching for transformers meeting the work order data, and updating a first preset transformer set;
step S5: screening out transformers with available capacity and voltage grade meeting the requirement of a user on work order data in the first preset transformer set to obtain a second preset transformer set, if the second preset transformer set is an empty set, increasing the numerical value of a preset distance, and turning to the step S3, otherwise, turning to the step S6;
step S6: and respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion installation target transformer.
In one embodiment, the supply transformer information includes: the number, name, voltage grade, total capacity, used capacity and longitude and latitude of the power supply transformer; the grid line information includes: the input and output wiring data of the transformer, the serial number of the line, the name of the line, the voltage grade of the line, the equipment before and after the line, the length of the line and the electric energy loss rate of the line.
In one embodiment, the work order data includes: the work order number, the application installation capacity, the voltage grade and the voltage installation address data.
In one embodiment, the preset conditions are: the distance between the transformer and the user installation address is shortest.
In an embodiment, the searching for a transformer meeting the work order data within a preset distance range according to the work order data of the power consumer applying for business expansion, to obtain a first preset transformer set includes:
according to the work order data of the electric power user application business expansion installation, the installation address of the user is used as the circle center, meanwhile, the preset distance is used as the radius, the transformers meeting the work order data are searched, and a first preset transformer set is obtained.
In one embodiment, the increasing of the preset distance in steps S4 and S5 is performed by a preset step.
In a second aspect, an embodiment of the present invention provides a graph database-based electric power industry expansion system, including:
the graph database acquisition module is used for acquiring and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database;
the work order data acquisition module is used for acquiring work order data of business expansion installation applied by the power users in the preset area;
the first preset transformer set generation module is used for searching transformers meeting work order data in a preset distance range according to the work order data of business expansion installation applied by power users to obtain a first preset transformer set, if the first preset transformer set is an empty set, switching to the first preset transformer set generation module, and otherwise, switching to the second preset transformer set generation module;
the first preset transformer set generation module is updated and used for increasing the numerical value of the preset distance, further searching for transformers meeting the work order data and updating the first preset transformer set;
the second preset transformer set generation module is used for screening out transformers with available capacity and voltage levels meeting the requirement of users on application work order data to obtain a second preset transformer set, increasing the numerical value of a preset distance if the second preset transformer set is an empty set, and switching to the first preset transformer set generation module, or switching to a business expansion target transformer determination module;
and the business expansion target transformer determining module is used for respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion target transformer.
In a third aspect, an embodiment of the present invention provides a terminal, including: the system comprises at least one processor and a memory communicatively connected with the at least one processor, wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to cause the at least one processor to execute the graph database-based electric power industry expansion method according to the first aspect of the embodiment of the invention.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, where computer instructions are stored, and the computer instructions are configured to cause the computer to execute the graph database-based electric power industry expansion method according to the first aspect of the embodiment of the present invention.
The technical scheme of the invention has the following advantages:
according to the graph database-based power industry expansion installation method and system, the topological connection relation of the power grid equipment is accurately described through graph data, the advantage that the graph database analyzes the topological relation of the power grid equipment is exerted, two times of dynamic search are carried out according to the setting of corresponding conditions, the transformer set meeting the conditions is screened out, and the transformer meeting the preset conditions is determined to be the industry expansion installation target transformer according to the distance between each transformer in the transformer set and a user installation address. According to the method, the graph database is searched in a dynamic circulation mode, so that the analysis of a large-scale power grid complex association network is facilitated, and the query analysis efficiency in the electric power industry expansion and installation process is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flowchart illustrating an exemplary embodiment of a graph-based electric power industry installation method according to the present invention;
FIG. 2 is a block diagram of a graph-based business reporting system according to an embodiment of the present invention;
fig. 3 is a block diagram of a specific example of a graph-database-based electric power industry expansion installation terminal according to an embodiment of the present invention.
Detailed Description
The technical solutions of the present invention will be described clearly and completely with reference to the accompanying drawings, and it should be understood that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; the two elements may be directly connected or indirectly connected through an intermediate medium, or may be communicated with each other inside the two elements, or may be wirelessly connected or wired connected. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
In addition, the technical features involved in the different embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.
Example 1
The embodiment of the invention provides a graph database-based electric power industry expansion method, as shown in fig. 1, comprising the following steps:
step S1: the method comprises the steps of obtaining and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database.
In the embodiment of the invention, a graph database is used as an efficient and rapid power topology analysis scheme, a topological graph is taken as a research object, a graph in graph theory is a topological graph formed by a plurality of given points and lines connecting the two points and is generally used for describing a given relation between certain objects, the points represent the objects, the lines connecting the two points represent that the two objects have the relation, a graph theory method and graph data processing are introduced to embody the grid networking characteristics to the maximum extent, the advantages of graph theory processing and topological relation analysis are exerted, and the query analysis efficiency is improved.
In the embodiment of the present invention, as shown in table 1, the power supply transformer information includes: the number, name, voltage grade, total capacity, used capacity and longitude and latitude of the power supply transformer; the grid line information includes: as shown in table 2, the data of the incoming and outgoing lines of the transformer, the serial number of the line, the name of the line, the voltage level of the line, the equipment behind the line precursor, the length of the line, and the power loss rate of the line. By way of example only, and not by way of limitation, in practical applications, corresponding information is obtained according to actual requirements.
TABLE 1
| Properties | Value of | Remarks for note |
| Node_id | Node id | Transformer number (not empty) |
| Node_name | Node name | Name of transformer |
| Voltage_transformer | Voltage class | Voltage class of transformer |
| Cap_total | Total capacity | Total capacity of transformer |
| Cap_used | Capacity of use | Used capacity of transformer |
| Longitude | Longitude (G) | Longitude of transformer position |
| Latitude | Latitude | Latitude of transformer location |
| Connect_line | Connecting wire | Line connected with transformer |
TABLE 2
| Properties | Value of | Remarks for note |
| Line_id | Edge id | Line number (not empty) |
| Line_name | Edge name | Line name |
| Voltage | Voltage class | Line voltage class |
| Pre_equip | Front-wheel drive equipment | Line-connected precursor device |
| Next_equip | Subsequent equipment | Subsequent equipment of line connection |
| Length | Length of | Length of the line |
| Loss_rate | Rate of loss | Rate of loss of line power |
Step S2: and acquiring the work order data of the business expansion installation applied by the power users in the preset area.
In the embodiment of the present invention, as shown in table 3, the work order data includes: the work order number, the application installation capacity, the voltage class and the voltage installation address data are only given as examples, but not limited to the examples, and corresponding information is acquired according to actual requirements in actual application.
TABLE 3
| Properties | Value of | Remarks for note |
| Order_id | Work order id | Worksheet number (not empty) |
| Cap_require | Application capacity | User's application installation capacity |
| Voltage_require | Voltage class | Line voltage class |
| Order_longitude | Longitude (G) | Longitude of the installation address |
| Order_latitude | Latitude | Latitude of installation address |
Step S3: and searching transformers meeting the work order data in a preset distance range according to the work order data of the business expansion installation applied by the power user to obtain a first preset transformer set, if the first preset transformer set is an empty set, switching to the step S4, and otherwise, switching to the step S5.
In the embodiment of the invention, the primary consideration factor of the transformer address selection is the distance, the distance between the transformer and the user address should be as close as possible, and according to the work order data of the power user applying for business expansion, the transformer meeting the work order data is searched by taking the installation address of the user as the center of a circle and the preset distance as the radius to obtain the first preset transformer set. Wherein, preset distance carries out corresponding setting according to actual demand, searches for the transformer that satisfies the work order data, satisfies the condition and can set up to the transformer at certain distance within range, for example: taking the installation address of the user as the circle center and the distance k (unit meter) as the radius, the distance calculation formula between the installation address applied by the user and the address of each transformer is as follows: (Order _ Longitude-Longitude, Order _ Latitude), searching all transformers in a range of k meters near the address, and searching all transformers meeting the condition that distance is less than or equal to k to obtain a first preset transformer set.
Step S4: and increasing the numerical value of the preset distance, further searching for the transformer meeting the work order data, and updating the first preset transformer set.
In the embodiment of the present invention, when the first preset transformer set is an empty set, increasing the value of the preset distance by a preset step length, searching for a transformer again, updating the first preset transformer set until the first preset transformer set is not an empty set, and then performing step S5, where the preset step length is correspondingly set according to an actual requirement, and no specific requirement is made here, for example: if the first preset transformer set is searched for being empty, the process proceeds to step S4, otherwise.
Step S5: screening out transformers with available capacity and voltage grade meeting the work order data of the user in the first preset transformer set to obtain a second preset transformer set, if the second preset transformer set is an empty set, increasing the numerical value of the preset distance, and turning to the step S3, otherwise, turning to the step S6.
In the embodiment of the present invention, transformers meeting the distance condition are further screened, when the available capacity and the voltage level of the first preset transformer set meet the transformer for the user applying the work order data, a second preset transformer set is obtained, if the second preset transformer set is an empty set, the value of the preset distance is increased, the step S3 is performed, the transformer meeting the distance condition is searched again, otherwise, the step S6 is performed, wherein the value of the preset distance is increased, the preset step length is increased, and the preset distance and the preset step length are correspondingly set according to the actual requirements, for example: screening out a first preset transformer set, and defining the result set: node _ search ═ Node _ id1, Node _ id2, Node _ id3,. and Node _ idn ], traversing a first preset transformer set, and calculating available transformer capacity Cap _ available [ Cap _ available1, Cap _ available2, Cap _ available3,. and Cap _ available n ] corresponding to all Node _ ids in the set; traversing all the Cap _ available which is corresponding to the Node _ id in the result set and is not less than Cap _ requirement, and storing the Transformer of Voltage _ Transformer which is corresponding to the Node _ id and is Voltage _ requirement into a second preset transformer set, if the result set is empty, increasing the k value by 100, returning to the step S3, searching the transformer again, otherwise, returning to the step S6, and defining the set as: node _ result [ [ Node _ ida, Node _ idb. .
Step S6: and respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion installation target transformer.
In the embodiment of the present invention, the preset conditions are: the distance between the transformer and the user installation address is shortest, and corresponding preset conditions are set according to actual requirements in practical application, for example: in the set Node _ result, the distance between the address of each Node _ id and the user installation address is calculated: and selecting the optimal access transformer of the business expansion and installation scheme as the business expansion and installation target transformer if the transformer corresponding to the Node _ id with the minimum Length _ install value is selected from the Length _ install, [ Length _ install1, Length _ install 2.
The graph database-based power industry expansion installation method provided by the embodiment of the invention has the advantages that the topological connection relation of power grid equipment is accurately described through graph data, the graph database is used for analyzing the topological relation of the power grid equipment, two dynamic searches are carried out according to the setting of corresponding conditions, a transformer set meeting the conditions is screened out, and the transformer meeting the preset conditions is determined as the industry expansion installation target transformer according to the distance between each transformer in the transformer set and a user installation address. According to the method, the graph database is searched in a dynamic circulation mode, so that the analysis of a large-scale power grid complex association network is facilitated, and the query analysis efficiency in the electric power industry expansion and installation process is improved.
Example 2
The embodiment of the invention provides a graph database-based electric power industry expansion system, as shown in fig. 2, comprising:
the graph database acquisition module 1 is used for acquiring and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database; this module executes the method described in step S1 in embodiment 1, and is not described herein again.
The work order data acquisition module 2 is used for acquiring work order data of business expansion installation applied by the power users in the preset area; this module executes the method described in step S2 in embodiment 1, and is not described herein again.
The first preset transformer set generation module 3 is used for searching transformers meeting work order data in a preset distance range according to the work order data of business expansion installation applied by the power user to obtain a first preset transformer set, if the first preset transformer set is an empty set, switching to the first preset transformer set generation module, and otherwise, switching to the second preset transformer set generation module; this module executes the method described in step S3 in embodiment 1, and is not described herein again.
Updating a first preset transformer set generation module 4, which is used for increasing the numerical value of the preset distance, further searching for transformers meeting the work order data, and updating a first preset transformer set; this module executes the method described in step S4 in embodiment 1, and is not described herein again.
The second preset transformer set generation module 5 is used for screening out transformers of which the available capacity and the voltage level in the first preset transformer set meet the requirement of a user on application work order data to obtain a second preset transformer set, increasing the numerical value of a preset distance if the second preset transformer set is an empty set, and switching to the first preset transformer set generation module, or switching to a business expansion target transformer determination module; this module executes the method described in step S5 in embodiment 1, and is not described herein again.
The business expansion target transformer determining module 6 is used for respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion target transformer; this module executes the method described in step S6 in embodiment 1, and is not described herein again.
The embodiment of the invention provides a graph database-based power industry expansion installation system, which accurately describes the topological connection relation of power grid equipment through graph data, exerts the advantage of analyzing the topological relation of the power grid equipment by using a graph database, carries out two times of dynamic search according to the setting of corresponding conditions, screens out a transformer set meeting the conditions, and determines the transformer meeting preset conditions as an industry expansion installation target transformer according to the distance between each transformer in the transformer set and a user installation address. According to the method, the graph database is searched in a dynamic circulation mode, so that the analysis of a large-scale power grid complex association network is facilitated, and the query analysis efficiency in the electric power industry expansion and installation process is improved.
Example 3
An embodiment of the present invention provides a terminal, as shown in fig. 3, including: at least one processor 401, such as a CPU (Central Processing Unit), at least one communication interface 403, memory 404, and at least one communication bus 402. Wherein a communication bus 402 is used to enable connective communication between these components. The communication interface 403 may include a Display (Display) and a Keyboard (Keyboard), and the optional communication interface 403 may also include a standard wired interface and a standard wireless interface. The Memory 404 may be a high-speed RAM Memory (Random Access Memory) or a non-volatile Memory (non-volatile Memory), such as at least one disk Memory. The memory 404 may optionally be at least one memory device located remotely from the processor 401. Wherein the processor 401 may execute the graph database-based electric power industry expansion method in embodiment 1. A set of program codes is stored in the memory 404, and the processor 401 calls the program codes stored in the memory 404 for executing the graph database-based electric power industry installation method in embodiment 1. The communication bus 402 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The communication bus 402 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one line is shown in FIG. 3, but this does not represent only one bus or one type of bus. The memory 404 may include a volatile memory (RAM), such as a random-access memory (RAM); the memory may also include a non-volatile memory (english: non-volatile memory), such as a flash memory (english: flash memory), a hard disk (english: hard disk drive, abbreviated: HDD) or a solid-state drive (english: SSD); the memory 404 may also comprise a combination of memories of the kind described above. The processor 401 may be a Central Processing Unit (CPU), a Network Processor (NP), or a combination of a CPU and an NP.
The memory 404 may include a volatile memory (RAM), such as a random-access memory (RAM); the memory may also include a non-volatile memory (english: non-volatile memory), such as a flash memory (english: flash memory), a hard disk (english: hard disk drive, abbreviated: HDD) or a solid-state drive (english: SSD); the memory 404 may also comprise a combination of memories of the kind described above.
The processor 401 may be a Central Processing Unit (CPU), a Network Processor (NP), or a combination of a CPU and an NP.
The processor 401 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a Programmable Logic Device (PLD), or a combination thereof. The PLD may be a Complex Programmable Logic Device (CPLD), a field-programmable gate array (FPGA), a General Array Logic (GAL), or any combination thereof.
Optionally, the memory 404 is also used to store program instructions. The processor 401 may call program instructions to implement the graph database-based electric power industry installation method according to embodiment 1.
The embodiment of the invention also provides a computer-readable storage medium, wherein computer-executable instructions are stored on the computer-readable storage medium and can execute the graph database-based electric power industry expansion installation method in the embodiment 1. The storage medium may be a magnetic Disk, an optical Disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a Flash Memory (Flash Memory), a Hard Disk (Hard Disk Drive, abbreviated as HDD), a Solid State Drive (SSD), or the like; the storage medium may also comprise a combination of memories of the kind described above.
It should be understood that the above examples are only for clarity of illustration and are not intended to limit the embodiments. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. And are neither required nor exhaustive of all embodiments. And obvious variations or modifications of the invention may be made without departing from the spirit or scope of the invention.
Claims (9)
1. A graph database-based electric power industry expansion method is characterized by comprising the following steps:
step S1: acquiring and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database;
step S2: acquiring work order data of business expansion installation applied by the power users in the preset area;
step S3: searching transformers meeting the work order data in a preset distance range according to the work order data of business expansion installation applied by the power user to obtain a first preset transformer set, if the first preset transformer set is an empty set, turning to the step S4, and if not, turning to the step S5;
step S4: increasing the numerical value of the preset distance, further searching for transformers meeting the work order data, and updating a first preset transformer set;
step S5: screening out transformers with available capacity and voltage grade meeting the requirement of a user on work order data in the first preset transformer set to obtain a second preset transformer set, if the second preset transformer set is an empty set, increasing the numerical value of a preset distance, and turning to the step S3, otherwise, turning to the step S6;
step S6: and respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion installation target transformer.
2. The graph database-based electric power industry augmentation method of claim 1, wherein the power supply transformer information comprises: the number, name, voltage grade, total capacity, used capacity and longitude and latitude of the power supply transformer; the grid line information includes: the input and output wiring data of the transformer, the serial number of the line, the name of the line, the voltage grade of the line, the equipment before and after the line, the length of the line and the electric energy loss rate of the line.
3. The graph database-based electric power industry augmentation method according to claim 1, wherein the work order data comprises: the work order number, the application installation capacity, the voltage grade and the voltage installation address data.
4. The graph database-based electric power industry expansion method according to claim 3, wherein the preset conditions are: the distance between the transformer and the user installation address is shortest.
5. The graph database-based electric power business expansion method according to claim 1, wherein the step of searching for transformers meeting work order data within a preset distance range according to the work order data of the electric power customer applying business expansion to obtain a first preset transformer set comprises:
according to the work order data of the electric power user application business expansion installation, the installation address of the user is used as the circle center, meanwhile, the preset distance is used as the radius, the transformers meeting the work order data are searched, and a first preset transformer set is obtained.
6. The graph database-based electric power industry expansion method according to claim 1, wherein the values of the increased preset distance in steps S4 and S5 are increased by a preset step length.
7. A graph database-based electric power industry expansion system, comprising:
the graph database acquisition module is used for acquiring and storing power supply transformer information and power grid line information of a preset area in a graph database, taking the power supply transformer information as node data in the graph database, and taking the power grid line information as line data in the graph database;
the work order data acquisition module is used for acquiring work order data of business expansion installation applied by the power users in the preset area;
the first preset transformer set generation module is used for searching transformers meeting work order data in a preset distance range according to the work order data of business expansion installation applied by power users to obtain a first preset transformer set, if the first preset transformer set is an empty set, switching to the first preset transformer set generation module, and otherwise, switching to the second preset transformer set generation module;
the first preset transformer set generation module is updated and used for increasing the numerical value of the preset distance, further searching for transformers meeting the work order data and updating the first preset transformer set;
the second preset transformer set generation module is used for screening out transformers with available capacity and voltage levels meeting the requirement of users on application work order data to obtain a second preset transformer set, increasing the numerical value of a preset distance if the second preset transformer set is an empty set, and switching to the first preset transformer set generation module, or switching to a business expansion target transformer determination module;
and the business expansion target transformer determining module is used for respectively calculating the distance between each transformer in the second preset transformer set and the user installation address, and determining the transformer meeting the preset conditions as the business expansion target transformer.
8. A terminal, comprising: at least one processor, and a memory communicatively coupled to the at least one processor, wherein the memory stores instructions executable by the at least one processor to cause the at least one processor to perform the graph database-based power industry augmentation method of any of claims 1-6.
9. A computer-readable storage medium storing computer instructions for causing a computer to perform the graph database-based electric power industry installation method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011150324.5A CN112256929A (en) | 2020-10-23 | 2020-10-23 | Graph database-based electric power industry expansion method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011150324.5A CN112256929A (en) | 2020-10-23 | 2020-10-23 | Graph database-based electric power industry expansion method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112256929A true CN112256929A (en) | 2021-01-22 |
Family
ID=74261967
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011150324.5A Pending CN112256929A (en) | 2020-10-23 | 2020-10-23 | Graph database-based electric power industry expansion method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112256929A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE29924799U1 (en) * | 1999-04-15 | 2006-01-19 | Moeller Gmbh | Planning and diagnosis device for electrical installation uses computer installation for subsequent execution of planning routine, configuration routine, setting up routine and diagnosis routine |
| CN102496068A (en) * | 2011-12-04 | 2012-06-13 | 江苏省电力公司南京供电公司 | Power supply scheme auxiliary generation method based on GIS (geographic information system) |
| CN104166942A (en) * | 2014-07-02 | 2014-11-26 | 国家电网公司 | Method and system for searching cross-regional power supply range based on CIM model |
| CN104463702A (en) * | 2014-12-05 | 2015-03-25 | 国家电网公司 | Implementation method and system of business expansion scheme based on power grid GIS framework |
| CN108090165A (en) * | 2017-12-13 | 2018-05-29 | 美林数据技术股份有限公司 | A kind of acquisition methods of the collection of illustrative plates variation based on embedded chart database |
| CN109408603A (en) * | 2018-09-05 | 2019-03-01 | 国网山东省电力公司济南供电公司 | A kind of platform area topology drawing drawing method based on big data |
| CN110941742A (en) * | 2019-11-04 | 2020-03-31 | 国网辽宁省电力有限公司葫芦岛供电公司 | Method for establishing marketing and distribution through data map |
| CN111049113A (en) * | 2020-01-03 | 2020-04-21 | 国网上海市电力公司 | 35KV power distribution network constant value self-adaptive setting method based on centralized master station architecture |
-
2020
- 2020-10-23 CN CN202011150324.5A patent/CN112256929A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE29924799U1 (en) * | 1999-04-15 | 2006-01-19 | Moeller Gmbh | Planning and diagnosis device for electrical installation uses computer installation for subsequent execution of planning routine, configuration routine, setting up routine and diagnosis routine |
| CN102496068A (en) * | 2011-12-04 | 2012-06-13 | 江苏省电力公司南京供电公司 | Power supply scheme auxiliary generation method based on GIS (geographic information system) |
| CN104166942A (en) * | 2014-07-02 | 2014-11-26 | 国家电网公司 | Method and system for searching cross-regional power supply range based on CIM model |
| CN104463702A (en) * | 2014-12-05 | 2015-03-25 | 国家电网公司 | Implementation method and system of business expansion scheme based on power grid GIS framework |
| CN108090165A (en) * | 2017-12-13 | 2018-05-29 | 美林数据技术股份有限公司 | A kind of acquisition methods of the collection of illustrative plates variation based on embedded chart database |
| CN109408603A (en) * | 2018-09-05 | 2019-03-01 | 国网山东省电力公司济南供电公司 | A kind of platform area topology drawing drawing method based on big data |
| CN110941742A (en) * | 2019-11-04 | 2020-03-31 | 国网辽宁省电力有限公司葫芦岛供电公司 | Method for establishing marketing and distribution through data map |
| CN111049113A (en) * | 2020-01-03 | 2020-04-21 | 国网上海市电力公司 | 35KV power distribution network constant value self-adaptive setting method based on centralized master station architecture |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022100233A1 (en) | Graph database-based power grid retrieval method and system | |
| CN110727741A (en) | Knowledge graph construction method and system of power system | |
| CN111325561B (en) | Intelligent complaint processing method and device, electronic equipment and storage medium | |
| CN113872204B (en) | Power load property determination method and device based on power grid diagram topological calculation | |
| US11822862B2 (en) | Techniques for generating one or more scores and/or one or more corrections for a digital twin representing a utility network | |
| CN111898221A (en) | Address selection method and device and computer readable storage medium | |
| CN113723810A (en) | Graph database-based power grid modeling method | |
| CN109634987A (en) | The querying method and device of power grid chart database | |
| CN111741427A (en) | Service complaint processing method, device and equipment | |
| CN111523777A (en) | Novel smart city system and application method thereof | |
| CN107146165B (en) | Distribution network planning data management method and system | |
| CN112256929A (en) | Graph database-based electric power industry expansion method and system | |
| CN110399534B (en) | Terminal performance report generation method, device, equipment and storage medium | |
| CN109739719B (en) | Communication machine room infrastructure management method and device | |
| KR20170061911A (en) | Method for constructing fused regression network and fused analysis system thereof | |
| CN109256774B (en) | Power grid subgraph division method and device based on voltage class | |
| US20220027770A1 (en) | Method, apparatus, device and storage medium for information processing | |
| CN113595750B (en) | Network topology dividing method and device and network topology management equipment | |
| CN105656029B (en) | A kind of super radius of electricity supply of low-voltage power supply taiwan area load point determines method and device | |
| WO2020135894A2 (en) | Method and device for establishing transmission line on/off switching combination scheme for limiting short circuit current | |
| CN110233796B (en) | Power communication network optimization method and equipment based on weighted routing algorithm | |
| CN114139621A (en) | Method, device, equipment and storage medium for determining model classification performance identification | |
| CN111461582A (en) | Power grid construction project scheme selection method, system and storage medium | |
| CN113761781B (en) | Distributed protection device model sharing method and device based on ant colony algorithm | |
| CN110889643A (en) | Paper quality evaluation method and system |
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 |