Data processing method, device, electronic device and readable storage medium

Abstract

The present application discloses a data processing method, apparatus, electronic device, and readable storage medium, belonging to the field of data processing technology. The method comprises: upon receiving a first input from a user regarding first data in a file, determining second data associated with the first data in the file and performing a first operation corresponding to the first input; and, if the first operation only includes updating the first data and the second data is updated, restoring the updated second data to the pre-update second data.

Description

Technical Field

[0001] The present application belongs to the field of data processing technology, and specifically relates to a data processing method, device, electronic device and readable storage medium. Background Art

[0002] Currently, when users edit table data on electronic devices, when they trigger the electronic device to delete or filter part of the data in a table, some data associated with that part of the data may change. To ensure the accuracy of the data in the table and prevent that data from being affected by the operation, users are usually required to manually verify the data or add complex formulas or data validation rules to the table.

[0003] However, according to the above method, when the amount of data in a table is large, the efficiency of data verification is low if the user verifies the data one by one or verifies the data by adding complex formulas or data validation rules. Summary of the Invention

[0004] The purpose of the embodiments of the present application is to provide a data processing method, device, electronic device and readable storage medium, which can solve the problem of low efficiency of data verification.

[0005] In a first aspect, an embodiment of the present application provides a data processing method, which includes: upon receiving a first input from a user regarding first data in a file, determining second data associated with the first data in the file, and performing a first operation corresponding to the first input; when the first operation only includes updating the first data and the second data is updated, restoring the updated second data to the second data before the update.

[0006] In second aspect, an embodiment of the present application provides a data processing device, which includes a processing module and a recovery module; the processing module is used to determine the second data associated with the first data in the file and perform a first operation corresponding to the first input when receiving a first input from a user to the first data in the file; the recovery module is used to restore the updated second data to the second data before the update when the first operation only includes updating the first data and the second data is updated.

[0007] In a third aspect, an embodiment of the present application provides an electronic device comprising a processor and a memory, wherein the memory stores programs or instructions that can be run on the processor, and when the programs or instructions are executed by the processor, the steps of the method described in the first aspect are implemented.

[0008] In a fourth aspect, an embodiment of the present application provides a readable storage medium, on which a program or instruction is stored. When the program or instruction is executed by a processor, the steps of the method described in the first aspect are implemented.

[0009] In a fifth aspect, an embodiment of the present application provides a chip, which includes a processor and a communication interface, the communication interface and the processor are coupled, and the processor is used to run programs or instructions to implement the method described in the first aspect.

[0010] In a sixth aspect, an embodiment of the present application provides a computer program product, which is stored in a storage medium and executed by at least one processor to implement the method described in the first aspect.

[0011] In an embodiment of the present application, when a user inputs a first data in a file, the second data associated with the first data in the file can be determined, and a first operation corresponding to the first input can be performed; and when the first operation only includes updating the first data, and the second data is updated, the updated second data can be restored to the second data before the update. Through this solution, since when a first operation is performed on the first data in the file, if the first operation does not require updating the second data associated with the first data in the file, and the second data has been updated, the second data can be directly restored to the data before the update. Therefore, there is no need for manual data verification by the user, or data verification by adding complex formulas or data validation rules to the file, thereby improving the efficiency of data verification. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 This is one of the flow charts of the data processing method provided in the embodiment of the present application;

[0013] Figure 2 This is the second flow chart of the data processing method provided in the embodiment of the present application;

[0014] Figure 3 This is the third flow chart of the data processing method provided in the embodiment of the present application;

[0015] Figure 4 This is the fourth flow chart of the data processing method provided in the embodiment of the present application;

[0016] Figure 5 This is the fifth flow chart of the data processing method provided in the embodiment of the present application;

[0017] Figure 6 This is the sixth flow chart of the data processing method provided in the embodiment of the present application;

[0018] Figure 7This is the seventh flow chart of the data processing method provided in the embodiment of the present application;

[0019] Figure 8 This is one of the schematic diagrams of the data processing device provided in the embodiment of the present application;

[0020] Figure 9 This is the second schematic diagram of the data processing device provided in the embodiment of the present application;

[0021] Figure 10 This is the third schematic diagram of the data processing device provided in the embodiment of the present application;

[0022] Figure 11 This is the fourth schematic diagram of the data processing device provided in an embodiment of the present application;

[0023] Figure 12 is a schematic diagram of an electronic device provided in an embodiment of the present application;

[0024] Figure 13 This is a hardware diagram of the electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0025] The following will be combined with the accompanying drawings in the embodiments of the present application to clearly describe the technical solutions in the embodiments of the present application. Obviously, the embodiments described are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field are within the scope of protection of this application.

[0026] The terms "first," "second," and the like in the specification and claims of this application are used to distinguish similar objects, and are not used to describe a specific order or precedence. It should be understood that the terms used in this manner are interchangeable where appropriate, so that the embodiments of this application can be implemented in an order other than that illustrated or described herein, and that the objects distinguished by "first," "second," and the like are generally of the same type, and do not limit the number of objects; for example, the first object can be one or more. In addition, the term "and / or" in the specification and claims represents at least one of the connected objects, and the character " / " generally indicates that the objects associated with each other are in an "or" relationship.

[0027] The term "indication" in this application can be either a direct indication (or explicit indication) or an indirect indication (or implicit indication). A direct indication can be understood as the sender explicitly informing the receiver of specific information, the operation to be performed, or the requested result, etc. in the instruction sent; an indirect indication can be understood as the receiver determining the corresponding information based on the instruction sent by the sender, or making a judgment and determining the operation to be performed or the requested result, etc. based on the judgment result.

[0028] The terms "at least one" and "at least one of" in the specification and claims of this application refer to any one, any two, or a combination of more than two of the objects included. For example, at least one of a, b, and c can be represented by: "a", "b", "c", "a and b", "a and c", "b and c", and "a, b, and c", where a, b, and c can be single or multiple. Similarly, "at least two" means two or more, and its meaning is similar to "at least one".

