# US 12,613,851 B2 · Method, apparatus, device and medium for processing table data

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 12,613,851 B2
- Document ID: US12613851B2
- Status: Granted
- Kind: B2
- Application number: 18/763,808
- Filed: 2024-07-03
- Published: 2025-01-09
- Granted: 2026-04-28
- Earliest claimed: 2023-07-03
- Assignees: Beijing Zitiao Network Technology Co., Ltd.
- Applicants: Beijing Zitiao Network Technology Co., Ltd.
- Inventors: Zhanhong Luo; Mingtao Luo
- Web page: https://patentgrep.com/patent/US12613851B2

## CPC

- G06F 16/2282: {Tablespace storage structures; Management thereof}
- Y02D 10/00: Energy efficient computing, e.g. low power processors, power management or thermal management
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y02D: CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE

## Abstract

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.

## Claims

### Claim 1

A method for processing table data, comprising:
determining, by a processor coupled to a memory, at least one target field corresponding to a preset data calculation formula;
determining, by the processor and in response to a data modification operation on a target table, a modification field corresponding to the data modification operation;
determining, by the processor, whether the modification field belongs to the at least one target field in a table that is stored in a collaborative database corresponding to the preset data calculation formula; and
determining, by the processor, 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; and
updating a calculation result in the collaborative database,
wherein determining the modification field corresponding to the data modification operation comprises:
determining a first number of field types corresponding to the data modification operation;
determining a second number of field types contained in each record corresponding to the target table; and
determining all fields contained in the each record as the modification field in case that the first number of the field types is greater than or equal to the second number of the field types.

### Claim 2 (depends on 1)

The method of claim 1, wherein determining the at least one target field corresponding to the preset data calculation formula comprises:
determining at least one table identification corresponding to the preset data calculation formula and a first field identification corresponding to each of the table identification;
determining a second field identification in a table corresponding to each of the table identification; and
determining a field corresponding to a successfully matched second field identification as the target field by matching the second field identification with a first field identification of a corresponding table identification.

### Claim 3 (depends on 1)

The method of claim 1, wherein determining the modification field corresponding to the data modification operation comprises:
determining a modification table cell corresponding to the data modification operation; and
determining a field corresponding to the modification table cell as the modification field.

### Claim 4 (depends on 1)

The method of claim 1, wherein before determining whether the modification field belongs to the at least one target field, the method comprises:
building a parent node according to each table corresponding to the preset data calculation formula;
building a child node according to each target field corresponding to the preset data calculation formula; and
building a tree structure corresponding to the parent node and the child node according to a correspondence between tables and target fields corresponding to the preset data calculation formula.

### Claim 5 (depends on 4)

The method of claim 4, wherein determining whether the modification field belongs to the at least one target field comprises:
matching a child node in the tree structure with the modification field, and determining, according to a matching result, whether a target child node corresponding to the modification field exists in the tree structure; and
determining that the modification field belongs to the at least one target field in case that the target child node exists.

### Claim 6 (depends on 1)

The method of claim 1, wherein performing the data recalculation process according to the preset data calculation formula further comprises:
obtaining a modification table cell identification corresponding to the modification field and modified first data;
determining, according to the modification table cell identification, a non-modification table cell identification corresponding to a non-modification field in the preset data calculation formula, and obtaining second data corresponding to the non-modification table cell identification; and
obtaining a recalculated calculation result by calculating the first data and the second data according to the preset data calculation formula.

### Claim 7

An electronic device, comprising:
a processor;
a memory configured to store instructions executable by the processor;
wherein the processor is configured to read the executable instructions from the memory, and the instructions, when executed by the processor, causes the processor to:
determine at least one target field corresponding to a preset data calculation formula;
determine, in response to a data modification operation on a target table, a modification field corresponding to the data modification operation;
determine whether the modification field belongs to the at least one target field in a table that is stored in a collaborative database corresponding to the preset data calculation formula; and
determine 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; and
update a calculation result in the collaborative database,
wherein the instructions causing the processor to determine the modification field corresponding to the data modification operation comprise instructions causing the processor to:
determine a first number of field types corresponding to the data modification operation;
determine a second number of field types contained in each record corresponding to the target table; and
determine all fields contained in the each record as the modification field in case that the first number of the field types is greater than or equal to the second number of the field types.

