Index configuration method and device and related equipment

By pre-generating indicators and supporting users to create new indicators, the problem of poor application effect of indicator configuration in the existing technology is solved, and higher flexibility and convenience are achieved, and configuration efficiency is improved.

CN119417291APending Publication Date: 2025-02-11云账户技术(天津)有限公司
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411451165.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-10-17
Publication Date
2025-02-11

AI Technical Summary

Technical Problem

The existing technology has poor application effect in indicator configuration, and cannot take into account both configuration flexibility and operation simplicity, resulting in business personnel needing to carry out a lot of repeated code development work.

Method used

By pre-generating a certain amount of indicators, users can support them to create new indicators based on pre-generated indicators, replace hard-coded methods or SQL configuration methods, generate target expressions, and create indicators in the pre-set indicator configuration interface.

Benefits of technology

It improves the flexibility and convenience of indicator configuration, reduces the learning burden and code development workload of business personnel, and improves configuration efficiency and application effect.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119417291A_ABST
    Figure CN119417291A_ABST
Patent Text Reader

Abstract

The invention provides an index configuration method and device and related equipment, and relates to the technical field of computers, the method comprises the steps that index configuration information of a first index is acquired, the index configuration information comprises description information of the first index, at least one second index and index configuration data, the second index is a preset generated index associated with the first index, the index configuration data comprises a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used for adjusting an expression value of the second index, and the second configuration parameter is used for indicating the expression value of the second index in the process of generating the first index based on the at least one second index. An operation mode between at least one second index; generating a target expression of the first index according to the at least one second index and the index configuration data; and creating the first index in a preset index configuration interface according to the description information and the target expression of the first index. The index configuration means provided by the invention has both configuration flexibility and operation simplicity.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the technical field of computers, and in particular to an indicator configuration method, device and related equipment. Background Art

[0002] Indicators refer to business-related variables or characteristics, which come from the business side. In the early stages of business development, the business scenarios and types are relatively simple, the complexity of indicators is low, and the number is small. Related technologies will use hard coding to implement the calculation logic of indicators.

[0003] However, as the business grows and expands, the number and complexity of indicators increase. Although the hard-coding method can facilitate the application of indicators by business personnel, it will bring a lot of repetitive code development work, which makes the configuration efficiency of indicators relatively low.

[0004] In order to optimize the configuration efficiency of indicators, relevant technologies will use SQL configuration to achieve flexible configuration of indicators to a certain extent, so as to reduce some repetitive code development work for indicators. However, the SQL configuration method requires business personnel to have certain SQL coding capabilities, which brings a certain learning burden to business personnel.

[0005] In other words, the application effect of the indicator configuration means provided by the relevant technology is poor, and it is impossible to achieve both configuration flexibility and ease of operation. Summary of the invention

[0006] The purpose of the present disclosure is to provide an indicator configuration method, device and related equipment to solve the technical problem that the indicator configuration means provided by the related art have poor application effect.

[0007] In a first aspect, the present disclosure provides an indicator configuration method, comprising:

[0008] Acquire indicator configuration information of a first indicator, the indicator configuration information including: description information of the first indicator, at least one second indicator, and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, and the indicator configuration data includes a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate an operation mode between the at least one second indicator in a process of generating the first indicator based on the at least one second indicator;

[0009] generating a target expression for the first indicator according to the at least one second indicator and the indicator configuration data;

[0010] The first indicator is created in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

[0011] In one embodiment, each of the second indicators corresponds to a default indicator value;

[0012] The step of generating a target expression for the first indicator according to the at least one second indicator and the indicator configuration data comprises:

[0013] generating a candidate expression according to the at least one second indicator and the indicator configuration data;

[0014] The candidate expression is executed according to the default indicator value corresponding to each of the second indicators, and when the candidate expression is successfully executed, the candidate expression is determined as the target expression.

[0015] In one embodiment, the first configuration parameter includes a function sub-parameter and a condition sub-parameter, wherein the function sub-parameter is used to call an aggregation function, and the condition sub-parameter is used to determine at least one target indicator value for calculating the target expression from a plurality of candidate indicator values ​​corresponding to the second indicator.

