Data table processing method and device, equipment and storage medium

Abstract

Embodiments of the present application disclose a data table processing method, device and equipment, and a storage medium, wherein the method comprises: performing sharding on an original data table; if a first data table segment is obtained by performing sharding on the original data table, displaying the first data table segment on a data table display interface, obtaining data types corresponding to M pieces of offline operation data associated with the original data table respectively, M being a positive integer; if the data types of the M pieces of offline operation data are all local data types, setting an editing state of the first data table segment to an editable state according to the M pieces of offline operation data; the first data table segment in the editable state is allowed to be edited; if a second data table segment is obtained by performing sharding on the original data table, displaying the second data table segment on the data table display interface comprising the first data table segment. The editing efficiency of the data table can be improved by the present application.

Description

Technical Field

[0001] This application relates to the field of Internet technology, and in particular to a data table processing method, apparatus, device and storage medium. Background Technology

[0002] A data table is a type of spreadsheet used in databases, also known as a smart sheet. It uses fields to describe the subject information or value range of a row of data records, or fields to describe the subject information or value range of a column of data records, providing a well-organized data structure. Therefore, data tables are widely used in fields such as finance, education, and healthcare. For example, businesses can use data tables to collect revenue information over a period of time, or students can use data tables to collect weekly class schedules. Typically, the source data of a data table (such as font color, font size, etc.) is stored in the corresponding backend server device. If a terminal needs to display the data table, it needs to load and display the data table based on the source data in the backend server device. In practice, it has been found that waiting for all data content in the data table to be loaded before allowing the corresponding user to edit the data table results in relatively low editing efficiency. Summary of the Invention

[0003] This application provides a data table processing method, apparatus, device, and storage medium to improve the efficiency of data table editing.

[0004] One embodiment of this application provides a data table processing method, including:

[0005] The original data table is divided into segments according to the order in which the original data content is displayed in the original data table;

[0006] If the original data table is sharded to obtain a first data table fragment, then the first data table fragment is displayed on the data table display interface, and the data types corresponding to the M offline operation data associated with the original data table are obtained, where M is a positive integer;

[0007] If the data types of the M offline operation data are all local data types, then based on the M offline operation data, the edit status of the first data table fragment is set to editable; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table;

[0008] If the original data table is fragmented to obtain a second data table fragment, then the second data table fragment is displayed on the data table display interface that includes the first data table fragment; the display order of the original data content in the first data table fragment is before the display order of the original data content in the second data table fragment.

[0009] One embodiment of this application provides a data table processing apparatus, including:

[0010] The sharding module is used to shard the original data table according to the display order of the original data content in the original data table;

[0011] The display module is used to display the first data table fragment on the data table display interface if the original data table is sharded to obtain the first data table fragment, and to obtain the data types corresponding to the M offline operation data associated with the original data table, where M is a positive integer;

[0012] The setting module is used to set the editable state of the first data table fragment according to the M offline operation data if the data types of the M offline operation data are all local data types; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table;

[0013] The display module is further configured to, if the original data table is fragmented to obtain a second data table fragment, display the second data table fragment on the data table display interface including the first data table fragment; the display order of the original data content in the first data table fragment is prior to the display order of the original data content in the second data table fragment.

[0014] Optionally, the display module includes: an acquisition unit and a determination unit.

[0015] The acquisition unit is used to acquire the operation type of the offline operation corresponding to the offline operation data Mi; the offline operation data Mi belongs to M offline operation data, where i is a positive integer less than or equal to M;

[0016] The determining unit is configured to determine the association between the offline operation data Mi and the data table segment in the original data table based on the operation type of the offline operation corresponding to the offline operation data Mi; and to determine the data type of the offline operation data Mi based on the association between the offline operation data Mi and the data table segment in the original data table.

[0017] Optionally, the determining unit determines the data type of the offline operation data Mi based on the association between the offline operation data Mi and the data table fragments in the original data table, including:

[0018] If the offline operation data Mi is associated with the first data table segment of the original data table but not with the second data table segment of the original data table, then the data type of the offline operation data Mi is determined to be a local data type.

[0019] If the offline operation data Mi is associated with the second data table segment in the original data table, but not with the first data table segment in the original data table, then the data type of the offline operation data Mi is determined to be a local data type.

[0020] Optionally, the settings module includes a traversal unit, an update unit, and a setting unit:

[0021] The traversal unit is used to traverse the M offline operation data if the data types of the M offline operation data are all local data types.

[0022] The update unit is configured to update the original data content in the first data table segment according to the first type of offline operation data if the first type of offline operation data is encountered in the M offline operation data, thereby obtaining the first updated data content; the first type of offline operation data is offline operation data that is associated with the first data table segment but not associated with the second data table segment.

[0023] The setting unit is used to set the editing state of the first data table segment to a first type of editable state; the first updated data content in the first data table segment in the first type of editable state is allowed to be edited, and the first type of editable state belongs to the editable state.

[0024] Optionally, the setting unit sets the editing state of the first data table fragment to a first type of editable state, including:

[0025] If all M offline operation data are of the first type, and the original data content in the first data table fragment has been updated according to the M first type offline operation data, then the editing state of the first data table fragment is set to the first type editable state.

[0026] If a second type of offline operation data is encountered in the M offline operation data entries, and the original data content in the first data table fragment has been updated based on the first type of offline operation data, then the first equivalent operation data of the second type of offline operation data is determined based on the first type of offline operation data. The first equivalent operation data is added to the execution queue, and the editing status of the first data table fragment is set to the first type of editable status. The second type of offline operation data is offline operation data associated with the second data table fragment but not associated with the first data table fragment. The first equivalent operation data is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table should be updated.

[0027] Optionally, the setting unit determines the first equivalent operation data of the second type of offline operation data based on the first type of offline operation data, including:

[0028] Obtain the first generation time of the first type of offline operation data and the second generation time of the second type of offline operation data;

[0029] Determine the first offline operation corresponding to the first type of offline operation data, and the second offline operation corresponding to the second type of offline operation data;

[0030] Generate a first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation;

[0031] A first delayed execution condition for the first equivalent operation is generated, and the first delayed execution condition and the first equivalent operation are determined as the first equivalent operation data of the second type of offline operation data. The first delayed execution condition is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table is updated according to the first equivalent operation.

[0032] Optionally, the setting unit generates a first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation, including:

[0033] If the first generation time is later than the second generation time, then based on the first offline operation and the second offline operation, determine the first equivalent operation associated with the second type of offline operation data;

[0034] If the first generation time is earlier than the second generation time, then the second offline operation is determined as the first equivalent operation associated with the second type of offline operation data.

[0035] Optionally, if the data types of the M offline operation data are all local data types, the setting module sets the edit state of the first data table fragment to editable state based on the M offline operation data, including:

[0036] If the data types of the M offline operation data are all local data types, then traverse the M offline operation data;

[0037] If all M offline operation data are of the second type, then the second equivalent operation data corresponding to the M offline operation data is determined; the second type of offline operation data is offline operation data that is associated with the second data table fragment but not associated with the first data table fragment; the second equivalent operation data is used to indicate that the second data fragment is updated when the second data table fragment is displayed.

[0038] The second equivalent operation data is added to the queue to be executed, and the editing state of the first data table fragment is set to the second type of editable state; the original data content in the first data table fragment in the second type of editable state is allowed to be edited, and the second type of editable state belongs to the editable state.

[0039] Optionally, the setting module determines the second equivalent operation data corresponding to the M pieces of second-type offline operation data, including:

[0040] Determine the third generation time corresponding to each of the M second-type offline operation data, and the third offline operation corresponding to each of the M second-type offline operation data;

[0041] Determine the execution order of the M third offline operations based on the M third generation times;

[0042] A second delayed execution condition is generated, and the second delayed execution condition, the execution order, and the third offline operations corresponding to the M second-type offline operation data are determined as the second equivalent operation data corresponding to the M second-type offline operation data. The second delayed execution condition is used to indicate that when the second data table fragment is displayed, the second data table fragment is updated according to the execution order and the third offline operations corresponding to the M second-type offline operation data.

[0043] Optionally, the device may also include a reading module and an updating module:

[0044] The reading module is used to read the equivalent operation data associated with the second type of offline operation data from the queue to be executed if the second data table fragment has been displayed, and use it as the target equivalent operation data.

[0045] The update module is used to update the data content in the data table segment associated with the target equivalent operation data in the original data table according to the target equivalent operation data, so as to obtain the second updated data content;

[0046] The settings module is also used to set the editable state of the second data table fragment.

[0047] Optionally, the device further includes an execution module, configured to, in response to an edit operation concerning the first data table segment, obtain the edit status of the first data table segment from a data status management service associated with the original data table; and if the edit status of the first data table segment is editable, perform the edit operation on the first data table segment.

[0048] Optionally, the setting module is further configured to update the original data content of the first data table segment and the original data content of the second data table segment based on the M offline operation data if at least one of the M offline operation data has a global data type and the second data table segment has been displayed; if the original data content of both the first data table segment and the second data table segment has been updated, the editing status of both the first data table segment and the second data table segment is set to editable.

[0049] One embodiment of this application provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the method described.

[0050] One embodiment of this application provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the steps of the method described.

[0051] One aspect of this application provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the method described.

[0052] In this application, after fragmenting the original data table to obtain the first data table fragment, the data types of the M offline operation data associated with the original data table are analyzed. Only when the data types of the M offline operation data are all local data types is the editing state of the first data table fragment set to editable based on the M offline operation data. This allows users to edit the first data table fragment without waiting for the original data table to be fragmented to obtain other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. Furthermore, the offline operation data of local data types here refers to offline operation data associated with a portion of the original data table fragments; that is, offline operation data of local data types refers to offline operation data that does not depend on any data table fragments of the original data table. In other words, the editing state of the first data table fragment is set to editable only when none of the M offline operation data depend on any data table fragments of the original data table. This avoids problems such as offline operation data being unusable or erroneous, ensuring the consistency of data content in the data table. Attached Figure Description

[0053] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0054] Figure 1 This is a schematic diagram of the architecture of a data table processing system provided in this application;

[0055] Figure 2 This is a flowchart illustrating the non-editable and editable first-piece data schemes provided in this application;

[0056] Figure 3 This is a schematic diagram illustrating the relationship between a data table fragment and user-editable time, as provided in this application.

[0057] Figure 4 This is a flowchart illustrating a data table processing method provided in this application;

[0058] Figure 5 This is a flowchart illustrating a data table processing method provided in this application;

