On-Demand Database Aggregation via User-Defined Summary Definitions
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems lack flexibility in summarizing data, requiring providers to build-in functionality or customize frameworks, which limits user customization and effective data aggregation.
Innovation Solution
Mechanisms and methods for aggregating on-demand database service data are provided, allowing users to create summary definitions that aggregate child records based on various functions and criteria, enabling enhanced data summarization and display of aggregates in response to user requests.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If conventional database systems use built-in summarization functionality, then data aggregation is achieved, but user customization flexibility is limited
Solution Approach 1:
The system enables users to create their own summary definitions and aggregation functions without requiring built-in pre-defined summarization capabilities. Users can specify custom functions, child records to aggregate, and display formats, allowing the system to adapt to diverse summarization needs through user-defined logic rather than fixed built-in functions.
Solution Approach 2:
The patent implements a universal summarization framework where a single system can support multiple aggregation functions (count, sum, average, min, max) and various display formats through a unified interface. This multi-functional approach allows one system to serve multiple summarization purposes without requiring separate built-in functionalities for each case.
2Ease of operation
If the system provides pre-defined summarization functions, then data aggregation is simplified, but adaptability to custom aggregation needs is reduced
Solution Approach 1:
The system transitions from static pre-defined summarization functions to dynamic user-defined aggregation functions. Users can dynamically specify which child records to aggregate, what functions to apply (count, sum, average, etc.), and how to display results. This dynamic configuration allows the system to adapt to custom aggregation needs while maintaining ease of operation through a standardized input interface.
3Measurement precision
If the system aggregates data in real-time, then data freshness is improved, but processing time and system resources are increased
Solution Approach 1:
The system allows users to pre-define summary definitions and aggregation parameters before actual data aggregation is needed. Users can specify child records, aggregation functions, and display formats in advance, so that when aggregation is executed, the system only needs to process the data according to pre-established rules rather than performing complex real-time calculations. This preliminary configuration reduces processing time while maintaining data freshness.
Data Source
AI summary
In accordance with embodiments, there are provided mechanisms and methods for aggregating on-demand database service data. These mechanisms and methods for aggregating on-demand database service data can enable embodiments to more flexibly summarize data. The ability of embodiments to provide such feature may lead to enhanced aggregation features which may be used for providing more effective ways of summarizing data.