[0016] In one embodiment, the second indicator includes a basic class indicator and a derived class indicator, the basic class indicator is an indicator generated without relying on other indicators, the derived class indicator is an indicator generated relying on other indicators, and the processing object of the aggregation function is the basic class indicator.

[0017] In one embodiment, after creating the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator, the method further includes:

[0018] When the first indicator is verified based on a preset verification rule and the verification passes, the first indicator is added to a preset indicator library.

[0019] In one embodiment, after adding the first indicator to a preset indicator library, the method further includes:

[0020] Obtaining indicator modification information of the first indicator;

[0021] According to the indicator modification information, the description information of the first indicator and / or the target expression of the first indicator are updated.

[0022] In one embodiment, after updating the description information of the first indicator and / or the target expression of the first indicator according to the indicator modification information, the method further includes:

[0023] An operation record is generated according to the indicator modification information, wherein the operation record includes an indicator difference between the first indicator before and after the update operation indicated by the indicator modification information.

[0024] In a second aspect, the present disclosure further provides an indicator configuration device, the device comprising:

[0025] An information acquisition module, used to acquire indicator configuration information of a first indicator, the indicator configuration information including: description information of the first indicator, at least one second indicator and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, the indicator configuration data including a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate the operation mode between the at least one second indicator in the process of generating the first indicator based on the at least one second indicator;

[0026] A generating module, configured to generate a target expression of the first indicator according to the at least one second indicator and the indicator configuration data;

[0027] A creation module is used to create the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

[0028] In a third aspect, an embodiment of the present disclosure further provides an electronic device, comprising a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the computer program implements the steps of the above-mentioned indicator configuration method when executed by the processor.

[0029] In a fourth aspect, an embodiment of the present disclosure further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the above-mentioned indicator configuration method are implemented.

[0030] In the present disclosure, a certain amount of indicators are generated in advance to support users to create new indicators based on the pre-generated indicators, thereby replacing the hard-coding method or SQL configuration method adopted by related technologies. This not only makes the configuration of indicators more flexible and convenient, but also avoids unnecessary learning burden for business personnel, and thus has strong versatility and better application effect. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 is a flow chart of an indicator configuration method provided by an embodiment of the present disclosure;

[0032] Figure 2 is a flow chart of an indicator configuration method provided by an embodiment of the present disclosure;

[0033] Figure 3 is a schematic diagram of a calculation logic generation process of a derived indicator provided by an embodiment of the present disclosure;

[0034] Figure 4 It is a schematic diagram of a calculation process of an expression of an indicator provided by an embodiment of the present disclosure;

[0035] Figure 5 is a structural schematic diagram of an indicator configuration device provided by an embodiment of the present disclosure;

[0036] Figure 6 It is a schematic diagram of an electronic device provided by an embodiment of the present disclosure. DETAILED DESCRIPTION

[0037] The following will be combined with the drawings in the embodiments of the present disclosure to clearly and completely describe the technical solutions in the embodiments of the present disclosure. Obviously, the described embodiments are part of the embodiments of the present disclosure, rather than all of the embodiments. Based on the embodiments in the present disclosure, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present disclosure.

[0038] The present disclosure provides an indicator configuration method, such as Figure 1 As shown, the indicator configuration method includes:

[0039] Step 101: Obtain indicator configuration information of a first indicator.

[0040] The indicator configuration information includes: description information of the first indicator, at least one second indicator and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, and the indicator configuration data includes a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate the operation method between the at least one second indicator in the process of generating the first indicator based on the at least one second indicator.

[0041] The first indicator mentioned above can be understood as an indicator of the actual business needs of the associated business scenario, such as total expenditure, maximum expenditure in a single month, and other indicators.

[0042] The description information of the above-mentioned first indicator is used to identify the first indicator among multiple indicators of the associated business scenario, and to explain the business meaning of the first indicator. For example, the description information of the first indicator may include: the indicator name of the first indicator, the remark information of the first indicator, the default indicator value of the first indicator, the data type to which the first indicator belongs, etc.

[0043] The second indicator mentioned above can be understood as: an indicator that has been published in the indicator library before the user initiates the task of creating the first indicator and is used to generate the first indicator;

