Patent · US Expired

Incremental maintenance of aggregated and join summary tables

US6983291B1 · kind B1 · utility

78Cited by
26References
87Claims
0Family size

Assignee

Inventors

Key dates

Filing dateMay 16, 2000
Grant dateJan 3, 2006
Priority date
Expiry dateMay 16, 2020

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F16/24556
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

A method, apparatus, and article of manufacture for incrementally maintaining a summary table derived from a plurality of base tables in a database stored on the computer. A plurality of modifications are applied to the base tables, and the applied modifications are then propagated to the summary table. The propagated modifications include an associated tag column containing a tag value, and the tag value indicates per row of the propagated modifications how many rows are to be added to or deleted from the summary table.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.