Aggregating data with complex operations

A computer-readable storage medium including instructions for causing a computer system to:

• accept a first data set, the first data set including records, each record holding a value for each of a plurality of fields;
• generate a second data set from the first data set, the second data set including one or more aggregated records, each aggregated record of the second data set corresponding to one or more records from the first data set that match values in a subset of fields associated with that aggregated record;
• and
• generate a third data set from the second data set, the third data set including one or more aggregated records, each aggregated record of the third data set corresponding to one or more aggregated records of the first data set that match values in a subset of fields associated with that aggregated record of the third data set;
• wherein an aggregate value associated with an aggregated record in the third data set represents a result of performing a computation based on a non-cascadable operation on values associated with a plurality of records from the first data set.

A system for aggregating data, including:

• means for accepting a first data set, the first data set including records, each record holding a value for each of a plurality of fields;
• means for generating a second data set from the first data set, the second data set including one or more aggregated records, each aggregated record of the second data set corresponding to one or more records from the first data set that match values in a subset of fields associated with that aggregated record;
• and
• means for generating a third data set from the second data set, the third data set including one or more aggregated records, each aggregated record of the third data set corresponding to one or more aggregated records of the first data set that match values in a subset of fields associated with that aggregated record of the third data set;
• wherein an aggregate value associated with an aggregated record in the third data set represents a result of performing a computation based on a non-cascadable operation on values associated with a plurality of records from the first data set.

A method for aggregating data, including:

• accepting a first data set, the first data set including records, each record holding a value for each of a plurality of fields;
• generating a Cartesian product of records of the first data set and a first plurality of key sets, each key set representing a subset of the fields of the first data set;
• generating a second data set from the generated Cartesian product, the second data set including one or more aggregated records, each aggregated record corresponding to one or more records from the first data set that match values in a subset of fields associated with the aggregated record;
• generating a third data set from the second data set, the third data set including one or more aggregated records, each aggregated record of the third data set corresponding to one or more aggregated records of the first data set that match values in a subset of fields associated with that aggregated record of the third data set;
• and
• storing the data sets or presenting a result based on the data sets over a user interface.

A computer-readable storage medium including instructions for causing a computer system to:

• accept a first data set, the first data set including records, each record holding a value for each of a plurality of fields;
• generate a Cartesian product of records of the first data set and a first plurality of key sets, each key set representing a subset of the fields of the first data set;
• generate a second data set from the generated Cartesian product, the second data set including one or more aggregated records, each aggregated record corresponding to one or more records from the first data set that match values in a subset of fields associated with the aggregated record;
• and
• generate a third data set from the second data set, the third data set including one or more aggregated records, each aggregated record of the third data set corresponding to one or more aggregated records of the first data set that match values in a subset of fields associated with that aggregated record of the third data set.

A system for aggregating data, including:

• means for accepting a first data set, the first data set including records, each record holding a value for each of a plurality of fields;
• means for generating a Cartesian product of records of the first data set and a first plurality of key sets, each key set representing a subset of the fields of the first data set;
• means for generating a second data set from the generated Cartesian product, the second data set including one or more aggregated records, each aggregated record corresponding to one or more records from the first data set that match values in a subset of fields associated with the aggregated record;
• and
• means for generating a third data set from the second data set, the third data set including one or more aggregated records, each aggregated record of the third data set corresponding to one or more aggregated records of the first data set that match values in a subset of fields associated with that aggregated record of the third data set.