SQL (Structured Query Language) statement generation method and device, equipment and storage medium

SQL (Structured Query Language) statement generation method and device, equipment and storage medium

The invention discloses an SQL (Structured Query Language) statement generation method and device, equipment and a storage medium. The method comprises the following steps: acquiring an original SQL statement; the original SQL statement comprises main table metadata; analyzing the original SQL state...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: FAN YUNBO, QIN HUACHAN, LIAO GUANGXIAN, TAO JIE
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 FAN YUNBO
QIN HUACHAN
LIAO GUANGXIAN
TAO JIE
description The invention discloses an SQL (Structured Query Language) statement generation method and device, equipment and a storage medium. The method comprises the following steps: acquiring an original SQL statement; the original SQL statement comprises main table metadata; analyzing the original SQL statement to generate a first syntax tree; on the basis of a preset mapping relation between main table metadata and M groups of sub-table metadata, replacing the main table metadata in the first syntax tree by using the M groups of sub-table metadata to obtain M second syntax trees; and carrying out inverse analysis on the M second syntax trees to generate M sub-SQL statements. Thus, according to the preset unified mapping relation, the original SQL statement issued by the center cluster is converted, the sub-SQL statements matched with the M edge clusters can be automatically generated, manual intervention is not needed in the conversion process, the conversion standard is unified, the correctness of the sub-SQL state
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN115687387A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN115687387A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN115687387A3</originalsourceid><addsrcrecordid>eNqNzMEKgkAYBGAvHaJ6h79bQR1EUq8hRQcJxO7y4062kLu2-2_Q22fRA3QaGL6ZaaTqqqRVLS60EhwUVQHuRSWbLnCHNXlhQQ8j1MHAsWhrqIfcrCI2ihSeusWG8Ah6-LpP68W6cT5CpUM_jyZXvnssfjmLlsfDpThtMdgGfuB2vJamOMfxLs2zJM_2yT_mDYVBPmk</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>SQL (Structured Query Language) statement generation method and device, equipment and storage medium</title><source>esp@cenet</source><creator>FAN YUNBO ; QIN HUACHAN ; LIAO GUANGXIAN ; TAO JIE</creator><creatorcontrib>FAN YUNBO ; QIN HUACHAN ; LIAO GUANGXIAN ; TAO JIE</creatorcontrib><description>The invention discloses an SQL (Structured Query Language) statement generation method and device, equipment and a storage medium. The method comprises the following steps: acquiring an original SQL statement; the original SQL statement comprises main table metadata; analyzing the original SQL statement to generate a first syntax tree; on the basis of a preset mapping relation between main table metadata and M groups of sub-table metadata, replacing the main table metadata in the first syntax tree by using the M groups of sub-table metadata to obtain M second syntax trees; and carrying out inverse analysis on the M second syntax trees to generate M sub-SQL statements. Thus, according to the preset unified mapping relation, the original SQL statement issued by the center cluster is converted, the sub-SQL statements matched with the M edge clusters can be automatically generated, manual intervention is not needed in the conversion process, the conversion standard is unified, the correctness of the sub-SQL state</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2023</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=20230203&amp;DB=EPODOC&amp;CC=CN&amp;NR=115687387A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25563,76418</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20230203&amp;DB=EPODOC&amp;CC=CN&amp;NR=115687387A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>FAN YUNBO</creatorcontrib><creatorcontrib>QIN HUACHAN</creatorcontrib><creatorcontrib>LIAO GUANGXIAN</creatorcontrib><creatorcontrib>TAO JIE</creatorcontrib><title>SQL (Structured Query Language) statement generation method and device, equipment and storage medium</title><description>The invention discloses an SQL (Structured Query Language) statement generation method and device, equipment and a storage medium. The method comprises the following steps: acquiring an original SQL statement; the original SQL statement comprises main table metadata; analyzing the original SQL statement to generate a first syntax tree; on the basis of a preset mapping relation between main table metadata and M groups of sub-table metadata, replacing the main table metadata in the first syntax tree by using the M groups of sub-table metadata to obtain M second syntax trees; and carrying out inverse analysis on the M second syntax trees to generate M sub-SQL statements. Thus, according to the preset unified mapping relation, the original SQL statement issued by the center cluster is converted, the sub-SQL statements matched with the M edge clusters can be automatically generated, manual intervention is not needed in the conversion process, the conversion standard is unified, the correctness of the sub-SQL state</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>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNzMEKgkAYBGAvHaJ6h79bQR1EUq8hRQcJxO7y4062kLu2-2_Q22fRA3QaGL6ZaaTqqqRVLS60EhwUVQHuRSWbLnCHNXlhQQ8j1MHAsWhrqIfcrCI2ihSeusWG8Ah6-LpP68W6cT5CpUM_jyZXvnssfjmLlsfDpThtMdgGfuB2vJamOMfxLs2zJM_2yT_mDYVBPmk</recordid><startdate>20230203</startdate><enddate>20230203</enddate><creator>FAN YUNBO</creator><creator>QIN HUACHAN</creator><creator>LIAO GUANGXIAN</creator><creator>TAO JIE</creator><scope>EVB</scope></search><sort><creationdate>20230203</creationdate><title>SQL (Structured Query Language) statement generation method and device, equipment and storage medium</title><author>FAN YUNBO ; QIN HUACHAN ; LIAO GUANGXIAN ; TAO JIE</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN115687387A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>FAN YUNBO</creatorcontrib><creatorcontrib>QIN HUACHAN</creatorcontrib><creatorcontrib>LIAO GUANGXIAN</creatorcontrib><creatorcontrib>TAO JIE</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>FAN YUNBO</au><au>QIN HUACHAN</au><au>LIAO GUANGXIAN</au><au>TAO JIE</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>SQL (Structured Query Language) statement generation method and device, equipment and storage medium</title><date>2023-02-03</date><risdate>2023</risdate><abstract>The invention discloses an SQL (Structured Query Language) statement generation method and device, equipment and a storage medium. The method comprises the following steps: acquiring an original SQL statement; the original SQL statement comprises main table metadata; analyzing the original SQL statement to generate a first syntax tree; on the basis of a preset mapping relation between main table metadata and M groups of sub-table metadata, replacing the main table metadata in the first syntax tree by using the M groups of sub-table metadata to obtain M second syntax trees; and carrying out inverse analysis on the M second syntax trees to generate M sub-SQL statements. Thus, according to the preset unified mapping relation, the original SQL statement issued by the center cluster is converted, the sub-SQL statements matched with the M edge clusters can be automatically generated, manual intervention is not needed in the conversion process, the conversion standard is unified, the correctness of the sub-SQL state</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN115687387A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title SQL (Structured Query Language) statement generation method and device, equipment and storage medium
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-08T12%3A11%3A16IST&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=FAN%20YUNBO&rft.date=2023-02-03&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN115687387A%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