Index data processing method and device and computer equipment

Abstract

The present disclosure relates to the technical field of data processing, and specifically discloses an index data processing method and device and computer equipment. The method comprises: obtaining original index data, processing the original index data by executing a pre-configured database script to obtain processed index data; writing the processed index data into an index database; in response to an index task processing instruction, obtaining a task electronic spreadsheet template corresponding to a task object associated with the index task; according to the task object and a data mapping relationship, reading index data corresponding to the index task from the index database, and writing the read index data into the task electronic spreadsheet template to generate a task electronic spreadsheet instance; and executing pre-configured task execution logic in the task electronic spreadsheet instance to obtain a task execution result. The present disclosure improves the index data reading and writing efficiency and meets the processing needs of personalized index tasks.

Description

Technical Field

[0001] This disclosure relates to the field of data processing technology, and in particular to a method, apparatus and computer equipment for processing indicator data. Background Technology

[0002] With the rapid development of the global economy and science and technology, information technology and internet technology have also developed extremely quickly, propelling data into the era of big data. Data processing permeates all areas of social production and life. The development of data processing technology and the breadth and depth of its applications have greatly influenced the progress of human society, especially in scenarios involving multi-dimensional processing of data according to different data characteristics (such as indicators).

[0003] In related technologies, when processing large-scale data according to data indicators and further processing the indicator data, there are often many types of indicators and different statistical methods for various indicator data. Moreover, after obtaining the indicator data, the processing methods for indicator data are also different due to the different sources and characteristics of the indicator data, resulting in low processing efficiency and difficulty in adapting to large-scale, multi-feature indicator data processing scenarios. Summary of the Invention

[0004] Therefore, it is necessary to provide a method, apparatus, computer equipment, storage medium, and computer program product for processing indicator data to address the aforementioned technical problems.

[0005] Firstly, this disclosure provides a method for processing indicator data. The method includes:

[0006] Obtain raw indicator data, and process the raw indicator data by executing a pre-configured database script to obtain processed indicator data;

[0007] Write the processed indicator data into the indicator database;

[0008] In response to the indicator task processing instruction, obtain the task spreadsheet template corresponding to the task object associated with the indicator task;

[0009] Based on the task object and the data mapping relationship, the indicator data corresponding to the indicator task is read from the indicator database, and the read indicator data is written into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database;

[0010] Execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution result.

[0011] In one embodiment, the process of obtaining raw indicator data involves processing the raw indicator data by executing a pre-configured database script to obtain processed indicator data.

[0012] Subscribe to raw indicator data associated with indicator tasks, and store the subscribed raw indicator data in a processing database; the processing database is configured with the database scripts.

[0013] The database script is traversed and executed to generate indicator data; the processed indicator data includes indicator data records with task object number and task time as keys;

[0014] The indicator data records are inserted into the indicator database.

[0015] In one embodiment, the method further includes:

[0016] Obtain the association configuration information between the task spreadsheet template and the task object, and establish the correspondence between the task spreadsheet template and the task object based on the association configuration information;

[0017] Obtain the mapping configuration information between the task spreadsheet template and the indicator database, and establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information.

[0018] In one embodiment, the mapping configuration information includes several mapping relationship records, which at least include the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database.

[0019] In one embodiment, the method further includes:

[0020] Receive updated spreadsheet files for task spreadsheet templates or task spreadsheet instances;

[0021] If the spreadsheet update file meets the permission rules, the spreadsheet update file becomes effective and generates a transaction record; the transaction record includes a copy of the spreadsheet update file.

[0022] In one embodiment, executing the pre-configured task execution logic in the task spreadsheet instance and obtaining the task execution result includes:

[0023] Extract the first row of data from the task spreadsheet instance, and parse the first row of data to obtain the calculation rule template;

[0024] According to the calculation rule template, the calculation formula is adaptively written into the task spreadsheet instance based on the row number;

[0025] The task execution result is obtained by calculating and processing the indicator data in the task spreadsheet instance according to the calculation formula.

[0026] The task execution results are entered into the task spreadsheet instance to obtain the task result file.

[0027] In one embodiment, the method further includes:

[0028] Read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

[0029] Secondly, this disclosure also provides an indicator data processing apparatus. The apparatus includes:

[0030] The data processing module is used to acquire raw indicator data and process the raw indicator data by executing a pre-configured database script to obtain processed indicator data.

[0031] The indicator database module is used to write the processed indicator data into the indicator database;

[0032] The task instruction module is used to respond to the indicator task processing instruction and obtain the task spreadsheet template corresponding to the task object associated with the indicator task.