[0059] Figure 6 This is a schematic diagram of offline operation data provided in this application;

[0060] Figure 7This is a flowchart illustrating a data table processing method provided in this application;

[0061] Figure 8 This is a flowchart illustrating a data table processing method provided in this application;

[0062] Figure 9 This is a schematic diagram illustrating the interaction scenario between functional modules in a computer device provided in this application;

[0063] Figure 10 This is a schematic diagram of the structure of a data table processing device provided in an embodiment of this application;

[0064] Figure 11 This is a schematic diagram of the structure of a computer device provided in an embodiment of this application. Detailed Implementation

[0065] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of this application.

[0066] To facilitate a clearer understanding of this application, the data table processing method for implementing this application is first introduced, such as... Figure 1 As shown, the data processing includes server 10 and a terminal cluster. The terminal cluster can include one or more terminals; there is no limit to the number of terminals here. Figure 1 As shown, the terminal cluster may specifically include terminal 1, terminal 2, ..., terminal n; it can be understood that terminal 1, terminal 2, terminal 3, ..., terminal n can all connect to server 10 via the network so that each terminal can interact with server 10 via the network.

[0067] The terminal is equipped with a data table platform that provides data table services to users. This platform can include mini-programs, web pages, or applications associated with the data tables. Users can create, view, and modify data tables through the platform installed on the terminal. The data table here is a database-type spreadsheet, also known as a smart sheet. It uses fields to describe the subject information or value range of a row of data records, or fields to describe the subject information or value range of a column of data records, providing a well-organized data structure. The data table includes data content, which consists of data records and fields. Fields describe the subject information or value range of the data records, and the data content may also include data table metadata (such as table ID, table title, etc.) and display view data (such as display view name, display view ID, display view type, and display view attributes, etc.). In one embodiment, the fields in the data table can be arranged in rows, meaning all fields in the data table are arranged in the same row. In this case, a field in the data table describes the subject information or value range of the data records in the column containing that field. For example, suppose the data table is Data Table 1, which collects student information. The fields and data records of Data Table 1 are arranged as shown in Table 1 below:

[0068] Table 1

[0069] Xiao Wang male …… Xiao Li female …… …… …… ……

[0070] As can be seen, the fields in Table 1 include name, gender, etc. All fields are arranged in the first row of Table 1. The name field is located in the first row and first column of Table 1. The name field describes the student's name in the data record located in the first column of Table 1. For example, "Xiao Wang" in the first column of the second row and "Xiao Li" in the second column of the second row are both student names. The gender field is located in the first row and second column of Table 1. The gender field describes the student's gender in the data record located in the second column of Table 1. For example, "Male" in the second row and second column is the gender of "Xiao Wang," and "Female" in the second row and third column is the gender of "Xiao Li."

[0071] In one embodiment, the fields in the data table can be arranged in columns, meaning all fields in the data table are arranged in the same column. In this case, a field in the data table is used to describe the subject information or value range of the data record in the row containing that field. For example, assuming the data table is Data Table 2 which collects student information, the arrangement of the fields and data records in Data Table 2 is shown in Table 2 below:

[0072] Table 2

[0073] gender male female …… …… …… …… ……

[0074] As can be seen, the fields in Table 2 include name, gender, etc. All fields in Table 2 are arranged in the first column. The name field is located in the first row and first column of Table 2. The name field describes the names of students in the data records in the first row of Table 2, such as "Xiao Wang" in the first row and second column, and "Xiao Li" in the first row and second column. The gender field is located in the second row and first column of Table 2. The gender field describes the gender of students in the data records in the second row of Table 2, such as "Male" in the second row and second column, representing the gender of "Xiao Wang," and "Female" in the second row and third column, representing the gender of "Xiao Li." It is understood that the data records and fields in the data table can be arranged in other ways, and this application does not limit this arrangement.

[0075] Understandably, server 10 can refer to a device used to provide backend services for the data table platform. For example, server 10 can be used to store the source data and data content of the data table. The source data of the data table includes information such as the layout, order, font, color, and font size of the data content. Server 10 can also be used to shard the data table to obtain at least two data table fragments. Sharding the data table means dividing the data content of a complete data table into at least two data table fragments. After obtaining the data table fragments, server 10 can sequentially transmit the sharded data table data and the source data of the data table to the terminal. The terminal can sequentially render the received data table fragments according to the source data of the data table and display the rendered data table fragments. Generally, the data table fragment first displayed by the terminal (that is, the data table fragment first obtained by server 10) can be called the first screen data, or the first data table fragment, or the first piece of data. The remaining data table fragments in the data table other than the first data table fragment can be called the second data table fragment, or the fragmented data. By fragmenting the data table, it is beneficial to reduce the amount of data transmitted initially, shorten the time for initial data transmission, calculation, and rendering, and enable the terminal to quickly display the first data table fragment, allowing users to see the data content in the data table more quickly and interact with the data table more quickly.

[0076] The server can be a single physical server, a server cluster or distributed system consisting of at least two physical servers, or a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, Content Delivery Network (CDN), and big data and artificial intelligence platforms. The terminal can specifically refer to smartphones, tablets, laptops, desktop computers, smart speakers, speakers with screens, smartwatches, etc., but is not limited to these. The terminals and servers can be directly or indirectly connected via wired or wireless communication. The number of terminals and servers can be one or at least two; this application does not impose any restrictions.

[0077] Understandably, the data tables displayed in the terminal of this application allow users to edit them, such as... Figure 2 As shown, the current data table editing scheme is a non-editable initial data segment scheme. This means that after the terminal loads the initial data segment of the data table, editing of the initial data segment is not allowed. Editing of the data table is only permitted after the terminal has loaded all data segment fragments of the data table. Specifically, as... Figure 2 As shown, the first piece of data is not editable, and the solution includes the following steps S1 to S6:

[0078] S1. The terminal loads the page, specifically the page containing the data table, and generates a data table retrieval request, which is then sent to the server. This request carries the data table's identifier and its view type identifier, etc. The view type describes the arrangement of data records and fields in the data table; common view types include dashboard view, table view, brochure view, and Gantt view. Upon receiving the request, the server identifies the requested data table (the original data table) based on its identifier and retrieves the source data. Based on the original data table's view type and the location information of its data content, the server determines the display order of the data content and divides the original data table accordingly.

[0079] S2. The terminal loads the first piece of data from the server. Loading the first piece of data means that if the server divides the original data table to obtain the first piece of data, the terminal obtains the first piece of data and the source data of the original data table from the server.

[0080] S3. Terminal application first data: The application first data refers to the rendering and other processing of the first data based on the source data of the original data table, and the display of the processed first data.

[0081] S4. The terminal loads fragmented data from the server. Loading fragmented data means that if the server fragments the original data table to obtain fragmented data, the terminal retrieves the fragmented data from the server. For example, if... Figure 3 As shown, after the server shards the original data table to obtain the first data piece, it continues to shard the original data table, obtaining shard data 1, shard data 2, ..., shard data n in sequence. The terminal loads n shard data from the server in sequence, where n can be an integer greater than or equal to 1.

[0082] S5. Terminal application fragmented data: Application fragmented data refers to the fragmented data that has been processed and rendered based on the source data of the original data table, and the processed fragmented data is then displayed.

