Online index algorithm editing and debugging method, electronic equipment and storage medium

Abstract

The invention relates to the technical field of software information, and provides an index algorithm online editing and debugging method, electronic equipment and a storage medium, and the method comprises the steps: building a table for storing index algorithms; displaying the stored index algorithm through a table; performing parameter configuration on the index algorithm; and the index algorithm is debugged and stored for subsequent use. According to the scheme, the stored index algorithm is displayed through the table, the index algorithm is configured, and the index algorithm is configured and debugged, so that the efficiency of newly adding the index algorithm is effectively improved, the difficulty of index debugging is greatly reduced, and an enterprise can be conveniently applied to various informatization function systems.

Description

Technical Field

[0001] The present application relates to the field of software information technology, and in particular to an online editing and debugging method for an indicator algorithm, an electronic device and a storage medium. Background Art

[0002] When companies need to decide on an event, they often need to develop scientific indicator algorithms for evaluation. For example, companies often use OKR (Objectives and Key Results) to evaluate employees' work. OKR, or Objectives and Key Results, is a set of management tools and methods for defining and tracking goals and their completion. Key results are presented in the form of quantitative indicators to measure whether the goals have been achieved at the end of the period. In order to display the results of indicators, the program needs to develop a large number of indicator algorithms to display the indicator results by calculating the existing data. At this time, an indicator algorithm system with high setting efficiency and low operation difficulty is needed.

[0003] The indicator algorithms on the market are basically pre-written in the code program. When adding or modifying the indicator algorithm, the program must be modified; the results after the indicator calculation are inaccurate, and users cannot troubleshoot and debug the algorithm. Therefore, how to improve the efficiency of adding indicators and reduce the difficulty of indicator debugging is a technical problem that needs to be solved urgently. Summary of the invention

[0004] In order to help improve the problems of low debugging efficiency and difficult operation of existing indicator algorithms, the present application provides an indicator algorithm online editing and debugging method, electronic device and storage medium.

[0005] In a first aspect, the present application provides an online editing and debugging method for an indicator algorithm, the method comprising:

[0006] Create a table to store indicator algorithms;

[0007] Display the stored indicator algorithm through a table;

[0008] Configure parameters for indicator algorithms;

[0009] Debug the indicator algorithm and save it for subsequent use.

[0010] Furthermore, when the stored indicator algorithm is displayed through a table: the indicator algorithm data stored in the database is displayed through a web interface to add, delete or modify the indicator algorithm.

[0011] Furthermore, the process of configuring the indicator algorithm includes:

[0012] The indicator algorithm sql statement is displayed through the interface; an indicator algorithm is selected for editing, and the indicator algorithm sql statement is displayed; when the calculation result of the indicator algorithm is a percentage type, the numerator and denominator sql statements of the indicator algorithm are displayed.

[0013] Configure the required parameters of the indicator algorithm. Write the indicator algorithm sql statement, configure the parameters and parameter types; after the configuration of the parameters is completed, load the values ​​of the above parameters used in the historical algorithm for the user to debug the indicator algorithm.

[0014] Furthermore, when debugging the indicator algorithm: according to the parameter type, the interface dynamically renders and loads the parameters used in the sql algorithm; when the parameter is of time type, the time space can select the start and end time, and format the time. The drop-down box type control can select multiple departments and projects; and load the historical algorithm, configure the debugging parameters of the control; click the debug button, and the interface will dynamically display the result interface according to the result calculated by the sql algorithm.

[0015] Furthermore, after debugging the indicator algorithm: confirm that it is correct and save the indicator algorithm, and use it in the business system to display it as the result value of the OKR indicator.

[0016] By adopting the above technical solution, the efficiency of adding new indicators can be effectively improved and the difficulty of indicator debugging can be reduced.

[0017] In a second aspect, the present application provides an electronic device, which adopts the following technical solution:

[0018] An electronic device, comprising:

[0019] at least one processor;

[0020] Memory;

[0021] At least one application, wherein the at least one application is stored in a memory and configured to be executed by at least one processor, and the at least one application is configured to: execute an indicator algorithm online editing and debugging method.

[0022] In a third aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution:

[0023] A computer-readable storage medium stores a computer program, which, when executed in a computer, causes the computer to execute any one of the indicator algorithm online editing and debugging methods provided in the first aspect.

