Table data processing methods, apparatus, equipment, media, and products

Abstract

We provide table data processing methods, apparatus, equipment, media, and products. [Solution] The method includes the steps of: receiving a data viewing request for a target table from a client, determining a first editing time corresponding to the first table data for which viewing was requested, wherein the client has second table data corresponding to the target table stored in the second editing time; if the first editing time is later than the second editing time, determining the data to be modified from the second table data corresponding to the data viewing request based on the first and second editing times; backing up the data to be modified, and displaying the first table data in the client based on the second table data and the backed-up data to be modified.

Description

Technical Field

[0001] Embodiments of the present disclosure relate to the field of computer processing technology, and in particular to a method, apparatus, device, medium, and product for processing table data.

Background Art

[0002] With the rapid development of Internet offices, the analysis, processing, and collection of data have become very important, and the application of tables is also expanding more and more. Users can store and manage data through tables, and support browsing of historical table data obtained by editing tables at any historical time point by users.

[0003] In related technologies, every time a user browses historical table data corresponding to a table at an arbitrary historical time point, it is necessary to obtain the historical table data corresponding to the corresponding historical time point from the server and cache and display the obtained historical table data in the client. However, according to this table data processing method, the speed at which the client responds to table browsing requests becomes slow, and a large amount of the client's resource storage space is occupied, imposing a heavy burden on the client's memory, which may affect the user's table usage experience.

Summary of the Invention

Means for Solving the Problems

[0004] The present disclosure provides a method, apparatus, device, medium, and product for processing table data, realizing the effect of constructing the table data requested for browsing based on the stored table data, and further ensuring that the modification of the stored data does not affect the cache of the client, and realizing the effect of effectively saving the resource occupation space of the client.

[0005] According to a first aspect, embodiments of the present disclosure provide a method for processing table data, the method comprising: The steps include: receiving a data access request for a target table from a client, determining a first editing time corresponding to the requested first table data, wherein the client has a second table data corresponding to the target table stored in the second editing time; If the first editing time is later than the second editing time, the process involves determining the data to be modified from the second table data that corresponds to the data viewing request, based on the first and second editing times. The process includes the steps of 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.

[0006] According to a second aspect, the embodiments of the present disclosure further provide a table data processing device, which is A data retrieval request module that receives a data retrieval request for a target table from a client and determines a first editing time corresponding to the first table data for which retrieval was requested, wherein the client has a second table data corresponding to the target table stored in the second editing time. If the first editing time is later than the second editing time, a data determination module for determining the data to be changed from the second table data corresponding to the data viewing request is provided based on the first and second editing times, It includes a request data display module for 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.

[0007] According to a third aspect, embodiments of the present disclosure further provide electronic devices, which include, One or more processors, A storage device for storing one or more programs, When one or more programs are executed on one or more processors, one or more processors are made to implement the table data processing method described in any one of the embodiments of this disclosure.

[0008] According to a fourth aspect, an embodiment of the present disclosure further provides a storage medium including computer-executable instructions, which, when executed by a computer processor, are used to execute a table data processing method described in any one of the embodiments of the present disclosure.

[0009] According to the fifth aspect, the embodiments of the present disclosure further provide a computer program product including a computer program, which, when executed on a processor, implements the table data processing method described in any one of the embodiments of the present disclosure.

[0010] In the technical solution of the embodiment of this disclosure, a data viewing request for a target table is received by the client, a first editing time corresponding to the first table data for which viewing is requested is determined, viewing of the table data is triggered by interactive operation between the user and the client, and subsequent determination operations of table data are performed, the second table data corresponding to the target table is stored in the client at the second editing time, at least a portion of the table data corresponding to the target table is stored in the client, thereby realizing the effect of using the stored table data as a database for subsequent operations, and further, if the first editing time is later than the second editing time, the data to be changed from the second table data corresponding to the data viewing request is determined based on the first and second editing times, and if the editing time for which viewing is requested is later than the stored editing time, the stored table data is used as the data construction basis for the table data for which viewing is requested This technology achieves the following effects: it backs up the data to be changed, displays the first table data on the client based on the second table data and the backed-up data to be changed, solves the problem that the table data processing method occupies a large amount of the client's resource storage space, places a heavy burden on the client's memory, and is slow to respond to table viewing requests, and by backing up the data to be changed in the stored table data and constructing the table data requested for viewing, it achieves the effect of constructing the table data requested for viewing based on the stored table data, it ensures that the modification of stored data does not affect the client's cache, effectively saves the resource space occupied by the client, and further improves the response speed of the client viewing table data and improves the client's processing performance for table data.

[0011] By combining the drawings and referring to the following specific embodiments, the above and other features, advantages and aspects of each embodiment of the present disclosure will become more apparent. Throughout the drawings, identical or similar reference numerals refer to identical or similar elements. It should be understood that the drawings are schematic and elements are not necessarily drawn to scale. [Brief explanation of the drawing]

[0012] [Figure 1] This is a schematic flowchart of the table data processing method according to the embodiment of this disclosure. [Figure 2] This is a timing flowchart of the table data processing method according to an embodiment of the present disclosure. [Figure 3] This is a schematic flowchart of another table data processing method according to the embodiments of this disclosure. [Figure 4] This is a schematic diagram of the table data display process according to an embodiment of the present disclosure. [Figure 5] This is a schematic flowchart of another table data processing method according to the embodiments of this disclosure. [Figure 6] This is a schematic flowchart of another table data processing method according to the embodiments of this disclosure. [Figure 7] This is a schematic diagram of an interface for displaying a database table according to an embodiment of the present disclosure. [Figure 8] This is a schematic diagram of the structure of a table data processing device according to an embodiment of the present disclosure. [Figure 9] This is a schematic diagram of the structure of an electronic device for realizing an embodiment of the present disclosure. [Modes for carrying out the invention]

[0013] The embodiments of this disclosure will be described in detail below with reference to the drawings. While specific embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be realized in various forms and should not be construed as being limited to the embodiments described herein. Rather, these embodiments are provided to enable a more thorough and complete understanding of this disclosure. It should be understood that the drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0014] It should be understood that the steps described in the embodiments of the methods of this disclosure may be performed in a different order and / or in parallel. Furthermore, embodiments of the methods may include additional steps and / or omit the performance of the indicated steps. The scope of this disclosure is not limited in these embodiments.

