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 following steps: receiving a data viewing request for a target table through a client, and determining first editing time corresponding to first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at the second editing time; under the condition that the first editing time is later than the second editing time, determining to-be-changed data corresponding to the data viewing request in the second table data according to the first editing time and the second editing time; and backing up the to-be-changed data, and displaying the first table data in the client according to the second table data and the backed-up to-be-changed data. According to the technical scheme, the effect of constructing the table data requested to be checked according to the stored table data is achieved, and then the effect of effectively saving the resource occupation space of the client on the basis of ensuring that the storage data is modified without influencing the cache of the client is achieved.

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 Internet office, data analysis, processing and collection have become extremely important, and the application of tables has become more and more extensive. Users can store and manage data through tables, and support users to view historical table data edited at any historical time.

[0003] In the related art, every time a user views the historical table data corresponding to a table at any historical moment, the historical table data corresponding to the corresponding historical moment needs to be pulled from the server, and the pulled historical table data is cached in the client for display. However, this table data processing method may cause the client to respond slowly to the table viewing request, and there is a large amount of resource storage space occupied by the client, which puts great pressure on the client's memory and affects the user's experience of using the table. Summary of the invention

[0004] The present disclosure provides a table data processing method, device, equipment, medium and product to achieve the effect of constructing table data requested for viewing based on stored table data, thereby achieving the effect of effectively saving client resource occupation space while ensuring that modifying stored data does not affect client cache.

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

[0006] Receiving, through a client, a data viewing request for a target table, and determining a first editing time corresponding to first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time;

[0007] In a case where the first editing time is later than the second editing time, determining the data to be changed in the second table data corresponding to the data viewing request according to the first editing time and the second editing time;

[0008] The data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed.

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

[0010] A data viewing request module, used to receive a data viewing request for a target table through a client, and determine a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time;

[0011] A module for determining data to be changed, configured to determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time when the first editing time is later than the second editing time;

[0012] The data request module is used to back up the data to be changed, and display the first table data in the client according to the second table data and the backed up data to be changed.

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

[0014] one or more processors;

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

[0016] 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.

[0017] 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.

[0018] 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.

[0019] The technical solution of the disclosed embodiment receives a data viewing request for a target table through a client, determines a first editing time corresponding to the first table data requested to be viewed, triggers viewing of the table data and execution of subsequent operations determined by the table data through interactive operations between the user and the client, and the client stores second table data corresponding to the target table at the second editing time, thereby achieving an effect of storing at least part of the table data corresponding to the target table in the client, so as to use the stored table data as the data basis for subsequent operations; further, in a case where the first editing time is later than the second editing time, determines the data to be changed in the second table data corresponding to the data viewing request based on the first editing time and the second editing time, thereby achieving an effect of using the stored table data as the data basis for the requested viewing when the editing time requested to be viewed is later than the stored editing time. The effect of constructing the data foundation of the table data of the table data is achieved; further, the data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed, which solves the problem that a large amount of resource storage space of the client is occupied in the table data processing method in the related technology, which brings great pressure to the client's memory, and then causes the client to respond slowly to the table viewing request. By backing up the data to be changed in the stored table data to construct the table data requested to be viewed, the effect of constructing the table data requested to be viewed based on the stored table data is achieved, and then, on the basis of ensuring that the modification of the stored data does not affect the client cache, the effect of effectively saving the client's resource occupation space is achieved, and then, the response rate of viewing the table data through the client is improved, and the client's processing performance for the table data is improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] 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.

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

[0022] Figure 2 A timing flow chart of the table data processing method provided in the embodiment of the present disclosure

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

[0024] Figure 4 A schematic diagram of a table data display process provided by an embodiment of the present disclosure;

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

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

[0027] Figure 7 A schematic diagram of an interface for displaying a database table provided by an embodiment of the present disclosure;

[0028] Figure 8 A schematic diagram of the structure of a table data processing device provided by an embodiment of the present disclosure;

[0029] Fig. 9 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

[0030] 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.

[0031] 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.

[0032] 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.

[0033] 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.

[0034] 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".

[0035] 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.

[0036] 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.

[0037] 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.

[0038] 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.

[0039] 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.

[0040] 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.

[0041] Figure 1 A flow chart of a table data processing method provided in an embodiment of the present disclosure is applicable to a scenario in which table data obtained by historical editing corresponding to a target table is viewed through a client. The method can be executed by a table data processing device, which can be implemented in the form of software and / or hardware, and optionally, by an electronic device, which can be a mobile terminal, a PC or a server, etc.

[0042] like Figure 1 As shown, the method of the embodiment of the present disclosure may specifically include:

[0043] S110, receiving a data viewing request for a target table through a client, and determining a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time.

