Aggregating data with complex operations

摘要

A method, software and system for aggregating data. The method includes accepting a first data set (302), the first data set including records, each record holding a value for each of a plurality of fields; generating a Cartesian product (306) of records of the first data set and a first plurality of key sets (304), each key set representing a subset of the fields of the first data set; generating a second data set (310) 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 have matching values in a subset of fields associated with the aggregated record; generating a third data set (318) 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.