[0015] As used herein, the term “including” and its variations are in open form, meaning “including but not limited to.” The term “based on” means “based at least in part.” The term “one embodiment” means “at least one embodiment,” the term “another embodiment” means “at least one other embodiment,” and the term “several embodiments” means “at least several embodiments.” Relevant definitions of other terms are given in the following explanation.

[0016] It should be noted that the concepts of “first,” “second,” etc., as used in this disclosure are used solely to distinguish between different devices, modules, or units, and are not intended to restrict the order or interdependence of functions performed by these devices, modules, or units.

[0017] It should be noted that the modifiers “one” and “multiple” as used in this disclosure are illustrative and not restrictive. Those skilled in the art should note that unless explicitly stated otherwise in the context, they should be understood as “one or more.”

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

[0019] As can be understood, before using the technical solutions disclosed in each embodiment of the present disclosure, it is necessary to notify the user of the types, usage scopes, usage scenarios, etc. of personal information related to the present disclosure in an appropriate manner in accordance with relevant laws and regulations and obtain the user's permission.

[0020] For example, when responding to receiving a user's voluntary request, by sending prompt information to the user, it is clearly prompted to the user that the operation requested to be performed by it needs to obtain and use the user's personal information. Thereby, the user can independently choose whether to provide personal information to software or hardware such as an electronic device, an application program, a server, or a storage medium that executes the operation of the technical solution of the present disclosure based on the prompt information.

[0021] As an implementable but not limited way, the method of sending prompt information to the user in response to receiving a user's voluntary request may be, for example, in the form of a pop-up window. The prompt information can be presented in text form in the pop-up window. Also, a selection control for the user to select "agree" or "disagree" to provide personal information to the electronic device is also displayed in the pop-up window.

[0022] As can be understood, the above process of notifying and obtaining the user's permission is merely an example and does not limit the implementation manner of the present disclosure. Other methods that meet the relevant laws and regulations can also be applied to the implementation manner of the present disclosure.

[0023] To ensure understanding, data relating to this technical solution (including, but not limited to, the data itself, or the acquisition or use of the data) must comply with the requirements of the corresponding laws, regulations, and related provisions.

[0024] Figure 1 is a schematic flowchart of a table data processing method according to an embodiment of the present disclosure. The embodiment of the present disclosure can be applied to a scenario in which a client views table data obtained by history editing corresponding to a target table, and the method can be executed by a table data processing device, which can be implemented in software and / or hardware form, and can optionally be implemented by an electronic device, which may be a mobile terminal, PC terminal or server, etc.

[0025] As shown in Figure 1, the methods of the embodiments of this disclosure may specifically include S110 to S130.

[0026] S110 receives a data retrieval request for the target table from the client, determines the first editing time corresponding to the first table data requested for retrieval, and stores the second table data corresponding to the target table in the second editing time for the client.

[0027] The target table may be a table that supports viewing the data associated with the table. The target table may be a table of any type. Optionally, the target table may be an independent table or a subtable of one of the access tables. A data viewing request can be understood as a command to request the execution of an operation to view table data. A data viewing request may include multiple generation methods. Optionally, a data viewing request may be generated when a trigger operation against a pre-configured data viewing control is detected, or when it is detected that the received audio information contains a trigger word associated with the viewing data, or when a data viewing trigger command entered by a user is received. The first table data may be a history table editing record corresponding to the target table. In other words, the first table data may be data obtained after editing the target table at a historical time. In embodiments of this disclosure, after creating the target table, the data within the target table can be edited again, and the table data obtained after editing can be set as the table data corresponding to the target table, and the table data obtained by editing can be stored associated with the corresponding editing time. Furthermore, data viewing can be performed on historically edited table data, and the historically edited table data for which viewing is requested can be set as the first table data. The first editing time may be the time it takes to edit and obtain the first table data. The second table data may be the data obtained after editing the target table at a history time stored in the client. The second table data may be the table data corresponding to the target table at a second editing time retrieved from the server by the client. The second editing time may be the time it takes to edit and obtain the second table data. In the embodiments of this disclosure, the first and second editing times may be two adjacent history editing times or two non-adjacent history editing times.

[0028] In possible embodiments of this disclosure, the first table is a database table, and each column of the database table is a unique field type, and the content entered into the cells of each column must correspond to the field type of that column. In other words, the field type can be used to restrict at least one of the following pieces of information: the data format, data type, and data content of the data entered into the cells of that column. Exemplaryly, the field type includes, but is not limited to, one or more of the following types: text type, option type, date type, and numeric type.

[0029] It is important to explain that the second table data stored in the client may be second table data obtained from the server corresponding to the second edit time of the target table, provided that the second edit time is determined randomly, and the obtained second table data is stored in the client. Alternatively, if the client receives a data viewing request for second table data at the second edit time of the target table, the second table data may be obtained from the server, and the second table data is stored in the client.

[0030] In embodiments of this disclosure, a client can retrieve second table data associated with a target table from the server at a second editing time and store the second table data in the client. Furthermore, multiple table data corresponding to the target table can be displayed based on the client's display interface. In addition, when a data viewing request for any table data corresponding to the target table is received from the client, the requested first table data can be determined, and the first editing time corresponding to the first table data can be determined.

[0031] S120, If the first editing time is later than the second editing time, the data to be modified in response to the data viewing request is determined from the second table data based on the first and second editing times.

[0032] The data to be modified may be the table data to be edited in the second table data, compared to the first table data. In embodiments of this disclosure, if the first editing time is later than the second editing time, the first table data can be obtained only after the data editing operation is entered based on the second table data, and the data in the second table data that is edited to obtain the first table data can be the data to be modified. The data to be modified may be the data associated with the data editing operation. Selectively, if the data editing operation that changes from the second table data to the first table data is a data increase operation, the data to be modified may be data that does not exist in the second table data compared to the first table data; or if the data editing operation that changes from the second table data to the first table data is a data deletion operation, the data to be modified may be extraneous data in the second table data compared to the first table data; or if the data editing operation that changes from the second table data to the first table data is a data modification operation, the data to be modified may be data that is modified in the second table data compared to the first table data.

[0033] In practical applications, when a client receives a data retrieval request for the first table data at the first editing time, and the editing time corresponding to the table data stored in the client is earlier than the first editing time, the client typically retrieves the first table data corresponding to the first editing time directly from the server, displays it, and stores it. This data retrieval method can occupy a large amount of the client's resource storage space and may also affect the efficiency of the client's request response.