[0044] Among them, the target table can be a table that supports viewing the data associated with the table. The target table can be any type of table. Optionally, the target table is an independent table or one of the sub-tables in the accessed table. The data viewing request can be understood as an instruction for requesting to perform the operation of viewing the table data. The data viewing request can include multiple generation methods. Optionally, when a trigger operation for a preset data viewing control is detected, a data viewing request can be generated; or, when a trigger word associated with viewing data is detected in the received audio information, a data viewing request can be generated; or, when a data viewing trigger instruction input by a user is received, a data viewing request can be generated. The first table data can be a historical table editing record corresponding to the target table. In other words, the first table data can be data obtained after editing the target table at a historical time. In the embodiment of the present disclosure, after the target table is created, the data in the target table can be edited again, and the table data obtained after each editing is completed can be used as the table data corresponding to the target table, and the edited table data can be stored in association with its corresponding editing time. Further, the historically edited table data can also be viewed, and the historically edited table data requested to be viewed can be used as the first table data. The first editing time may be the time when the first table data is edited. The second table data may be data stored on the client side after the target table is edited at a historical time. The second table data may be table data corresponding to the target table at the second editing time pulled from the server side by the client side. The second editing time may be the time when the second table data is edited. In the disclosed embodiment, the first editing time and the second editing time may be two adjacent historical editing times or two non-adjacent historical editing times.

[0045] As a possible implementation of the present disclosure, the first table is a database table, each column of the database table has a fixed field type, and the content filled in the cells of each column needs to correspond to the field type of the column. In other words, the field type can be used to define at least one of the information such as the data format, data type, and data content of the data filled in the cells of the column. Exemplarily, the field type can include but is not limited to one or more of the types such as text type, option type, date type, and numeric type.

[0046] It should be noted that the second table data stored in the client may be, when the second editing time is randomly determined, the second table data corresponding to the target table at the second editing time is pulled from the server, and the pulled second table data is stored in the client. Alternatively, when a data viewing request for the second table data of the target table at the second editing time is received through the client, the second table data is pulled from the server, and the second table data is stored in the client.

[0047] In an embodiment of the present disclosure, the second table data associated with the target table at the second editing time can be pulled from the server by the client, and the second table data can be stored in the client. Further, multiple table data corresponding to the target table can be displayed based on the display interface of the client. Further, in the case of receiving a data viewing request for any table data corresponding to the target table through the client, the first table data requested to be viewed can be determined, and the first editing time corresponding to the first table data can be determined.

[0048] S120: When the first editing time is later than the second editing time, determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time.

[0049] Among them, the data to be changed may be the table data to be edited in the second table data compared with the first table data. In the embodiment of the present disclosure, when the first editing time is later than the second editing time, the first table data may be obtained only after the data editing operation is input on the basis of the second table data, and the data edited in the second table data to obtain the first table data may be used as the data to be changed. The data to be changed may be data associated with the data editing operation. Optionally, in the case where the data editing operation from the second table data to the first table data is a data addition operation, the data to be changed may be data that does not exist in the second table data compared with the first table data; or, in the case where the data editing operation from the second table data to the first table data is a data deletion operation, the data to be changed may be redundant data in the second table data compared with the first table data; or, in the case where the data editing operation from the second table data to the first table data is a data modification operation, the data to be changed may be data to be modified in the second table data compared with the first table data, etc.

[0050] In actual applications, when a data viewing request for first table data corresponding to a first editing time is received through a client, and the editing time corresponding to the table data stored in the client is earlier than the first editing time, the client usually directly pulls the first table data corresponding to the first editing time from the server, and displays and stores the pulled first table data. This data viewing method may occupy a large amount of resource storage space of the client, thereby affecting the request response efficiency of the client.

[0051] In view of the above situation, in an embodiment of the present disclosure, when determining the first editing time corresponding to the first table data requested to be viewed, the first editing time can be compared with the second editing time corresponding to the second table data stored in the client. Furthermore, in a case where the first editing time is later than the second editing time, the table data to be edited in the second table data compared to the first table data can be determined based on the first editing time and the second editing time. Furthermore, the determined table data can be used as the data to be changed in the second table data corresponding to the data viewing request. Furthermore, the first table data can be determined based on the data to be changed and the second table data. Thus, the effect of determining the table data requested to be viewed based on the table data stored in the client can be achieved, thereby improving the request response efficiency and data viewing efficiency.

[0052] As an optional implementation of an embodiment of the present disclosure, both the first table data and the second table data are table data obtained after editing based on a data editing operation, and, in the case where the first editing time is later than the second editing time, the first table data may be table data obtained after inputting a data editing operation based on the second table data. Furthermore, in the case where it is determined that the first editing time is later than the second editing time, the data editing operation required to change from the second table data to the first table data may be determined based on the first editing time and the second editing time. Furthermore, the data associated with the data editing operation of the second table data may be determined, and the data may be used as the data to be changed.

[0053] S130 , backing up the data to be changed, and displaying the first table data on the client according to the second table data and the backed-up data to be changed.

[0054] In the embodiment of the present disclosure, when the data to be changed is determined, the data to be changed can be backed up. Further, the backed up data to be changed can be processed. Furthermore, the first table data can be determined based on the changed data and the second table data obtained after the processing, and the first table data can be displayed in the client.

[0055] In actual applications, when it is necessary to edit the table data stored in the client to obtain the table data requested for viewing, the stored table data is usually fully backed up. Further, the backed-up table data is edited to obtain the table data requested for viewing. Such a data processing method may occupy a large amount of resource storage space of the client, causing great pressure on the client's memory and performance.

[0056] In view of the above situation, in the embodiment of the present disclosure, the data to be changed corresponding to the data viewing request in the second table data stored in the client can be determined. Further, the data to be changed is backed up, and the first table data requested for viewing is determined based on the second table data and the backed up data to be changed. Therefore, compared with backing up all the stored table data, backing up only the table data that needs to be changed can effectively save the client's resource space, thereby improving the client's request response efficiency.

