Methods and systems for multi-dimensional aggregation using composition
Multi-dimensional aggregation using user interface workflow composition is described. Data for a computer implemented process is in a set of related data objects in a data store with each object in the set of related data objects representing an entity modelled in the process. A number of levels for a multi-dimensional aggregation associated with a request is determined where each level of the multi-dimensional aggregation represents a different dimension of data values to be aggregated. Data is aggregated at the levels of aggregation based on the relationships between parent objects and children objects. The data for a final level of aggregation is output to a user interface. The final result includes multiple dimensions of data.
1. A system for multi-dimensional aggregation comprising:
a processor;
a non-transitory, computer-readable medium storing a set of instructions executable by the processor, wherein the set of instructions include instructions for:
storing data for a computer implemented process in a set of related data objects in a data store, each object in the set of related data objects representing an entity modelled in the process;
receiving a request generated responsive to a user interaction in a user interface of a workflow composition tool during workflow composition, the user interaction including user selection of a set of parent objects each having a set of children objects and user selection of an aggregation function to apply a multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects, the user-selected aggregation function selected by the user from a plurality of aggregation functions selectable from the user interface;
determining a number of levels for the multi-dimensional aggregation associated with the request, each level of the multi-dimensional aggregation representing a different dimension of data values to be aggregated,
wherein the multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects to be applied is configured for:
for each parent object in the set of parent objects:
retrieving children object data for a first level of multi-level aggregation for a related set of children objects related to that parent object,
aggregating the children object data to generate aggregated children object data for that parent object, and
outputting the aggregated children object data for use in a second level of multi-dimensional aggregation;
for the second level of multi-dimensional aggregation:
applying the user-selected aggregation function to parent object data from the set of parent objects to generate a data value for a first dimension of the multi-dimensional aggregation, and
applying the user-selected aggregation function using the aggregated children object data for each parent object to generate a data value for a second dimension of the multi-dimensional aggregation to generate a final result; and
outputting the final result to the user interface, the final result including multiple dimensions of data values.
2. The system of claim 1 , wherein the user interface is a drag and drop interface of the workflow composition tool that allows the user to drag a representation of the user-selected aggregation function from a list of aggregations functions into a work area, wherein the user interaction comprises a user dragging the representation of the user-selected aggregation function into the work area.
3. The system of claim 1 , wherein receiving the request comprises receiving the request at a server from a processor-based client application and wherein outputting the final result to the user interface comprises sending the final result from the server to the processor-based client application.
4. The system of claim 1 , wherein the set of instructions further comprises instructions for periodically determining whether aggregation is complete for each level of the multi-dimensional aggregation and outputting the final result to the user interface responsive to a determination that aggregation is complete for each level of the multi-dimensional aggregation.
5. The system of claim 1 , further comprising a computer memory coupled to the processor and a database, wherein aggregating the data for the related set of children objects to generate the aggregated children object data for each parent object comprises inserting the data for the related set of children objects in an instance table in the computer memory to enable aggregating the data for the related set of children objects, and wherein the set of instructions comprises instructions for storing the aggregated children object data in the database for use in a next level of the multi-dimensional aggregation.
6. The system of claim 1 , wherein retrieving data for the first level of multi-level aggregation from the related set of children objects comprises retrieving non-aggregated data from a data source table.
7. The system of claim 1 , wherein aggregating the data from the related set of children objects to generate the aggregated children object data for each parent object comprises applying a different function than the user-selected aggregation function.
8. The system of claim 1 , wherein outputting the final result to the user interface comprises creating a data source that has a list entity names, a list of fields, computed column definitions, aggregation field definitions, and structured query language statements for data retrieval.
9. The system of claim 1 , wherein the selectable plurality of aggregation functions comprises a counting function, a summing function, and an averaging function.
10. A computer program product comprising a non-transitory, computer-readable medium storing a set of instructions executable by a processor, wherein the set of instructions include instructions for:
accessing data for a computer implemented process from a set of related data objects in a data store, each object in the set of related data objects representing an entity modelled in the process;
receiving a request generated responsive to a user interaction in a user interface of a workflow composition tool during workflow composition, the user interaction including user selection of a set of parent objects each having a set of children objects and user selection of an aggregation function to apply a multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects, the user-selected aggregation function selected by the user from a plurality of aggregation functions selectable from the user interface;
determining a number of levels for the multi-dimensional aggregation associated with the request, each level of the multi-dimensional aggregation representing a different dimension of data values to be aggregated,
wherein the multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects to be applied is configured for:
for each parent object in the set of parent objects:
retrieving children object data for a first level of multi-level aggregation for a related set of children objects related to that parent object,
aggregating the children object data to generate aggregated children object data for that parent object,
and outputting the aggregated children object data for use in a second level of multi-dimensional aggregation;
for the second level of multi-dimensional aggregation:
applying the user-selected aggregation function to parent object data from the set of parent objects to generate a data value for a first dimension of the multi-dimensional aggregation, and
applying the user-selected aggregation function using the aggregated children object data for each parent object to generate a data value for a second dimension of the multi-dimensional aggregation to generate a final result; and
outputting the final result to the user interface, the final result including multiple dimensions of data values.
11. The computer program product of claim 10 , wherein the user interface is a drag and drop interface of the workflow composition tool that allows the user to drag a representation of the user-selected aggregation function from a list of aggregations functions into a work area, wherein the user interaction comprises a user dragging the representation of the user-selected aggregation function into the work area.
12. The computer program product of claim 10 , wherein receiving the request comprises receiving the request at a server from a processor-based client application and wherein outputting the final result to the user interface comprises sending the final result from the server to the processor-based client application.
13. The computer program product of claim 10 , wherein the set of instructions further comprises instructions for periodically determining whether aggregation is complete for each level of the multi-dimensional aggregation and outputting the final result to the user interface responsive to a determination that aggregation is complete for each level of the multi-dimensional aggregation.
14. The computer program product of claim 10 , wherein aggregating the data for the related set of children objects to generate the aggregated children object data for each parent object comprises inserting the data for the related set of children objects in an instance table in a computer memory that is coupled to the processor, to enable aggregating the data for the related set of children objects, and wherein the set of instructions comprises instructions for storing the aggregated children object data in a database for use in a next level of the multi-dimensional aggregation.
15. The computer program product of claim 10 , wherein retrieving data for the first level of multi-level aggregation from the related set of children objects comprises retrieving non-aggregated data from a data source table.
16. The computer program product of claim 10 , wherein aggregating the data from the related set of children objects to generate the aggregated children object data for each parent object comprises applying a different function than the user-selected aggregation function.
17. The computer program product of claim 10 , wherein outputting the final result to the user interface comprises creating a data source that has a list of entity names, a list of fields, computed column definitions, aggregation field definitions, and structured query language statements for data retrieval.
18. The computer program product of claim 10 , wherein the selectable plurality of aggregation functions comprises a counting function, a summing function, and an averaging function.
19. A computer-implemented method for multi-dimensional data aggregation using workflow composition, the method comprising:
accessing data for a computer implemented process from a set of related data objects in a data store, each object in the set of related data objects representing an entity modelled in the process;
receiving a request generated responsive to a user interaction in a user interface of a workflow composition tool during workflow composition, the user interaction including user selection of a set of parent objects each having a set of children objects and user selection of an aggregation function to apply a multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects, the user-selected aggregation function selected by the user from a plurality of aggregation functions selectable from the user interface;
determining a number of levels for the multi-dimensional aggregation associated with the request, each level of the multi-dimensional aggregation representing a different dimension of data values to be aggregated,
wherein the multi-dimensional aggregation of data from the set of the user-selected parent objects and the set of children objects to be applied is configured for:
for each parent object in the set of parent objects:
retrieving children object data for a first level of multi-level aggregation for a related set of children objects related to that parent object,
aggregating the children object data to generate aggregated children object data for that parent object, and
outputting the aggregated children object data for use in a second level of multi-dimensional aggregation;
for the second level of multi-dimensional aggregation:
applying the user-selected aggregation function to parent object data from the set of parent objects to generate a data value for a first dimension of the multi-dimensional aggregation, and
applying the user-selected aggregation function using the aggregated children object data for each parent object to generate a data value for a second dimension of the multi-dimensional aggregation to generate a final result; and
outputting the final result to the user interface, the final result including multiple dimensions of data values.
20. The method of claim 19 , wherein the user interface is a drag and drop interface of the workflow composition tool that allows the user to drag a representation of the user-selected aggregation function from a list of aggregation functions into a work area, wherein the user interaction comprises a user dragging the representation of the user-selected aggregation function into the work area.
21. The method of claim 19 , wherein receiving the request comprises receiving the request at a server from a processor-based client application and wherein outputting the final result to the user interface comprises sending the final result from the server to the processor-based client application.
22. The method of claim 19 , further comprising:
periodically determining whether aggregation is complete for each level of the multi-dimensional aggregation and outputting the final result to the user interface responsive to a determination that aggregation is complete for each level of the multi-dimensional aggregation.
23. The method of claim 19 , wherein aggregating the data for the related set of children objects to generate the aggregated children object data for each parent object comprises inserting the data for the related set of children objects in an instance table in a computer memory that is coupled to the processor, to enable aggregating the data for the related set of children objects, and wherein the set of instructions comprises instructions for storing the aggregated children object data in a database for use in a next level of the multi-dimensional aggregation.
24. The method of claim 19 , wherein retrieving data for the first level of multi-level aggregation from the related set of children objects comprises retrieving non-aggregated data from a data source table.
25. The method of claim 19 , wherein aggregating the data from the related set of children objects to generate the aggregated children object data for each parent object comprises applying a different function than the user-selected aggregation function.
26. The method of claim 19 , wherein outputting the final result to the user interface comprises creating a data source that has a list of entity names, a list of fields, computed column definitions, aggregation field definitions, and structured query language statements for data retrieval.
27. The computer-implemented method of claim 19 , wherein the selectable plurality of aggregation functions comprises a counting function, a summing function, and an averaging function.