Table Data Recalculation Using Target Field Matching

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improvedata accuracyVSAvoidcomputational cost
Core Design Contradiction:
ReliabilityVSUse of energy by moving object

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.

Inventive Principle:
Principle #1Segmentation

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.

Inventive Principle:
Principle #3Local quality

2Reliability

If all cells associated with calculation formulas are matched with modified table cells, then complete data consistency is achieved, but recalculation efficiency decreases

Engineering Contradiction:
Improvedata consistencyVSAvoidrecalculation efficiency
Core Design Contradiction:
ReliabilityVSProductivity

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.

Inventive Principle:
Principle #2Taking out (Extraction)

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.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS12613851B2Method, apparatus, device and medium for processing table data
Publication Date: 2026.04.28 BEIJING ZITIAO NETWORK TECH CO LTD
  • US12613851B2 patent drawing
  • US12613851B2 patent drawing
  • US12613851B2 patent drawing

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.