[0057] As an optional implementation of the first embodiment of the present disclosure, after backing up the data to be changed, a data editing operation can be performed on the backed up data to be changed to obtain the target changed data. Further, other table data other than the data to be changed in the second table data can be determined. Then, table data can be constructed based on the target changed data and other table data, and the constructed table data is used as the first table data, and the first table data is displayed in the client.

[0058] In the disclosed embodiment, the first table data is the table data obtained after the target table is edited at the first editing time, so that when the first table data is displayed, the user can quickly capture the data edited on the target table at the first editing time based on the displayed first table data. Optionally, after the first table data is displayed on the client according to the second table data and the backed up data to be changed, it also includes: highlighting the target table data generated by editing the target table at the first editing time in the first table data.

[0059] The target table data may be table data generated by editing in the first table data at the first editing time. The target table data may be at least part of the table data in the first table data.

[0060] As an optional implementation of the embodiment of the present disclosure, the target table data generated by editing the target table at the first editing time can be determined according to the first editing time. Further, when the first table data is displayed on the client, the determined target table data can be highlighted in the first table data.

[0061] For example, Figure 2A timing flow chart of the table data processing method provided by the embodiment of the present disclosure. Figure 2 As shown, when the user inputs a history record preview operation for the target table through the client's view layer, the historical edited table data required for the preview can be pulled from the history record manager on the server and cached on the client. Furthermore, the cached historical edited table data can be passed to the model layer (at least for processing the display data of the client's view layer) to construct the data required by the view layer based on the model layer. Furthermore, after the construction is completed, the constructed table rendering data can be passed to the view layer, and the view layer is notified to start rendering, and then the rendered table data is displayed based on the view layer.

[0062] The technical solution of the disclosed embodiment receives a data viewing request for a target table through a client, determines a first editing time corresponding to the first table data requested to be viewed, triggers viewing of the table data and execution of subsequent operations determined by the table data through interactive operations between the user and the client, and the client stores second table data corresponding to the target table at the second editing time, thereby achieving an effect of storing at least part of the table data corresponding to the target table in the client, so as to use the stored table data as the data basis for subsequent operations; further, in a case where the first editing time is later than the second editing time, determines the data to be changed in the second table data corresponding to the data viewing request based on the first editing time and the second editing time, thereby achieving an effect of using the stored table data as the data basis for the requested viewing when the editing time requested to be viewed is later than the stored editing time. The effect of constructing the data foundation of the table data of the table data is achieved; further, the data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed, which solves the problem that a large amount of resource storage space of the client is occupied in the table data processing method in the related technology, which brings great pressure to the client's memory, and then causes the client to respond slowly to the table viewing request. By backing up the data to be changed in the stored table data to construct the table data requested to be viewed, the effect of constructing the table data requested to be viewed based on the stored table data is achieved, and then, on the basis of ensuring that the modification of the stored data does not affect the client cache, the effect of effectively saving the client's resource occupation space is achieved, and then, the response rate of viewing the table data through the client is improved, and the client's processing performance for the table data is improved.

[0063] Figure 3A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of the embodiment of the present disclosure refines the method of determining the data to be changed according to the first editing time and the second editing time on the basis of the above-mentioned embodiment. Optionally, the data to be changed in the second table data is determined according to the first editing time and the second editing time, including: determining the data editing operation performed to change the second table data to the first table data according to the first editing time and the second editing time, and obtaining the table data associated with the data editing operation in the second table data as the data to be changed. For specific implementation methods, please refer to the description of the embodiment of the present disclosure. Among them, the technical features that are the same or similar to those in the above-mentioned embodiments are not repeated here.

[0064] like Figure 3 As shown, the method of the embodiment of the present disclosure may specifically include:

[0065] S210, receiving a data viewing request for a target table through a client, and determining a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time.

[0066] S220. When the first editing time is later than the second editing time, determine the data editing operation performed to change the second table data to the first table data according to the first editing time and the second editing time, and obtain the table data associated with the data editing operation in the second table data as the data to be changed.

[0067] Among them, the data editing operation may be an operation of editing the table data. Specifically, the data editing operation includes the table data to be edited and the editing mode obtained for the table data to be edited. Optionally, the data editing operation includes performing at least one of the operations of adding data, deleting data, modifying data and moving data position on the table data to be edited. In the embodiment of the present disclosure, when the first editing time is later than the second editing time, the first table data can be obtained by inputting the editing operation on the second table data, and the operation performed by changing the second table data to the first table data can be used as the data editing operation. The data to be changed may be the table data in the second table data to which the data editing operation acts. The data to be changed may include multiple data associated with the data editing operation, and optionally, the data to be changed includes at least the table data to be changed and the position data of the table data to be changed in the target table. The table data to be changed may be the table data to be processed. The position data may be used to indicate the position of the table data to be changed in the target table. For example, the position data may be used to indicate the row and column of the table data to be changed in the target table, or the display position in the visualization window.