[0029] The data processing method, device, electronic device, and readable storage medium provided in the embodiments of the present application are described in detail below with reference to specific embodiments and their application scenarios in conjunction with the accompanying drawings.

[0030] Currently, when users edit or verify data in a table file (i.e., a data set consisting of rows and columns, commonly used for storing, displaying, and processing data) on an electronic device, it is often the case that the user's operation on a part of the table file causes errors or inconsistencies in other parts of the table file, such as the following scenario:

[0031] (1) Inserting or deleting a row of data in a spreadsheet file may cause errors in formula calculation results or data summary totals. Since formula calculations and data summary are often based on the data in the entire spreadsheet file, inserting or deleting a row of data may change the calculation results of other parts of the data, resulting in data inconsistency.

[0032] (2) When filtering part of the data in a table file, dragging subsequent rows / columns according to the pattern of the explicit data automatically generates a similar pattern, resulting in changes in the implicit data (i.e., data that is not directly displayed in the table file and is associated with the explicit data, such as the results of formula calculations, the total number of data summaries, etc.). If the user does not discover the error in time and performs multiple operations, the final result may contain multiple errors that need to be quickly located and corrected; for example, the user filters part of the data in the table, and then drags subsequent rows or columns according to a certain pattern, so that the data in the table is automatically updated. However, this operation may affect other parts of the data, and the user may not be able to discover and correct the error in time.

[0033] For example, when filtering partial data in a spreadsheet file, there are the following problems: 1. The influence of the formula drop-down operation is greater when the entire column is inconsistent; 2. The data operation itself is non-continuous. For example, a user can use the formula drop-down operation to filter the data of the employees with performance scores of S and A in Table 1 below;

[0034] Table 1

[0035] Work Number Name department group Dimension 1 Dimension 2 Dimension 3 Total score Performance 00001 User 1 Department 1 Group 1 70 82 77 75.55 B 00002 User 2 Department 1 Group 2 75 70 80 77 B 00003 User 3 Department 1 Group 3 83 80 90 84.3 A 00004 User 4 Department 1 Group 4 69 70 80 75.15 B 00005 User 5 Department 1 Group 5 54 50 60 59.4 C 00006 User 6 Department 2 Group 6 70 77 83 78.45 B 00007 User 7 Department 2 Group 7 85 90 95 91.5 S 00008 User 8 Department 3 Group 8 56 55 60 55.85 C 00009 User 9 Department 4 Group 9 90 92 96 94.15 S 00010 User 10 Department 5 Group 10 83 80 80 81.55 A

[0036] The filtered data are shown in Table 2 below:

[0037] Table 2

[0038] 1 Work Number Name department group Dimension 1 Dimension 2 Dimension 3 Total score Performance 4 00003 User 3 Department 1 Group 3 83 80 90 84.3 A 8 00007 User 7 Department 2 Group 7 85 90 95 91.5 S 10 00009 User 9 Department 4 Group 9 90 92 96 94.15 S 11 00010 User 10 Department 5 Group 10 83 80 80 81.55 A

[0039] However, if the user makes an error, the results after selecting all and pulling down are as shown in Table 3 below:

[0040] Table 3

[0041]

[0042]

[0043] If the data affected by the above erroneous operation is explicit data, the user can easily identify the data error and perform a rollback operation to re-filter. However, for implicit data that was not filtered, some data may be modified while others remain unchanged. Especially when the spreadsheet file contains a large amount of data and the operations are complex, if the user does not discover the data error in time and performs multiple operations, it will be difficult to handle and locate the update problem, and usually the only option is to rework and re-perform the operation in the source file.

[0044] Existing methods for editing or verifying spreadsheet files generally require users to manually check and verify data, or add complex formulas or data validation rules to the spreadsheet to ensure data accuracy and consistency. However, this method has the following drawbacks:

[0045] (1) Complex operation: users need to manually check and verify data, or set complex formulas and data validation rules. The operation process is tedious, complex, and prone to errors.

[0046] (2) Inefficiency: Since users need to manually check and verify data, or set complex formulas and data validation rules, the operation efficiency is low;

[0047] (3) It is difficult to meet diverse needs; different users have different needs for table data editing or verification, and existing table editing or verification methods often cannot meet the needs of different users.

[0048] (4) Difficulty in discovering and correcting errors: When users perform operations on a part of the data, errors or inconsistencies may occur in other parts of the data, and existing table editing or verification methods often make it difficult to discover and correct errors in a timely manner.

[0049] The above problems often make the user's data editing or verification process complicated and inefficient, and also reduce the accuracy and consistency of the data.

[0050] In order to solve the above problems, the embodiments of the present application provide a data processing method, device, electronic device and readable storage medium. The data processing method provided by the embodiments of the present application can be applied in scenarios where users operate on part of the data in a table file.

[0051] In the data method provided in the embodiment of the present application, when a user inputs a first data in a table file, the second data associated with the first data in the table file can be determined, and a first operation corresponding to the first input can be performed; and when the first operation only includes updating the first data, and the second data is updated, the updated second data can be restored to the second data before the update. Through this solution, since when a first operation is performed on the first data in the table file, if the first operation does not require updating the second data associated with the first data in the table file, and the second data has been updated, the second data can be directly restored to the data before the update, so there is no need for manual data verification by the user, or by adding complex formulas or data validation rules to the table file for data verification, thereby improving the efficiency of data verification.

[0052] It should be noted that the data processing methods provided in the embodiments of the present application can be executed by a data processing device, an electronic device, or a functional module in an electronic device, etc. In some embodiments of the present application, the data processing methods provided in the embodiments of the present application are described by taking an electronic device executing the data processing method as an example.

[0053] Figure 1 FIG. 1 is a flow chart showing a data processing method provided in an embodiment of the present application. Figure 1 As shown, the data processing method provided in the embodiment of the present application may include the following steps 101 and 102.

[0054] Step 101: Upon receiving a first input from a user regarding first data in a file, the electronic device determines second data associated with the first data in the file and performs a first operation corresponding to the first input.