[0033] The task spreadsheet module is used to read the indicator data corresponding to the indicator task from the indicator database according to the task object and the data mapping relationship, and write the read indicator data into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database;

[0034] The task results module is used to execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution results.

[0035] In one embodiment, the data processing module includes:

[0036] A subscription unit is used to subscribe to raw indicator data associated with indicator tasks and store the subscribed raw indicator data in a processing database; the processing database is configured with the database script.

[0037] The script execution unit is used to traverse and execute the database scripts to generate indicator data; the processed indicator data includes indicator data records with task object number and task time as keys;

[0038] The record insertion unit is used to insert the indicator data record into the indicator database.

[0039] In one embodiment, the device further includes:

[0040] The association configuration module is used to obtain the association configuration information between the task spreadsheet template and the task object, and to establish the correspondence between the task spreadsheet template and the task object based on the association configuration information;

[0041] The mapping configuration module is used to obtain the mapping configuration information between the task spreadsheet template and the indicator database, and to establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information.

[0042] In one embodiment, the mapping configuration information includes several mapping relationship records, which at least include the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database.

[0043] In one embodiment, the device further includes:

[0044] The update file module is used to receive update files for task spreadsheet templates or task spreadsheet instances.

[0045] The update activation module is used to activate the spreadsheet update file and generate a transaction record when the spreadsheet update file meets the permission rules; the transaction record includes a copy of the spreadsheet update file.

[0046] In one embodiment, the task result module includes:

[0047] The calculation extraction unit is used to extract the first row of data from the task spreadsheet instance and parse the first row of data to obtain a calculation rule template;

[0048] The formula writing unit is used to adaptively write calculation formulas into the task spreadsheet instance according to the row number based on the calculation rule template.

[0049] The calculation execution unit is used to calculate and process the indicator data in the task spreadsheet instance according to the calculation formula to obtain the task execution result;

[0050] The result writing unit is used to fill the task execution result into the task spreadsheet instance to obtain the task result file.

[0051] In one embodiment, the indicator database module is further configured to read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

[0052] Thirdly, this disclosure also provides a computer device. The computer device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the steps of the above-described indicator data processing method.

[0053] Fourthly, this disclosure also provides a computer-readable storage medium. The computer-readable storage medium stores a computer program thereon, which, when executed by a processor, implements the steps of the above-described indicator data processing method.

[0054] Fifthly, this disclosure also provides a computer program product. The computer program product includes a computer program that, when executed by a processor, implements the steps of the above-described indicator data processing method.

[0055] The above-mentioned data processing methods, apparatus, computer equipment, storage media, and computer program products shall have at least the following beneficial effects:

[0056] This disclosure, on the one hand, processes the acquired raw indicator data to obtain indicator data and stores it in an indicator database. On the other hand, by responding to indicator task processing instructions, it determines the corresponding task spreadsheet template based on the task object. Then, based on the data mapping relationship, it can accurately and quickly write the indicator data required by the indicator task from the indicator database into the task spreadsheet template, and enable the task spreadsheet template to execute task execution logic for the task object, ultimately obtaining the task execution result. This not only greatly improves the efficiency of reading and writing indicator data, but also standardizes the indicator task processing process and improves processing efficiency by executing indicator tasks more intuitively and traversally through the task spreadsheet template. At the same time, the correspondence between the task spreadsheet template and the task object meets the personalized indicator task processing needs, improving processing accuracy and flexibility. Attached Figure Description

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

[0058] Figure 1 This is an application environment diagram of the indicator data processing method in one embodiment;

[0059] Figure 2 This is an application environment diagram of the step of obtaining indicator data in one embodiment;

[0060] Figure 3 This is an application environment diagram of the steps for obtaining task execution results in one embodiment;

[0061] Figure 4 This is a flowchart illustrating an indicator data processing method in one embodiment;

[0062] Figure 5 This is a flowchart illustrating the steps for obtaining indicator data in one embodiment;

[0063] Figure 6 This is a flowchart illustrating the steps for obtaining configuration information in one embodiment;

[0064] Figure 7 This is a flowchart illustrating the steps for updating file configuration in one embodiment;

[0065] Figure 8 This is a flowchart illustrating the steps for obtaining task execution results in one embodiment;

[0066] Figure 9 This is a structural block diagram of an indicator data processing device in one embodiment;

[0067] Figure 10 This is a structural block diagram of the data processing module in one embodiment;

[0068] Figure 11 This is a structural block diagram of the indicator data processing device in another embodiment;

[0069] Figure 12 This is a structural block diagram of the indicator data processing device in another embodiment;

