Index configuration method and apparatus, and electronic device

Abstract

The application provides an index configuration method and device and electronic equipment, wherein the method comprises: obtaining index configuration information, wherein the index configuration information comes from multiple dimensions; for any index in the index configuration information, determining an index value of the index according to the index configuration information, and determining at least one derived index value of the index according to the index configuration information or a preset index calculation rule; and storing the index value and the at least one derived index value of at least one index belonging to the same dimension into the same index information table according to the dimension to which each index belongs, so as to perform information pushing based on at least one index information table. Thus, the index data can be automatically processed based on the index configuration information and the preset index calculation rule, a corresponding index processing program does not need to be developed for each index data, the repeated development work of the index processing program is avoided, the index processing complexity is reduced, and the index processing and index query performance are improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to an index configuration method and device and electronic equipment. BACKGROUND

[0002] In recent years, with the rapid development of commercial bank business and the continuous deepening of digital operation, the business data of commercial banks is becoming more and more rich. In order to grasp the business development, commercial banks define various business statistical analysis indexes.

[0003] In the related art, in order to obtain these index information, the common method is to analyze the processing caliber of each index, develop the related index processing program, process the related index data from the data source table, and then process and obtain various derivative indexes according to different dimensions and calculation rules. However, with the increase of indexes, the data processing workload increases significantly, and once a new business index is added, a new index processing program code needs to be developed and deployed online, which involves a lot of repetitive development work and cannot quickly respond to business needs. Moreover, due to the repeated development of different program codes to process indexes, there may be inconsistencies in the calculation rules of derivative indexes with the same concept, and the accuracy of the processing results cannot be guaranteed. SUMMARY

[0004] The present application aims to at least solve one of the technical problems in the related art.

[0005] To this end, the first object of the present application is to propose an index configuration method to automatically process index data based on index configuration information and preset index calculation rules, without the need to develop a corresponding index processing program for each index data, thereby avoiding the repetitive development of index processing programs and reducing the complexity of index processing. In addition, the index value and at least one derivative index value of any index at any time of any institution can be conveniently and efficiently queried through the index information table, without the need to associate multiple table queries and perform multiple record calculation processing, thereby greatly improving the index processing and index query performance and quickly responding to business needs.

[0006] The second object of the present application is to propose an index configuration device.

[0007] The third object of the present application is to propose an electronic equipment.

[0008] The fourth object of the present application is to propose a computer readable storage medium.

[0009] The fifth object of the present application is to propose a computer program product.

[0010] To achieve the above objects, the first aspect of the present application proposes an index configuration method, comprising:

[0011] obtain index configuration information, wherein the index configuration information is from multiple dimensions;

[0012] determine, for any index in the index configuration information, an index value of the index according to the index configuration information;

[0013] determine at least one derived index value of the index according to the index configuration information or according to a preset index calculation rule;

[0014] store the index value and the at least one derived index value of at least one index belonging to the same dimension into the same index information table according to the dimension to which each index belongs, so as to push information based on at least one index information table.

[0015] To achieve the above object, the second aspect of the present application provides an index configuration device, comprising:

[0016] an obtaining module configured to obtain index configuration information, wherein the index configuration information is from multiple dimensions;

[0017] a first determining module configured to determine, for any index in the index configuration information, an index value of the index according to the index configuration information;

[0018] a second determining module configured to determine at least one derived index value of the index according to the index configuration information or according to a preset index calculation rule;

[0019] a processing module configured to store the index value and the at least one derived index value of at least one index belonging to the same dimension into the same index information table according to the dimension to which each index belongs, so as to push information based on at least one index information table.

[0020] To achieve the above object, the third aspect of the present application provides an electronic device, comprising: at least one processor; and a memory connected with the at least one processor in communication; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the index configuration method of the first aspect.

[0021] To achieve the above object, the fourth aspect of the present application provides a computer readable storage medium storing computer instructions, wherein the computer instructions are used to enable the computer to execute the index configuration method of the first aspect.

[0022] To achieve the above object, the fifth aspect of the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the index configuration method of the first aspect.

[0023] The technical solution provided by the embodiments of the present application has the following beneficial effects:

[0024] By obtaining the index configuration information, wherein the index configuration information comes from multiple dimensions, for any index in the index configuration information, the index value of the index is determined according to the index configuration information, and at least one derived index value of the index is determined according to the index configuration information or a preset index calculation rule, so that the index value and the at least one derived index value of at least one index belonging to the same dimension are stored in the same index information table according to the dimension to which each index belongs, and information pushing is performed based on at least one index information table. Therefore, the index data can be automatically processed based on the index configuration information and the preset index calculation rule, without the need to develop a corresponding index processing program for each index data, thereby avoiding repeated development of the index processing program and reducing the index processing complexity. At the same time, the index value and the at least one derived index value of any index of any institution at any period can be conveniently and efficiently queried through the index information table without the need to associate multiple table queries and perform multiple record calculation processing, thereby greatly improving the index processing and index query performance and quickly responding to business requirements.

[0025] Additional aspects and advantages of the present application will be made apparent by the following description and the appended claims. BRIEF DESCRIPTION OF DRAWINGS

[0026] The above and / or additional aspects and advantages of the present application will become apparent and be readily understood from the following description, taken in conjunction with the accompanying drawings, in which:

[0027] Figure 1 A flowchart of an index configuration method provided by an embodiment of the present application is shown in FIG. 1;

[0028] Figure 2 A flowchart of another index configuration method provided by an embodiment of the present application is shown in FIG. 2;

[0029] Figure 3 A flowchart of another index configuration method provided by an embodiment of the present application is shown in FIG. 3;

[0030] Figure 4 A flowchart of an index configuration method in a scenario provided by an embodiment of the present application is shown in FIG. 4;

[0031] Figure 5 A structural diagram of an index configuration device provided by an embodiment of the present application is shown in FIG. 5;

[0032] Figure 6 A structural schematic diagram of an electronic device is provided for an embodiment of the present application. DETAILED DESCRIPTION

[0033] Embodiments of the present application are described in detail below with reference to examples illustrated in the accompanying drawings, in which the same or similar components or components having the same or similar functions are denoted by the same or similar reference numerals throughout. The embodiments described below by reference to the accompanying drawings are exemplary and are intended to explain the present application, and cannot be understood as limiting the present application.

[0034] In recent years, with the rapid development of commercial bank business and the continuous deepening of digital operation, the business data of commercial banks is becoming more and more rich. However, in the face of massive data, how to better tap the value of data and master the development of commercial bank business to help business development has become a problem that each commercial bank urgently needs to solve.

[0035] In order to master the business development, commercial banks define various business statistical analysis indicators. These indicators include basic indicators such as bond underwriting business income, bond issuance scale, and bond customer number; various incremental indicators such as bond underwriting business income daily increment, monthly increment, quarterly increment, and annual increment; various comparative indicators such as day-to-day comparison, month-to-month comparison, quarter-to-quarter comparison, and year-to-year comparison; and various ratio indicators such as monthly same / compounded growth rate, quarterly same / compounded growth rate, and annual growth rate. In order to obtain these indicator information, the common method is to analyze the processing caliber of each indicator, develop relevant indicator processing programs, process relevant indicator data from data source tables, and then process and obtain various derivative indicators according to different dimensions and calculation rules.

[0036] However, with the increase of indicators, the workload of data processing increases significantly. Once new business indicators are added, new indicator processing program codes need to be developed and deployed online, which involves a lot of repetitive development work and cannot quickly respond to business needs. Moreover, due to the repeated development of different program codes to process indicators, there may be inconsistencies in the processing and calculation rules of derivative indicators with the same concept, and the accuracy of the processing results cannot be guaranteed. In addition, since the indicator information is processed and calculated by different indicator processing programs, the processing rules are stored in each processing program, and there is a lack of unified management.

[0037] In addition, for the storage of index information, a narrow table is used for storage, that is, one index result of the same dimension is stored in one record. For a business scenario that needs to simultaneously display the basic index values, incremental values, comparison values, ratio values and other numerical values of the same dimension, such as the current bond underwriting business income cumulative value, daily incremental value, monthly incremental value, annual incremental value and year-on-year and month-on-month comparison of each first-level branch, multiple data need to be queried for row-column conversion or numerical splicing to completely display the relevant information, the query statement is complex, and the query performance is low. There is also a wide table for storage, that is, the index results of the same dimension are stored in one record. Using this scheme, business query is more convenient, but data processing is mostly complex, and there are often repeated association calculation of multiple source tables, multiple processing steps, multiple updates of the same record at each step and other problems, and the data processing performance is poor.

[0038] To solve the above problems, the present application provides an index configuration method, device and electronic equipment, which uses a configurable way to allow data analysts to conveniently configure the relevant information of each business index according to a template at any time, and realizes unified management of indexes through unified index configuration.

[0039] The technical scheme provided by the present application can automatically process index data based on index configuration information and preset index calculation rules, without the need to develop a corresponding index processing program for each index data, avoiding repeated development work of index processing programs, and reducing the complexity of index processing. At the same time, by storing the index values of at least one index and at least one derived index value belonging to the same dimension in the same index information table, the index values and at least one derived index value of any index of each institution at any period can be conveniently and efficiently queried through the index information table, avoiding multi-table association and multi-data integration processing, and greatly improving the index query performance, which can quickly respond to business needs.

[0040] The index configuration method, device and electronic equipment of the embodiments of the present application will be described below with reference to the accompanying drawings.

[0041] Figure 1 A flowchart of an index configuration method provided by the embodiments of the present application.

[0042] As Figure 1 shown, the index configuration method comprises the following steps:

[0043] Step 101, obtaining index configuration information.

[0044] The index configuration information comes from multiple dimensions. For example, the index configuration information can come from multiple different institutions and multiple different systems. Any institution can correspond to at least one system.

[0045] The index configuration information includes one or more of a system number, a system name, an index code, an index name, an index business description, an index type, an increment judgment field, an organization field name, an organization level, organization summary information, an index processing statement, or an index calculation formula, and an execution sequence number.