[0055] Optionally, in an embodiment of the present application, the above-mentioned file may be any possible file such as a table file or a document file including a table.

[0056] In the embodiment of the present application, the first input is used to perform the first operation.

[0057] Optionally, in the embodiment of the present application, the first input may be any possible form of input such as touch input, hover input or voice input.

[0058] For example, taking the above-mentioned first input as a touch input as an example, the first input may be a sliding input or a double-click input.

[0059] Optionally, in an embodiment of the present application, the first operation may be a screening operation, a deletion operation, an insertion operation, or the like.

[0060] Optionally, in an embodiment of the present application, the first operation may update the first data.

[0061] Optionally, in an embodiment of the present application, the second data may be: data having a formula calculation association relationship with the first data, or data having a data aggregation association relationship with the first data, etc.

[0062] For example, taking the above-mentioned second data as data having a formula calculation association relationship with the above-mentioned first data as an example, assuming that the first data is the first a columns of data in the Ath row in a spreadsheet file (i.e. the above-mentioned file), and the data in the Ath row is applied with a summation formula, then the second data can be the data after the ath column data in the Ath row, where A and a are both positive integers; it can be seen that the second data has a summation formula calculation association relationship with the first data.

[0063] Optionally, in an embodiment of the present application, after determining the second data, the electronic device may display a mark in the file, where the mark is used to remind the user that editing or verifying the file may affect other parts of the data.

[0064] Optionally, in an embodiment of the present application, the mark may be displayed at any possible location, such as the edge of the file, a corner of a cell in the file, or below a cell in the file.

[0065] Optionally, in an embodiment of the present application, the above-mentioned mark can be a text mark, a color mark or an image mark, etc.

[0066] For example, assuming that the above file is a table file, when the electronic device recognizes that the user has opened the table file and is in the non-select all mode during filtering, the electronic device can scan the entire table file and then add a supplementary operation feature to the row number selected by the first input:

[0067] (Operation 1, update row numbers: a / c / f / i) - as the result of the explicit operation (i.e. the first data above), a virtual is built in and marked in the corresponding row in order;

[0068] (Operation 1, row numbers cannot be updated: b / d / e / g / h) - Contrary to the result of explicit operations, the built-in operation here is NULL;

[0069] Similarly, when corresponding to operations 2, 3, ... N, the electronic device can automatically record and match the associated operations and embed them into the corresponding row features to facilitate determination of the above-mentioned second data.

[0070] Optionally, in the embodiment of the present application, Figure 1 ,like Figure 2 As shown, the above step 101 can be specifically implemented through the following step 101a.

[0071] Step 101a: When receiving a first input from a user regarding first data in a file, the electronic device determines second data based on the first information and performs a first operation corresponding to the first input.

[0072] The first information includes any of the following:

[0073] Input position information of the first input and operation type information of the first operation, the first operation being determined based on the first input;

[0074] The relationship information between the data in the above files.

[0075] Optionally, in an embodiment of the present application, after receiving the above-mentioned first input, the electronic device may first determine the above-mentioned first operation corresponding to the first input, then determine a data range based on the input position information of the first input, and finally determine the above-mentioned second data within the data range that may be affected by the above-mentioned first operation based on the operation type information of the first operation.

[0076] Optionally, in an embodiment of the present application, if the above-mentioned file is a table file, the above-mentioned association relationship information may indicate the dependency relationship between different cells in the table file.

[0077] Optionally, in an embodiment of the present application, the dependencies between the different cells can be analyzed using a dependency analysis algorithm. For example, the electronic device can automatically analyze dependencies calculated by formulas, dependencies of data aggregation, etc. using a dependency analysis algorithm in the background to determine whether the first operation will affect related data, and thus determine the second data.

[0078] It should be noted that the above dependency analysis algorithm can determine whether the user's operation will affect other parts of the data by analyzing the dependency between different cells in the table; the dependency analysis algorithm can traverse all cells in the table through recursive calls and establish a dependency graph between cells. For example, for the dependency of formula calculation, the dependency analysis algorithm can determine the cells that the formula calculation depends on by parsing the cell references in the formula; for the dependency of data aggregation, the dependency analysis algorithm can determine the cells that the aggregation depends on by analyzing the method and scope of data aggregation. Specifically, the following steps can be adopted:

[0079] 1. Traverse all cells in the table and build a dependency graph between cells;

[0080] 2. Analyze user operations, such as inserting or deleting a row of data, or filtering some data, to predict user operation intentions;

[0081] 3. Based on the dependency graph between cells and the user's operation intention, determine whether the user's operation requires updating related data;

[0082] 4. If the relevant data needs to be updated, the data will be automatically updated and the update time stamp will be added; if the relevant data does not need to be updated, the user's operation will be automatically saved and the data in the table will be updated.

[0083] In an embodiment of the present application, since the electronic device can determine the above-mentioned second data based on the input position information of the first input and the operation type information of the above-mentioned first operation, or based on the association relationship information between the data in the above-mentioned file when receiving the user's first input of the above-mentioned first data, the accuracy of determining the second data can be improved.

[0084] Step 102: When the first operation only includes updating the first data and the second data is updated, the electronic device restores the updated second data to the second data before the update.

[0085] Optionally, in an embodiment of the present application, the first operation only includes updating the first data, that is, the first operation will not update any data (including the second data) in the file other than the first data.

[0086] Optionally, in an embodiment of the present application, before the above step 102, the electronic device may first determine whether the above first operation only includes updating the above first data, and determine whether the above second data has been updated.

[0087] The specific method for the electronic device to determine whether the above-mentioned first operation only includes updating the above-mentioned first data, and the specific method for determining whether the above-mentioned second data has been updated will be described in detail in the following embodiments. In order to avoid repetition, they will not be described here.

[0088] In the embodiment of the present application, the updated second data is restored to the second data before the update in order to ensure that the second data is not affected by the first operation, that is, to keep the second data unchanged.

[0089] Optionally, in an embodiment of the present application, the electronic device may automatically restore the updated second data to the second data before the update, or may be triggered by user input to restore the updated second data to the second data before the update.

