The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 04, 2010
Filed:
Dec. 22, 2003
Margaret A. Bernal, San Jose, CA (US);
Karelle L. Cornwell, Campbell, CA (US);
Hsuiying Y. Cheng, Fremont, CA (US);
Yao-ching S. Chen, Saratoga, CA (US);
Christopher J. Crone, San Jose, CA (US);
Fen-ling Lin, San Jose, CA (US);
James W. Pickel, Gilroy, CA (US);
Yumi K. Tsuji, San Jose, CA (US);
Julie A. Watts, Morgan Hill, CA (US);
Margaret A. Bernal, San Jose, CA (US);
Karelle L. Cornwell, Campbell, CA (US);
Hsuiying Y. Cheng, Fremont, CA (US);
Yao-Ching S. Chen, Saratoga, CA (US);
Christopher J. Crone, San Jose, CA (US);
Fen-Ling Lin, San Jose, CA (US);
James W. Pickel, Gilroy, CA (US);
Yumi K. Tsuji, San Jose, CA (US);
Julie A. Watts, Morgan Hill, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
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.