System and method for deploying an SQL procedure

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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: DANG TAMMIE, MCFEELY CLAIRE W, HUANG JOE C, CHIEH DING-WEI, FULLER GEORGIA C, CUI BAOQIU, TSUJI YUMI K, BERNAL MARGARET A, YOTHERS JAY A, ZAGELOW MARGARET A, COTNER CURT L, LEE HUI-AN, PEI CHUNFENG, CHEN YAOING S, PICKEL JAMES W, ZHOU LIYAN, FARBER MARION B
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.