[0090] Optionally, in an embodiment of the present application, after restoring the updated second data to the second data before the update, the electronic device may scan the data in the entire file again to detect data errors therein.

[0091] Optionally, in the embodiment of the present application, Figure 1 ,like Figure 3 As shown, the above step 102 can be specifically implemented through the following steps 102a and 102b.

[0092] Step 102a: When the first operation only includes updating the first data and the second data is updated, the electronic device cancels the association between the first data and the second data.

[0093] Optionally, in an embodiment of the present application, the electronic device can establish an association relationship between the first data and the second data by establishing a link data influence matrix between the first data and the second data; and can cancel the association relationship by deleting the link data influence matrix.

[0094] Optionally, in an embodiment of the present application, the electronic device can establish a data microarray rule, automatically identify the non-draggable data in the above-mentioned file, and freeze the current data so that it cannot be updated. The original matrix data is identified and then the frozen data is established; for example, assuming that the file is the above-mentioned Table 1, then the electronic device can establish the first 5 columns of data of the module segmentation matrix on the left as the corresponding dependency binding relationship result, and the first column is a unique identification number ID (i.e., a mandatory unchangeable column). The reason for setting a unique mandatory unchangeable column is to be able to match back to the frozen segmentation module matrix again through the unique identification number when the frozen data is misoperated later; if the original data, excluding the first row of the title row, has a total of M*N rows of data, then:

[0095] operate

[0096] The corresponding values ​​in the Operation A matrix represent the behavior of this operation. Each operation corresponds to a matrix, such as Operation A matrix, Operation B matrix, and so on, to the final operation matrix. The first five columns of these matrices are frozen dependencies in the backend and remain unchanged. The following columns can be bound to the automatic calculation mode using corresponding calculation rules to prevent rapid recovery if the corresponding invisible operation is modified.

[0097] Step 102b: The electronic device restores the updated second data to the second data before the update.

[0098] For other descriptions of the embodiments of the present application, please refer to the relevant descriptions in the above embodiments. In order to avoid repetition, they will not be repeated here.

[0099] In an embodiment of the present application, since the electronic device can first cancel the association between the above-mentioned first data and the above-mentioned second data, and then restore the updated second data to the second data before the update, it can be ensured that the first data will not be affected when the second data is restored, thereby improving the accuracy of data processing.

[0100] Optionally, in the embodiment of the present application, Figure 1 ,like Figure 4 As shown, the above step 102 can be specifically implemented through the following steps 102c and 102d.

[0101] Step 102c: When the first operation only includes updating the first data and the second data is updated, the electronic device displays the first control.

[0102] The first control is used to prompt that the second data has been updated.

[0103] Optionally, in the embodiment of the present application, the first control may be a prompt box control or a mark control.

[0104] Optionally, in the embodiment of the present application, the display parameter of the first control may be any display parameter.

[0105] Optionally, in an embodiment of the present application, the above-mentioned display parameters may include at least one of the following: display color, display size, display shape, display transparency, etc.

[0106] Optionally, in an embodiment of the present application, the first control may be displayed floating above the file.

[0107] Optionally, in an embodiment of the present application, the first control may prompt the user that the second data has been updated, and the user should pay attention to maintaining the integrity and consistency of the data.

[0108] It should be noted that, in actual implementation, the electronic device can also remind the user that the second data has been updated through vibration or voice prompts, and pay attention to maintaining the integrity and consistency of the data, without being limited to the first control.

[0109] Step 102d: When receiving the second input from the user to the first control, the electronic device restores the updated second data to the second data before the update.

[0110] In the embodiment of the present application, the second input is used to perform a recovery operation on the updated second data.

[0111] Optionally, in the embodiment of the present application, the second input may be any possible form of input such as touch input, hover input or voice input.

[0112] For example, taking the second input as a touch input, the second input may be a single-click input or a long-press input of the first control.

[0113] In an embodiment of the present application, since the above-mentioned first operation only includes updating the first data, and the second data is updated, the electronic device can display a first control for prompting that the second data has been updated, and trigger data recovery of the second data through user input to the first control. Therefore, on the one hand, the first control can be used to remind the user to pay attention to the integrity and consistency of the data to enrich the reminder function in data processing; on the other hand, the second data can be restored with the user's confirmation, thereby improving the flexibility of recovering the second data.

[0114] Optionally, in an embodiment of the present application, if the electronic device fails to determine the above-mentioned second data, it can automatically save the above-mentioned first operation and update the data in the above-mentioned file; then the electronic device can automatically identify the unique identification number in the file, such as the work number in the above-mentioned Table 1, and according to the unique identification number in the original file and the finally saved file, on other feature contents (i.e., frozen and non-adjustable content), detect again whether there are any abnormalities, for example, whether there are multiple lines of repeated work numbers, whether the work number does not match other immutable features such as the name, etc.; if there is an abnormality, execute the above-mentioned steps 101 and 102 again.

[0115] Optionally, in the embodiment of the present application, in order to avoid the problem of too much operation content and untimely update and recovery, multiple scanning checks can be added to timely detect problems; specifically including: (1) scheduled update: the background can automatically update the relevant data regularly or regularly, and add an "update time" mark; for example, automatically update the data every once in a while or when the user is idle, and add a corresponding mark in the cell to remind the user that the data has been updated; (2) data version control: even if the corresponding version is closed, the background can automatically use data version control to record different versions of data and change history, so that the user can perform data rollback and recovery operations when needed. Every time the data is updated, the background can record the corresponding version number and update time, and add a corresponding mark in the cell to remind the user that the data has been updated.

[0116] In the data processing method provided in the embodiment of the present application, since when a first operation is performed on the first data in a file, if the first operation does not require updating the second data associated with the first data in the file, and the second data has been updated, the second data can be directly restored to the data before the update. Therefore, there is no need for manual data verification by the user, or data verification by adding complex formulas or data validation rules to the file, thereby improving the efficiency of data verification.

[0117] The specific method for the electronic device to determine whether the second data has been updated is described in detail below.