[0083] S6. After the terminal displays the fragmented data, it can synchronize and apply the offline operation data associated with the original data table. Synchronizing and applying the offline operation data associated with the original data table means: obtaining the offline operation data associated with the original data table and updating the data content in the original data table (i.e., the initial fragment data and the fragmented data) displayed on the terminal based on the offline operation data. Here, offline operation data refers to operation log data generated when a user performs an operation on the original data table in an offline state. This offline operation data is stored locally on the terminal and is not committed to the backend database (the server's database) for disk persistence. The operation may include deleting a row or column in the original data table, inserting a new row, grouping the data content in the original data table, transforming rows and columns, etc. Offline state can refer to a state where the terminal has not established a network connection with the server, or it can refer to a state where the network connection between the terminal and the server is faulty or interrupted. Therefore, updating the data content in the original data table (i.e., the first piece of data and the fragmented data) displayed on the terminal based on the offline operation data means: restoring the data content in the updated data table from the original data table based on the offline operation data. Here, the updated data table refers to the data table obtained by the user performing a certain operation on the original data table in an offline state.

[0084] In the initial data non-editable scheme, after the terminal device completes the update of the original data table's data content—that is, after the terminal obtains all data table fragments of the original data table—the editable state of the original data table is set, at which point the user is allowed to edit the original data table. It is evident that in the initial data non-editable scheme, the data table can only be edited after all data table fragments have arrived (i.e., loaded) to the terminal, resulting in relatively low editing efficiency. For example, in the initial data non-editable scheme, the relationship between the user's editable time and the data table fragments of the original data table is as follows: Figure 3As shown in 10a, the user-editable time refers to the time during which users are allowed to edit the data content in the original data table. For example... Figure 3 In the original data table, there are first data fragments, fragment 1, fragment 2, ..., fragment n. In the scheme where the first data fragment is not editable, the data content in the original data table can only be edited after the terminal obtains the data table fragment n. In other words, in the scheme where the first data fragment is not editable, the time when the user can edit is the time when the terminal obtains all the data table fragments in the original data table.

[0085] like Figure 2 In addressing the low editing efficiency of data tables in schemes where the initial data segment is not editable, this application proposes a scheme where the initial data segment is editable. This scheme allows users to edit the initial data segment after the terminal has loaded it, and allows users to edit the full text of the data table after the terminal has loaded all data segment fragments. Specifically, as shown... Figure 2 As shown, the editable scheme for the first piece of data includes the following steps S7 to S13:

[0086] S7, Terminal executes page loading.

[0087] S8. The terminal loads the first piece of data from the server.

[0088] S9, first piece of data for terminal application.

[0089] S10. The terminal synchronizes and applies offline operation data. Specifically, the terminal obtains offline operation data related to the original data table and determines the data type of the offline operation data. If the data types of the offline operation data are all local data types, the edit status of the first piece of data is set to editable based on the offline operation data of the local data types. At this time, the first piece of data in the original data table allows the user to edit it. For example, if the offline operation data associated with the original data table includes offline operation data associated with the first piece of data, then the offline operation data associated with the first piece of data is obtained from the offline operation data of the local data types as the first type of offline operation data. The first piece of data is updated based on the first type of offline operation data, and the edit status of the first piece of data is set to editable. If the offline operation data associated with the original data table does not include offline operation data associated with the first piece of data, then the edit status of the first piece of data is set to editable. Here, offline operation data of local data types refers to offline operation data associated only with a portion of the data table. For example, offline operation data of local data types includes operation data for deleting a row of data, inserting a new row into a row, or updating a data record. The first type of offline operation data here refers to offline operation data that is associated with the first piece of data in the original data table and is not associated with the other pieces of data (i.e., fragmented data) in the original data table. Offline operation data associated with the first piece of data refers to offline operation data that acts on (or depends on) the first piece of data, such as operation data that deletes a row in the first piece of data, inserts a new row in a row in the first piece of data, or updates a data record in the first piece of data.

[0090] S11. The terminal loads fragmented data from the server.

[0091] S12, Terminal application fragmented data. It is understandable that the implementation method of step S7 in the editable first fragment data scheme can refer to the implementation method of step S1 in the non-editable first fragment data scheme; the implementation method of step S8 in the editable first fragment data scheme can refer to the implementation method of step S2 in the non-editable first fragment data scheme; and the implementation method of step S9 in the editable first fragment data scheme can refer to the implementation method of step S3 in the non-editable first fragment data scheme. The implementation method of step S11 in the editable first fragment data scheme can refer to the implementation method of step S4 in the non-editable first fragment data scheme; and the implementation method of step S12 in the editable first fragment data scheme can refer to the implementation method of step S5 in the non-editable first fragment data scheme. Repeated steps will not be elaborated further.

[0092] S13. The terminal synchronizes and applies offline operation data. Specifically, the terminal can determine whether there is second-type offline operation data associated with the fragmented data in the offline operation data of the local data type. If second-type offline operation data exists, the fragmented data is updated according to the second-type offline operation data, and the edit status of the fragmented data is set to editable. If there is no second-type offline operation data, the edit status of the fragmented data is set to editable, achieving full-text editability of the original data table. Here, second-type offline operation data refers to offline operation data associated with fragmented data in the original data table but not associated with the first fragmented data in the original data table. Offline operation data associated with fragmented data refers to offline operation data that acts on (or depends on) fragmented data. For example, fragmented data includes fragmented data 1, fragmented data 2, ..., fragmented data n. Second-type offline operation data may include one or more of the following: deleting a row in fragmented data 2, inserting a new row in a row in fragmented data 3, updating a data record in fragmented data n, etc.

[0093] Comparing the non-editable first data segment scheme with the editable first data segment scheme reveals the following: In the editable first data segment scheme, after the terminal device updates the first data segment of the original data table (i.e., after the terminal obtains the first data segment of the original data table), the editable state of the first data segment is set based on offline operation data. At this point, the user is allowed to edit the first data segment of the original data table. Therefore, the editable first data segment scheme allows users to edit the data table without waiting for all data table segments to arrive (i.e., be loaded) to the terminal, improving editing efficiency. For example, in the editable first data segment scheme, the relationship between the user-editable time and the data table segments of the original data table is as follows: Figure 3 As shown in 10b. Figure 3 In the original data table, there are initial data segments, segment 1, segment 2, ..., segment n. In the editable initial data segment scheme, once the terminal receives the initial data segment, it becomes editable. In other words, in this scheme, the user's editable time is the time it takes for the terminal to receive the initial data segment of the original data table. Therefore, the editable initial data segment scheme shortens the user's waiting time, allowing them to quickly edit the data content in the table and improving editing efficiency.

[0094] Further, please see Figure 4 This is a flowchart illustrating a data table processing method provided in an embodiment of this application. Figure 4 As shown, this method can be derived from... Figure 1 It can be executed by the terminal in the middle, or by Figure 1 The server in the middle can be used to execute it, or it can be executed by... Figure 1The method is executed jointly by the terminal and the server. The device used to execute this method in this application can be collectively referred to as a computer device. The data table processing method may include the following steps S101 to S104:

[0095] S101. The computer equipment segments the original data table according to the display order of the original data content in the original data table.

[0096] In this application, the computer device can obtain display attribute information of the original data content in the original data table. The display attribute information includes at least one or more of the following: display view type and position information. The position information of the original data content can be determined based on the position identifiers of the original data content in a first direction and a second direction within the original data table. For example, the first direction can be horizontal, meaning the position identifier in the first direction can be the row identifier of the original data content in the original data table; the second direction can be vertical, meaning the position identifier in the second direction can be the column identifier of the original data content in the original data table. The display view type of the original data content can be specified by the user corresponding to the computer device, or it can be the display view type of the original data content of the original data table when the computer device last displayed the original data table. The original data table can refer to the data table before the user performs a certain operation on it in an offline state, and the original data content refers to the data content contained in the data table before the user performs a certain operation on it in an offline state. Furthermore, the computer equipment can determine the display order of the data content in the original data table based on the display attribute information of the original data content. Furthermore, the original data table is fragmented according to the display order of the original data content in the original data table, that is, the data content in the original data table is fragmented sequentially according to the display order of the original data content in the original data table.

[0097] Understandably, in this application, the first data table fragment includes the table header and data records of the original data table. The table header includes fields, data table metadata (such as table ID, table title, etc.), and display view data (such as display view name, display view ID, display view type, and display view attributes, etc.). The data volume of the first data table fragment can be determined by any one or a combination of the following two methods: Method 1: The data volume of the first data table fragment can be determined based on the size of the computer device's display screen. Specifically, the computer device can determine the maximum amount of display data that the display screen can display based on the size of the display screen. This maximum display data volume refers to the maximum amount of data content that the display screen can display while clearly displaying the data content. For example, the data volume can refer to the number of rows of data content. Based on the maximum display data volume, the data volume of the first data table fragment is determined. For example, the data volume of the first data table fragment can be greater than the maximum display data volume, so that more data content can be displayed to the user when the user performs a zoom-out operation on the first data table fragment. The amount of data in the first data table segment can be less than or equal to the maximum amount of data to be displayed. This allows users to fully and clearly view the data content within the first data table segment when zooming in on it.

[0098] Method 2: The data volume of the first data table fragment can be determined based on the data table processing performance parameters of the computer device. These parameters include rendering efficiency, computational efficiency, etc. If the rendering efficiency of the computer device is greater than the rendering efficiency threshold, the first data volume is determined as the data volume of the first data table fragment. If the rendering efficiency of the computer device is less than or equal to the rendering efficiency threshold, the second data volume is determined as the data volume of the first data table fragment. The first data volume is greater than the second data volume.

[0099] Understandably, the data size of the second data table fragment can be determined using either or a combination of the following two methods: Method 1: The data size of the second data table fragment can be determined based on the data table processing performance parameters of the computer device. For example, if the rendering efficiency of the computer device is greater than a rendering efficiency threshold, the third data size is determined as the data size of the second data table fragment; if the rendering efficiency of the computer device is less than or equal to the rendering efficiency threshold, the fourth data size is determined as the data size of the second data table fragment; the third data size is greater than the fourth data size. By determining the data size of the second data table fragment based on the data table processing performance parameters of the computer device, the data content of the original data table can be quickly displayed to the user. The data size of the second data table fragment can be greater than the data size of the first data table fragment, or it can be less than the data size of the first data table fragment; this application does not limit this.

[0100] Method 2: The amount of data in the second data table segment can be determined based on the amount of data in the first data table segment. For example, if the first data table segment has 60 rows and the original data table header has 4 rows, since the header in the first data table segment will still be displayed when the second data table is shown, the amount of data in the second data table segment can be: 60 - 4 = 54 rows.

[0101] S102. If the original data table is fragmented to obtain a first data table fragment, the computer device displays the first data table fragment on the data table display interface and obtains the data types corresponding to the M offline operation data associated with the original data table, where M is a positive integer.

[0102] In this application, if the original data table is fragmented to obtain a first data table fragment, then the first data table fragment is displayed on the data table display interface of the data table platform. In other words, by prioritizing the display of the first data table fragment, users can view part of the data content of the original data table without waiting for the original data table to be fragmented to obtain a second data table fragment. This reduces the amount of data in the initial data table fragment transmission, shortens data transmission, calculation, and rendering time, and facilitates users' rapid interaction with the data content in the data table. Displaying the first data table fragment here can refer to rendering, calculating, and other processing the original data content in the first data table fragment based on the source data of the original data table, and then displaying the processed first data table fragment. The source data of the original data table includes the font, color, font size, arrangement, etc., of the original data content. It is understood that in this application, if the computing device does not contain offline operation data about the original data table, when the original data table is fragmented to obtain the first data table fragment, the editable state of the first data table fragment can be directly set.

[0103] Furthermore, the computer device can obtain the data types corresponding to the M offline operation data associated with the original data table. Here, the M offline operation data associated with the original data table can refer to operation log data generated when a user performs an operation on the original data table while offline, or it can refer to operation log data generated from the most recent offline operation performed on the original data table. The data types of offline operation data include local data types and global data types. Global data type offline operation data can refer to offline operation data associated with all data table segments in the original data table, while local data type offline operation data can refer to offline operation data associated with some data table segments in the original data table. For example, assuming the original data table includes n data table segments, global data type offline operation data refers to offline operation data associated with all n data table segments, such as sorting data records under a certain field, filtering data records under a certain field, or grouping data records in the original data table according to a certain field, etc. Local operation data can refer to offline operation data associated with any one of the n data table segments, such as operation data for deleting a row of data, inserting a new row into a row, or updating a data record.

[0104] It is understandable that the data types corresponding to the M offline operation data associated with the original data table mentioned above include: the computer device can determine the operation type of the offline operation corresponding to the offline operation data Mi. The offline operation corresponding to the offline operation data Mi can refer to the operation performed on the original data content in the original data table in an offline state. For example, offline operations can include performing a deletion operation on a row or column of the original data content of the original data table, performing a sorting operation on data records under a certain field in the original data content, performing an update operation on a certain data record in the original data content, performing a filtering operation on data records under a certain field in the original data content, and so on. The operation type corresponding to the offline operation can include global operation type and local operation type. Global operation type refers to the operation type corresponding to the offline operation that applies to all data table fragments of the original data table, while local operation type refers to the operation type corresponding to the offline operation that applies to a portion of the data table fragments of the original data table. For example, a global operation type refers to an offline operation that needs to be performed on all data table fragments in the original data table. Offline operations of the global operation type can include, but are not limited to: deleting a column in the original data table, sorting data records under a specific field in the original data table, filtering data records under a specific field in the original data table, etc. A local operation type refers to an offline operation that needs to be performed on a portion of the original data table. Offline operations of the local operation type can include, but are not limited to: deleting a row in the original data table, updating a specific data record in the original data table, inserting a new row into a specific row in the original data table, etc.

[0105] Furthermore, the computer device can determine the association between offline operation data Mi and data table segments in the original data table based on the operation type of the offline operation corresponding to Mi. An association between offline operation data Mi and a specific data table segment in the original data table means that the data table segment needs to be updated based on the offline operation data Mi; an unassociated association means that the data table segment does not need to be updated based on the offline operation data Mi. For example, if the operation type of the offline operation corresponding to Mi is a global operation type, then it is determined that offline operation data Mi is associated with all data table segments in the original data table, and the data type of offline operation data Mi is determined to be a global data type. If the operation type of the offline operation corresponding to Mi is a local operation type, then it is determined that offline operation data Mi is associated with some data table segments in the original data table, and the data type of offline operation data Mi is determined to be a local data type.

[0106] Understandably, determining the data type of offline operation data Mi based on the association between the offline operation data Mi and the data table fragments in the original data table includes: if the offline operation data Mi is associated with the first data table fragment in the original data table but not with the second data table fragment, then the data type of the offline operation data Mi is determined to be a local data type, and in this case, the offline operation data Mi can be called first-type offline operation data. For example, first-type offline operation data may include, but is not limited to: deleting a row in the first data table fragment, inserting a new row in the first data table fragment, updating a data record in the first data table fragment, etc. If the offline operation data Mi is associated with the second data table fragment in the original data table but not with the first data table fragment in the original data table, then the data type of the offline operation data Mi is determined to be a local data type, that is, the offline operation data Mi is second-type offline operation data. For example, second-type offline operation data may include, but is not limited to: deleting a row in the second data table fragment, inserting a new row in the second data table fragment, updating a data record in the second data table fragment, etc.

[0107] S103. If the data types of the M offline operation data are all local data types, the computer device sets the editing state of the first data table fragment to an editable state based on the M offline operation data. The first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table.

[0108] In this application, the offline operation data of the global data type depends on all data table fragments in the original data table. If the edit status of the first data table fragment is set to editable based on the offline operation data of the global data type, it will cause errors in the application of the offline operation data or the offline operation data cannot be applied. Here, setting the edit status of the first data table fragment to editable based on the offline operation data of the global data type means: updating the first data table fragment based on the offline operation data of the global data type to obtain updated data content, and then setting the edit status of the first data table fragment carrying the updated data content to editable. For example, the original data table is shown in Table 3 below. The original data table is a data table that collects the colors of letters in a document. The fields in the original data table include letters and colors, and the data records in the original data table are the colors of each letter. Assume that the offline operation data 1 associated with the original data table is: sorting the data records under the color field in the order of red, yellow, blue, and green. This offline operation data 1 is the offline operation data of the global data type.

[0109] Table 3

[0110] A red B yellow C green D blue E red F red G green …… ……

[0111] Suppose the computer device fragments the original data table to obtain a first data table fragment, which consists of rows 1 to 4 of the original data table, as shown in Table 4. Further, based on the offline operation data 1, the first data table fragment is updated to obtain the updated data content within it. Since the original data records in the first data table fragment are arranged in the order of red, yellow, blue, and green, the arrangement of the original data records in the first data table fragment is the same as the arrangement of the updated data content, as shown in Table 4.

[0112] Table 4

[0113] A red B yellow C green

[0114] However, by arranging the data records in the original data table according to offline operation data 1, a sorted original data table is obtained. The arrangement of the data records in this sorted original data table is shown in Table 5. Table 5 shows that the first row of the sorted original data table reflects the fields in the original data table, the second row reflects the color of the letter A, the third row reflects the color of the letter E, and the fourth row reflects the color of the letter F. It is evident that the updated data content in the first data table fragment is different from the data content in the first to fourth rows of the sorted original data table. The sorted original data table represents the state that the original data table actually needs to be restored after going online. That is, when the first data table fragment arrives, it is updated according to the offline operation data of the global data type, causing an error in the application of the offline operation data. To address this issue, in this application, if the M offline operation data entries include one or more entries with local data types, the editing status of the first data table fragment is paused based on these M offline operation data entries, and the data is set to editable. This avoids errors or inapplicability of offline operation data, ensuring the consistency of data content in the data table. For example, it ensures that the updated data content in the first data table fragment is consistent with the data content at the corresponding position (i.e., rows 1 to 4) in the sorted original data table. If the M offline operation data entries are all of local data types, the editing status of the first data table fragment is set to editable based on these M offline operation data entries. Users can edit the first data table fragment without waiting for the original data table to be fragmented into other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. It is understood that setting the editable state of the first data table segment means displaying a prompt message on the data display interface to indicate that the first data table segment is editable; alternatively, the computer device may output an editable voice prompt to indicate that the first data table segment is editable; or the computer device may un-gray out the first data table segment, with un-graying indicating that the first data table segment is editable and graying out indicating that the first data table segment is not editable. Alternatively, the computer device may display the first data table segment in other prominent display methods to indicate that the first data table segment is editable, and this application does not limit this to any particular method.

[0115] Table 5

[0116]

[0117]

[0118] Understandably, when the original data table supports multiple users to edit, the editable state of the first data table can mean that multiple users are allowed to edit the first data table fragment. These multiple users can include the creator of the original data table and any user authorized by the creator to edit. When the original data table supports only one user to edit, the editable state of the first data table can mean that a user with authorized privileges is allowed to edit the first data table fragment. These authorized users can be either the creator of the original data table or any user authorized by the creator to edit.

[0119] Furthermore, when the first data table fragment is in an editable state and an editing operation is received from the target object, the editing operation may include the target object's object information (such as account, nickname, etc.). The computer device can obtain the permission settings information of the original data table. This permission settings information reflects the set of objects that have editing permissions for the original data table. If the target object belongs to this set of objects, the editing operation is performed on the first data table fragment; if the target object does not belong to this set of objects, the editing operation on the first data table fragment is paused. This can improve the security of the data table.

[0120] S104. If the original data table is fragmented to obtain a second data table fragment, the computer device displays the second data table fragment on the data table display interface that includes the first data table fragment; the display order of the original data content in the first data table fragment is before the display order of the original data content in the second data table fragment.

[0121] In this application, if the original data table is fragmented to obtain a second data table fragment, then the second data table fragment is displayed on the data table display interface that includes the first data table fragment. Displaying the second data table fragment here means: processing the second data table fragment based on the source data of the original data table, such as rendering and calculation, to obtain a processed second data table fragment, and then displaying the processed second data table fragment. The display order of the original data content in the first data table fragment precedes the display order of the original data content in the second data table fragment. In other words, the first and second data table fragments are displayed sequentially according to the display order of the original data content in the original data table, ensuring that the display order of the data content in the first and second data table fragments is consistent with the display order of the data content in the original data table.

[0122] Understandably, computer devices can display the implementation of the second data table segment on a data table display interface that includes the first data table segment through any one of the following two display methods or a combination of the two display methods:

[0123] Method 1: The data table display interface includes only one data table display area. If the original data table is fragmented into a second data table segment, the computer device can hide the first data table segment in the data table display area of ​​the data table display interface and highlight the second data table segment in the same area. Alternatively, if the original data table is fragmented into a second data table segment, and a display instruction for the second data table segment is received, the computer device can hide the first data table segment in the data table display area of ​​the data table display interface and highlight the second data table segment. Here, "hidden display" refers to a display method where the user cannot see the displayed data content, while "highlighted display" can refer to a display method where the user can see the displayed data content. In other words, hiding the first data table segment in the data table display area of ​​the data table display interface means hiding the data records within the first data table segment. In other words, the header portion of the first data table segment is still displayed in the data table display area; only the data records within the first data table segment are hidden.

[0124] Method 2: The data table display interface includes only two data table display areas, namely the first data table display area and the second data table display area. The first data table fragment is displayed in the first data table display area. If the original data table is fragmented to obtain the second data table fragment, the computer device displays the second data table fragment in the second data table display area.

[0125] Understandably, after the first data table fragment is in an editable state, S users can perform editing operations on the first data table fragment, where S can be greater than or equal to 1. When S is greater than 1, it indicates that the original data table supports editing by multiple users. The computer device can use the updated first data table fragments obtained by the S users performing editing operations on the first data table fragment as S first candidate data table fragments, and merge the S first candidate data table fragments to obtain a first merged data table fragment. Here, merging the S first candidate data table fragments can refer to removing data content deleted by users, adding data content added by users, etc., in the first data table fragment. At this time, the above-mentioned S104 includes: if the original data table is fragmented to obtain a second data table fragment, the computer device updates the first data table fragment on the data table display interface to the first merged data table fragment, and displays the second data table fragment on the data table display interface including the first merged data table fragment. In this application, after fragmenting the original data table to obtain the first data table fragment, the data types of the M offline operation data associated with the original data table are analyzed. Only when the data types of the M offline operation data are all local data types is the editing state of the first data table fragment set to editable based on the M offline operation data. This allows users to edit the first data table fragment without waiting for the original data table to be fragmented to obtain other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. Furthermore, the offline operation data of local data types here refers to offline operation data associated with a portion of the original data table fragments; that is, offline operation data of local data types refers to offline operation data that does not depend on any data table fragments of the original data table. In other words, the editing state of the first data table fragment is set to editable only when none of the M offline operation data depend on any data table fragments of the original data table. This avoids problems such as offline operation data being unusable or erroneous, ensuring the consistency of data content in the data table.

[0126] Further, please see Figure 5 This is a flowchart illustrating a data table processing method provided in an embodiment of this application. Figure 5 As shown, this method can be derived from... Figure 1 It can be executed by the terminal in the middle, or by Figure 1 The server in the middle can be used to execute it, or it can be executed by... Figure 1 The method is executed jointly by a terminal and a server. The device used to execute this method in this application can be collectively referred to as a computer device. The data table processing method may include the following steps S201 to S208:

[0127] S201. The computer equipment segments the original data table according to the display order of the original data content in the original data table.

[0128] S202. If the original data table is fragmented to obtain a first data table fragment, the computer device displays the first data table fragment on the data table display interface and obtains the data types corresponding to the M offline operation data associated with the original data table, where M is a positive integer.

[0129] S203. If the data types of the M offline operation data are all local data types, then the computer device will traverse the M offline operation data.

[0130] S204. If the first type of offline operation data is found in the M offline operation data, the computer device updates the original data content in the first data table segment according to the first type of offline operation data to obtain the first updated data content; the first type of offline operation data is offline operation data that is associated with the first data table segment but not associated with the second data table segment.

[0131] S205, the computer device sets the editing state of the first data table segment to a first type of editable state; the first updated data content in the first data table segment in the first type of editable state is allowed to be edited, and the first type of editable state belongs to the editable state.

[0132] In steps S203-S205, if the data types of the M offline operation data are all local data types, the computer device can obtain the generation time of the M offline operation data and iterate through the M offline operation data sequentially according to the generation time. If the computer device encounters first-type offline operation data among the M offline operation data, it can update the original data content in the first data table segment based on the first-type offline operation data to obtain the first updated data content. The first updated data content is the collective term for all data content in the first data table segment after the original data content is updated. Furthermore, the edit state of the first data table segment can be set to an editable state, that is, the first updated data content in the first data table segment in the first-type editable state is allowed to be edited. In other words, after the first data table segment arrives and offline operation data is applied to the first data table segment, the first data table segment can be edited immediately without waiting for the arrival of the second data table segment, thus speeding up the time for the data table segment to reach the editable state, improving the editing efficiency of the data table, and providing users with a better editing experience.

[0133] Understandably, offline operation data may block user operations. This means that the offline operation data cannot be applied or will be applied incorrectly. Typically, after obtaining a first data table fragment, the computer needs to update that fragment based on the first type of offline operation data. However, if the M offline operation data entries include offline operation data that depends on subsequent fragments (i.e., the second data table fragment), it can easily lead to the first type of offline operation data being unapplied or being applied incorrectly. For example, the offline operation data of the original data table might be as follows... Figure 6 As shown, the offline operations on the original data table include deleting data record 2 from shard 2, inserting a new row at row 1000, modifying data record 5 in shard 3, and deleting the data record in the second column of the first shard. For example... Figure 6 As shown, deleting data record 2 in shard data 2 depends on shard data 2; inserting a new row in row 1000 depends on a subsequent shard data; and modifying data record 5 in shard data 3 depends on shard data 3. The generation time of each offline operation data, from earliest to latest, is: deleting data record 2 in shard data 2, inserting a new row in row 1000, modifying data record 5 in shard data 3, and deleting the data record in the second column of the first shard data. Therefore, the application time of each offline operation data, from earliest to latest, is: deleting data record 2 in shard data 2, inserting a new row in row 1000, modifying data record 5 in shard data 3, and deleting the data record in the second column of the first shard data. In other words, the computer device needs to apply the following offline operation data in sequence: deleting data record 2 in shard data 2, inserting a new row in row 1000, and modifying data record 5 in shard data 3, before the first shard data can be updated based on the deletion of the data record in the second column of the first shard data. In other words, once the first batch of data arrives, the data records in the second column of the first batch of data cannot be deleted immediately to update the first batch of data, causing offline operation data application to be blocked.

[0134] To address the issue of application blocking caused by offline operation data, this application addresses the following: if all M pieces of offline operation data encountered are of the first type, and the original data content in the first data table fragment has been updated based on the M pieces of first-type offline operation data, then the editable state of the first data table fragment is set to the first type of editable state. If second-type offline operation data is also encountered among the M pieces of offline operation data, and the original data content in the first data table fragment has been updated based on the first type of offline operation data, it indicates that the M pieces of offline operation data include not only the first type but also the second type, and the sum of the number of first-type and second-type offline operation data is M. In other words, the M pieces of offline operation data also include offline operation data that depends on subsequent fragment data. At this point, the computer device can determine the first equivalent operation data of the second type of offline operation data based on the first type of offline operation data. The first equivalent operation data refers to the operation data that is executed later. This first equivalent operation data is used to instruct that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data should be updated. The data table fragment associated with the first equivalent operation data can be determined jointly based on the first type of offline operation data and the second offline operation data. The data table fragment associated with the first equivalent operation data is either the first data table fragment or the second data table fragment. The updated content obtained by updating the original data table based on the first type of offline operation data and the second type of offline operation data is the same as the updated data content obtained by updating the original data table based on the first type of offline operation data and the first equivalent operation data. For example, the original data table is shown in Table 6 below. The original data table is a data table for collecting user information. The fields in the original data table include user serial number, gender, etc. The offline operation data of the original data table includes: Offline operation data A: Insert a new row in the fourth row of the original data table; Offline operation data B: Delete the third row of the original data table.

[0135] Table 6

[0136] 1 male 2 female 3 male 4 female

[0137] Assuming that the execution order of offline operation data A is before that of offline operation data B, if offline operation data A is executed first and then offline operation data B is executed on the original data table, an updated data table is obtained, as shown in Table 7.

[0138] Table 7

[0139]

[0140]

[0141] Therefore, if the computer device first performs offline operation data B on the original data table, and then performs the equivalent operation data A' of offline operation data A (where equivalent operation data A' inserts a new row in the second row), the resulting updated data table is the same as Table 7 above. In implementation, the computer device can add the first equivalent operation data to the queue to be executed and set the editing state of the first data table fragment to a first type of editable state; the second type of offline operation data is offline operation data associated with the second data table fragment but not associated with the first data table fragment. The first equivalent operation data is used to indicate that when the second data table fragment is completed and displayed, the data fragment associated with the first equivalent operation data in the original data table should be updated. For example, as shown in Table 6, assume that the first data table fragment includes the data content of the first to third rows in the original data table, and the second data table fragment includes the data content of the fourth to fifth rows in the original data table. That is, offline operation data A is associated with the second data table fragment, offline operation data B is associated with the first data table fragment, and equivalent operation data A' is associated with the first data table fragment in the original data table. In other words, when the first data table fragment arrives, offline operation data B is executed on the first data table fragment, the editing state of the first data table fragment is set to the first type of editing state, and the equivalent operation data A' is added to the execution queue. When the second data table fragment arrives, the equivalent operation data A' is read from the execution queue, and the equivalent operation data A' of the offline operation data A is executed on the first data table fragment.

