Table data processing method and device, equipment, medium and product

Abstract

The embodiment of the invention provides a table data processing method and device, equipment, a medium and a product. The method comprises the steps of displaying at least part of records of a target table in a target interface of a client in response to a data access request which is input by the client and aims at the target table; the record refers to a row of data in the target table; receiving a sub-record editing operation for the target table through the target interface, determining hierarchical description data corresponding to the 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; the hierarchical description data is used for describing child records in the target table and father-child relation data corresponding to father records containing the child records. According to the technical scheme provided by the embodiment of the invention, the records of the table can be loaded as required, the changed records can be quickly and effectively updated in a targeted manner, and the processing efficiency and the use experience of the table are improved.

Description

Technical Field

[0001] The embodiments of the present disclosure relate to the field of computer processing technology, and in particular, to a table data processing method, device, equipment, medium and product. Background Art

[0002] 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 can store, manage and view data records through tables.

[0003] For viewing data records through tables, the table data processing method in related technologies often loads all data records at once according to the access request of table data, and reloads all data records when the data records change. However, when the amount of data is very large (such as millions of rows), loading all data at once may cause the client to bear huge memory and computing pressure, resulting in low table processing efficiency and poor user experience. Summary of the invention

[0004] The embodiments of the present disclosure provide a table data processing method, apparatus, device, medium and product to realize the on-demand display of table records and the rapid and effective targeted update of changed records, thereby improving the processing efficiency and user experience of the table.

[0005] In a first aspect, an embodiment of the present disclosure provides a table data processing method, the method comprising:

[0006] In response to a data access request for a target table inputted at a client, displaying at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table;

[0007] Receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record based on the sub-record editing operation, and update the display data of the target table in the target interface based on the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records.

[0008] In a second aspect, an embodiment of the present disclosure further provides a table data processing device, the device comprising:

[0009] A data access request module, configured to respond to a data access request for a target table inputted at a client, and display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table;

[0010] A table data display module is used to receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and update the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent records containing the sub-records.

[0011] In a third aspect, an embodiment of the present disclosure further provides an electronic device, the electronic device comprising:

[0012] one or more processors;

[0013] a storage device for storing one or more programs,

[0014] When the one or more programs are executed by the one or more processors, the one or more processors implement the table data processing method as described in any one of the embodiments of the present disclosure.

[0015] In a fourth aspect, the embodiments of the present disclosure further provide a storage medium comprising computer executable instructions, which, when executed by a computer processor, are used to execute the table data processing method as described in any one of the embodiments of the present disclosure.

[0016] In a fifth aspect, the embodiments of the present disclosure further provide a computer program product, including a computer program, which, when executed by a processor, implements the table data processing method as described in any one of the embodiments of the present disclosure.

[0017] The technical solution of the embodiment of the present disclosure, by responding to the data access request for the target table input on the client, displays at least part of the records of the target table in the target interface of the client, and since the record refers to a row of data in the target table, the records of the target table are displayed on demand. Then, the sub-record editing operation for the target table is received through the target interface, and the hierarchical description data corresponding to the edited sub-record is determined according to the sub-record editing operation. In the technical solution, by defining the hierarchical description data describing the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records, the nesting level of the records in the target table is reduced, and the data structure of the target table is simplified. Afterwards, the display data of the target table in the target interface can be updated relatively quickly and targetedly according to the hierarchical description data. The technical solution of the embodiment of the present disclosure solves the technical problem of low table processing efficiency in the table processing method in the related art, realizes the on-demand display of table records and the ability to quickly and effectively update the changed records in a targeted manner, without loading all the data of the target table, supports the rapid editing and display of sub-records in the on-demand display table scenario, and improves the processing efficiency and user experience of the target table. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale.

[0019] Figure 1 A flowchart of a table data processing method provided by an embodiment of the present disclosure;

[0020] Figure 2 A flowchart of another table data processing method provided by an embodiment of the present disclosure;

[0021] Figure 3 A flowchart of another table data processing method provided by an embodiment of the present disclosure;

[0022] Figure 4 A flowchart of another table data processing method provided by an embodiment of the present disclosure;

[0023] Figure 5 An example diagram of an interface for displaying records applicable to a table data processing method provided in an embodiment of the present disclosure;

[0024] Figure 6A timing diagram of a table data processing method applicable to an embodiment of the present disclosure and responding to on-demand loading of table data provided in an embodiment of the present disclosure;

[0025] Figure 7 An example diagram of an interface for recording operations of a table data processing method provided in an embodiment of the present disclosure;

[0026] Figure 8 A timing diagram of a table data processing method applicable to an embodiment of the present disclosure when responding to a sub-record editing operation provided in the embodiment of the present disclosure;

[0027] Fig. 9 A schematic diagram of the structure of a table data processing device provided by an embodiment of the present disclosure;

[0028] Fig.10 A schematic diagram of the structure of an electronic device provided by the embodiment of the present disclosure for implementing the embodiment of the present disclosure. DETAILED DESCRIPTION

[0029] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0030] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0031] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0032] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0033] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0034] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0035] It is understandable that before using the technical solutions disclosed in the embodiments of the present disclosure, the types, scope of use, usage scenarios, etc. of the personal information involved in the present disclosure should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations.

[0036] For example, in response to receiving an active request from a user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information. Thus, the user can autonomously choose whether to provide personal information to software or hardware such as an electronic device, application, server, or storage medium that performs the operation of the technical solution of the present disclosure according to the prompt message.

[0037] As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. In addition, the pop-up window may also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0038] It is understandable that the above notification and the process of obtaining user authorization are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that meet the relevant laws and regulations may also be applied to the implementation of the present disclosure.

[0039] It is understandable that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and relevant provisions.

