Methods and systems for multi-dimensional aggregation using composition

A computer-implemented method for multi-dimensional aggregation using user interface workflow composition, the method comprising:

• responding to a client request by:
• determining a number of levels of a multi-dimension aggregation required based on the client request;
• determining, on a periodic basis, whether aggregation is complete for all determined levels of the multi-dimension aggregation beginning with a first level and ending with a final level, each of the dimensions of the multi-dimension aggregation corresponding to a different attribute, the aggregation being complete for each level when at least one parent object for the each level has been aggregated and a plurality of children objects for the each level, that are associated with the at least one parent object for the each level, in a hierarchical parent-child relationship for the each level, have been aggregated for the each level;
• retrieving first level parent object data associated with the at least one first level parent object and first level children object data associated with a plurality of first level children objects for the first level in response to a determination that aggregation is not complete for each level of the multi-dimension aggregation;
• aggregating the retrieved first level parent object data and the retrieved first level children object data of the first level, the aggregating including storing the retrieved first level children object data in instance tables in computer memory, and aggregating the retrieved first level children object data in the in-memory instance tables;
• storing, in an aggregation table, the aggregated first level parent object data and the aggregated first level children object data for the first level as input for a next level of the multi-dimension aggregation;
• repeating the steps of determining, retrieving, aggregating and storing for each level from the first level through the final level until the aggregation is complete for the final level of the multi-dimension aggregation;
• and
• outputting final level aggregated parent object data and final level aggregated children object data for the final level to a user interface, the final level aggregated parent object data for the final level based on an application of an aggregation function to the respective aggregated parent object data for each level from the first level to a penultimate level and the final level aggregated children object data for the final level based on an application of the aggregation function to the respective aggregated children object data for each level from the first level to the penultimate level, wherein the client request is a single query.

A non-transitory computer-readable medium storing computer-readable program code to be executed by one or more processors, the program code including instructions to:

• determine a number of levels of a multi-dimension aggregation required based on a request for the multi-dimension aggregation, wherein the request is a single query;
• determine, on a periodic basis, whether aggregation is complete for all determined levels of the multi-dimension aggregation beginning with a first level and ending with a final level, each of the dimensions of the multi-dimension aggregation corresponding to a different attribute, the aggregation being complete for each level when at least one parent object for the each level has been aggregated and a plurality of children objects for the each level, that are associated with the at least one parent object for the each level, in a hierarchical parent-child relationship for the each level, have been aggregated for the each level;
• retrieve first level parent object data associated with at least one first level parent object and first level children object data associated with a plurality of first level children objects for the first level in response to a determination that aggregation is not complete for each level of the multi-dimension aggregation;
• aggregate the retrieved first level parent object data and the retrieved first level children object data of the first level, the aggregating including storing the retrieved first level children object data in instance tables in computer memory, and aggregating the retrieved first level children object data in the in-memory instance tables;
• store, in an aggregation table, the aggregated first level parent object data and the aggregated first level children object data for the first level as input for a next level of the multi-dimension aggregation;
• repeat the steps of determining, retrieving, aggregating and storing for each level from the first level through the final level until the aggregation is complete for the final level of the multi-dimension aggregation;
• and
• output final level aggregated parent object data and final level aggregated children object data for the final level to a user interface, the final level aggregated parent object data for the final level based on an application of an aggregation function to the respective aggregated parent object data for each level from the first level to a penultimate level and the final level aggregated children object data for the final level based on an application of the aggregation function to the respective aggregated children object data for each level from the first level to the penultimate level.