[0044] The second indicator may be an indicator pre-configured by the user in the indicator library, for example, an indicator configured by a developer in a hard-coded manner. In this process, the developer may adaptively configure the indicator name, remark information, data type (such as floating point, character, etc.), data source, calculation logic (SQL and function used to obtain the indicator, etc.) and configurable conditions (conditions for filtering multiple candidate indicator values ​​of the second indicator, for example, when the second indicator indicates the transaction amount, the configurable conditions may include transaction time, transaction type, etc.) of the second indicator;

[0045] The second indicator may also be an indicator previously created by the user and successfully published and entered into the indicator library, for example, an indicator created by a business person through the indicator configuration method provided by the present disclosure.

[0046] By supporting users to set the first configuration parameters, users can flexibly select at least one target indicator value for generating the first indicator from multiple alternative indicator values ​​corresponding to the second indicator, and / or users can aggregate at least two alternative indicator values ​​corresponding to the second indicator and output the specific indicator value required for calculating the first indicator, so as to match the changing business needs in actual applications.

[0047] Exemplarily, when the second indicator indicates the daily expenditure, and the second indicator corresponds to 30 candidate indicator values ​​in the database (indicating daily expenditures from the 1st to the 30th respectively), through the setting of the first configuration parameter, the daily expenditures from the 1st to the 10th can be selected to participate in the calculation of the first indicator (referring to selecting the target indicator value from multiple candidate indicator values), or the average of the daily expenditures from the 1st to the 30th can be selected to participate in the calculation of the first indicator (referring to aggregating at least two alternative indicator values ​​and outputting a specific indicator value), and the average of the daily expenditures from the 1st to the 10th can also be selected to participate in the calculation of the first indicator.

[0048] When the generation of a first indicator involves two or more second indicators, the operation method between the two or more second indicators (such as arithmetic operations, logarithms, inverses, etc.) is determined based on the setting of the second configuration parameters; and when the generation of a first indicator involves at least one constant and one second indicator, the operation method between at least one constant and one second indicator can be determined based on the setting of the second configuration parameters.

[0049] It should be noted that the above business scenarios may be any scenarios involving indicator application, such as financial management scenarios, passenger flow monitoring scenarios, etc.

[0050] Step 102: Generate a target expression for the first indicator according to the at least one second indicator and the indicator configuration data.

[0051] As described above, by determining the first configuration parameter corresponding to each second indicator and / or the operation method between at least one second indicator, the target expression of the first indicator is generated, thereby completing the association between the front-end preset indicator configuration interface and the back-end database.

[0052] It should be pointed out that, in the application, the second indicator may not be set with the corresponding first configuration parameter.

[0053] Step 103: Create the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

[0054] In the present disclosure, a certain amount of indicators are generated in advance to support users to create new indicators based on the pre-generated indicators, thereby replacing the hard-coding method or SQL configuration method adopted by related technologies. This not only makes the configuration of indicators more flexible and convenient, but also avoids unnecessary learning burden for business personnel, and thus has strong versatility and better application effect.

[0055] In one embodiment, each of the second indicators corresponds to a default indicator value;

[0056] The step of generating a target expression for the first indicator according to the at least one second indicator and the indicator configuration data comprises:

[0057] generating a candidate expression according to the at least one second indicator and the indicator configuration data;

[0058] The candidate expression is executed according to the default indicator value corresponding to each of the second indicators, and when the candidate expression is successfully executed, the candidate expression is determined as the target expression.

[0059] In this embodiment, after determining at least one second indicator and the indicator configuration data for generating the first indicator, a candidate expression is first generated, and then the default indicator value of each second indicator configuration is brought into the candidate expression for calculation, and if the candidate expression is executed successfully, the candidate expression is finally determined as the target expression to ensure the feasibility of the target expression and reduce the risk of failure brought to the business system by the unexecutable first indicator configured by the user.

[0060] It should be noted that the candidate expression is executed according to the default indicator value corresponding to each of the second indicators. If the execution of the candidate expression fails, a preset warning message is returned to prompt the user that the expression configuration of the first indicator created this time is incorrect.

