Table data processing method, device, equipment, medium and product
By identifying and backing up the data to be changed on the client side, the problem of excessive resource consumption in the table data processing method is solved, resulting in a faster response rate and higher processing performance.
Patent Information
- Application Number
- CN202411535304.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-30
- Publication Date
- 2026-01-09
- Estimated Expiration
- 2044-10-30
AI Technical Summary
In existing technologies, the table-based data processing method results in excessive client resource consumption, slow response, and a negative impact on user experience.
The system receives data viewing requests from the client, determines the first editing time, identifies the data to be changed based on the first and second editing times, backs up the data to be changed, and constructs the table data to be viewed based on the stored table data.
It effectively saves client-side resource usage space and improves the response rate and processing performance of table data.
Smart Images

Figure CN119476230B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] Embodiments of the present disclosure relate to the technical field of computer processing, and in particular, to a table data processing method, device, equipment, medium and product. BACKGROUND
[0002] With the rapid development of Internet office, the analysis and collection of data become extremely important, and the application of tables is more and more widespread. Users can store and manage data through tables, and support users to view historical table data edited at any historical moment.
[0003] In the related art, when a user views historical table data corresponding to any historical moment of a table each time, the historical table data corresponding to the historical moment is 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 table viewing requests, and a large amount of resource storage space of the client is occupied, which greatly pressures the memory of the client and affects the user experience of using the table. SUMMARY
[0004] The present disclosure provides a table data processing method, device, equipment, medium and product to realize the effect of constructing requested viewing table data according to stored table data, and further realize the effect of effectively saving the resource storage space of the client on the basis of ensuring that modifying the stored data does not affect the client cache.
[0005] In a first aspect, the embodiments of the present disclosure provide a table data processing method, which comprises:
[0006] receiving, by 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 the case where the first editing time is later than the second editing time, determining, according to the first editing time and the second editing time, to-be-changed data corresponding to the data viewing request in the second table data;
[0008] 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.
[0009] In a second aspect, the embodiments of the present disclosure further provide a table data processing device, which comprises:
[0010] The data viewing request module is used to receive a data viewing request for a target table through a client and determine the first editing time corresponding to the first table data to be viewed; wherein, the client stores the second table data corresponding to the target table at the second editing time;
[0011] The module for determining data to be changed is used to determine, based on the first editing time and the second editing time, the data to be changed in the second table data corresponding to the data viewing request when the first editing time is later than the second editing time.
[0012] The request data display 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] Thirdly, embodiments of this disclosure also provide an electronic device, the electronic device comprising:
[0014] One or more processors;
[0015] 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 tabular data processing method as described in any of the embodiments of this disclosure.
[0017] Fourthly, embodiments of this disclosure also provide a storage medium containing computer-executable instructions, which, when executed by a computer processor, are used to perform the tabular data processing method as described in any of the embodiments of this disclosure.
[0018] Fifthly, embodiments of this disclosure also provide a computer program product, including a computer program that, when executed by a processor, implements the tabular data processing method as described in any of the embodiments of this disclosure.
[0019] The technical solution of this disclosure embodiment involves a client receiving a data viewing request for a target table, determining the first editing time corresponding to the requested first table data, and triggering the viewing of table data and subsequent table data determination operations through interaction between the user and the client. The client stores second table data corresponding to the target table at the second editing time, achieving the effect of storing at least a portion of the table data corresponding to the target table in the client, using the stored table data as the data basis for subsequent operations. Furthermore, if the first editing time is later than the second editing time, the data to be changed in the second table data corresponding to the data viewing request is determined based on the first and second editing times, achieving the effect of using the stored table data as the data basis for the requested viewing when the requested editing time is later than the stored editing time. The system effectively builds upon the existing table data. Furthermore, it backs up the data to be changed and displays the first table data on the client based on the second table data and the backed-up data. This solves the problem of excessive client resource storage space consumption and memory pressure in related table data processing methods, leading to slow client response to table viewing requests. By backing up the data to be changed from the stored table data to construct the requested table data, the system achieves the effect of constructing the requested table data based on the stored table data. This effectively saves client resource space while ensuring that modifications to stored data do not affect client caching, thereby improving the response rate of table data viewing on the client and enhancing the client's table data processing performance. Attached Figure Description
[0020] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote 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 illustrating a tabular data processing method provided in an embodiment of this disclosure;
[0022] Figure 2 A timing flowchart of a tabular data processing method provided in this embodiment of the present disclosure.
[0023] Figure 3 A flowchart illustrating another tabular data processing method provided in this embodiment of the present disclosure;
[0024] Figure 4 A schematic diagram illustrating the tabular data display process provided in this embodiment of the disclosure;
[0025] Figure 5 FIG. 3 is a flowchart of another table data processing method provided by an embodiment of the present disclosure;
[0026] Figure 6 FIG. 3 is a flowchart of another table data processing method provided by an embodiment of the present disclosure;
[0027] Figure 7 FIG. 4 is a schematic diagram of an interface for displaying a database table provided by an embodiment of the present disclosure;
[0028] Figure 8 FIG. 5 is a structural schematic diagram of a table data processing apparatus provided by an embodiment of the present disclosure;
[0029] Figure 9 FIG. 6 is a structural schematic diagram of an electronic device for implementing an embodiment of the present disclosure provided by an embodiment of the present disclosure. DETAILED DESCRIPTION
[0030] Embodiments of the present disclosure will be described in more detail by referring to the drawings. Although certain embodiments of the present disclosure are shown in the drawings, it is understood that the present disclosure can be implemented in various forms, and should not be construed as being limited to the embodiments set forth herein, but rather these embodiments are provided to more thoroughly and completely understand the present disclosure. It is understood that the drawings and embodiments of the present disclosure are for exemplary purposes only, and are not intended to limit the scope of protection of the present disclosure.
[0031] It should be understood that the various steps in the method embodiments of the present disclosure can be performed in different orders, and / or in parallel. In addition, the method embodiments can include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.
[0032] The term "comprising" and variations thereof as used herein are open-ended, that is, "comprising but not limited to." The term "based on" is "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." Related definitions are given below in the description of the application.
[0033] It should be noted that the "first", "second", and the like concepts mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not intended to limit the order or interdependence of the functions performed by these devices, modules or units.
[0034] It should be noted that the modification of "one" and "multiple" mentioned in the present disclosure is illustrative rather than limiting, and those skilled in the art should understand that "one or more" should be understood unless otherwise explicitly indicated in the context.
[0035] The names of the messages or information exchanged between the plurality of devices in the embodiments of the present disclosure are only for illustrative purposes, and are not used to limit the scope of the messages or information.
[0036] It can be understood that, before using the technical solutions disclosed in the embodiments of the present disclosure, the type, use range, use scenario, etc. of the personal information involved in the present disclosure should be informed to the user and the authorization of the user should be obtained through appropriate means according to relevant laws and regulations.
[0037] For example, in response to receiving the active request of the user, the prompt information is sent to the user to explicitly prompt the user that the operation requested to be performed will require obtaining and using the personal information of the user. Thus, the user can voluntarily choose whether to provide the personal information to the software or hardware such as electronic device, application program, server or storage medium, etc. that performs the operation of the technical solutions of the present disclosure according to the prompt information.
[0038] As an optional but non-limiting implementation manner, in response to receiving the active request of the user, the prompt information can be sent to the user in the form of a pop-up window, and the prompt information can be presented in the form of text in the pop-up window. In addition, the pop-up window can also carry selection controls for the user to select "agree" or "disagree" to provide the personal information to the electronic device.
[0039] It can be understood that the above notification and user authorization process is only illustrative, and does not limit the implementation manner of the present disclosure. Other manners that meet the relevant laws and regulations can also be applied to the implementation manner of the present disclosure.
[0040] It can be understood that the data involved in the present technical solution (including but not limited to the data itself, the acquisition or use of the data) should comply with the requirements of the relevant laws and regulations and relevant provisions.
[0041] Figure 1 A flowchart of a table data processing method provided by the embodiments of the present disclosure is shown. The embodiments of the present disclosure are applicable to the scenario of viewing the table data obtained by the historical editing of the target table by the client. The method can be executed by a table data processing device, which can be implemented in the form of software and / or hardware. Optionally, the device can be implemented by an electronic device, which can be a mobile terminal, a PC terminal or a server, etc.
[0042] As shown in Figure 1 The method of the embodiments of the present disclosure can specifically include:
[0043] S110, receiving, by the 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.
[0044] The target table can be a table that supports viewing of 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 sub-tables in an accessed table. The data viewing request can be understood as an instruction for requesting execution of the operation of viewing table data. The data viewing request can include various generation manners. Optionally, the data viewing request can be generated in a case where a triggering operation for a preset data viewing control is detected; or the data viewing request can be generated in a case where the received audio information includes a triggering word associated with viewing data; or the data viewing request can be generated in a case where a data viewing triggering instruction input by a user is received. 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 the target table is edited at a historical time. In the embodiments of the present disclosure, after the target table is created, the data in the target table can be edited again, the table data obtained after each editing can be stored as table data corresponding to the target table, and the edited table data and the corresponding editing time can be associated and stored. Further, the historical edited table data can be viewed, and the historical edited table data requested to be viewed can be used as the first table data. The first editing time can be a time at which the first table data is obtained. The second table data can be data obtained after the target table is edited at the historical time and stored in the client. The second table data can be table data corresponding to the target table at the second editing time and pulled from the server by the client. The second editing time can be a time at which the second table data is obtained. In the embodiments of the present disclosure, the first editing time and the second editing time can be two adjacent historical editing times, or can be two non-adjacent historical editing times.
[0045] As a possible implementation manner 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 each cell of each column needs to correspond to the field type of the column. In other words, the field type can be used to limit at least one of the data format, the data type, and the data content of the data filled in the cell of the column. Exemplarily, the field type can include, but is not limited to, one or more of a text type, an option type, a date type, and a numerical value type.
[0046] It should be noted that the second table data stored in the client can be second table data corresponding to the target table at the second editing time pulled from the server in a case that the second editing time is randomly determined, and the pulled second table data is stored in the client. Alternatively, the second table data can also be pulled from the server and stored in the client in a case that a data viewing request for the second table data of the target table at the second editing time is received by the client.
[0047] In the embodiments 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 stored in the client. Further, the plurality of table data corresponding to the target table can be displayed based on the display interface of the client. Further, in a case that a data viewing request for any table data corresponding to the target table is received by 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, in a case that the first editing time is later than the second editing time, determining the 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.
[0049] The to-be-changed data can be table data to be edited in the second table data compared with the first table data. In the embodiments of the present disclosure, in a case that the first editing time is later than the second editing time, the first table data can be obtained after the data editing operation is inputted on the basis of the second table data, and the data edited in the second table data to obtain the first table data can be taken as the to-be-changed data. The to-be-changed data can be data associated with the data editing operation. Optionally, in a case that the data editing operation from the second table data to the first table data is a data addition operation, the to-be-changed data can be data not existing in the second table data compared with the first table data; or, in a case that the data editing operation from the second table data to the first table data is a data deletion operation, the to-be-changed data can be redundant data in the second table data compared with the first table data; or, in a case that the data editing operation from the second table data to the first table data is a data modification operation, the to-be-changed data can be data to be modified in the second table data compared with the first table data, and the like.
[0050] In actual application, in a case that a data viewing request for the first table data corresponding to the first editing time is received by the client, and the editing time corresponding to the table data stored in the client is earlier than the first editing time, the first table data corresponding to the first editing time is usually directly pulled from the server by the client, and the pulled first table data is displayed and stored. In this data viewing manner, a case that a large amount of resource storage space of the client is occupied and the request response efficiency of the client is affected may exist.
[0051] In view of the above, in the embodiment of the present disclosure, in a case that the first editing time corresponding to the first table data requested to be viewed is determined, the first editing time can be compared with the second editing time corresponding to the second table data stored in the client. Further, in a case that the first editing time is later than the second editing time, the table data to be edited in the second table data compared with the first table data can be determined according to the first editing time and the second editing time. Further, the determined table data can be taken as the to-be-changed data corresponding to the data viewing request in the second table data. Further, the first table data can be determined according to the to-be-changed data and the second table data. Thus, the effect that the table data requested to be viewed is determined according to the table data stored in the client can be achieved, and the request response efficiency and the data viewing efficiency are improved.
[0052] As an optional implementation manner of the embodiment of the present disclosure, the first table data and the second table data are both table data obtained after data editing operations, and in a case that the first editing time is later than the second editing time, the first table data can be table data obtained after a data editing operation is input on the basis of the second table data. Further, in a case that the first editing time is determined to be later than the second editing time, the data editing operation required to be performed for changing the second table data to the first table data can be determined according to the first editing time and the second editing time. Further, the data associated with the data editing operation in the second table data can be determined as the to-be-changed data.
[0053] S130, 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.
[0054] In the embodiment of the present disclosure, in a case that the to-be-changed data is determined, the to-be-changed data can be backed up. Further, the backed-up to-be-changed data can be processed. Further, the first table data can be determined according to the changed data obtained after processing and the second table data, and the first table data is displayed in the client.
[0055] In actual application, in the case that the table data stored in the client needs to be edited to obtain the table data requested to be viewed, the stored table data is usually backed up in full. Further, the backup table data is edited to obtain the table data requested to be viewed. Such a data processing manner may occupy a large amount of resource storage space of the client, and cause great pressure on the memory and performance of the client.
[0056] In view of the above, in the embodiment of the present disclosure, the to-be-changed data corresponding to the data viewing request in the second table data stored in the client can be determined. Further, the to-be-changed data is backed up, and the first table data requested to be viewed is determined according to the second table data and the backup to-be-changed data. Thus, compared with backing up the stored table data in full, only the table data that needs to be changed is backed up, which can effectively save the resource occupation space of the client, and further improve the request response efficiency of the client.
[0057] As an optional implementation manner of the embodiment of the present disclosure, after the to-be-changed data is backed up, a data editing operation can be performed on the backup to-be-changed data to obtain target changed data. Further, other table data in the second table data except the to-be-changed data can be determined. Further, the table data can be constructed based on the target changed data and the other table data, and the constructed table data is taken as the first table data, and the first table data is displayed in the client.
[0058] In the embodiment of the present disclosure, the first table data is the table data obtained after the target table is edited at the first editing time. In order to enable the user to quickly capture the data edited on the target table at the first editing time based on the displayed first table data in the case of displaying the first table data, optionally, after the first table data is displayed in the client according to the second table data and the backup to-be-changed data, the target table data generated by editing the target table at the first editing time is highlighted in the first table data.
[0059] The target table data can be the table data generated by editing the target table at the first editing time in the first table data. The target table data can be at least part of the table data in the first table data.
[0060] As an optional implementation manner 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, in the case of displaying the first table data in the client, the determined target table data can be highlighted in the first table data.
[0061] Exemplarily, Figure 2This is a timing flowchart of a tabular data processing method provided in an embodiment of this disclosure. Figure 2 As shown, when a user inputs a history preview operation for a target table through the client's view layer, the necessary historical edit table data can be retrieved from the server's history manager and cached on the client. Furthermore, the cached historical edit table data can be passed to the model layer (at least for processing the client's view layer display data) to build the data required by the view layer based on the model layer. Further, after construction is complete, the constructed table rendering data can be passed to the view layer, and the view layer is notified to start rendering. Subsequently, the view layer displays the rendered table data.
[0062] The technical solution of this disclosure embodiment involves a client receiving a data viewing request for a target table, determining the first editing time corresponding to the requested first table data, and triggering the viewing of table data and subsequent table data determination operations through interaction between the user and the client. The client stores second table data corresponding to the target table at the second editing time, achieving the effect of storing at least a portion of the table data corresponding to the target table in the client, using the stored table data as the data basis for subsequent operations. Furthermore, if the first editing time is later than the second editing time, the data to be changed in the second table data corresponding to the data viewing request is determined based on the first and second editing times, achieving the effect of using the stored table data as the data basis for the requested viewing when the requested editing time is later than the stored editing time. The system effectively builds upon the existing table data. Furthermore, it backs up the data to be changed and displays the first table data on the client based on the second table data and the backed-up data. This solves the problem of excessive client resource storage space consumption and memory pressure in related table data processing methods, leading to slow client response to table viewing requests. By backing up the data to be changed from the stored table data to construct the requested table data, the system achieves the effect of constructing the requested table data based on the stored table data. This effectively saves client resource space while ensuring that modifications to stored data do not affect client caching, thereby improving the response rate of table data viewing on the client and enhancing the client's table data processing performance.
[0063] Figure 3A flowchart of another table data processing method provided by an embodiment of the present disclosure is shown. The technical solution of the embodiment of the present disclosure refines the manner of determining the to-be-changed data according to the first editing time and the second editing time on the basis of the above-mentioned embodiment. Optionally, the manner of determining the to-be-changed data in the second table data according to the first editing time and the second editing time comprises: determining a data editing operation performed for changing the second table data into the first table data according to the first editing time and the second editing time, and obtaining table data associated with the data editing operation in the second table data as the to-be-changed data. The specific implementation can be referred to the description of the embodiment of the present disclosure. Wherein, the same or similar technical features as the foregoing embodiments are not described herein.
[0064] As shown in Figure 3 , the method of the embodiment of the present disclosure can specifically comprise:
[0065] S210, receiving a data viewing request for a target table through a client, 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.
[0066] S220, in the case that the first editing time is later than the second editing time, determining a data editing operation performed for changing the second table data into the first table data according to the first editing time and the second editing time, and obtaining table data associated with the data editing operation in the second table data as to-be-changed data.
[0067] Wherein, the data editing operation can be an operation of editing table data. Specifically, the data editing operation comprises edited table data and an editing manner of the edited table data. Optionally, the data editing operation comprises at least one of a data adding operation, a data deleting operation, a data modifying operation, a data position moving operation and the like performed on the edited table data. In the embodiment of the present disclosure, in the case that the first editing time is later than the second editing time, the first table data can be obtained by inputting the editing operation to the second table data, and the operation performed for changing the second table data into the first table data can be taken as the data editing operation. The to-be-changed data can be table data acted on by the data editing operation in the second table data. The to-be-changed data can comprise multiple data associated with the data editing operation. Optionally, the to-be-changed data comprises at least to-be-changed table data and position data of the to-be-changed table data in the target table. The to-be-changed table data can be table data to be processed. The position data can be used to indicate the position of the to-be-changed table data in the target table. For example, the position data can be used to indicate the row and the column of the to-be-changed table data in the target table, or the display position in the visualization window.
[0068] In the embodiments of the present disclosure, in the case that the first editing time is later than the second editing time, the data editing operation performed on the target table between the two times can be determined according to the first editing time and the second editing time, and the determined data editing operation is taken as the data editing operation performed to change the second table data into the first table data. Further, the second table data can be analyzed according to the data editing operation, and the table data acted on by the data editing operation is determined as the table data to be changed, and the position data of the table data to be changed in the target table is determined. Further, the determined table data to be changed and the position data of the table data to be changed in the target table are taken as the data to be changed.
[0069] It should be noted that in the case that 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 the table data obtained after the target table is edited at the historical time is obtained, the table data can be stored in association with the editing time and the operation identifier used to represent the corresponding data editing operation. Further, when it is necessary to determine the data editing operation performed to change the second table data into the first table data, the operation identifier corresponding to the first editing time and the operation identifier located between the first editing time and the second editing time can be determined, and then the determined operation identifier can be used to determine the data editing operation performed.
[0070] Optionally, determining 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 comprises: 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. The advantage of this setting is that it effectively determines the data editing operation performed between the two times according to the first editing time and the second editing time, determines the data editing operation according to the data change identifier, enhances the convenience of the data editing operation determination process, and further improves the construction efficiency of the table data requested to be viewed.
[0071] The first data change identifier can be used to represent 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 capable of representing the data editing operation. Optionally, the first data change identifier is information composed of numbers, characters or other characters. The second data change identifier can be used to represent the data change process of the target table between the first editing time and the second editing time. The number of the second data change identifier can be one or more. In the embodiments of the present disclosure, the change of the second table data to the first table data can be at least one data change, and thus, 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 of the change of the second table data to the first table data based on the data change identifier.
[0072] As an optional implementation of the first 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 of the target table can be stored in association. Further, when the first editing time and the second editing time are determined, the association relationship can be constructed in advance to determine 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. Further, the data editing operation performed on the table data at the first editing time and the data editing operation performed on the table data between the first editing time and the second editing time can be determined according to the first data identifier, 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.
[0073] S230, 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.
[0074] In the embodiments of the present disclosure, when the data editing operation performed to change the second table data to the first table data is determined, the first table data can be determined according to the data editing operation, the second table data and the backed-up to-be-changed data, and the first table data can be displayed in the client.
[0075] Optionally, displaying the first table data in the client according to the second table data and the backed-up to-be-changed data includes: performing a data editing operation on the backed-up to-be-changed data 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.
[0076] The target change data can be table data generated after performing a data editing operation on the backed-up to-be-changed data.
[0077] As an optional implementation of the embodiment one 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 according to the backup data to be changed. Further, the data editing operation can be performed on the table data to be changed according to the position data, so as to generate the target change data. Further, the first table data can be determined according to the target change data and the second table data, and the first table data is displayed in the client. The advantage of the above setting is that the data editing operation is applied to the stored and backup table data to construct the requested table data, so as to realize the effect of applying the data editing operation to the stored and backup table data to display the requested table data, improve the response rate of the client when viewing different historical editing data, and improve the processing performance of the client for the table data.
[0078] Optionally, the first table data is displayed in the client according to the second table data and the target change data, including: determining the un-changed table data in the second table data except the data to be changed, and displaying the first table data in the client according to the un-changed table data and the target change data.
[0079] Optionally, the un-changed table data includes at least the un-changed table data and the position data of the un-changed table data in the target table. For example, assuming that the second table data includes three data records, record A, record B and record C, and the record B is the table data to be changed. Further, the record A and the record C can be regarded as the un-changed table data.
[0080] As an optional implementation of the embodiment one, the un-changed table data in the second table data except the data to be changed can be determined based on the data to be changed, and the un-changed table data can include the un-changed table data and the position data of the un-changed table data in the target table. Further, the table data can be generated according to the table data to be changed in the data to be changed and the position data of the table data to be changed in the target table, and the un-changed table data in the un-changed table data and the position data of the un-changed table data in the target table, and the generated table data is taken as the first table data. Further, the first table data can be displayed in the client. The advantage of the above setting is that the stored table data and the data editing operation are used to construct the requested table data, so as to realize the effect of improving the response rate of the client when viewing different historical editing data on the basis of effectively saving the resource occupation space of the client.
[0081] For example, Figure 4 The schematic diagram of the table data display process provided by the embodiment of the present disclosure is shown in FIG. 1. As shown in FIG. 1, the table data display process includes the following steps. Figure 4As shown, the table data stored in the history record manager includes record A, record B and record C, when the table data to be viewed is requested in the model layer, the required table data can be pulled from the history record manager. Further, in the case that the to-be-changed data is determined to be record B according to the requested table data and the stored table data, record B can be backed up, and the requested table data can be constructed according to the backed-up record B Figure 4 (in a solid line box in FIG. 16) and un-changed record A and record C (in a dashed line box in FIG. 16). Figure 4
[0082] The technical solution of the embodiment of the present disclosure can determine 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 in the case that the first editing time is later than the second editing time, and obtain the table data associated with the data editing operation in the second table data as the to-be-changed data, which realizes 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 requested viewing editing time, and further determining the to-be-changed data based on the data editing operation, and further realizes the effect of taking the stored table data as the data basis for constructing the requested viewing table data.
[0083] Figure 5 The flowchart of another table data processing method provided by the embodiment of the present disclosure is shown. The technical solution of the embodiment of the present disclosure further includes, after determining the first editing time of the first table data corresponding to the target table in the above-mentioned embodiment, in the case that 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; 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. The specific implementation can be referred to the description of the embodiment of the present disclosure. Wherein, the same or similar technical features as the foregoing embodiments are not described herein. As shown, the method of the embodiment of the present disclosure can specifically include: Figure 5
[0084] S310, receiving a data viewing request for a target table through a client, and determining a first editing time of first table data corresponding to the target table; wherein the client stores second table data corresponding to the target table at a second editing time.
[0085] S320, in the case that 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.
[0086] The third table data can be the table data corresponding to the target table at the first editing time, which is retrieved from the server by the client.
[0087] In this embodiment of the disclosure, when the first editing time is earlier than the second editing time, it indicates that when editing the target table, the first table data edited at the first editing time may be obtained first, followed by the second table data edited at the second editing time. Consequently, when viewing the first table data, it may be impossible to determine the specific content of the first table data using the second table data. Furthermore, table data corresponding to the target table at the first editing time can be retrieved from the server, and this retrieved table data can be used as the third table data, which is then stored in the client.
[0088] S330: The third table data stored on the client will be displayed in the client along with the first table data corresponding to the data viewing request.
[0089] In this embodiment of the disclosure, if 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. If the first editing time is later than the second editing time, determine 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.
[0091] S350: Back up the data to be changed, and display the data in the first table on the client based on the data in the second table and the backed-up data to be changed.
[0092] The technical solution of this disclosure, after determining the first editing time of the target table corresponding to the first table data to be viewed, if the first editing time is earlier than the second editing time, retrieves the third table data corresponding to the target table at the first editing time from the server, stores the third table data in the client, and displays the first table data corresponding to the data viewing request in the client based on the third table data stored in the client. This achieves the effect of retrieving the requested table data from the server through the client when the editing time of the requested view is earlier than the stored editing time, that is, it achieves the effect of selectively retrieving table data from the server, thereby effectively saving the resource space occupied by the client.
[0093] Figure 6FIG. 2 is 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. In the case that the target table is a first sub-table in a database table and the database table includes a second sub-table, the client receives a sub-table switching operation for the second sub-table, and displays fourth table data of the second sub-table at the second editing time according to the second table data. The specific implementation can be referred to the description of the embodiment of the present disclosure. The technical features same as or similar to the foregoing embodiments are not described herein again.
[0094] As shown in FIG. 1, the method of the embodiment of the present disclosure can specifically include the following steps. Figure 6
[0095] S410, receiving a data viewing request for the target table through the 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, in the case 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.
[0097] S430, 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.
[0098] S440, in the case that the target table is a first sub-table in a 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.
[0099] The database table can include a plurality of sub-tables. Cross-table operations can also be performed between the plurality of sub-tables through cross-table formulas, one-way or two-way associated fields, lookup reference fields, etc. The second sub-table can be a data table other than the first sub-table in the database table. For example, it is assumed that the database table includes five sub-tables, namely, data table 1, data table 2, data table 3, data table 4, and data table 5. In the case that data table 2 is the first sub-table, data table 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 displayed sub-table in the interface to another sub-table. Optionally, the sub-table switching operation includes at least one of a clicking operation (including single clicking and multiple clicking), a long-pressing operation, a touch operation, and a sliding operation. The fourth table data can be table data edited at the second editing time for the second sub-table in the target table. It should be noted that a single sub-table can also be a database table.
[0100] In the embodiments of the present disclosure, in the case that the target table is a first sub-table in a database table and the database table includes a second sub-table, after the first table data corresponding to the target table is displayed by the client, in the case that a sub-table switching operation for the second sub-table is received by the client, the second editing time corresponding to the table data to be displayed by 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 displayed in the client.
[0101] It should be noted that the manner of displaying the fourth table data according to the second table data can include various manners. Alternatively, the fourth table data corresponding to the second sub-table at the second editing time can also be stored in the client while the second table data corresponding to the target table at the second editing time is stored in the client. Alternatively, the second editing time is determined based on the second table data stored in the client, and the fourth table data corresponding to the second sub-table at the second editing time is pulled from the server based on the second editing time and the second sub-table.
[0102] As an optional implementation manner of the embodiment of the present disclosure, in the case that the sub-table switching operation for the second sub-table is detected, the editing time of the table data corresponding to the second sub-table to be displayed can be determined according to the second table data stored in the client, which is the second editing time. Further, the fourth table data corresponding to the second sub-table at the second editing time can be pulled from the server according to the second editing time and the second sub-table, stored in the client, and displayed in the client.
[0103] For example, Figure 7 An interface schematic diagram for displaying a database table provided by the embodiments of the present disclosure is shown in FIG. 1. As shown in FIG. 1, the interface schematic diagram includes a target table 101 and a second sub-table 102. Figure 7As shown, 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. Among them, 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. Moreover, the time order of the 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. The corresponding table data of the respective data table at the corresponding history editing time can be displayed based on the data table display area. In the case where the client stores the table data corresponding to data table 2 at history editing time C, after displaying the table data corresponding to data table 3 at history editing time D in the data table display area, in the case where 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 as history editing time C according to the table data corresponding to data table 2 at history editing time C stored by the client. Further, the table data corresponding to data table 2 at history editing time C can be pulled from the server, the table data is displayed in the data table display area, and history record 3 corresponding to history editing time C is highlighted among the plurality of history records in the history record display area.
[0104] The technical solution of the embodiments of the present disclosure realizes the effect of independent display between each sub-table in the database table, that is, realizes the effect that other sub-tables are not affected in the case where the table data displayed by an arbitrary sub-table is changed, by displaying the second table data or the first table data of the target table at the second editing time in the client, receiving a sub-table switching operation for the second sub-table by the client in the case where the target table is the first sub-table in the database table and the database table includes the second sub-table, and displaying the fourth table data of the second sub-table at the second editing time according to the second table data.
[0105] Figure 8 A structural schematic diagram of a table data processing device provided by the embodiments of the present disclosure is shown in Figure 8As shown, the apparatus includes: a data viewing request module 510, a data to be changed determination module 520, and a request data display module 530. The data viewing request module 510 is configured to receive, by a client, a data viewing request for a target table, and determine a first editing time corresponding to first table data requested to be viewed. 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 configured to, in a case where the first editing time is later than the second editing time, determine, according to the first editing time and the second editing time, data to be changed in the second table data corresponding to the data viewing request. The request data display module 530 is configured to backup the data to be changed, and display the first table data in the client according to the second table data and the backup data to be changed.
[0106] The technical scheme of the embodiment of the present disclosure receives, by a client, a data viewing request for a target table, and determines a first editing time corresponding to first table data requested to be viewed. The viewing of table data and the subsequent operation of determining table data can be triggered by an interactive operation between a user and the client. The client stores second table data corresponding to the target table at a second editing time. At least part of the table data corresponding to the target table is stored in the client, so as to use the stored table data as a data basis for subsequent operations. Further, in a case where the first editing time is later than the second editing time, the data to be changed in the second table data corresponding to the data viewing request is determined according to the first editing time and the second editing time. The stored table data is used as a data construction basis for the table data requested to be viewed in a case where the editing time requested to be viewed is later than the stored editing time. Further, the data to be changed is backed up, and the first table data is displayed in the client according to the second table data and the backup data to be changed. The problem that a large amount of resource storage space of the client is occupied, the memory of the client is greatly stressed, and the response of the client to the table viewing request is slow is solved. The data to be changed in the stored table data is backed up to construct the table data requested to be viewed. The table data requested to be viewed is constructed according to the stored table data. Further, the resource occupation space of the client is effectively saved on the basis of ensuring that the modification of the stored data does not affect the cache of the client. Further, the response rate of the client to the table data is improved, and the processing performance of the client to the table data is improved.
[0107] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the to-be-changed data determination module 520 is specifically configured to determine a data editing operation performed for changing 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 the to-be-changed data.
[0108] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the to-be-changed data determination module 520 includes a data editing operation acquisition unit. The data editing operation acquisition unit is configured to determine 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 acquire a data editing operation performed on table data corresponding to the first data change identifier and the second data change identifier.
[0109] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the to-be-changed data includes at least to-be-changed table data and position data of the to-be-changed table data in the target table.
[0110] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the request data display module 530 includes a table data display unit. The table data display unit is configured to perform the data editing operation on the backup to-be-changed data to generate target changed data, and display the first table data in the client according to the second table data and the target changed data.
[0111] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the table data display unit is specifically configured to determine un-changed table data in the second table data except the to-be-changed data, and display the first table data in the client according to the un-changed data and the target changed data.
[0112] In any of the optional technical solutions in the embodiments of the present disclosure, optionally, the apparatus further includes a data pulling module and a table data display module. The data pulling module is configured to, after determining that the first table data requested to be viewed corresponds to the first editing time of the target table, in the case that the first editing time is earlier than the second editing time, pull third table data corresponding to the target table at the first editing time from a server, and store the third table data in the client. The table data display module is configured 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] Optionally, based on any of the optional technical solutions in the embodiments of the present disclosure, the apparatus further comprises a sub-table switching module. The sub-table switching module is configured to, after the first table data is displayed in the client according to the second table data and the backup to-be-changed data, highlight the target table data edited at the first editing time in the first table data.
[0114] Optionally, based on any of the optional technical solutions in the embodiments of the present disclosure, the apparatus further comprises a data highlighting module. The data highlighting module is configured to, after the first table data is displayed in the client according to the second table data and the backup to-be-changed data, highlight the target table data edited at the first editing time in the first table data.
[0115] The table data processing apparatus provided in the embodiments of the present disclosure can execute the table data processing method provided in any of the embodiments of the present disclosure, and has the corresponding function modules and beneficial effects of executing the table data processing method.
[0116] It should be noted that each unit and module included in the apparatus is only divided according to the function logic, and is not limited to the above division, as long as the corresponding function can be implemented; in addition, the specific name of each functional unit is only for convenient distinction, and does not limit the protection scope of the embodiments of the present disclosure.
[0117] Reference will be made to the following description of the embodiments of the present disclosure with reference to the accompanying drawings, in which Figure 9 which shows a structural schematic diagram of an electronic device (for example, a terminal device or a server in Figure 9 The terminal device in the embodiments of the present disclosure can include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (Personal Digital Assistant), a PAD (Tablet Personal Computer), a PMP (Portable Multimedia Player), a vehicle terminal (for example, a car navigation terminal), and the like, and a fixed terminal such as a digital TV, a desktop computer, and the like. Figure 9 The electronic device shown is only an example, and should not bring any limitation to the functions and use range of the embodiments of the present disclosure.
[0118] As Figure 9As shown, the electronic device 600 can include a processing apparatus (e.g., a central processing unit, a graphics processing unit, etc.) 601 that can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 602 or loaded into a random access memory (RAM) 603 from a storage apparatus 606. Various programs and data required for the operation of the electronic device 600 are also stored in the RAM 603. The processing apparatus 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.
[0119] Generally, the following apparatuses can be connected to the I / O interface 605: an input apparatus 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 apparatus 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage apparatus 606 including, for example, a magnetic tape, a hard disk, etc.; and a communication apparatus 609. The communication apparatus 609 can allow the electronic device 600 to perform wireless or wired communication with other devices to exchange data. Although Figure 9 The electronic device 600 is shown with various apparatuses, but it should be understood that all of the shown apparatuses are not required to implement or have the electronic device 600. More or less apparatuses can alternatively be implemented.
[0120] In particular, the processes described above with reference to the flowcharts can be implemented as a computer software program according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for performing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network through the communication apparatus 609, or installed from the storage apparatus 606, or installed from the ROM 602. When the computer program is executed by the processing apparatus 601, the above-described functions defined in the methods of the embodiments of the present disclosure are performed.
[0121] The names of the messages or information exchanged between the plurality of apparatuses in the embodiments of the present disclosure are used only for illustrative purposes, and are not intended to limit the scope of the messages or information.
[0122] The electronic device provided by the embodiments of the present disclosure and the table data processing method provided by the above embodiments belong to the same inventive concept, and the technical details not described in detail in the embodiments of the present disclosure can be referred to the above embodiments, and the embodiments of the present disclosure have the same beneficial effects as the above embodiments.
[0123] The embodiments of the present disclosure provide a computer storage medium, which stores a computer program, and the program is executed by a processor to implement the table data processing method provided by the above embodiments.
[0124] It should be noted that the computer readable medium described above in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the two. The computer readable storage medium may, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or apparatus, or any combination of the above. More specific examples of the computer readable storage medium can include, but are not limited to, an electrical connection having one or more wires, a portable computer diskette, 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, the computer readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, device or apparatus. In the present disclosure, the computer readable signal medium can include a data signal carried in a baseband or as a part of a carrier wave, which carries computer readable program code. Such a propagated data signal can take many forms, including but not limited to an electromagnetic signal, an optical signal or any suitable combination of the above. The computer readable signal medium can also be any computer readable medium other than the computer readable storage medium, which can send, propagate or transmit a program for use by or in conjunction with an instruction execution system, device or apparatus. The program code contained on the computer readable medium can be transmitted by any suitable medium, including but not limited to a wire, a cable, a RF (radio frequency) or the like, or any suitable combination of the above.
[0125] According to one or more embodiments of the present disclosure, example one provides a table data processing method, comprising: receiving a data viewing request for a target table through a client, 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 the case 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; 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.
[0126] According to one or more embodiments of the present disclosure, Example Two provides the method of Example One, further including: optionally, the determining the to-be-changed data in the second table data according to the first edit time and the second edit time includes: determining a data edit operation performed to change the second table data to the first table data according to the first edit time and the second edit time, and obtaining table data associated with the data edit operation in the second table data as the to-be-changed data.
[0127] According to one or more embodiments of the present disclosure, Example Three provides the method of Example Two, further including: optionally, the determining the data edit operation performed to change the second table data to the first table data according to the first edit time and the second edit time includes: determining a first data change identifier corresponding to the first edit time and a second data change identifier located between the first edit time and the second edit time, and obtaining a data edit operation performed to 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 Four provides the method of Example Two, further including: optionally, the to-be-changed data at least includes to-be-changed table data and position data of the to-be-changed table data in the target table.
[0129] According to one or more embodiments of the present disclosure, Example Five provides the method of Example Two, further including: optionally, the displaying the first table data in the client according to the second table data and the backup to-be-changed data includes: performing the data edit operation to the backup to-be-changed data 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, the displaying the first table data in the client according to the second table data and the target change data includes: determining un-changed table data in the second table data other than the to-be-changed data, and displaying the first table data in the client according to the un-changed data and the target change data.
[0131] According to one or more embodiments of the present disclosure, Example Seven provides the method of Example One, further comprising: optionally, after determining that the first table data requested to be viewed corresponds to a first editing time of the target table, further comprising: in a 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 a server, and storing the third table data in the client; displaying the first table data corresponding to the data viewing request in the client based on the third table data stored in the client.
[0132] According to one or more embodiments of the present disclosure, Example Eight provides the method of Example One, further comprising: optionally, after displaying the second table data of the target table at the second editing time or the first table data in the client, further comprising: in a case where the target table is a first sub-table in a 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 Nine provides the method of Example One, further comprising: optionally, after displaying the first table data in the client according to the second table data and the backup of the to-be-changed data, further comprising: highlighting 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 Ten provides a table data processing apparatus, comprising: a data viewing request module configured to receive a data viewing request for a target table through a client, and determine a first editing time corresponding to 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 configured to, in a case where the first editing time is later than the second editing time, determine 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 a request data display module configured to backup the to-be-changed data, and display the first table data in the client according to the second table data and the backup of the to-be-changed data.
[0135] In some embodiments, the client, server, or other computing machines can communicate using any known or later developed form of computer-readable media, including but not limited to wireless media, wire-based media, optical-based media, and the like. In some embodiments, the client, server, or other computing machines can communicate using any current or later developed network protocol, such as the Hyper Text Transfer Protocol (HTTP) and / or the like, and can be interconnected with any form or medium of digital data communication (for example, a communication network) including the Internet, local area networks (“LANs”), wide area networks (“WANs”), and peer-to-peer networks (for example, ad hoc peer-to-peer networks), as well as any current or later developed network.
[0136] The computer-readable medium described above can be included in the electronic device described above; or can exist separately from the electronic device and can be accessed via the electronic device.
[0137] The computer-readable medium described above carries one or more programs that, when executed by the electronic device, cause the electronic device to: receive, by a client, a data viewing request for a target table, determine 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;
[0138] In a case where the first editing time is later than the second editing time, determine, according to the first editing time and the second editing time, to-be-changed data in the second table data corresponding to the data viewing request;
[0139] Backup the to-be-changed data, and display the first table data in the client according to the second table data and the backed-up to-be-changed data.
[0140] Computer program code for carrying out operations of the present disclosure can be written in any one or more of a number of programming languages or combinations of languages including an object-oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can 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 the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).
[0141] The computer program product of the first aspect can include one or more non-transitory computer-readable media storing instructions that, when executed, cause one or more processors to perform the operations of the corresponding method. The computer program product of the first aspect can include a non-transitory computer-readable medium storing code for causing a computer to perform the operations of the corresponding method.
[0142] The units described in the embodiments of the present disclosure can be implemented by hardware, software, or a combination of hardware and software. In some cases, the names of the units do not constitute a limitation on the units themselves. For example, the data viewing request module can also be described as a module that receives a data viewing request for a target table.
[0143] The functions described in this specification can be implemented in part or in whole by one or more hardware logic components. For example, and without limitation, illustrative types of hardware logic components that can be used include Field-programmable Gate Arrays (FPGAs), Program-specific Integrated Circuits (ASICs), Program-specific Standard Products (ASSPs), System-on-a-chip systems (SOCs), Complex Programmable Logic Devices (CPLDs), etc.
[0144] In the context of the present disclosure, a machine-readable medium can be a tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include but is not limited to an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of the machine-readable storage medium will include one or more of: a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0145] The above description merely illustrates the preferred embodiments of the disclosure and a principle for applying the technologies. It is understood by those skilled in the art that the disclosed scope of the disclosure is not limited to the technical solutions formed by the specific combinations of the technical features described above, and should also cover other technical solutions formed by the combinations of the technical features described above or their equivalent features without departing from the disclosed concept. For example, the technical solutions formed by the mutual replacement of the above-described features and the technical features with similar functions disclosed in the disclosure (but not limited to) can be formed.
[0146] Further, although operations are depicted in a particular, sequential order, this should not be understood as requiring or implying that the operations are performed in the order illustrated or sequentially. In certain circumstances, multitasking and parallel processing can be advantageous. Likewise, although specific implementation details are included for the purpose of providing a thorough disclosure, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable sub-combination.
[0147] Although the subject matter has been described in language specific to structural features and / or methodological acts, it is to be understood that the subject defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.
Claims
1. A tabular data processing method, characterized by, Comprising: receiving, by a client, a data viewing request for a target table, 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, according to the first editing time and the second editing time, to-be-changed data in the second table data corresponding to the data viewing request; 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; the determining, according to the first editing time and the second editing time, to-be-changed data in the second table data corresponding to the data viewing request, comprising: determining a 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 table data associated with the data editing operation in the second table data as to-be-changed data.
2. The tabular data processing method of claim 1, wherein, the determining a 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, comprising: 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 a data editing operation performed on table data corresponding to the first data change identifier and the second data change identifier.
3. The tabular data processing method of claim 1, wherein, the to-be-changed data at least includes to-be-changed table data and position data of the to-be-changed table data in the target table.
4. The tabular data processing method of claim 1, wherein, the displaying the first table data in the client according to the second table data and the backed-up to-be-changed data, comprising: performing the data editing operation on the backed-up to-be-changed data 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.
5. The tabular data processing method according to claim 4, characterized in that, the displaying the first table data in the client according to the second table data and the target change data, comprising: determining un-changed table data in the second table data except the to-be-changed data, and displaying the first table data in the client according to the un-changed data and the target change data.
6. The tabular data processing method of claim 1, wherein, after determining the first editing time corresponding to the first table data requested to be viewed of the target table, further comprising: in a 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 a server, and storing the third table data in the client; displaying the first table data corresponding to the data viewing request in the client based on the third table data stored in the client.
7. The tabular data processing method of claim 1, wherein, after the target table in the client displays the second table data at the second editing time or the first table data, further comprising: In a case where the target table is a first sub-table in a database table and the database table includes a second sub-table, a sub-table switching operation for the second sub-table is received by the client, and fourth table data of the second sub-table at the second editing time is displayed according to the second table data.
8. The tabular data processing method of claim 1, wherein, After the first table data is displayed in the client according to the second table data and the to-be-changed data, the method further includes: highlighting target table data edited at the first editing time on the first table data.
9. A tabular data processing apparatus, characterized by comprising: The method includes: a data viewing request module configured to receive, by a client, a data viewing request for a target table, and determine 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; a to-be-changed data determination module configured to, in a case where the first editing time is later than the second editing time, determine 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; a request data display module configured to backup the to-be-changed data, and display the first table data in the client according to the second table data and the to-be-changed data; the to-be-changed data determination module is specifically configured to determine a 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 table data associated with the data editing operation in the second table data as the to-be-changed data.
10. An electronic device, comprising: The electronic device includes: one or more processors; a storage device configured to store one or more programs, when the one or more programs are executed by the one or more processors, the one or more processors implement the table data processing method of any one of claims 1-8.
11. A storage medium containing computer-executable instructions, wherein: The computer executable instructions, when executed by a computer processor, are configured to perform the table data processing method of any one of claims 1-8.
12. A computer program product comprising a computer program, characterized in that, The computer program, when executed by a processor, implements the table data processing method of any one of claims 1-8.
Citation Information
Patent Citations
Method and device for obtaining discrepant data
CN110292775A