Table data updating method, apparatus and device, computer readable medium and product
By obtaining and utilizing the update configuration information of the table data, reading and encapsulating the list of data to be updated and participating in the update data, the complex problem of the table update process in the existing technology is solved, and the simplification of the system architecture and improvement of development flexibility is achieved.
Patent Information
- Application Number
- CN202411448931.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-16
- Publication Date
- 2025-02-07
AI Technical Summary
When updating table files, the prior art needs to be developed separately from the dimension of the smallest cell for each summary method, resulting in complex system architecture and verbose program files.
By obtaining the update configuration information of the target table data, including information to be updated, information to be updated, information to be updated and information to be updated, it reads the data to be updated and data to be updated, encapsulates it into a list, and updates the table data based on this information.
It simplifies the system architecture and program files, improves the flexibility of the development table update method, and decouples the update process to update configuration, update method configuration and data positioning configuration.
Smart Images
Figure CN119396849A_ABST
Abstract
Description
Technical Field
[0001] Embodiments of the present disclosure relate to the field of computer technology, and in particular to a table data updating method, apparatus, device, computer-readable medium, and product. Background Art
[0002] As a common storage method for enterprise business data, spreadsheet files are usually used for business analysis. According to business needs, data in spreadsheet files can be directly used for various forms of summarization (for example, the values filled into the total cells are determined based on the data in the spreadsheet) to update the spreadsheet files. At present, when updating spreadsheet files, the commonly used method is: using a plug-in adapted to the spreadsheet file, reading the data of each row and column of the spreadsheet file, and then directly determining the summary update content based on the data of each row and column read in a summary manner to update the spreadsheet file.
[0003] However, the inventors have found that when the above method is used, the following technical problems often occur: the method of directly using the read rows and columns of data to determine the summary update content requires separate development of each summary method from the dimension of the smallest cell, resulting in a more complex system architecture and, in turn, a more lengthy program file.
[0004] The above information disclosed in this Background section is only for enhancement of understanding of the background of the inventive concept and therefore it may contain information that does not form the prior art that is already known to a person of ordinary skill in the art. Summary of the invention
[0005] The content of this disclosure is used to introduce concepts in a brief form, which will be described in detail in the detailed implementation section below. The content of this disclosure is not intended to identify the key features or essential features of the technical solution claimed for protection, nor is it intended to limit the scope of the technical solution claimed for protection.
[0006] Some embodiments of the present disclosure propose a table data updating method, an apparatus, an electronic device, a computer-readable medium, and a computer program product to solve one or more of the technical problems mentioned in the above background technology section.
[0007] In a first aspect, some embodiments of the present disclosure provide a table data updating method, the method comprising: obtaining update configuration information corresponding to target table data, wherein the update configuration information comprises information to be updated, information of variables participating in updating and update method information, the information of variables participating in updating corresponds to at least one variable participating in updating, and the update method information corresponds to a variable participating in updating in the at least one variable participating in updating; reading data to be updated corresponding to the information to be updated from the target table data; adding the data to be updated to a list of data to be updated; determining, according to the target table data, data participating in updating corresponding to the information of variables participating in updating; adding the data participating in updating to a list of data participating in updating; and updating the target table data based on the updated list of data to be updated, the list of data participating in updating and the update method information.
[0008] Optionally, the above-mentioned information to be updated includes at least one row and column filtering condition; and the above-mentioned reading of the data to be updated corresponding to the above-mentioned information to be updated from the above-mentioned target table data includes: selecting table data that satisfies the above-mentioned at least one row and column filtering condition from the above-mentioned target table data; and determining the selected table data as the data to be updated corresponding to the above-mentioned information to be updated.
[0009] Optionally, the above-mentioned variable information participating in updating includes at least one variable screening information, each variable screening information corresponds to a variable participating in updating, and the above-mentioned variable screening information includes at least one row and column screening condition; and the above-mentioned determining the participating update data corresponding to the above-mentioned variable information participating in updating based on the above-mentioned target table data includes: for each variable screening information in the above-mentioned at least one variable screening information, performing the following steps: selecting table data that satisfies the above-mentioned at least one row and column screening condition from the above-mentioned target table data; determining the selected table data as the variable data corresponding to the above-mentioned variable screening information; and determining each determined variable data as the participating update data corresponding to the above-mentioned variable information participating in updating.
[0010] Optionally, the above-mentioned information to be updated includes a column identifier to be updated; and the above-mentioned updating of the above-mentioned target table data based on the updated data list to be updated, the participating update data list and the above-mentioned update method information includes: generating table update data according to the above-mentioned update method information and each variable data corresponding to the above-mentioned at least one participating update variable in the updated participating update data list; determining the row and column information to be updated according to the updated data list to be updated and the above-mentioned column identifier to be updated; and updating the above-mentioned table update data to the above-mentioned target table data according to the determined row and column information to be updated.
[0011] Optionally, the above-mentioned variable information participating in the update includes a column identifier to be updated; and before the above-mentioned table update data is updated to the above-mentioned target table data according to the determined row and column information to be updated, the above-mentioned target table data is updated based on the updated data list to be updated, the data list participating in the update and the above-mentioned update method information, and also includes: determining the row and column information to be updated according to the updated data list to be updated and the column identifier to be updated included in the above-mentioned variable information participating in the update.
[0012] Optionally, the above-mentioned determining the participating update data corresponding to the above-mentioned participating update variable information according to the above-mentioned target table data includes: in response to determining that the above-mentioned update configuration information includes external table information, determining the participating update variable corresponding to the above-mentioned external table information as an external participating update variable; for each participating update variable among the above-mentioned at least one participating update variable, performing the following steps: in response to determining that the above-mentioned participating update variable is an external participating update variable, determining the table file corresponding to the external table information of the above-mentioned participating update variable as external table data; reading variable data corresponding to the above-mentioned participating update variable from the above-mentioned external table data; in response to determining that the above-mentioned participating update variable is not an external participating update variable, reading variable data corresponding to the above-mentioned participating update variable from the above-mentioned target table data; determining each determined variable data as the participating update data corresponding to the above-mentioned participating update variable information.
[0013] In a second aspect, some embodiments of the present disclosure provide a table data updating device, the device comprising: an acquiring unit, configured to acquire update configuration information corresponding to target table data, wherein the update configuration information comprises information to be updated, information on variables participating in updating and update method information, the information on variables participating in updating corresponds to at least one variable participating in updating, and the update method information corresponds to a variable participating in updating in the at least one variable participating in updating; a reading unit, configured to read data to be updated corresponding to the information to be updated from the target table data; a first adding unit, configured to add the data to be updated to a list of data to be updated; a determining unit, configured to determine the data participating in updating corresponding to the information on variables participating in updating according to the target table data; a second adding unit, configured to add the data participating in updating to a list of data participating in updating; an updating unit, configured to update the target table data based on the updated list of data to be updated, the list of data participating in updating and the update method information.
[0014] Optionally, the information to be updated includes at least one row and column filtering condition.
[0015] Optionally, the reading unit is further configured to: select table data satisfying the at least one row and column screening condition from the target table data; and determine the selected table data as the data to be updated corresponding to the information to be updated.
[0016] Optionally, the above-mentioned variable information participating in updating includes at least one variable screening information, each variable screening information corresponds to a variable participating in updating, and the above-mentioned variable screening information includes at least one row and column screening condition.
[0017] Optionally, the determination unit is further configured to: for each variable screening information in the at least one variable screening information mentioned above, perform the following steps: select table data that satisfies the at least one row and column screening condition mentioned above from the target table data; determine the selected table data as variable data corresponding to the variable screening information mentioned above; determine each determined variable data as participating update data corresponding to the participating update variable information mentioned above.
[0018] Optionally, the information to be updated includes an identifier of a column to be updated.
[0019] Optionally, the update unit is further configured to: generate table update data according to the above-mentioned update method information and the variable data corresponding to the above-mentioned at least one participating update variable in the updated participating update data list; determine the row and column information to be updated according to the updated list of data to be updated and the above-mentioned column identifier to be updated; and update the above-mentioned table update data to the above-mentioned target table data according to the determined row and column information to be updated.
[0020] Optionally, the above-mentioned variable information involved in updating includes an identifier of a column to be updated.
[0021] Optionally, before updating the above-mentioned table update data to the above-mentioned target table data according to the determined row and column information to be updated, the update unit also includes: an information determination unit, configured to determine the row and column information to be updated according to the updated list of data to be updated and the column identifier to be updated included in the above-mentioned variable information participating in the update.
[0022] Optionally, the determination unit is further configured to: in response to determining that the above-mentioned update configuration information includes external table information, determine the participating update variable corresponding to the above-mentioned external table information as an external participating update variable; for each participating update variable among the above-mentioned at least one participating update variable, perform the following steps: in response to determining that the above-mentioned participating update variable is an external participating update variable, determine the table file corresponding to the external table information of the above-mentioned participating update variable as external table data; read variable data corresponding to the above-mentioned participating update variable from the above-mentioned external table data; in response to determining that the above-mentioned participating update variable is not an external participating update variable, read the variable data corresponding to the above-mentioned participating update variable from the above-mentioned target table data; determine each determined variable data as the participating update data corresponding to the above-mentioned participating update variable information.
[0023] In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device on which one or more programs are stored, and when the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any implementation manner of the above-mentioned first aspect.
[0024] In a fourth aspect, some embodiments of the present disclosure provide a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the method described in any implementation manner of the above-mentioned first aspect is implemented.
[0025] In a fifth aspect, some embodiments of the present disclosure provide a computer program product, including a computer program, which implements the method described in any implementation manner of the above-mentioned first aspect when executed by a processor.
[0026] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table update method of some embodiments of the present disclosure, the system architecture and program files are simplified. Specifically, the reason for the complexity of the system architecture and the lengthy program files is that the method of directly using the read data of each row and column to determine the summary update content needs to be developed separately from the dimension of the smallest cell for each summary method, resulting in a relatively complex system architecture, thereby resulting in a relatively lengthy program file. Based on this, the table update method of some embodiments of the present disclosure, first, obtains the update configuration information corresponding to the target table data, wherein the above-mentioned update configuration information includes information to be updated, information of variables participating in the update, and information of the update mode, wherein the above-mentioned information of variables participating in the update corresponds to at least one variable participating in the update, and the above-mentioned update mode information corresponds to the variables participating in the update of the at least one variable participating in the update. Thus, the configuration related information for updating the table data can be obtained in advance. Secondly, the data to be updated corresponding to the above-mentioned information to be updated is read from the above-mentioned target table data. Thus, the table data to be updated can be located. Then, the above-mentioned data to be updated is added to the list of data to be updated. Thus, the located table data to be updated can be encapsulated into a list for subsequent direct reading from the list. Next, according to the target table data, the update data corresponding to the update variable information is determined. Thus, the data needed to update the table can be located. Secondly, the update data is added to the update data list. Thus, the located update data can be encapsulated into a list for subsequent direct reading from the list. Finally, based on the updated list of data to be updated, the update data list and the update method information, the target table data is updated. Thus, and because the update method information directly corresponds to the update variables, the data needed can be located directly from the update data list according to the update variables corresponding to the update method information, and then after determining the update content according to the update method information, the table data that needs to be updated can be updated according to the table data stored in the update data list. Thus, the process of updating the table can be decoupled into the process of update configuration, update method configuration and data location configuration, which improves the flexibility when developing the table update method and simplifies the system architecture and program files. BRIEF DESCRIPTION OF THE DRAWINGS
[0027] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that components and elements are not necessarily drawn to scale.
[0028] Figure 1 is an architectural diagram of an exemplary system in which some embodiments of the present disclosure may be applied;
[0029] Figure 2 is a flow chart of some embodiments of the table data updating method according to the present disclosure;
[0030] Figure 3 are flow charts of other embodiments of the table data updating method according to the present disclosure;
[0031] Figure 4 is a schematic diagram of the structure of some embodiments of the table data updating device according to the present disclosure;
[0032] Figure 5 It is a schematic diagram of the structure of an electronic device suitable for implementing some embodiments of the present disclosure. DETAILED DESCRIPTION
[0033] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments set forth herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.
[0034] It should also be noted that, for ease of description, only the parts related to the invention are shown in the drawings. In the absence of conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other.
[0035] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.
[0036] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".
[0037] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.
[0038] With regard to the collection, storage, and use of user personal information (such as form data) involved in this disclosure, before performing the corresponding operations, the relevant organizations or individuals shall fulfill their obligations, including conducting personal information security impact assessments, fulfilling the obligation to inform the personal information subject, and obtaining the authorization and consent of the personal information subject in advance.
[0039] The present disclosure will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.
[0040] Figure 1 An exemplary system architecture 100 is shown to which a table data updating method or a table data updating apparatus according to some embodiments of the present disclosure may be applied.
[0041] like Figure 1 As shown, the system architecture 100 may include terminal devices 101, 102, 103, a network 104 and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.
[0042] Users can use terminal devices 101, 102, 103 to interact with server 105 through network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, 103, such as web browser applications, table editing applications, search applications, instant messaging tools, email clients, social platform software, etc.
[0043] Terminal devices 101, 102, 103 may be hardware or software. When terminal devices 101, 102, 103 are hardware, they may be various electronic devices having a display screen and supporting table display, including but not limited to smart phones, tablet computers, e-book readers, laptop portable computers, desktop computers, etc. When terminal devices 101, 102, 103 are software, they may be installed in the electronic devices listed above. They may be implemented as multiple software or software modules for providing distributed services, or as a single software or software module. No specific limitation is made here.
[0044] The server 105 may be a server that provides various services, such as a background server that provides support for table data displayed on the terminal devices 101, 102, and 103. The background server may analyze and process the received data such as the table update request, and feed back the processing result (such as the updated table content) to the terminal device.
[0045] It should be noted that the table updating method provided in the embodiment of the present disclosure can be executed by the terminal devices 101, 102, 103, or by the server 105. Accordingly, the table updating device can be set in the terminal devices 101, 102, 103, or in the server 105. No specific limitation is made here.
[0046] It should be noted that the server can be hardware or software. When the server is hardware, it can be implemented as a distributed server cluster consisting of multiple servers, or it can be implemented as a single server. When the server is software, it can be implemented as multiple software or software modules for providing distributed services, or it can be implemented as a single software or software module. No specific limitation is made here.
[0047] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.
[0048] Continue to refer Figure 2 , shows a process 200 of some embodiments of the table data updating method according to the present disclosure. The table data updating method comprises the following steps:
[0049] Step 201, obtaining update configuration information corresponding to target table data.
[0050] In some embodiments, the execution body of the table data update method (for example Figure 1 The server or terminal device shown in the figure can obtain the update configuration information of the corresponding target table data from the computing device storing the update configuration information through a wired connection or a wireless connection. Among them, the computing device storing the update configuration information can be the above-mentioned execution subject, or it can be a database server. The above-mentioned target table data can be a file of a table structure that needs to be summarized and updated. For example, the above-mentioned target table data can be an Excel table file. The summary update can be understood as summarizing the table file based on the data in the table file to achieve the update of the table file. The above-mentioned update configuration information can be pre-configured configuration item related information when updating the table file. The above-mentioned update configuration information can be stored in a structured file. For example, the structured file can be a yml file.
[0051] The above-mentioned update configuration information may include, but is not limited to: information to be updated, information about variables involved in updating, and information about update methods. The information to be updated may be configuration information for locating the position or data in the table to be updated. For example, the information to be updated may include row and column positioning conditions. The row and column positioning conditions may be used to locate the cells to be updated. As an example, the row and column positioning conditions may include: condition:col16=='Automatic calculation'&&col10=='Income'&&col11=='Total'; resultCol:col12. The row and column positioning condition may represent filtering out all rows whose 6th column is 'Automatic calculation', whose 10th column is 'Income', and whose 11th column is 'Total' from the above-mentioned target table data, and using the position or cell data of the 12th column in the filtered row as the position or data to be updated. It should be noted that the filtered row may be one row or multiple rows, which is specifically determined by the data content in the target table data. The above-mentioned condition may be a logical operation expression. For example, the logical operation expression may be an MVEL expression. By configuring resultCol, you can further filter the results of condition positioning to determine the row and column identifiers or cell data to be updated. resultCol can also be defined with field values.
[0052] The above-mentioned update-participating variable information may be configuration information for locating data in a table corresponding to the update-participating variable. The above-mentioned update-participating variable information may correspond to at least one update-participating variable. The above-mentioned update-participating variable information may include variable row and column positioning conditions corresponding to each update-participating variable. For example, the variable row and column positioning conditions may include: variables:order:condition:col6==${col6}&&col7==${col7}&&col8==${col8}&&col9==${col9}&&col10=='unit quantity'&&col11=='unit quantity'; income:condition:col6==${col6}&&col7==${col7}&&col8==${col8}&&col9==${col9}&&col10=='unit price'&&col11=='average income per unit'. The variable row and column positioning conditions may correspond to two update-participating variables, namely, order variable and income variable. The order variable and the income variable respectively correspond to a logical operation expression condition for locating variable data. Through the variable row and column positioning condition, the table contents of multiple rows and columns corresponding to the order variable and the income variable can be located from the target table data.
[0053] The update mode information may be configuration information for the update mode. The update mode information corresponds to the update participating variable in the at least one update participating variable, and it can be understood that the update mode information may be constructed based on the update participating variable. For example, the update mode information may be an arithmetic expression constructed using the update participating variable. As an example, the update mode information may include: expression:order*income.
[0054] It should be noted that the above-mentioned wireless connection methods may include but are not limited to 3G / 4G connection, WiFi connection, Bluetooth connection, WiMAX connection, Zigbee connection, UWB (ultra wideband) connection, and other wireless connection methods currently known or to be developed in the future.
[0055] Step 202: Read the data to be updated corresponding to the information to be updated from the target table data.
[0056] In some embodiments, the execution subject may read the data to be updated corresponding to the information to be updated from the target table data. In practice, the execution subject may read cell data from the target table data according to the row and column positioning conditions to obtain at least one cell data as the data to be updated corresponding to the information to be updated.
[0057] Optionally, the information to be updated may include at least one row and column filtering condition. The row and column filtering condition may be a condition for filtering a row or column. For example, one of the row and column filtering conditions may be: col16 == 'automatically calculated'. The logical relationship between the at least one row and column filtering condition may be "and".
[0058] In some optional implementations of some embodiments, the execution subject may read the data to be updated corresponding to the information to be updated from the target table data through the following steps:
[0059] The first step is to select table data satisfying the at least one row and column screening condition from the target table data. The selected table data satisfies each row and column screening condition of the at least one row and column screening condition at the same time. For example, when the at least one row and column screening condition is a condition for limiting the value of a column in the table, the selected table data may include at least one row of table content.
[0060] The second step is to determine the selected table data as the data to be updated corresponding to the above-mentioned information to be updated. Thus, the table data can be pre-screened as the data to be updated using multiple row and column screening conditions.
[0061] Step 203: Add the data to be updated to the list of data to be updated.
[0062] In some embodiments, the execution subject may add the data to be updated to a list of data to be updated. The list of data to be updated may be a list for storing located data to be updated. The list of data to be updated may be predefined, and the data in the list of data to be updated may be stored in the form of key-value pairs.
[0063] Step 204: Determine the update participation data corresponding to the update participation variable information according to the target table data.
[0064] In some embodiments, the execution subject may determine the update participation data corresponding to the update participation variable information according to the target table data. In practice, the execution subject may read the table content corresponding to the at least one update participation variable from the target table data according to the variable row and column positioning condition, and obtain at least one table content as the update participation data corresponding to the information to be updated.
[0065] Optionally, the above-mentioned variable information participating in the update includes at least one variable screening information. The variable screening information can be table data screening configuration information for a variable participating in the update. Each variable screening information corresponds to a variable participating in the update. The above-mentioned variable screening information includes at least one row and column screening condition. For example, one of the row and column screening conditions can be: col6==${col6}, which can indicate that the variable to be located is in the 6th column. The logical relationship between the above-mentioned at least one row and column screening condition can be "and".
[0066] In some optional implementations of some embodiments, the execution subject may determine the participating update data corresponding to the participating update variable information according to the target table data through the following steps:
[0067] In the first step, for each variable screening information in the at least one variable screening information, the following steps are performed:
[0068] The first sub-step is to select table data satisfying the at least one row and column screening condition from the target table data. The selected table data satisfies each row and column screening condition of the at least one row and column screening condition at the same time. For example, when the at least one row and column screening condition is a condition for limiting the value of a column in the table, the selected table data may include at least one row of table content.
[0069] The second sub-step is to determine the selected table data as variable data corresponding to the above variable screening information, wherein one variable data corresponds to one variable involved in updating.
[0070] In the second step, each determined variable data is determined as the participating update data corresponding to the above-mentioned participating update variable information. Thus, the table data can be selected as the participating update data using multiple row and column selection conditions.
[0071] Step 205: Add the participating update data to the participating update data list.
[0072] In some embodiments, the execution subject may add the update participation data to a list of update participation data. The list of update participation data may be a list for storing the location update participation data. The list of update participation data may be predefined, and the data may be stored in the form of key-value pairs in the list of update participation data.
[0073] Step 206: Update the target table data based on the updated list of data to be updated, the list of data participating in the update, and the update method information.
[0074] In some embodiments, the above-mentioned execution subject can update the above-mentioned target table data based on the updated list of data to be updated, the list of data participating in the update and the above-mentioned update method information. In practice, first, the above-mentioned execution subject can input the above-mentioned update method information into a pre-packaged update method to obtain the table update data. The above-mentioned update method can be a method that takes the update method information as a method input parameter and the determined table update data as an output to execute the update method corresponding to the update method information. The above-mentioned update method can directly read the participating update data from the above-mentioned list of data participating in the update. For example, the update method can be expressed as CalRuleHandler.cal(). Then, the above-mentioned execution subject can update the table update data to the cell position corresponding to the data to be updated stored in the above-mentioned list of data to be updated in the target table data to update the above-mentioned target table data.
[0075] Optionally, the information to be updated may include a column identifier to be updated. The column identifier to be updated may represent an identifier of a column where the data to be updated is located.
[0076] In some optional implementations of some embodiments, the execution subject may update the target table data based on the updated list of data to be updated, the list of data participating in updating and the update method information through the following steps:
[0077] The first step is to generate table update data according to the above update method information and the variable data corresponding to the above at least one participating update variable in the updated participating update data list. In practice, the above execution subject can input the above update method information and the above participating update data list into a pre-packaged update method to obtain the table update data. Here, the above update method can be a method that takes the update method information and the participating update data list as method input parameters and the determined table update data as output, so as to execute the update method corresponding to the update method information. The above update method can directly read each variable data from the above participating update data list. When there is only one cell data to be updated, the table update data can include one update value. When there are multiple cell data to be updated, the table update data can include multiple update values.
[0078] The second step is to determine the row and column information to be updated based on the updated list of data to be updated and the above-mentioned column identifier to be updated. In practice, the above-mentioned execution entity can extract the key-value pair whose corresponding key includes the above-mentioned column identifier to be updated from the above-mentioned list of data to be updated, and obtain at least one key-value pair. Then, the above-mentioned execution entity can determine the row and column identifier corresponding to each key-value pair in the above-mentioned at least one key-value pair, and obtain at least one row and column identifier as the row and column information to be updated. When there is only one cell data to be updated, the row and column information to be updated may include one row and column identifier. When there are multiple cell data to be updated, the row and column information to be updated may include multiple row and column identifiers.
[0079] The third step is to update the table update data to the target table data according to the determined row and column information to be updated. In practice, the execution subject can update the at least one update value included in the table update data to the cell corresponding to the at least one row and column identifier to update the target table data. Thus, the list of data to be updated can be used to locate the position to be updated, so as to update the generated table update data to the target table data.
[0080] Optionally, the above-mentioned variable information involved in updating may also include an identifier of a column to be updated.
[0081] In some optional implementations of some embodiments, before the table update data is updated to the target table data according to the determined row and column information to be updated, the execution subject may also determine the row and column information to be updated according to the updated data list to be updated and the column identifier to be updated included in the above-mentioned participating update variable information. In practice, the specific implementation method of the execution subject determining the row and column information to be updated can refer to the method of determining the row and column information to be updated in the above-mentioned second step, which will not be repeated here. Therefore, when there is also a column identifier to be updated in the definition of the participating update variable, the position to be updated can be determined based on the column identifier to be updated in the definition of the participating update variable.
[0082] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table update method of some embodiments of the present disclosure, the system architecture and program files are simplified. Specifically, the reason for the complexity of the system architecture and the lengthy program files is that the method of directly using the read data of each row and column to determine the summary update content needs to be developed separately from the dimension of the smallest cell for each summary method, resulting in a relatively complex system architecture, thereby resulting in a relatively lengthy program file. Based on this, the table update method of some embodiments of the present disclosure, first, obtains the update configuration information corresponding to the target table data, wherein the above-mentioned update configuration information includes information to be updated, information of variables participating in the update, and information of the update mode, wherein the above-mentioned information of variables participating in the update corresponds to at least one variable participating in the update, and the above-mentioned update mode information corresponds to the variables participating in the update of the at least one variable participating in the update. Thus, the configuration related information for updating the table data can be obtained in advance. Secondly, the data to be updated corresponding to the above-mentioned information to be updated is read from the above-mentioned target table data. Thus, the table data to be updated can be located. Then, the above-mentioned data to be updated is added to the list of data to be updated. Thus, the located table data to be updated can be encapsulated into a list for subsequent direct reading from the list. Next, according to the target table data, the update data corresponding to the update variable information is determined. Thus, the data needed to update the table can be located. Secondly, the update data is added to the update data list. Thus, the located update data can be encapsulated into a list for subsequent direct reading from the list. Finally, based on the updated list of data to be updated, the update data list and the update method information, the target table data is updated. Thus, and because the update method information directly corresponds to the update variables, the data needed can be located directly from the update data list according to the update variables corresponding to the update method information, and then after determining the update content according to the update method information, the table data that needs to be updated can be updated according to the table data stored in the update data list. Thus, the process of updating the table can be decoupled into the process of update configuration, update method configuration and data location configuration, which improves the flexibility when developing the table update method and simplifies the system architecture and program files.
[0083] Further references Figure 3 , which shows a process 300 of another embodiment of a table data updating method. The process 300 of the table data updating method includes the following steps:
[0084] Step 301, obtaining update configuration information corresponding to target table data.
[0085] Step 302: Read the data to be updated corresponding to the information to be updated from the target table data.
[0086] Step 303: Add the data to be updated to the list of data to be updated.
[0087] Step 304: In response to determining that the update configuration information includes external table information, determine the update participating variable corresponding to the external table information as the external update participating variable.
[0088] In some embodiments, the execution body of the table data update method (for example Figure 1 The server or terminal device shown in the figure can determine the update variable corresponding to the external table information as the external update variable in response to determining that the update configuration information includes the external table information. The external table information can be a file identifier of an external table file configured for the update variable that is different from the target table data, which can indicate that the update variable needs to be assigned table data from the external table file.
[0089] Step 305: for each of the at least one update-participating variable, perform the following steps:
[0090] Step 3051: In response to determining that the update-participating variable is an external update-participating variable, a table file corresponding to the external table information of the update-participating variable is determined as external table data.
[0091] In some embodiments, the execution subject may determine the table file corresponding to the external table information of the participating update variable as the external table data in response to determining that the participating update variable is an external participating update variable. Thus, the external table file may be located according to the external table information of the participating update variable.
[0092] Step 3052, read variable data corresponding to the variables involved in updating from the external table data.
[0093] In some embodiments, the execution subject may read the variable data corresponding to the variables participating in the update from the external table data. In practice, the specific implementation method of the execution subject reading the variable data corresponding to the variables participating in the update from the external table data can be referred to. Figure 2 The corresponding step 204 in those embodiments will not be described in detail here.
[0094] Step 3053: In response to determining that the participating update variable is not an external participating update variable, variable data corresponding to the participating update variable is read from the target table data.
[0095] In some embodiments, the execution subject may read the variable data corresponding to the update-participating variables from the external table data. In practice, the specific implementation method of the execution subject reading the variable data corresponding to the update-participating variables from the target table data may refer to Figure 2 The corresponding step 204 in those embodiments will not be described in detail here.
[0096] Step 306: determine each determined variable data as participating update data corresponding to participating update variable information.
[0097] Step 307: Add the participating update data to the participating update data list.
[0098] Step 308: Update the target table data based on the updated list of data to be updated, the list of data participating in the update, and the update method information.
[0099] In some embodiments, the specific implementation methods of steps 301-303, 307-308 and the technical effects brought about can be referred to Figure 2 The corresponding steps 201-203, 205-206 in the embodiments are not described in detail here.
[0100] from Figure 3 It can be seen that Figure 2 Compared with the description of some corresponding embodiments, Figure 3 The process 300 of the table data updating method in some corresponding embodiments embodies the step of expanding the external table information. Therefore, the solutions described in these embodiments can decouple the external table data dependency and support external data association in the form of an extended table.
[0101] Further references Figure 4 As an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of a table data updating device. These device embodiments are similar to Figure 2 Corresponding to the method embodiments shown, the table data updating device can be specifically applied to various electronic devices.
[0102] like Figure 4As shown, the table data updating apparatus 400 of some embodiments includes: an acquisition unit 401, a reading unit 402, a first adding unit 403, a determining unit 404, a second adding unit 405 and an updating unit 406. The acquisition unit 401 is configured to acquire update configuration information corresponding to the target table data, wherein the update configuration information includes information to be updated, information of variables participating in updating and update mode information, the information of variables participating in updating corresponds to at least one variable participating in updating, and the update mode information corresponds to a variable participating in updating in the at least one variable participating in updating; the reading unit 402 is configured to read the data to be updated corresponding to the information to be updated from the target table data; the first adding unit 403 is configured to add the data to be updated to a list of data to be updated; the determining unit 404 is configured to determine the data participating in updating corresponding to the information of variables participating in updating according to the target table data; the second adding unit 405 is configured to add the data participating in updating to a list of data participating in updating; and the updating unit 406 is configured to update the target table data based on the updated list of data to be updated, the list of data participating in updating and the update mode information.
[0103] Optionally, the information to be updated includes at least one row and column filtering condition.
[0104] Optionally, the reading unit 402 may be further configured to: select table data satisfying the at least one row and column screening condition from the target table data; and determine the selected table data as the data to be updated corresponding to the information to be updated.
[0105] Optionally, the above-mentioned variable information participating in updating includes at least one variable screening information, each variable screening information corresponds to a variable participating in updating, and the above-mentioned variable screening information includes at least one row and column screening condition.
[0106] Optionally, the determination unit 404 can be further configured to: for each variable filtering information in the at least one variable filtering information mentioned above, perform the following steps: select table data that satisfies the at least one row and column filtering condition mentioned above from the target table data; determine the selected table data as variable data corresponding to the variable filtering information mentioned above; determine each determined variable data as participating update data corresponding to the participating update variable information mentioned above.
[0107] Optionally, the information to be updated includes an identifier of a column to be updated.
[0108] Optionally, the update unit 406 can be further configured to: generate table update data according to the above-mentioned update method information and the variable data corresponding to the above-mentioned at least one participating update variable in the updated participating update data list; determine the row and column information to be updated according to the updated list of data to be updated and the above-mentioned column identifier to be updated; and update the above-mentioned table update data to the above-mentioned target table data according to the determined row and column information to be updated.
[0109] Optionally, the above-mentioned variable information involved in updating includes an identifier of a column to be updated.
[0110] Optionally, before updating the above-mentioned table update data to the above-mentioned target table data according to the determined row and column information to be updated, the update unit 406 may also include: an information determination unit (not shown in the figure), which is configured to determine the row and column information to be updated according to the updated list of data to be updated and the column identifier to be updated included in the above-mentioned variable information participating in the update.
[0111] Optionally, the determination unit 404 can be further configured to: in response to determining that the above-mentioned update configuration information includes external table information, determine the participating update variable corresponding to the above-mentioned external table information as an external participating update variable; for each participating update variable among the above-mentioned at least one participating update variable, perform the following steps: in response to determining that the above-mentioned participating update variable is an external participating update variable, determine the table file corresponding to the external table information of the above-mentioned participating update variable as external table data; read variable data corresponding to the above-mentioned participating update variable from the above-mentioned external table data; in response to determining that the above-mentioned participating update variable is not an external participating update variable, read the variable data corresponding to the above-mentioned participating update variable from the above-mentioned target table data; determine each determined variable data as the participating update data corresponding to the above-mentioned participating update variable information.
[0112] It is understandable that the units recorded in the table data updating device 400 and the reference Figure 2 Therefore, the operations, features and beneficial effects described above for the method are also applicable to the table data updating device 400 and the units included therein, and will not be described in detail here.
[0113] Reference below Figure 5 , which shows an electronic device 500 (eg, Figure 1 A schematic diagram of the structure of a server or terminal device in FIG. Figure 5 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.
[0114] like Figure 5As shown, the electronic device 500 may include a processing device 501 (e.g., a central processing unit, a graphics processing unit, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 502 or a program loaded from a storage device 508 into a random access memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the electronic device 500 are also stored. The processing device 501, the ROM 502, and the RAM 503 are connected to each other via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.
[0115] Typically, the following devices may be connected to the I / O interface 505: an input device 506 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 507 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 508 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 509. The communication device 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 5 The electronic device 500 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead. Figure 5 Each block shown in the figure may represent one device, or may represent multiple devices as required.
[0116] In particular, according to some embodiments of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, some embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In some such embodiments, the computer program can be downloaded and installed from the network through the communication device 509, or installed from the storage device 508, or installed from the ROM 502. When the computer program is executed by the processing device 501, the above-mentioned functions defined in the method of some embodiments of the present disclosure are executed.
[0117] It should be noted that the computer-readable medium recorded in some embodiments of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In some embodiments of the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In some embodiments of the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.
[0118] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.
[0119] The computer-readable medium may be included in the electronic device; or it may exist independently without being installed in the electronic device. The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: obtains update configuration information corresponding to the target table data, wherein the update configuration information includes information to be updated, update-participating variable information, and update mode information, wherein the update-participating variable information corresponds to at least one update-participating variable, and the update mode information corresponds to a update-participating variable in the at least one update-participating variable; reads the update data corresponding to the information to be updated from the target table data; adds the update data to the list of data to be updated; determines the update data corresponding to the update variable information according to the target table data; adds the update data to the update-participating data list; updates the target table data based on the updated list of data to be updated, the list of update-participating data, and the update mode information.
[0120] Computer program code for performing the operations of some embodiments of the present disclosure may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0121] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0122] The units described in some embodiments of the present disclosure may be implemented by software or by hardware. The described units may also be provided in a processor, for example, may be described as: a processor including an acquisition unit, a reading unit, a first adding unit, a determination unit, a second adding unit, and an update unit. The names of these units do not, in some cases, constitute limitations on the units themselves, for example, the acquisition unit may also be described as a "unit for acquiring update configuration information corresponding to target table data".
[0123] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chip (SOCs), complex programmable logic devices (CPLDs), and the like.
[0124] Some embodiments of the present disclosure further provide a computer program product, including a computer program, which implements any of the above-mentioned table data updating methods when executed by a processor.
[0125] The above descriptions are only some preferred embodiments of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the embodiments of the present disclosure is not limited to the technical solutions formed by a specific combination of the above-mentioned technical features, but should also cover other technical solutions formed by any combination of the above-mentioned technical features or their equivalent features without departing from the above-mentioned inventive concept. For example, the above-mentioned features are replaced with the technical features with similar functions disclosed in the embodiments of the present disclosure (but not limited to) and the technical solutions formed.
Claims
1. A table data updating method, comprising: Acquire update configuration information corresponding to the target table data, wherein the update configuration information includes information to be updated, update-participating variable information, and update mode information, the update-participating variable information corresponds to at least one update-participating variable, and the update mode information corresponds to a update-participating variable in the at least one update-participating variable; Reading the to-be-updated data corresponding to the to-be-updated information from the target table data; Add the data to be updated to the list of data to be updated; Determine, according to the target table data, participating update data corresponding to the participating update variable information; Adding the participating update data to the participating update data list; The target table data is updated based on the updated list of data to be updated, the list of data participating in updating and the update mode information.
2. The method according to claim 1, wherein: The information to be updated includes at least one row and column screening condition; And the step of reading the data to be updated corresponding to the information to be updated from the target table data comprises: Selecting table data satisfying the at least one row and column screening condition from the target table data; The selected table data is determined as the data to be updated corresponding to the information to be updated.
3. The method according to claim 1, wherein: The update-participating variable information includes at least one variable screening information, each variable screening information corresponds to a participating update variable, and the variable screening information includes at least one row and column screening condition; And the determining, according to the target table data, the participating update data corresponding to the participating update variable information comprises: For each variable screening information in the at least one variable screening information, the following steps are performed: Selecting table data satisfying the at least one row and column screening condition from the target table data; determining the selected table data as variable data corresponding to the variable screening information; The determined variable data are determined as participating update data corresponding to the participating update variable information.
4. The method according to claim 1, wherein: The to-be-updated information includes an identifier of a column to be updated; and the updating of the target table data based on the updated to-be-updated data list, the participating update data list and the update mode information includes: Generate table update data according to the update mode information and each variable data corresponding to the at least one update-participating variable in the updated update-participating data list; Determine the row and column information to be updated according to the updated list of data to be updated and the identifier of the column to be updated; The table update data is updated into the target table data according to the determined row and column information to be updated.
5. The method according to claim 4, wherein: The participating update variable information includes a to-be-updated column identifier; and before updating the table update data into the target table data according to the determined to-be-updated row and column information, updating the target table data based on the updated to-be-updated data list, the participating update data list and the update mode information, further comprising: The row and column information to be updated is determined according to the updated list of data to be updated and the identifier of the column to be updated included in the variable information participating in the update.
6. The method according to claim 1, wherein: The step of determining the update participation data corresponding to the update participation variable information according to the target table data includes: In response to determining that the update configuration information includes external table information, determining the participating update variable corresponding to the external table information as the external participating update variable; For each of the at least one update-participating variable, the following steps are performed: In response to determining that the update-participating variable is an external update-participating variable, determining a table file corresponding to the external table information of the update-participating variable as external table data; Reading variable data corresponding to the variables involved in updating from the external table data; In response to determining that the participating update variable is not an external participating update variable, reading variable data corresponding to the participating update variable from the target table data; The determined variable data are determined as participating update data corresponding to the participating update variable information.
7. A table data updating device, comprising: an acquisition unit, configured to acquire update configuration information corresponding to the target table data, wherein the update configuration information includes information to be updated, update participating variable information and update mode information, the update participating variable information corresponds to at least one update participating variable, and the update mode information corresponds to a update participating variable in the at least one update participating variable; a reading unit, configured to read the to-be-updated data corresponding to the to-be-updated information from the target table data; A first adding unit, configured to add the to-be-updated data to a to-be-updated data list; a determining unit configured to determine, according to the target table data, the participating update data corresponding to the participating update variable information; a second adding unit, configured to add the participating update data to a participating update data list; The updating unit is configured to update the target table data based on the updated list of data to be updated, the list of data participating in updating and the updating mode information.
8. An electronic device, comprising: one or more processors; a storage device having one or more programs stored thereon, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 6.
9. A computer readable medium having a computer program stored thereon, wherein: When the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.
10. A computer program product, comprising a computer program, which, when executed by a processor, implements the method according to any one of claims 1 to 6.