[0118] Optionally, in the embodiment of the present application, Figure 1 ,like Figure 5 As shown, after the above step 101, the data processing method provided in the embodiment of the present application may further include the following steps 103 to 105.

[0119] Step 103: The electronic device obtains a first matrix corresponding to the second data.

[0120] Optionally, in an embodiment of the present application, the electronic device may store the second data as the first matrix according to the position of the second data in the file.

[0121] For example, assuming that the above file is a table file, the electronic device can automatically detect whether there is an implicit row number operation, that is, the operation does not directly involve the change of the row number, but will affect the implicit row number. After executing the above first operation, a new implicit data feature matrix column B1 (that is, the above first matrix) is obtained.

[0122] Step 104: The electronic device compares the first matrix and the second matrix.

[0123] The second matrix is ​​a matrix corresponding to the second data stored before performing the first operation.

[0124] For example, assuming that the above file is a table file, the electronic device can detect the incomplete / discontinuous row number differences in the table file, and implicitly store the current implicit partial data feature matrix column B2 (ie the above second matrix) and perform detection and storage.

[0125] Step 105: The electronic device determines whether the second data is updated based on the comparison result of the first matrix and the second matrix.

[0126] Optionally, in an embodiment of the present application, if the comparison result is that the first matrix and the second matrix are the same, it can be determined that the second data has not been updated.

[0127] Optionally, in an embodiment of the present application, if the comparison result is that the first matrix and the second matrix are different, it can be determined that the second data has been updated.

[0128] Optionally, in the embodiment of the present application, if the electronic device determines that the second data has been updated, a split operation may be performed; specifically, the process of the split operation is as follows:

[0129] (1) Splitting explicit and implicit operations: Obtain the microarray matrix T1 corresponding to the above file before the first operation (the T1 can be the result after microarray data processing), and then split the first operation into explicit part matrix and implicit part matrix. This splitting is based on the display results of each specific step of the operation. After the user screens and scans the explicit operation interface, the part A1 of the explicit feature in the original data microarray T can be obtained, and then T1-A1 is used as the implicit part microarray feature matrix B1 (here it is not a direct subtraction, but the original matrix ignores the existing displayed microarray A1 matrix, and the remaining values ​​are synthesized into the new implicit microarray feature data B1); then after executing the first operation, scan the obtained table microarray feature matrix T2, and similarly choose to split it into explicit feature matrices A2 and B2 at the corresponding features, while the implicit operation matrix result values ​​B1 and B2 are saved in the background for subsequent processing.

[0130] (2) Cancel the implicit row number built-in operation (i.e., cancel the above-mentioned association): After the segmentation is performed according to the above steps, the link data influence matrix of the explicit part and the implicit part is established respectively. The system will automatically cancel the implicit row number corresponding to the built-in explicit operation link adjustment to avoid affecting the implicit part. In other words, the A1 matrix and the B1 matrix form a new microarray data to be operated, which has its own data sequence pattern, but B1 is not displayed on the user selection interface. Of course, when the A1 microarray data is processed by the user to obtain A2, in principle, B1 cancels the original regular link and does not undergo the corresponding operation of A1, so B2 = B1.

[0131] (3) Hidden Operation Value Processing: The system will perform a judgment on the hidden operation value stored in the background. This is to add a judgment in case of emergency. If B2 is not equal to B1, a quick reminder will be given to check the corresponding matching result difference and find the error until B2 = B1 is confirmed. Then, according to the user's needs and operation type, the corresponding operation is performed respectively. After processing is completed, the results A2 and B2 are merged into a new matrix column T2 according to the previous row and column relationship and synchronized to the table.

[0132] Continue to screen and segment the data microarray using the explicit and implicit parts of the table in the above manner, and obtain the final operation result microarray feature matrix T(N) after the last step.

[0133] Where, T1 (total microarray table feature matrix) = A1 (dominant microarray feature table matrix) + B1 (implicit)

[0134] T2=A2+B2

[0135] T3=A3+B3

[0136] …

[0137] T(N)=A(N)+B(N);

[0138] Of course, each operation has different explicit and implicit results, so if we look at each operation separately, we can only say that the implicit matrix remains unchanged in a single operation. However, when there is a new operation, if the original operation is correct, a new matrix link ring can be retained (until the final confirmation is made and the series of matrices corresponding to the link ring are released), or the user can confirm that it is correct and use subsequent microarray data features to overwrite the previous one to save space, thereby saving space.

[0139] In the embodiment of the present application, since the electronic device can determine whether the second matrix is ​​updated by comparing the matrices corresponding to the second data before and after performing the first operation, the accuracy of determining whether the second data is updated can be improved.

[0140] The following describes in detail the specific method for the electronic device to determine whether the first operation only includes updating the first data. Figure 1 ,like Figure 6 As shown, after the above step 101, the data processing method provided in the embodiment of the present application may further include the following step 106.

[0141] Step 106: The electronic device determines whether the first operation includes updating the second data based on the historical record of the first operation and the data characteristics of the data in the file.

[0142] Optionally, in an embodiment of the present application, the electronic device can learn and predict the user's operation intention based on the historical records of the above-mentioned first operation and the data characteristics of the data in the file to accurately determine whether the first operation requires updating the above-mentioned second data.

[0143] For example, the electronic device can analyze the user's operating habits and preferences, as well as the distribution characteristics and patterns of the data in the above-mentioned files, to predict the user's operating intentions and the data that may be affected.

[0144] Optionally, in an embodiment of the present application, the electronic device may determine whether the first operation includes updating the second data through a user behavior budget method.

[0145] It's important to note that the aforementioned user behavior budgeting method primarily predicts a user's intended action and the data that might be affected by analyzing their historical action records and table data features. Specifically, this method uses existing learning methods to extract features from a user's historical action records and train a model to predict the user's next action. For example, based on the user's historical action records and table data features, this method can predict whether a user will insert or delete a row of data, thereby determining whether the relevant data needs to be updated.

