Patent ID: 11868340
Assignee: AT&T INTELLECTUAL PROPERTY I, L.P.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 12:
13. A non-transitory machine-readable medium, comprising executable instructions that, when executed by a processor of a device, facilitate performance of operations, comprising:
determining that a materialized view, representative of a stored query of a database system, has produced a derived table that stores derived table data derived from a source table that stores source table data;
creating an update log representative of first updates to the source table;
creating a progress log representative of second updates to the derived table resulting from the first updates;
determining an invertible relationship between a source table timestamp field and a derived table timestamp field; and
performing an update propagation procedure that determines a derived time range of the derived table to recomputed in response to an update to the source table data, the update propagation procedure comprising:
converting, based on the invertible relationship, a lower limit timestamp of the update to a lower limit time of the derived time range;
converting, based on the invertible relationship, an upper limit timestamp of the update to an upper limit time of the derived time range; and;
performing a recompute procedure that recomputes the derived time range of the derived table.