US-20260127359-A1 - TABLE DATA PROCESSING METHOD, ELECTRONIC DEVICE, AND NON-TRANSITORY STORAGE MEDIUM

US20260127359A1US 20260127359 A1US20260127359 A1US 20260127359A1US-20260127359-A1

Abstract

The present disclosure provides a table data processing method, an electronic device and a non-transitory storage medium. The method includes: displaying at least part of records of a first table in a first interface of a client in response to a data access request for the first table input in the client, where the records are rows of data in the first table; and receiving a sub-record editing operation for the first table through the first interface, determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the first table in the first interface according to the hierarchical description data, where the hierarchical description data is used to describe parent-child relationship data corresponding to the sub-record in the first table and a parent record including the sub-record.

Inventors

Xupan LI

Assignees

BEIJING ZITIAO NETWORK TECHNOLOGY CO., LTD.

Dates

Publication Date: 20260507
Application Date: 20251105
Priority Date: 20241107

Claims (20)

1 . A table data processing method, comprising: displaying at least part of records of a first table in a first interface of a client in response to a data access request for the first table input in the client, wherein the records are rows of data in the first table; and receiving a sub-record editing operation for the first table through the first interface, determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the first table in the first interface according to the hierarchical description data, wherein the hierarchical description data is used to describe parent-child relationship data corresponding to sub-record in the first table and a parent record comprising the sub-record.
2 . The table data processing method according to claim 1 , wherein the hierarchical description data comprises first description data and second description data, the first description data is used to describe a subordinate relationship between the sub-record and the parent record to which the sub-record belongs, and the second description data is used to describe a subordinate relationship between the parent record and the sub-record comprised in the parent record.
3 . The table data processing method according to claim 2 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record adding operation, adding first description data corresponding to an added sub-record, and writing description data corresponding to the added sub-record into second description data of a parent record to which the added sub-record belongs.
4 . The table data processing method according to claim 2 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record deleting operation, deleting the first description data corresponding to the added sub-record, and deleting description data corresponding to the added sub-record from second description data of the parent record to which the added sub-record belongs.
5 . The table data processing method according to claim 2 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record adding operation, adding first description data corresponding to an added sub-record, and writing description data corresponding to the added sub-record into second description data of a parent record to which the added sub-record belongs; and in response to that the sub-record editing operation comprises the sub-record deleting operation, deleting the first description data corresponding to the added sub-record, and deleting description data corresponding to the added sub-record from second description data of the parent record to which the added sub-record belongs.
6 . The table data processing method according to claim 2 , wherein the sub-record editing operation comprises a sub-record moving operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: determining the edited sub-record according to the sub-record moving operation, and determining a first parent record to which the edited sub-record belongs before moving and a second parent record to which the edited sub-record belongs after moving; and changing a parent record in first description data corresponding to the edited sub-record from the first parent record to the second parent record, deleting description data corresponding to the edited sub-record from second description data corresponding to the first parent record, and adding description data corresponding to the edited sub-record to second description data corresponding to the second parent record.
7 . The table data processing method according to claim 2 , wherein the hierarchical description data is stored in a form of key-value pairs, the first description data takes an identifier of the sub-record as a key and an identifier of the parent record to which the sub-record belongs as a value, and the second description data takes an identifier of the parent record as a key and identifiers of the sub-record subordinate to the parent record as values.
8 . The table data processing method according to claim 1 , wherein table data corresponding to the data access request is stored in the client, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the first table in the first interface according to the hierarchical description data, comprises: in the client, determining the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation and the table data corresponding to the data access request stored in the client, and updating the display data of the first table in the first interface according to the hierarchical description data determined by the client.
9 . The table data processing method according to claim 8 , wherein after the updating the display data of the first table in the first interface according to the hierarchical description data determined by the client, the method further comprises: in response to that the client receives hierarchical description data corresponding to the edited sub-record sent by a server, updating the hierarchical description data corresponding to the edited sub-record stored in the client according to the hierarchical description data received; and updating the display data of the first table in the first interface according to the hierarchical description data updated in the client.
10 . The table data processing method according to claim 1 , wherein the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: adding a preset identifier to the hierarchical description data corresponding to the edited sub-record stored in the client, and updating the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier.
11 . The table data processing method according to claim 10 , wherein the updating the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier, comprises: sending the sub-record editing operation to a server, so that the server updates the hierarchical description data corresponding to the edited sub-record stored in the server based on the sub-record editing operation; and receiving the hierarchical description data corresponding to the edited sub-record sent by the server, and updating the hierarchical description data corresponding to the edited sub-record stored in the client according to the hierarchical description data received and the preset identifier.
12 . The table data processing method according to claim 1 , wherein the displaying at least part of records of a first table in a first interface of a client in response to a data access request for the first table input at the client, comprises: in response to the data access request for the first table input in the client, obtaining first data corresponding to records requested to be accessed from table data of the first table stored in a server, and caching the first data in the client; and displaying the first table in the first interface of the client according to the first data cached in the client.
13 . An electronic device, comprising: one or more processors; and a storage apparatus, configured to store one or more programs, when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement a table data processing method, wherein the table data processing method comprises: displaying at least part of records of a first table in a first interface of a client in response to a data access request for the first table input in the client, wherein the records are rows of data in the first table; and receiving a sub-record editing operation for the first table through the first interface, determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the first table in the first interface according to the hierarchical description data, wherein the hierarchical description data is used to describe parent-child relationship data corresponding to sub-record in the first table and a parent record comprising the sub-record.
14 . The electronic device according to claim 13 , wherein the hierarchical description data comprises first description data and second description data, the first description data is used to describe a subordinate relationship between the sub-record and the parent record to which the sub-record belongs, and the second description data is used to describe a subordinate relationship between the parent record and the sub-record comprised in the parent record.
15 . The electronic device according to claim 14 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record adding operation, adding first description data corresponding to an added sub-record, and writing description data corresponding to the added sub-record into second description data of a parent record to which the added sub-record belongs.
16 . The electronic device according to claim 14 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record deleting operation, deleting the first description data corresponding to the added sub-record, and deleting description data corresponding to the added sub-record from second description data of the parent record to which the added sub-record belongs.
17 . The electronic device according to claim 14 , wherein the sub-record editing operation comprises at least one selected from a group consisting of a sub-record adding operation and a sub-record deleting operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: in response to that the sub-record editing operation comprises the sub-record adding operation, adding first description data corresponding to an added sub-record, and writing description data corresponding to the added sub-record into second description data of a parent record to which the added sub-record belongs; and in response to that the sub-record editing operation comprises the sub-record deleting operation, deleting the first description data corresponding to the added sub-record, and deleting description data corresponding to the added sub-record from second description data of the parent record to which the added sub-record belongs.
18 . The electronic device according to claim 14 , wherein the sub-record editing operation comprises a sub-record moving operation, and the determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, comprises: determining the edited sub-record according to the sub-record moving operation, and determining a first parent record to which the edited sub-record belongs before moving and a second parent record to which the edited sub-record belongs after moving; and changing a parent record in first description data corresponding to the edited sub-record from the first parent record to the second parent record, deleting description data corresponding to the edited sub-record from second description data corresponding to the first parent record, and adding description data corresponding to the edited sub-record to second description data corresponding to the second parent record.
19 . The electronic device according to claim 14 , wherein the hierarchical description data is stored in a form of key-value pairs, the first description data takes an identifier of the sub-record as a key and an identifier of the parent record to which the sub-record belongs as a value, and the second description data takes an identifier of the parent record as a key and identifiers of the sub-record subordinate to the parent record as values.
20 . A storage medium comprising computer-executable instructions, wherein the computer-executable instructions, when executed by a computer processor, are configured to perform a table data processing method, wherein the table data processing method comprises: displaying at least part of records of a first table in a first interface of a client in response to a data access request for the first table input in the client, wherein the records are rows of data in the first table; and receiving a sub-record editing operation for the first table through the first interface, determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the first table in the first interface according to the hierarchical description data, wherein the hierarchical description data is used to describe parent-child relationship data corresponding to sub-record in the first table and a parent record comprising the sub-record.

