QUERY PROCESSING MANAGEMENT IN A DATABASE MANAGEMENT SYSTEM
First Claim
1. A computer-implemented method for query processing management in a database management system (DBMS), the method comprising:
- detecting, by the DBMS, that a query has a set of subqueries;
detecting, by the DBMS, that the set of subqueries indicates a set of data structures;
selecting, from the set of data structures, a lead data structure using a selection criterion;
identifying, from the lead data structure of the set of data structures, a set of input columns;
identifying, from the set of data structures other than the lead data structure, a set of output columns;
constructing, using the set of input columns and the set of output columns, a hash data structure; and
building, based on the hash data structure, a cache.
1 Assignment
0 Petitions
Accused Products
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.
10 Citations
20 Claims
-
1. A computer-implemented method for query processing management in a database management system (DBMS), the method comprising:
-
detecting, by the DBMS, that a query has a set of subqueries; detecting, by the DBMS, that the set of subqueries indicates a set of data structures; selecting, from the set of data structures, a lead data structure using a selection criterion; identifying, from the lead data structure of the set of data structures, a set of input columns; identifying, from the set of data structures other than the lead data structure, a set of output columns; constructing, using the set of input columns and the set of output columns, a hash data structure; and building, based on the hash data structure, a cache. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A system for query processing management in a database management system (DBMS), the system comprising:
-
a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including; detecting, by the DBMS, that a query has a set of subqueries; detecting, by the DBMS, that the set of subqueries indicates a set of data structures; selecting, from the set of data structures, a lead data structure using a selection criterion; identifying, from the lead data structure of the set of data structures, a set of input columns; identifying, from the set of data structures other than the lead data structure, a set of output columns; constructing, using the set of input columns and the set of output columns, a hash data structure; and building, based on the hash data structure, a cache.
-
-
20. A computer program product for query processing management in a database management system (DBMS), the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
-
detecting, by the DBMS, that a query has a set of subqueries; detecting, by the DBMS, that the set of subqueries indicates a set of data structures; selecting, from the set of data structures, a lead data structure using a selection criterion; identifying, from the lead data structure of the set of data structures, a set of input columns; identifying, from the set of data structures other than the lead data structure, a set of output columns; constructing, using the set of input columns and the set of output columns, a hash data structure; and building, based on the hash data structure, a cache.
-
Specification