Broadening field specialization

A computer-implemented method to minimize cache pressure using slot pressure profile (SPP)-guided Algorithm, the method comprising:

• generating, in a SPP generation phase, an intermediate SPP from a binary code of a database management system (DBMS);
• receiving, in a SPP processing phase, the generated intermediate SPP obtained in the SPP Generation phase and outputting a reference SPP;
• accepting, in a candidate ordering phase, the reference SPP and producing a candidate slot list related to a cache by sorting the values in the reference SPP;
• deciding, in a slot selection phase, a slot number among the candidate slot list;
• passing the decided slot number, in a bee insertion phase, to find an open memory address mapping to the decided slot number for a bee code, the bee code being a specialized version of a DBMS function created and loaded into the cache at run-time;
• and
• executing, in a query evaluation phase, a query with the bee code using the found open memory address,
• wherein the SPP generation phase further comprising the step of:
• identifying functions that are invoked by operators implemented by the DBMS, preferably wherein dynamic analysis is used at DBMS compile time to provide an estimate of the cache pressure of the identified functions;
• and/or wherein the SPP generation phase further comprising the steps of:
• obtaining a call graph for the DBMS for executing representative workload;
• performing a breadth-first search to identify all functions the query calls;
• for each identified function, generating a per-function binary instruction cache (I-cache) function score SPP;
• adding up the function score SPPs for an operator to yield a per-operator reference I-cache function count SPP;
• and/or
• wherein the SPP generation phase further comprising the steps of:
• generating at DBMS compile time one or more SPPs by assigning weights to a binary SPP;
• and
• collecting a raw SPP over the DBMS executing a workload;
• and/or
• wherein the SPP processing phase, the candidate ordering phase, the slot selection phase, the bee insertion phase and the query evaluation phase all occur with running time of the DBMS;
• and/or
• wherein the SPP processing phase comprises a Binary Function Score Algorithm to infer a cache pressure;
• and/or
• wherein the SPP processing phase comprises a Function Count Algorithm to construct a reference SPP;
• and/or
• wherein the SPP processing phase comprises a MaxResidency Algorithm to give a query plan, wherein the MaxResidency algorithm preferably comprises steps of:
• computing an instruction threshold to identify slots that are accessed enough to potentially incur cache pressure;
• checking a max residency of the identified slots;
• and
• in response to the max residency reaches the instruction threshold of total counts at the identified slot, incrementing an estimated occupancy at this slot by 1, wherein the instruction threshold preferably is a ratio of a residency to a total instruction count at a slot that is considered long enough to occupy a cache line.