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

Claim 13:
14. A computer-implemented method for enhancing automatic multidimensional query processing comprising:
executing a database query comprising:
semi-joining a plurality of dimension tables with a fact table;
identifying 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;
generating 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;
merging the plurality of RID lists, thereby defining a plurality of RIDs;
sorting, subject to the merging, the plurality of RIDs as a function of data location; and
fetching the plurality of data values from the fact table.