[0046] The system number and the system name are used to identify the attribution system of the index; the index type includes one or more of an accumulated value, a current year cumulative value, an era value, an average value, and an increment calculation value; the increment judgment field is used to identify the date of the increment data; the organization field name is used to perform index statistics of the organization dimension; the organization level includes a total bank, a first-level bank, a second-level bank, a branch bank, a network point, a sub-branch, and a seventh-level organization; the organization summary information is used to identify whether the index value has been summarized according to the organization; and the execution sequence number is used to identify the execution sequence of the index calculation formula.

[0047] To more flexibly support the implementation of the index processing and solve the problem that the basic index may be derived from the association of multiple source tables, for the processing of the basic index, the index processing statement or the index calculation formula is written.

[0048] It should be noted that the index configuration information is defined according to the business demand, the analysis of the business logic and the data source of the business concerned index, and the index configuration information including the index code, the index type, the index processing statement or the index calculation formula, the organization level, and the like that need to be configured.

[0049] As an example, the index configuration information that needs to be configured can be specifically defined by designing the following data index configuration table, wherein the table structure of the data index configuration table can be as shown in Table 1:

[0050] Table 1: Data index configuration table example

[0051]

[0052] It should be noted that the data index configuration table is completed by a data analyst, and the data analyst has the ability to write the index processing statement.

[0053] The explanations of the fields in the data index configuration table are as follows:

[0054] 1. Physical primary key, creator, creation time, modifier, and modification time: automatically recorded by the system, and no configuration is needed.

[0055] 2. System number and system name: the system number and the system name defined uniformly by a commercial bank are used to identify the attribution system of the index.

[0056] 3, Index code: self-defined code, the coding rule is: system number + four characters, four characters are any combination of numbers and letters.

[0057] 4, Index name and index business description: fill in the Chinese name of the index and the business meaning of the index.

[0058] 5, Index type: here the index is divided into five types: 01 cumulative value; 02: cumulative value this year; 03: point value; 04: average value; 11: incremental calculation value.

[0059] Among them, 01 cumulative value: indicates the long-term cumulative index value, without a specific start time, for example, the number of customers;

[0060] 02 Cumulative value this year: indicates the cumulative value of this year, such as operating income, which is the operating income of each year, and the calculation start time is January 1 of the current year;

[0061] 03 Point value: indicates the index value of a specific point in time, for example, loan balance, which is the amount of money at a specific point in time;

[0062] 04 Average value: indicates the average value based on a certain statistical dimension, such as daily average deposit balance;

[0063] 11 Incremental calculation value: a branch of cumulative value index type, used to solve the situation that the statistical rules and incremental calculation of incremental index do not completely correspond.

[0064] In related technologies, the incremental value of 01 cumulative value index is obtained by hooking and calculating, such as the daily increment of a cumulative value index = the cumulative value of the day - the cumulative value of the previous day. However, there may be some lag or error correction in actual business, for example, assume that a piece of historical business data that did not occur on the same day is generated on the same day. Since this piece of business is not generated on the same day, the business requires that the historical business data be counted in the cumulative value, but it cannot be counted in the daily increment of the same day. That is, when calculating the index, the historical business data will be counted in the daily cumulative value, but the cumulative value of the previous day is calculated on the previous day, and at that time the system does not contain the historical business data, so the cumulative value of the previous day does not contain the business data. If the daily increment continues to use the formula of the cumulative value of the day - the cumulative value of the previous day to calculate, it will result in that the daily increment of the same day calculates the historical business more, which does not meet the actual business requirements.

[0065] To address this issue, this invention introduces an indicator type called "11 Incremental Calculation Value" for the calculation of derived incremental indicators. Instead of using the calculation logic of 01 cumulative values, an incremental judgment field is introduced. The incremental value of this type of indicator is calculated by automatically adding the incremental judgment field condition to the basic indicator processing SQL statement to meet business needs.

[0066] 6. Incremental Judgment Field: This field is required if the indicator type is an 11-increment calculated value. Multiple fields can be combined. Since this field is used to determine the derived daily, monthly, quarterly, and yearly incremental indicator data, their field type must be date. If they are not date types, date functions can be used to convert them to date types first. For indicator types other than 11-increment calculated value, no incremental judgment field information needs to be configured.

[0067] 7. Organization Field Name: To enable convenient and efficient querying of the value of any indicator and at least one derived indicator for any organization at any time through the indicator information table—that is, to analyze the business development of each organization based on the organization dimension—the actual displayed indicators are all organization-based indicators. Since the organization field names may differ between different data source tables, it is necessary to specify the organization field name when configuring the indicator configuration information for organization-level indicator statistics. If not specified, the most common organization field name, INSNO, will be used by default.

[0068] 8. Institutional Levels: Based on the characteristics of commercial banks' institutional levels, this invention defines seven levels, primarily used for the aggregation and calculation of derived indicators at each institutional level. The appropriate level can be selected based on the required granularity of the institutional level to be displayed. The definitions of the seven institutional levels are shown in Table 2.

[0069] Table 2 Examples of Organizational Hierarchy Definitions

[0070] HIERARCHY NUMBER ORGANIZATIONAL HIERARCHY 1 1: Head Office 2 2: Head Office, Level 1 3 3: Head Office, Level 1, Level 2 4 4: Head Office, Level 1, Level 2, Branch 5 5: Head Office, Level 1, Level 2, Branch, Outlet 6 6: Head Office, Level 1, Level 2, Branch, Outlet, Sub-branch 7 7: Head Office, Level 1, Level 2, Branch, Outlet, Sub-branch, Level 7

[0071] As shown in Table 2, the head office is the superior organization of the first-level branches, the first-level branches are the superior organizations of the second-level branches, the second-level branches are the superior organizations of the branches, the branches are the superior organizations of the outlets, the outlets are the superior organizations of the sub-branches, and the sub-branches are the superior organizations of the seventh-level organizations.

[0072] 9. Organizational Summary Information: This indicates whether the indicator values ​​have been summarized by organization. In other words, whether the indicator data of each organization in the indicator data source is only the data of its own organization, or whether it includes the summarized data of the organization at the same level and its subordinate organizations. The default value is 0, which means that the indicator data is only the data of the organization itself.

[0073] 10、index processing statement or index calculation formula: used for storing the index processing statement or index calculation formula of index calculation. Alternatively, the index processing statement can be an SQL statement, at this time, the SQL is allowed to be flexibly written, and the multi-table association is allowed in the SQL, but the index field must use the index code as an alias, and the basic index value can be directly queried through the SQL statement. If the index is derived and calculated based on addition, subtraction, multiplication and division of multiple indexes, the calculation formula of the index is filled in.

[0074] 11、execution order number: if the index processing is an SQL statement, the value is 1, if the index is derived and calculated based on addition, subtraction, multiplication and division of other indexes, the execution order number is sequentially increased to ensure that the index value of the dependent index is calculated when the loop calculation index is calculated.

[0075] 12、whether manual initialization is completed: used for index initialization, which can be ignored in daily use, and the default value is 0, indicating that the manual initialization is not completed.

[0076] Step 102, for any index in the index configuration information, the index value of the index is determined according to the index configuration information.

[0077] In some embodiments, for any index in the index configuration information, the index value of the index can be determined according to the index processing statement or index calculation formula of the index indicated by the index configuration information.

[0078] Alternatively, the index configuration information can be read in a loop until all indexes in the index configuration information are automatically processed. When any index in the index configuration information is read, the processing mode of the index can be determined according to the index configuration information, that is, whether the index processing statement or the index calculation formula, if the processing mode of the index is the index processing statement, the index value of the index is obtained by running the index processing statement of the index indicated by the index configuration information, if the processing mode of the index is the index calculation formula, the index value of the index is obtained by calculating the index calculation formula of the index indicated by the index configuration information.

[0079] Step 103, at least one derived index value of the index is determined according to the index configuration information or the preset index calculation rule.

[0080] Among them, the derived index refers to the index derived based on the basic index, including the incremental index (such as: daily increment, monthly increment, quarterly increment, annual increment, etc.), the comparison index (such as: compared with the previous day, compared with the same period of the previous month, compared with the same period of the previous quarter, compared with the same period of the previous year, etc.), the ratio index (such as: monthly same period / compared with the same period, quarterly same period / compared with the same period, annual growth rate, etc.) and the like.

[0081] The derived index value includes one or more of an incremental value, a comparison value, and a ratio value, and the preset index calculation rule includes one or more of a preset incremental value calculation rule, a preset comparison value calculation rule, and a preset ratio value calculation rule.

[0082] In some embodiments, when the index type of the index indicated by the index configuration information is an incremental calculation value, at least one incremental value of the index is determined according to the index processing statement or the index calculation formula of the index indicated by the index configuration information, at least one comparison value of the index is determined according to a preset comparison value calculation rule corresponding to the incremental calculation value, and at least one ratio value of the index is determined according to the at least one incremental value and a preset ratio value calculation rule. Alternatively, when the index type of the index indicated by the index configuration information is not an incremental value statistical query, at least one incremental value of the index is determined according to a preset incremental value calculation rule corresponding to the index type of the index indicated by the index configuration information, at least one comparison value of the index is determined according to a preset comparison value calculation rule corresponding to the index type of the index indicated by the index configuration information, and at least one ratio value of the index is determined according to the at least one incremental value and a preset ratio value calculation rule.

[0083] That is, when the index type of the index is an incremental calculation value, the incremental value of the index is determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information; when the index type of the index is not an incremental calculation value, the incremental value of the index is determined based on a preset incremental value calculation rule corresponding to the index type of the index indicated by the index configuration information. In addition, whether the index type of the index is an incremental calculation value or not, the comparison value of the index is determined based on a preset comparison value calculation rule corresponding to the index type of the index indicated by the index configuration information, and whether the index type of the index is an incremental calculation value or not, the ratio value of the index is determined based on the incremental value of the index and a preset ratio value calculation rule.

[0084] In step 104, according to the dimensions to which the indexes belong, the index values and at least one derived index value of at least one index belonging to the same dimension are stored in the same index information table, so as to perform information pushing based on the at least one index information table.

[0085] In some embodiments, a wide table and a narrow table can be fused to store indexes, and the index values and at least one derived index value of any index of the same dimension are stored in a record in the same index information table, facilitating business query use, avoiding multi-table association and multi-data integration processing, simplifying query use, and improving query performance.