[0061] For example, if the candidate expression is (sum(income)-sum(expenditure)) / sum(income), the data types of income and expenditure are both numeric, and the candidate expression can be expressed as (AB) / A. The default values ​​of A and B are set to 1 and 2, respectively. Then the result of executing the candidate expression is -1. At this time, it can be determined that the candidate expression is executed successfully.

[0062] If the candidate expression is (1++income), the candidate expression can be expressed as (1++A). If the default value of A is set to 1, an error will be reported when executing the candidate expression. At this time, the candidate expression can be determined to be an illegal expression, that is, the execution of the candidate expression is determined to have failed.

[0063] In the present disclosure, the situation where the execution of a candidate expression fails can be understood as that the execution result output by the candidate expression is a preset exception result, for example: an exception (Exception) or error (error) is thrown immediately after the candidate expression is executed; and the situation where the execution of a candidate expression is successful can be understood as that the execution result output by the candidate expression does not belong to the preset exception result.

[0064] In some embodiments, the warning information may also carry execution error data to indicate to the user the cause of the error in the expression of the configured first indicator, help the user avoid such problems in subsequent indicator configurations, and enhance the user's operational experience during the indicator configuration process.

[0065] In one embodiment, the first configuration parameter includes a function sub-parameter and a condition sub-parameter, wherein the function sub-parameter is used to call an aggregation function, and the condition sub-parameter is used to determine at least one target indicator value for calculating the target expression from a plurality of candidate indicator values ​​corresponding to the second indicator.

[0066] In the present disclosure, after the user configures the corresponding first configuration parameter for one of at least one second indicator, the aforementioned specific indicator value can be output based on the function sub-parameter in the first configuration parameter, and the aforementioned at least one target indicator value can be output based on the conditional sub-parameter in the first configuration parameter.

[0067] Exemplarily, the aggregation function may be used to output a sun function for calculating a sum value, a max function for calculating a maximum value, a min function for calculating a minimum value, an avg function for calculating an average value, a count function for calculating a quantity, and the like.

[0068] Exemplarily, the conditional sub-parameters may include screening of conditions such as time, location, type, object, etc., such as transaction time, transaction location, transaction type, etc.

[0069] In one embodiment, the second indicator includes a basic class indicator and a derived class indicator, the basic class indicator is an indicator generated without relying on other indicators, the derived class indicator is an indicator generated relying on other indicators, and the processing object of the aggregation function is the basic class indicator.

[0070] In the present disclosure, the indicators used in business scenarios are divided into basic indicators and derived indicators, among which, the basic indicators can be understood as a type of indicators preset by developers in the indicator library through hard coding, and the derived indicators can be understood as a type of indicators created by business personnel through indicator configuration and recorded in the indicator library. In order to significantly distinguish the differences between basic indicators and derived indicators, and to ensure the correctness and professionalism of basic indicators (basic indicators are the cornerstone of the generation of derived indicators), it can also be set that only developers have the authority to update basic indicators (add, delete, modify), while business personnel do not have the authority to update basic indicators.

[0071] It should be noted that, in the present disclosure, the first indicator is a derived indicator, and the second indicator can be a basic indicator or a derived indicator.

[0072] In one embodiment, after creating the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator, the method further includes:

[0073] When the first indicator is verified based on a preset verification rule and the verification passes, the first indicator is added to a preset indicator library.

[0074] In this embodiment, in order to prevent business personnel from publishing abnormal indicators (such as duplicate indicators, redundant indicators irrelevant to the business, etc.), preset verification rules can be set in advance to verify the first indicator created by the user. Only when the verification passes will the first indicator be added to the preset indicator library for storage. The indicators used during the operation of the business system are all derived from the indicator library.

[0075] Exemplarily, the verification of the first indicator can be completed based on a preset network model or a large language model (referring to inputting the first indicator into a preset network model or a large language model to output an indicator verification value, and the preset verification rule is that if the indicator verification value is greater than a preset threshold, the verification is judged to be passed, otherwise the verification is judged to be failed), or the verification of the first indicator can be completed manually by a tester. The present disclosure does not limit the specific verification method of the first indicator.

[0076] In one embodiment, after adding the first indicator to a preset indicator library, the method further includes:

[0077] Obtaining indicator modification information of the first indicator;

