Patent ID: 7711746
Filing Date: 2010-05-04
Classification: G06F

Abstract:
1. A processor-implemented method for deploying a structured query language (SQL) procedure, the method comprising: creating the SQL procedure comprising a procedure logic component that comprises one or more loop statements, conditional statement and other control statements and a database request component that comprises one or more SQL statements from a source system to a target system, wherein the procedural logic component and the database request component are deployed separately from the source system to the target system generating source code, a symbol table, and optimization results for the structured query language procedure, in order to regenerate run-time instructions for the SQL statements of the database request component, wherein the SQL statements of the database request component function with a deployed version of an internal representation of the procedural logic component; maintaining an association between the procedural logic component and the database request component during deployment; copying the deployed version of the internal representation of the procedural logic component to the target system without regeneration; and regenerating the database request component to recreate the structured query language procedure on the target system, and to maintain a consistent interface between the procedural logic component and the database request component.