Late Materialization of Queried Data in Database Cache

A computer-implemented method, comprising:

• receiving, by one or more processors, a query for data of a database comprising one or more tables, each table of the one or more tables comprising one or more respective attributes, the query referencing a plurality of attributes included in the one or more tables;
• receiving, by the one or more processors, a query execution plan defining an order for executing the query by executing one or more query operations across one or more execution steps;
• determining, by the one or more processors and for each of the one or more query operations, respective one or more of the plurality of attributes needed for executing the query operation;
• and
• in response to receiving the query, executing, by the one or more processors, the one or more query operations according to the query execution plan, wherein at each execution step of the query execution plan, retrieving the respective one or more needed attributes needed for executing a respective query operation during a current execution step from a cache caching a plurality of attributes from the one or more tables.

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

• receiving, a query for data of a database comprising one or more tables, each table comprising one or more respective attributes, the query referencing a plurality of attribute,
• receiving a query execution plan defining an order for executing one or more query operations across one or more execution steps;
• determining, for each of the one or more query operations, respective one or more of the plurality of attributes needed for executing the query operation;
• and
• in response to receiving the query, executing the one or more query operations according to the query execution plan, wherein at each execution step of the query execution plan, retrieving the respective one or more needed attributes needed for executing a respective query operation during a current execution step from a cache caching a plurality of attributes from the one or more tables.