[0078] According to the indicator modification information, the description information of the first indicator and / or the target expression of the first indicator are updated.

[0079] This embodiment, through the above-mentioned settings, supports the user to modify the first indicator that has been successfully created, which can avoid the generation of homogenized indicators and reduce the number of redundant indicators (infrequently used) in the indicator library.

[0080] It should be noted that when the user's indicator deletion information for a certain indicator is obtained, if the deleted object is a derived class indicator, the corresponding derived class indicator will be deleted in the indicator library accordingly; if the deleted object is a basic class indicator, the user's identity needs to be verified. When the verification result indicates that the user is a developer, the corresponding derived class indicator can be deleted in the indicator library accordingly. Otherwise, a prompt of insufficient operation authority will be returned.

[0081] In one embodiment, after updating the description information of the first indicator and / or the target expression of the first indicator according to the indicator modification information, the method further includes:

[0082] An operation record is generated according to the indicator modification information, wherein the operation record includes an indicator difference between the first indicator before and after the update operation indicated by the indicator modification information.

[0083] In this embodiment, when the first indicator undergoes an indicator modification operation, a corresponding operation record is generated to record the difference between the first indicator before and after the indicator modification, so as to facilitate the user's subsequent tracking and tracing of the indicator configuration behavior, which can further improve the application reliability of the configured indicator.

[0084] It should be noted that one operation record corresponds to one indicator modification operation. When an indicator involves multiple modifications, multiple operation records corresponding to the indicator will be generated. In the application, different versions can be released for the same indicator to record the difference between each indicator before and after the update. For example, newly created indicators correspond to version 1.0, and each time an indicator is modified, the version number corresponds to +1 (such as version 2.0, version 3.0, etc.). Multiple versions of each indicator can be recorded in the business system to facilitate version rollback and problem tracking.

[0085] For ease of understanding, the following examples are provided:

[0086] like Figure 2As shown, the present disclosure also provides an indicator configuration method for separating indicator calculation from the development, testing, and online processes, and provides a simple logic definition method so that business personnel can easily get started and ensure the logical correctness of indicator calculation. It can not only overcome the shortcomings of low efficiency of hard coding methods, but also avoid the shortcomings of high learning costs of SQL configuration methods.

[0087] Figure 2 In the method shown, indicators are divided into two categories: basic indicators (i.e., the aforementioned basic class indicators) and derived indicators (i.e., the aforementioned derived class indicators), and the basic attributes, calculation logic, and configurable conditions of the basic indicators are pre-configured by the developer.

[0088] Among them, basic attributes include but are not limited to the name, description, data type, source, etc. of the indicator; calculation logic includes but is not limited to the calculation SQL of the indicator, the name of the calculation method, etc. The SQL can be the SQL of the DB or the SQL of the big data framework (Spark SQL, FlinkSQL, etc.); the calculation method handles some indicators with complex calculation processes in a hard-coded manner.

[0089] Configurable conditions are used to calculate additional indicators when indicators are derived. For example, if the basic indicator is the transaction amount, the configurable conditions include transaction time and transaction type. The derived indicator can be the cumulative transaction amount of tobacco and alcohol within 3 days.

[0090] To ensure the accuracy and professionalism of basic indicators, basic indicators are configured by developers and cannot be modified or deleted by business personnel.

[0091] After the developers configure the basic indicators, the business personnel derive the indicators. When deriving, they need to fill in the name and description of the derived indicators, select the indicator set involved in the derivation (which can include at least one of the constants, basic indicators and derived indicators), and then select the configuration conditions of each indicator in the indicator set and the logical relationship between the conditions (optional, you do not need to select the configuration conditions), and finally configure the calculation formula for these indicators (that is, set the expression value of the corresponding second indicator through the first configuration parameter and / or set the operation method between multiple items in the indicator set through the second configuration parameter).

[0092] The calculation formula of the configuration indicator refers to how the indicators involved in the derivation generate derived indicators through calculation, including operators, aggregation functions, etc.

[0093] For example: select the indicators as income and expenditure, configure the condition to within 1 month, and configure the calculation formula to sum(income)-sum(expenditure), then you can get the net income within 1 month; select the indicator as expenditure, configure the condition to within 1 month, and configure the calculation formula to max(expenditure), then you can get the largest expenditure in 1 month.

