On-demand cache management of derived cache

One or more storage media comprising sequences of instructions, wherein said sequences of instructions, when executed by one or more processors, cause:

• making a determination to load a particular in-memory enabled PF element of a database into a derived cache of a database server, said derived cache caching a plurality of IMCUs;
• responsive to making the determination to load a particular in-memory enabled PF element of a database into a derived cache of a database server:
• determining whether there is least a sufficient amount of available space in the derived cache for said particular in-memory enable PF element;
• if there is at least a sufficient amount of available space in the derived cache for said particular in-memory enable PF element:
• determining whether a particular IMCU of said plurality of IMCUs has a cache benefit value that is less than a cache benefit value of said particular in-memory enabled PF element by at least a threshold;
• if said particular IMCU of said plurality of IMCUs has a cache benefit value that is less than a cache benefit value of said particular in-memory enabled PF element by at least a threshold:
• evicting said particular IMCU from said cache;
• in response to evicting said particular IMCU from said cache,
• loading said particular in-memory enabled PF element into said derived cache.