Framework for numa affinitized parallel query on in-memory objects within the rdbms

One or more non-transitory storage media storing instructions which, when executed by one or more processors, cause performance of:

• for each non-uniform memory access (NUMA) node of a plurality of NUMA nodes, storing, in volatile memory associated with the NUMA node, one or more in-memory chunks of an in-memory object;
• wherein the plurality of NUMA nodes includes a particular NUMA node;
• in response to receiving a query, performing the steps of:
• determining a particular set of NUMA nodes, of the plurality of NUMA nodes, that store in-memory chunks, of the in-memory object, that contain data required to process the query;
• wherein the particular set of NUMA nodes includes the particular NUMA node;
• for each respective NUMA node in the particular set of NUMA nodes, assigning a set of one or more processes associated with the respective NUMA node to operate on a distinct cluster of in-memory chunks, of the in-memory object, that are stored in the volatile memory of the respective NUMA node and contain data required to process the query;
• and
• wherein the step of assigning includes assigning a particular set of one or more processes associated with the particular NUMA node to operate on a particular cluster of in-memory chunks, of the in-memory object, that:
• are stored in the volatile memory of the particular NUMA node and contain data required to process the query.