Graph database-based terminal wiring visualization method and system

Abstract

The invention relates to the technical field of hydropower station equipment visualization management, in particular to a terminal wiring visualization method and system based on a graph database, and the method comprises the steps: building a terminal wiring diagram data model based on historical cable relation data of a hydropower station, and the carrier of the terminal wiring diagram data model is a Neo4j database; historical cable relation data of the hydropower station is converted into graph data from table data, the graph data are imported into a neo4j database in batches, and a back-end service framework and a front-end page are constructed respectively; the front-end page sends a request to the back-end service framework based on an input user operation instruction, the back-end service framework executes analysis on the user operation instruction, updates and converts an execution result through a terminal wiring diagram data model, and inputs the execution result to the front-end page to execute visual interaction; and visual accurate management of the wiring state of the hydropower station equipment is completed.

Description

Technical Field

[0001] The present invention relates to the technical field of visualized management of hydropower station equipment, and in particular to a terminal wiring visualization method and system based on a graph database. Background Art

[0002] Equipment wiring management in hydropower stations is a key link to ensure safe and efficient operation of power stations. At present, traditional wiring status records mainly rely on paper drawings or spreadsheets, which have many limitations. First, the update and maintenance of paper drawings takes a lot of time and manpower, is prone to errors, and is difficult to adapt to the rapidly changing equipment status. Secondly, although spreadsheets have improved the efficiency of data management to a certain extent, their query efficiency and visualization are still limited when dealing with large-scale data and complex wiring relationships. With the increase in the scale and complexity of hydropower stations, the wiring relationship of equipment is becoming increasingly complex. The traditional wiring status recording method can no longer meet the needs of modern hydropower stations, especially in large-scale power systems. The traditional recording method can no longer meet its real-time, accuracy and visualization requirements. Based on this, in response to the above problems, we designed a terminal wiring visualization method and system based on a graph database. Summary of the invention

[0003] The purpose of the present invention is to provide a terminal wiring visualization method and system based on a graph database, which uses the Neo4j graph database to build a terminal wiring diagram data model, converts historical cable relationship data into a graph data structure, and realizes the visualization and precise management of the equipment wiring status through a front-end and back-end separated architecture. The design based on the present invention can provide hydropower station managers with an intuitive and efficient equipment wiring status query and analysis tool, greatly improving management efficiency and decision-making quality.

[0004] The present invention is achieved through the following technical solutions:

[0005] A terminal wiring visualization method based on a graph database, the method comprising the following steps:

[0006] Construct a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the carrier of the terminal wiring diagram data model is a neo4j database;

[0007] Convert the historical cable relationship data of the hydropower station from table data to graph data, and import them into the neo4j database in batches, and build the backend service framework and front-end page respectively;

[0008] The front-end page sends a request to the back-end service framework based on the input user operation instructions. The back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

[0009] Optionally, the terminal wiring diagram data model is established by:

[0010] Obtain historical cable relationship data of hydropower stations;

[0011] Identify the key entities of the hydropower station, create node types based on the key entities of the hydropower station, and define labels for each node type;

[0012] Analyze the connection relationships between key entities of the hydropower station, define the relationship type for each connection, create mapping rules from tabular data to graphical structure, draw a conceptual diagram of nodes and connection relationships, and complete the construction of the terminal wiring diagram data model.

[0013] Optionally, the neo4j database has a composition structure including: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, an interaction and communication service, and a visual interaction page; the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are respectively connected to the graph database service and the interaction and communication service, and the interaction and communication service is connected to the visual interaction page.

[0014] Optionally, the neo4j database is provided with query logic, and the steps are as follows:

[0015] Obtain the user's query operation instruction, the visual interaction page generates a request according to the user's query operation instruction, and sends the request to the interaction and communication service;

[0016] The interaction and communication service verifies the security of the request, performs data parsing on the request based on the verification result, and calls the query processing service based on the parsing result;

[0017] The query processing service converts the request data into the corresponding database query statement and passes the query statement to the graph database service. The graph database service performs the query operation on the terminal wiring diagram data model to obtain the query result.

[0018] The query results are returned to the interaction and communication service through the graph database service and the query processing service in sequence. The interaction and communication service converts the query results into a specific format and returns the query results after format conversion to the visualization interaction page.

[0019] Optionally, the neo4j database is also provided with anomaly detection logic, the steps of which are as follows:

[0020] Get the user's fault detection request;

[0021] The user's fault detection request is sequentially transmitted through the visual interaction page and the interaction and communication service to the query processing service for fault detection;

[0022] The query processing service generates query statements for graph data traversal and anomaly detection based on the user's fault detection request, and passes the query statements to the graph database service;