[0142] It is understood that setting the editing state of the first data table segment to the first type of editable state means displaying a first prompt message on the data display interface, which indicates that the first updated data content within the first data table segment is editable; or, the computer device outputs an editable first voice prompt, which indicates that the first updated data content within the first data table segment is editable; or, the computer device can un-gray out the first data table segment, which indicates that the first updated data content within the first data table segment is editable, while graying out indicates that the first data table segment is not editable. Alternatively, the computer device can display the first data table segment in other prominent display methods to indicate that the first updated data content within the first data table segment is editable, and this application does not limit this. It is understood that the first updated data content refers to all data content contained in the first data table segment after updating the original data content in the first data table segment according to the first type of offline operation data.

[0143] Understandably, the aforementioned determination of the first equivalent operation data of the second type of offline operation data based on the first type of offline operation data includes: the computer device can obtain the first generation time of the first type of offline operation data and the second generation time of the second type of offline operation data. The first generation time may refer to the time when a certain operation is performed on the first data table segment of the original data table in an offline state, and the second generation time is the time when a certain operation is performed on the second data table segment of the original data table in an offline state. Further, the computer device determines the first offline operation corresponding to the first type of offline operation data and the second offline operation corresponding to the second type of offline operation data; here, the first offline operation refers to the operation performed on the first data table segment of the original data table in an offline state, and the second offline operation refers to the operation performed on the second data table segment of the original data table in an offline state. Further, the computer device can generate the first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation; then, it generates a first delayed execution condition for the first equivalent operation, and determines the first delayed execution condition and the first equivalent operation as the first equivalent operation data of the second type of offline operation data. The first delayed execution condition is used to instruct that when the second data table fragment is completed and displayed, the data table fragment associated with the first equivalent operation data be updated according to the first equivalent operation.