[0040] Figure 1 The present invention provides a flowchart of a table data processing method provided by an embodiment of the present invention. The present invention is applicable to scenarios where table data is processed. The method can be executed by a table data processing device, which can be implemented in the form of software and / or hardware. Optionally, it can be implemented by an electronic device, which can be a mobile terminal, a PC, or a server. Figure 1 As shown, the method of this embodiment may specifically include:

[0041] S110. In response to a data access request for a target table inputted at a client, display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table.

[0042] Among them, the target table can be understood as a table that requires data access, which can be used to store, manage and display data records. The data in the target table can be presented in the form of rows. A record can refer to the data recorded in a row in the target table. In practical applications, the target table usually includes multiple rows of data, that is, the target table usually includes multiple records. In the embodiment of the present disclosure, the records in the target table can have a parent-child relationship. The target table may include one or more parent records and one or more child records subordinate to the parent record. It should be noted that the number of child records under different parent records in the target table may be the same or different.

[0043] In the embodiment of the present disclosure, a data access request may be understood as a request for data access to data in a target table, and may be used to display at least part of the records of the target table in a target interface of a client. In the embodiment of the present disclosure, a target interface may be understood as an interface for displaying at least part of the records of a target table. In the embodiment of the present disclosure, the layout of the target interface may be an adaptive layout using a responsive layout method to adapt to display screens of different resolutions; or, it may be a layout using a preset interface size, wherein the preset interface size may be set according to actual needs, and is not specifically limited herein. Optionally, the preset interface size includes a preset interface length and / or a preset interface width.

[0044] In the embodiment of the present disclosure, the application scenario of the data access request for the target table input by the client can be when the records of the target table are not displayed on the target interface of the client; or, it can be when the records of the target table are displayed on the target interface of the client.

[0045] As an optional implementation of the embodiment of the present disclosure, in response to a data access request for a target table inputted on a client, specifically, in the case where the record of the target table is not displayed on the target interface of the client, in response to a data viewing operation for the target table inputted on the client. Based on this, after receiving the data viewing operation for the target table inputted on the client, the default loading record of the target table can be determined. The default loading record can then be displayed in the target interface of the client. Among them, the default loading record can be understood as the default record to be displayed when the target table is accessed for the first time within a preset time period. For example, the default loading record can be the record of the target table displayed on the target interface when the target table was last closed.

[0046] In an embodiment of the present disclosure, determining the default at least part of the records of the target table can be determined based on the preset record identifier and the preset number of record displays of the target table; wherein the preset record identifier can be used to distinguish the data content in different tables of the target interface. For example, the preset record identifier can be the first record displayed in the target table. In some scenarios, the preset record identifier is called a column header, which is used to identify the data content of the column data in which it is located, or in other words, to distinguish the data content of different columns. The preset record identifier can be set according to actual needs, and it is not specifically set here. The preset number of record displays can be set according to actual needs, and it is not specifically limited here, for example, 20, 30 or 50, etc. It can be understood that the preset number of record displays does not exceed the upper limit of the number of records that can be displayed on the target interface.

[0047] As another optional implementation of the embodiment of the present disclosure, in response to a data access request for a target table inputted on a client, specifically, when the target interface of the client displays records of the target table, in response to a scrolling operation on the target interface displaying records of the target table. Based on this, after receiving a scrolling operation on the target interface displaying records of the target table, at least part of the records of the target table displayed on the target interface of the client can be updated.

[0048] In the embodiment of the present disclosure, the storage location of the records of the target table may be a client or a server. There may be multiple ways to display at least part of the records of the target table in the target interface of the client.

[0049] As an optional implementation of the disclosed embodiment, when the storage location of the records of the target table is the client, after receiving a data access request for the target table input on the client, at least part of the records of the target table can be read from the client and the at least part of the records can be displayed in the target interface of the client.

[0050] As another optional implementation of the embodiment of the present disclosure, when the storage location of the records of the target table is a server, the response to a data access request for the target table input on the client, displaying at least part of the records of the target table in the target interface of the client may include: in response to a data access request for the target table input on the client, obtaining target data corresponding to the records requested to be accessed from the table data of the target table stored on the server, and caching the target data in the client; and displaying the target table in the target interface of the client based on the target data cached in the client.

[0051] Among them, the target data can be understood as the table data corresponding to the data access request of the target table stored in the server. Specifically, after receiving the data access request for the target table input on the client, the data access request can be sent to the server. Then, the target data corresponding to the record requested to be accessed can be obtained from the table data of the target table stored on the server. After obtaining the target data on the server, the target data can be stored in the cache of the client. Then, the target table can be displayed in the target interface of the client based on the target data cached in the client. In general, the target data is the data displayed in the target interface, that is, the table data that the view layer needs to render.

[0052] On the basis of the above embodiment, in order to facilitate the subsequent access to the target table through the client, after the client receives the target data sent by the server, the target data of the target table can be stored in a preset storage location. On this basis, in order to reduce the occupation of the client storage space, when the client receives the target data of the target table sent by the server, the reception time of the target data can be marked. Within the preset period from the reception time, if no data access request for the target table is input in the client, the target data stored by the client can be deleted.

[0053] S120. Receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and update the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records.

[0054] Among them, the sub-record editing operation can be understood as an operation for editing the sub-records in the target table. In the disclosed embodiment, the sub-record editing operation may include a sub-record adding operation and / or a sub-record deleting operation. The sub-record adding operation can be understood as an operation for adding at least one sub-record in the target table. The sub-record deleting operation can be understood as an operation for deleting at least one sub-record in the target table. In the disclosed embodiment, the hierarchical description data can be used to describe the parent-child relationship data corresponding to the sub-records in the target table and the parent record containing the sub-records. In other words, the hierarchical description data can be used to determine the parent record to which the sub-record is subordinate and all the sub-records under the parent record.

