International Business Machines Corporation

Ding-Wei Chieh

Yao-Ching Stephen Chen

Guogen Zhang

Yumi Kimura Tsuji

Yun Yu Wang

Curt Lee Cotner

James Willis Pickel

Ruiping Li

Jay A Yothers

Brian Thinh-Vinh Tran

Tammie Dang

Lee-Chin Hsu Liu

Claire Willey McFeely

Irene Ching-Hua Liu

Margaret Ann Bernal

Margaret Zagelow

Chunfeng Pei

Georgia Carroll Fuller

Hsuiying Yen Cheng

Joe Cheng-yu Huang

Baoqiu Cui

Hui-An Lee

Liyan Zhou

Marion B Farber

Huong T Tran

Baoqui Cui

Yumi Kimara Tsuji

Joe Cheung-Yu c/oIBM Uk Ltd Ip Law Huang

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.

System and method for deploying an SQL procedure

A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.

Materialized view signature and efficient identification of materialized view candidates for queries

A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: (a) combining join predicates from a query with local predicates from each branch of one or more UNION ALL views referenced by the query; (b) analyzing the combined predicates; and (c) not generating the join when the analysis step indicates that the combined predicates lead to an empty result.

Query transformation for union all view join queries using join predicates for pruning and distribution

Growing community of inventors

Cupertino, CA, United States of America

Ding-Wei Chieh