Adaptive Formula Generation for Dynamic Data Updates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Cloud-based software systems fail to automatically adjust auto-populated data fields when source data in a database is modified, requiring additional resources for monitoring and maintenance, as these systems are only active during initial population and do not adapt to changes in the data.
Innovation Solution
A system that generates adaptive 'smart' formulas and efficient formula suggestions by example, allowing users to input data strings that automatically propagate and update across related data cells, enabling automatic recalculation of values based on changes in source data, and providing users with the ability to learn and customize formulas.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Extent of automation
If traditional auto-populate features are used, then initial data population is automated, but the system cannot automatically adjust when source data is modified
Solution Approach 1:
The patent implements dynamic formula suggestions that automatically detect and adapt to changes in source data. The system continuously monitors source data modifications and dynamically updates target data fields accordingly, transforming the static auto-populate feature into a dynamic system that responds to data changes in real-time.
Solution Approach 2:
The system incorporates feedback mechanisms by detecting changes in source data and using this information to automatically update target fields. The formula suggestion system receives feedback from source data modifications and adjusts its recommendations and automatic population accordingly, creating a closed-loop system that adapts to changing conditions.
2Reliability
If manual monitoring and editing of data fields is performed, then data accuracy is maintained, but additional resources and time are required
Solution Approach 1:
The system implements self-service functionality by automatically detecting source data changes and updating target data fields without requiring manual intervention. The formula suggestion system autonomously monitors data changes, recalculates values, and propagates updates throughout the dataset, eliminating the need for manual monitoring and editing while maintaining data accuracy.
Solution Approach 2:
The patent enables continuous automatic updates of data fields by establishing persistent formula connections between source and target data. The system continuously monitors for changes and automatically propagates updates, ensuring that data accuracy is maintained over time without periodic manual intervention, thus eliminating time loss associated with repetitive monitoring tasks.
3Adaptability or versatility
If comprehensive formula suggestions are provided, then user customization capability is enhanced, but system complexity increases
Solution Approach 1:
The system provides partial formula suggestions by offering only the most relevant and commonly used formula options based on the detected data patterns and user needs. Rather than presenting all possible formulas, the system selectively suggests the most appropriate ones, reducing the perceived complexity while maintaining customization capability. Users can request additional options if needed.
Data Source
AI summary
A system includes an interface configured to receive a user input string for a data cell and a processor configured to: determine a lexicon from data related to the data cell; determine an efficient formula from the lexicon; and provide the efficient formula to a formula cell. The system further includes a memory coupled to the processor and configured to provide the processor with instructions.