Data relation analysis method and device based on SQL script

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:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator LENG YINGYING
SONG LIJUAN
LI RUI
XING YUQIANG
ZHANG KAIHENG
description 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
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN117874059A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN117874059A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN117874059A3</originalsourceid><addsrcrecordid>eNrjZLBxSSxJVChKzUksyczPU0jMS8ypLM4sVshNLcnITwHyUxRSUssyk1MVkhKLU1MUgGqCA30UipOLMgtKeBhY0xJzilN5oTQ3g6Kba4izh25qQX58anFBYnJqXmpJvLOfoaG5hbmJgamlozExagCXAS8Y</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Data relation analysis method and device based on SQL script</title><source>esp@cenet</source><creator>LENG YINGYING ; SONG LIJUAN ; LI RUI ; XING YUQIANG ; ZHANG KAIHENG</creator><creatorcontrib>LENG YINGYING ; SONG LIJUAN ; LI RUI ; XING YUQIANG ; ZHANG KAIHENG</creatorcontrib><description>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</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2024</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240412&amp;DB=EPODOC&amp;CC=CN&amp;NR=117874059A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240412&amp;DB=EPODOC&amp;CC=CN&amp;NR=117874059A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LENG YINGYING</creatorcontrib><creatorcontrib>SONG LIJUAN</creatorcontrib><creatorcontrib>LI RUI</creatorcontrib><creatorcontrib>XING YUQIANG</creatorcontrib><creatorcontrib>ZHANG KAIHENG</creatorcontrib><title>Data relation analysis method and device based on SQL script</title><description>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</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2024</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZLBxSSxJVChKzUksyczPU0jMS8ypLM4sVshNLcnITwHyUxRSUssyk1MVkhKLU1MUgGqCA30UipOLMgtKeBhY0xJzilN5oTQ3g6Kba4izh25qQX58anFBYnJqXmpJvLOfoaG5hbmJgamlozExagCXAS8Y</recordid><startdate>20240412</startdate><enddate>20240412</enddate><creator>LENG YINGYING</creator><creator>SONG LIJUAN</creator><creator>LI RUI</creator><creator>XING YUQIANG</creator><creator>ZHANG KAIHENG</creator><scope>EVB</scope></search><sort><creationdate>20240412</creationdate><title>Data relation analysis method and device based on SQL script</title><author>LENG YINGYING ; SONG LIJUAN ; LI RUI ; XING YUQIANG ; ZHANG KAIHENG</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN117874059A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2024</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LENG YINGYING</creatorcontrib><creatorcontrib>SONG LIJUAN</creatorcontrib><creatorcontrib>LI RUI</creatorcontrib><creatorcontrib>XING YUQIANG</creatorcontrib><creatorcontrib>ZHANG KAIHENG</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LENG YINGYING</au><au>SONG LIJUAN</au><au>LI RUI</au><au>XING YUQIANG</au><au>ZHANG KAIHENG</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Data relation analysis method and device based on SQL script</title><date>2024-04-12</date><risdate>2024</risdate><abstract>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</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN117874059A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Data relation analysis method and device based on SQL script
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-01T11%3A45%3A15IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=LENG%20YINGYING&rft.date=2024-04-12&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN117874059A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true