Patent ID: 7110999
Filing Date: 2006-09-19
Classification: G06F,Y10S

Abstract:
1. A computer-implemented method for incrementally maintaining pre-computed aggregate views, comprising: receiving a pre-computed aggregate view derived from one or more base tables in a database, the pre-computed aggregate view including a pre-computed aggregate table and a view definition, the view definition including aggregation functions that include a combination of sum, sum distinct, count(*), count, count distinct, min, and max, the view definition further including expressions that are capable of being nullable; receiving changes to the one or more base tables, the changes being represented as insertions and deletions to rows of the one or more base tables and being non-minimal; tagging the insertions and deletions with distinguishing literals in an additional column and combining the tagged insertions and deletions to define a first result set; and defining a second result set from the first result set, wherein each row shows, for each aggregation function in the view definition, contributions from changes that are insertions and contributions from changes that are deletions, and wherein generating a second result set includes setting conditional expressions in an aggregation function such that contributions from changes that are insertions and contributions from changes that are deletions are distinguishable.