[0144] Understandably, the above-mentioned generation of the first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation includes: if the first generation time is later than the second generation time, then the first equivalent operation associated with the second type of offline operation data is determined based on the first offline operation and the second offline operation. For example, the above-mentioned offline operation data A is: inserting a new row in the fourth row of the original data table; offline operation data B is: deleting the third row of the original data table. The offline operation corresponding to offline operation data A is inserting a new row in the fourth row, and the offline operation corresponding to offline operation data B is deleting the third row. Offline operation data A is associated with the second data table fragment, and offline operation data B is associated with the first data table fragment. The generation time of offline operation data A is earlier than the generation time of offline operation data B. Based on the offline operation corresponding to offline operation data A and the offline operation corresponding to offline operation data B, the equivalent operation of offline operation data A is determined: that is, inserting a new row in the second row. If the first generation time is earlier than the second generation time, then the second offline operation is determined as the first equivalent operation associated with the second type of offline operation data.

[0145] S206. If all M offline operation data are of the second type, the computer device determines the second equivalent operation data corresponding to the M offline operation data of the second type. The second type of offline operation data is offline operation data that is associated with the second data table segment but not associated with the first data table segment. The second equivalent operation data is used to indicate that the second data table segment should be updated when it is displayed.

[0146] S207. The computer device adds the second equivalent operation data to the queue to be executed and sets the editing state of the first data table fragment to the second type of editable state; the original data content in the first data table fragment in the second type of editable state is allowed to be edited, and the second type of editable state belongs to the editable state.

[0147] In steps S206 and S207, if all M offline operation data entries are of the second type, it indicates that none of the M offline operations are associated with the first data table fragment. The computer device can then determine the second equivalent operation data corresponding to the M second-type offline operation data entries. This second equivalent operation data is used to indicate that the second data table fragment should be updated when it is fully displayed. The second equivalent operation data is the delayed operation data of the second-type offline operation data; that is, the updated data content obtained by updating the second data table fragment based on the second-type offline operation data is the same as the updated data content obtained by updating the second data table fragment based on the second equivalent operation data. Further, the computer device can add this second equivalent operation data to the execution queue and set the editing state of the first data table fragment to the second type of editable state.

[0148] It is understood that setting the editing state of the first data table segment to the second type of editable state means displaying a second prompt message on the data display interface. This second prompt message indicates that the original data content within the first data table segment is editable. Alternatively, the computer device may output an editable second voice prompt, indicating that the original data content within the first data table segment is editable. Or, the computer device may un-gray out the first data table segment; un-graying out indicates that the original data content within the first data table segment is editable, while graying out indicates that the first data table segment is not editable. Alternatively, the computer device may display the first data table segment in other prominent display methods to indicate that the original data content within the first data table segment is editable; this application does not limit this. The first and second prompt messages may be the same or different, and may include icons, text, symbols, etc. The first and second voice prompt messages may be the same or different.