[0034] In response to the above situation, in the embodiments of this disclosure, when a first editing time corresponding to the first table data for which viewing has been requested is determined, the first editing time can be compared with a second editing time corresponding to the second table data stored in the client. Furthermore, if the first editing time is slower than the second editing time, the table data to be edited in the second table data can be determined based on the first and second editing times compared with the first table data. Furthermore, the determined table data can be designated as the data to be modified in the second table data that corresponds to the data viewing request. Furthermore, the first table data can be determined based on the data to be modified and the second table data. This makes it possible to determine the table data for which viewing has been requested based on the table data stored in the client, and further improves the efficiency of request response and data viewing.

[0035] In one selectable embodiment of the embodiments of this disclosure, both the first table data and the second table data are table data obtained after editing based on a data editing operation, and if 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, if it is determined that the first editing time is later than the second editing time, the data editing operation that needs to be performed to change the second table data to the first table data can be determined based on the first and second editing times. Furthermore, the data associated with the second table data and the data editing operation can be determined, and said data can be made the data to be modified.

[0036] S130 backs up the data to be changed and displays the data from the first table in the client based on the second table data and the backed-up data to be changed.

[0037] In the embodiments of this disclosure, once the data to be changed has been determined, the data to be changed can be backed up. Furthermore, the backed-up data to be changed can be processed. Furthermore, based on the changed data and second table data obtained after processing, the first table data can be determined and the first table data can be displayed in the client.

[0038] In practical applications, when it's necessary to edit table data stored on a client to obtain requested table data, a full backup of the stored table data is typically performed. Furthermore, the backed-up table data is edited to obtain the requested table data. This data processing method can potentially occupy a large amount of the client's resource storage space, placing an extreme burden on the client's memory and performance.

[0039] In response to the above situation, the embodiments of this disclosure can determine the data to be modified from the second table data stored in the client that corresponds to the data viewing request. Furthermore, the data to be modified 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 modified. This means that, compared to performing a full backup of the stored table data, only the table data that needs to be modified needs to be backed up, effectively saving the resource space occupied by the client and further improving the efficiency of the client's request response.

[0040] In one selectable embodiment of the embodiments of this disclosure, after backing up the data to be changed, data editing operations can be performed on the backed-up data to be changed, thereby obtaining the target changed data. Furthermore, other table data from the second table data other than the data to be changed can be determined. Furthermore, table data can be constructed based on the target changed data and the other table data, and the constructed table data can be designated as the first table data, and the first table data can be displayed in the client.

[0041] In embodiments of the present disclosure, the first table data is table data obtained after editing the target table at a first editing time, and when displaying the first table data, the further step includes optionally displaying the first table data in the client based on the second table data and backed-up data to be changed, and then highlighting the target table data generated by editing the target table at the first editing time, in order to quickly capture the data to be edited in the target table at the first editing time based on the displayed first table data for the user.

[0042] The target table data may be table data generated by editing the first table data during the first editing time. The target table data may also be at least a portion of the table data from the first table data.

[0043] In one optional embodiment of the embodiments of this disclosure, target table data can be determined by editing the target table at a first editing time based on the first editing time. Furthermore, when displaying the first table data to the client, the determined target table data can be highlighted within the first table data.