[0055] In the embodiment of the present disclosure, the storage location of the hierarchical description data may be a client, or may be a server. There are multiple ways to determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation.

[0056] As an optional implementation of the embodiment of the present disclosure, when the storage location of the hierarchical description data can be a client, the edited sub-record can be determined according to the sub-record editing operation. Then, the hierarchical description data corresponding to the edited sub-record in the client can be updated based on the edited sub-record. Thus, the hierarchical description data corresponding to the edited sub-record can be read from the client.

[0057] As another optional implementation of the embodiment of the present disclosure, when the storage location of the hierarchical description data can be a server, the edited sub-record can be determined according to the sub-record editing operation. After determining the edited sub-record, the edited sub-record can be sent to the server so that the server updates the hierarchical description data corresponding to the edited sub-record, and sends the updated hierarchical description data to the client so that the client obtains the hierarchical description data corresponding to the edited sub-record.

[0058] In the embodiment of the present disclosure, the updating of the display data of the target table in the target interface according to the hierarchical description data may specifically include: determining the parent record to which the edited sub-record is subordinate and all the sub-records under the parent record according to the hierarchical description data. Thus, the display data of the target table in the target interface may be updated based on the parent record to which the edited sub-record is subordinate and all the sub-records under the parent record.

[0059] In a disclosed embodiment, the hierarchical description data may include first description data and second description data. Among them, the first description data may be used to describe the subordinate relationship between the child record and the parent record to which the child record is subordinate. The second description data may be used to describe the subordinate relationship between the parent record and the child record contained in the parent record. In a disclosed embodiment, the advantage of using the first description data and the second description data as the hierarchical description data is that when a child record is added or deleted under a parent record of a target table displayed on the target interface, there is no need to reload all the records of the target table, and the records that have changed in the target table can be loaded in a targeted manner. In addition, it is relatively fast and effective to realize that the target interface loads and displays the records of the target table on demand.

[0060] In the embodiment of the present disclosure, the hierarchical description data is stored in the form of a key-value pair (Map). Among them, the first description data can use the identifier of the child record as a key and the identifier of the parent record to which the child record belongs as a value. The second description data can use the identifier of the parent record as a key and the identifier of the child record subordinate to the parent record as a value. In the embodiment of the present disclosure, two Maps are used, one for storing the mapping of child records to parent records, namely the first description data, and the other for storing the mapping of parent records to child records, namely the second description data, to achieve flat data storage of records in the target table, reduce the nested level of data, make data access more direct, and make record addition, deletion and modification more flexible. The use of Map can easily update the parent-child relationship between parent records and child records in the target table without rebuilding the entire data structure. In addition, it also avoids duplicate storage of data and facilitates understanding and maintenance.

[0061] On the basis of the above-mentioned embodiment, the hierarchical description data corresponding to the edited sub-record determined according to the sub-record editing operation may specifically include: when the sub-record editing operation includes a sub-record adding operation, the first description data corresponding to the added sub-record may be added, and the description data corresponding to the added sub-record may be written into the second description data of the parent record to which the added sub-record is subordinate; and / or, when the sub-record editing operation includes a sub-record deleting operation, the first description data corresponding to the added sub-record may be deleted, and the description data corresponding to the added sub-record may be deleted from the second description data of the parent record to which the added sub-record is subordinate. The use of this technical solution can simply and quickly implement the deletion of sub-records, improve the processing rate of the target table, and increase the view update speed after the sub-records are deleted.

[0062] On the basis of the above-mentioned embodiments, the embodiments of the present disclosure may further include: the client may include a current client and a collaborative client that collaborates with the current client. In the embodiments of the present disclosure, the number of the collaborative clients may be one, two or more. The current client and the collaborative client respectively establish data communication links with the server based on a network communication protocol (such as Websoket). After the collaborative client receives the sub-record editing operation for the target table, the collaborative client may send the sub-record editing operation to the server, so that the server broadcasts the message of the collaborative client's sub-record editing operation for the target table to the client that is in communication link with the server. After the current client obtains the message from the data communication link, the sub-record editing operation of the collaborative client for the target table can be obtained based on the message. Then, the sub-record editing operation of the collaborative client for the target table can be performed on the target table of the current client, thereby realizing the function of multi-client collaborative processing of the sub-record editing operation of the target table.

[0063] The technical solution of the embodiment of the present disclosure is to display at least part of the records of the target table in the target interface of the client in response to the data access request for the target table inputted on the client. Since the record refers to a row of data in the target table, the records of the target table are displayed on demand. The target interface receives the sub-record editing operation for the target table, and determines the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation. In the technical solution, by defining the hierarchical description data describing the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records, the nesting level of the records in the target table is reduced, and the data structure of the target table is simplified. Afterwards, the display data of the target table in the target interface can be updated relatively quickly and specifically according to the hierarchical description data. The technical solution of the embodiment of the present disclosure solves the technical problem of low table processing efficiency in the existing table processing, realizes the ability to load the records of the table on demand and to update the changed records in a relatively fast and effective manner, without loading all the data of the target table, supports the rapid editing and display of the sub-records in the on-demand display table scenario, and improves the processing efficiency and user experience of the target table.

[0064] Figure 2A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of this embodiment is based on the above-mentioned embodiment, wherein the sub-record editing operation includes a sub-record moving operation; the hierarchical description data corresponding to the edited sub-record is determined according to the sub-record editing operation, including: determining the edited sub-record according to the sub-record moving operation, and determining the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move; modifying the parent record in the first description data corresponding to the edited sub-record from the first parent record to the second parent record, deleting the description data corresponding to the edited sub-record in the second description data corresponding to the first parent record, and adding the description data corresponding to the edited sub-record in the second description data corresponding to the second parent record. For specific implementation methods, please refer to the description of this embodiment. Among them, technical features that are the same or similar to those in the above-mentioned embodiments are not repeated here. As Figure 2 As shown, the method of this embodiment may specifically include:

