Table Data Recalculation Using Target Field Matching
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for processing multi-dimensional tables with complex structures require extensive recalculations due to modifications, leading to high computational costs and inefficiencies in determining affected calculation formulas.
Innovation Solution
A method and apparatus for processing table data that identifies target fields corresponding to a preset data calculation formula, determines modification fields, and checks if they belong to the target fields to perform recalculation only when necessary, using a tree structure to efficiently locate affected fields.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If extensive recalculation is performed when data modifications occur in multi-dimensional tables, then data accuracy is maintained, but computational costs increase significantly
Solution Approach 1:
The patent segments the recalculation process by identifying and isolating only the specific fields affected by data modifications. Instead of recalculating all fields in multi-dimensional tables, the system divides the calculation scope into affected and unaffected portions, performing recalculation only on segmented affected fields. This resolves the contradiction by maintaining data accuracy through targeted recalculation while reducing computational costs by excluding unrelated fields.
Solution Approach 2:
The patent applies local quality by implementing field-level granularity in recalculation operations. The system identifies modification fields at the field level and applies recalculation only to those specific locations where changes occurred, rather than applying uniform recalculation across the entire table structure. This localized approach preserves data accuracy where needed while minimizing unnecessary computational expenditure in unaffected areas.
2Reliability
If all cells associated with calculation formulas are matched with modified table cells, then complete data consistency is achieved, but recalculation efficiency decreases
Solution Approach 1:
The patent extracts and identifies only the modification fields from the set of all fields in multi-dimensional tables. When data modifications occur, the system takes out the specific modified fields for recalculation consideration, excluding all other unchanged fields from the recalculation process. This extraction approach ensures data consistency for modified fields while dramatically improving recalculation efficiency by eliminating unnecessary processing of unrelated fields.
Solution Approach 2:
The patent implements partial action by performing recalculation only on the subset of fields that are actually affected by modifications, rather than applying excessive recalculation to all fields. The system determines the minimal necessary recalculation scope by comparing modification fields with target fields associated with calculation formulas, executing recalculation only where partially needed. This partial approach maintains sufficient data consistency while optimizing recalculation efficiency.
Data Source
AI summary
Embodiments of the present disclosure relate to processing method, apparatus, device and medium for data table. The method comprises: determining at least one target field corresponding to a preset data calculation formula; determining, in response to a data modification operation on a target table, a modification field corresponding to the data modification operation; determining whether the modification field belongs to the at least one target field; and determining that the preset data calculation formula meets a preset recalculation condition in case that the modification field belongs to the at least one target field, so as to perform a data recalculation process according to the preset data calculation formula.