[0086] As an example, the table structure of the index information table is shown in Table 3.

[0087] Table 3 index information table example

[0088]

[0089] Wherein, the data date, the agency number, the index code, and the agency summary information are the primary keys, the primary key order number of the data date is 1, the primary key order number of the agency number is 2, the primary key order number of the index code is 3, and the primary key order number of the agency summary information is 4, and the data date, the agency number, the index code, and the agency summary information cannot be empty. Optionally, the default value of the agency summary information is 0, indicating that the index data is only the data of the agency. The default value of the deletion identifier is also 0.

[0090] Therefore, when the business personnel need to query the index situation, the current value, the incremental value, the comparison value, and the ratio value of the relevant business index of the corresponding agency can be quickly and conveniently obtained by selecting the time, the agency, and the index code through the index information table, without multiple table association queries and the calculation and processing of multiple data records, so that the query performance is guaranteed and the use is convenient and efficient.

[0091] In the embodiment, the index configuration information is obtained, wherein the index configuration information comes from multiple dimensions, any index in the index configuration information is determined according to the index configuration information, the index value of the index is determined, and at least one derived index value of the index is determined according to the index configuration information or a preset index calculation rule, so that the index value and the at least one derived index value of at least one index belonging to the same dimension are stored in the same index information table according to the dimension to which each index belongs, and information pushing is performed based on at least one index information table. Therefore, the index data can be automatically processed based on the index configuration information and the preset index calculation rule, without the need to develop a corresponding index processing program for each index data, the repeated development work of the index processing program is avoided, and the index processing complexity is reduced. At the same time, the index value and the at least one derived index value of any index of any period of any agency can be conveniently and efficiently queried through the index information table, without the need to associate multiple table queries and perform multiple record calculation processing, so that the index processing and index query performance are greatly improved, and the business demand can be quickly responded.

[0092] From the above analysis, at least one derived index value of an index can be determined according to the index configuration information or the preset index calculation rule in the present application. In order to clearly illustrate this process, another index configuration method is provided in the embodiment. Figure 2 The flowchart of the another index configuration method provided in the embodiment of the present application is shown.

[0093] It should be noted that in the embodiments of the present application, the derived index value includes one or more of an incremental value, a comparison value and a ratio value, and the preset index calculation rule includes one or more of a preset incremental value calculation rule, a preset comparison value calculation rule and a preset ratio value calculation rule.

[0094] As shown in Figure 2 The index configuration method can include the following steps:

[0095] Step 201, obtaining index configuration information.

[0096] Step 202, for any index in the index configuration information, determining the index value of the index according to the index configuration information.

[0097] It should be noted that the execution process of steps 201-202 can refer to steps 101-102 in the previous embodiment for details, and the principle is the same, which will not be repeated here.

[0098] Step 203, in the case where the index type of the index indicated by the index configuration information is an incremental calculation value, determining at least one incremental value of the index according to the index processing statement or the index calculation formula of the index indicated by the index configuration information.

[0099] The at least one incremental value can include one or more of a daily incremental value, a monthly incremental value, a quarterly incremental value and an annual incremental value.

[0100] In some embodiments, in the case where the processing mode of the index indicated by the index configuration information is an index processing statement, and the index type of the index indicated by the index configuration information is an incremental calculation value, at least one incremental value of the index can be determined according to the index processing statement of the index indicated by the index configuration information. Alternatively, in the case where the processing mode of the index indicated by the index configuration information is an index calculation formula, and the index type of the index indicated by the index configuration information is an incremental calculation value, at least one incremental value of the index can be determined according to the index calculation formula of the index indicated by the index configuration information.

[0101] Optionally, if the index processing statement of the index indicated by the index configuration information is an SQL statement, the index processing statement can include an SQL statement in which a data analyst uses casewhen to judge and process according to the incremental judgment field of the index indicated by the index configuration information, to calculate at least one incremental value of the index. Specifically, if the incremental value is a COUNT counting function, the incremental judgment field is set to 1 if it meets the condition, and 0 if it does not meet the condition, and then the total is calculated; if the incremental value is a SUM / AVG / MAX / MIN aggregation function, the field value is taken if the incremental judgment field meets the condition, and null if it does not meet the condition, and then the calculation is performed.

[0102] In step 204, in a case where the metric type of the metric indicated by the metric configuration information is not the incremental value statistical query, at least one incremental value of the metric is determined according to a preset incremental value calculation rule corresponding to the metric type of the metric indicated by the metric configuration information.

[0103] In some embodiments, in a case where the metric type of the metric indicated by the metric configuration information is the accumulated value or the average value, a difference value between the metric value of the metric and the last day metric value of the metric is determined as the daily incremental value of the metric; a difference value between the metric value of the metric and the last month-end metric value of the metric is determined as the monthly incremental value of the metric; a difference value between the metric value of the metric and the last quarter-end metric value of the metric is determined as the quarterly incremental value of the metric; and a difference value between the metric value of the metric and the last year-end metric value of the metric is determined as the annual incremental value of the metric.

[0104] Alternatively, in a case where the metric type of the metric indicated by the metric configuration information is the current year accumulated value, if the date of the metric is the first day of the current year, the metric value of the metric is determined as the daily incremental value of the metric, otherwise a difference value between the metric value of the metric and the last day metric value of the metric is determined as the daily incremental value of the metric; if the date of the metric is the first month of the current year, the metric value of the metric is determined as the monthly incremental value of the metric, otherwise a difference value between the metric value of the metric and the last month-end metric value of the metric is determined as the monthly incremental value of the metric; if the date of the metric is the first quarter of the current year, the metric value of the metric is determined as the quarterly incremental value of the metric, otherwise a difference value between the metric value of the metric and the last quarter-end metric value of the metric is determined as the quarterly incremental value of the metric; and the metric value of the metric is determined as the annual incremental value of the metric.

[0105] Alternatively, in a case where the metric type of the metric indicated by the metric configuration information is the point value, the metric value of the metric is determined as the daily incremental value of the metric; if the date of the metric is the first day of the month, the metric value of the metric is determined as the monthly incremental value of the metric, otherwise a sum of the metric value of the metric and the last day monthly incremental value of the metric is determined as the monthly incremental value of the metric; if the date of the metric is the first day of the quarter, the metric value of the metric is determined as the quarterly incremental value of the metric, otherwise a sum of the metric value of the metric and the last day quarterly incremental value of the metric is determined as the quarterly incremental value of the metric; if the date of the metric is the first day of the current year, the metric value of the metric is determined as the annual incremental value of the metric, otherwise a sum of the metric value of the metric and the last day annual incremental value of the metric is determined as the annual incremental value of the metric.

[0106] As an example, the preset incremental value calculation rules of the accumulated value, the average value, the current year accumulated value and the point value can be as shown in Table 4:

[0107] Table 4: Example of preset incremental value calculation rules At step 205, at least one comparison value of the index is determined according to a preset comparison value calculation rule corresponding to the index type of the index indicated by the index configuration information.

[0108] The at least one comparison value can include one or more of a same period increment value compared with a previous day, a same period increment value compared with a previous month, a same period increment value compared with a previous quarter, and a same period increment value compared with a previous year.

[0109] In some embodiments, in a case where the index type of the index indicated by the index configuration information is an increment calculation value, a difference between the index value of the index and an index value of the index of a previous day is determined as the same period increment value compared with the previous day of the index; a difference between the index value of the index and an index value of the index of a previous month is determined as the same period increment value compared with the previous month of the index; a difference between the index value of the index and an index value of the index of a previous quarter is determined as the same period increment value compared with the previous quarter of the index; and a difference between the index value of the index and an index value of the index of a previous year is determined as the same period increment value compared with the previous year of the index.

[0110] Alternatively, in a case where the index type of the index indicated by the index configuration information is any one of an accumulated value, an average value, and a point-in-time value, a difference between the index value of the index and an index value of the index of a previous day is determined as the same period increment value compared with the previous day of the index; a difference between the index value of the index and an index value of the index of a previous month is determined as the same period increment value compared with the previous month of the index; a difference between the index value of the index and an index value of the index of a previous quarter is determined as the same period increment value compared with the previous quarter of the index; and a difference between the index value of the index and an index value of the index of a previous year is determined as the same period increment value compared with the previous year of the index.

[0111] Alternatively, if the index type of the index indicated by the index configuration information is a current year cumulative value, if the date of the index is the first day of the current year, a difference between the index value of the index and the index value of the previous day of the index is determined as a first difference value, and a sum of the first difference value and the index value of the previous day of the index is determined as the same period incremental value of the previous day of the index, otherwise, a difference between the index value of the index and the index value of the previous day of the index is determined as the same period incremental value of the previous day of the index; if the date of the index is the first month of the current year, a difference between the index value of the index and the same period index value of the previous month of the index is determined as a second difference value, and a sum of the second difference value and the index value of the previous month of the index is determined as the same period incremental value of the previous month of the index, otherwise, a difference between the index value of the index and the same period index value of the previous month of the index is determined as the same period incremental value of the previous month of the index; if the date of the index is the first quarter of the current year, a difference between the index value of the index and the same period index value of the previous quarter of the index is determined as a third difference value, and a sum of the third difference value and the index value of the previous quarter of the index is determined as the same period incremental value of the previous quarter of the index, otherwise, a difference between the index value of the index and the same period index value of the previous quarter of the index is determined as the same period incremental value of the previous quarter of the index; a difference between the index value of the index and the same period index value of the previous year of the index is determined as the same period incremental value of the previous year of the index.

[0112] As an example, the preset comparison value calculation rule can be as shown in Table 5:

[0113] Table 5: Example of preset comparison value calculation rule

[0114]

[0115] Step 206: determining at least one ratio value of the index according to at least one incremental value of the index and a preset ratio value calculation rule.

[0116] The at least one ratio value includes one or more of monthly same period comparison, monthly period comparison, quarterly same period comparison, quarterly period comparison, and annual growth rate.