[0065] S210. In response to a data access request for a target table inputted at a client, display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table.

[0066] S220. Receive a sub-record editing operation for the target table through the target interface; wherein the sub-record editing operation includes a sub-record moving operation.

[0067] The sub-record moving operation may be understood as an operation for moving or adjusting the position of at least one sub-record in the target table.

[0068] S230: Determine the edited sub-record according to the sub-record move operation, and determine the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move.

[0069] The first parent record may be understood as the parent record to which the edited child record belongs before being moved, and the second parent record may be understood as the parent record to which the edited child record belongs after being moved.

[0070] Specifically, the edited sub-record is determined according to the sub-record moving operation, and the parent record to which the edited sub-record is subordinate before the move, i.e., the first parent record, is determined, and the parent record to which the edited sub-record is subordinate after the move, i.e., the second parent record, is determined.

[0071] In the embodiment of the present disclosure, the method of determining the first parent record to which the edited subrecord is subordinate before the move may specifically be, obtaining the first description data of the edited subrecord before the move. Based on the first description data of the edited subrecord before the move, the first parent record to which the edited subrecord is subordinate before the move is determined. Similarly, the method of determining the second parent record to which the edited subrecord is subordinate after the move may specifically be, obtaining the first description data of the edited subrecord after the move. Based on the first description data of the edited subrecord after the move, the second parent record to which the edited subrecord is subordinate after the move is determined.

[0072] S240. Change the parent record in the first description data corresponding to the edited child record from the first parent record to the second parent record, delete the description data corresponding to the edited child record from the second description data corresponding to the first parent record, and add the description data corresponding to the edited child record to the second description data corresponding to the second parent record.

[0073] Specifically, the parent record in the first description data corresponding to the edited child record may be modified from the first parent record to the second parent record, so that the parent record in the first description data corresponding to the edited child record is the second parent record. After the modification, the description data corresponding to the edited child record in the second description data corresponding to the first parent record may be determined, and the description data corresponding to the edited child record in the second description data corresponding to the first parent record may be deleted, and the description data corresponding to the edited child record may be written into the second description data corresponding to the second parent record.

[0074] S250: Update display data of the target table in the target interface according to the modified first description data and the modified second description data.

[0075] The technical solution of the embodiment of the present disclosure determines the edited sub-record according to the sub-record moving operation, and determines the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move; the parent record in the first description data corresponding to the edited sub-record is modified from the first parent record to the second parent record, the description data corresponding to the edited sub-record is deleted from the second description data corresponding to the first parent record, and the description data corresponding to the edited sub-record is added to the second description data corresponding to the second parent record, thereby realizing the function of performing a sub-record moving operation on the sub-records in the target table.

[0076] Figure 3A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of this embodiment is based on the above-mentioned embodiment. Optionally, the client stores table data corresponding to the data access request; the hierarchical description data corresponding to the edited sub-record is updated according to the sub-record editing operation, and the display data of the target table in the target interface is updated according to the hierarchical description data, including: in the client, the hierarchical description data corresponding to the edited sub-record is determined according to the sub-record editing operation and the table data corresponding to the data access request stored in the client, and the display data of the target table in the target interface is updated according to the hierarchical description data determined by the client. For specific implementation methods, please refer to the description of this embodiment. Among them, technical features that are the same or similar to those in the above-mentioned embodiments are not repeated here. Figure 3 As shown, the method of this embodiment may specifically include:

[0077] S310. In response to a data access request for a target table inputted on a client, display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table, and the client stores table data corresponding to the data access request.

[0078] S320. Receive a sub-record editing operation for the target table through the target interface. In the client, determine the hierarchical description data corresponding to the edited sub-record based on the sub-record editing operation and the table data corresponding to the data access request stored in the client, and update the display data of the target table in the target interface based on the hierarchical description data determined by the client.

[0079] The hierarchical description data may be used to describe the parent-child relationship data corresponding to the child records in the target table and the parent records containing the child records.

[0080] In the embodiment of the present disclosure, the client has stored table data corresponding to the data access request. Then, after receiving the sub-record editing operation for the target table through the target interface, the hierarchical description data corresponding to the sub-record before the edited sub-record in the client can be updated in the client according to the sub-record editing operation and the table data corresponding to the data access request stored in the client. Thereby, the hierarchical description data corresponding to after the edited sub-record can be obtained, that is, the hierarchical description data corresponding to the edited sub-record can be obtained. Then, according to the hierarchical description data determined by the client, the display data of the target table in the target interface can be updated. Such processing in the embodiment of the present disclosure not only realizes the immediate visibility of the modified target table on the client, but also ensures that the client operation is put on the screen first, that is, the rendering result of the target table can be seen immediately on the client without waiting for the server to respond.

[0081] In the embodiment of the present disclosure, after updating the display data of the target table in the target interface according to the hierarchical description data determined by the client, it may also include: when the client receives the hierarchical description data corresponding to the edited sub-record sent by the server, updating the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data; updating the display data of the target table in the target interface according to the updated hierarchical description data in the client.

[0082] Specifically, when the client receives the hierarchical description data corresponding to the edited sub-record sent by the server, the hierarchical description data corresponding to the edited sub-record stored in the client can be updated in a targeted manner based on the received hierarchical description data. Furthermore, the display data of the target table in the target interface can be updated based on the updated hierarchical description data in the client. In an embodiment of the present disclosure, after receiving an editing operation on a sub-record of the target table through the target interface, a message of the editing operation can be uploaded to the server, so that the server updates the hierarchical description data corresponding to the edited sub-record based on the message, and sends the updated hierarchical description data corresponding to the edited sub-record to the client.

