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.

Date of Patent:
Jan. 19, 2021

Filed:

Apr. 23, 2018
Applicant:

International Business Machines Corporation, Armonk, NY (US);

Inventors:

Rafal P. Konik, Oronoco, MN (US);

Roger A. Mittelstadt, Byron, MN (US);

Brian R. Muras, Otsego, MN (US);

Chad A. Olstad, Rochester, MN (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/23 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24542 (2019.01); G06F 16/23 (2019.01); G06F 16/2365 (2019.01);
Abstract

A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.


Find Patent Forward Citations

Loading…