[0117] In some embodiments, if the same period monthly incremental value of the previous year of the index is a first preset value, the monthly same period comparison of the index is set to a second preset value, or if the same period monthly incremental value of the previous year of the index is not the first preset value, a difference between the monthly incremental value of the index and the same period monthly incremental value of the previous year of the index is determined as a first intermediate value, and a ratio between the first intermediate value and the same period monthly incremental value of the previous year of the index is determined as the monthly same period comparison of the index.

[0118] Alternatively, the monthly growth rate of the index can be set to a fourth preset value when the increment value of the index in the same month of the previous month is the third preset value, or the difference between the increment value of the index and the increment value of the index in the same month of the previous month is determined as a second intermediate value when the increment value of the index in the same month of the previous month is not the second preset value, and the ratio between the second intermediate value and the increment value of the index in the same month of the previous month is determined as the monthly growth rate of the index.

[0119] Alternatively, the quarterly growth rate of the index can be set to a sixth preset value when the increment value of the index in the same quarter of the previous year is the fifth preset value, or the difference between the increment value of the index and the increment value of the index in the same quarter of the previous year is determined as a third intermediate value when the increment value of the index in the same quarter of the previous year is not the third preset value, and the ratio between the third intermediate value and the increment value of the index in the same quarter of the previous year is determined as the quarterly growth rate of the index.

[0120] Alternatively, the quarterly growth rate of the index can be set to a sixth preset value when the increment value of the index in the same quarter of the previous year is the fifth preset value, or the difference between the increment value of the index and the increment value of the index in the same quarter of the previous year is determined as a third intermediate value when the increment value of the index in the same quarter of the previous year is not the third preset value, and the ratio between the third intermediate value and the increment value of the index in the same quarter of the previous year is determined as the quarterly growth rate of the index.

[0121] Alternatively, the annual growth rate of the index can be set to a tenth preset value when the increment value of the index in the previous year is the ninth preset value, or the difference between the increment value of the index and the increment value of the index in the previous year is determined as a fifth intermediate value when the increment value of the index in the previous year is not the fifth preset value, and the ratio between the fifth intermediate value and the increment value of the index in the previous year is determined as the annual growth rate of the index.

[0122] The values of the first preset value to the tenth preset value are not limited in the embodiments of the present application. Alternatively, the first preset value to the tenth preset value can be set according to artificial experience, for example, the first preset value to the tenth preset value can be set to the same value (for example, the first preset value to the tenth preset value can be set to 0), or at least one of the first preset value to the tenth preset value can be set to a different value (for example, the first preset value, the third preset value, the fifth preset value, the seventh preset value and the ninth preset value can be set to 0, and the second preset value, the fourth preset value, the sixth preset value, the eighth preset value and the tenth preset value can be set to 0), or the first preset value to the tenth preset value can be dynamically adjusted according to actual application requirements, which is not limited in the embodiments.

[0123] As an example, the preset ratio value calculation rule can be as shown in Table 6:

[0124] Table 6: Example of preset ratio value calculation rule In step 207, according to the dimension to which each index belongs, the index values of at least one index and the at least one derived index value belonging to the same dimension are stored in the same index information table, so as to push information based on the at least one index information table.

[0125] It should be noted that the execution process of the present step can refer to step 104 in the previous embodiment for details, and the principle is the same, which will not be described here again.

[0126] In the present embodiment, in the case where the index type of the index indicated by the index configuration information is an incremental value, at least one incremental value of the index is determined according to the index processing statement or the index calculation formula of the index indicated by the index configuration information. In the case where the index type of the index indicated by the index configuration information is not an incremental value statistical query, at least one incremental value of the index is determined according to the preset incremental value calculation rule corresponding to the index type of the index indicated by the index configuration information. Thus, at least one comparison value of the index is determined according to the preset comparison value calculation rule corresponding to the index type of the index indicated by the index configuration information, and at least one ratio value of the index is determined according to the preset ratio value calculation rule. Therefore, at least one derived index value of the index is automatically determined according to the index configuration information or the preset index calculation rule.

[0127] Optionally, in the present application, the viewing statistics of the index is based on the agency dimension, which is used to analyze the business development of the whole bank or a branch bank, and therefore, each index needs to be summarized according to the agency. The following will be described in combination with Figure 3 the process.

[0128] As shown in Figure 2 , the index configuration method can include the following steps:

[0129] In step 301, index configuration information is obtained.

[0130] In step 302, for any index in the index configuration information, the index value of the index is determined according to the index configuration information.

[0131] In step 303, in the case where the index type of the index indicated by the index configuration information is an incremental value, at least one incremental value of the index is determined according to the index processing statement or the index calculation formula of the index indicated by the index configuration information.

[0132] It should be noted that the execution process of steps 301-303 can refer to steps 201-203 in the previous embodiment for details, and the principle is the same, which will not be described here again.

[0133] Step 304, adding the index value of the index and the at least one incremental value of the index to the index intermediate table, or adding the index value of the index to the index intermediate table.

[0134] The index intermediate table is used to store the index data aggregated by the institution.

[0135] In some embodiments, the index value of the index and the at least one incremental value of the index are added to the index intermediate table in a case where both the index value of the index and the at least one incremental value of the index are determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information, or only the index value of the index is added to the index intermediate table in a case where the index value of the index is determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information, and the at least one incremental value of the index is not determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information, so that the incremental value and the comparison value are calculated based on the index value and the incremental value stored in the index intermediate table and corresponding preset index calculation rules for different index types.

[0136] As an example, the table structure of the index intermediate table is shown in Table 7:

[0137] Table 7 Index Intermediate Table Example The data date, the institution number, the index code, and the institution aggregation information are primary keys, the primary key sequence number of the data date is 1, the primary key sequence number of the institution number is 2, the primary key sequence number of the index code is 3, and the primary key sequence number of the institution aggregation information is 4, and the data date, the institution number, the index code, and the institution aggregation information cannot be empty. Optionally, the default value of the institution aggregation information is 0, indicating that the index data is only the data of the institution.

[0138] It should be noted that in the index intermediate table, the daily incremental value, the monthly incremental value, the quarterly incremental value, and the annual incremental value have corresponding values only when the index type is 11 incremental calculation value, and the values of the four fields are empty for other index types.

[0139] Step 305, in a case where the index value of the index is determined based on the index processing statement of the index indicated by the index configuration information, determining whether the index has been aggregated by the institution according to the institution aggregation information of the index indicated by the index configuration information.

[0140] It should be noted that in the present application, it is only determined whether the index has been aggregated by the institution in a case where the index value of the index is determined based on the index processing statement of the index indicated by the index configuration information. In a case where the index value of the index is determined based on the index calculation formula of the index indicated by the index configuration information, the calculation formula has been aggregated by the institution, and therefore it is not necessary to determine whether the index has been aggregated by the institution.

[0141] Since the institution summary information in the index configuration information is used to identify whether the index value has been summarized by institution, in some embodiments, in the case where the index value of the index is determined based on the index processing statement of the index indicated by the index configuration information, it can be determined whether the index has been summarized by institution according to the institution summary information of the index indicated by the index configuration information.

[0142] Step 306, in the case where the index is not summarized by institution, the index values of the index at each level are summarized to the index intermediate table level by level upwards according to the institution level of the index indicated by the index configuration information and the institution level to be summarized.

[0143] Since the institution level includes the head office, the first-level branch, the second-level branch, the branch, the outlet, the sub-branch, and the seventh-level institution, wherein the head office is the superior institution of the first-level branch, the first-level branch is the superior institution of the second-level branch, the second-level branch is the superior institution of the branch, the branch is the superior institution of the outlet, the outlet is the superior institution of the sub-branch, and the sub-branch is the superior institution of the seventh-level institution, in some embodiments, the level-by-level upwards summarization refers to the summarization of the seventh-level institution to the sub-branch, the summarization of the sub-branch to the branch, the summarization of the branch to the second-level branch, the summarization of the second-level branch to the first-level branch, and the summarization of the first-level branch to the head office.

[0144] In some embodiments, for the case where the index has not been summarized by institution, the data can be summarized level by level upwards according to the configured need summary level and the level to which the unsummarized institution belongs (the seventh-level institution is summarized to the sub-branch; the sub-branch is summarized to the branch; the branch is summarized to the second-level branch; the second-level branch is summarized to the first-level branch; and the first-level branch is summarized to the head office), so that after the summarization, any level institution has a summary index value of all the institutions under its jurisdiction.

[0145] Step 307, in the case where the index type of the index indicated by the index configuration information is not the incremental value statistical query, at least one incremental value of the index is determined according to the preset incremental value calculation rule corresponding to the index type of the index indicated by the index configuration information.

[0146] Step 308, at least one comparison value of the index is determined according to the preset comparison value calculation rule corresponding to the index type of the index indicated by the index configuration information.

[0147] Step 309, at least one ratio value of the index is determined according to the preset ratio value calculation rule and the at least one incremental value of the index.

[0148] Step 310, the index values and the at least one derived index value of the at least one index belonging to the same dimension are stored in the same index information table according to the dimension to which each index belongs, so as to perform information pushing based on the at least one index information table.

[0149] It should be noted that the execution process of steps 307-310 can refer to steps 204-207 in the previous embodiment for details, and the principles are the same, which will not be repeated here.

[0150] In the embodiment, in the case that the index type of the index indicated by the index configuration information is an incremental value, at least one incremental value of the index is determined according to the index processing statement or the index calculation formula of the index indicated by the index configuration information, and then whether the index has been aggregated by the organization is determined according to the organization aggregation information of the index indicated by the index configuration information, so that in the case that the index has not been aggregated by the organization, the index value of the index and the at least one incremental value of the index are aggregated to the organization level to be aggregated level by level upwards according to the organization level of the index indicated by the index configuration information and the organization level to be aggregated. In the case that the index type of the index indicated by the index configuration information is not an incremental value statistical query, at least one incremental value of the index is determined according to the preset incremental value calculation rule corresponding to the index type of the index indicated by the index configuration information, and then the index value of the index determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information, or the index value of the index and the at least one incremental value of the index are added to the index intermediate table. Thus, the index value of the index and the derived index value can be stored in the index information table according to the organization dimension.

[0151] In order to clearly illustrate the above-mentioned embodiments, examples are provided.