[0023] The graph database service performs traversal and anomaly detection operations on the terminal wiring diagram data model, identifies anomalies or fault points, and returns the detection results to the query processing service. The query processing service extracts the fault point information in the detection results and generates fault point topology data;

[0024] The fault point topology data is transmitted to the visualization interaction page via the interaction and communication service, and the visualization interaction page performs rendering and displays the fault point topology graph.

[0025] Optionally, the visual interactive page is built by a Vue3 framework, and a D3.js library is introduced to perform data visualization rendering.

[0026] Terminal wiring visualization system based on graph database, including:

[0027] A model building unit, which builds a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the terminal wiring diagram data model carrier is a neo4j database;

[0028] The processing unit converts the historical cable relationship data of the hydropower station from table data to graph data, and imports them into the neo4j database in batches, and builds the backend service framework and front-end page respectively;

[0029] The execution unit, the front-end page sends a request to the back-end service framework based on the input user operation instructions, the back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

[0030] Optionally, the front-end page in the execution unit includes: a visual interaction page; the back-end service framework in the execution unit includes: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, and an interaction and communication service; wherein the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are respectively connected to the graph database service and the interaction and communication service, and the interaction and communication service is connected to the visual interaction page.

[0031] The technical solution of the present invention has at least the following advantages and beneficial effects:

[0032] The present invention uses the Neo4j graph database to construct a terminal wiring diagram data model, converts historical cable relationship data into a graph data structure, and realizes visual and accurate management of equipment wiring status through a front-end and back-end separated architecture. The design based on the present invention can provide hydropower station managers with an intuitive and efficient equipment wiring status query and analysis tool, greatly improving management efficiency and decision-making quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 A schematic diagram of the process of the terminal wiring visualization method based on the graph database provided by the present invention;

[0034] Figure 2 A schematic diagram of the structure of the terminal wiring diagram data model provided by the present invention;

[0035] Figure 3 This is a schematic diagram of the structure of the neo4j database provided by the present invention. DETAILED DESCRIPTION

[0036] In order to make the purpose, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the drawings in the present invention. Obviously, what is described is only a part of the present invention, not all of it. Generally, the components of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.

[0037] like Figure 1 As shown, the present invention provides one embodiment: a terminal wiring visualization method based on a graph database, the steps of the method comprising:

[0038] Construct a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the carrier of the terminal wiring diagram data model is a neo4j database;

[0039] Convert the historical cable relationship data of the hydropower station from table data to graph data, and import them into the neo4j database in batches, and build the backend service framework and front-end page respectively;

[0040] The front-end page sends a request to the back-end service framework based on the input user operation instructions. The back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

[0041] In this embodiment, a terminal wiring topology model is established in the neo4j database, a back-end service performs database query and request processing, and a front-end page performs visual presentation and interaction.

[0042] In the specific application of this embodiment, the terminal wiring diagram data model is established in the following process:

[0043] Obtain historical cable relationship data of hydropower stations;

[0044] Identify the key entities of the hydropower station, create node types based on the key entities of the hydropower station, and define labels for each node type;

[0045] Analyze the connection relationships between key entities of the hydropower station, define the relationship type for each connection, create mapping rules from tabular data to graphical structure, draw a conceptual diagram of nodes and connection relationships, and complete the construction of the terminal wiring diagram data model.

[0046] like Figure 2 As shown, in the implementation, this embodiment establishes a terminal wiring diagram data model in the neo4j database to represent the wiring conditions between terminals. According to the existing cable inventory table, the diagram data model is designed to convert the table data into diagram data. Taking the terminal X02:01 in the local control unit 9LCU as an example, the established diagram data model is as follows Figure 2 As shown, actual existing entities are used as nodes of the model, and nodes with labels such as "panel cabinet", "loop type", "cable", "core wire", and "terminal" are established respectively, and the attributes of the corresponding nodes are defined (for example, the node labeled "panel cabinet" has the "name" attribute, the node labeled "loop type" has the "type" and "panel cabinet" attributes, the node labeled "cable" has the "number", "specification", and "loop" attributes, the node labeled "core wire" has the "core wire number", "terminal number", "cable number" and other attributes, the node labeled "terminal" has the "terminal number", "core wire number", "function overview" and other attributes), the association between entities is used as the relationship between model nodes, and the attributes of the corresponding relationship are defined (such as update time, etc.).

[0047] According to the graph data model, create the node file nodes.csv and the relationship file relationsh ips.csv respectively, and use the tool "neo4j-admin import" to import the node file and the relationship file into the neo4j database. So far, the terminal wiring diagram data model has been established in the neo4j database. The graph data can be operated through Cypher statements, such as finding all terminals connected to a specific device, updating the connection relationship, traversing the graph data for fault detection, etc.