[0146] Optionally, in an embodiment of the present application, the electronic device may more accurately determine whether the first operation includes updating the second data by combining multiple detection methods. For example, algorithm analysis and user behavior prediction may be combined to detect whether the first operation includes updating the second data, thereby improving the accuracy and precision of the determination.

[0147] Optionally, in an embodiment of the present application, the above-mentioned multiple detection methods may include a pattern matching method, which can determine whether the user's operation will affect the data in other parts by analyzing the distribution characteristics and patterns of the data in the table. Specifically, the pattern matching method can identify the data patterns in the table through pattern matching and determine whether the user's operation conforms to these patterns. For example, the pattern matching method can identify whether the data of a certain cell depends on other cells based on the distribution characteristics and patterns of the data in the table, thereby determining whether the user's operation will affect related data.

[0148] Optionally, in an embodiment of the present application, the above-mentioned multiple detection methods may also include relevant artificial intelligence algorithms and models. For the specific description of the artificial intelligence algorithms and models, reference can be made to the relevant descriptions in the relevant technologies. In order to avoid repetition, they will not be repeated here.

[0149] Optionally, in an embodiment of the present application, the user can customize the detection rules to better meet the user's needs. For example, the user can customize the dependencies of a cell, or set the data update method and marking method of a cell to better ensure the accuracy and consistency of the data.

[0150] In the embodiment of the present application, since the electronic device can determine whether the first operation includes updating the above-mentioned second data based on the historical records of the first operation and the data characteristics of the data in the file, it can accurately determine whether the first operation includes updating the second data through multi-dimensional learning prediction.

[0151] Optionally, in the embodiment of the present application, Figure 1 ,like Figure 7 As shown, the data processing method provided in the embodiment of the present application may further include the following step 107.

[0152] Step 107: When the first operation further includes updating the second data, the electronic device updates the second data and displays the first mark.

[0153] The first mark is used to indicate the update time of the second data.

[0154] Optionally, in an embodiment of the present application, the first operation further includes updating the second data, that is, the first operation simultaneously includes updating the first data and the second data.

[0155] Optionally, in an embodiment of the present application, before the above step 107, the electronic device may first determine through the above step 106 whether the above first operation includes updating the above second data.

[0156] Optionally, in an embodiment of the present application, if the above-mentioned file is a table file, the above-mentioned first mark can be displayed in a cell in the file, or displayed at any position such as the row, column or worksheet where the above-mentioned second data is located, so that the user can understand the data update status more clearly.

[0157] Optionally, in an embodiment of the present application, the first mark may be a text mark, a color mark, an image mark, or the like.

[0158] Optionally, in an embodiment of the present application, the above-mentioned first mark can be an update time mark that is personalized based on the user's operation history and the data characteristics of the data in the above-mentioned file to improve the user's usage experience and operation efficiency; for example, information such as "updator" or "update method" is added to the update time mark so that the user can better understand the situation and method of data update; for example, the operation types with the same type in the frozen matrix can be layered with different colors to remind the user.

[0159] Optionally, in an embodiment of the present application, the electronic device may automatically update the data in the above-mentioned file at a preset time interval, and display the above-mentioned update time mark after each data update.

[0160] In an embodiment of the present application, since the electronic device can update the above-mentioned second data and display the above-mentioned first mark when the above-mentioned first operation also includes updating the above-mentioned second data, it is convenient for the user to understand the update status of the data in the above-mentioned file through the first mark, so as to verify and modify the data in a timely manner.

[0161] The above-mentioned method embodiments, or various possible implementation methods in each method embodiment, can be executed separately, or, under the premise that there is no contradiction, can also be executed in combination with each other. The specific implementation can be determined according to actual usage requirements, and the embodiments of the present application do not limit this.

[0162] The data processing method provided in the embodiment of the present application can be executed by a data processing device. In the embodiment of the present application, the data processing device provided in the embodiment of the present application is described by taking the data processing method executed by the data processing device as an example.

[0163] like Figure 8 As shown, an embodiment of the present application provides a data processing device 80 , which may include a processing module 81 and a recovery module 82 .

[0164] The processing module 81 may be configured to, upon receiving a first input from a user regarding first data in a file, determine second data in the file associated with the first data and perform a first operation corresponding to the first input. The recovery module 82 may be configured to, if the first operation only includes updating the first data and the second data is updated, restore the updated second data to the pre-update second data.

[0165] In one possible implementation, the recovery module 82 can be specifically used to cancel the association between the first data and the second data when the above-mentioned first operation only includes updating the above-mentioned first data and the above-mentioned second data is updated; and restore the updated second data to the second data before the update.

[0166] In one possible implementation, the recovery module 82 can be specifically used to display a first control when the above-mentioned first operation only includes updating the above-mentioned first data and the above-mentioned second data is updated. The first control is used to prompt that the second data has been updated; and when a second input from the user to the first control is received, the updated second data is restored to the second data before the update.

[0167] In one possible implementation, the processing module 81 can be specifically used to determine the above-mentioned second data based on the first information; wherein the first information includes any one of the following items: the input position information of the above-mentioned first input and the operation type information of the above-mentioned first operation, and the first operation is determined based on the first input; the association relationship information between the data in the above-mentioned file.

[0168] In one possible implementation, combining Figure 8 ,like Figure 9 As shown, the data processing device 80 may further include an acquisition module 83, a comparison module 84, and a first determination module 85. The acquisition module 83 may be configured to acquire a first matrix corresponding to the second data after the processing module 81 performs the first operation corresponding to the first input. The comparison module 84 may be configured to compare the first matrix with a second matrix corresponding to the second data stored before the first operation is performed. The first determination module 85 may be configured to determine whether the second data has been updated based on the comparison result of the first matrix and the second matrix.

[0169] In one possible implementation, combining Figure 8 ,like Figure 10As shown, the data processing device 80 may further include a second determination module 86. The second determination module 86 may be configured to, after the processing module 81 performs the first operation corresponding to the first input, determine whether the first operation includes updating the second data based on a history of the first operation and data features of the data in the file.