[0149] Understandably, determining the second equivalent operation data corresponding to the M second-type offline operation data includes: the computer device can determine the third generation time corresponding to each of the M second-type offline operation data, and the third offline operation corresponding to each of the M second-type offline operation data. The third generation time is the time when the third offline operation is performed on the second data table fragment in the original data table in the offline state. The third offline operation can refer to the operation performed on the second data table fragment in the original data table in the offline state, such as deleting a row in the second data table fragment, inserting a new row in the second data table fragment, updating a data record in the second data table fragment, etc. Further, based on the M third generation times, the execution order of the M third offline operations is determined, that is, the earlier the third generation time, the earlier the execution order of the corresponding third offline operation data; the later the third generation time, the later the execution order of the corresponding third offline operation data. Then, a second delayed execution condition is generated, and the second delayed execution condition, the execution order, and the third offline operations corresponding to the M second-type offline operation data are determined as the second equivalent operation data corresponding to the M second-type offline operation data. The second delayed execution condition is used to instruct that when the second data table fragment is displayed, the second data table fragment shall be updated sequentially according to the third offline operation corresponding to each of the M second-type offline operation data, in accordance with the execution order. By adding the second equivalent operation data associated with the second-type offline operation data to the pending execution queue, problems such as offline operation data not being applicable, offline operation data application errors, and offline operation data application blocking can be avoided, ensuring the consistency of the data table content.

[0150] S208. If the original data table is fragmented to obtain a second data table fragment, the computer device displays the second data table fragment on the data table display interface that includes the first data table fragment; the display order of the original data content in the first data table fragment is before the display order of the original data content in the second data table fragment.

[0151] Understandably, if the second data table fragment has been fully displayed, the computer device can retrieve the equivalent operation data associated with the second type of offline operation data from the execution queue as the target equivalent operation data. If the target equivalent operation data is associated with the first data table fragment, the first updated data content in the first data table fragment is updated according to the target equivalent operation data to obtain the second updated data content. If the target equivalent operation data is associated with the second data table fragment, the original data content in the second data table fragment is updated according to the target equivalent operation data to obtain the second updated data content. When all equivalent operation data has been applied, the editing state of the second data table fragment is set to editable, realizing full-text editability of the original data table.

[0152] Understandably, if at least one of the M offline operation data entries has a global data type, and the second data table fragment has been fully displayed, then the original data content of both the first and second data table fragments will be updated based on the M offline operation data entries. If the original data content of both the first and second data table fragments has been updated, then the edit status of both the first and second data table fragments will be set to editable, enabling full-text editability of the original data tables.

[0153] For example, such as Figure 7 As shown, the implementation process of this scheme includes the following steps S21a to S26a: S21a: When the computer device slices the original data table to obtain the first data table fragment, it confirms that the first data table fragment has been obtained (i.e., the first data table fragment has arrived), performs rendering and other processing on the first data table fragment, and displays the first data table fragment (i.e., applies the first data table fragment). S22a: The computer device can obtain M offline operation data related to the original data table, and determine whether the M offline operation data includes offline operation data with a global data type. If the M offline operation data does not include offline operation data with a global data type, then steps S25a to S26a are executed. If the M offline operation data includes offline operation data with a global data type, then steps S23a to S24a are executed. S23a. If the M offline operation data entries include offline operation data with a global data type, apply the second data table fragment. S24a. Process the offline operation data, that is, update the first and second data table fragments based on the offline operation data, and set the original data table's edit state to editable, thus enabling full-text editability of the data table. S25a. If the M offline operation data entries do not include offline operation data with a global data type, process the offline operation data, that is, set the first data table's edit state to editable based on the offline operation data, at which point the first data table fragment can be edited. S26a. Apply the second data table fragment, that is, when the original data table fragment is fragmented to obtain the second data table fragment, render and calculate the second data table fragment, and then display the second data table fragment.

[0154] Furthermore, such as Figure 8As shown, the implementation process of this scheme includes the following steps S31a to S38a: S31a: When the computer device slices the original data table to obtain a first data table fragment, it confirms that the first data table fragment has been obtained (i.e., the first data table fragment has arrived), performs rendering and other processing on the first data table fragment, and displays the first data table fragment (i.e., applies the first data table fragment). S32a: The computer device can obtain M offline operation data related to the original data table, and determine whether the M offline operation data includes offline operation data with a global data type. If the M offline operation data does not include offline operation data with a global data type, then steps S33a to S36 are executed. If the M offline operation data includes offline operation data with a global data type, then steps S37a to S38a are executed. S33a. If the M offline operation data entries do not include offline operation data with a global data type, process the offline operation data and set the edit state of the first data table fragment to editable, allowing users to edit the data content in the first data table fragment. Processing the offline operation data here includes generating equivalent operation data for the offline operation data, etc. Further, S34a. If the original data table is fragmented to obtain a second data table fragment, apply the second data table fragment. Applying the second data table fragment means performing rendering, calculation, and other operations on the second data table fragment. S35a. Process the equivalent operation data associated with the second data table fragment in the execution queue, that is, update the second data table fragment based on the equivalent operation data associated with the second data table fragment. S36a. Determine whether the application of the second data table fragment is complete (i.e., fragmentation is complete). If the application of the second data table fragment is complete, set the edit state of the second data table fragment to editable, enabling full-text editability. If the application of the second data table fragment is not complete, continue executing steps S34a to S35a until all second data table fragments are applied.

[0155] Understandably, such as Figure 8As shown, the specific implementation process for processing offline operation data is as follows: S41b to S44b. S41b: Traverse the M offline operation data entries. S42b: Determine if the offline operation data is associated with the first data table fragment. If the offline operation data is not associated with the first data table fragment, then the offline operation is determined to be the second type of offline operation data, and step S43b is executed. If the offline operation data is associated with the first data table fragment, then the offline operation is determined to be the first type of offline operation data, and step S45b is executed to update the first data table fragment according to the first type of offline operation data (i.e., apply the offline operation data). S43b: Convert the second type of offline operation data into equivalent operation data and add the equivalent operation data to the queue to be executed. S44b: Determine if the M offline operation data entries have been traversed completely. If the M offline operation data entries have not been traversed completely, continue executing step S41b. If the M offline operation data entries have been traversed completely, then the current process ends.

[0156] Optional, such as Figure 9 As shown, the computer device may include a data state management service, a data layer, a fragment loading manager, and a rendering layer. The data state management service maintains the editing state of the data table. The fragment loading manager pulls data table fragments and applies them to the data layer, then transmits the data table fragments to the rendering layer for rendering. User operations are feature operations, such as grouping and sorting, which directly affect the data layer. This solution maintains the editing state of the original data table through the data state management service. The fragment loading manager can write the editing state of the original data table into the data state management service, while features obtain the editing state of the original data table (and data table fragments) through the data state management service to determine how to respond to user operations. For example, in response to an edit operation on the first data table segment, the computer device can obtain the edit status of the first data table segment from the state management service associated with the original data table; if the edit status of the first data table segment is editable, the edit operation is performed on the first data table segment; if the edit status of the first data table segment is disabled, the edit operation on the first data table segment is paused, thereby resolving the issue of the user's data operation range.

[0157] Understandably, taking a data table with 6.7k data points as an example, the comparison of editable time for users using the initial editable data scheme and the comparison scheme is shown in Table 8 below. Table 8 shows that in the comparison scheme, the data content in the table is only editable 1800ms after the data request begins, while in this scheme, the data content is editable within 550ms. It is evident that this scheme reduces the initial editable time of the data by 69% compared to the comparison scheme, and granting users editable permissions to the data table earlier improves the efficiency of data table editing.

[0158] Table 8

[0159]

[0160] In this application, after fragmenting the original data table to obtain the first data table fragment, the data types of the M offline operation data associated with the original data table are analyzed. Only when the data types of the M offline operation data are all local data types is the editing state of the first data table fragment set to editable based on the M offline operation data. This allows users to edit the first data table fragment without waiting for the original data table to be fragmented to obtain other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. Furthermore, the offline operation data of local data types here refers to offline operation data associated with a portion of the original data table fragments; that is, offline operation data of local data types refers to offline operation data that does not depend on any data table fragments of the original data table. In other words, the editing state of the first data table fragment is set to editable only when none of the M offline operation data depend on any data table fragments of the original data table. This avoids problems such as offline operation data being unusable or erroneous, ensuring the consistency of data content in the data table.

[0161] Please see Figure 10 This is a schematic diagram of a data table processing device provided in an embodiment of this application. The aforementioned data table processing device can be a computer program (including program code) running in a network device; for example, the data table processing device is an application software. This device can be used to execute the corresponding steps in the method provided in the embodiments of this application. Figure 10 As shown, the data table processing device may include: a sharding module 111, a display module 112, a setting module 113, a reading module 114, and an update module 115.

[0162] The sharding module is used to shard the original data table according to the display order of the original data content in the original data table;

[0163] The display module is used to display the first data table fragment on the data table display interface if the original data table is fragmented to obtain the first data table fragment, and to obtain the data types corresponding to the M offline operation data associated with the original data table, where M is a positive integer;

[0164] The setting module is used to set the editable state of the first data table fragment according to the M offline operation data if the data types of the M offline operation data are all local data types; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table;

[0165] The display module is further configured to, if the original data table is fragmented to obtain a second data table fragment, display the second data table fragment on the data table display interface including the first data table fragment; the display order of the original data content in the first data table fragment is prior to the display order of the original data content in the second data table fragment.

[0166] Optionally, the display module includes: an acquisition unit 50a and a determination unit 51a.

[0167] The acquisition unit is used to acquire the operation type of the offline operation corresponding to the offline operation data Mi; the offline operation data Mi belongs to M offline operation data, where i is a positive integer less than or equal to M;

[0168] The determining unit is configured to determine the association between the offline operation data Mi and the data table segment in the original data table based on the operation type of the offline operation corresponding to the offline operation data Mi; and to determine the data type of the offline operation data Mi based on the association between the offline operation data Mi and the data table segment in the original data table.

[0169] Optionally, the determining unit determines the data type of the offline operation data Mi based on the association between the offline operation data Mi and the data table fragments in the original data table, including:

[0170] If the offline operation data Mi is associated with the first data table segment of the original data table but not with the second data table segment of the original data table, then the data type of the offline operation data Mi is determined to be a local data type.

[0171] If the offline operation data Mi is associated with the second data table segment in the original data table, but not with the first data table segment in the original data table, then the data type of the offline operation data Mi is determined to be a local data type.