[0094] After the derived indicator configuration is completed, the background will automatically generate the calculation logic and configurable conditions of the derived indicator, where the configurable conditions are generated based on the configurable conditions of the basic indicators / derived indicators involved in the derivation.

[0095] It should be pointed out that after adding a derived indicator, a grayscale release must be carried out first. It can only be officially released after the testers have tested that the calculation of the newly added derived indicator is correct and the business personnel have confirmed that the derived indicator configuration is correct. After modifying the derived indicator, it is necessary to record the value of each modification and attach the version information of the derived indicator when calculating the indicator, so as to facilitate the subsequent tracing of the derived indicator calculation and troubleshooting.

[0096] The basic indicators and derived indicators after official release are available for call by other modules of the business system. For example, other modules can combine the basic business data and the indicators after release to perform risk monitoring and indicator change monitoring. The basic business data may be user name, transaction order number, etc.

[0097] Figure 3 The calculation logic generation process of the derived indicator is shown, specifically:

[0098] 1) Traverse the calculation formula configured by the user and determine the type of each formula item in the calculation formula;

[0099] a. If the current formula item is an aggregate function, determine whether the next formula item is an indicator and a basic indicator. If not, return a formula item configuration error. Otherwise, add the current formula item to the expression (derived indicators are not allowed here because the derived indicator may have selected an aggregate function condition. Aggregate function conditions are not allowed to be selected when it is derived again, otherwise conflicts between aggregate function conditions may occur). Then determine whether the data source of the basic indicator is a method. If it is, obtain the condition set of the method according to the selected configuration conditions, and write the aggregate function into the condition set (the aggregate function is also used as a condition); if the data source of the basic indicator is SQL, generate the corresponding SQL according to the selected configuration conditions and aggregate functions (the basic indicator corresponds to one SQL. After adding configuration conditions and / or aggregate functions to the basic indicator, a new SQL can be generated. For example, if the basic indicator is income, it corresponds to one SQL. Then the total income within one month will correspond to one new SQL, and the average income within one month will correspond to another new SQL); skip the judgment of the next formula item;

[0100] b. If the current formula item is an indicator, add it to the expression, and then determine whether the data source of the indicator is a method. If it is, obtain the condition set of the method according to the selected configuration conditions; if the data source of the indicator is SQL, generate a complete SQL according to the selected configuration conditions;

[0101] c. If this item is an operator, add it to the expression;

[0102] d. If this item is a constant, add it to the expression (i.e. the candidate expression mentioned above);

[0103] 2) Verify whether the generated expression is legal. Specifically, the default value of the data type setting of the above configuration item (i.e., the aforementioned default indicator value) is used to calculate the expression, and then verify the legality of the expression. If the expression calculation result is a specific value that is not abnormal or erroneous, the expression is legal, otherwise it is illegal (the legal candidate expression is used as the target expression);

[0104] 3) The data type of the derived indicator is obtained according to the value type of the expression calculation result.

[0105] As shown above, the default indicator value can be determined based on the data type of each indicator, and the default value corresponding to each data type is pre-set. For a newly added derived indicator, the data type of the derived indicator can be determined accordingly based on the calculation result obtained by calculating the target expression corresponding to the derived indicator based on the default indicator value, and then the default indicator value of the derived indicator can be determined.

[0106] Figure 4 The expression calculation process of the indicator is shown, specifically:

[0107] If it is a basic indicator, determine whether the data source is a DB. If so, execute SQL according to the DB configuration to obtain the SQL execution result. If the data source is a method, execute the specified method according to the method configuration to obtain the execution result.

[0108] If it is a derived indicator, traverse the dependent indicators to determine whether the data source is a DB. If it is, execute SQL according to the DB configuration to obtain the SQL execution result; if the data source is a method, execute the specified method according to the method configuration to obtain the execution result; then execute the expression to obtain the value of the derived indicator.

[0109] In this embodiment, the DB data source and the method data source indicate different channels for obtaining indicators, among which the calculation process corresponding to the indicators obtained based on the method data source is more complicated, and the calculation process corresponding to the indicators obtained based on the DB data source is relatively simple. The method data source can be understood as a data source formed by a combination of multiple DB data sources or functions. The distinction between the two is to reduce the complexity and maintenance difficulty of the entire business system and avoid the generation of identical or similar complex SQL.