[0170] In one possible implementation, combining Figure 8 ,like Figure 11 As shown, the data processing device 80 may further include an updating module 87. The updating module 87 may be configured to update the second data and display a first mark when the first operation further includes updating the second data; wherein the first mark is configured to indicate the update time of the second data.

[0171] In the data processing device provided in the embodiment of the present application, since when a first operation is performed on the first data in a file, if the first operation does not require updating the second data associated with the first data in the file, and the second data has been updated, the second data can be directly restored to the data before the update. Therefore, there is no need for manual data verification by the user, or for data verification to be performed by adding complex formulas or data validation rules to the target file, thereby improving the efficiency of data verification.

[0172] The data processing device in the embodiment of the present application can be an electronic device or a component in the electronic device, such as an integrated circuit or a chip. The electronic device can be a terminal or other device other than a terminal. For example, the electronic device can be a mobile phone, a tablet computer, a laptop computer, a PDA, an in-vehicle electronic device, a mobile Internet device (MID), an augmented reality (AR) / virtual reality (VR) device, a robot, a wearable device, an ultra-mobile personal computer (UMPC), a netbook or a personal digital assistant (PDA), etc. It can also be a server, a network attached storage (NAS), a personal computer (PC), a television (TV), a teller machine or a self-service machine, etc., and the embodiment of the present application does not specifically limit it.

[0173] The data processing device in the embodiment of the present application may be a device having an operating system. The operating system may be an Android operating system, an iOS operating system, or other possible operating systems, which are not specifically limited in the embodiment of the present application.

[0174] The data processing device provided in the embodiment of the present application can implement the various processes implemented in the above method embodiment and achieve the same technical effect. To avoid repetition, it will not be described here.

[0175] like Figure 12 As shown, an embodiment of the present application also provides an electronic device 1200, including a processor 1201 and a memory 1202, wherein the memory 1202 stores a program or instruction that can be run on the processor 1201, and when the program or instruction is executed by the processor 1201, the various steps of the above-mentioned data processing method embodiment are implemented, and the same technical effect can be achieved. To avoid repetition, it will not be repeated here.

[0176] It should be noted that the electronic devices in the embodiments of the present application include mobile electronic devices and non-mobile electronic devices.

[0177] Figure 13 A schematic diagram of the hardware structure of an electronic device implementing an embodiment of the present application.

[0178] like Figure 13 As shown, the electronic device 1000 includes but is not limited to: a radio frequency unit 1001, a network module 1002, an audio output unit 1003, an input unit 1004, a sensor 1005, a display unit 1006, a user input unit 1007, an interface unit 1008, a memory 1009, and a processor 1010 and other components.

[0179] Those skilled in the art will understand that the electronic device 1000 may also include a power source (such as a battery) to power each component, and the power source may be logically connected to the processor 1010 through a power management system, thereby implementing functions such as charging, discharging, and power consumption management through the power management system. Figure 13 The electronic device structure shown in the figure does not constitute a limitation on the electronic device. The electronic device may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently, which will not be repeated here.

[0180] Among them, the processor 1010 can be used to determine the second data associated with the first data in the file when receiving the user's first input on the first data in the file, and perform a first operation corresponding to the first input; and when the first operation only includes updating the first data and the second data is updated, restore the updated second data to the second data before the update.

[0181] In one possible implementation, the processor 1010 can be specifically used to cancel the association between the first data and the second data when the above-mentioned first operation only includes updating the above-mentioned first data and the above-mentioned second data is updated; and restore the updated second data to the second data before the update.

[0182] In one possible implementation, the processor 1010 can be specifically used to display a first control when the above-mentioned first operation only includes updating the above-mentioned first data and the above-mentioned second data is updated, and the first control is used to prompt that the second data has been updated; and when a second input from the user to the first control is received, the updated second data is restored to the second data before the update.

[0183] In one possible implementation, the processor 1010 can be specifically used to determine the above-mentioned second data based on the first information; wherein the first information includes any one of the following items: input position information of the above-mentioned first input and operation type information of the above-mentioned first operation, and the first operation is determined based on the first input; and association relationship information between the data in the above-mentioned file.

[0184] In one possible implementation, the processor 1010 may also be configured to, after executing the first operation corresponding to the first input, obtain a first matrix corresponding to the second data; and compare the first matrix with a second matrix, where the second matrix is ​​a matrix corresponding to the second data stored before executing the first operation; and determine whether the second data is updated based on the comparison result of the first matrix and the second matrix.

[0185] In one possible implementation, the processor 1010 may also be configured to, after executing the first operation corresponding to the first input, determine whether the first operation includes updating the second data based on a historical record of the first operation and data features of the data in the file.

[0186] In a possible implementation, the processor 1010 may also be configured to update the second data and display a first mark when the first operation further includes updating the second data; wherein the first mark is used to indicate the update time of the second data.

[0187] In the electronic device provided in the embodiment of the present application, since when a first operation is performed on the first data in a file, if the first operation does not require updating the second data associated with the first data in the file, and the second data has been updated, the second data can be directly restored to the data before the update. Therefore, there is no need for manual data verification by the user, or data verification by adding complex formulas or data validation rules to the target file, thereby improving the efficiency of data verification.

[0188] It should be understood that in an embodiment of the present application, the input unit 1004 may include a graphics processing unit (GPU) 10041 and a microphone 10042, and the graphics processor 10041 processes the image data of a static picture or video obtained by an image capture device (such as a camera) in a video capture mode or an image capture mode. The display unit 1006 may include a display panel 10061, and the display panel 10061 may be configured in the form of a liquid crystal display, an organic light emitting diode, etc. The user input unit 1007 includes a touch panel 10071 and at least one of other input devices 10072. The touch panel 10071 is also called a touch screen. The touch panel 10071 may include two parts: a touch detection device and a touch controller. Other input devices 10072 may include, but are not limited to, a physical keyboard, function keys (such as volume control keys, switch keys, etc.), a trackball, a mouse, and an operating stick, which will not be repeated here.