[0152] According to the needs of business index query of commercial banks, in order to quickly grasp the development of various businesses and improve work efficiency, the embodiment of the application provides a kind of configuration index automatic processing and fusion storage implementation method, and it is generally divided into three steps of index configuration, index automatic processing and index fusion storage, index convenient query.

[0153] I. Index configuration

[0154] Index configuration refers to the index configuration information including index code, index type, index processing statement or index calculation formula, organization level and other information that needs to be configured, which is defined according to business needs, analyzing the business logic and data sources of business concerned indicators.

[0155] II. Index automatic processing and index fusion storage

[0156] After completing the index configuration, the index automatic processing can be realized based on the index configuration information, and the processed index data is stored in the index intermediate table and the index information table. Finally, the index value and the derived value of each index are fused in a record, which is convenient for business to query quickly and conveniently.

[0157] Optionally, the implementation steps of the index automatic processing and fusion storage are as shown in Figure 4

[0158] Step 401, start.

[0159] Step 402, loop to read the index configuration information.

[0160] Here, the index configuration information can be looped to read until all indexes are automatically processed.

[0161] Step 403, determine whether the loop is ended, divided into two cases:

[0162] One is that the loop is ended, entering step 416;

[0163] The other is that the loop is not ended, entering step 404.

[0164] Step 404, determine whether the index processing mode is an index processing statement or an index calculation formula, divided into two cases:

[0165] One is that the index processing mode is an index calculation formula, entering step 405;

[0166] The other is that the index processing mode is an index processing statement, entering step 408.

[0167] Step 405, determine whether the index type is an incremental calculation value, divided into two cases:

[0168] One is that the index type is an incremental calculation value, entering step 406;

[0169] The other is that the index type is not an incremental calculation value, entering step 407.

[0170] Step 406, process the index value and the incremental value into the index intermediate table according to the index calculation formula.

[0171] Here, if the index type is an incremental calculation value, the index value and the incremental value are processed into the index intermediate table according to the index calculation formula. The incremental value can include one or more of the daily incremental value, the monthly incremental value, the quarterly incremental value, and the annual incremental value. As an example, the table structure of the index intermediate table is shown in Table 7.

[0172] It should be noted that after this step is executed, step 413 is entered.

[0173] Step 407, process the index value into the index intermediate table according to the index calculation formula.

[0174] Here, if the index type is not an incremental calculation value, only the index value is processed into the index intermediate table according to the index calculation formula. As an example, the table structure of the index intermediate table is shown in Table 7.​

[0175] It should be noted that after this step is executed, step 413 is entered.

[0176] Step 408: Determine whether the index type is an incremental calculation value, and divide into two cases:

[0177] One is that the index type is an incremental calculation value, and step 409 is entered.

[0178] The other is that the index type is not an incremental calculation value, and step 410 is entered.

[0179] Step 409: Process the index value and the incremental value into the intermediate table according to the index processing statement.

[0180] Here, if the index type is an incremental calculation value, the index value and the incremental value are processed into the index intermediate table according to the index calculation formula. The incremental value can include one or more of the daily incremental value, the monthly incremental value, the quarterly incremental value, and the annual incremental value. As an example, the table structure of the index intermediate table is shown in Table 7.

[0181] Optionally, in response to the index processing statement being an SQL statement, if the index type is an incremental calculation value, the case when is used for judgment processing according to the incremental judgment field information, and the processing statement of the daily, monthly, quarterly, and annual incremental index is constructed (if the index value is the COUNT counting function, 1 is set if the incremental date judgment condition is met, and 0 is set if the condition is not met, and then the total is calculated; if the index value is the SUM / AVG / MAX / MIN aggregation function, the field value is taken if the incremental field judgment condition is met, and null is set if the condition is not met, and then the calculation is performed), so that the constructed daily, monthly, quarterly, and annual incremental index processing statement is spliced into the processing SQL statement of the index value, and then the SQL statement is run to process the index value and the daily, monthly, quarterly, and annual incremental index into the index intermediate table.

[0182] It should be noted that after this step is executed, step 411 is entered.

[0183] Step 410: Process the index value into the index intermediate table according to the index processing statement.

[0184] Here, if the index type is not an incremental calculation value, the index processing statement is only used to calculate the index value of the index at this time, so that the index processing statement can be run to process the index value of the index into the index intermediate table. As an example, the table structure of the index intermediate table is shown in Table 7.

[0185] It should be noted that after this step is executed, step 411 is entered.

[0186] Step 411: Determine whether the index has been aggregated by organization, and divide into two cases:

[0187] One is that the index is not aggregated by the institution, entering step 412;

[0188] The other is that the index has been aggregated by the institution, entering step 413.

[0189] It should be noted that in the present application, only for the case where the index processing mode is an index processing statement, it is judged whether the index has been aggregated by the institution. For the case where the index processing mode is an index calculation formula, since the calculation formula has been aggregated by the institution, it is not necessary to judge whether the index has been aggregated by the institution.

[0190] In step 412, according to the configured aggregation level, the index values of each level of institution are aggregated to the intermediate table step by step.

[0191] Here, for the case where the index has not been aggregated by the institution, according to the configured required aggregation level and the level to which the un-aggregated institution belongs, the data is aggregated step by step (the seven-level institution is aggregated to the branch office; the branch office is aggregated to the branch; the branch is aggregated to the two-level bank; the two-level bank is aggregated to the one-level bank; the one-level bank is aggregated to the head office), so that after aggregation, each level of institution has a summary index value of all the institutions under it.

[0192] In step 413, according to the index type, the corresponding preset index calculation rule is adopted to calculate the comparison value, or to calculate the increment value and the comparison value.

[0193] The increment value can include one or more of the daily increment value, the monthly increment value, the quarterly increment value and the annual increment value. The comparison value can include one or more of the same period increment value compared with the previous day, the same period increment value compared with the previous month, the same period increment value compared with the previous quarter and the same period increment value compared with the previous year. The preset index calculation rule can include one or more of the preset increment value calculation rule, the preset comparison value calculation rule and the preset ratio value calculation rule.

[0194] Here, if this step is executed after step 406, according to the index type, the corresponding preset index calculation rule is adopted to calculate the comparison value; if this step is executed after step 407, according to the index type, the corresponding preset index calculation rule is adopted to calculate the increment value and the comparison value; if this step is executed after step 411 or step 412, if the previous step of step 411 is step 409, according to the index type, the corresponding preset index calculation rule is adopted to calculate the comparison value; if the previous step of step 411 is step 410, according to the index type, the corresponding preset index calculation rule is adopted to calculate the increment value and the comparison value.

[0195] As an example, the increment value can be calculated according to the preset increment value calculation rule as shown in Table 4, and the comparison value can be calculated according to the preset comparison value calculation rule as shown in Table 5.

[0196] Step 414, calculating the ratio value according to the increment value and the preset ratio value calculation rule.

[0197] As an example, the preset ratio value calculation rule as shown in Table 6 can be used to calculate the ratio value.

[0198] Step 415, storing the same dimension indicator value, increment value, comparison value and ratio value into the indicator information table.

[0199] Here, the calculated same dimension indicator value, increment value, comparison value and ratio value can be stored in the same record of the indicator information table, facilitating business convenient and quick query.

[0200] Step 416, end.

[0201] III. Indicator convenient query

[0202] When the business personnel need to query the indicator, the current value, increment value, comparison value and ratio value of the corresponding business indicator of the agency can be quickly and conveniently obtained by selecting the time, agency and indicator code from the indicator information table as shown in Table 3, without the need for multiple table association query and multiple data record calculation processing, the query performance is guaranteed, and the use is convenient and efficient.

[0203] In summary, in order to meet the business indicator query needs of commercial banks, quickly respond to business needs, improve the accuracy of indicator processing and the consistency of calculation rule caliber, while taking into account the indicator processing and indicator query performance, avoiding repeated development of indicator processing programs, and improving work efficiency, the application provides a configured indicator automatic processing and fusion storage implementation method. Through the configured indicator automatic processing and fusion storage implementation method of the application, the problems of repeated development of indicator processing programs, inconsistent processing caliber of increment ratio value ratio calculation, delayed indicator processing response, poor accuracy of indicator processing results, complex indicator query and poor indicator query performance of the existing indicator processing implementation method are effectively solved, the work efficiency is greatly improved, and the unified management of indicator information is realized, facilitating the later maintenance of business indicators and further developing indicator analysis work.

[0204] In the present application, the implementation method and configuration template of index information are designed, and the data analysis personnel can flexibly configure the index information concerned by the business according to the template. The index intermediate table and the index information table are designed, and the cyclic reading of index configuration information is realized based on the two tables. According to the index type, the index processing mode, the organization aggregation level and other configuration information, the index value is automatically processed and stored in the index intermediate table. Then, according to the set derivative index processing rules, the incremental value, the comparison value and the ratio value of the index and other derivative index values are processed. Finally, the related values of the indexes of the same dimension are fused and stored in the same record of the index information table. The whole processing process is automatically judged and processed based on the configuration information, the calculation rules are unified, and the processing process is clear and efficient. Therefore, the business personnel can conveniently and efficiently query the index information such as the index value, the incremental value, the comparison value and the ratio value of any period of any organization through the index information table, without the need of multiple table association and multiple record query processing. The index processing and business query performance are greatly improved, the index processing complexity is reduced, the accuracy of the index processing and the consistency of the derivative index processing rules are improved, the business demand can be quickly responded, the unified management of the business index is realized, and the business development is promoted.

[0205] In order to realize the above-mentioned embodiment, the present application further provides an index configuration device.

[0206] Figure 5 The structure diagram of the index configuration device provided by the embodiment of the present application is shown.

[0207] As shown in Figure 5 the index configuration device comprises an acquisition module 51, a first determination module 52, a second determination module 53 and a processing module 54.

[0208] The acquisition module 51 is used for acquiring index configuration information; wherein the index configuration information comes from multiple dimensions;

[0209] The first determination module 52 is used for determining the index value of the index according to the index configuration information for any index in the index configuration information.

[0210] The second determination module 53 is used for determining at least one derivative index value of the index according to the index configuration information or according to a preset index calculation rule.