[0070] Figure 13 Here is a structural block diagram of the task result module in one embodiment;

[0071] Figure 14 This is a block diagram of the internal structure of a computer device in one embodiment. Detailed Implementation

[0072] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0073] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs. The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of this disclosure.

[0074] The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this disclosure. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this disclosure as detailed in the appended claims. The terms "comprising," "including," or any other variations thereof are intended to cover a non-exclusive inclusion, such that a process, method, product, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, product, or apparatus. Without further limitation, the presence of additional identical or equivalent elements in a process, method, product, or apparatus that includes said elements is not excluded. For example, the use of terms such as "first," "second," etc., is to denote names and does not indicate any particular order.

[0075] When used herein, the singular forms of “a,” “an,” and “the” may also include the plural forms unless the context clearly indicates otherwise. It should also be understood that the terms “comprising / including” or “having,” etc., specify the presence of the stated features, wholes, steps, operations, components, parts, or combinations thereof, but do not preclude the possibility of the presence or addition of one or more other features, wholes, steps, operations, components, parts, or combinations thereof. Meanwhile, in this specification, the term “and / or” includes any and all combinations of the associated listed items.

[0076] As mentioned in the background, in scenarios involving large-scale, multi-feature indicator data processing, there are often limitations such as low processing efficiency and difficulty in flexibly configuring the data according to the needs of the scenario. Taking the performance appraisal scenario in human resources as an example, this paper illustrates the indicator data processing method disclosed herein.

[0077] The indicator data processing method provided in this disclosure can be applied to, for example... Figure 1In the application environment shown, the indicator task system 100 communicates with external business systems 102 and clients 103 and 104 via a network. The indicator task system 100 can receive raw indicator data related to performance appraisal (indicator tasks) generated by the business systems. The indicator task system 100 includes an external data subscription module 104, an indicator processing and storage module 106, a file management module 108, a mapping configuration module 110, a mapping read / write module 112, a performance evaluation plan module 114, an operation review module 116, a comprehensive query module 118, a performance template management module 120, an operation flow module 122, a template formula calculation module 124, a performance import / export module 126, and a performance analysis module 128.

[0078] Specifically, in combination Figure 2 As shown, the external data subscription module 104 is used to interact with the business system 102, obtaining raw indicator data related to performance evaluation through subscription. The external data subscription module 104 can import the subscribed raw indicator data into the processing database, which is deployed with database scripts.

[0079] The indicator processing and storage module 106 executes a pre-configured database script to read and process the raw indicator data from the processing database 130, thereby calculating the indicator data. The indicator data in this embodiment can be used to characterize user performance data. The indicator processing and storage module 106 can then store the obtained indicator data into the indicator database.

[0080] File management module 108 provides file storage management capabilities for the indicator task system 100. File management module 108 can implement its functionality by manipulating object storage. Object storage, commonly used for object-based storage, is a general term used to describe methods for solving and processing discrete units, which are called objects. Objects do not have further hierarchical structures within a single layer. Each object resides at the same level in a flat address space called a storage pool; one object does not belong to a lower level of another object. Storing objects can store task spreadsheet template files.

[0081] The mapping configuration module 110 is used to receive configuration instructions from the client 103 and configure the data mapping relationship between the task spreadsheet template and the indicator database. Each mapping relationship record includes at least four key pieces of information: (1) the page name in the task spreadsheet template where the indicator data is located; (2) the field name in the task spreadsheet template where the indicator data is located; (3) the data table name in the indicator database where the indicator data is located; and (4) the field name in the indicator database where the indicator data is located.

[0082] The mapping read / write module 112 is used to write indicator data from the indicator database to the task spreadsheet template and write indicator data or task execution result data from the task spreadsheet instance to the indicator database according to the data mapping relationship between the task spreadsheet template and the indicator database.

[0083] Combination Figure 3 As shown, the performance evaluation plan module 114 is used to initiate performance evaluation tasks (indicator tasks) at preset intervals according to the configuration instructions of the client 103.

[0084] The operation review module 116 is used to enable the client 103 to modify the association configuration information between the task spreadsheet template and the task object, the mapping configuration information between the indicator database and the task spreadsheet template, or the task spreadsheet template. The operation review module 116 can review the modification permissions and make the modification instructions of the client 103 with administrator privileges effective.

[0085] The comprehensive query module 118 is used to provide the client 103 with query services such as raw indicator data query, indicator data query, and task execution result data query.

[0086] The performance template management module 120 provides management functions for task spreadsheet templates to the client 103. It can execute corresponding actions based on a series of commands from the client 103, such as uploading, modifying, and deleting task spreadsheet templates and their associated configuration information. The performance template management module 120 can also manage the task cycle information of the task spreadsheet templates. The performance template management module 120 can upload the finalized task spreadsheet template file to the file management module 108, which then stores the template file in object storage.