[0189] The memory 1009 can be used to store software programs and various data. The memory 1009 may mainly include a first storage area for storing programs or instructions and a second storage area for storing data, wherein the first storage area may store an operating system, applications or instructions required for at least one function (such as a sound playback function, an image playback function, etc.). In addition, the memory 1009 may include a volatile memory or a non-volatile memory, or the memory 1009 may include both volatile and non-volatile memories. Among them, the non-volatile memory may be a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), or a flash memory. The volatile memory may be a random access memory (RAM), a static random access memory (SRAM), a dynamic random access memory (DRAM), a synchronous dynamic random access memory (SDRAM), a double data rate synchronous dynamic random access memory (DDRSDRAM), an enhanced synchronous dynamic random access memory (ESDRAM), a synchronous link dynamic random access memory (SLDRAM), and a direct memory bus random access memory (DRRAM). The memory 1009 in the embodiment of the present application includes but is not limited to these and any other suitable types of memory.

[0190] Processor 1010 may include one or more processing units. Optionally, processor 1010 integrates an application processor and a modem processor. The application processor primarily handles operations related to the operating system, user interface, and application programs, while the modem processor primarily processes wireless communication signals, such as a baseband processor. It is understood that the modem processor may not be integrated into processor 1010.

[0191] An embodiment of the present application also provides a readable storage medium, on which a program or instruction is stored. When the program or instruction is executed by a processor, the various processes of the above-mentioned data processing method embodiment are implemented and the same technical effect can be achieved. To avoid repetition, it will not be repeated here.

[0192] The processor is the processor in the electronic device described in the above embodiment. The readable storage medium includes a computer readable storage medium, such as a computer read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0193] An embodiment of the present application further provides a chip, which includes a processor and a communication interface, wherein the communication interface is coupled to the processor, and the processor is used to run programs or instructions to implement the various processes of the above-mentioned data processing method embodiment and can achieve the same technical effect. To avoid repetition, it will not be repeated here.

[0194] It should be understood that the chip mentioned in the embodiments of the present application can also be called a system-level chip, a system chip, a chip system or a system-on-chip chip, etc.

[0195] An embodiment of the present application provides a computer program product, which is stored in a storage medium. The program product is executed by at least one processor to implement the various processes of the above-mentioned data processing method embodiment and can achieve the same technical effect. To avoid repetition, it will not be repeated here.

[0196] It should be noted that, in this article, the terms "comprise", "include" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the statement "comprises a ..." does not exclude the presence of other identical elements in the process, method, article or device comprising the element. In addition, it should be noted that the scope of the methods and devices in the embodiments of the present application is not limited to performing functions in the order shown or discussed, and may also include performing functions in a substantially simultaneous manner or in the opposite order according to the functions involved. For example, the described method may be performed in an order different from that described, and various steps may also be added, omitted, or combined. In addition, the features described with reference to certain examples may be combined in other examples.

[0197] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus the necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art can be embodied in the form of a computer software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), including a number of instructions for enabling a terminal (which can be a mobile phone, computer, server, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0198] The embodiments of the present application are described above in conjunction with the accompanying drawings, but the present application is not limited to the above-mentioned specific implementation methods. The above-mentioned specific implementation methods are merely illustrative and not restrictive. Under the guidance of this application, ordinary technicians in this field can also make many forms without departing from the purpose of this application and the scope of protection of the claims, all of which are within the protection of this application.

Claims

1. A data processing method, characterized in that: The method comprises: Upon receiving a first input from a user regarding first data in a file, determining second data associated with the first data in the file, and performing a first operation corresponding to the first input; In a case where the first operation only includes updating the first data and the second data is updated, the updated second data is restored to the second data before the update.

2. The method according to claim 1, characterized in that The step of restoring the updated second data to the second data before the update, when the first operation only includes updating the first data and the second data is updated, includes: If the first operation only includes updating the first data and the second data is updated, canceling the association between the first data and the second data; The updated second data is restored to the second data before updating.

3. The method according to claim 1, characterized in that The step of restoring the updated second data to the second data before the update, when the first operation only includes updating the first data and the second data is updated, includes: In a case where the first operation only includes updating the first data and the second data is updated, a first control is displayed, where the first control is used to prompt that the second data has been updated; When a second input to the first control is received from the user, the updated second data is restored to the second data before the update.

4. The method according to claim 1, wherein The determining the second data associated with the first data in the file includes: determining the second data according to the first information; The first information includes any one of the following: input position information of the first input and operation type information of the first operation, the first operation being determined based on the first input; The association relationship information between the data in the file.

5. The method according to any one of claims 1 to 4, characterized in that After executing the first operation corresponding to the first input, the method further includes: Obtaining a first matrix corresponding to the second data; Comparing the first matrix with a second matrix, where the second matrix is ​​a matrix corresponding to the second data stored before performing the first operation; According to the comparison result of the first matrix and the second matrix, it is determined whether the second data is updated.

6. The method according to any one of claims 1 to 4, characterized in that After executing the first operation corresponding to the first input, the method further includes: It is determined whether the first operation includes updating the second data according to a history record of the first operation and data characteristics of the data in the file.

7. The method according to any one of claims 1 to 4, characterized in that The method further comprises: In a case where the first operation further includes updating the second data, updating the second data and displaying the first mark; The first mark is used to indicate the update time of the second data.

8. A data processing device, characterized in that: The device includes a processing module and a recovery module; The processing module is configured to, upon receiving a first input from a user regarding first data in a file, determine second data associated with the first data in the file, and perform a first operation corresponding to the first input; The recovery module is configured to, when the first operation only includes updating the first data and the second data is updated, restore the updated second data to the second data before the update.

9. An electronic device, characterized in that: The method comprises a processor and a memory, wherein the memory stores programs or instructions that can be run on the processor, and when the programs or instructions are executed by the processor, the steps of the data processing method according to any one of claims 1 to 7 are implemented.

10. A readable storage medium, characterized in that: The readable storage medium stores a program or instruction, and when the program or instruction is executed by the processor, the steps of the data processing method according to any one of claims 1 to 7 are implemented.

Images