[0024] To summarize, this application proposes a solution for online editing and debugging of indicator algorithms. By displaying the stored indicator algorithms in a table, the indicator algorithms are configured and debugged, which effectively improves the efficiency of adding new indicator algorithms and greatly reduces the difficulty of indicator debugging, making it easier for enterprises to use them in various information-based functional systems. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 It is a flowchart of an online editing and debugging method of an indicator algorithm provided in an embodiment of the present application;

[0026] Figure 2 It is a schematic diagram of the module principle of an embodiment of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0027] In order to make the purpose, technical solutions and advantages of this application more clear, the following Figure 1 , Attachment Figure 2 It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0028] The embodiment of the present application provides an online editing and debugging method for an indicator algorithm, which is used in an enterprise OKR system.

[0029] This embodiment uses the enterprise OKR system as an application example to specifically illustrate the above method. In actual implementation, the above method can also be used in other systems that require indicator algorithm debugging, and this embodiment does not limit this.

[0030] Specific reference Figure 1 As shown, an online editing and debugging method for an indicator algorithm comprises:

[0031] S10: Establish a table for storing indicator algorithms;

[0032] S20: Display the stored indicator algorithm through a table;

[0033] S30: configure parameters of the indicator algorithm;

[0034] S40: Debug the indicator algorithm and save it for subsequent use.

[0035] This technical solution displays the stored indicator algorithms through tables, configures the indicator algorithms, and debugs the indicator algorithms, which effectively improves the efficiency of adding indicator algorithms and greatly reduces the difficulty of indicator debugging, making it easier for enterprises to use them in various information-based functional systems.

[0036] On the basis of the embodiment of the present invention, when the stored indicator algorithm is displayed through a table: the indicator algorithm data stored in the database is displayed through a web interface to add, delete or modify the indicator algorithm.

[0037] On this basis, the process of configuring the indicator algorithm includes:

[0038] S31: Display the indicator algorithm sql statement (Structured Query Language, Structured Query Language) through the interface;

[0039] S32: Configure the required parameters of the indicator algorithm.

[0040] Furthermore, when S31 displays the indicator algorithm sql statement in the interface: select an indicator algorithm for editing and display the indicator algorithm sql statement; when the calculation result of the indicator algorithm is a percentage type, display the numerator and denominator sql statements of the indicator algorithm.

[0041] Furthermore, when configuring the parameters of the indicator algorithm, S32: writes the indicator algorithm sql statement, configures the parameters and parameter types; for example, time controls: start time, end time, etc.; drop-down box types: department, project, etc.; after the configuration parameters are completed, loads the values ​​of the above parameters used in the historical algorithm for the user to debug the indicator algorithm.

[0042] Based on the embodiment of the present invention, when debugging the indicator algorithm: according to the type of parameter, the interface dynamically renders the parameters used in the loading SQL algorithm; when the parameter is of time type, the time space provides start and end time selections and formats the time.

[0043] On the basis of the embodiment of the present invention, when debugging the indicator algorithm, it also includes: a drop-down box type control provides selection of multiple departments and projects; and loads the historical algorithm and configures the debugging parameters of the control; clicks the debug button, and the interface dynamically displays the result interface based on the result calculated by the sql algorithm.

[0044] In this embodiment, after debugging the indicator algorithm is completed, it also includes S50: confirming that it is correct and saving the indicator algorithm, using it in the business system to display it as the result value of the OKR indicator.

[0045] In the following example, the online editing and debugging method of the indicator algorithm is as follows:

[0046] Click the Add button on the interface to jump to the indicator algorithm adding interface, and enter SQL in the SQL editing interface.

[0047] The start time, end time, and user list parameters are configured in sql; the historical parameter values ​​of these parameters are loaded for algorithm debugging.

[0048] According to the type of parameter, the interface dynamically renders and loads the parameters used in the SQL algorithm, time controls, and drop-down multiple-select controls, and backfills the controls based on historical parameter values.

[0049] Click the debug button, and the interface will automatically display the result interface dynamically based on the result calculated by the SQL algorithm. Once you confirm that the result value is what you want, save the algorithm.

[0050] The saved algorithm will appear in the algorithm list. If you need to edit the algorithm, click the Edit button to jump to the editing interface. The editing interface has the same functions as the new interface. After editing, click the Save button to save the debugged algorithm.

[0051] After the algorithm is saved, the modified algorithm will be used in real time to calculate the results during business use.

[0052] In actual implementation, other methods may also be used to configure and debug parameters, and this embodiment does not limit the specific parameter types.

