The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 04, 2010
Filed:
Dec. 17, 2005
Margaret Ann Bernal, San Jose, CA (US);
Yao-ching Stephen Chen, Saratoga, CA (US);
Ding-wei Chieh, Cupertino, CA (US);
Curt Lee Cotner, Gilroy, CA (US);
Baoqiu Cui, San Jose, CA (US);
Tammie Dang, Morgan Hill, CA (US);
Marion B. Farber, San Jose, CA (US);
Georgia Carroll Fuller, San Jose, CA (US);
Joe Cheng-yu Huang, San Jose, CA (US);
Hui-an Lee, San Jose, CA (US);
Claire Willey Mcfeely, San Jose, CA (US);
Chunfeng Pei, San Jose, CA (US);
James Willis Pickel, Gilroy, CA (US);
Yumi Kimura Tsuji, San Jose, CA (US);
Jay A. Yothers, Gilroy, CA (US);
Margaret Alice Zagelow, Morgan Hill, CA (US);
Liyan Zhou, San Jose, CA (US);
Margaret Ann Bernal, San Jose, CA (US);
Yao-Ching Stephen Chen, Saratoga, CA (US);
Ding-Wei Chieh, Cupertino, CA (US);
Curt Lee Cotner, Gilroy, CA (US);
Baoqiu Cui, San Jose, CA (US);
Tammie Dang, Morgan Hill, CA (US);
Marion B. Farber, San Jose, CA (US);
Georgia Carroll Fuller, San Jose, CA (US);
Joe Cheng-yu Huang, San Jose, CA (US);
Hui-An Lee, San Jose, CA (US);
Claire Willey McFeely, San Jose, CA (US);
Chunfeng Pei, San Jose, CA (US);
James Willis Pickel, Gilroy, CA (US);
Yumi Kimura Tsuji, San Jose, CA (US);
Jay A. Yothers, Gilroy, CA (US);
Margaret Alice Zagelow, Morgan Hill, CA (US);
Liyan Zhou, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
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.