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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LENG YINGYING, SONG LIJUAN, LI RUI, XING YUQIANG, ZHANG KAIHENG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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