System and method for deploying an SQL procedure
An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated...
Gespeichert in:
| Hauptverfasser: | , , , , , , , , , , , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| 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 | Bernal, Margaret Ann Chen, Yao-Ching Stephen Chieh, Ding-Wei Cotner, Curt Lee Cui, Baoqiu Dang, Tammie Farber, Marion B Fuller, Georgia Carroll Huang, Joe Cheng-yu Lee, Hui-An McFeely, Claire Willey Pei, Chunfeng Pickel, James Willis Tsuji, Yumi Kimura Yothers, Jay A Zagelow, Margaret Alice Zhou, Liyan |
| description | An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component. |
| format | Patent |
| fullrecord | <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07711746</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07711746</sourcerecordid><originalsourceid>FETCH-uspatents_grants_077117463</originalsourceid><addsrcrecordid>eNrjZDAIriwuSc1VSMxLUchNLcnIT1FIyy9SSEktyMmvzMxLB0ooBAf6KBQU5SenppQWpfIwsKYl5hSn8kJpbgYFN9cQZw_d0uKCxJLUvJLi-PSiRBBlYG5uaGhuYmZMhBIAA3crug</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>System and method for deploying an SQL procedure</title><source>USPTO Issued Patents</source><creator>Bernal, Margaret Ann ; Chen, Yao-Ching Stephen ; Chieh, Ding-Wei ; Cotner, Curt Lee ; Cui, Baoqiu ; Dang, Tammie ; Farber, Marion B ; Fuller, Georgia Carroll ; Huang, Joe Cheng-yu ; Lee, Hui-An ; McFeely, Claire Willey ; Pei, Chunfeng ; Pickel, James Willis ; Tsuji, Yumi Kimura ; Yothers, Jay A ; Zagelow, Margaret Alice ; Zhou, Liyan</creator><creatorcontrib>Bernal, Margaret Ann ; Chen, Yao-Ching Stephen ; Chieh, Ding-Wei ; Cotner, Curt Lee ; Cui, Baoqiu ; Dang, Tammie ; Farber, Marion B ; Fuller, Georgia Carroll ; Huang, Joe Cheng-yu ; Lee, Hui-An ; McFeely, Claire Willey ; Pei, Chunfeng ; Pickel, James Willis ; Tsuji, Yumi Kimura ; Yothers, Jay A ; Zagelow, Margaret Alice ; Zhou, Liyan ; International Business Machines Corporation</creatorcontrib><description>An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.</description><language>eng</language><creationdate>2010</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7711746$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,780,802,885,64039</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7711746$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Bernal, Margaret Ann</creatorcontrib><creatorcontrib>Chen, Yao-Ching Stephen</creatorcontrib><creatorcontrib>Chieh, Ding-Wei</creatorcontrib><creatorcontrib>Cotner, Curt Lee</creatorcontrib><creatorcontrib>Cui, Baoqiu</creatorcontrib><creatorcontrib>Dang, Tammie</creatorcontrib><creatorcontrib>Farber, Marion B</creatorcontrib><creatorcontrib>Fuller, Georgia Carroll</creatorcontrib><creatorcontrib>Huang, Joe Cheng-yu</creatorcontrib><creatorcontrib>Lee, Hui-An</creatorcontrib><creatorcontrib>McFeely, Claire Willey</creatorcontrib><creatorcontrib>Pei, Chunfeng</creatorcontrib><creatorcontrib>Pickel, James Willis</creatorcontrib><creatorcontrib>Tsuji, Yumi Kimura</creatorcontrib><creatorcontrib>Yothers, Jay A</creatorcontrib><creatorcontrib>Zagelow, Margaret Alice</creatorcontrib><creatorcontrib>Zhou, Liyan</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>System and method for deploying an SQL procedure</title><description>An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2010</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNrjZDAIriwuSc1VSMxLUchNLcnIT1FIyy9SSEktyMmvzMxLB0ooBAf6KBQU5SenppQWpfIwsKYl5hSn8kJpbgYFN9cQZw_d0uKCxJLUvJLi-PSiRBBlYG5uaGhuYmZMhBIAA3crug</recordid><startdate>20100504</startdate><enddate>20100504</enddate><creator>Bernal, Margaret Ann</creator><creator>Chen, Yao-Ching Stephen</creator><creator>Chieh, Ding-Wei</creator><creator>Cotner, Curt Lee</creator><creator>Cui, Baoqiu</creator><creator>Dang, Tammie</creator><creator>Farber, Marion B</creator><creator>Fuller, Georgia Carroll</creator><creator>Huang, Joe Cheng-yu</creator><creator>Lee, Hui-An</creator><creator>McFeely, Claire Willey</creator><creator>Pei, Chunfeng</creator><creator>Pickel, James Willis</creator><creator>Tsuji, Yumi Kimura</creator><creator>Yothers, Jay A</creator><creator>Zagelow, Margaret Alice</creator><creator>Zhou, Liyan</creator><scope>EFH</scope></search><sort><creationdate>20100504</creationdate><title>System and method for deploying an SQL procedure</title><author>Bernal, Margaret Ann ; Chen, Yao-Ching Stephen ; Chieh, Ding-Wei ; Cotner, Curt Lee ; Cui, Baoqiu ; Dang, Tammie ; Farber, Marion B ; Fuller, Georgia Carroll ; Huang, Joe Cheng-yu ; Lee, Hui-An ; McFeely, Claire Willey ; Pei, Chunfeng ; Pickel, James Willis ; Tsuji, Yumi Kimura ; Yothers, Jay A ; Zagelow, Margaret Alice ; Zhou, Liyan</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_077117463</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2010</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Bernal, Margaret Ann</creatorcontrib><creatorcontrib>Chen, Yao-Ching Stephen</creatorcontrib><creatorcontrib>Chieh, Ding-Wei</creatorcontrib><creatorcontrib>Cotner, Curt Lee</creatorcontrib><creatorcontrib>Cui, Baoqiu</creatorcontrib><creatorcontrib>Dang, Tammie</creatorcontrib><creatorcontrib>Farber, Marion B</creatorcontrib><creatorcontrib>Fuller, Georgia Carroll</creatorcontrib><creatorcontrib>Huang, Joe Cheng-yu</creatorcontrib><creatorcontrib>Lee, Hui-An</creatorcontrib><creatorcontrib>McFeely, Claire Willey</creatorcontrib><creatorcontrib>Pei, Chunfeng</creatorcontrib><creatorcontrib>Pickel, James Willis</creatorcontrib><creatorcontrib>Tsuji, Yumi Kimura</creatorcontrib><creatorcontrib>Yothers, Jay A</creatorcontrib><creatorcontrib>Zagelow, Margaret Alice</creatorcontrib><creatorcontrib>Zhou, Liyan</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Bernal, Margaret Ann</au><au>Chen, Yao-Ching Stephen</au><au>Chieh, Ding-Wei</au><au>Cotner, Curt Lee</au><au>Cui, Baoqiu</au><au>Dang, Tammie</au><au>Farber, Marion B</au><au>Fuller, Georgia Carroll</au><au>Huang, Joe Cheng-yu</au><au>Lee, Hui-An</au><au>McFeely, Claire Willey</au><au>Pei, Chunfeng</au><au>Pickel, James Willis</au><au>Tsuji, Yumi Kimura</au><au>Yothers, Jay A</au><au>Zagelow, Margaret Alice</au><au>Zhou, Liyan</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>System and method for deploying an SQL procedure</title><date>2010-05-04</date><risdate>2010</risdate><abstract>An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_uspatents_grants_07711746 |
| source | USPTO Issued Patents |
| title | System and method for deploying an SQL procedure |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-30T11%3A44%3A34IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-uspatents_EFH&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Bernal,%20Margaret%20Ann&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2010-05-04&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07711746%3C/uspatents_EFH%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 |