[0172] Optionally, the setup module includes traversal unit 60b, update unit 61b, and setup unit 62b:

[0173] The traversal unit is used to traverse the M offline operation data if the data types of the M offline operation data are all local data types.

[0174] The update unit is configured to update the original data content in the first data table segment according to the first type of offline operation data if the first type of offline operation data is encountered in the M offline operation data, thereby obtaining the first updated data content; the first type of offline operation data is offline operation data that is associated with the first data table segment but not associated with the second data table segment.

[0175] The setting unit is used to set the editing state of the first data table segment to a first type of editable state; the first updated data content in the first data table segment in the first type of editable state is allowed to be edited, and the first type of editable state belongs to the editable state.

[0176] Optionally, the setting unit sets the editing state of the first data table fragment to a first type of editable state, including:

[0177] If all M offline operation data are of the first type, and the original data content in the first data table fragment has been updated based on the M first type offline operation data, then the editing state of the first data table fragment is set to the first type editable state.

[0178] If a second type of offline operation data is encountered in the M offline operation data entries, and the original data content in the first data table fragment has been updated based on the first type of offline operation data, then the first equivalent operation data of the second type of offline operation data is determined based on the first type of offline operation data. The first equivalent operation data is added to the execution queue, and the editing status of the first data table fragment is set to the first type of editable status. The second type of offline operation data is offline operation data associated with the second data table fragment but not associated with the first data table fragment. The first equivalent operation data is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table should be updated.

[0179] Optionally, the setting unit determines the first equivalent operation data of the second type of offline operation data based on the first type of offline operation data, including:

[0180] Obtain the first generation time of the first type of offline operation data and the second generation time of the second type of offline operation data;

[0181] Determine the first offline operation corresponding to the first type of offline operation data, and the second offline operation corresponding to the second type of offline operation data;

[0182] Generate a first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation;

[0183] A first delayed execution condition for the first equivalent operation is generated, and the first delayed execution condition and the first equivalent operation are determined as the first equivalent operation data of the second type of offline operation data. The first delayed execution condition is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table is updated according to the first equivalent operation.

[0184] Optionally, the setting unit generates a first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation, including:

[0185] If the first generation time is later than the second generation time, then based on the first offline operation and the second offline operation, determine the first equivalent operation associated with the second type of offline operation data;

[0186] If the first generation time is earlier than the second generation time, then the second offline operation is determined as the first equivalent operation associated with the second type of offline operation data.

[0187] Optionally, if the data types of the M offline operation data are all local data types, the setting module sets the edit state of the first data table fragment to editable state based on the M offline operation data, including:

[0188] If the data types of the M offline operation data are all local data types, then traverse the M offline operation data;

[0189] If all M offline operation data are of the second type, then the second equivalent operation data corresponding to the M offline operation data is determined; the second type of offline operation data is offline operation data that is associated with the second data table fragment but not associated with the first data table fragment; the second equivalent operation data is used to indicate that the second data fragment is updated when the second data table fragment is displayed.

[0190] The second equivalent operation data is added to the queue to be executed, and the editing state of the first data table fragment is set to the second type of editable state; the original data content in the first data table fragment in the second type of editable state is allowed to be edited, and the second type of editable state belongs to the editable state.

[0191] Optionally, the setting module determines the second equivalent operation data corresponding to the M pieces of second-type offline operation data, including:

[0192] Determine the third generation time corresponding to each of the M second-type offline operation data, and the third offline operation corresponding to each of the M second-type offline operation data;

[0193] Determine the execution order of the M third offline operations based on the M third generation times;

[0194] A second delayed execution condition is generated, and the second delayed execution condition, the execution order, and the third offline operations corresponding to the M second-type offline operation data are determined as the second equivalent operation data corresponding to the M second-type offline operation data. The second delayed execution condition is used to indicate that when the second data table fragment is displayed, the second data table fragment is updated according to the execution order and the third offline operations corresponding to the M second-type offline operation data.

[0195] Optionally, the device may also include a reading module and an updating module:

[0196] The reading module is used to read the equivalent operation data associated with the second type of offline operation data from the queue to be executed if the second data table fragment has been displayed, and use it as the target equivalent operation data.

[0197] The update module is used to update the data content in the data table segment associated with the target equivalent operation data in the original data table according to the target equivalent operation data, so as to obtain the second updated data content;

[0198] The settings module is also used to set the editable state of the second data table fragment.

[0199] Optionally, the device further includes an execution module, configured to, in response to an edit operation concerning the first data table segment, obtain the edit status of the first data table segment from a data status management service associated with the original data table; and if the edit status of the first data table segment is editable, perform the edit operation on the first data table segment.

[0200] Optionally, the setting module is further configured to update the original data content of the first data table segment and the original data content of the second data table segment based on the M offline operation data if at least one of the M offline operation data has a global data type and the second data table segment has been displayed; if the original data content of both the first data table segment and the second data table segment has been updated, the editing status of both the first data table segment and the second data table segment is set to editable.

[0201] According to one embodiment of this application, Figure 4 The steps involved in the data table processing method shown can be derived from... Figure 10 The data processing unit shown in the diagram executes the operation through its various modules. For example, Figure 3 Step S101 shown can be performed by Figure 10 The sharding module 111 in the middle is used to execute, Figure 3 Steps S102 and S104 shown can be derived from Figure 10 The display module 112 in the middle is used to execute; Figure 3 Step S103 shown can be performed by Figure 10 The settings module 113 in the middle is used to execute.

[0202] According to one embodiment of this application, Figure 10 The modules in the data table processing device shown can be individually or entirely combined into one or more units, or some of these units can be further divided into at least two functionally smaller sub-units to achieve the same operation without affecting the technical effects of the embodiments of this application. The above modules are based on logical functional division. In practical applications, the function of one module can also be implemented by at least two units, or the function of at least two modules can be implemented by one unit. In other embodiments of this application, the data table processing device may also include other units. In practical applications, these functions can also be implemented with the assistance of other units, and can be implemented collaboratively by at least two units.

[0203] According to one embodiment of this application, the following can be executed by running on a general-purpose computer device, such as a computer, which includes processing components and storage components such as a central processing unit (CPU), random access memory (RAM), and read-only memory (ROM). Figure 4 and Figure 5 The computer program (including program code) for each step involved in the corresponding method shown, to construct such... Figure 10The data table processing apparatus shown herein, and the data table processing method for implementing the embodiments of this application, are described. The computer program described above may be recorded on, for example, a computer-readable recording medium, loaded onto the aforementioned computing device via the computer-readable recording medium, and run therein.

[0204] In this application, after fragmenting the original data table to obtain the first data table fragment, the data types of the M offline operation data associated with the original data table are analyzed. Only when the data types of the M offline operation data are all local data types is the editing state of the first data table fragment set to editable based on the M offline operation data. This allows users to edit the first data table fragment without waiting for the original data table to be fragmented to obtain other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. Furthermore, the offline operation data of local data types here refers to offline operation data associated with a portion of the original data table fragments; that is, offline operation data of local data types refers to offline operation data that does not depend on any data table fragments of the original data table. In other words, the editing state of the first data table fragment is set to editable only when none of the M offline operation data depend on any data table fragments of the original data table. This avoids problems such as offline operation data being unusable or erroneous, ensuring the consistency of data content in the data table.

[0205] Please see Figure 11 This is a schematic diagram of the structure of a computer device provided in an embodiment of this application. Figure 11 As shown, the computer device 1000 may include a processor 1001, a network interface 1004, and a memory 1005. Furthermore, the computer device 1000 may also include a user interface 1003 and at least one communication bus 1002. The communication bus 1002 is used to enable communication between these components. The user interface 1003 may include a display screen and a keyboard; optionally, the user interface 1003 may also include a standard wired interface or a wireless interface. The network interface 1004 may optionally include a standard wired interface or a wireless interface (such as a Wi-Fi interface). The memory 1005 may be high-speed RAM or non-volatile memory, such as at least one disk drive. Optionally, the memory 1005 may also be at least one storage device located remotely from the processor 1001. Figure 11 As shown, the memory 1005, which is a computer-readable storage medium, may include an operating system, a network communication module, a user interface module, and a device control application.

[0206] exist Figure 11 In the computer device 1000 shown, the network interface 1004 provides network communication functionality; the user interface 1003 is mainly used to provide an input interface; and the processor 1001 can be used to call the device control application stored in the memory 1005 to achieve:

[0207] The original data table is divided into segments according to the order in which the original data content is displayed in the original data table;

[0208] If the original data table is sharded to obtain a first data table fragment, then the first data table fragment is displayed on the data table display interface, and the data types corresponding to the M offline operation data associated with the original data table are obtained, where M is a positive integer;

[0209] If the data types of the M offline operation data are all local data types, then based on the M offline operation data, the edit status of the first data table fragment is set to editable; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table;

[0210] If the original data table is fragmented to obtain a second data table fragment, then the second data table fragment is displayed on the data table display interface that includes the first data table fragment; the display order of the original data content in the first data table fragment is before the display order of the original data content in the second data table fragment.

[0211] In this application, after fragmenting the original data table to obtain the first data table fragment, the data types of the M offline operation data associated with the original data table are analyzed. Only when the data types of the M offline operation data are all local data types is the editing state of the first data table fragment set to editable based on the M offline operation data. This allows users to edit the first data table fragment without waiting for the original data table to be fragmented to obtain other data table fragments (such as the second data table fragment), thus improving the efficiency of data table editing. Furthermore, the offline operation data of local data types here refers to offline operation data associated with a portion of the original data table fragments; that is, offline operation data of local data types refers to offline operation data that does not depend on any data table fragments of the original data table. In other words, the editing state of the first data table fragment is set to editable only when none of the M offline operation data depend on any data table fragments of the original data table. This avoids problems such as offline operation data being unusable or erroneous, ensuring the consistency of data content in the data table.

[0212] It should be understood that the computer device 1000 described in the embodiments of this application can perform the foregoing... Figure 5 and the preceding text Figure 4 The description of the data table processing method in the corresponding embodiments can also be implemented as described above. Figure 10 The description of the data table processing apparatus in the corresponding embodiments will not be repeated here. Furthermore, the beneficial effects of using the same method will also not be repeated.

