US 6,983,291 B1
Incremental maintenance of aggregated and join summary tables
Roberta Jo Cochrane, Los Gatos, Calif. (US); Mir Hamid Pirahesh, San Jose, Calif. (US); and Richard Sefton Sidle, Mountain View, Calif. (US)
Assigned to International Business Machines Corporation, Armonk, N.Y. (US)
Filed on May 16, 2000, as Appl. No. 9/571,554.
Claims priority of provisional application 60/135277, filed on May 21, 1999.
Int. Cl. G06F 17/30 (2006.01)
U.S. Cl. 707—200 87 Claims
OG exemplary drawing
 
1. A method of incrementally maintaining a summary table derived from a plurality of base tables in a database stored on the computer, the method comprising:
(a) applying a plurality of modifications to the base tables; and
(b) propagating the applied modifications to the summary table, wherein the propagated modifications include an associated tag column containing a tag value, and the tag value indicates how many rows are to be added or deleted from the summary table.