Dynamic optimization method for SQL (Structured Query Language) script
The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting...
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 | QING XIAODONG WANG ZHENG QIN XIAOCHAO |
| description | The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting and analyzing a grammatical structure of an SQL script by triggering an optimization mechanism, and checking script specifications; then, dynamically optimizing the SQL script on the basis of the analyzed grammar structure and an index condition returned by a retrieval target database; the target database is retrieved again in combination with different script sets, virtual table sets and retrieval condition sets; and finally, sequentially presenting the SQL script, the table structure information, the execution time, the result set, whether the result set is consistent or not and other information according to the execution efficiency. Through the mode of dynamically optimizing the SQL script, the project develop |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN115576563A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN115576563A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN115576563A3</originalsourceid><addsrcrecordid>eNrjZHBzqcxLzM1MVsgvKMnMzaxKLMnMz1PITS3JyE9RSMsvUggO9FHQCC4pKk0uKS1KTVEILE0tqlTwScxLL01MT9VUKE4uyiwo4WFgTUvMKU7lhdLcDIpuriHOHrqpBfnxqcUFicmpeakl8c5-hoampuZmpmbGjsbEqAEABtszNA</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Dynamic optimization method for SQL (Structured Query Language) script</title><source>esp@cenet</source><creator>QING XIAODONG ; WANG ZHENG ; QIN XIAOCHAO</creator><creatorcontrib>QING XIAODONG ; WANG ZHENG ; QIN XIAOCHAO</creatorcontrib><description>The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting and analyzing a grammatical structure of an SQL script by triggering an optimization mechanism, and checking script specifications; then, dynamically optimizing the SQL script on the basis of the analyzed grammar structure and an index condition returned by a retrieval target database; the target database is retrieved again in combination with different script sets, virtual table sets and retrieval condition sets; and finally, sequentially presenting the SQL script, the table structure information, the execution time, the result set, whether the result set is consistent or not and other information according to the execution efficiency. Through the mode of dynamically optimizing the SQL script, the project develop</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=20230106&DB=EPODOC&CC=CN&NR=115576563A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,777,882,25545,76296</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230106&DB=EPODOC&CC=CN&NR=115576563A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>QING XIAODONG</creatorcontrib><creatorcontrib>WANG ZHENG</creatorcontrib><creatorcontrib>QIN XIAOCHAO</creatorcontrib><title>Dynamic optimization method for SQL (Structured Query Language) script</title><description>The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting and analyzing a grammatical structure of an SQL script by triggering an optimization mechanism, and checking script specifications; then, dynamically optimizing the SQL script on the basis of the analyzed grammar structure and an index condition returned by a retrieval target database; the target database is retrieved again in combination with different script sets, virtual table sets and retrieval condition sets; and finally, sequentially presenting the SQL script, the table structure information, the execution time, the result set, whether the result set is consistent or not and other information according to the execution efficiency. Through the mode of dynamically optimizing the SQL script, the project develop</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>eNrjZHBzqcxLzM1MVsgvKMnMzaxKLMnMz1PITS3JyE9RSMsvUggO9FHQCC4pKk0uKS1KTVEILE0tqlTwScxLL01MT9VUKE4uyiwo4WFgTUvMKU7lhdLcDIpuriHOHrqpBfnxqcUFicmpeakl8c5-hoampuZmpmbGjsbEqAEABtszNA</recordid><startdate>20230106</startdate><enddate>20230106</enddate><creator>QING XIAODONG</creator><creator>WANG ZHENG</creator><creator>QIN XIAOCHAO</creator><scope>EVB</scope></search><sort><creationdate>20230106</creationdate><title>Dynamic optimization method for SQL (Structured Query Language) script</title><author>QING XIAODONG ; WANG ZHENG ; QIN XIAOCHAO</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN115576563A3</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>QING XIAODONG</creatorcontrib><creatorcontrib>WANG ZHENG</creatorcontrib><creatorcontrib>QIN XIAOCHAO</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>QING XIAODONG</au><au>WANG ZHENG</au><au>QIN XIAOCHAO</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Dynamic optimization method for SQL (Structured Query Language) script</title><date>2023-01-06</date><risdate>2023</risdate><abstract>The invention relates to a script optimization technology, and discloses an SQL script dynamic optimization method, which simplifies the operation of developers on a database so as to reduce the learning cost of SQL script optimization. The method comprises the following steps: firstly, intercepting and analyzing a grammatical structure of an SQL script by triggering an optimization mechanism, and checking script specifications; then, dynamically optimizing the SQL script on the basis of the analyzed grammar structure and an index condition returned by a retrieval target database; the target database is retrieved again in combination with different script sets, virtual table sets and retrieval condition sets; and finally, sequentially presenting the SQL script, the table structure information, the execution time, the result set, whether the result set is consistent or not and other information according to the execution efficiency. Through the mode of dynamically optimizing the SQL script, the project develop</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN115576563A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Dynamic optimization method for SQL (Structured Query Language) 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-21T09%3A14%3A08IST&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=QING%20XIAODONG&rft.date=2023-01-06&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN115576563A%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 |