[0083] It should be noted that, in the embodiment of the present disclosure, in order to ensure consistency in the hierarchical description data between the client and the server, the hierarchical description data corresponding to the edited sub-record is determined in the client according to the sub-record editing operation and the table data corresponding to the data access request stored in the client, and does not need to be stored in the client. The hierarchical description data stored in the client may be the hierarchical description data corresponding to the edited sub-record issued by the server.

[0084] The technical solution of the embodiment of the present disclosure is to determine, in the client, 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 to update the display data of the target table in the target interface according to the hierarchical description data determined by the client, thereby achieving the technical effect of immediate visibility of the modified target table on the client and reducing the waiting time of the client.

[0085] Figure 4 A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of this embodiment is based on the above-mentioned embodiment. Optionally, the hierarchical description data corresponding to the edited sub-record is determined according to the sub-record editing operation, and the display data of the target table in the target interface is updated according to the hierarchical description data, including: 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. For specific implementation methods, please refer to the description of this embodiment. Among them, technical features that are the same or similar to those in the above-mentioned embodiments are not repeated here. Figure 4 As shown, the method of this embodiment may specifically include:

[0086] S410. In response to a data access request for a target table inputted at a client, display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table.

[0087] S420. Receive a sub-record editing operation for the target table through the target interface, add a preset identifier to the hierarchical description data corresponding to the edited sub-record stored in the client, and update the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier.

[0088] Among them, the hierarchical description data is used to describe the parent-child relationship data corresponding to the child records in the target table and the parent records containing the child records. The preset identifier can be used to identify whether the hierarchical description data corresponding to the edited child record stored in the client is accurate. In the embodiment of the present disclosure, when the hierarchical description data corresponding to the sub-record is added with a preset identifier, it can be determined that the hierarchical description data corresponding to the sub-record is inaccurate. Similarly, when the hierarchical description data corresponding to the sub-record is not added with a preset identifier, it can be determined that the hierarchical description data corresponding to the sub-record is accurate. In the disclosed embodiment, by adding a preset identifier to the hierarchical description data corresponding to the sub-record, inaccurate records in the target table can be quickly located to facilitate accurate updating of inaccurate records. The representation of the preset identifier may include numbers and / letters.

[0089] Specifically, after receiving the sub-record editing operation for the target table through the target interface, the hierarchical description data corresponding to the edited sub-record stored in the client can be determined. Thus, a preset identifier can be added to the hierarchical description data corresponding to the edited sub-record stored in the client. Then, the hierarchical description data corresponding to the edited sub-record stored in the client can be updated based on the preset identifier.

[0090] In the embodiment of the present disclosure, the updating of the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier may include: first sending the sub-record editing operation to the 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. Afterwards, the hierarchical description data corresponding to the edited sub-record sent by the server may be received, and the hierarchical description data corresponding to the edited sub-record stored in the client may be updated according to the received hierarchical description data and the preset identifier.

[0091] In the embodiment of the present disclosure, the updating of the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data and the preset identifier may be storing the received hierarchical description data in the client and deleting the hierarchical description data added with the preset identifier; or, may be replacing the hierarchical description data added with the preset identifier with the received hierarchical description data.

[0092] S430: Update display data of the target table in the target interface according to the hierarchical description data.

[0093] On the basis of the above embodiment, after receiving the hierarchical description data sent by the server, it can be determined whether the display data obtained based on the hierarchical description data sent by the server is consistent with the display data of the target table displayed by the client at the current moment. If not, the display data of the target table in the target interface is updated based on the hierarchical description data sent by the server. If so, there is no need to perform the operation of updating the display data of the target table in the target interface based on the hierarchical description data sent by the server, so that the hierarchical description data stored in the client can be updated without perception.

[0094] The technical solution of the embodiment of the present disclosure adds a preset identifier to the hierarchical description data corresponding to the edited sub-record stored in the client, and updates the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier, thereby achieving relatively fast and convenient update processing of the hierarchical description data corresponding to the edited sub-record stored in the client.

[0095] As an optional implementation of the embodiment of the present disclosure, the table processing method of this embodiment may include the following specific steps:

[0096] 1. After receiving a data access request for a target table inputted on a client, at least part of the records of the target table can be displayed in the target interface of the client. The record refers to a row of data in the target table. Figure 5 , the records in the target table include parent record 1, child record 1.1 subordinate to parent record 1, record 2, parent record 3, child record 3.1 subordinate to parent record 3, record 4, record 5, record 6 and record 7.

[0097] Specifically, Figure 6 As shown, after receiving the table opening operation for the target table input by the operator on the client, the hierarchical information (hierarchical description data) of the target table in the client can be determined to obtain partial record data of the target table from the server. After the client receives the partial record data returned by the server, the hierarchical relationship of the partial records can be calculated on the client, and the parent record and its child records in the target table can be cached in the client. After the client calculation is completed, the target table can be notified to re-render the record data. Among them, the process of re-rendering the target table can specifically include: the parent record can be first obtained from the cache of the client. Afterwards, the child records subordinate to the parent record can be obtained from the cache of the client.

[0098] 2. Receive a sub-record editing operation for the target table through the target interface, wherein the sub-record editing operation includes a sub-record moving operation. Figure 7As shown, a sub-record dragging operation of dragging sub-record 1.1 to parent record 3 in the target table may be received through the target interface.

[0099] 3. According to the dragging operation of dragging the child record 1.1 of the target table to the parent record 3, it can be determined that the edited record is the child record 1.1, and it can be determined that the parent record to which the child record 1.1 belongs before the move is the parent record 1 and the parent record to which the child record 1.1 belongs after the move is the parent record 3.

