International Business Machines Corporation

Hsuiying Yen Cheng

Yao-Ching Stephen Chen

Yun Yu Wang

Guogen Zhang

James Willis Pickel

Fen-Ling Lin

Julie Ann Watts

Ruiping Li

Brian Thinh-Vinh Tran

Lee-Chin Hsu Liu

Christopher John Crone

Karelle Lynne Cornwell

Irene Ching-Hua Liu

Margaret Ann Bernal

Yumi Kimura Tsuji

Ding-Wei Chieh

A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.

Method of returning data during insert statement processing

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

Growing community of inventors

Fremont, CA, United States of America

Hsuiying Yen Cheng