[0211] The processing module 54 is used for storing the index value and the at least one derivative index value of at least one index belonging to the same dimension into the same index information table according to the dimension to which each index belongs, so as to perform information pushing based on at least one index information table.

[0212] Further, in a possible implementation of the embodiment of the present application, the derived indicator value includes one or more of an incremental value, a comparison value and a ratio value, the preset indicator calculation rule includes one or more of a preset incremental value calculation rule, a preset comparison value calculation rule and a preset ratio value calculation rule; the second determination module 53 includes:

[0213] The first determination unit is configured to, in a case where the indicator type of the indicator indicated by the indicator configuration information is an incremental calculation value, determine at least one incremental value of the indicator according to the indicator processing statement or the indicator calculation formula of the indicator indicated by the indicator configuration information.

[0214] The second determination unit is configured to, in a case where the indicator type of the indicator indicated by the indicator configuration information is not an incremental value statistical query, determine at least one incremental value of the indicator according to a preset incremental value calculation rule corresponding to the indicator type of the indicator indicated by the indicator configuration information.

[0215] The third determination unit is configured to determine at least one comparison value of the indicator according to a preset comparison value calculation rule corresponding to the indicator type of the indicator indicated by the indicator configuration information.

[0216] The fourth determination unit is configured to determine at least one ratio value of the indicator according to the at least one incremental value and a preset ratio value calculation rule.

[0217] Further, in a possible implementation of the embodiment of the present application, the at least one incremental value includes one or more of a daily incremental value, a monthly incremental value, a quarterly incremental value and an annual incremental value; and the second determination unit is further configured to:

[0218] In a case where the indicator type of the indicator indicated by the indicator configuration information is an accumulated value or a mean value, determine a difference between the indicator value of the indicator and a previous day indicator value of the indicator as the daily incremental value of the indicator, determine a difference between the indicator value of the indicator and a previous month end indicator value of the indicator as the monthly incremental value of the indicator, determine a difference between the indicator value of the indicator and a previous quarter end indicator value of the indicator as the quarterly incremental value of the indicator, and determine a difference between the indicator value of the indicator and a previous year end indicator value of the indicator as the annual incremental value of the indicator.

[0219] In a case where the index type of the index indicated by the index configuration information is a current year accumulated value, if the date of the index is the first day of the current year, the index value of the index is determined as the daily increment value of the index, otherwise the difference between the index value of the index and the previous day index value of the index is determined as the daily increment value of the index; if the date of the index is the first month of the current year, the index value of the index is determined as the monthly increment value of the index, otherwise the difference between the index value of the index and the last month end index value of the index is determined as the monthly increment value of the index; if the date of the index is the first quarter of the current year, the index value of the index is determined as the quarterly increment value of the index, otherwise the difference between the index value of the index and the last quarter end index value of the index is determined as the quarterly increment value of the index; the index value of the index is determined as the annual increment value of the index;

[0220] In a case where the index type of the index indicated by the index configuration information is a point value, the index value of the index is determined as the daily increment value of the index; if the date of the index is the first day of a month, the index value of the index is determined as the monthly increment value of the index, otherwise the sum of the index value of the index and the previous day monthly increment value of the index is determined as the monthly increment value of the index; if the date of the index is the first day of a quarter, the index value of the index is determined as the quarterly increment value of the index, otherwise the sum of the index value of the index and the previous day quarterly increment value of the index is determined as the quarterly increment value of the index; if the date of the index is the first day of the current year, the index value of the index is determined as the annual increment value of the index, otherwise the sum of the index value of the index and the previous day annual increment value of the index is determined as the annual increment value of the index.

[0221] Further, in a possible implementation manner of the embodiment of the present application, the at least one comparison value includes one or more of a previous day same period increment value, a previous month same period increment value, a previous quarter same period increment value and a previous year same period increment value; the third determination unit is also used for:

[0222] In a case where the index type of the index indicated by the index configuration information is an increment calculation value, the difference between the index value of the index and the previous day index value of the index is determined as the previous day same period increment value of the index; the difference between the index value of the index and the previous month same period index value of the index is determined as the previous month same period increment value of the index; the difference between the index value of the index and the previous quarter same period index value of the index is determined as the previous quarter same period increment value of the index; the difference between the index value of the index and the previous year same period index value of the index is determined as the previous year same period increment value of the index;

[0223] In a case where the index type of the index indicated by the index configuration information is any one of an accumulated value, an average value, and a point value, a difference between the index value of the index and the previous day index value of the index is determined as the same period increment value of the previous day of the index; a difference between the index value of the index and the same period index value of the previous month of the index is determined as the same period increment value of the previous month of the index; a difference between the index value of the index and the same period index value of the previous quarter of the index is determined as the same period increment value of the previous quarter of the index; and a difference between the index value of the index and the same period index value of the previous year of the index is determined as the same period increment value of the previous year of the index.

[0224] In a case where the index type of the index indicated by the index configuration information is an accumulated value of the current year, in a case where the date of the index is the first day of the current year, a difference between the index value of the index and the previous day index value of the index is determined as a first difference value, and a sum of the first difference value and the previous previous day index value of the index is determined as the same period increment value of the previous day of the index; otherwise, a difference between the index value of the index and the previous day index value of the index is determined as the same period increment value of the previous day of the index; in a case where the date of the index is the first month of the current year, a difference between the index value of the index and the same period index value of the previous month of the index is determined as a second difference value, and a sum of the second difference value and the previous previous month end index value of the index is determined as the same period increment value of the previous month of the index; otherwise, a difference between the index value of the index and the same period index value of the previous month of the index is determined as the same period increment value of the previous month of the index; in a case where the date of the index is the first quarter of the current year, a difference between the index value of the index and the same period index value of the previous quarter of the index is determined as a third difference value, and a sum of the third difference value and the previous previous quarter end index value of the index is determined as the same period increment value of the previous quarter of the index; otherwise, a difference between the index value of the index and the same period index value of the previous quarter of the index is determined as the same period increment value of the previous quarter of the index; and a difference between the index value of the index and the same period index value of the previous year of the index is determined as the same period increment value of the previous year of the index.

[0225] Further, in a possible implementation manner of the embodiment of the present application, the at least one increment value includes one or more of a daily increment value, a monthly increment value, a quarterly increment value, and an annual increment value, and the at least one rate value includes one or more of a monthly same period increment value, a monthly same period increment value, a quarterly same period increment value, a quarterly same period increment value, and an annual growth rate; and the fourth determination unit is further configured to:

[0226] In a case where the monthly increment value of the previous year of the index is a first preset value, the monthly same period increment value of the index is set as a second preset value, or in a case where the monthly increment value of the previous year of the index is not the first preset value, a difference between the monthly increment value of the index and the monthly increment value of the previous year of the index is determined as a first intermediate value, and a ratio between the first intermediate value and the monthly increment value of the previous year of the index is determined as the monthly same period increment value of the index.

[0227] In a case where the increment value of the index in the same month of the last month is the third preset value, the monthly comparison of the index is set as a fourth preset value, or in a case where the increment value of the index in the same month of the last month is not the second preset value, a second intermediate value is determined according to a difference between the increment value of the index and the increment value of the index in the same month of the last month, and a ratio between the second intermediate value and the increment value of the index in the same month of the last month is determined as the monthly comparison of the index.

[0228] In a case where the increment value of the index in the same quarter of the last year is the fifth preset value, the quarterly comparison of the index is set as a sixth preset value, or in a case where the increment value of the index in the same quarter of the last year is not the third preset value, a third intermediate value is determined according to a difference between the increment value of the index and the increment value of the index in the same quarter of the last year, and a ratio between the third intermediate value and the increment value of the index in the same quarter of the last year is determined as the quarterly comparison of the index.

[0229] In a case where the increment value of the index in the same quarter of the last month is the seventh preset value, the quarterly comparison of the index is set as an eighth preset value, or in a case where the increment value of the index in the same quarter of the last month is not the fourth preset value, a fourth intermediate value is determined according to a difference between the increment value of the index and the increment value of the index in the same quarter of the last month, and a ratio between the fourth intermediate value and the increment value of the index in the same quarter of the last month is determined as the quarterly comparison of the index.

[0230] In a case where the increment value of the index in the last year is the ninth preset value, the annual growth rate of the index is set as a tenth preset value, or in a case where the increment value of the index in the last year is not the fifth preset value, a fifth intermediate value is determined according to a difference between the increment value of the index and the increment value of the index in the last year, and a ratio between the fifth intermediate value and the increment value of the index in the last year is determined as the annual growth rate of the index.

[0231] Further, in a possible implementation manner of the embodiment of the present application, the first determining module 52 is further used for:

[0232] For any index in the index configuration information, the index value of the index is determined according to the index processing statement or the index calculation formula of the index indicated by the index configuration information.

[0233] Further, in a possible implementation manner of the embodiment of the present application, the apparatus further includes:

[0234] The adding module is used for adding the index value of the index and the at least one increment value of the index to the index intermediate table, wherein the index value of the index and the at least one increment value of the index are determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information; or

[0235] add the index value of the index to the index intermediate table, wherein the index value of the index is determined based on the index processing statement or the index calculation formula of the index indicated by the index configuration information;

[0236] The index intermediate table is configured to store the index data aggregated by the institutions.

[0237] Further, in a possible implementation of the embodiment of the present application, the apparatus further comprises:

[0238] The third determination module is configured to, in the case that the index value of the index is determined based on the index processing statement of the index indicated by the index configuration information, determine whether the index has been aggregated by the institutions according to the institution aggregation information of the index indicated by the index configuration information;

[0239] The aggregation module is configured to, in the case that the index has not been aggregated by the institutions, aggregate the index values of the index at each level of the institutions into the index intermediate table level by level upwards according to the institution level of the index indicated by the index configuration information and the institution level to be aggregated.

[0240] Further, in a possible implementation of the embodiment of the present application, the index configuration information comprises one or more of a system number, a system name, an index code, an index name, an index business description, an index type, an increment judgment field, an institution field name, an institution level, institution aggregation information, an index processing statement or an index calculation formula, and an execution order number;

[0241] The system number and the system name are configured to identify the system to which the index belongs.

[0242] The index type comprises one or more of an accumulated value, a current year cumulative value, an era value, an average value, and an increment calculation value.

