US 11,893,020 B2
Enhancing database query processing
Sheng Yan Sun, Beijing (CN); Xiaobo Wang, Beijing (CN); Hong Mei Zhang, Beijing (CN); and Shuo Li, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Jan. 7, 2022, as Appl. No. 17/647,402.
Prior Publication US 2023/0222124 A1, Jul. 13, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/24544 (2019.01) [G06F 16/2264 (2019.01); G06F 16/24532 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer system for enhancing automatic multidimensional query processing comprising:
one or more processing devices;
one or more memory devices communicatively and operably coupled to the one or more processing devices;
a database query enhancement tool, at least partially resident within the one or more memory devices, configured to execute an enhancement directed toward the automatic multidimensional query processing to execute a database query, the database query enhancement tool configured to:
semi-join a plurality of dimension tables with a fact table;
identify for extraction one or more data values from each dimension table of the plurality of dimension tables, wherein the one or more data values from each dimension table of the plurality of dimension tables are associated with a respective record identification (RID), thereby defining one or more RIDs, a respective dimension table of the plurality of dimension tables for each RID of the one or more RIDs, and a plurality of data values;
generate a plurality of RID lists, wherein each RID list of the plurality of RID lists includes a collection of the one or more RIDs for the respective dimension table;
merge the plurality of RID lists, thereby define a plurality of RIDs;
sort, subject to the merging, the plurality of RIDs as a function of data location; and
fetch the plurality of data values from the fact table.