US 11,841,857 B2
Query efficiency using merged columns
Shuo Li, Beijing (CN); Xiaobo Wang, Beijing (CN); Leilei Li, San Jose, CA (US); and Sheng Yan Sun, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Feb. 22, 2022, as Appl. No. 17/676,965.
Prior Publication US 2023/0267121 A1, Aug. 24, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 11/34 (2006.01)
CPC G06F 16/24542 (2019.01) [G06F 11/3409 (2013.01); G06F 16/221 (2019.01); G06F 16/2455 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving, from a host, a first query configured to perform a command on one or more target columns in a database;
analyzing a set of statistics for the database;
determining, based on the analyzing, that a first column of the one or more target columns is included in a set of sparse columns;
generating a plurality of access plans for the first query, including a first access plan that merges the first column with a second column;
selecting the first access plan;
merging, in response to the selecting, the first column with the second column into a merged column;
transforming, based on the first access plan, the first query to access the merged column; and
executing, in response to the transforming and the merging, the first query.