Text2sql optimization method based on dimension model modeling
The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service proce...
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!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | JING YOUDING DU CHUANGSHENG DENG PAN HAO ZENGCAI CAI PENGCHAO WANG XUFENG HUANG JIAJUN WEN QIANG |
| description | The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service process; s2, performing word segmentation processing on the ability problem set, and listing an entity table; s3, determining facts, dimensions and corresponding attributes of the digital model of the dimension model; s4, constructing a dimension model bus matrix according to the dimension model; s5, constructing an entity information table for the dimension model, and converting the entity information table into an entity dictionary; s6, constructing a dictionary-based named entity recognition model, and recognizing entities, related tables, association conditions, query conditions and grouping fields in the question sentences; s7, constructing an aggregation function judgment model to identify an aggregation function |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN116414865A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN116414865A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN116414865A3</originalsourceid><addsrcrecordid>eNrjZLALSa0oMSouzFHILyjJzM2sSizJzM9TyE0tychPUUhKLE5NUQDyUzJzU_OKwTL5Kak5EDIzL52HgTUtMac4lRdKczMourmGOHvophbkx6cWFyQmp-allsQ7-xkampkYmliYmToaE6MGAIAlMN4</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Text2sql optimization method based on dimension model modeling</title><source>esp@cenet</source><creator>JING YOUDING ; DU CHUANGSHENG ; DENG PAN ; HAO ZENGCAI ; CAI PENGCHAO ; WANG XUFENG ; HUANG JIAJUN ; WEN QIANG</creator><creatorcontrib>JING YOUDING ; DU CHUANGSHENG ; DENG PAN ; HAO ZENGCAI ; CAI PENGCHAO ; WANG XUFENG ; HUANG JIAJUN ; WEN QIANG</creatorcontrib><description>The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service process; s2, performing word segmentation processing on the ability problem set, and listing an entity table; s3, determining facts, dimensions and corresponding attributes of the digital model of the dimension model; s4, constructing a dimension model bus matrix according to the dimension model; s5, constructing an entity information table for the dimension model, and converting the entity information table into an entity dictionary; s6, constructing a dictionary-based named entity recognition model, and recognizing entities, related tables, association conditions, query conditions and grouping fields in the question sentences; s7, constructing an aggregation function judgment model to identify an aggregation function</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&date=20230711&DB=EPODOC&CC=CN&NR=116414865A$$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&date=20230711&DB=EPODOC&CC=CN&NR=116414865A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>JING YOUDING</creatorcontrib><creatorcontrib>DU CHUANGSHENG</creatorcontrib><creatorcontrib>DENG PAN</creatorcontrib><creatorcontrib>HAO ZENGCAI</creatorcontrib><creatorcontrib>CAI PENGCHAO</creatorcontrib><creatorcontrib>WANG XUFENG</creatorcontrib><creatorcontrib>HUANG JIAJUN</creatorcontrib><creatorcontrib>WEN QIANG</creatorcontrib><title>Text2sql optimization method based on dimension model modeling</title><description>The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service process; s2, performing word segmentation processing on the ability problem set, and listing an entity table; s3, determining facts, dimensions and corresponding attributes of the digital model of the dimension model; s4, constructing a dimension model bus matrix according to the dimension model; s5, constructing an entity information table for the dimension model, and converting the entity information table into an entity dictionary; s6, constructing a dictionary-based named entity recognition model, and recognizing entities, related tables, association conditions, query conditions and grouping fields in the question sentences; s7, constructing an aggregation function judgment model to identify an aggregation function</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>eNrjZLALSa0oMSouzFHILyjJzM2sSizJzM9TyE0tychPUUhKLE5NUQDyUzJzU_OKwTL5Kak5EDIzL52HgTUtMac4lRdKczMourmGOHvophbkx6cWFyQmp-allsQ7-xkampkYmliYmToaE6MGAIAlMN4</recordid><startdate>20230711</startdate><enddate>20230711</enddate><creator>JING YOUDING</creator><creator>DU CHUANGSHENG</creator><creator>DENG PAN</creator><creator>HAO ZENGCAI</creator><creator>CAI PENGCHAO</creator><creator>WANG XUFENG</creator><creator>HUANG JIAJUN</creator><creator>WEN QIANG</creator><scope>EVB</scope></search><sort><creationdate>20230711</creationdate><title>Text2sql optimization method based on dimension model modeling</title><author>JING YOUDING ; DU CHUANGSHENG ; DENG PAN ; HAO ZENGCAI ; CAI PENGCHAO ; WANG XUFENG ; HUANG JIAJUN ; WEN QIANG</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN116414865A3</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>JING YOUDING</creatorcontrib><creatorcontrib>DU CHUANGSHENG</creatorcontrib><creatorcontrib>DENG PAN</creatorcontrib><creatorcontrib>HAO ZENGCAI</creatorcontrib><creatorcontrib>CAI PENGCHAO</creatorcontrib><creatorcontrib>WANG XUFENG</creatorcontrib><creatorcontrib>HUANG JIAJUN</creatorcontrib><creatorcontrib>WEN QIANG</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>JING YOUDING</au><au>DU CHUANGSHENG</au><au>DENG PAN</au><au>HAO ZENGCAI</au><au>CAI PENGCHAO</au><au>WANG XUFENG</au><au>HUANG JIAJUN</au><au>WEN QIANG</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Text2sql optimization method based on dimension model modeling</title><date>2023-07-11</date><risdate>2023</risdate><abstract>The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service process; s2, performing word segmentation processing on the ability problem set, and listing an entity table; s3, determining facts, dimensions and corresponding attributes of the digital model of the dimension model; s4, constructing a dimension model bus matrix according to the dimension model; s5, constructing an entity information table for the dimension model, and converting the entity information table into an entity dictionary; s6, constructing a dictionary-based named entity recognition model, and recognizing entities, related tables, association conditions, query conditions and grouping fields in the question sentences; s7, constructing an aggregation function judgment model to identify an aggregation function</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN116414865A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Text2sql optimization method based on dimension model modeling |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-06T21%3A42%3A57IST&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=JING%20YOUDING&rft.date=2023-07-11&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN116414865A%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 |