[0100] 4. Afterwards, if Figure 8 As shown, in the client, the child record 1.1 under the parent record 1 can be deleted and the child record 1.1 can be added under the parent record 3. The hierarchical information of the parent record 1 and the parent record 3 stored in the client can be partially marked dirty. Then, the target table can be rendered specifically based on the hierarchical information after being marked dirty, so that the target table can be rendered preferentially on the client without the server sending the hierarchical information.

[0101] 5. After the client deletes the child record 1.1 under the parent record 1 and adds the child record 1.1 under the parent record 3, the child record dragging operation of dragging the child record 1.1 to the parent record 3 in the target table can be sent to the server, so that the server updates the hierarchical information corresponding to the child record dragging operation and sends the updated hierarchical information to the client.

[0102] 6. After the client receives the updated hierarchical information, the updated hierarchical information can be stored, and it can be determined whether the result of rendering the target table based on the updated hierarchical information is consistent with the result of rendering the target table by the client. If so, it can be determined that the client does not need to render the records of the target table displayed by the client based on the updated hierarchical information. If not, the target table displayed by the client can be rendered based on the updated hierarchical information to adjust the records of the target table displayed by the client.

[0103] The technical solution of the disclosed embodiment solves the technical problem of low table processing efficiency in existing table processing, realizes the ability to load table records on demand and to quickly and effectively update changed records, thereby improving table processing efficiency and user experience.

[0104] Fig. 9 A schematic diagram of the structure of a table data processing device provided by an embodiment of the present disclosure is shown in FIG. Fig. 9As shown, the device includes: a data access request module 510 and a table data display module 520. The data access request module 510 is used to display at least part of the records of the target table in the target interface of the client in response to a data access request for the target table input on the client; wherein the record refers to a row of data in the target table; the table data display module 520 is used to receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and update the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the parent-child relationship data corresponding to the sub-records in the target table and the parent records containing the sub-records.

[0105] The technical solution of the disclosed embodiment is to display at least part of the records of the target table in the target interface of the client through the data access request module 510 in response to the data access request for the target table input on the client; wherein the record refers to a row of data in the target table, thereby realizing on-demand loading of the records of the target table. The table data display module 520 receives the sub-record editing operation for the target table through the target interface, determines the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and updates the display data of the target table in the target interface according to the hierarchical description data. In the technical solution, by defining the hierarchical description data describing the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records, the nesting level of the records in the target table is reduced and the data structure of the target table is simplified. Afterwards, the display data of the target table in the target interface can be updated relatively quickly and specifically according to the hierarchical description data. The technical solution of the disclosed embodiment solves the technical problem of low table processing efficiency in existing table processing, realizes the on-demand loading of table records and the relatively fast and effective targeted update of changed records without loading all the data of the target table, supports the rapid editing and display of sub-records in the on-demand table display scenario, and improves the processing efficiency and user experience of the target table.

[0106] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the hierarchical description data includes first description data and second description data; the first description data is used to describe the subordinate relationship between the child record and the parent record to which the child record is subordinate; the second description data is used to describe the subordinate relationship between the parent record and the child record contained in the parent record.

[0107] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the sub-record editing operation includes a sub-record adding operation and / or a sub-record deleting operation; the table data display module 520 includes a first-level description data determination unit; the first-level description data determination unit is used to add first description data corresponding to the added sub-record when the sub-record editing operation includes a sub-record adding operation, and write the description data corresponding to the added sub-record into the second description data of the parent record to which the added sub-record is subordinate; and / or, when the sub-record editing operation includes a sub-record deleting operation, delete the first description data corresponding to the added sub-record, and delete the description data corresponding to the added sub-record from the second description data of the parent record to which the added sub-record is subordinate.

[0108] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the sub-record editing operation includes a sub-record moving operation. Further, the table data display module 520 may include a second-level description data determination unit. Among them, the second-level description data determination unit is used to determine the edited sub-record according to the sub-record moving operation, and determine the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move; modify the parent record in the first description data corresponding to the edited sub-record from the first parent record to the second parent record, delete the description data corresponding to the edited sub-record in the second description data corresponding to the first parent record, and add the description data corresponding to the edited sub-record in the second description data corresponding to the second parent record.

[0109] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the hierarchical description data is stored in the form of a key-value pair; the first description data uses the identifier of the child record as the key, and the identifier of the parent record to which the child record belongs as the value; the second description data uses the identifier of the parent record as the key, and the identifier of the child record that is subordinate to the parent record as the value.

[0110] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the client stores table data corresponding to the data access request. Further, the table data display module 520 can be used to determine the hierarchical description data corresponding to the edited sub-record in the client according to the sub-record editing operation and the table data corresponding to the data access request stored in the client, and update the display data of the target table in the target interface according to the hierarchical description data determined by the client.

[0111] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the table data processing device further includes a table data updating module. The table data updating module can be used to update the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data after the display data of the target table in the target interface is updated according to the hierarchical description data determined by the client, when the client receives the hierarchical description data corresponding to the edited sub-record sent by the server; and update the display data of the target table in the target interface according to the updated hierarchical description data in the client.

[0112] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the table data display module 520 includes a hierarchical description data updating submodule, wherein the hierarchical description data updating submodule is used to add a preset identifier to the hierarchical description data corresponding to the edited subrecord stored in the client, and update the hierarchical description data corresponding to the edited subrecord stored in the client based on the preset identifier.

[0113] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the hierarchical description data update submodule includes a server-side hierarchical update unit and a client-side hierarchical update unit. The server-side hierarchical update unit is used to send the sub-record editing operation to the 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; the client-side hierarchical update unit is used to receive the hierarchical description data corresponding to the edited sub-record sent by the server, and update the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data and the preset identifier.