[0044] As an example, Figure 2 is a timing flowchart of a table data processing method according to an embodiment of the present disclosure. As shown in Figure 2, when a user inputs a history record preview operation for a target table via the client's view layer, the server can retrieve the history edit table data necessary for the preview from the server's history record manager and cache it on the client. Furthermore, the cached history edit table data is passed to the model layer (used at least to process the display data of the client's view layer), thereby enabling the construction of the necessary data for the view layer based on the model layer. Furthermore, after the construction is complete, the constructed table rendering data can be passed to the view layer, and the view layer is notified to start rendering, and the table data obtained by rendering based on the view layer is displayed.

[0045] In the technical solution of the embodiment of this disclosure, a client receives a data viewing request for a target table, determines a first editing time corresponding to the first table data for which viewing is requested, and through interactive operation between the user and the client, it is possible to trigger viewing of the table data and to perform subsequent table data determination operations. The client stores second table data corresponding to the target table at the second editing time, and stores at least a portion of the table data corresponding to the target table in the client, thereby realizing the effect of using the stored target table as a database for subsequent operations. Furthermore, if the first editing time is later than the second editing time, the data to be changed from the second table data corresponding to the data viewing request is determined based on the first and second editing times, and if the editing time for which viewing is requested is later than the stored editing time, the stored table data is used as the data construction base for the table data for which viewing is requested. This technology achieves the desired effect, further backs up the data to be changed, displays the first table data on the client based on the second table data and the backed-up data to be changed, solves the problem that the table data processing method occupies a large amount of the client's resource storage space, places a heavy burden on the client's memory, and slows down the client's response speed to table viewing requests, and achieves the effect of constructing the requested table data based on the stored table data by backing up the data to be changed in the stored table data, further ensures that the modification of stored data does not affect the client's cache, effectively saves the client's resource space, and further improves the response speed of the client viewing table data, thereby improving the client's processing performance for table data.

[0046] Figure 3 is a schematic flowchart of another table data processing method according to an embodiment of the present disclosure. The technical solution of the embodiment of the present disclosure embodies a method for determining data to be modified based on a first editing time and a second editing time, based on the above embodiment. Optionally, the step of determining data to be modified in the second table data based on a first editing time and a second editing time includes determining the data editing operations performed to change the second table data to the first table data based on the first editing time and a second editing time, and obtaining the table data from the second table data associated with the data editing operations as the data to be modified. Specific embodiments can be found in the description of the embodiments of the present disclosure. Technical features identical or similar to those of the above embodiment will not be repeated here.

[0047] As shown in Figure 3, the method of the embodiment of this disclosure may specifically include S210 to S230.

[0048] S210 receives a data viewing request for the target table from the client, determines the first editing time corresponding to the first table data for which viewing was requested, and stores the second table data corresponding to the target table in the client's system after the second editing time.

[0049] S220, If the first editing time is later than the second editing time, the data editing operations performed to change the second table data to the first table data are determined based on the first and second editing times, and the table data from the second table associated with the data editing operations is retrieved as the data to be changed.

[0050] A data editing operation may be an operation to edit table data. Specifically, a data editing operation includes edited table data and an editing method obtained for the edited table data. Optionally, a data editing operation includes performing at least one of the following operations on the edited table data: data increment operation, data deletion operation, data modification operation, and data position movement operation. In embodiments of this disclosure, if the first editing time is later than the second editing time, the first table data can be obtained by inputting an editing operation on the second table data, and the operation performed to change from the second table data to the first table data can be considered a data editing operation. The data to be modified may be the table data on which the data editing operation was applied from the second table data. The data to be modified may include multiple data associated with the data editing operation, and optionally, the data to be modified includes at least the table data to be modified and the position data of the table data to be modified in the target table. The table data to be modified may be the table data to be processed. The position data can be used to indicate the location of the table data to be modified in the target table. For example, the position data can be used to indicate the row and column of the table data to be modified in the target table, or the display position in the visualization window.

[0051] In embodiments of this disclosure, if the first editing time is later than the second editing time, the data editing operations performed on the target table between these two times can be determined based on the first and second editing times, and the determined data editing operations can be considered as data editing operations performed to change the second table data to the first table data. Furthermore, the second table data can be analyzed based on the data editing operations, and the table data on which the data editing operations act 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. Furthermore, the determined table data to be changed and the position data of the table data to be changed in the target table can be considered as the data to be changed.

[0052] One point that needs to be explained is that when a target table is edited multiple times at different times, the table data obtained after editing the target table at any subsequent historical time and the data editing operations performed on the target table at that historical time can be quickly found. This is because, after obtaining the table data obtained after editing the target table at a historical time, the table data can be stored in association with an operation identifier that characterizes the editing time and the corresponding data editing operation. Furthermore, if 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 and second editing times can be determined, and then the data editing operation performed can be determined based on the determined operation identifier.

[0053] The step of selecting which data editing operations were performed to change the second table data to the first table data based on the first and second editing times includes determining the first data change identifier corresponding to the first editing time and the second data change identifier between the first and second editing times, and obtaining the data editing operations performed on the table data corresponding to the first and second data change identifiers. This configuration effectively determines the data editing operations performed between the first and second editing times, determines the data editing operations performed according to the data change identifiers, improves the convenience of the data editing operation determination process, and further improves the efficiency of constructing the requested table data.

[0054] A first data change identifier can be used to characterize a data editing operation performed on a target table during a first editing time. The first data change identifier may be any type of information that can characterize a data editing operation. Optionally, the first data change identifier may be numerical, text, or other character-based information. A second data change identifier can be used to characterize the data change process of the target table between a first editing time and a second editing time. There may be one or more second data change identifiers. In embodiments of this disclosure, the change from second table data to first table data may occur through at least one data change, and furthermore, when determining the data editing operation performed to change the second table data to first table data, a data change identifier between the first editing time and the second editing time can be determined, thereby determining the data change process that changes the second table data to first table data based on the data change identifier.

[0055] In one selectable embodiment of the embodiments of this disclosure, after editing a target table and obtaining table data, the table data, editing time, and a data change identifier that characterizes the change in the target table can be stored in association. Furthermore, when determining the first and second editing times, a first data change identifier corresponding to the first editing time and a second data change identifier between the first and second editing times can be determined based on a pre-established association. Furthermore, based on the first data identifier, it is possible to determine 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 both the first and second editing times, and the determined data editing operations can be defined as data editing operations performed to change the second table data to the first table data.

[0056] S230 backs up the data to be changed and displays the data in the first table on the client based on the second table data and the backed-up data to be changed.

[0057] In embodiments of this disclosure, when determining a data editing operation performed to change second table data to first table data, the first table data can be determined based on 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.

[0058] The step of displaying the first table data in the client based on the second table data and the backed-up data to be changed, as selectable, includes the steps of performing a data editing operation on the backed-up data to be changed to generate target change data, and then displaying the first table data in the client based on the second table data and the target change data.

[0059] Target change data may also be table data generated after performing data editing operations on the backed-up data to be changed.

[0060] In one selectable embodiment of the embodiments of this disclosure, the table data to be modified and the position data of the table data to be modified in the target table can be determined based on the backed-up data to be modified. Furthermore, data editing operations can be performed on the table data to be modified according to the position data to generate target modified data. Furthermore, the first table data can be determined based on the target modified data and the second table data, and the first table data can be displayed in the client. With this configuration, the table data requested for viewing can be constructed by applying data editing operations to the backed-up data to be modified, and the table data requested for viewing can be displayed by applying data editing operations to the stored and backed-up table data, which has the advantage of improving the response speed when the client views different history editing data and improving the processing performance of the client's table data.

[0061] The step of displaying the first table data in the client based on the second table data and the target change data, in an optional manner, includes determining the unchanged table data from the second table data other than the data to be changed, and displaying the first table data in the client based on the unchanged data and the target change data.

[0062] Unmodified table data may also be data associated with other table data in the second table data besides the table data being modified. Optionally, unmodified table data includes at least the unmodified table data and the location data of the unmodified table data in the target table. For example, suppose the second table data contains three data records, record A, record B, and record C, and record B is the table data being modified. Furthermore, records A and C may be unmodified table data.

[0063] In one selectable embodiment of this system, based on the data to be modified, it is possible to determine the unmodified table data from the second table data other than the data to be modified, and this unmodified table data may include the unmodified table data and the position data of the unmodified table data in the target table. Furthermore, table data can be generated based on the table data to be modified and its position data in the target table in the data to be modified, and the unmodified table data and its position data in the target table in the unmodified table data, and the generated table data can be made into the first table data. Furthermore, the first table data can be displayed on the client. This configuration has the advantage of constructing table data requested for viewing based on stored table data and data editing operations, effectively saving the resource space occupied by the client, and improving the response speed when the client views different history editing data.

[0064] Exemplary, Figure 4 is a schematic diagram of the table data display process according to an embodiment of the present disclosure. As shown in Figure 4, the table data stored in the history record manager includes record A, record B, and record C, and when the model layer requests to view table data, the necessary table data can be retrieved from the history record manager. Furthermore, if it is determined that the data to be changed is record B based on the table data requested to be viewed and the stored table data, record B can be backed up, and the table data requested to be viewed can be constructed based on the backed-up record B (shown by a solid frame in Figure 4), the unchanged records A and C (shown by dotted frames in Figure 4).

[0065] The technical solution of the embodiment of this disclosure determines, when the first editing time is later than the second editing time, the data editing operation performed to change the second table data to the first table data based on the first and second editing times, and acquires the table data associated with the data editing operation from the second table data as the data to be changed. This achieves the effect of determining the data editing operation performed on the table data within these two editing times based on the stored editing time and the requested editing time, further determining the data to be changed based on the data editing operation, and further achieving the effect of creating a database that constructs the requested table data according to the stored table data.

[0066] Figure 5 is a schematic flowchart of another table data processing method according to an embodiment of the present disclosure. Based on the above embodiment, the technical solution of the embodiment of the present disclosure further includes the steps of: determining that the first table data requested for viewing corresponds to the first editing time of the target table, and if the first editing time is earlier than the second editing time, obtaining 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; and displaying the first table data corresponding to the data viewing request in the client based on the third table data stored in the client. Specific embodiments can be found in the description of the embodiments of the present disclosure. Technical features identical or similar to those of the above embodiments will not be repeated here. As shown in Figure 5, the method of the embodiment of the present disclosure may specifically include S310 to S350.

[0067] S310 receives a data retrieval request for the target table from the client, determines the first edit time corresponding to the first table data requested, and stores the second table data corresponding to the target table in the client's memory at the second edit time.

[0068] In S320, if the first editing time is earlier than the second editing time, the third table data corresponding to the target table is retrieved from the server at the first editing time, and the third table data is stored on the client.

[0069] The third table data may be table data corresponding to the target table at the first editing time, retrieved by the client from the server.

[0070] In the embodiments of this disclosure, if the first editing time is earlier than the second editing time, it can be shown 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 performing data viewing on the first table data, it may not be possible to determine the specific contents of the first table data using the second table data. Moreover, the table data corresponding to the target table can be obtained from the server at the first editing time, and the obtained table data can be stored as third table data in the client.

[0071] S330 displays the first table data in the client that corresponds to the data viewing request, based on the third table data stored in the client.

[0072] In the embodiments of this disclosure, if the client has stored third table data corresponding to the target table during the first editing time, the stored third table data can be displayed on the client as first table data corresponding to the data viewing request.

[0073] S340, If the first editing time is later than the second editing time, the data to be modified in response to the data viewing request from the second table data is determined based on the first and second editing times.

[0074] S350 backs up the data to be changed and displays the data in the first table on the client based on the second table data and the backed-up data to be changed.

[0075] The technical solution of the embodiment of this disclosure determines that the requested first table data corresponds to the first editing time of the target table. If 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 obtained from the server, the third table data is stored on the client, and the first table data corresponding to the data viewing request is displayed on the client based on the third table data stored on the client. If the requested editing time is earlier than the stored editing time, the client obtains the requested table data from the server. In other words, the system achieves the targeted acquisition of table data from the server and further effectively saves the resource space occupied by the client.

[0076] Figure 6 is a schematic flowchart of another table data processing method according to an embodiment of the present disclosure. Based on the above embodiment, the technical solution of the embodiment of the present disclosure, when the target table is a first subtable in a database table and the database table includes a second subtable, receives a subtable switching operation for the second subtable from the client and displays the fourth table data of the second subtable under the second editing time based on the second table data. Specific embodiments can be found in the description of the embodiments of the present disclosure. Technical features identical or similar to those of the above embodiment will not be repeated here.

[0077] As shown in Figure 6, the method of the embodiment of this disclosure may specifically include S410 to S440.

[0078] S410 receives a data retrieval request for the target table from the client, determines the first editing time corresponding to the first table data requested, and stores the second table data corresponding to the target table in the client's memory at the second editing time.

[0079] S420, If the first editing time is later than the second editing time, the data to be modified in response to the data viewing request from the second table data is determined based on the first and second editing times.

[0080] S430 backs up the data to be changed and displays the data from the first table in the client based on the second table data and the backed-up data to be changed.

[0081] S440, if the target table is the first subtable in the database table and the database table contains a second subtable, the client receives a subtable switch operation for the second subtable and displays the fourth table data under the second edit time of the second subtable based on the second table data.

[0082] A database table can contain multiple subtables. Cross-table operations can also be performed between multiple subtables using methods such as cross-table expressions, one-way or two-way related fields, and finding reference fields. The second subtable may be any other data table in the database table other than the first subtable. For example, suppose a database table contains five subtables, namely Data Table 1, Data Table 2, Data Table 3, Data Table 4, and Data Table 5. If Data Table 2 is the first subtable, then Data Tables 1, 3, 4, and 5 are the second subtables. A subtable switching operation can be understood as switching between subtables displayed in the interface. Selectively, a subtable switching operation may include, but is not limited to, at least one of the following: click operations (including single-click and multi-click), long-press operations, touch operations, and swipe operations. The fourth table data may be table data obtained by editing the second subtable in the target table during the second editing time. It should be noted that a single subtable can also be a database table.

[0083] In embodiments of this disclosure, if the target table is a first subtable in a database table and the database table includes a second subtable, and after the client displays the first table data corresponding to the target table, and then the client receives a subtable switch operation for the second subtable, the client can determine the second edit time corresponding to the table data displayed in the second subtable based on the second table data corresponding to the target table stored in the client. Furthermore, the second subtable can determine the corresponding fourth table data at the second edit time and display the fourth table data in the client.

[0084] One point that needs to be explained is that there may be multiple ways to display fourth-table data based on second-table data. Selectively, the client stores the second-table data corresponding to the target table at the second edit time, and simultaneously stores the fourth-table data corresponding to the second subtable at the second edit time. Alternatively, the second edit time is determined based on the second-table data stored on the client, and the fourth-table data corresponding to the second subtable at the second edit time is retrieved from the server based on the second edit time and the second subtable.

[0085] In one selectable embodiment of the embodiments of this disclosure, when a subtable switching operation for the second subtable is detected, the editing time of the table data corresponding to the second subtable to be displayed can be determined as the second editing time based on the second table data stored in the client. Furthermore, based on the second editing time and the second subtable, the fourth table data corresponding to the second subtable can be obtained from the server at the second editing time, the fourth table data can be stored in the client, and the fourth table data can be displayed in the client.

[0086] Exemplary, Figure 7 is a schematic diagram of an interface for displaying a database table according to an embodiment of the present disclosure. As shown in Figure 7, the display interface includes a data table switching area 60, a data table display area 61, and a history record 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 record display area displays history record 1, history record 2, history record 3, history record 4, history record 5, and history record 6. History record 1 corresponds to history editing time A, history record 2 corresponds to history editing time B, history record 3 corresponds to history editing time C, history record 4 corresponds to history editing time D, history record 5 corresponds to history editing time E, and history record 6 corresponds to history editing time F. Furthermore, the time order of these six history editing times is history editing time A, history editing time B, history editing time C, history editing time D, history editing time E, and history editing time F, with history editing time A being the earliest and history editing time F being the latest. Based on the data table display area, the corresponding table data can be displayed at the corresponding history editing time of the corresponding data table. If the client has table data corresponding to data table 2 at history editing time C stored, after displaying the table data corresponding to data table 3 at history editing time D in the data table display area, if a sub-table switching operation for data table 2 is detected, the editing time of the table data corresponding to data table 2 to be displayed can be determined to be history editing time C based on the table data corresponding to data table 2 at history editing time C stored in the client. Furthermore, the table data corresponding to data table 2 at history editing time C can be retrieved from the server, the table data can be displayed in the data table display area, and history record 3 corresponding to history editing time C can be highlighted in the history record display area among multiple history records.

[0087] The technical solution of the embodiments of this disclosure displays the second table data or the first table data of the target table at the second editing time in the client, and if the target table is the first subtable in the database table and the database table contains the second subtable, the client receives a subtable switching operation for the second subtable, displays the fourth table data of the second subtable at the second editing time based on the second table data, and realizes the effect that each subtable in the database table is displayed independently of each other, that is, if the table data displayed in any subtable is changed, the other subtables are not affected.

[0088] Figure 8 is a schematic diagram of the structure of a table data processing device according to an embodiment of the present disclosure. As shown in Figure 8, the device includes a data viewing request module 510, a data determination module 520 for data to be modified, and a requested data display module 530. The data viewing request module 510 is used to receive a data viewing request for a target table from a client and to determine a first editing time corresponding to the first table data for which viewing is requested. The client stores second table data corresponding to the target table at a second editing time. The data determination module 520 is used to determine the data to be modified from the second table data corresponding to the data viewing request based on the first and second editing times, if the first editing time is later than the second editing time. The requested data display module 530 is used to back up the data to be modified and to display the first table data in the client based on the second table data and the backed-up data to be modified.

[0089] The technical solution of the embodiment of this disclosure receives a data viewing request for a target table from a client, determines a first editing time corresponding to the first table data for which viewing is requested, can trigger viewing of table data and execute subsequent table data determination operations through interactive operations between the user and the client, stores second table data corresponding to the target table in the client at the second editing time, stores at least a portion of the table data corresponding to the target table in the client, thereby realizing the effect of using the stored target table as a database for subsequent operations, and further, if the first editing time is later than the second editing time, determines the data to be changed from the second table data corresponding to the data viewing request based on the first and second editing times, and if the editing time for which viewing is requested is later than the stored editing time, the stored table data is used as the data construction basis for the table data for which viewing is requested This technology achieves the following effects: it backs up the data to be changed, displays the first table data on the client based on the second table data and the backed-up data to be changed, solves the problem that the table data processing method occupies a large amount of the client's resource storage space, places a heavy burden on the client's memory, and is slow to respond to table viewing requests, and by backing up the data to be changed in the stored table data and constructing the table data requested for viewing, it achieves the effect of constructing the table data requested for viewing based on the stored table data, it ensures that the modification of stored data does not affect the client's cache, effectively saves the resource space occupied by the client, and further improves the response speed of the client viewing table data and improves the client's processing performance for table data.

[0090] Based on any selectable technical solution in the embodiments of this disclosure, the data determination module 520 is selectively used to determine, specifically, the data editing operations performed to change the second table data to the first table data based on the first editing time and the second editing time, and to acquire the table data from the second table data associated with the data editing operations as the data to be modified.

[0091] Based on any selectable technical solution in the embodiments of this disclosure, the data determination module 520 to be modified 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 to acquire data editing operations performed on table data corresponding to the first data change identifier and the second data change identifier.

[0092] Based on any selectable technical solution in the embodiments of this disclosure, the data to be modified optionally includes at least the table data to be modified and the position data of the table data to be modified in the target table.

[0093] Depending on any selectable technical solution in the embodiments of the present disclosure, the requested 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 modified to generate target modified data, and to display the first table data in the client based on the second table data and the target modified data.

[0094] Based on any selectable technical solution in the embodiments of this disclosure, the table data display unit is selectively used to determine, specifically, the unmodified table data from the second table data other than the data to be modified, and to display the first table data in the client based on the unmodified data and the target modified data.

[0095] Based on any selectable technical solution in the embodiments of the present disclosure, the apparatus optionally further includes a data acquisition module and a table data display module. The data acquisition module is used to acquire a third table data corresponding to the target table at the first editing time from the server and store the third table data in the client, after determining that a first table data requested for viewing corresponds to a first editing time of the target table, and if the first editing time is earlier than the second editing time; and 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.

[0096] Based on any selectable technical solution in the embodiments of the present disclosure, the apparatus optionally further includes a subtable switching module. The subtable switching module is used to receive a subtable switching operation from the client to the second subtable if the target table is a first subtable in a database table and the database table includes a second subtable, after the step in which the second table data or the first table data of the target table at a second editing time is displayed in the client, and to display the fourth table data of the second subtable at the second editing time based on the second table data.

[0097] Based on any selectable technical solution in the embodiments of the present disclosure, the apparatus optionally further includes a data highlighting module. The data highlighting module is used to highlight in the first table data the target table data generated by editing the target table in the first editing time, after the step of displaying the first table data in the client based on the second table data and the backed-up data to be modified.

[0098] The table data processing device provided in the embodiments of this disclosure can perform the table data processing method provided in any embodiment of this disclosure and has appropriate functional modules and beneficial effects for performing the table data processing method.

[0099] Furthermore, the units and modules included in the above-mentioned device are merely classified according to functional logic and are not limited to the above classification; they only need to realize the appropriate function. Also, the specific names of each functional unit are for convenience to distinguish them from one another and do not limit the scope of protection of the embodiments of this disclosure.

[0100] Hereinafter, with reference to Figure 9, which shows a schematic diagram of the structure of an electronic device (e.g., a terminal device or server in Figure 9) 600 for implementing an embodiment of the present disclosure. The terminal devices relating to the embodiment of the present disclosure may include, but are not limited to, mobile devices such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), and in-vehicle terminals (e.g., in-vehicle navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. The electronic device shown in Figure 9 is merely an example and does not limit the functions and scope of use of the embodiment of the present disclosure.

[0101] As shown in Figure 9, the electronic device 600 may include a processing unit (e.g., a central processor, graphics processor, etc.) 601 that can perform various appropriate operations and processes based on 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. The RAM 603 also stores various programs and data necessary for the operation of the electronic device 600. The processing unit 601, ROM 602, and RAM 603 are interconnected via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0102] Typically, input devices 606, including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, and gyroscopes; output devices 607, including, for example, liquid crystal displays (LCDs), speakers, and oscillators; storage devices 606, including, for example, tapes and hard disks; and communication devices 609 can be connected to the I / O interface 605. The communication devices 609 can allow the electronic device 600 to communicate wirelessly or via wired communication with other devices to exchange data. Figure 9 illustrates an electronic device 600 with various devices, but as can be understood, it is not necessary to implement or include all of the illustrated devices. Instead, it is possible to implement or include more or less of the devices.