[0087] The operation log module 122 records the operation log of spreadsheet update files uploaded by client 103. Client 103 can upload spreadsheet update files, which can be update files for task spreadsheet templates or task spreadsheet instances including indicator data. When the spreadsheet update file is for a task spreadsheet template, it is used as a new task spreadsheet template, changing the calculation formulas of the task spreadsheet template. When the spreadsheet update file is for a task spreadsheet instance, it is used to modify the indicator data in the task spreadsheet instance. When the operation log module 122 receives a spreadsheet update file, the operation approval module 116 can approve the modification permissions of the client 103 account that uploaded the spreadsheet update file. If the permission requirements are met, the spreadsheet update file is made effective, and a copy of the spreadsheet update file is created, which can be named with the operation log number.

[0088] The template formula calculation module 124 is used in the assessment task to extract the first row of each page in the task spreadsheet instance, use it as the column feature of the formula, generate a calculation formula template, and fill the calculation formula into the valid rows of the task spreadsheet template. The calculation formula can be automatically filled according to the row number of the task spreadsheet template, realizing the formula drop-down function. After the filling is completed, the template formula calculation module 124 triggers the calculation of all the calculation formulas in the task spreadsheet template to obtain the assessment result data.

[0089] The performance import / export module 126 is used to import and export task execution results, allowing the client 103 to query task execution results based on keywords such as task time and task object.

[0090] The performance analysis module 128 is used to analyze the results of task execution. It can display the task execution results, task rankings, historical comparison information, etc. through graphical and tabular methods.

[0091] The client 103 can be, but is not limited to, various personal computers, laptops, smartphones, tablets, etc. The indicator task system 100 can be implemented using a standalone server or a server cluster consisting of multiple servers.

[0092] In some embodiments of this disclosure, such as Figure 4 As shown, a method for processing indicator data is provided, which can be applied to... Figure 1 Taking the indicator task system as an example, the following steps are included:

[0093] Step 410: Obtain the raw indicator data, and process the raw indicator data by executing a pre-configured database script to obtain the processed indicator data.

[0094] Indicators typically refer to the overall quantitative characteristics of a population. For example, in a human resources performance appraisal scenario, the total number of sales personnel, their sales revenue, and performance can be used as indicators, all of which reflect the overall quantitative characteristics from various perspectives.

[0095] For example, according to a preset cycle, the indicator task system can periodically obtain raw indicator data from the business system. Raw indicator data can refer to indicator-related data generated daily by the business system. For instance, in a human resources performance appraisal scenario, raw indicator data might include sales records from sales personnel. After obtaining the raw indicator data, database scripts can be executed to process, summarize, and calculate the raw indicator data. For example, based on the sales records of sales personnel, the total sales amount and performance of the sales personnel can be calculated, resulting in processed indicator data.

[0096] Step 420: Write the processed indicator data into the indicator database.

[0097] For example, the indicator task system can store the obtained indicator data in an indicator database.

[0098] Step 430: Respond to the indicator task processing instruction and obtain the task spreadsheet template corresponding to the task object associated with the indicator task.

[0099] For example, the indicator task system can respond to indicator task processing instructions after receiving them. Indicator task processing instructions can be initiated automatically and periodically by the indicator task system, or they can be initiated upon receiving instructions from the client. Indicator task processing instructions can include indicator task information, such as the task object and task time. The indicator task processing instructions can determine the task object associated with the indicator task, and further, obtain the corresponding task spreadsheet template based on the task object. The task spreadsheet template can correspond to the task object; it can also correspond to a specific attribute of the task object, such as the task object's level. The task spreadsheet template can be a pre-defined spreadsheet template file (e.g., an Excel file) used to populate indicator data and adapt to it. Here, an indicator task can refer to a task that processes indicator data according to pre-configured task execution logic, such as a performance appraisal task.

[0100] Step 440: Based on the task object and the data mapping relationship, read the indicator data corresponding to the indicator task from the indicator database, and write the read indicator data into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database.

[0101] For example, the data mapping relationship can characterize the data mapping relationship between the task spreadsheet template and the indicator database, including the mapping information of data fields and the mapping information of data storage locations. Based on the task objects involved in the indicator task and the data mapping relationship, the indicator data corresponding to the indicator task (e.g., indicator data involving task objects) can be read from the indicator database and written to the corresponding location in the task spreadsheet template. After the indicator data is written, the task spreadsheet template can generate a task spreadsheet instance for that indicator task.