[0068] In an embodiment of the present disclosure, when the first editing time is later than the second editing time, the data editing operation performed on the target table between the first editing time and the second editing time can be determined, and the determined data editing operation can be used as the data editing operation performed to change the second table data to the first table data. Further, the second table data can be analyzed according to the data editing operation, and the table data acted upon by the data editing operation can be determined as the table data to be changed, and the position data of the table data to be changed in the target table can be determined. Further, the determined table data to be changed and the position data of the table data to be changed in the target table can be used as the data to be changed.

[0069] It should be noted that, in the case where the target table is edited multiple times at different times, in order to be able to quickly find the table data obtained after the target table is edited at any historical time and the data editing operation performed on the target table at the historical time, after obtaining the table data obtained after the target table is edited at the historical time, the table data can be associated with the editing time and the operation identifier used to characterize the corresponding data editing operation and stored. Furthermore, when it is necessary to determine the data editing operation performed to change the second table data to the first table data, the operation identifier corresponding to the first editing time and the operation identifier between the first editing time and the second editing time can be determined, and then the data editing operation performed can be determined based on the determined operation identifier.

[0070] Optionally, determining the data editing operation performed to change the second table data to the first table data according to the first editing time and the second editing time includes: determining the first data change identifier corresponding to the first editing time and the second data change identifier between the first editing time and the second editing time, and obtaining the data editing operation performed on the table data corresponding to the first data change identifier and the second data change identifier. The advantage of such a setting is that it achieves the effect of effectively determining the data editing operation performed between the first editing time and the second editing time according to the two times, and determining the data editing operation performed according to the data change identifier, thereby enhancing the convenience of the data editing operation determination process, and further improving the efficiency of constructing the table data requested to be viewed.

[0071] Among them, the first data change identifier can be used to characterize the data editing operation performed on the target table at the first editing time. The first data change identifier can be any type of information that can characterize the data editing operation. Optionally, the first data change identifier is information based on numbers, text or other characters. The second data change identifier can be used to characterize the data change process of the target table between the first editing time and the second editing time. The number of second data change identifiers can be one or more. In the embodiment of the present disclosure, the change from the second table data to the first table data can be after at least one data change, and then, when determining the data editing operation performed to change the second table data to the first table data, the data change identifier between the first editing time and the second editing time can be determined to determine the data change process from the second table data to the first table data based on the data change identifier.

[0072] As an optional implementation of an embodiment of the present disclosure, after the target table is edited and the table data is obtained, the table data, the editing time, and the data change identifier representing the change in the target table can be stored in association. Further, when the first editing time and the second editing time are determined, the first data change identifier corresponding to the first editing time and the second data change identifier between the first editing time and the second editing time can be determined by a pre-constructed association relationship. Furthermore, the data editing operations performed on the table data at the first editing time and the data editing operations performed on the table data at the first editing time and the second editing time can be determined based on the first data identifier, and the determined data editing operations are used as the data editing operations performed to change the second table data to the first table data.

[0073] S230 , backing up the data to be changed, and displaying the first table data on the client according to the second table data and the backed-up data to be changed.

[0074] In an embodiment of the present disclosure, when determining a data editing operation performed to change the second table data into the first table data, the first table data can be determined according to the data editing operation, the second table data and the backed-up data to be changed, and the first table data can be displayed in the client.

[0075] Optionally, displaying the first table data on the client according to the second table data and the backed-up data to be changed includes: performing a data editing operation on the backed-up data to be changed to generate target change data, and displaying the first table data on the client according to the second table data and the target change data.

[0076] The target changed data may be table data generated after a data editing operation is performed on the backed up data to be changed.

[0077] As an optional implementation of the first embodiment of the present disclosure, the table data to be changed and the position data of the table data to be changed in the target table can be determined based on the backed up data to be changed. Further, a data editing operation can be performed on the table data to be changed based on the position data to generate target change data. Further, the first table data can be determined based on the target change data and the second table data, and the first table data can be displayed in the client. The advantage of such a setting is that by applying a data editing operation to the backed up data to be changed to construct the table data requested to be viewed, the effect of applying a data editing operation to the stored and backed up table data to display the table data requested to be viewed is achieved, the response rate of the client when viewing different historical edited data is improved, and the processing performance of the client for the table data is improved.

[0078] Optionally, displaying the first table data on the client according to the second table data and the target change data includes: determining unchanged table data in the second table data except for the data to be changed, and displaying the first table data on the client according to the unchanged data and the target change data.

[0079] The unchanged table data may be data associated with other table data in the second table data except the table data to be changed. Optionally, the unchanged table data at least includes the unchanged table data and the position data of the unchanged table data in the target table. Exemplarily, it is assumed that the second table data includes three data records, namely record A, record B and record C, and record B is the table data to be changed. Furthermore, record A and record C may be regarded as unchanged table data.

[0080] As an optional implementation manner of the present embodiment, unchanged table data other than the data to be changed in the second table data can be determined based on the data to be changed, and the unchanged table data can include unchanged table data and position data of the unchanged table data in the target table. Furthermore, table data can be generated based on the table data to be changed in the data to be changed and its position data in the target table and the unchanged table data in the unchanged table data and its position data in the target table, and the generated table data can be used as the first table data. Furthermore, the first table data can be displayed in the client. The advantage of such a setting is that it achieves the effect of constructing the table data requested to be viewed based on the stored table data and data editing operations, and achieves the effect of improving the response rate of the client when viewing different historical edited data on the basis of effectively saving the client's resource occupation space.