[0103] In particular, according to embodiments of the present disclosure, the process described with reference to the flowchart is implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product which includes a computer program contained on a non-temporary computer-readable medium which includes program code for performing the method shown in the flowchart. In such embodiments, the computer program may be downloaded and installed from a network by a communication device 609, or installed from a storage device 608, or installed from a ROM 602. When executed by a processing unit 601, the computer program performs the functions limited to the methods of embodiments of the present disclosure.

[0104] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and do not limit the scope of such messages or information.

[0105] The electronic devices provided by the embodiments of this disclosure and the table data processing methods provided by the embodiments belong to the same inventive concept, and technical details not described in detail in these embodiments can be found in the embodiments described above, and the embodiments of this disclosure and the embodiments described above have the same beneficial effects.

[0106] Embodiments of this disclosure provide a computer storage medium in which a computer program is stored, and when the program is executed by a processor, the table data processing method provided by the embodiment is realized.

[0107] It is important to note that the computer-readable media described herein may be computer-readable signal media, computer-readable storage media, or any combination of both. Computer-readable storage media may be, but are not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any combination of more than these. More specific examples of computer-readable storage media may include, but are not limited to, electrical connections having one or more wires, portable computer magnetic disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the above. In this disclosure, computer-readable storage media may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, apparatus, or device. In this disclosure, computer-readable signal media may include data signals propagating in the baseband or as part of a carrier wave, which may include computer-readable program code. Such propagating data signals may take various forms and may include, but are not limited to, electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium may further be any computer-readable medium other than a computer-readable storage medium, and the computer-readable signal medium may transmit, propagate, or transmit programs for use by or in combination with instruction execution systems, apparatus, or devices. The program code contained in the computer-readable medium may be transmitted by any suitable medium, including, but are not limited to, electric wires, optical cables, RF (radio frequency), or any suitable combination thereof.