[0102] Step 450: Execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution result.

[0103] For example, after generating a task spreadsheet instance, the indicator data in the task spreadsheet instance is processed according to the pre-configured task execution logic. For example, the indicator data can be calculated using a calculation formula to obtain the task execution result.

[0104] In the aforementioned indicator data processing method, on the one hand, the acquired raw indicator data is processed to obtain indicator data, which is then stored in an indicator database. On the other hand, by responding to indicator task processing instructions, a task spreadsheet template corresponding to the task object is determined based on the task object. Then, based on the data mapping relationship, the indicator data required by the indicator task can be accurately and quickly written from the indicator database to the task spreadsheet template. The task spreadsheet template then executes the task execution logic for the task object, ultimately obtaining the task execution result. This not only greatly improves the efficiency of reading and writing indicator data, but also standardizes the indicator task processing process and improves processing efficiency by executing indicator tasks more intuitively and traversally through the task spreadsheet template. At the same time, the task spreadsheet template corresponds to the task object, meeting the personalized indicator task processing needs and improving processing accuracy and flexibility.

[0105] In some embodiments of this disclosure, such as Figure 5 As shown, step 410 includes:

[0106] Step 412: Subscribe to the raw indicator data associated with the indicator task, and store the subscribed raw indicator data in the processing database; the processing database is deployed with the database script.

[0107] For example, raw indicator data associated with an indicator task can be obtained through subscription. This associated data can be the source data of the indicator data involved in the execution and processing of the indicator task. The subscription method can be a periodic, scheduled subscription or a subscription triggered by data updates from the business system. After subscribing to the raw indicator data, it can be stored in a processing database, which has database scripts pre-deployed.

[0108] Step 414: Iterate through and execute the database scripts to generate indicator data; the indicator data includes indicator data records with task object number and task time as keywords.

[0109] Step 416: Insert the indicator data record into the indicator database.

[0110] For example, by traversing and executing the database scripts of the processing database, the raw indicator data is calculated and processed to generate several indicator data records with task object number and task time as keys. These generated indicator data records are then inserted into the indicator database for storage.

[0111] In this embodiment, a processing database is used as a buffer, and the original indicator data is processed by a database script to obtain the indicator data. This standardizes the process of processing indicator data and allows the indicator data to be searched and located by keywords.

[0112] In some embodiments of this disclosure, such as Figure 6 As shown, the method further includes:

[0113] Step 402: Obtain the association configuration information between the task spreadsheet template and the task object, and establish the correspondence between the task spreadsheet template and the task object based on the association configuration information.

[0114] For example, the indicator task system can receive association configuration information between task spreadsheet templates and task objects through a client. This association configuration information includes at least the correspondence between task spreadsheet templates and task objects; for example, a task spreadsheet template can be associated one-to-one with a task object, or it can be associated one-to-one with a specific type of task object. The indicator task system can configure the correspondence between task spreadsheet templates and task objects based on this association configuration information.

[0115] Step 404: Obtain the mapping configuration information between the task spreadsheet template and the indicator database, and establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information.

[0116] For example, the indicator task system can receive mapping configuration information between the task spreadsheet template and the indicator database through a client. This mapping configuration information includes at least the data mapping information between the task spreadsheet template and the indicator database, such as the mapping relationship between data fields and storage locations of indicator data within the task spreadsheet template and within the indicator data itself. The indicator task system can configure the data mapping relationship between the task spreadsheet template and the indicator database based on this mapping configuration information.

[0117] This embodiment can obtain the association configuration information and mapping configuration information sent by the client, and then configure the correspondence between the task spreadsheet template and the task object according to the association configuration information, and configure the data mapping relationship between the task spreadsheet template and the indicator database according to the mapping configuration information. This makes the task spreadsheet template highly adaptable to the task object and the indicator database, greatly improving adaptability and flexibility.

[0118] In some embodiments of this disclosure, the mapping configuration information includes several mapping relationship records. Each mapping relationship record includes at least the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database. That is, each mapping relationship record includes at least four key pieces of information: (1) the page name of the task spreadsheet template containing the indicator data; (2) the field name of the task spreadsheet template containing the indicator data; (3) the data table name of the indicator data in the indicator database; and (4) the field name of the indicator data in the indicator database. This helps to accurately and quickly locate the indicator data in the task spreadsheet template and the indicator database.

[0119] In some embodiments of this disclosure, such as Figure 7 As shown, the method further includes:

[0120] Step 406: Receive the updated spreadsheet file of the task spreadsheet template or task spreadsheet instance.

