Patent ID: 11893020
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 7:
8. A computer program product embodied on at least one computer readable storage medium having computer executable instructions for enhancing automatic multidimensional query processing that when executed cause one or more computing devices 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.