[0114] Based on any optional technical solution in the embodiments of the present disclosure, optionally, the data access request module 510 includes a client data cache unit and a target table display unit. The client data cache unit is used to respond to a data access request for a target table input on the client, obtain target data corresponding to the record requested for access from the table data of the target table stored on the server, and cache the target data in the client; the target table display unit is used to display the target table in the target interface of the client according to the target data cached in the client.

[0115] The table data processing device provided in the embodiments of the present disclosure can execute the table data processing method provided in any embodiment of the present disclosure, and has the corresponding functional modules and beneficial effects for executing the table data processing method.

[0116] It is worth noting that the various units and modules included in the above-mentioned device are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the protection scope of the embodiments of the present disclosure.

[0117] Reference below Fig.10 , which shows a schematic diagram of the structure of an electronic device (such as a terminal device or a server) 600 suitable for implementing the embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure may include but is not limited to mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig.10 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0118] like Fig.10 As shown, the electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage device 606 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic device 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0119] Typically, the following devices may be connected to the I / O interface 605: an input device 606 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 606 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 609. The communication device 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. Although Fig.10 The electronic device 600 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0120] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 609, or installed from a storage device 606, or installed from a ROM 602. When the computer program is executed by the processing device 601, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0121] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0122] The electronic device provided in the embodiment of the present disclosure and the table data processing method provided in the above embodiment belong to the same inventive concept. The technical details not fully described in the embodiment of the present disclosure can be referred to the above embodiment, and the present embodiment has the same beneficial effects as the above embodiment.

[0123] The embodiment of the present disclosure provides a computer storage medium on which a computer program is stored. When the program is executed by a processor, the table data processing method provided by the above embodiment is implemented.

[0124] It should be noted that the computer-readable medium disclosed above may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0125] According to one or more embodiments of the present disclosure, [Example 1] provides a table data processing method, including: in response to a data access request for a target table input on a client, displaying at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table; receiving a sub-record editing operation for the target table through the target interface, determining hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and updating the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records.

[0126] According to one or more embodiments of the present disclosure, [Example 2] provides the method of Example 1, further including: optionally, the hierarchical description data includes first description data and second description data; the first description data is used to describe the subordinate relationship between the child record and the parent record to which the child record is subordinate; the second description data is used to describe the subordinate relationship between the parent record and the child record contained in the parent record.

[0127] According to one or more embodiments of the present disclosure, [Example Three] provides the method of Example One, further including: optionally, the sub-record editing operation includes a sub-record adding operation and / or a sub-record deleting operation; the determining the hierarchical description data corresponding to the edited sub-record based on the sub-record editing operation includes: when the sub-record editing operation includes a sub-record adding operation, adding first description data corresponding to the added sub-record, and writing the description data corresponding to the added sub-record to the second description data of the parent record to which the added sub-record is subordinate; and / or, when the sub-record editing operation includes a sub-record deleting operation, deleting the first description data corresponding to the added sub-record, and deleting the description data corresponding to the added sub-record from the second description data of the parent record to which the added sub-record is subordinate.

[0128] According to one or more embodiments of the present disclosure, [Example 4] provides the method of Example 1, further including: optionally, the sub-record editing operation includes a sub-record moving operation; the determining of the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation includes: determining the edited sub-record according to the sub-record moving operation, and determining the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move; modifying the parent record in the first description data corresponding to the edited sub-record from the first parent record to the second parent record, deleting the description data corresponding to the edited sub-record in the second description data corresponding to the first parent record, and adding the description data corresponding to the edited sub-record in the second description data corresponding to the second parent record.

[0129] According to one or more embodiments of the present disclosure, [Example 5] provides the method of Example 1, further including: optionally, the hierarchical description data is stored in the form of a key-value pair; the first description data uses the identifier of the child record as the key, and the identifier of the parent record to which the child record belongs as the value; the second description data uses the identifier of the parent record as the key, and the identifier of the child record that is subordinate to the parent record as the value.

[0130] According to one or more embodiments of the present disclosure, [Example Six] provides the method of Example One, further including: optionally, tabular data corresponding to the data access request is stored in the client; updating the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and updating the display data of the target table in the target interface according to the hierarchical description data, including: in the client, determining the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation and the tabular data corresponding to the data access request stored in the client, and updating the display data of the target table in the target interface according to the hierarchical description data determined by the client.

[0131] According to one or more embodiments of the present disclosure, [Example 7] provides the method of Example 1, further including: optionally, after updating the display data of the target table in the target interface according to the hierarchical description data determined by the client, it also includes: when the client receives the hierarchical description data corresponding to the edited sub-record sent by the server, updating the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data; updating the display data of the target table in the target interface according to the updated hierarchical description data in the client.

[0132] According to one or more embodiments of the present disclosure, [Example Eight] provides the method of Example One, further including: optionally, determining the hierarchical description data corresponding to the edited sub-record based on the sub-record editing operation includes: 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.

[0133] According to one or more embodiments of the present disclosure, [Example Nine] provides the method of Example One, further including: optionally, updating the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier, including: sending the sub-record editing operation to the 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; receiving the hierarchical description data corresponding to the edited sub-record issued by the server, and updating the hierarchical description data corresponding to the edited sub-record stored in the client according to the received hierarchical description data and the preset identifier.

[0134] According to one or more embodiments of the present disclosure, [Example 10] provides the method of Example 1, further including: optionally, in response to a data access request for a target table input on the client, displaying at least part of the records of the target table in the target interface of the client, including: in response to a data access request for a target table input on the client, obtaining target data corresponding to the records requested to be accessed from the table data of the target table stored on the server, and caching the target data in the client; displaying the target table in the target interface of the client according to the target data cached in the client.