[0048] In further application of this embodiment, the neo4j database has a composition structure including: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, an interaction and communication service, and a visual interaction page; the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are respectively connected to the graph database service and the interaction and communication service, and the interaction and communication service is connected to the visual interaction page.

[0049] like Figure 3 As shown, in the implementation, the front-end page in this embodiment performs visual presentation and interaction. The front-end is built with the Vue3 framework, and the D3.js library is introduced for visual rendering of graphic data. It can send corresponding requests to the back-end according to user operations, and then render the results returned by the back-end into an intuitive visual page. The back-end service in this embodiment performs database query and front-end request processing. Based on the microservice architecture, different functional modules are split into independent microservices, which interact through lightweight communication protocols (such as HTTP / RESTful API), etc. Its system architecture is as follows Figure 3 As shown in the figure, it mainly includes four major components: graph database service, query processing service, update processing service, and interaction and communication service. Among them, the graph database service is responsible for managing and maintaining graph structure data. It is used to connect to the graph database in the architecture and execute corresponding query statements (such as path search, relationship traversal, etc.) and modification statements (such as node update, relationship change, etc.). The query processing service is responsible for parsing query requests from the front end and converting them into a language that can be executed by the graph database (such as Cypher language, etc.). The update processing service is responsible for parsing graph data update requests from the front end and converting them into a language that can be executed by the graph database (such as Cypher language, etc.). The interaction and communication service is responsible for interactive requests and communications with the front end, including routing management, request response, identity authentication, error handling, etc.

[0050] Specifically, the neo4j database is provided with query logic, and the steps are as follows:

[0051] Obtain the user's query operation instruction, the visual interaction page generates a request according to the user's query operation instruction, and sends the request to the interaction and communication service;

[0052] The interaction and communication service verifies the security of the request, performs data parsing on the request based on the verification result, and calls the query processing service based on the parsing result;

[0053] The query processing service converts the request data into the corresponding database query statement and passes the query statement to the graph database service. The graph database service performs the query operation on the terminal wiring diagram data model to obtain the query result.

[0054] The query results are returned to the interaction and communication service through the graph database service and the query processing service in sequence. The interaction and communication service converts the query results into a specific format and returns the query results after format conversion to the visualization interaction page.

[0055] In the application example, taking "find all terminals under the 9LCU power circuit" as an example, the processing flow is: the front-end interface sends a request to the back-end according to the user operation. After the interaction and communication service receives the request, it first verifies its security, then parses the request parameters, and calls the query processing service according to the parsing result. The query processing service converts the request data into the corresponding database query statement and sends it to the database service for execution. The query results are returned to the interaction and communication service layer by layer, and the interaction and communication service converts the results into data in a specific format and returns them to the front-end.

[0056] Specifically, the neo4j database is also provided with anomaly detection logic, and the steps are as follows:

[0057] Get the user's fault detection request;

[0058] The user's fault detection request is sequentially transmitted through the visual interaction page and the interaction and communication service to the query processing service for fault detection;

[0059] The query processing service generates query statements for graph data traversal and anomaly detection based on the user's fault detection request, and passes the query statements to the graph database service;

[0060] The graph database service performs traversal and anomaly detection operations on the terminal wiring diagram data model, identifies anomalies or fault points, and returns the detection results to the query processing service. The query processing service extracts the fault point information in the detection results and generates fault point topology data;

[0061] The fault point topology data is transmitted to the visualization interaction page via the interaction and communication service, and the visualization interaction page performs rendering and displays the fault point topology graph.

[0062] In another application of this embodiment, the present invention provides a terminal wiring visualization system based on a graph database, including:

[0063] A model building unit, which builds a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the terminal wiring diagram data model carrier is a neo4j database;

[0064] The processing unit converts the historical cable relationship data of the hydropower station from table data to graph data, and imports them into the neo4j database in batches, and builds the backend service framework and front-end page respectively;

[0065] The execution unit, the front-end page sends a request to the back-end service framework based on the input user operation instructions, the back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

[0066] Specifically, the front-end page in the execution unit includes: a visual interaction page; the back-end service framework in the execution unit includes: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, and an interaction and communication service; wherein the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are respectively connected to the graph database service and the interaction and communication service, and the interaction and communication service is connected to the visual interaction page.