[0213] Furthermore, it should be noted that this application embodiment also provides a computer-readable storage medium, which stores a computer program executed by the aforementioned data table processing device. The computer program includes program instructions, and when the processor executes the program instructions, it can execute the aforementioned... Figure 5 and the preceding text Figure 4 The description of the data table processing method in the corresponding embodiments will not be repeated here. Furthermore, the beneficial effects of using the same method will also not be repeated. For technical details not disclosed in the computer-readable storage medium embodiments related to this application, please refer to the description of the method embodiments of this application.

[0214] As an example, the above program instructions can be deployed and executed on a single computer device, or deployed and executed on at least two computer devices at a single location, or executed on at least two computer devices distributed across at least two locations and interconnected via a communication network. At least two computer devices distributed across at least two locations and interconnected via a communication network can form a blockchain network.

[0215] The aforementioned computer-readable storage medium can be a data table processing apparatus provided in any of the foregoing embodiments or a central storage unit of the aforementioned computer device, such as a hard disk or central storage of the computer device. The computer-readable storage medium can also be an external storage device of the computer device, such as a plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, etc., provided on the computer device. Furthermore, the computer-readable storage medium may include both the central storage unit and external storage devices of the computer device. The computer-readable storage medium is used to store the computer program and other programs and data required by the computer device. The computer-readable storage medium can also be used to temporarily store data that has been output or will be output.

[0216] The terms "first," "second," etc., in the specification, claims, and drawings of this application are used to distinguish content in different media, rather than to describe a specific order. Furthermore, the term "comprising," and any variations thereof, are intended to cover non-exclusive inclusion. For example, a process, method, apparatus, product, or device that includes a series of steps or units is not limited to the listed steps or modules, but may optionally include steps or modules not listed, or may optionally include other step units inherent to these processes, methods, apparatuses, products, or devices.

[0217] This application also provides a computer program product, including a computer program / instructions, which, when executed by a processor, implement the foregoing description. Figure 3 and Figure 5 The description of the data table processing method in the corresponding embodiments will not be repeated here. Furthermore, the beneficial effects of using the same method will also not be repeated. For technical details not disclosed in the embodiments of the computer program product involved in this application, please refer to the description of the method embodiments of this application.

[0218] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this application.

[0219] The methods and related apparatus provided in this application are described with reference to the method flowcharts and / or structural diagrams provided in this application. Specifically, each block of the method flowchart and / or structural diagram, as well as combinations of blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable network-connected device to generate a machine, such that the instructions executable by the processor of the computer or other programmable network-connected device produce instructions for implementing the process. Figure 1 A flowchart or multiple flowcharts and / or structural diagrams Figure 1 The means for the functions specified in one or more boxes. These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable network-connected device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means implemented in a process. Figure 1 A flowchart or multiple flowcharts and / or structural diagrams Figure 1 The functions specified in one or more boxes. These computer program instructions may also be loaded onto a computer or other programmable network-connected device to cause a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable device for implementing the process. Figure 1 A flowchart or a structure diagram showing the steps of the function specified in one or more boxes.

[0220] The above-disclosed embodiments are merely preferred embodiments of this application and should not be construed as limiting the scope of this application. Therefore, any equivalent variations made in accordance with the claims of this application shall still fall within the scope of this application.

Claims

1. A data table processing method, characterized in that, include: The original data table is divided into segments according to the order in which the original data content is displayed in the original data table; If the original data table is sharded to obtain a first data table fragment, then the first data table fragment is displayed on the data table display interface, and the data types corresponding to the M offline operation data associated with the original data table are obtained, where M is a positive integer; If the data types of the M offline operation data are all local data types, then based on the M offline operation data, the edit status of the first data table fragment is set to editable; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table; If the original data table is fragmented to obtain a second data table fragment, then the second data table fragment is displayed on the data table display interface that includes the first data table fragment; the display order of the original data content in the first data table fragment is before the display order of the original data content in the second data table fragment.

2. The method as described in claim 1, characterized in that, The step of obtaining the data types corresponding to the M offline operation data associated with the original data table includes: Obtain the operation type of the offline operation corresponding to the offline operation data Mi; the offline operation data Mi belongs to M offline operation data, where i is a positive integer less than or equal to M; Based on the operation type of the offline operation corresponding to the offline operation data Mi, determine the association relationship between the offline operation data Mi and the data table fragment in the original data table; The data type of the offline operation data Mi is determined based on the association between the offline operation data Mi and the data table fragments in the original data table.

3. The method as described in claim 2, characterized in that, The step of determining the data type of the offline operation data Mi based on the association relationship between the offline operation data Mi and the data table fragments in the original data table includes: If the offline operation data Mi is associated with the first data table segment of the original data table but not with the second data table segment of the original data table, then the data type of the offline operation data Mi is determined to be a local data type. If the offline operation data Mi is associated with the second data table segment in the original data table, but not with the first data table segment in the original data table, then the data type of the offline operation data Mi is determined to be a local data type.

4. The method as described in claim 1, characterized in that, If the data types of the M offline operation data are all local data types, then based on the M offline operation data, the edit state of the first data table fragment is set to editable state, including: If the data types of the M offline operation data are all local data types, then traverse the M offline operation data; If the first type of offline operation data is found in the M offline operation data, the original data content in the first data table segment is updated according to the first type of offline operation data to obtain the first updated data content; the first type of offline operation data is offline operation data that is associated with the first data table segment but not associated with the second data table segment. Set the editing state of the first data table fragment to a first type of editable state; the first updated data content in the first data table fragment in the first type of editable state is allowed to be edited, and the first type of editable state belongs to the editable state.

5. The method as described in claim 4, characterized in that, Setting the editing state of the first data table fragment to the first type of editable state includes: If all M offline operation data are of the first type, and the original data content in the first data table fragment has been updated based on the M first type offline operation data, then the editing state of the first data table fragment is set to the first type editable state. If a second type of offline operation data is encountered in the M offline operation data entries, and the original data content in the first data table fragment has been updated based on the first type of offline operation data, then the first equivalent operation data of the second type of offline operation data is determined based on the first type of offline operation data. The first equivalent operation data is added to the execution queue, and the editing status of the first data table fragment is set to the first type of editable status. The second type of offline operation data is offline operation data associated with the second data table fragment but not associated with the first data table fragment. The first equivalent operation data is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table should be updated.

6. The method as described in claim 5, characterized in that, The step of determining the first equivalent operation data of the second type of offline operation data based on the first type of offline operation data includes: Obtain the first generation time of the first type of offline operation data and the second generation time of the second type of offline operation data; Determine the first offline operation corresponding to the first type of offline operation data, and the second offline operation corresponding to the second type of offline operation data; Generate a first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation; A first delayed execution condition for the first equivalent operation is generated, and the first delayed execution condition and the first equivalent operation are determined as the first equivalent operation data of the second type of offline operation data. The first delayed execution condition is used to indicate that when the second data table fragment is displayed, the data table fragment associated with the first equivalent operation data in the original data table is updated according to the first equivalent operation.

7. The method as described in claim 6, characterized in that, The step of generating the first equivalent operation associated with the second type of offline operation data based on the first generation time, the second generation time, the first offline operation, and the second offline operation includes: If the first generation time is later than the second generation time, then based on the first offline operation and the second offline operation, determine the first equivalent operation associated with the second type of offline operation data; If the first generation time is earlier than the second generation time, then the second offline operation is determined as the first equivalent operation associated with the second type of offline operation data.

8. The method as described in claim 1, characterized in that, If the data types of the M offline operation data are all local data types, then based on the M offline operation data, the edit state of the first data table fragment is set to editable state, including: If the data types of the M offline operation data are all local data types, then traverse the M offline operation data; If all M offline operation data are of the second type, then the second equivalent operation data corresponding to the M offline operation data is determined; the second type of offline operation data is offline operation data associated with the second data table fragment and not associated with the first data table fragment; the second equivalent operation data is used to indicate that the second data table fragment is updated when the display of the second data table fragment is completed. The second equivalent operation data is added to the queue to be executed, and the editing state of the first data table fragment is set to the second type of editable state; the original data content in the first data table fragment in the second type of editable state is allowed to be edited, and the second type of editable state belongs to the editable state.

9. The method as described in claim 8, characterized in that, The determination of the second equivalent operation data corresponding to the M pieces of second-type offline operation data includes: Determine the third generation time corresponding to each of the M second-type offline operation data, and the third offline operation corresponding to each of the M second-type offline operation data; Determine the execution order of the M third offline operations based on the M third generation times; A second delayed execution condition is generated, and the second delayed execution condition, the execution order, and the third offline operations corresponding to the M second-type offline operation data are determined as the second equivalent operation data corresponding to the M second-type offline operation data. The second delayed execution condition is used to indicate that when the second data table fragment is displayed, the second data table fragment is updated according to the execution order and the third offline operations corresponding to the M second-type offline operation data.

10. The method as described in claim 5 or 8, characterized in that, The method further includes: If the second data table fragment has been displayed, then the equivalent operation data associated with the second type of offline operation data is read from the queue to be executed, and used as the target equivalent operation data; Based on the target equivalent operation data, the data content in the data table segment associated with the target equivalent operation data in the original data table is updated to obtain the second updated data content; Set the edit status of the second data table fragment to editable.

11. The method as described in claim 1, characterized in that, The method further includes: In response to an edit operation on the first data table fragment, the edit status of the first data table fragment is obtained from the data status management service associated with the original data table; If the first data table segment is in an editable state, then the editing operation is performed on the first data table segment.

12. The method as described in claim 1, characterized in that, The method further includes: If at least one of the M offline operation data is of a global data type, and the second data table fragment has been fully displayed, then the original data content of the first data table fragment and the original data content of the second data table fragment are updated according to the M offline operation data. If the original data content of both the first data table segment and the second data table segment has been updated, then the edit status of both the first data table segment and the second data table segment will be set to editable.

13. A data table processing device, characterized in that, include: The sharding module is used to shard the original data table according to the display order of the original data content in the original data table; The display module is used to display the first data table fragment on the data table display interface if the original data table is fragmented to obtain the first data table fragment, and to obtain the data types corresponding to the M offline operation data associated with the original data table, where M is a positive integer; The setting module is used to set the editable state of the first data table fragment according to the M offline operation data if the data types of the M offline operation data are all local data types; the first data table fragment in the editable state is allowed to be edited, and the offline operation data of the local data type is the offline operation data associated with a part of the data table fragment in the original data table; The display module is further configured to, if the original data table is fragmented to obtain a second data table fragment, display the second data table fragment on the data table display interface including the first data table fragment; the display order of the original data content in the first data table fragment is prior to the display order of the original data content in the second data table fragment.

14. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 12.

15. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 12.

16. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 12.

Images