Invention Grant
- Patent Title: Query processing management in a database management system
-
Application No.: US15344431Application Date: 2016-11-04
-
Publication No.: US10565201B2Publication Date: 2020-02-18
- Inventor: Thomas A. Beavin , Zhang Hao , Shuo Li , Xiaobo Wang , Ke Wei Wei
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Erik K Johnson
- Main IPC: G06F16/20
- IPC: G06F16/20 ; G06F16/2455 ; G06F16/2453

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.
Public/Granted literature
- US20180129708A1 QUERY PROCESSING MANAGEMENT IN A DATABASE MANAGEMENT SYSTEM Public/Granted day:2018-05-10
Information query