[0067] The system architecture of this embodiment is specifically designed based on the logic in the method, wherein a new "Device Retrieval" column is added to the system layout to select a specific device, and the specific device option information is displayed in the "Retrieval Information" column below. "Data Export" can choose to export the selected data in a standard file format (PDF, EXCEL, etc.). "Data Import" batch imports node data and relationship data to batch update graph data. "Anomaly Detection" traverses and checks the graph data to find the abnormal points, displays the fault point topology graph in the graphic display, and outputs text information in "Information Output". Switch modes through the "View / Edit" option. In "View" mode, you can exit the graphic display interface for viewing, drag and zoom the graphics with the mouse, etc. In "Edit" mode, you can directly change the graph data in the "Graphic Display" interface (modify node attributes, edge attributes, etc.), and the changed data is synchronized to the graph database through the back-end service.

[0068] The above is only the preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A terminal wiring visualization method based on a graph database, characterized in that: The steps of the method include: Construct a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the carrier of the terminal wiring diagram data model is a neo4j database; Convert the historical cable relationship data of the hydropower station from table data to graph data, and import them into the neo4j database in batches, and build the backend service framework and front-end page respectively; The front-end page sends a request to the back-end service framework based on the input user operation instructions. The back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

2. The terminal connection visualization method based on graph database according to claim 1, characterized in that: The terminal wiring diagram data model is established in the following process: Obtain historical cable relationship data of hydropower stations; Identify the key entities of the hydropower station, create node types based on the key entities of the hydropower station, and define labels for each node type; Analyze the connection relationships between key entities of the hydropower station, define the relationship type for each connection, create mapping rules from tabular data to graphical structure, draw a conceptual diagram of nodes and connection relationships, and complete the construction of the terminal wiring diagram data model.

3. The terminal connection visualization method based on graph database according to claim 2 is characterized in that: The neo4j database has a composition structure including: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, an interaction and communication service, and a visual interaction page; the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are connected to the graph database service and the interaction and communication service respectively, and the interaction and communication service is connected to the visual interaction page.

4. The terminal connection visualization method based on a graph database according to claim 3, characterized in that: The neo4j database is provided with query logic, the steps of which are as follows: Obtain the user's query operation instruction, the visual interaction page generates a request according to the user's query operation instruction, and sends the request to the interaction and communication service; The interaction and communication service verifies the security of the request, performs data parsing on the request based on the verification result, and calls the query processing service based on the parsing result; The query processing service converts the request data into the corresponding database query statement and passes the query statement to the graph database service. The graph database service performs the query operation on the terminal wiring diagram data model to obtain the query result. The query results are returned to the interaction and communication service through the graph database service and the query processing service in sequence. The interaction and communication service converts the query results into a specific format and returns the query results after format conversion to the visualization interaction page.

5. The terminal connection visualization method based on graph database according to claim 4 is characterized in that: The neo4j database is also equipped with anomaly detection logic, the steps of which are as follows: Get the user's fault detection request; The user's fault detection request is sequentially transmitted through the visual interaction page and the interaction and communication service to the query processing service for fault detection; The query processing service generates query statements for graph data traversal and anomaly detection based on the user's fault detection request, and passes the query statements to the graph database service; The graph database service performs traversal and anomaly detection operations on the terminal wiring diagram data model, identifies anomalies or fault points, and returns the detection results to the query processing service. The query processing service extracts the fault point information in the detection results and generates fault point topology data; The fault point topology data is transmitted to the visualization interaction page via the interaction and communication service, and the visualization interaction page performs rendering and displays the fault point topology graph.

6. The terminal connection visualization method based on graph database according to claim 5, characterized in that: The visual interactive page is built with the Vue3 framework, and the D3.js library is introduced to perform data visualization rendering.

7. The terminal wiring visualization system based on the graph database is characterized by: include: A model building unit, which builds a terminal wiring diagram data model based on the historical cable relationship data of the hydropower station, wherein the terminal wiring diagram data model carrier is a neo4j database; The processing unit converts the historical cable relationship data of the hydropower station from table data to graph data, and imports them into the neo4j database in batches, and builds the backend service framework and front-end page respectively; The execution unit, the front-end page sends a request to the back-end service framework based on the input user operation instructions, the back-end service framework executes and parses the user operation instructions, updates and transforms the execution results through the terminal wiring diagram data model, and inputs them to the front-end page for visual interaction, thereby completing the visual and precise management of the wiring status of the hydropower station equipment.

8. The terminal wiring visualization system based on the graph database according to claim 7 is characterized in that: The front-end page in the execution unit includes: a visual interaction page; the back-end service framework in the execution unit includes: a terminal wiring diagram data model, a graph database service, a query processing service, an update processing service, and an interaction and communication service; wherein the terminal wiring diagram data model is connected to the graph database service, the query processing service and the update processing service are respectively connected to the graph database service and the interaction and communication service, and the interaction and communication service is connected to the visual interaction page.

Images