Multi-Dimensional Aggregation Workflow Engine
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Calculating aggregate function attributes for one parent and multiple children objects in a single query is difficult, especially for users unfamiliar with structured query languages, often requiring multiple complex queries.
Innovation Solution
A system for multi-dimensional aggregation using user interface workflow composition, where a data source engine determines aggregation completeness at each level, retrieves and aggregates data, and outputs results to a user interface, simplifying the process by breaking down aggregation into levels and applying functions like summing and averaging correctly across parent and child objects.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users calculate aggregate function attributes for one parent and multiple children objects using traditional query methods, then accurate aggregation results can be obtained, but the process requires multiple complex queries and is difficult for users unfamiliar with structured query languages
Solution Approach 1:
The patent introduces an intermediary component (aggregation service or workflow engine) that mediates between the user and the complex aggregation operations. This intermediary automatically generates and executes the necessary queries, manages the aggregation logic, and returns results, thereby shielding users from the complexity of structured query languages while maintaining accurate aggregation results
2Productivity
If users perform aggregation calculations manually or through multiple queries, then comprehensive data can be retrieved, but the process is time-consuming and inefficient
Solution Approach 1:
The patent implements preliminary action by pre-defining aggregation templates, workflows, and calculation logic that can be reused across multiple aggregation operations. The system prepares and caches aggregation rules, data relationships, and computation patterns in advance, enabling rapid execution of aggregation queries without requiring users to manually construct complex queries each time, thereby significantly improving productivity and reducing time loss
Data Source
AI summary
Multi-dimensional aggregation using user interface workflow composition is described. A determination is made whether aggregation is complete for each level of a multi-dimension aggregation. Data is retrieved for a level of aggregation in response to a determination that aggregation is not complete for each level of the multi-dimension aggregation. The data is aggregating based on the level of aggregation. The aggregated data is stored for a next level of aggregation. The data for a final level of aggregation is output to a user interface in response to a determination that aggregation is complete for each level of the multi-dimension aggregation.