[0110] In the present disclosure, derived indicators and their calculation logic are generated by configuring the conditions and formulas of indicators, which can save hard coding work, SQL configuration work and online processes and facilitate use by business personnel; and because the configurable conditions of basic indicators are configured by developers, and the configurable conditions of derived indicators are derived from the dependent basic indicators or derived indicators, it can effectively prevent the arbitrary configuration of indicators and reduce the application risks brought by erroneous indicators entering the business system. At the same time, the legitimacy of the expression is verified during the indicator derivation process, and the configuration errors of the expression are discovered and effectively avoided in time, as well as the grayscale release of newly added derived indicators and the recording of the modification history of derived indicators, thereby ensuring the correctness and traceability of indicator calculation.

[0111] See also Figure 5 , Figure 5 is an indicator configuration device provided by an embodiment of the present disclosure, such as Figure 5 As shown, the indicator configuration device 500 includes:

[0112] The information acquisition module 501 is used to acquire the indicator configuration information of the first indicator, wherein the indicator configuration information includes: description information of the first indicator, at least one second indicator and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, and the indicator configuration data includes a first configuration parameter and / or a second configuration parameter, wherein the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate the operation mode between the at least one second indicator in the process of generating the first indicator based on the at least one second indicator;

[0113] A generating module 502, configured to generate a target expression of the first indicator according to the at least one second indicator and the indicator configuration data;

[0114] The creation module 503 is used to create the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

[0115] In one embodiment, each of the second indicators corresponds to a default indicator value;

[0116] The generating module 502 is specifically used for:

[0117] generating a candidate expression according to the at least one second indicator and the indicator configuration data;

[0118] The candidate expression is executed according to the default indicator value corresponding to each of the second indicators, and when the candidate expression is successfully executed, the candidate expression is determined as the target expression.

[0119] In one embodiment, the first configuration parameter includes a function sub-parameter and a condition sub-parameter, wherein the function sub-parameter is used to call an aggregation function, and the condition sub-parameter is used to determine at least one target indicator value for calculating the target expression from a plurality of candidate indicator values ​​corresponding to the second indicator.

[0120] In one embodiment, the second indicator includes a basic class indicator and a derived class indicator, the basic class indicator is an indicator generated without relying on other indicators, the derived class indicator is an indicator generated relying on other indicators, and the processing object of the aggregation function is the basic class indicator.

[0121] In one embodiment, the indicator configuration device 500 further includes:

[0122] The verification module is used to verify the first indicator based on the preset verification rules, and if the verification passes, add the first indicator to a preset indicator library.

[0123] In one embodiment, the indicator configuration device 500 further includes:

[0124] A modification module is used to obtain indicator modification information of the first indicator, and update the description information of the first indicator and / or the target expression of the first indicator according to the indicator modification information.

[0125] In one embodiment, the indicator configuration device 500 further includes:

[0126] A recording module is used to generate an operation record according to the indicator modification information, wherein the operation record includes the indicator difference between the first indicator before and after the update operation indicated by the indicator modification information.

[0127] The indicator configuration device 500 provided in the embodiment of the present disclosure can implement each process in the above-mentioned indicator configuration method embodiment, and will not be described again here to avoid repetition.

[0128] According to an embodiment of the present disclosure, the present disclosure also provides an electronic device and a readable storage medium.

[0129] Figure 6A schematic block diagram of an example electronic device 600 that can be used to implement an embodiment of the present disclosure is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present disclosure described and / or required herein.