[0108] According to one or more embodiments of the present disclosure, [Example 1] provides a table data processing method comprising: receiving a data viewing request for a target table from a client; determining a first editing time corresponding to the first table data for which viewing was requested, wherein the client has second table data corresponding to the target table stored in a second editing time; if the first editing time is later than the second editing time, determining the data to be modified from the second table data corresponding to the data viewing request based on the first and second editing times; backing up the data to be modified; and displaying the first table data in the client based on the second table data and the backed-up data to be modified.

[0109] According to one or more embodiments of the present disclosure, Example 2 provides the method of Example 1, wherein the step of selectively determining the data to be changed in the second table data based on the first and second editing times includes determining the data editing operations performed to change the second table data to the first table data based on the first and second editing times, and obtaining the table data from the second table data associated with the data editing operations as the data to be changed.

[0110] According to one or more embodiments of the present disclosure, Example 3 provides the method of Example 2, wherein the step of determining data editing operations performed to change the second table data to the first table data based on the first editing time and the second editing time includes the steps of determining 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 obtaining data editing operations performed on the table data corresponding to the first data change identifier and the second data change identifier.

[0111] According to one or more embodiments of the present disclosure, [Example 4] provides the method of Example 2, wherein the data to be modified optionally includes at least the table data to be modified and the position data of the table data to be modified in the target table.