[0121] For example, the indicator task system can receive spreadsheet update files for task spreadsheet templates or task spreadsheet instances via a client. When the update file is for a task spreadsheet template, it serves as the new template, changing the calculation formulas within that template. When the update file is for a task spreadsheet instance, it modifies the indicator data within that instance.

[0122] Step 408: If the spreadsheet update file meets the permission rules, the spreadsheet update file becomes effective and a transaction record is generated; the transaction record includes a copy of the spreadsheet update file.

[0123] For example, after receiving an updated spreadsheet file uploaded by a client, the indicator task system can verify the permissions of the client account that sent the file. It determines whether the client account meets the set permission rules. If the updated spreadsheet file meets the permission rules, it makes the updated file effective, serving as an official task spreadsheet template or instance, and generates a corresponding transaction record. The transaction record includes a copy of the updated spreadsheet file, and the copy file's name can be a serial number.

[0124] This embodiment supports client updates to task spreadsheet templates and task spreadsheet instances by uploading updated spreadsheet files. Permission verification is performed on the updated spreadsheet files to ensure their secure activation. Furthermore, a log record is generated for each updated spreadsheet file, facilitating data traceability and ensuring data stability.

[0125] In some embodiments of this disclosure, such as Figure 8 As shown, step 450 includes:

[0126] Step 452: Extract the first row of data from the task spreadsheet instance, and parse the first row of data to obtain the calculation rule template.

[0127] For example, after generating a task spreadsheet instance, the indicator task system can execute pre-configured task execution logic on the task spreadsheet instance. Target rows of the task spreadsheet instance can be extracted; these target rows are data header rows used to characterize the features or attributes of the indicator data in the corresponding columns. The target rows are typically the first row of the task spreadsheet template. After extracting the first row of data from the task spreadsheet instance, the first row is parsed, and the columns are used as calculation factors to obtain the calculation rule template corresponding to the task spreadsheet instance. The calculation rule template may include calculation formulas. Optionally, in some embodiments, similarly, the first column of data in the task spreadsheet instance can also be extracted, and the rows can be used as calculation factors to obtain the calculation rule template corresponding to the task spreadsheet instance.

[0128] Step 454: Write the calculation formula into the task spreadsheet instance according to the row number based on the calculation rule template.

[0129] For example, calculation formulas are written into the valid rows of the task spreadsheet instance according to the determined calculation rule template. The calculation formulas can be automatically filled in based on the row numbers of the task spreadsheet template, realizing a formula drop-down function. Here, a valid row can refer to a row in the task spreadsheet instance where there are no missing or abnormal rows.

[0130] Step 456: Calculate and process the indicator data in the task spreadsheet instance according to the calculation formula to obtain the task execution result.

[0131] For example, after the calculation formula is filled in, the indicator data in the task spreadsheet instance is calculated according to the calculation formula to obtain the task execution result.

[0132] Step 458: Fill the task execution results into the task spreadsheet instance to obtain the task result file.

[0133] For example, the calculated task execution results can be filled into the corresponding position in the task spreadsheet instance to obtain the task result file.

[0134] This embodiment extracts and analyzes the data in the first row of a task spreadsheet instance to determine the calculation rule template corresponding to the task spreadsheet instance, thereby obtaining a calculation formula applicable to the task spreadsheet instance. This allows for rapid calculation of the task spreadsheet instance and the resulting task execution.

[0135] In some embodiments of this disclosure, the method further includes:

[0136] Read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

[0137] For example, the metrics database is used not only to store metric data but also to store task execution results. The data mapping relationship also includes the data mapping relationship between task execution results and the metrics database. After a task spreadsheet instance generates a task result file, the metrics task system can read the task execution results from the task result file and store them in the metrics database.

[0138] This embodiment reads the task execution results from the task result file and stores them in the indicator database, which can quickly store the task execution results and facilitate subsequent location and query.

[0139] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0140] Based on the same inventive concept, this disclosure also provides an indicator data processing apparatus for implementing the indicator data processing method described above. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more indicator data processing apparatus embodiments provided below can be found in the limitations of the indicator data processing method described above, and will not be repeated here.

[0141] In some embodiments of this disclosure, such as Figure 9 As shown, an indicator data processing device is provided. The device 900 includes:

[0142] The data processing module 910 is used to acquire raw indicator data and process the raw indicator data by executing a pre-configured database script to obtain processed indicator data.

[0143] The indicator database module 920 is used to write the processed indicator data into the indicator database;

[0144] The task instruction module 930 is used to respond to the indicator task processing instruction and obtain the task spreadsheet template corresponding to the task object associated with the indicator task.

