Method and device for generating SQL (Structured Query Language) statement from natural language statement

The invention discloses a method and device for generating SQL statements from natural language statements, and the method comprises the steps: building a language processing model based on data enhancement, and the language processing model comprises a data enhancement module and a task training mo...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: CHENG LIHAN, ZHOU XIAOYU, SHI XINYU, HUANG YAN, LI JINXIA, BIAN HUAXING, DING MANJIANG, SHEN JIAN, WEN FUGUO, WANG XI
Format: Patent
Sprache:chi ; eng
Schlagworte:
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 CHENG LIHAN
ZHOU XIAOYU
SHI XINYU
HUANG YAN
LI JINXIA
BIAN HUAXING
DING MANJIANG
SHEN JIAN
WEN FUGUO
WANG XI
description The invention discloses a method and device for generating SQL statements from natural language statements, and the method comprises the steps: building a language processing model based on data enhancement, and the language processing model comprises a data enhancement module and a task training module; obtaining first training data and inputting the first training data into a data enhancement module for data syntax analysis, information removal and data sampling to obtain second training data; merging the first training data and the second training data to generate training data, and sending the training data to a task training module for training until the language processing model converges; establishing a language conversion model, and embedding the language conversion model into a language processing model; the language conversion model receives a to-be-converted natural language statement, and decomposes the to-be-converted natural language statement through the language conversion model to obtain a si
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN118484465A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN118484465A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN118484465A3</originalsourceid><addsrcrecordid>eNqNzbEKwjAUheEuDqK-w3XTwaFYpasUxaEKpe7l0pzGSpuU5Ebw7e1QcHU6w__BmUevG-RpFbFRpPBua1BjHWkYOJbWaCqLnDaluFBLcFBUBLgP5Wx0YI0teWFBDyPUONuT4ZFxR90Efn0ZzRruPFbTLqL15fzIrjsMtoIfuB5PpcrucZwmaZIcD6f9P-YLNntAuw</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method and device for generating SQL (Structured Query Language) statement from natural language statement</title><source>esp@cenet</source><creator>CHENG LIHAN ; ZHOU XIAOYU ; SHI XINYU ; HUANG YAN ; LI JINXIA ; BIAN HUAXING ; DING MANJIANG ; SHEN JIAN ; WEN FUGUO ; WANG XI</creator><creatorcontrib>CHENG LIHAN ; ZHOU XIAOYU ; SHI XINYU ; HUANG YAN ; LI JINXIA ; BIAN HUAXING ; DING MANJIANG ; SHEN JIAN ; WEN FUGUO ; WANG XI</creatorcontrib><description>The invention discloses a method and device for generating SQL statements from natural language statements, and the method comprises the steps: building a language processing model based on data enhancement, and the language processing model comprises a data enhancement module and a task training module; obtaining first training data and inputting the first training data into a data enhancement module for data syntax analysis, information removal and data sampling to obtain second training data; merging the first training data and the second training data to generate training data, and sending the training data to a task training module for training until the language processing model converges; establishing a language conversion model, and embedding the language conversion model into a language processing model; the language conversion model receives a to-be-converted natural language statement, and decomposes the to-be-converted natural language statement through the language conversion model to obtain a si</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS ; 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=20240813&amp;DB=EPODOC&amp;CC=CN&amp;NR=118484465A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76516</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240813&amp;DB=EPODOC&amp;CC=CN&amp;NR=118484465A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>CHENG LIHAN</creatorcontrib><creatorcontrib>ZHOU XIAOYU</creatorcontrib><creatorcontrib>SHI XINYU</creatorcontrib><creatorcontrib>HUANG YAN</creatorcontrib><creatorcontrib>LI JINXIA</creatorcontrib><creatorcontrib>BIAN HUAXING</creatorcontrib><creatorcontrib>DING MANJIANG</creatorcontrib><creatorcontrib>SHEN JIAN</creatorcontrib><creatorcontrib>WEN FUGUO</creatorcontrib><creatorcontrib>WANG XI</creatorcontrib><title>Method and device for generating SQL (Structured Query Language) statement from natural language statement</title><description>The invention discloses a method and device for generating SQL statements from natural language statements, and the method comprises the steps: building a language processing model based on data enhancement, and the language processing model comprises a data enhancement module and a task training module; obtaining first training data and inputting the first training data into a data enhancement module for data syntax analysis, information removal and data sampling to obtain second training data; merging the first training data and the second training data to generate training data, and sending the training data to a task training module for training until the language processing model converges; establishing a language conversion model, and embedding the language conversion model into a language processing model; the language conversion model receives a to-be-converted natural language statement, and decomposes the to-be-converted natural language statement through the language conversion model to obtain a si</description><subject>CALCULATING</subject><subject>COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS</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>eNqNzbEKwjAUheEuDqK-w3XTwaFYpasUxaEKpe7l0pzGSpuU5Ebw7e1QcHU6w__BmUevG-RpFbFRpPBua1BjHWkYOJbWaCqLnDaluFBLcFBUBLgP5Wx0YI0teWFBDyPUONuT4ZFxR90Efn0ZzRruPFbTLqL15fzIrjsMtoIfuB5PpcrucZwmaZIcD6f9P-YLNntAuw</recordid><startdate>20240813</startdate><enddate>20240813</enddate><creator>CHENG LIHAN</creator><creator>ZHOU XIAOYU</creator><creator>SHI XINYU</creator><creator>HUANG YAN</creator><creator>LI JINXIA</creator><creator>BIAN HUAXING</creator><creator>DING MANJIANG</creator><creator>SHEN JIAN</creator><creator>WEN FUGUO</creator><creator>WANG XI</creator><scope>EVB</scope></search><sort><creationdate>20240813</creationdate><title>Method and device for generating SQL (Structured Query Language) statement from natural language statement</title><author>CHENG LIHAN ; ZHOU XIAOYU ; SHI XINYU ; HUANG YAN ; LI JINXIA ; BIAN HUAXING ; DING MANJIANG ; SHEN JIAN ; WEN FUGUO ; WANG XI</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN118484465A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2024</creationdate><topic>CALCULATING</topic><topic>COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>CHENG LIHAN</creatorcontrib><creatorcontrib>ZHOU XIAOYU</creatorcontrib><creatorcontrib>SHI XINYU</creatorcontrib><creatorcontrib>HUANG YAN</creatorcontrib><creatorcontrib>LI JINXIA</creatorcontrib><creatorcontrib>BIAN HUAXING</creatorcontrib><creatorcontrib>DING MANJIANG</creatorcontrib><creatorcontrib>SHEN JIAN</creatorcontrib><creatorcontrib>WEN FUGUO</creatorcontrib><creatorcontrib>WANG XI</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>CHENG LIHAN</au><au>ZHOU XIAOYU</au><au>SHI XINYU</au><au>HUANG YAN</au><au>LI JINXIA</au><au>BIAN HUAXING</au><au>DING MANJIANG</au><au>SHEN JIAN</au><au>WEN FUGUO</au><au>WANG XI</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method and device for generating SQL (Structured Query Language) statement from natural language statement</title><date>2024-08-13</date><risdate>2024</risdate><abstract>The invention discloses a method and device for generating SQL statements from natural language statements, and the method comprises the steps: building a language processing model based on data enhancement, and the language processing model comprises a data enhancement module and a task training module; obtaining first training data and inputting the first training data into a data enhancement module for data syntax analysis, information removal and data sampling to obtain second training data; merging the first training data and the second training data to generate training data, and sending the training data to a task training module for training until the language processing model converges; establishing a language conversion model, and embedding the language conversion model into a language processing model; the language conversion model receives a to-be-converted natural language statement, and decomposes the to-be-converted natural language statement through the language conversion model to obtain a si</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN118484465A
source esp@cenet
subjects CALCULATING
COMPUTER SYSTEMS BASED ON SPECIFIC COMPUTATIONAL MODELS
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Method and device for generating SQL (Structured Query Language) statement from natural language statement
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-13T17%3A55%3A49IST&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=CHENG%20LIHAN&rft.date=2024-08-13&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN118484465A%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