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

Claim 0:
1. A device, comprising:
a processor; and
a memory that stores executable instructions that, when executed by the processor, facilitate performance of operations, the 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;
generating an update log representative of a first history of first updates to the source table;
generating a progress log representative of a second history of second updates to the derived table resulting from the first updates that have been processed;
determining a relationship between a source table timestamp field and a derived table timestamp field; and
in response to a determination that an update has occurred to the source table data, performing an update propagation procedure that determines a portion of the derived table to be recomputed in response to the update to the source table data, the update propagation procedure comprising:
performing a coalesce procedure that combines the update with other updates to the source table data, resulting in a coalesced update;
converting, based on the relationship, a minimum timestamp of the coalesced update to a minimum time, and a maximum timestamp of the coalesced update to a maximum time; and
performing a recompute procedure that recomputes the portion of the derived table having timestamps between the minimum time and the maximum time.