Query execution using materialized tables

A method comprising:

• retrieving, by at least one hardware processor, a plurality of materialized tables (MTs), each MT of the plurality of MTs including a lag duration and referring to a corresponding base table of a plurality of base tables, the lag duration indicating a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance;
• determining a plurality of time instances for the MT based on the lag duration and a number of prior refreshes of the corresponding base table;
• determining a plurality of aligned time instances for the plurality of MTs based on the plurality of time instances for each MT of the plurality of MTs;
• and
• scheduling refresh operations for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period indicated by the lag duration associated with each of the plurality MTs.

A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• retrieving a plurality of materialized tables (MTs), each MT of the plurality of MTs including a lag duration and referring to a corresponding base table of a plurality of base tables, the lag duration indicating a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance;
• determining a plurality of time instances for the MT based on the lag duration and a number of prior refreshes of the corresponding base table;
• determining a plurality of aligned time instances for the plurality of MTs based on the plurality of time instances for each MT of the plurality of MTs;
• and
• scheduling refresh operations for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period indicated by the lag duration associated with each of the plurality MTs.