Description

CROSS-REFERENCE TO RELATED APPLICATION This application claims the priority to and benefits of the Chinese Patent Application No. 202411586995.4, which was filed on November 7, 2024. The aforementioned patent application is hereby incorporated by reference in its entirety. TECHNICAL FIELD Embodiments of the present disclosure relate to the field of computer processing technologies, and in particular, to a table data processing method, an electronic device, and a non-transitory storage medium. BACKGROUND With the rapid development of information technology, tables have become an indispensable part of all walks of life, carrying a large amount of information in an intuitive and clear way. Users may store, manage, and view data records through tables. For viewing data records through a table, the table data processing method in the related art often loads all data records at once according to a data access request for the table, and reloads all data records when the data records change. However, when the amount of data is very large (for example, on the order of millions of rows), loading all the data at once may cause the client to bear huge memory and computing pressure, making the table processing efficiency low and the user experience poor. SUMMARY Embodiments of the present disclosure provide a table data processing method, an apparatus, a device, a medium, and a product, which may display records of a table on demand and may update changed records more quickly and effectively in a targeted manner, thereby improving the processing efficiency and use experience of the table. An embodiment of the present disclosure provides a table data processing method, including: displaying at least part of records of a target table (for example, a first table) in a target interface (for example, a first interface) of a client in response to a data access request for the target table input in the client, where the records are rows of data in the target table; and receiving a sub-record editing operation for the target table through the target interface, determining hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and updating display data of the target table in the target interface according to the hierarchical description data, where the hierarchical description data is used to describe parent-child relationship data corresponding to a sub-record in the target table and a parent record including the sub-record. An embodiment of the present disclosure further provides a table data processing apparatus, including: a data access request module, configured to display at least part of records of a target table in a target interface of a client in response to a data access request for the target table input in the client, where the records are rows of data in the target table; and a table data display module, configured to receive a sub-record editing operation for the target table through the target interface, determine hierarchical description data corresponding to an edited sub-record according to the sub-record editing operation, and update display data of the target table in the target interface according to the hierarchical description data, where the hierarchical description data is used to describe parent-child relationship data corresponding to a sub-record in the target table and a parent record including the sub-record. An embodiment of the present disclosure further provides an electronic device, including: one or more processors; and a storage apparatus, configured to store one or more programs, when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the table data processing method according to any one of the embodiments of the present disclosure. An embodiment of the present disclosure further provides a storage medium including computer-executable instructions, where the computer-executable instructions, when executed by a computer processor, are configured to perform the table data processing method according to any one of the embodiments of the present disclosure. An embodiment of the present disclosure further provides a computer program product, including a computer program, where the computer program, when executed by a processor, implements the table data processing method according to any one of the embodiments of the present disclosure. BRIEF DESCRIPTION OF DRAWINGS The above and other features, advantages, and aspects of the embodiments of the present disclosure will become more apparent in combination with the drawings and with reference to the following specific embodiments. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that the components and elements are not necessarily drawn to scale. FIG. 1 is a schematic flowchart of a table data processing method