Autonomous Column Selection for Columnar Cache

A computer-implemented method, comprising:

• receiving, by a system comprising one or more processors, a query specifying one or more groups of data along a first dimension of the plurality of dimensions;
• processing, by the system, the query to retrieve the one or more groups of data specified in the query, from one or both of a database cache and one or more storage devices of the system, one or both of the database cache and the one or more storage devices storing tables having a plurality of dimensions;
• generating, for the query and by the system, values for one or more performance metrics in processing the query when the one or more groups of data are cached in the database cache;
• and
• loading, by the system, at least a portion of the one or more groups of data specified in the query into the database cache, based on the values of the one or more performance metrics.

One or more non-transitory computer-readable storage media storing instructions that when executed by a system comprising one or more processors, cause the system to perform operations comprising:

• receiving a query specifying one or more groups of data along a first dimension of a plurality of dimensions;
• processing the query to retrieve the one or more groups of data specified in the query, from one or both of a database cache and one or more storage devices storing tables having a plurality of dimensions;
• generating, for the query, values for one or more performance metrics in processing the query when the one or more groups of data are cached in the database cache;
• and
• loading at least a portion of the one or more groups of data specified in the query into the database cache, based on the values of the one or more performance metrics.