[0243] The increment judgment field is configured to identify the date of the increment data.

[0244] The institution field name is configured to perform index statistics in the institution dimension.

[0245] The institution level comprises a total bank, a first-level bank, a second-level bank, a branch bank, a network point, a sub-branch, and a seventh-level institution.

[0246] The institution aggregation information is configured to identify whether the index value has been aggregated by the institutions.

[0247] The execution order number is configured to identify the execution order of the index calculation formula.

[0248] It should be noted that the foregoing explanation and description of the index configuration method embodiment are also applicable to the index configuration apparatus of the embodiment, which will not be described herein again.

[0249] In the embodiment of the present application, the index configuration information is acquired, wherein the index configuration information comes from multiple dimensions, for any index in the index configuration information, the index value of the index is determined according to the index configuration information, and at least one derived index value of the index is determined according to the index configuration information or a preset index calculation rule, thereby the index value and the at least one derived index value of at least one index belonging to the same dimension are stored in the same index information table according to the dimension to which each index belongs, and information pushing is performed based on at least one index information table. Thus, the index data can be automatically processed based on the index configuration information and the preset index calculation rule, without the need to separately develop a corresponding index processing program for each index data, thereby avoiding repeated development of the index processing program and reducing the index processing complexity. Meanwhile, the index value and the at least one derived index value of any index of any agency at any time can be conveniently and efficiently queried through the index information table, without the need to associate multiple table queries and perform multiple record calculation processing, thereby greatly improving the index processing and index query performance and quickly responding to business requirements.

[0250] To achieve the above-mentioned embodiments, the present application further provides an electronic device, comprising: at least one processor; and a memory in communication connection with the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the index configuration method provided in any one of the above-mentioned embodiments of the present application.

[0251] To achieve the above-mentioned embodiments, the present application further provides a computer readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to perform the index configuration method provided in any one of the above-mentioned embodiments of the present application.

[0252] To achieve the above-mentioned embodiments, the present application further provides a computer program product, comprising a computer program which, when executed by a processor, implements the index configuration method provided in any one of the above-mentioned embodiments of the present application.

[0253] Figure 6 An electronic device according to an embodiment of the present application.

[0254] It should be noted that, Figure 6 The electronic device shown is merely an example and should not impose any limitation on the functions and use range of the embodiments of the present application.

[0255] As Figure 6 shown, the electronic device comprises:

[0256] The memory 601, the processor 602, and the computer program stored in the memory 601 and executable on the processor 602.

[0257] The processor 602 implements the index configuration method provided in any of the above embodiments when executing the program.

[0258] Further, the electronic device further comprises:

[0259] The communication interface 603 is configured to communicate between the memory 601 and the processor 602.

[0260] The memory 601 is configured to store a computer program executable on the processor 602.

[0261] The memory 601 can include a high-speed RAM memory, and can also include a non-volatile memory, for example, at least one disk memory.

[0262] The processor 602 is configured to implement the index configuration method provided in any of the above embodiments when executing the program.

[0263] If the memory 601, the processor 602 and the communication interface 603 are implemented independently, the communication interface 603, the memory 601 and the processor 602 can be connected to each other through a bus and complete communication between each other. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For the convenience of representation, Figure 6 Only one thick line is used in the figure, but it does not mean that there is only one bus or only one type of bus.

[0264] Optionally, in a specific implementation, if the memory 601, the processor 602 and the communication interface 603 are integrated on a chip, the memory 601, the processor 602 and the communication interface 603 can complete communication between each other through an internal interface.

[0265] The processor 602 can be a Central Processing Unit (CPU), or an Application Specific Integrated Circuit (ASIC), or one or more integrated circuits configured to implement embodiments of the present application.

[0266] In the description of the application, the description of the terms "one embodiment", "some embodiments", "an example", "a specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of the application. The illustrative description of the above terms in the specification does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any suitable manner in one or more embodiments or examples. In addition, different embodiments or examples described in the specification and the features of different embodiments or examples can be combined and combined by those skilled in the art without contradiction, if necessary.

[0267] In addition, the terms "first", "second" are only for descriptive purposes and cannot be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined with "first", "second" can explicitly or implicitly include at least one of the features. In the description of the application, the meaning of "a plurality of" is at least two, for example, two, three, etc., unless otherwise specifically limited.

[0268] Any process or method descriptions in flow charts or described elsewhere herein can be understood as representing code modules, segments, or portions of code that include one or more executable instructions for performing specific logic functions or steps in the process, and the various embodiments of the application include additional implementations in which the order of steps can be changed, including use of an opposite order, and additional or fewer steps can be performed, depending on the functionality involved as would be understood by those skilled in the art.

