Electricity marketing customer relationship construction method and system based on graph database
By using graph database technology in power customer management to build business and logical graph models, the problem of inefficient traditional power customer management is solved, and efficient customer relationship processing and data analysis are achieved.
Patent Information
- Application Number
- CN202410851975.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-06-28
- Publication Date
- 2024-11-08
AI Technical Summary
The traditional power customer management method is inefficient when dealing with complex customer relationships, user behaviors and power demand relationships, and cannot effectively perform complex queries and large number of concurrent operations, making it difficult to intuitively understand and analyze data.
Using a graph database-based method, we use collecting and cleaning power consumption data, building a business graph model and a logical graph model, building a graph database, and analyzing customer relationships using graph analysis algorithms, and using Neo4J graph database and kettle tools for data synchronization and display.
It improves the efficiency and accuracy of the power customer relationship architecture, can efficiently handle complex customer relationships and concurrent operations, and realizes intuitive data analysis and display.
Smart Images

Figure CN118917867A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of power customer management, and in particular to a method and system for establishing power marketing customer relationships based on a graph database. Background Art
[0002] Traditional electricity customer management methods mostly rely on flat database systems for customer management. For example, the invention with publication number CN117573888A discloses a digital operation and maintenance method for a power supply station based on a data middle platform, including the following steps: Step S1: Based on the data middle platform, a real-time database and a historical database of the power supply station are constructed, which are respectively used to store real-time collected data and historical data of the power supply station; Step S2: Based on the historical database of the power supply station, data association is performed to form a topological map of the relationship between lines, substations and users, and further a knowledge graph of the power supply station is constructed; Step S3: Based on the knowledge graph analysis of the power supply station, a power consumption model is constructed; Step S4: Real-time database data is obtained, and based on the power consumption model, the user's power consumption is analyzed; Step S5: Based on the analysis results, whether there is an abnormal situation, and corresponding processing measures are taken according to the abnormal situation.
[0003] However, this approach is inefficient when dealing with complex customer relationships, user behaviors, and power demand relationships. It cannot effectively execute complex queries and a large number of concurrent operations, and it is difficult to intuitively understand and analyze data. Summary of the invention
[0004] The purpose of the present invention is to provide a method and system for building customer relationships in power marketing based on a graph database in order to overcome the defects of the above-mentioned prior art in that it is inefficient in processing complex customer relationships, user behaviors and power demand relationships, and cannot effectively execute complex queries and a large number of concurrent operations.
[0005] The purpose of the present invention can be achieved by the following technical solutions:
[0006] A method for establishing customer relationships in power marketing based on a graph database comprises the following steps:
[0007] S1: Collect user electricity consumption data, which includes electricity customer profile data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information;
[0008] S2: Clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, and filling missing values;
[0009] S3: Perform data modeling based on the cleaned data to construct a business graph model and a logic graph model, where graph nodes in the business graph model and the logic graph model represent customers, and graph edges represent relationships between customers;
[0010] S4: Build a graph database based on the business graph model and the logical graph model;
[0011] S5: collect heterogeneous data regularly through steps S1-S3, and import it into the graph database to synchronize the data;
[0012] S6: Use graph analysis algorithms to analyze customer relationships in the graph database and present them graphically.
[0013] Furthermore, the electricity customer profile data includes: account number, account name, electricity usage address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; the electricity usage behavior data includes access point, substation, metering point, line and transformer information.
[0014] Furthermore, a power marketing collection system is used to collect the user's power consumption data.
[0015] Furthermore, the graph database is a Neo4J graph database.
[0016] Furthermore, the collected heterogeneous data is imported into the graph database through the kettle tool.
[0017] The present invention also provides a power marketing customer relationship building system based on a graph database, comprising:
[0018] The electricity consumption data collection module is used to collect user electricity consumption data, which includes electricity customer file data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information;
[0019] The data cleaning module is used to clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, and filling missing values;
[0020] A graph data modeling module, which is used to perform data modeling based on the cleaned data, and to construct a business graph model and a logical graph model, wherein the graph nodes in the business graph model and the logical graph model represent customers, and the graph edges represent the relationship between customers;
[0021] Graph database building module, used to build graph database according to business graph model and logical graph model;
[0022] A graph database synchronization module, used to collect heterogeneous data and import it into the graph database for data synchronization;
[0023] The graphic display module is used to analyze customer relationships in the graph database using graph analysis algorithms and display them graphically.
[0024] Furthermore, the electricity customer profile data includes: account number, account name, electricity usage address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; the electricity usage behavior data includes access point, substation, metering point, line and transformer information.
[0025] Furthermore, the electricity consumption data collection module uses an electric power marketing collection system to collect the user's electricity consumption data.
[0026] Furthermore, the graph database is a Neo4J graph database.
[0027] Furthermore, the collected heterogeneous data is imported into the graph database through the kettle tool.
[0028] Compared with the prior art, the present invention has the following advantages:
[0029] (1) The present invention uses a flat database system to manage electricity customers. However, the system is inefficient in processing complex customer relationships, user behaviors, and electricity demand relationships, cannot effectively execute complex queries and a large number of concurrent operations, and is difficult to intuitively understand and analyze data. The present invention innovatively proposes the use of a graph database to manage and analyze electricity customer data. The graph database can handle and construct complex customer relationships in electricity customer data, and implement high-load query calculations, thereby effectively conducting electricity marketing and customer management.
[0030] (2) The present invention can effectively improve the efficiency and accuracy of the power customer relationship architecture by collecting and cleaning electricity consumption data and constructing a graph database to express customer relationships. BRIEF DESCRIPTION OF THE DRAWINGS
[0031] Figure 1 A flowchart of a method for establishing customer relationships in power marketing based on a graph database provided in an embodiment of the present invention. DETAILED DESCRIPTION
[0032] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Generally, the components of the embodiments of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.
[0033] Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the invention claimed for protection, but merely represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0034] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.
[0035] Example 1
[0036] like Figure 1 As shown, this embodiment provides a method for establishing customer relationships in power marketing based on a graph database, comprising the following steps:
[0037] S1: Collect user electricity consumption data, which includes electricity customer profile data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information;
[0038] The electricity customer profile data includes: household number, household name, electricity address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; the electricity usage behavior data includes access point, substation, metering point, line and transformer information, specifically including substation capacity, access point latitude and longitude, line name, transformer capacity and other information;
[0039] S2: Clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, filling missing values, verifying business logic, etc.
[0040] S3: Perform data modeling based on the cleaned data to build a business graph model and a logical graph model. The graph nodes in the business graph model and the logical graph model represent customers, and the graph edges represent the relationship between customers.
[0041] S4: Build a graph database based on the business graph model and the logical graph model;
[0042] Specifically, you can deploy the Neo4J graph database and optimize JVM performance;
[0043] S5: collect heterogeneous data regularly through steps S1-S3, import it into the graph database, and perform data synchronization;
[0044] Optionally, use the kettle tool to import the collected heterogeneous data into the graph database;
[0045] That is, using the kettle tool, the heterogeneous marketing database model and power distribution database model are constructed into a graph data model and imported into the graph database;
[0046] S6: Use graph analysis algorithms to analyze customer relationships in the graph database and display them graphically;
[0047] That is, use graph analysis algorithms to analyze customer relationships and display them by category.
[0048] Graph Database is a new type of NoSQL database based on graph theory. Its data storage structure and data query method are based on graph theory. In a graph database, data is stored and queried in a graph structure, where nodes represent entities and edges represent relationships between entities. This data structure enables graph databases to efficiently process complex relational operations and have excellent storage, query and analysis capabilities for highly interconnected data.
[0049] The main features of graph databases include:
[0050] Intuitiveness: Graph databases intuitively display the relationships between data in the form of graphs, making relationship queries and visualization simpler and more direct.
[0051] Efficiency: Since the relationships between entities have been stored in the database in advance, graph databases can quickly respond to complex association queries, avoiding the tedious process of large numbers of recursive queries and multi-table joint queries.
[0052] Flexibility: Graph databases support massive, complex, and flexibly structured relational operations and are suitable for processing unstructured or semi-structured data.
[0053] Graph databases have a wide range of application scenarios, including social fields (such as managing social relationships, finding mutual friends, friend recommendations, etc.), retail fields (such as product recommendations), security fields (such as risk assessment), etc. In addition, graph databases can also handle data processing tasks of more than 100 million, meeting the needs of large-scale data storage and query.
[0054] The above is an introduction to the method embodiment. The following is a further explanation of the solution of the present invention through a system embodiment.
[0055] This embodiment also relates to a power marketing customer relationship building system based on a graph database, including:
[0056] The electricity consumption data collection module is used to collect user electricity consumption data, which includes electricity customer file data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information;
[0057] The data cleaning module is used to clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, and filling missing values;
[0058] The graph data modeling module is used to perform data modeling based on the cleaned data and build a business graph model and a logical graph model. The graph nodes in the business graph model and the logical graph model represent customers, and the graph edges represent the relationship between customers.
[0059] Graph database building module, used to build graph database according to business graph model and logical graph model;
[0060] The graph database synchronization module is used to collect heterogeneous data and import it into the graph database for data synchronization;
[0061] The graphic display module is used to analyze customer relationships in the graph database using graph analysis algorithms and display them graphically.
[0062] Optionally, the electricity customer profile data includes: account number, account name, electricity usage address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; electricity usage behavior data includes access point, substation, metering point, line and transformer information.
[0063] Optionally, the electricity consumption data collection module uses a power marketing collection system to collect user electricity consumption data.
[0064] Optionally, the graph database is a Neo4J graph database.
[0065] Optionally, use the kettle tool to import the collected heterogeneous data into the graph database.
[0066] It should be noted that the specific content and beneficial effects of the device of the present application can be found in the above-mentioned method embodiment, which will not be repeated here.
[0067] The functions described in each module herein can be implemented by program code, which can be written in any combination of one or more programming languages. These program codes can be provided to a processor or controller of a general-purpose computer, a special-purpose computer or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code can be executed entirely on the machine, partially on the machine, partially on the machine as an independent software package and partially on a remote machine or completely on a remote machine or server.
[0068] The preferred specific embodiments of the present invention are described in detail above. It should be understood that a person skilled in the art can make many modifications and changes based on the concept of the present invention without creative work. Therefore, any technical solution that can be obtained by a person skilled in the art through logical analysis, reasoning or limited experiments based on the concept of the present invention on the basis of the prior art should be within the scope of protection determined by the claims.
Claims
1. A method for building customer relationships in power marketing based on a graph database, characterized in that: The following steps are involved: S1: Collect user electricity consumption data, which includes electricity customer profile data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information; S2: Clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, and filling missing values; S3: Perform data modeling based on the cleaned data to construct a business graph model and a logic graph model, where graph nodes in the business graph model and the logic graph model represent customers, and graph edges represent relationships between customers; S4: Build a graph database based on the business graph model and the logical graph model; S5: collect heterogeneous data regularly through steps S1-S3, and import it into the graph database to synchronize the data; S6: Use graph analysis algorithms to analyze customer relationships in the graph database and present them graphically.
2. According to claim 1, a method for establishing customer relationships in power marketing based on a graph database is characterized in that: The electricity customer profile data includes: account number, account name, electricity usage address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; the electricity usage behavior data includes access point, substation, metering point, line and transformer information.
3. The method for establishing customer relationships in power marketing based on a graph database according to claim 1, characterized in that: The power marketing collection system is used to collect the user's power consumption data.
4. The method for establishing customer relationships in power marketing based on a graph database according to claim 1, characterized in that: The graph database is a Neo4J graph database.
5. The method for establishing customer relationships in power marketing based on a graph database according to claim 1, characterized in that: The collected heterogeneous data is imported into the graph database through the kettle tool.
6. A power marketing customer relationship building system based on graph database, characterized in that: include: The electricity consumption data collection module is used to collect user electricity consumption data, which includes electricity customer file data, electricity customer metering data, electricity consumption behavior data and electricity customer electricity service information; The data cleaning module is used to clean the collected user electricity consumption data. The cleaning process includes removing duplicate data, removing abnormal data, and filling missing values; A graph data modeling module, which is used to perform data modeling based on the cleaned data, and to construct a business graph model and a logical graph model, wherein the graph nodes in the business graph model and the logical graph model represent customers, and the graph edges represent the relationship between customers; Graph database building module, used to build graph database according to business graph model and logical graph model; A graph database synchronization module, used to collect heterogeneous data and import it into the graph database for data synchronization; The graphic display module is used to analyze customer relationships in the graph database using graph analysis algorithms and display them graphically.
7. The power marketing customer relationship building system based on graph database according to claim 6 is characterized in that: The electricity customer profile data includes: account number, account name, electricity usage address, industry classification, customer type and voltage level; the electricity customer metering data includes meter information, which includes meter ID, manufacturer, wiring method, installation address and factory number; the electricity usage behavior data includes access point, substation, metering point, line and transformer information.
8. The power marketing customer relationship building system based on graph database according to claim 7 is characterized in that: The electricity consumption data collection module uses an electric power marketing collection system to collect the user's electricity consumption data.
9. The power marketing customer relationship building system based on graph database according to claim 7 is characterized in that: The graph database is a Neo4J graph database.
10. The system for establishing a power marketing customer relationship based on a graph database according to claim 7, characterized in that: The collected heterogeneous data is imported into the graph database through the kettle tool.
Citation Information
Cited By
Intelligent construction method for power customer relation graph based on multi-source data fusion
CN121502015A