[0112] According to one or more embodiments of the present disclosure, Example 5 provides the method of Example 2, wherein the step of selectively displaying the first table data in the client based on the second table data and the backed-up data to be modified includes the steps of performing the data editing operation on the backed-up data to be modified to generate target modified data, and displaying the first table data in the client based on the second table data and the target modified data.

[0113] According to one or more embodiments of the present disclosure, Example 6 provides the method of Example 5, wherein the step of selectively displaying the first table data in the client based on the second table data and the target change data includes determining the unchanged table data from the second table data other than the data to be changed, and displaying the first table data in the client based on the unchanged data and the target change data.

[0114] According to one or more embodiments of the present disclosure, [Example 7] provides the method of Example 1, which optionally includes the steps of: determining that a requested first table data corresponds to a first edit time of the target table, and if the first edit time is earlier than the second edit time, retrieving a third table data from the server that corresponds to the target table at the first edit time and storing the third table data in the client; and displaying the first table data corresponding to the data retrieval request in the client based on the third table data stored in the client.

[0115] According to one or more embodiments of the present disclosure, [Example 8] provides the method of Example 1, which optionally includes the step of the client displaying either the second table data or the first table data at a second edit time of the target table, and if the target table is a first subtable in a database table and the database table includes a second subtable, the client receives a subtable switch operation to the second subtable and displays the fourth table data of the second subtable at the second edit time based on the second table data.

[0116] According to one or more embodiments of the present disclosure, [Example 9] provides the method of Example 1, which optionally includes, after the step of displaying the first table data in the client based on the second table data and the backed-up data to be modified, the step of editing the target table in the first editing time and highlighting the generated target table data in the first table data.

[0117] According to one or more embodiments of the present disclosure, [Example 10] provides a table data processing device comprising: a data retrieval request module for receiving a data retrieval request from a client for a target table and determining a first editing time corresponding to the requested first table data, wherein the client stores second table data corresponding to the target table at a second editing time; a data to be modified determination module for determining the data to be modified from the second table data corresponding to the data retrieval request based on the first and second editing times if the first editing time is later than the second editing time; and a request data display module for backing up the data to be modified and displaying the first table data in the client based on the second table data and the backed-up data to be modified.