[0145] The task spreadsheet module 940 is used to read the indicator data corresponding to the indicator task from the indicator database according to the task object and the data mapping relationship, and write the read indicator data into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database;

[0146] The task result module 950 is used to execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution result.

[0147] In some embodiments of this disclosure, such as Figure 10 As shown, the data processing module 910 includes:

[0148] The subscription unit 912 is used to subscribe to raw indicator data associated with the indicator task and store the subscribed raw indicator data in the processing database; the processing database is deployed with the database script.

[0149] The script execution unit 914 is used to traverse and execute the database scripts to generate indicator data; the processed indicator data includes indicator data records with task object number and task time as keys;

[0150] The record insertion unit 916 is used to insert the indicator data record into the indicator database.

[0151] In some embodiments of this disclosure, such as Figure 11 As shown, the device 900 further includes:

[0152] The association configuration module 960 is used to obtain the association configuration information between the task spreadsheet template and the task object, and to establish the correspondence between the task spreadsheet template and the task object based on the association configuration information;

[0153] The mapping configuration module 970 is used to obtain the mapping configuration information between the task spreadsheet template and the indicator database, and to establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information.

[0154] In some embodiments of this disclosure, the mapping configuration information includes several mapping relationship records, and the mapping relationship records include at least the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database.

[0155] In some embodiments of this disclosure, such as Figure 12 As shown, the device 900 further includes:

[0156] The update file module 980 is used to receive the update file of the task spreadsheet template or task spreadsheet instance;

[0157] The update activation module 990 is used to activate the spreadsheet update file and generate a transaction record when the spreadsheet update file meets the permission rules; the transaction record includes a copy of the spreadsheet update file.

[0158] In some embodiments of this disclosure, such as Figure 13 As shown, the task result module 950 includes:

[0159] The calculation extraction unit 952 is used to extract the first row of data of the task spreadsheet instance and parse the first row of data to obtain the calculation rule template;

[0160] Formula writing unit 954 is used to automatically write calculation formulas into the task spreadsheet instance according to the row number based on the calculation rule template.

[0161] The calculation execution unit 956 is used to calculate and process the indicator data in the task spreadsheet instance according to the calculation formula to obtain the task execution result;

[0162] The result writing unit 958 is used to fill the task execution result into the task spreadsheet instance to obtain the task result file.

[0163] In some embodiments of this disclosure, the indicator database module is further configured to read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

[0164] Each module in the aforementioned indicator data processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device in hardware form, or stored in the memory of a computer device in software form, so that the processor can call and execute the operations corresponding to each module. It should be noted that the module division in this embodiment is illustrative and only represents one logical functional division; in actual implementation, other division methods may be used.

[0165] Based on the aforementioned embodiments of the indicator data processing method, in another embodiment provided in this disclosure, a computer device is provided. This computer device may be a server, and its internal structure diagram may be as follows: Figure 14As shown, this computer device includes a processor, memory, input / output interfaces (I / O), and a communication interface. The processor, memory, and I / O interfaces are connected via a system bus, and the communication interface is also connected to the system bus via the I / O interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides the environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores data. The I / O interfaces are used for exchanging information between the processor and external devices. The communication interface is used for communicating with external terminals via a network connection. When the computer program is executed by the processor, it implements a method for processing index data.

[0166] Those skilled in the art will understand that Figure 14 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0167] Based on the aforementioned embodiments of the indicator data processing method, in another embodiment provided in this disclosure, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, it implements the steps in the above-described method embodiments.

[0168] Based on the aforementioned embodiments of the indicator data processing method, in another embodiment provided in this disclosure, a computer program product is provided, including a computer program that, when executed by a processor, implements the steps in the above-described method embodiments.

[0169] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0170] In the description of this specification, references to terms such as "some embodiments," "other embodiments," and "ideal embodiments" indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. In this specification, the illustrative descriptions of the above terms do not necessarily refer to the same embodiments or examples.

[0171] It is understood that the various embodiments of the methods described in this specification are presented in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on its differences from other embodiments. Relevant details can be found in the descriptions of other method embodiments.

[0172] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features of the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0173] The embodiments described above are merely illustrative of several implementations of this disclosure, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of the patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this disclosure, and these all fall within the scope of protection of this disclosure. Therefore, the scope of protection of this patent should be determined by the appended claims.

Claims

