Grouping and regrouping using aggregation
First Claim
Patent Images
1. A system for grouping and regrouping data using aggregation, comprising:
- a grouping module for grouping data into at least one group instance, wherein the grouping module groups the data using at least one grouping expression; and
a regrouping module for regrouping the at least one group instance, wherein the regrouping module regroups the at least one group instance on a group instance by group instance basis into at least one regrouped group instance, using the at least one regrouping expression.
2 Assignments
0 Petitions
Accused Products
Abstract
Grouping and regrouping of data using aggregation is disclosed. In one aspect of this disclosure, data can be grouped based on some expressions, and then this result can be regrouped based on other expressions which may utilize aggregates computed in the context of the first group. Such regrouping is performed on a group basis—as opposed to being regrouped, for example, on a row basis. The grouping and regrouping can employ various logical expressions that may incorporate the aggregates. Moreover, regrouping of regrouping can be performed, and the mentioned logical expressions can be based on groups of various scopes.
-
Citations
20 Claims
-
1. A system for grouping and regrouping data using aggregation, comprising:
-
a grouping module for grouping data into at least one group instance, wherein the grouping module groups the data using at least one grouping expression; and
a regrouping module for regrouping the at least one group instance, wherein the regrouping module regroups the at least one group instance on a group instance by group instance basis into at least one regrouped group instance, using the at least one regrouping expression. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method for grouping and regrouping data in a database using aggregation, comprising:
-
grouping a first data into a first group in order to configure the first group into a first data set on which a first aggregate function can be performed;
grouping a second data into a second group in order to configure the second group into a second data set on which a second aggregate function can be performed;
performing the first aggregate function on the first data set;
performing the second aggregate function on the second data set; and
regrouping at least one of the first group and the second group into a third group, wherein the third group is formed based on one of the first group and the second group. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer readable medium bearing executable instructions for grouping and regrouping data in a database using aggregation, comprising:
-
grouping data into a first group;
aggregating the first group; and
regrouping the first group into a second group, wherein the regrouping uses a regrouping expression. - View Dependent Claims (18, 19, 20)
-
Specification