[0135] According to one or more embodiments of the present disclosure, [Example 11] provides a table data processing device, including: a data access request module, used to respond to a data access request for a target table input on a client, and display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table; a table data display module, used to receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and update the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records.

[0136] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0137] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0138] The above-mentioned computer-readable medium carries one or more programs. When the above-mentioned one or more programs are executed by the electronic device, the electronic device: in response to a data access request for a target table input on the client, displays at least part of the records of the target table in the target interface of the client; wherein the record refers to a row of data in the target table; receives a sub-record editing operation for the target table through the target interface, determines the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and updates the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the parent-child relationship data corresponding to the sub-records in the target table and the parent records containing the sub-records.

[0139] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including, but not limited to, object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0140] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0141] The modules involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of a module does not limit the module itself in some cases. For example, a data access request module may also be described as "a module for displaying at least part of the records of the target table in the target interface of the client".

[0142] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0143] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0144] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

[0145] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

[0146] Although the subject matter has been described in language specific to structural features and / or methodological logical actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims.

Claims

1. A table data processing method, characterized in that: include: In response to a data access request for a target table inputted at a client, displaying at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table; Receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record based on the sub-record editing operation, and update the display data of the target table in the target interface based on the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent record containing the sub-records.

2. The table data processing method according to claim 1, characterized in that: The hierarchical description data includes first description data and second description data; the first description data is used to describe the subordinate relationship between the child record and the parent record to which the child record is subordinate; the second description data is used to describe the subordinate relationship between the parent record and the child record contained in the parent record.

3. The table data processing method according to claim 2, characterized in that: The sub-record editing operation includes a sub-record adding operation and / or a sub-record deleting operation; and determining the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation includes: In the case where the sub-record editing operation includes a sub-record adding operation, adding first description data corresponding to the added sub-record, and writing the description data corresponding to the added sub-record into second description data of a parent record to which the added sub-record is subordinate; and / or, In the case where the child record editing operation includes a child record deletion operation, the first description data corresponding to the added child record is deleted, and the description data corresponding to the added child record is deleted from the second description data of the parent record to which the added child record is subordinate.

4. The table data processing method according to claim 2, characterized in that: The sub-record editing operation includes a sub-record moving operation; and determining the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation includes: Determine the edited sub-record according to the sub-record move operation, and determine the first parent record to which the edited sub-record belongs before the move and the second parent record to which the edited sub-record belongs after the move; The parent record in the first descriptive data corresponding to the edited child record is modified from the first parent record to the second parent record, the descriptive data corresponding to the edited child record is deleted from the second descriptive data corresponding to the first parent record, and the descriptive data corresponding to the edited child record is added to the second descriptive data corresponding to the second parent record.

5. The table data processing method according to claim 2, characterized in that: The hierarchical description data is stored in the form of key-value pairs; the first description data uses the identifier of the child record as the key and the identifier of the parent record to which the child record belongs as the value; the second description data uses the identifier of the parent record as the key and the identifier of the child record that is subordinate to the parent record as the value.

6. The table data processing method according to claim 1, characterized in that: The client stores table data corresponding to the data access request; the updating of the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and the updating of the display data of the target table in the target interface according to the hierarchical description data include: In the client, the hierarchical description data corresponding to the edited sub-record is determined based on the sub-record editing operation and the table data corresponding to the data access request stored in the client, and the display data of the target table in the target interface is updated based on the hierarchical description data determined by the client.

7. The table data processing method according to claim 6, characterized in that: After updating the display data of the target table in the target interface according to the level description data determined by the client, the method further includes: When the client receives the hierarchical description data corresponding to the edited sub-record sent by the server, the hierarchical description data corresponding to the edited sub-record stored in the client is updated according to the received hierarchical description data; The display data of the target table in the target interface is updated according to the updated hierarchical description data in the client.

8. The table data processing method according to claim 1, characterized in that: The determining, according to the sub-record editing operation, the hierarchical description data corresponding to the edited sub-record includes: A preset identifier is added to the hierarchical description data corresponding to the edited sub-record stored in the client, and the hierarchical description data corresponding to the edited sub-record stored in the client is updated based on the preset identifier.

9. The table data processing method according to claim 8, characterized in that: The updating of the hierarchical description data corresponding to the edited sub-record stored in the client based on the preset identifier includes: Sending the sub-record editing operation to the 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; The hierarchical description data corresponding to the edited sub-record sent by the server is received, and the hierarchical description data corresponding to the edited sub-record stored in the client is updated according to the received hierarchical description data and the preset identifier.

10. The table data processing method according to claim 1, characterized in that: The step of displaying at least part of the records of the target table in a target interface of the client in response to a data access request for the target table inputted at the client comprises: In response to a data access request for a target table inputted at a client, target data corresponding to the record requested for access is acquired from table data of the target table stored at a server, and the target data is cached in the client; The target table is displayed in a target interface of the client according to the target data cached in the client.

11. A table data processing device, characterized in that: include: A data access request module, configured to respond to a data access request for a target table inputted at a client, and display at least part of the records of the target table in a target interface of the client; wherein the record refers to a row of data in the target table; A table data display module is used to receive a sub-record editing operation for the target table through the target interface, determine the hierarchical description data corresponding to the edited sub-record according to the sub-record editing operation, and update the display data of the target table in the target interface according to the hierarchical description data; wherein the hierarchical description data is used to describe the sub-records in the target table and the parent-child relationship data corresponding to the parent records containing the sub-records.

12. An electronic device, characterized in that: The electronic device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the table data processing method as described in any one of claims 1 to 10.

13. A storage medium containing computer executable instructions, characterized in that: When the computer executable instructions are executed by a computer processor, they are used to perform the table data processing method according to any one of claims 1 to 10.

14. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the computer program implements the table data processing method according to any one of claims 1 to 10.

Images