1. A method for processing indicator data, characterized in that, The method includes: Obtain raw indicator data, and process the raw indicator data by executing a pre-configured database script to obtain processed indicator data; Write the processed indicator data into the indicator database; In response to the indicator task processing instruction, obtain the task spreadsheet template corresponding to the task object associated with the indicator task; Based on the task object and the data mapping relationship, the indicator data corresponding to the indicator task is read from the indicator database, and the read indicator data is written into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database; Execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution result; The process of obtaining raw indicator data, which involves processing the raw indicator data by executing a pre-configured database script to obtain processed indicator data, includes: Subscribe to raw indicator data associated with indicator tasks, and store the subscribed raw indicator data in a processing database; the processing database is configured with the database scripts. The database script is traversed and executed to generate indicator data; the processed indicator data includes indicator data records with task object number and task time as keys; Insert the aforementioned indicator data records into the indicator database; The method further includes: Obtain the association configuration information between the task spreadsheet template and the task object, and establish the correspondence between the task spreadsheet template and the task object based on the association configuration information; Obtain the mapping configuration information between the task spreadsheet template and the indicator database, and establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information; The execution of the pre-configured task execution logic in the task spreadsheet instance, and the acquisition of the task execution result, include: Extract the first row of data from the task spreadsheet instance, and parse the first row of data to obtain the calculation rule template; According to the calculation rule template, the calculation formula is adaptively written into the task spreadsheet instance based on the row number; The task execution result is obtained by calculating and processing the indicator data in the task spreadsheet instance according to the calculation formula. The task execution results are entered into the task spreadsheet instance to obtain the task result file.

2. The method according to claim 1, characterized in that, The mapping configuration information includes several mapping relationship records. Each mapping relationship record includes at least the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database.

3. The method according to claim 1, characterized in that, The method further includes: Receive updated spreadsheet files for task spreadsheet templates or task spreadsheet instances; If the spreadsheet update file meets the permission rules, the spreadsheet update file becomes effective and generates a transaction record; the transaction record includes a copy of the spreadsheet update file.

4. The method according to claim 1, characterized in that, The method further includes: Read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

5. An indicator data processing device, characterized in that, The device includes: The data processing module is used to acquire raw indicator data and process the raw indicator data by executing a pre-configured database script to obtain processed indicator data. The indicator database module is used to write the processed indicator data into the indicator database; The task instruction module is used to respond to the indicator task processing instruction and obtain the task spreadsheet template corresponding to the task object associated with the indicator task. The task spreadsheet module is used to read the indicator data corresponding to the indicator task from the indicator database according to the task object and the data mapping relationship, and write the read indicator data into the task spreadsheet template to generate a task spreadsheet instance; the data mapping relationship includes the pre-configured data fields and data storage location relationship between the task spreadsheet template and the indicator database; The task results module is used to execute the pre-configured task execution logic in the task spreadsheet instance and obtain the task execution results; The data processing module includes: A subscription unit is used to subscribe to raw indicator data associated with indicator tasks and store the subscribed raw indicator data in a processing database; the processing database is configured with the database script. The script execution unit is used to traverse and execute the database scripts to generate indicator data; the processed indicator data includes indicator data records with task object number and task time as keys; A record insertion unit is used to insert the indicator data record into the indicator database; The device further includes: The association configuration module is used to obtain the association configuration information between the task spreadsheet template and the task object, and to establish the correspondence between the task spreadsheet template and the task object based on the association configuration information; The mapping configuration module is used to obtain the mapping configuration information between the task spreadsheet template and the indicator database, and to establish a data mapping relationship between the task spreadsheet template and the indicator database based on the mapping configuration information. The task result module includes: The calculation extraction unit is used to extract the first row of data from the task spreadsheet instance and parse the first row of data to obtain a calculation rule template; The formula writing unit is used to adaptively write calculation formulas into the task spreadsheet instance according to the row number based on the calculation rule template. The calculation execution unit is used to calculate and process the indicator data in the task spreadsheet instance according to the calculation formula to obtain the task execution result; The result writing unit is used to fill the task execution result into the task spreadsheet instance to obtain the task result file.

6. The apparatus according to claim 5, characterized in that, The mapping configuration information includes several mapping relationship records. Each mapping relationship record includes at least the page name and field name of the indicator data in the task spreadsheet template, and the data table name and field name of the indicator data in the indicator database.

7. The apparatus according to claim 5, characterized in that, The device further includes: The update file module is used to receive update files for task spreadsheet templates or task spreadsheet instances. The update activation module is used to activate the spreadsheet update file and generate a transaction record when the spreadsheet update file meets the permission rules; the transaction record includes a copy of the spreadsheet update file.

8. The apparatus according to claim 5, characterized in that, The indicator database module is also used for: Read the task execution results from the task result file and store the task execution results in the indicator database according to the data mapping relationship.

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

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

Images