Joe Huang

US Patent:

7580958, Aug 25, 2009

Filed:

Jun 17, 2005

Appl. No.:

11/156509

Inventors:

Yao-Ching Stephen Chen - Saratoga CA, US
Curt Lee Cotner - Gilroy CA, US
Baoqiu Cui - San Jose CA, US
Tammie Dang - Morgan Hill CA, US
Joe Cheng-yu Huang - San Jose CA, US
Claire Willey McFeely - San Jose CA, US
Robert Thomas Miller - San Jose CA, US
Manogari Nogi Simanjuntak - San Jose CA, US
Yumi Kimura Tsuji - San Jose CA, US
Xiaoyu Yang - San Jose CA, US
Jay A. Yothers - Gilroy CA, US
Margaret Alice Zagelow - Morgan Hill CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 12/00
G06F 17/30

US Classification:

707201, 707203

Abstract:

Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

US Patent:

7711746, May 4, 2010

Filed:

Dec 17, 2005

Appl. No.:

11/311810

Inventors:

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

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00

US Classification:

707770, 717136

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.