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

Claim 16:
17. A method, comprising:
determining, by a device comprising a processor, 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;
generating, by the device, an update log representative of first updates to the source table;
generating, by the device, a progress log representative of second updates to the derived table that result from processing of the first updates;
determining, by the device, an invertible relationship between a source table timestamp field and a derived table timestamp field; and
performing, by the device, an update propagation procedure that determines a derived time range of the derived table to recompute in response to an update to the source table data, the update propagation procedure comprising:
converting, by the device, a minimum timestamp of the update to a minimum time of the derived time range based on the invertible relationship;
converting, by the device, a maximum timestamp of the update to a maximum time of the derived time range based on the invertible relationship; and;
performing, by the device, a recompute procedure that recomputes the derived time range of the derived table.