[0130] like Figure 6 As shown, the device 600 includes a computing unit 601, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 602 or a computer program loaded from a storage unit 608 to a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the device 600 can also be stored. The computing unit 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0131] A number of components in the device 600 are connected to the I / O interface 605, including: an input unit 606, such as a keyboard, a mouse, etc.; an output unit 604, such as various types of displays, speakers, etc.; a storage unit 608, such as a disk, an optical disk, etc.; and a communication unit 609, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 609 allows the device 600 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0132] The computing unit 601 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 601 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSP), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 601 performs the various methods and processes described above, such as the indicator configuration method. For example, in some embodiments, the indicator configuration method may be implemented as a computer software program, which is tangibly included in a machine-readable medium, such as a storage unit 608. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 600 via the ROM 602 and / or the communication unit 609. When the computer program is loaded into the RAM 603 and executed by the computing unit 601, one or more steps of the indicator configuration method described above may be executed. Alternatively, in other embodiments, the computing unit 601 may be configured to execute the indicator configuration method in any other appropriate manner (eg, by means of firmware).

[0133] Various embodiments of the systems and techniques described above herein may be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0134] The program code for implementing the method of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0135] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, 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 foregoing.

[0136] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0137] The systems and techniques described herein may be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by 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), and the Internet.

[0138] A computer system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship with each other. The server may be a cloud server, a server of a distributed system, or a server combined with a blockchain.

[0139] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps recorded in this disclosure can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solutions disclosed in this disclosure can be achieved, and this document does not limit this.

[0140] The above specific implementations do not constitute a limitation on the protection scope of the present disclosure. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present disclosure shall be included in the protection scope of the present disclosure.

Claims

1. An indicator configuration method, characterized in that: The method comprises: Acquire indicator configuration information of a first indicator, the indicator configuration information including: description information of the first indicator, at least one second indicator, and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, and the indicator configuration data includes a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate an operation mode between the at least one second indicator in a process of generating the first indicator based on the at least one second indicator; generating a target expression for the first indicator according to the at least one second indicator and the indicator configuration data; The first indicator is created in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

2. The method according to claim 1, characterized in that Each of the second indicators corresponds to a default indicator value; The step of generating a target expression for the first indicator according to the at least one second indicator and the indicator configuration data comprises: generating a candidate expression according to the at least one second indicator and the indicator configuration data; The candidate expression is executed according to the default indicator value corresponding to each of the second indicators, and when the candidate expression is successfully executed, the candidate expression is determined as the target expression.

3. The method according to claim 1, characterized in that The first configuration parameter includes a function sub-parameter and a condition sub-parameter, wherein the function sub-parameter is used to call an aggregation function, and the condition sub-parameter is used to determine at least one target indicator value for calculating the target expression from a plurality of candidate indicator values ​​corresponding to the second indicator.

4. The method according to claim 3, characterized in that: The second indicator includes a basic class indicator and a derived class indicator. The basic class indicator is an indicator generated without relying on other indicators, and the derived class indicator is an indicator generated relying on other indicators. The processing object of the aggregation function is the basic class indicator.

5. The method according to claim 1, characterized in that After creating the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator, the method further includes: When the first indicator is verified based on a preset verification rule and the verification passes, the first indicator is added to a preset indicator library.

6. The method according to claim 5, characterized in that After adding the first indicator to a preset indicator library, the method further includes: Obtaining indicator modification information of the first indicator; According to the indicator modification information, the description information of the first indicator and / or the target expression of the first indicator are updated.

7. The method according to claim 6, characterized in that After updating the description information of the first indicator and / or the target expression of the first indicator according to the indicator modification information, the method further includes: An operation record is generated according to the indicator modification information, wherein the operation record includes an indicator difference between the first indicator before and after the update operation indicated by the indicator modification information.

8. An indicator configuration device, characterized in that: The device comprises: An information acquisition module, used to acquire indicator configuration information of a first indicator, the indicator configuration information including: description information of the first indicator, at least one second indicator and indicator configuration data, wherein the second indicator is a preset indicator associated with the first indicator, the indicator configuration data including a first configuration parameter and / or a second configuration parameter, the first configuration parameter is used to adjust the expression value of the second indicator, and the second configuration parameter is used to indicate the operation mode between the at least one second indicator in the process of generating the first indicator based on the at least one second indicator; A generating module, configured to generate a target expression of the first indicator according to the at least one second indicator and the indicator configuration data; A creation module is used to create the first indicator in a preset indicator configuration interface according to the description information and the target expression of the first indicator.

9. An electronic device, characterized in that: The method comprises a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the computer program implements the steps of the method according to any one of claims 1 to 7 when executed by the processor.

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