| CPC G06F 16/284 (2019.01) [G06F 16/2282 (2019.01); G06F 16/24532 (2019.01); G06F 16/24542 (2019.01); G06F 16/2455 (2019.01); G06F 16/24552 (2019.01)] | 20 Claims |
|
1. A method for execution by a database system, comprising:
receiving a query expression indicating a query for execution against at least one relational database table; and
executing the query based on:
identifying a plurality of required binomial coefficient values required for generating a set of output values for the query based on a configured non-integer numeric value included in the query expression;
utilizing a thread pool of the database system to generate the plurality of required binomial coefficient values as a function of the configured non-integer numeric value via a plurality of parallelized threads of the thread pool, wherein each of the plurality of parallelized threads generates a corresponding subset of the plurality of required binomial coefficient values in parallel with other ones of the plurality of parallelized threads generating other corresponding subsets of the plurality of required binomial coefficient values;
storing the plurality of required binomial coefficient values in cache memory resources; and
generating the set of output values, wherein generating each output value of the set of output values is based on:
identifying a subset of the plurality of required binomial coefficient values for generating the each output value;
accessing the subset of the plurality of required binomial coefficient values in the cache memory resources, wherein the each output value is generated as a function of the subset of the plurality of required binomial coefficient values;
generating a query resultant for the query based on the set of output values; and
removing the plurality of required binomial coefficient values from the cache memory resources based on completing execution of the query.
|