[0118] In some embodiments, clients and servers can communicate using any currently known or future-developed network protocol, such as HTTP (Hypertext Transfer Protocol), and can interconnect with digital data communications (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks ("LANs"), wide area networks ("WANs"), internetworks (e.g., the Internet), and end-to-end networks (e.g., ad hoc end-to-end networks), and any currently known or future-developed networks.

[0119] The computer-readable medium described above may be included in the electronic device described above, or it may exist separately without being incorporated into the electronic device.

[0120] The computer-readable medium contains one or more programs, and when the one or more programs are executed on the electronic device, the electronic device receives a data viewing request for a target table from a client and determines a first editing time corresponding to the first table data for which viewing was requested, wherein the client has second table data corresponding to the target table stored in the second editing time. If the first editing time is later than the second editing time, the steps include determining the data to be changed from the second table data that corresponds to the data viewing request based on the first and second editing times, The system is configured to perform the steps of: backing up the data to be modified, and displaying the first table data in the client based on the second table data and the backed-up data to be modified.

[0121] Computer program code for performing the operations of the Disclosure can be written in one or more programming languages ​​or a combination thereof, and such programming languages ​​include object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as the C language or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a single standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network, such as a local area network (LAN) or a wide area network (WAN), or it may be connected to an external computer (for example, connected via the Internet using an Internet service provider).

[0122] The flowcharts and block diagrams in the figures illustrate the feasible systematic structure, functions, and operations of the systems, methods, and computer program products relating to various embodiments of the present disclosure. In this regard, each block in a flowchart or block diagram may represent a module, program segment, or part of code, and such module, program segment, or part of code may contain one or more executable instructions for implementing a defined logic function. It should also be noted that in some alternative implementations, the functions shown within a block may be executed in a different order than shown in the drawings. For example, two blocks shown in sequence may actually be executed substantially in parallel, or they may be executed in reverse order depending on the related functions. It should also be noted that each block in a block diagram and / or flowchart, and combinations of blocks in a block diagram and / or flowchart, may be implemented by a dedicated hardware-based system that performs the defined function or operation, or by a combination of dedicated hardware and computer instructions.

[0123] The units described in the embodiments of this disclosure may be implemented in software or in hardware. The names of the units are not limited to the units themselves in any given context; for example, a data retrieval request module could be further described as a "module that receives data retrieval requests for a target table."

[0124] The functions described herein may be performed by at least partially one or more hardware logic components. Typical types of hardware logic components that may be used, without limitation, include field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standards (ASSPs), on-chip systems (SOCs), complex programmable logic devices (CPLDs), and the like.

[0125] In the context of this disclosure, a machine-readable medium may be a tangible medium containing or storing a program used in or in connection with an instruction execution system, device, or apparatus. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium includes, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices, or apparatus, or any appropriate combination of the above. More specific examples of machine-readable storage media include one or more wire-based electrical connections, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any appropriate combination of the above.

[0126] The above description is merely illustrative of preferred embodiments and technical principles used in the present disclosure. Those skilled in the art should understand that the scope of the present disclosure is not limited to technical solutions formed by specific combinations of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalents, without departing from the disclosed concept. For example, the above features are technical solutions formed by substituting each other with similar functional technical features disclosed in the present disclosure (but not limited to these).

[0127] Furthermore, although each operation has been described in a specific order, it should not be understood as requiring these operations to be performed in a specific order or sequential execution order as indicated. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although the above description includes some specific implementation details, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments can also be achieved by combining them in a single embodiment. Conversely, various features described in the context of a single embodiment can also be achieved individually or in any suitable subcombination in multiple embodiments.

[0128] While this subject matter is described in language specific to structural features and / or methodological logic, it should be understood that the subject matter limited to the attached claims is not necessarily limited to the specific features or behaviors described above. Rather, the specific features and behaviors described above are merely illustrative forms for realizing the claims.

Claims

1. A step of receiving a data viewing request for a target table from a client, determining a first editing time corresponding to the first table data for which viewing was requested, wherein the client has second table data corresponding to the target table stored in the second editing time. If the first editing time is later than the second editing time, the steps include determining the data to be changed from the second table data corresponding to the data viewing request based on the first and second editing times, The method is characterized by including the steps of 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. Table data processing method.

2. The step of determining the data to be changed in the second table data based on the first editing time and the second editing time is as follows: The process is characterized by including the steps of determining the data editing operations performed to change the second table data to the first table data based on the first editing time and the second editing time, and acquiring the table data from the second table data associated with the data editing operations as the data to be modified. The table data processing method according to claim 1.

3. The step of determining the data editing operations performed to change the second table data to the first table data based on the first editing time and the second editing time is: The method is characterized by including the steps of determining 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 obtaining data editing operations performed on the table data corresponding to the first data change identifier and the second data change identifier. The table data processing method according to claim 2.

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

5. The step of displaying the first table data in the client based on the second table data and the backed-up data to be modified is: The method is characterized by including the steps of performing the data editing operation on the backed-up data to be modified to generate target modification data, and displaying the first table data in the client based on the second table data and the target modification data. The table data processing method according to claim 2.

6. The step of displaying the first table data in the client based on the second table data and the target change data is: The method is characterized by including the step of determining the unchanged table data from the second table data other than the data to be changed, and displaying the first table data in the client based on the unchanged data and the target change data. The table data processing method according to claim 5.

7. After determining that the requested data for the first table corresponds to the first editing time of the target table, If the first editing time is earlier than the second editing time, the steps include obtaining the third table data corresponding to the target table from the server at the first editing time and storing the third table data in the client, The further step is 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, characterized in that the method further includes the step of displaying the first table data corresponding to the data viewing request in the client based on the third table data stored in the client. The table data processing method according to claim 1.

8. In the aforementioned client, after the step in which the second table data or the first table data at the second editing time of the target table is displayed, If the target table is a first subtable in a database table and the database table includes a second subtable, the further step includes receiving a subtable switching operation for the second subtable from the client and displaying the fourth table data of the second subtable under the second editing time based on the second table data. The table data processing method according to claim 1.

9. After the step of displaying the first table data in the client based on the second table data and the backed-up data to be modified, The method further includes the step of editing the target table during the first editing time and highlighting the target table data generated within the first table data. The table data processing method according to claim 1.

10. A data retrieval request module for receiving a data retrieval request for a target table from a client and determining a first editing time corresponding to the requested first table data, wherein the client has a second table data corresponding to the target table stored in the second editing time. If the first editing time is later than the second editing time, a data determination module for determining the data to be changed from the second table data corresponding to the data viewing request based on the first and second editing times, The system is characterized by including a request data display module for backing up the data to be modified and displaying the first table data in the client based on the second table data and the backed-up data to be modified. Table data processing unit.

11. One or more processors, A memory device for storing one or more programs, When the one or more programs are executed on the one or more processors, the one or more processors are made to implement the table data processing method described in any one of claims 1 to 9. electronic equipment.

12. A storage medium containing computer executable instructions, The computer executable instruction is used to execute the table data processing method described in any one of claims 1 to 9 when it is executed by a computer processor. A storage medium containing computer executable instructions.

13. A computer program characterized by implementing the table data processing method described in any one of claims 1 to 9 when executed by a processor.

Images