[0053] The present application also provides an electronic device, such as Figure 2 As shown, Figure 2 The electronic device 700 shown includes: a processor 701 and a memory 703. The processor 701 and the memory 703 are connected, such as through a bus 702. Optionally, the electronic device 700 may also include a transceiver 704. It should be noted that in actual applications, the transceiver 704 is not limited to one, and the structure of the electronic device 700 does not constitute a limitation on the embodiments of the present application.

[0054] Processor 701 may be a CPU (Central Processing Unit), a general purpose processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit) or other programmable logic devices, transistor logic devices, hardware components or any combination thereof. It may implement or execute various exemplary logic blocks, modules and circuits described in conjunction with the disclosure of this application. Processor 701 may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, etc.

[0055] The bus 702 may include a path to transmit information between the above components. The bus 702 may be a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus. The bus 702 may be divided into an address bus, a data bus, etc. For ease of representation, Figure 2 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0056] The memory 703 can be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, or an EEPROM (Electrically Erasable Programmable Read Only Memory), a disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited to this.

[0057] The memory 703 is used to store the application code for executing the solution of the present application, and the execution is controlled by the processor 701. The processor 701 is used to execute the application code stored in the memory 703 to implement the contents shown in the above method embodiment.

[0058] The electronic devices include, but are not limited to, mobile terminals such as mobile phones, notebook computers, PDAs (personal digital assistants), PADs (tablet computers), etc., and fixed terminals such as digital TVs, desktop computers, etc. It can also be a server, etc. Figure 2 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0059] An embodiment of the present application also provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed in a computer, the computer is caused to execute the online editing and debugging method of the indicator algorithm provided in the above embodiment.

[0060] It should be understood that although the steps in the flowchart of the accompanying drawings are shown in sequence according to the instructions of the arrows, these steps are not necessarily performed in the order indicated by the arrows. Unless otherwise clearly stated in this document, the execution of these steps is not strictly limited in order and can be performed in other orders.

[0061] The above are only some implementation methods of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A method for online editing and debugging of an indicator algorithm, characterized in that: The method comprises: Create a table to store indicator algorithms; Display the stored indicator algorithm through a table; Configure parameters for indicator algorithms; Debug the indicator algorithm and save it for subsequent use.

2. The online editing and debugging method of indicator algorithm according to claim 1 is characterized in that: When displaying stored indicator algorithms through a table: Display the indicator algorithm data stored in the database through the web interface to add, delete, or modify the indicator algorithm.

3. The online editing and debugging method of indicator algorithm according to claim 1, characterized in that: The process of configuring the indicator algorithm includes: Display the indicator algorithm sql statement through the interface; Configure the required parameters of the indicator algorithm.

4. The online editing and debugging method of indicator algorithm according to claim 3 is characterized in that: When displaying the indicator algorithm sql statement on the interface: select an indicator algorithm for editing and display the indicator algorithm sql statement; when the calculation result of the indicator algorithm is a percentage type, display the numerator and denominator sql statements of the indicator algorithm.

5. The online editing and debugging method of indicator algorithm according to claim 3 is characterized in that: When configuring the parameters of the indicator algorithm: write the indicator algorithm SQL statement, configure the parameters and parameter types; after the configuration of the parameters is completed, load the values ​​of the above parameters used in the historical algorithm for the user to debug the indicator algorithm.

6. The online editing and debugging method of indicator algorithm according to claim 1, characterized in that: When debugging the indicator algorithm: according to the parameter type, the interface dynamically renders and loads the parameters used in the SQL algorithm; when the parameter is of time type, the time space provides start and end time selections and formats the time.

7. The online editing and debugging method of indicator algorithm according to claim 6 is characterized in that: When debugging the indicator algorithm, it also includes: the drop-down box type control provides multiple departments and projects for selection; and loads the historical algorithm and configures the debugging parameters of the control; clicks the debug button, and the interface dynamically displays the result interface based on the result calculated by the sql algorithm.

8. The online editing and debugging method of indicator algorithm according to claim 1, characterized in that: After debugging the indicator algorithm, it also includes: confirming that it is correct and saving the indicator algorithm, using it in the business system, and displaying it as the result value of the OKR indicator.

9. An electronic device, characterized in that: The electronic device includes: at least one processor; Memory; At least one application, wherein the at least one application is stored in a memory and configured to be executed by at least one processor, and the at least one application is configured to: execute the indicator algorithm online editing and debugging method described in any one of claims 1 to 8.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed in a computer, the computer is caused to execute the online editing and debugging method for the indicator algorithm described in any one of claims 1 to 8.

Images