System and method for deploying an SQL procedure

US7711746B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Margaret Bernal · San Jose, US
• Yao-Ching Chen · Saratoga, US
• Ding-Wei Chieh · Cupertino, US
• Curt L. Cotner · Gilroy, US
• Baoqiu Cui · Beijing, CN
• Tammie Dang · معلمی نژاد, US
• Marion Farber · San Jose, US
• Georgia C. Fuller · San Jose, US
• Joe Cheng-yu Huang · San Jose, US
• Hui-An Lee · San Jose, US
• Claire McFeely · San Jose, US
• Chunfeng Pei · San Jose, US
• James W. Pickel · Gilroy, US
• Yumi Tsuji · San Jose, US
• Jay A. Yothers · Gilroy, US
• Margaret Zagelow · معلمی نژاد, US
• Liyan Zhou · San Jose, US

Key dates

• Filing date: Dec 17, 2005
• Grant date: May 4, 2010
• Expiry date: Mar 7, 2027

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/28
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.