Data relation analysis method and device based on SQL script
The invention provides a data relation analysis method and device based on an SQL script, and the method is applied to a server, and comprises the steps: receiving the SQL script sent by a client; analyzing the SQL script to obtain a blood relationship model; the blood relationship model is converte...
Gespeichert in:
Hauptverfasser: | , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention provides a data relation analysis method and device based on an SQL script, and the method is applied to a server, and comprises the steps: receiving the SQL script sent by a client; analyzing the SQL script to obtain a blood relationship model; the blood relationship model is converted, a graph model is obtained, the graph model is a directed tag attribute graph, and the graph model comprises a library, a table, an SQL (Structured Query Language) process, a field and a field blood relationship process; storing the graph model into a graph database; calling the graph model in the graph database through a Gremlin graph traversal statement, and performing calculation to obtain a blood relationship graph; sending the blood relationship graph to a client, so that the client displays the blood relationship graph; the blood relationship of two granularities of tables and fields in multiple database SQL scripts is analyzed through data blood relationship, cross-database and automatic data blood relatio |
---|