[0081] For example, Figure 4 This is a schematic diagram of the table data display process provided by the embodiment of the present disclosure. Figure 4As shown, the table data stored in the history record manager includes record A, record B and record C. When the model layer requests to view the table data, the required table data can be pulled from the history record manager. Further, when it is determined that the data to be changed is record B according to the table data requested to be viewed and the stored table data, record B can be backed up, and according to the backed up record B ( Figure 4 The solid-line box in the figure shows the unchanged records A and C ( Figure 4 The table data requested is constructed (indicated by a dotted box in the figure).

[0082] The technical solution of the disclosed embodiment determines the data editing operation performed to change the second table data to the first table data according to the first editing time and the second editing time when the first editing time is later than the second editing time, obtains the table data associated with the data editing operation in the second table data as the data to be changed, thereby achieving the effect of determining the data editing operation performed on the table data within the two editing times according to the stored editing time and the editing time requested to be viewed, and then determining the data to be changed based on the data editing operation, thereby achieving the effect of using the stored table data as the data basis for constructing the table data requested to be viewed.

[0083] Figure 5 A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of the embodiment of the present disclosure is based on the above-mentioned embodiment. After determining that the first table data requested to be viewed corresponds to the first editing time of the target table, it also includes: when the first editing time is earlier than the second editing time, pulling the third table data corresponding to the target table at the first editing time from the server, and storing the third table data on the client; based on the third table data stored on the client, displaying the first table data corresponding to the data viewing request on the client. For specific implementation methods, please refer to the description of the embodiment of the present disclosure. Among them, technical features that are the same or similar to those of the above-mentioned embodiments are not repeated here. Figure 5 As shown, the method of the embodiment of the present disclosure may specifically include:

[0084] S310, receiving a data viewing request for a target table through a client, and determining a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time.

[0085] S320: When the first editing time is earlier than the second editing time, third table data corresponding to the target table at the first editing time is pulled from the server, and the third table data is stored in the client.

[0086] The third table data may be table data corresponding to the target table at the first editing time and pulled from the server by the client.

[0087] In the embodiment of the present disclosure, when the first editing time is earlier than the second editing time, it can be indicated that when editing the target table, the first table data edited at the first editing time can be obtained first, and then the second table data edited at the second editing time can be obtained. Furthermore, when viewing the first table data, it may not be possible to determine the specific content in the first table data through the second table data. Furthermore, the table data corresponding to the target table at the first editing time can be pulled from the server, the pulled table data can be used as the third table data, and the third table data can be stored in the client.

[0088] S330: Display the first table data corresponding to the data viewing request on the client based on the third table data stored in the client.

[0089] In the embodiment of the present disclosure, when the client stores third table data corresponding to the target table at the first editing time, the stored third table data can be used as the first table data corresponding to the data viewing request, and the first table data can be displayed in the client.

[0090] S340: When the first editing time is later than the second editing time, determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time.

[0091] S350 , backing up the data to be changed, and displaying the first table data on the client according to the second table data and the backed-up data to be changed.

[0092] The technical solution of the disclosed embodiment is, after determining that the first table data requested to be viewed corresponds to the first editing time of the target table, when the first editing time is earlier than the second editing time, the third table data corresponding to the target table at the first editing time is pulled from the server, and the third table data is stored on the client. Based on the third table data stored on the client, the first table data corresponding to the data viewing request is displayed on the client, thereby achieving the effect of pulling the table data requested to be viewed from the server through the client when the editing time requested to be viewed is earlier than the stored editing time, that is, achieving the effect of pulling the table data requested to be viewed from the server in a targeted manner, thereby effectively saving the resource occupation space of the client.

[0093] Figure 6A flowchart of another table data processing method provided by an embodiment of the present disclosure. The technical solution of the embodiment of the present disclosure is based on the above embodiment. When the target table is the first sub-table in the database table and the database table includes the second sub-table, a sub-table switching operation for the second sub-table is received by the client, and the fourth table data of the second sub-table at the second editing time is displayed according to the second table data. For specific implementation methods, please refer to the description of the embodiment of the present disclosure. Among them, the technical features that are the same or similar to the above embodiments are not repeated here.

[0094] like Figure 6 As shown, the method of the embodiment of the present disclosure may specifically include:

[0095] S410, receiving a data viewing request for a target table through a client, and determining a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time.

[0096] S420: When the first editing time is later than the second editing time, determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time.

[0097] S430 , backing up the data to be changed, and displaying the first table data on the client according to the second table data and the backed-up data to be changed.

[0098] S440: When the target table is the first sub-table in the database table and the database table includes the second sub-table, a sub-table switching operation for the second sub-table is received through the client, and fourth table data of the second sub-table at the second editing time is displayed according to the second table data.

[0099] Among them, the database table may contain multiple sub-tables. Cross-table operations can also be performed between multiple sub-tables by means of cross-table formulas, unidirectional or bidirectional association fields, and reference field lookup. The second sub-table may be other data tables in the database table except the first sub-table. Exemplarily, it is assumed that the database table contains 5 sub-tables, namely data table 1, data table 2, data table 3, data table 4, and data table 5. In the case where data table 2 is the first sub-table, data set 1, data table 3, data table 4, and data table 5 are the second sub-tables. The sub-table switching operation can be understood as an operation of switching the sub-table displayed in the interface to other sub-tables. Optionally, the sub-table switching operation includes but is not limited to at least one of a click operation (including a single click and multiple clicks), a long press operation, a touch operation, and a sliding operation. The fourth table data may be the table data obtained by editing the second sub-table in the target table at the second editing time. It should be noted that a single sub-table may also be a database table.

[0100] In the embodiment of the present disclosure, when the target table is the first sub-table in the database table and the database table includes the second sub-table, after the first table data corresponding to the target table is displayed through the client, when the sub-table switching operation for the second sub-table is received through the client, the second editing time corresponding to the table data to be displayed in the second sub-table can be determined according to the second table data corresponding to the target table stored in the client. Further, the fourth table data corresponding to the second sub-table at the second editing time can be determined, and the fourth table data can be displayed in the client.

[0101] It should be noted that there are multiple ways to display the fourth table data according to the second table data. Optionally, while the client stores the second table data corresponding to the target table at the second editing time, the fourth table data corresponding to the second subtable at the second editing time may also be stored. Alternatively, the second editing time is determined based on the second table data stored by the client, and the fourth table data corresponding to the second subtable at the second editing time is pulled from the server based on the second editing time and the second subtable.

[0102] As an optional implementation of an embodiment of the present disclosure, when a sub-table switching operation for a second sub-table is detected, the editing time of the table data corresponding to the second sub-table to be displayed can be determined as the second editing time based on the second table data stored in the client. Further, the fourth table data corresponding to the second sub-table at the time of the second editing can be pulled from the server based on the second editing time and the second sub-table, the fourth table data can be stored in the client, and the fourth table data can be displayed in the client.

[0103] For example, Figure 7 This is a schematic diagram of an interface for displaying a database table provided by an embodiment of the present disclosure. Figure 7As shown, the display interface includes a data table switching area 60, a data table display area 61 and a history display area 62. The data table switching area displays data table 1, data table 2, data table 3, data table 4 and data table 5. The history display area displays history records 1, history records 2, history records 3, history records 4, history records 5 and history records 6. Among them, history record 1 corresponds to historical editing time A, history record 2 corresponds to historical editing time B, history record 3 corresponds to historical editing time C, history record 4 corresponds to historical editing time D, history record 5 corresponds to historical editing time E, and history record 6 corresponds to historical editing time F. Moreover, the time order of these six historical editing times is historical editing time A, historical editing time B, historical editing time C, historical editing time D, historical editing time E and historical editing time F, with historical editing time A being the earliest and historical editing time F being the latest. The tabular data corresponding to the corresponding data table at the corresponding historical editing time can be displayed based on the data table display area. In the case where the client stores the table data corresponding to the historical editing time C of the data table 2, after the table data corresponding to the historical editing time D of the data table 3 is displayed in the data table display area, in the case where the sub-table switching operation for the data table 2 is detected, the editing time of the table data corresponding to the data table 2 to be displayed can be determined as the historical editing time C according to the table data corresponding to the historical editing time C of the data table 2 stored in the client. Further, the table data corresponding to the data table 2 at the historical editing time C can be pulled from the server, the table data can be displayed in the data table display area, and the historical record 3 corresponding to the historical editing time C can be highlighted in the historical record display area.

[0104] The technical solution of the disclosed embodiment, after displaying the second table data or the first table data of the target table at the second editing time in the client, when the target table is the first sub-table in the database table and the database table includes the second sub-table, receives the sub-table switching operation for the second sub-table through the client, and displays the fourth table data of the second sub-table at the second editing time according to the second table data, thereby achieving the effect that the sub-tables in the database table are displayed independently of each other, that is, achieving the effect that when the table data displayed by any sub-table is changed, other sub-tables are not affected by it.

[0105] Figure 8 A schematic diagram of the structure of a table data processing device provided by an embodiment of the present disclosure is shown in FIG. Figure 8As shown, the device includes: a data viewing request module 510, a data to be changed determination module 520 and a data request display module 530. The data viewing request module 510 is used to receive a data viewing request for a target table through a client, and determine a first editing time corresponding to the first table data requested for viewing; the client stores second table data corresponding to the target table at a second editing time; the data to be changed determination module 520 is used to determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time when the first editing time is later than the second editing time; the data request display module 530 is used to back up the data to be changed, and display the first table data on the client according to the second table data and the backed up data to be changed.

[0106] The technical solution of the disclosed embodiment receives a data viewing request for a target table through a client, determines a first editing time corresponding to the first table data requested to be viewed, triggers viewing of the table data and execution of subsequent operations determined by the table data through interactive operations between the user and the client, and the client stores second table data corresponding to the target table at the second editing time, thereby achieving an effect of storing at least part of the table data corresponding to the target table in the client, so as to use the stored table data as the data basis for subsequent operations; further, in a case where the first editing time is later than the second editing time, determines the data to be changed in the second table data corresponding to the data viewing request based on the first editing time and the second editing time, thereby achieving an effect of using the stored table data as the data basis for the requested viewing when the editing time requested to be viewed is later than the stored editing time. The effect of constructing the data foundation of the table data of the table data is achieved; further, the data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed, which solves the problem that a large amount of resource storage space of the client is occupied in the table data processing method in the related technology, which brings great pressure to the client's memory, and then causes the client to respond slowly to the table viewing request. By backing up the data to be changed in the stored table data to construct the table data requested to be viewed, the effect of constructing the table data requested to be viewed based on the stored table data is achieved, and then, on the basis of ensuring that the modification of the stored data does not affect the client cache, the effect of effectively saving the client's resource occupation space is achieved, and then, the response rate of viewing the table data through the client is improved, and the client's processing performance for the table data is improved.

[0107] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the module 520 for determining data to be changed is specifically used to determine the data editing operation performed to change the second table data to the first table data according to the first editing time and the second editing time, and obtain the table data associated with the data editing operation in the second table data as the data to be changed.

[0108] Based on any optional technical solution in the embodiments of the present disclosure, the module 520 for determining data to be changed optionally includes: a data editing operation acquisition unit. The data editing operation acquisition unit is used to determine a first data change identifier corresponding to the first editing time and a second data change identifier between the first editing time and the second editing time, and acquire the data editing operation performed on the table data corresponding to the first data change identifier and the second data change identifier.

[0109] On the basis of any optional technical solution in the embodiments of the present disclosure, optionally, the data to be changed includes at least table data to be changed and position data of the table data to be changed in the target table.

[0110] Based on any optional technical solution in the embodiments of the present disclosure, the request data display module 530 optionally includes: a table data display unit. The table data display unit is used to perform the data editing operation on the backed up data to be changed to generate target change data, and display the first table data in the client according to the second table data and the target change data.

[0111] Based on any optional technical solution in the embodiments of the present disclosure, optionally, a table data display unit is specifically used to determine unchanged table data in the second table data except the data to be changed, and display the first table data in the client according to the unchanged data and the target changed data.

[0112] On the basis of any optional technical solution in the embodiments of the present disclosure, the device may further include: a data pulling module and a table data display module. The data pulling module is used to pull third table data corresponding to the target table at the first editing time from the server after determining that the first table data requested for viewing corresponds to the first editing time of the target table, if the first editing time is earlier than the second editing time, and store the third table data in the client; the table data display module is used to display the first table data corresponding to the data viewing request in the client based on the third table data stored in the client.

[0113] On the basis of any optional technical solution in the embodiments of the present disclosure, the device may further include: a sub-table switching module. The sub-table switching module is configured to, after displaying the second table data or the first table data of the target table at the second editing time in the client, receive a sub-table switching operation for the second sub-table through the client when the target table is the first sub-table in the database table and the database table includes the second sub-table, and display the fourth table data of the second sub-table at the second editing time according to the second table data.

[0114] Based on any optional technical solution in the embodiments of the present disclosure, the device may further include: a data highlighting module, wherein the data highlighting module is configured to highlight the target table data generated by editing the target table at the first editing time in the first table data after the first table data is displayed on the client according to the second table data and the backed-up data to be changed.

[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. 9 , which shows an electronic device (eg, Fig. 9 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. 9 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. 9As 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. 9 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 embodiment of the present disclosure has the same beneficial effects as the above embodiment.

[0123] The embodiments of the present disclosure provide 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 in the above embodiments 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: receiving a data viewing request for a target table through a client, and determining a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time; when the first editing time is later than the second editing time, determining the data to be changed in the second table data corresponding to the data viewing request based on the first editing time and the second editing time; backing up the data to be changed, and displaying the first table data in the client based on the second table data and the backed-up data to be changed.

[0126] According to one or more embodiments of the present disclosure, [Example 2] provides the method of Example 1, further including: optionally, determining the data to be changed in the second table data based on the first editing time and the second editing time, including: determining the data editing operation performed to change the second table data to the first table data based on the first editing time and the second editing time, and obtaining the table data associated with the data editing operation in the second table data as the data to be changed.

[0127] According to one or more embodiments of the present disclosure, [Example Three] provides the method of Example Two, further including: optionally, determining the data editing operation performed to change the second table data to the first table data based on the first editing time and the second editing time, including: determining a first data change identifier corresponding to the first editing time and a second data change identifier located between the first editing time and the second editing time, and obtaining the data editing operation performed on the table data corresponding to the first data change identifier and the second data change identifier.

[0128] According to one or more embodiments of the present disclosure, [Example 4] provides the method of Example 2, further comprising: optionally, the data to be changed includes at least the table data to be changed and the position data of the table data to be changed in the target table.

[0129] According to one or more embodiments of the present disclosure, [Example 5] provides the method of Example 2, further including: optionally, displaying the first table data in the client according to the second table data and the backed up data to be changed, including: performing the data editing operation on the backed up data to be changed to generate target change data, and displaying the first table data in the client according to the second table data and the target change data.

[0130] According to one or more embodiments of the present disclosure, [Example Six] provides the method of Example Five, further including: optionally, displaying the first tabular data in the client according to the second tabular data and the target change data includes: determining unchanged tabular data in the second tabular data except the data to be changed, and displaying the first tabular data in the client according to the unchanged data and the target change data.

[0131] According to one or more embodiments of the present disclosure, [Example 7] provides the method of Example 1, further including: optionally, after determining that the first table data requested to be viewed corresponds to the first editing time of the target table, it also includes: when the first editing time is earlier than the second editing time, pulling the third table data corresponding to the target table at the first editing time from the server, and storing the third table data in the client; based on the third table data stored in the client, displaying the first table data corresponding to the data viewing request in the client.

[0132] According to one or more embodiments of the present disclosure, [Example 8] provides the method of Example 1, further including: optionally, after the second table data or the first table data of the target table at the second editing time is displayed in the client, it also includes: when the target table is the first sub-table in the database table and the database table includes a second sub-table, receiving a sub-table switching operation for the second sub-table through the client, and displaying fourth table data of the second sub-table at the second editing time according to the second table data.

[0133] According to one or more embodiments of the present disclosure, [Example 9] provides the method of Example 1, further including: optionally, after displaying the first table data in the client according to the second table data and the backed-up data to be changed, it also includes: highlighting the target table data generated by editing the target table at the first editing time in the first table data.

[0134] According to one or more embodiments of the present disclosure, [Example 10] provides a table data processing device, including: a data viewing request module, used to receive a data viewing request for a target table through a client, and determine a first editing time corresponding to the first table data requested to be viewed; the client stores second table data corresponding to the target table at a second editing time; a to-be-changed data determination module, used to determine the to-be-changed data in the second table data corresponding to the data viewing request according to the first editing time and the second editing time when the first editing time is later than the second editing time; a data display request module, used to back up the to-be-changed data, and display the first table data on the client according to the second table data and the backed-up to-be-changed data.

[0135] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (Hyper Text 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.

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

[0137] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: receives a data viewing request for a target table through a client, and determines a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time;

[0138] In a case where the first editing time is later than the second editing time, determining the data to be changed in the second table data corresponding to the data viewing request according to the first editing time and the second editing time;

[0139] The data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed.

[0140] 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).

[0141] 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.

[0142] The units involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of a unit does not limit the unit itself in some cases. For example, a data viewing request module may also be described as a "module for receiving a data viewing request for a target table."

[0143] 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.

[0144] 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.

[0145] 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.

[0146] 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.

[0147] 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: Receiving, through a client, a data viewing request for a target table, and determining a first editing time corresponding to first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time; In a case where the first editing time is later than the second editing time, determining the data to be changed in the second table data corresponding to the data viewing request according to the first editing time and the second editing time; The data to be changed is backed up, and the first table data is displayed on the client according to the second table data and the backed up data to be changed.

2. The table data processing method according to claim 1, characterized in that: The step of determining the data to be changed in the second table data according to the first editing time and the second editing time includes: Determine a data editing operation performed to change the second table data into the first table data according to the first editing time and the second editing time, and obtain table data associated with the data editing operation in the second table data as data to be changed.

3. The table data processing method according to claim 2, characterized in that: The data editing operation performed to change the second table data into the first table data according to the first editing time and the second editing time includes: Determine a first data change identifier corresponding to the first editing time and a second data change identifier between the first editing time and the second editing time, and obtain a data editing operation performed on the table data corresponding to the first data change identifier and the second data change identifier.

4. The table data processing method according to claim 2, characterized in that: The data to be changed at least includes table data to be changed and position data of the table data to be changed in the target table.

5. The table data processing method according to claim 2, characterized in that: The step of displaying the first table data on the client according to the second table data and the backed-up data to be changed includes: The data editing operation is performed on the backed up data to be changed to generate target changed data, and the first table data is displayed on the client according to the second table data and the target changed data.

6. The table data processing method according to claim 5, characterized in that: The step of displaying the first table data on the client according to the second table data and the target change data comprises: Unchanged table data other than the to-be-changed data in the second table data is determined, and the first table data is displayed on the client according to the unchanged data and the target changed data.

7. The table data processing method according to claim 1, characterized in that: After determining that the first table data requested to be viewed corresponds to the first editing time of the target table, the method further includes: In the case where the first editing time is earlier than the second editing time, pulling third table data corresponding to the target table at the first editing time from the server, and storing the third table data in the client; The first table data corresponding to the data viewing request is displayed in the client based on the third table data stored in the client.

8. The table data processing method according to claim 1, characterized in that: After the second table data or the first table data of the target table at the second editing time is displayed in the client, the method further includes: When the target table is the first subtable in a database table and the database table includes a second subtable, a subtable switching operation for the second subtable is received by the client, and fourth table data of the second subtable at the second editing time is displayed according to the second table data.

9. The table data processing method according to claim 1, characterized in that: After displaying the first table data on the client according to the second table data and the backed-up data to be changed, the method further includes: The target table data generated by editing the target table at the first editing time is highlighted and displayed in the first table data.

10. A table data processing device, characterized in that: include: A data viewing request module, used to receive a data viewing request for a target table through a client, and determine a first editing time corresponding to the first table data requested to be viewed; wherein the client stores second table data corresponding to the target table at a second editing time; A module for determining data to be changed, configured to determine the data to be changed corresponding to the data viewing request in the second table data according to the first editing time and the second editing time when the first editing time is later than the second editing time; The data request module is used to back up the data to be changed, and display the first table data in the client according to the second table data and the backed up data to be changed.

11. 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 according to any one of claims 1 to 9.

12. 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 9.

13. 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 9.

Images