### Claim 8 (depends on 7)

The device of claim 7, wherein the instructions causing the processor to determine the at least one target field corresponding to the preset data calculation formula comprise instructions causing the processor to:
determine at least one table identification corresponding to the preset data calculation formula and a first field identification corresponding to each of the table identification;
determine a second field identification in a table corresponding to each of the table identification; and
determine a field corresponding to a successfully matched second field identification as the target field by matching the second field identification with a first field identification of a corresponding table identification.

### Claim 9 (depends on 7)

The device of claim 7, wherein the instructions causing the processor to determine the modification field corresponding to the data modification operation comprise instructions causing the processor to:
determine a modification table cell corresponding to the data modification operation; and
determine a field corresponding to the modification table cell as the modification field.

### Claim 10 (depends on 7)

The device of claim 7, wherein before determining whether the modification field belongs to the at least one target field, the instructions further causes the processor to:
build a parent node according to each table corresponding to the preset data calculation formula;
build a child node according to each target field corresponding to the preset data calculation formula; and
build a tree structure corresponding to the parent node and the child node according to a correspondence between tables and target fields corresponding to the preset data calculation formula.

### Claim 11 (depends on 10)

The device of claim 10, wherein the instructions causing the processor to determine whether the modification field belongs to the at least one target field comprise instructions causing the processor to:
match a child node in the tree structure with the modification field, and determine, according to a matching result, whether a target child node corresponding to the modification field exists in the tree structure; and
determine that the modification field belongs to the at least one target field in case that the target child node exists.

### Claim 12 (depends on 7)

The device of claim 7, wherein the instructions causing the processor to perform the data recalculation process according to the preset data calculation formula further comprise instructions causing the processor to:
obtain a modification table cell identification corresponding to the modification field and modified first data;
determine, according to the modification table cell identification, a non-modification table cell identification corresponding to a non-modification field in the preset data calculation formula, and obtain second data corresponding to the non-modification table cell identification; and
obtain a recalculated calculation result by calculating the first data and the second data according to the preset data calculation formula.

### Claim 13

A non-transitory computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, the computer program is configured to:
determine at least one target field corresponding to a preset data calculation formula;
determine, in response to a data modification operation on a target table, a modification field corresponding to the data modification operation;
determine whether the modification field belongs to the at least one target field in a table that is stored in a collaborative database corresponding to the preset data calculation formula; and
determine 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; and
update a calculation result in the collaborative database,
wherein the computer program configured to determine the modification field corresponding to the data modification operation is further configured to:
determine a first number of field types corresponding to the data modification operation;
determine a second number of field types contained in each record corresponding to the target table; and
determine all fields contained in the each record as the modification field in case that the first number of the field types is greater than or equal to the second number of the field types.

### Claim 14 (depends on 13)

The medium of claim 13, wherein the computer program configured to determine the at least one target field corresponding to the preset data calculation formula is further configured to:
determine at least one table identification corresponding to the preset data calculation formula and a first field identification corresponding to each of the table identification;
determine a second field identification in a table corresponding to each of the table identification; and
determine a field corresponding to a successfully matched second field identification as the target field by matching the second field identification with a first field identification of a corresponding table identification.

### Claim 15 (depends on 13)

The medium of claim 13, wherein the computer program configured to determine the modification field corresponding to the data modification operation is further configured to:
determine a modification table cell corresponding to the data modification operation; and
determine a field corresponding to the modification table cell as the modification field.

### Claim 16 (depends on 13)

The medium of claim 13, wherein before determining whether the modification field belongs to the at least one target field, the computer program is further configured to:
build a parent node according to each table corresponding to the preset data calculation formula;
build a child node according to each target field corresponding to the preset data calculation formula; and
build a tree structure corresponding to the parent node and the child node according to a correspondence between tables and target fields corresponding to the preset data calculation formula.

### Claim 17 (depends on 16)

The medium of claim 16, wherein the computer program configured to determine whether the modification field belongs to the at least one target field is further configured to:
match a child node in the tree structure with the modification field, and determine, according to a matching result, whether a target child node corresponding to the modification field exists in the tree structure; and
determine that the modification field belongs to the at least one target field in case that the target child node exists.