[0269] The logic and / or steps represented in flow diagrams or otherwise described herein, for example, can be considered as a sequence of instructions to implement logic functions, and can be embodied in any computer-readable medium for use by an instruction execution system, apparatus, or device, such as a computer-based system, processor- containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. In the context of this specification, a "computer-readable medium" can be any means that can contain, store, communicate, propagate or transport the program for use by or in connection with the instruction execution system, apparatus, or device. The computer-readable medium can be a machine-readable storage device (e.g., magnetic, optical or other) a machine-readable storage diskette (e.g., floppy, flexible or other), a machine-readable storage card (e.g., RAM, ROM or other), a machine-readable storage tape (e.g., magnetic, optical or other), a machine-readable storage medium (e.g., a portable memory chip), a machine-readable signal, a machine-readable propagated signal, a machine-readable compressed signal, and the like. More specific examples (a non-exhaustive list) of the computer-readable medium include the following: an electrical connection having one or more wires (e.g., a bus that has thin film resistors for

[0270] It should be understood that aspects of the application can be implemented in hardware, software, firmware or combinations thereof. In the above embodiments, various steps or methods can be implemented in software or firmware that is stored in memory and executed by a suitable instruction execution system. As such, in some embodiments, memory (including computer-readable storage media) can be a non-transitory computer-readable storage medium that includes a computer-readable storage medium with instructions or logic stored on it, or a machine-readable storage medium, such as random access memory (RAM), read only memory (ROM), a permanent memory, or other flash memory including a non-volatile memory, or a portable electronic medium such as a compact disc read only memory (CD-ROM), etc. As used herein, the term "non-transitory" simply means a computer-readable medium that does not include a propagated signal per se (although the term "non-transitory computer-readable medium" should not be interpreted so as to

[0271] Those skilled in the art can understand that all or part of the steps involved in the above-mentioned embodiment method can be completed by programs instructing relevant hardware, and the programs can be stored in a computer-readable storage medium. When the programs are executed, one or a combination of the steps of the method embodiments is included.

[0272] In addition, each function unit in each embodiment of the present application can be integrated in one processing module, or each unit can be physically present separately, or two or more units can be integrated in one module. The integrated module can be realized in the form of hardware or in the form of a software function module. When the integrated module is realized in the form of a software function module and sold or used as an independent product, it can also be stored in a computer readable storage medium.

[0273] The storage medium mentioned above can be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present application have been shown and described above, it should be understood that the above embodiments are exemplary and should not be construed as limiting the present application, and those skilled in the art can make changes, modifications, replacements and variations to the above embodiments within the scope of the present application.

Claims

1. A method for configuring indicators, characterized in that, include: Obtain indicator configuration information; wherein, the indicator configuration information comes from multiple dimensions; For any indicator in the indicator configuration information, determine the indicator value according to the indicator configuration information; Based on the indicator configuration information or preset indicator calculation rules, determine at least one derived indicator value for the indicator; Based on the dimension to which each of the indicators belongs, the indicator values ​​of at least one of the indicators belonging to the same dimension and at least one derived indicator value are stored in the same indicator information table, so as to push information based on at least one of the indicator information tables; The derived indicator value includes one or more of incremental values, comparison values, and ratio values; the preset indicator calculation rule includes one or more of preset incremental value calculation rules, preset comparison value calculation rules, and preset ratio value calculation rules; determining at least one derived indicator value of the indicator based on the indicator configuration information or the preset indicator calculation rule includes: When the indicator type of the indicator indicated by the indicator configuration information is an incremental calculated value, at least one incremental value of the indicator is determined according to the indicator processing statement or indicator calculation formula of the indicator indicated by the indicator configuration information. If the indicator type indicated by the indicator configuration information is not incremental value statistical query, at least one incremental value of the indicator is determined according to the preset incremental value calculation rule corresponding to the indicator type indicated by the indicator configuration information. Based on the preset comparison value calculation rule corresponding to the indicator type indicated by the indicator configuration information, at least one comparison value of the indicator is determined. Based on at least one incremental value of the indicator and a preset ratio value calculation rule, determine at least one ratio value of the indicator; The step of determining the indicator value of any indicator in the indicator configuration information, based on the indicator configuration information, includes: For any indicator in the indicator configuration information, the indicator value is determined according to the indicator processing statement or indicator calculation formula indicated by the indicator configuration information.

2. The method according to claim 1, characterized in that, The at least one incremental value includes one or more of daily incremental values, monthly incremental values, quarterly incremental values, and annual incremental values; when the indicator type indicated by the indicator configuration information is not incremental value statistical query, the at least one incremental value of the indicator is determined according to the preset incremental value calculation rule corresponding to the indicator type indicated by the indicator configuration information, including: When the indicator type indicated by the indicator configuration information is a cumulative value or an average value, the difference between the indicator value and the previous day's indicator value is determined as the daily increment value of the indicator; the difference between the indicator value and the indicator value at the end of the previous month is determined as the monthly increment value of the indicator; the difference between the indicator value and the indicator value at the end of the previous quarter is determined as the quarterly increment value of the indicator; and the difference between the indicator value and the indicator value at the end of the previous year is determined as the annual increment value of the indicator. When the indicator type indicated by the indicator configuration information is the year-to-date cumulative value, if the indicator date is the first day of the year, the indicator value is determined as the daily increment value; otherwise, the difference between the indicator value and the previous day's indicator value is determined as the daily increment value. If the indicator date is the first month of the year, the indicator value is determined as the monthly increment value; otherwise, the difference between the indicator value and the previous month's end indicator value is determined as the monthly increment value. If the indicator date is the first quarter of the year, the indicator value is determined as the quarterly increment value; otherwise, the difference between the indicator value and the previous quarter's end indicator value is determined as the quarterly increment value. Finally, the indicator value is determined as the year-to-date increment value. If the indicator type indicated by the indicator configuration information is a point-in-time value, the indicator value is determined as the daily increment value of the indicator; if the date of the indicator is the first day of the month, the indicator value is determined as the monthly increment value of the indicator; otherwise, the sum of the indicator value and the previous day's monthly increment value is determined as the monthly increment value of the indicator; if the date of the indicator is the first day of the quarter, the indicator value is determined as the quarterly increment value of the indicator; otherwise, the sum of the indicator value and the previous day's quarterly increment value is determined as the quarterly increment value of the indicator; if the date of the indicator is the first day of the year, the indicator value is determined as the annual increment value of the indicator; otherwise, the sum of the indicator value and the previous day's annual increment value is determined as the annual increment value of the indicator.

3. The method according to claim 1, characterized in that, The at least one comparison value includes one or more of the following: the increase value compared to the same period of the previous day, the increase value compared to the same period of the previous month, the increase value compared to the same period of the previous quarter, and the increase value compared to the same period of the previous year; determining the at least one comparison value of the indicator according to the preset comparison value calculation rule corresponding to the indicator type indicated by the indicator configuration information includes: When the indicator type indicated by the indicator configuration information is an incremental calculated value, the difference between the indicator value and the indicator value of the previous day is determined as the incremental value of the indicator compared to the same period of the previous day; the difference between the indicator value and the indicator value of the previous month is determined as the incremental value of the indicator compared to the same period of the previous month; the difference between the indicator value and the indicator value of the previous quarter is determined as the incremental value of the indicator compared to the same period of the previous quarter; and the difference between the indicator value and the indicator value of the previous year is determined as the incremental value of the indicator compared to the same period of the previous year. When the indicator type indicated by the indicator configuration information is any one of cumulative value, average value, and point-in-time value, the difference between the indicator value and the previous day's indicator value is determined as the indicator's year-on-year increase; the difference between the indicator value and the previous month's indicator value is determined as the indicator's year-on-year increase; the difference between the indicator value and the previous quarter's indicator value is determined as the indicator's quarter-on-quarter increase; and the difference between the indicator value and the previous year's indicator value is determined as the indicator's year-on-year increase. When the indicator type indicated by the indicator configuration information is the year-to-date cumulative value, if the indicator date is the first day of the year, the difference between the indicator value and the previous day's indicator value is determined as the first difference, and the sum of the first difference and the indicator value of the day before yesterday is determined as the indicator's year-to-date increment value; otherwise, the difference between the indicator value and the previous day's indicator value is determined as the indicator's year-to-date increment value. If the indicator date is the first month of the year, the difference between the indicator value and the indicator value of the previous month's same period is determined as the second difference, and the sum of the second difference and the indicator value at the end of the month before yesterday is determined as the year-to-date increment value. The indicator is determined as the increase compared to the same period last month; otherwise, the difference between the indicator value and the indicator value of the same period last month is determined as the increase compared to the same period last month. If the indicator's date is the first quarter of the current year, the difference between the indicator value and the indicator value of the same period last quarter is determined as the third difference, and the sum of the third difference and the indicator value at the end of the quarter before last is determined as the increase compared to the same period last quarter. Otherwise, the difference between the indicator value and the indicator value of the same period last quarter is determined as the increase compared to the same period last quarter. The difference between the indicator value and the indicator value of the same period last year is determined as the increase compared to the same period last year.

4. The method according to claim 1, characterized in that, The at least one incremental value includes one or more of daily incremental values, monthly incremental values, quarterly incremental values, and annual incremental values; the at least one ratio value includes one or more of monthly year-on-year, monthly month-on-month, quarterly year-on-year, quarterly month-on-month, and annual growth rate; determining the at least one ratio value of the indicator based on the at least one incremental value of the indicator and the preset ratio value calculation rules includes: If the monthly increment of the indicator in the same period of the previous year is a first preset value, the monthly year-on-year growth of the indicator is set to a second preset value; or, if the monthly increment of the indicator in the same period of the previous year is not a first preset value, the difference between the monthly increment of the indicator and the monthly increment of the indicator in the same period of the previous year is determined as a first intermediate value, and the ratio between the first intermediate value and the monthly increment of the indicator in the same period of the previous year is determined as the monthly year-on-year growth of the indicator. If the monthly increment of the indicator in the same period of the previous month is a third preset value, the month-on-month change of the indicator is set to a fourth preset value. Alternatively, if the monthly increment of the indicator in the same period of the previous month is not a second preset value, the difference between the monthly increment of the indicator and the monthly increment of the indicator in the same period of the previous month is determined as a second intermediate value, and the ratio between the second intermediate value and the monthly increment of the indicator in the same period of the previous month is determined as the month-on-month change of the indicator. If the quarterly increment of the indicator in the same period of the previous year is the fifth preset value, the quarterly year-on-year of the indicator is set to the sixth preset value. Alternatively, if the quarterly increment of the indicator in the same period of the previous year is not the third preset value, the difference between the quarterly increment of the indicator and the quarterly increment of the indicator in the same period of the previous year is determined as the third intermediate value, and the ratio between the third intermediate value and the quarterly increment of the indicator in the same period of the previous year is determined as the quarterly year-on-year of the indicator. If the quarterly increment of the indicator in the same period of the previous quarter is the seventh preset value, the quarterly year-on-year change of the indicator is set to the eighth preset value. Alternatively, if the quarterly increment of the indicator in the same period of the previous quarter is not the fourth preset value, the difference between the monthly increment of the indicator and the quarterly increment of the indicator in the same period of the previous quarter is determined as the fourth intermediate value, and the ratio between the fourth intermediate value and the quarterly increment of the indicator in the same period of the previous quarter is determined as the quarterly year-on-year change of the indicator. If the previous year's annual increment of the indicator is the ninth preset value, the annual growth rate of the indicator is set to the tenth preset value. Alternatively, if the previous year's annual increment of the indicator is not the fifth preset value, the difference between the annual increment of the indicator and the previous year's annual increment of the indicator is determined as the fifth intermediate value, and the ratio between the fifth intermediate value and the previous year's annual increment of the indicator is determined as the annual growth rate of the indicator.

5. The method according to claim 1, characterized in that, The method further includes: Add the indicator value and at least one incremental value of the indicator to the indicator intermediate table; wherein the indicator value and at least one incremental value of the indicator are determined based on the indicator processing statement or indicator calculation formula indicated by the indicator configuration information; or, The indicator value is added to the indicator intermediate table; wherein the indicator value is determined based on the indicator processing statement or indicator calculation formula indicated by the indicator configuration information. The intermediate index table is used to store index data summarized by organization.

6. The method according to claim 1, characterized in that, The method further includes: When the indicator value is determined based on the indicator processing statement of the indicator indicated by the indicator configuration information, it is determined whether the indicator has been summarized by institution according to the institution summary information of the indicator indicated by the indicator configuration information. If the indicators are not aggregated by organization, the indicator values ​​of each organization are aggregated upwards to the intermediate indicator table according to the organization level of the indicator as indicated by the indicator configuration information and the organization level to be aggregated.

7. The method according to any one of claims 1-6, characterized in that, The indicator configuration information includes one or more of the following: system number, system name, indicator code, indicator name, indicator business description, indicator type, incremental judgment field, organization field name, organization level, organization summary information, indicator processing statement or indicator calculation formula, and execution sequence number. The system number and system name are used to identify the system to which the indicator belongs; The indicator types include one or more of the following: cumulative value, year-to-date cumulative value, era value, average value, and incremental calculated value; The incremental judgment field is used to identify the date of the incremental data; The organization field name is used for statistical analysis of indicators at the organization level; The organizational hierarchy includes head office, first-level branches, second-level branches, branches, outlets, sub-branches, and seven levels of organization; The aggregated information of the institutions is used to identify whether the indicator values ​​have been aggregated by institution; The execution sequence number is used to identify the execution order of the indicator calculation formula.

8. An indicator configuration device, characterized in that, include: The acquisition module is used to acquire indicator configuration information; wherein, the indicator configuration information comes from multiple dimensions; The first determining module is used to determine the indicator value of any indicator in the indicator configuration information based on the indicator configuration information. The second determining module is used to determine at least one derived indicator value of the indicator based on the indicator configuration information or based on a preset indicator calculation rule. The processing module is used to store the indicator values ​​of at least one indicator belonging to the same dimension and at least one derived indicator value into the same indicator information table according to the dimension to which each indicator belongs, so as to push information based on at least one indicator information table; The derived indicator values ​​include one or more of incremental values, comparison values, and ratio values; the preset indicator calculation rules include one or more of preset incremental value calculation rules, preset comparison value calculation rules, and preset ratio value calculation rules; the second determining module includes: The first determining unit is configured to determine at least one incremental value of the indicator based on the indicator processing statement or indicator calculation formula of the indicator indicated by the indicator configuration information, when the indicator type of the indicator indicated by the indicator configuration information is an incremental calculated value. The second determining unit is used to determine at least one incremental value of the indicator according to the preset incremental value calculation rule corresponding to the indicator type indicated by the indicator configuration information, when the indicator type of the indicator indicated by the indicator configuration information is not incremental value statistical query. The third determining unit is used to determine at least one comparison value of the indicator according to the preset comparison value calculation rule corresponding to the indicator type indicated by the indicator configuration information. The fourth determining unit is used to determine at least one ratio value of the indicator based on at least one incremental value of the indicator and a preset ratio value calculation rule. The first determining module is further configured to: For any indicator in the indicator configuration information, the indicator value is determined according to the indicator processing statement or indicator calculation formula indicated by the indicator configuration information.

9. An electronic device, characterized in that, include: At least one processor; as well as A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.

10. A computer-readable storage medium storing computer instructions, characterized in that, The computer instructions are used to cause the computer to perform the method according to any one of claims 1-7.

11. A computer program product, characterized in that, It includes a computer program that, when executed by a processor, implements the method of any one of claims 1-7.

Images