Patent ID: 7933867

Claim:
A database system comprising: processors; a storage subsystem having plural storage modules to store respective portions of a view containing results of a cube-based operation on at least one base table, the view containing a first result set for a group-by on a first grouping set, and a second result set for a group-by on a second grouping set, wherein the second grouping set has less attributes than the first grouping set; and database software executable on the processors and having plural access modules that provide parallel access of data in the plural storage modules, wherein the database software executable on the processors is configured to: distribute the portions of the view across the plural storage modules based on hash values computed by hashing plural attributes specified by a function defining the view; in response to a change to the at least one base table: update the first result set by computing a change to the first result set based on the change in the at least one base table; distribute rows of the change to the first result set across the plural storage modules based on hash values computed by hashing the attributes of the second grouping set and at least one other attribute that is part of the first grouping set but not the second grouping set, wherein the at least one other attribute is assigned a predefined value used by said database software executable to perform the hashing of the attributes of the second grouping set and the at least one other attribute; and update the second result set by computing a change to the second result set based on the distributed rows of the change to the first result set.