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:
Feb. 18, 2020

Filed:

Nov. 04, 2016
Applicant:

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

Inventors:

Thomas A. Beavin, Milpitas, CA (US);

Zhang Hao, Beijing, CN;

Shuo Li, Beijing, CN;

Xiaobo Wang, Beijing, CN;

Ke Wei Wei, Beijing, CN;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/20 (2019.01); G06F 16/2455 (2019.01); G06F 16/2453 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24552 (2019.01); G06F 16/2453 (2019.01);
Abstract

Disclosed aspects relate to query processing management in a database management system (DBMS). The DBMS may detect that a query has a set of subqueries. The DBMS may detect that the set of subqueries indicates a set of data structures. A lead data structure may be selected from the set of data structures using a selection criterion. A set of input columns may be identified from the lead data structure of the set of data structures. A set of output columns may be identified from the set of data structures other than the lead data structure. A hash data structure may be constructed using the set of input columns and the set of output columns. A cache may be built based on the hash data structure.


Find Patent Forward Citations

Loading…