Index determination method and device

Abstract

The present invention discloses an indicator determination method and device, and relates to the field of computer technology. A specific implementation of the method includes: obtaining at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator; generating a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the measurement field; and performing statistical processing on the measurement field in the basic data table according to the measurement rule to determine the statistical indicator. This implementation can save the manpower cost required for the indicator statistical process and has high efficiency.

Description

Technical Field

[0001] The present invention relates to the field of computers, and in particular to an indicator determination method and device. Background Art

[0002] Enterprises or other organizations often need to perform indicator statistics based on multiple data tables. Existing indicator statistics methods include: manual statistics and indicator hard-coding. Manual statistics require high manpower costs and low efficiency. The indicator hard-coding method also consumes a lot of manpower and material resources, and the indicator development cycle is long and there is a lot of duplication of work. Summary of the invention

[0003] In view of this, an embodiment of the present invention provides an indicator determination method and device, which can save the manpower cost required for the indicator statistical process and has high efficiency.

[0004] In a first aspect, an embodiment of the present invention provides an indicator determination method, comprising:

[0005] Acquire at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator;

[0006] Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field;

[0007] According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine the statistical indicators.

[0008] Optionally, generating a basic data table according to the dimension information table and the fact table includes:

[0009] For each data record in the fact table: determine the dimension field in the data record; associate the dimension field with the dimension information table to determine the dimension information corresponding to the dimension field; add the dimension information to the data record to generate the basic data table.

[0010] Optionally, the measurement rule includes a measurement caliber;

[0011] The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes:

[0012] According to the measurement caliber, a set of records to be counted is selected from the basic data table;

[0013] Statistical processing is performed on the metric fields in the record set to be counted to determine the statistical index.

[0014] Optionally, the measurement rule includes a measurement method;

[0015] The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes:

[0016] The metric fields in the record set to be counted are counted in the metric manner to determine the statistical index.

[0017] Optionally, the statistical indicator is a composite indicator; the at least one fact table includes: a first fact table and a second fact table;

[0018] The generating of a basic data table according to the dimension information table and the fact table includes:

[0019] Generate a first basic data table according to the dimension information table and the first fact table;

[0020] Generate a second basic data table according to the dimension information table and the second fact table;

[0021] The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes:

[0022] Performing statistical processing on the first metric field in the first basic data table to determine a first statistical indicator;

[0023] Performing statistical processing on the second metric field in the second basic data table to determine a second statistical index;

[0024] The composite indicator is determined according to the first statistical indicator, the second statistical indicator and the measurement rule.

[0025] Optionally, the measurement rule includes a measurement method;

[0026] The determining the composite indicator according to the first statistical indicator, the second statistical indicator and the measurement rule includes:

[0027] The first statistical indicator and the second statistical indicator are statistically processed in the measurement manner to determine the composite indicator.

[0028] Optionally, the statistical indicator is a derived indicator; the measurement rule includes: a first statistical time and a second statistical time;

[0029] The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes:

[0030] According to the first statistical time, a first statistical record set is selected from the basic data table;

[0031] Performing statistical processing on the metric field in the first statistical record set to determine a third statistical indicator corresponding to the first statistical time;

[0032] According to the second statistical time, a second statistical record set is selected from the basic data table;

[0033] Performing statistical processing on the metric field in the second statistical record set to determine a fourth statistical indicator corresponding to the second statistical time;

[0034] The derived indicator is determined according to the third statistical indicator, the fourth statistical indicator and the measurement rule.

[0035] Optionally, the measurement rule also includes a measurement method;

[0036] The determining the derived indicator according to the third statistical indicator, the fourth statistical indicator and the measurement rule includes:

[0037] The third statistical indicator and the fourth statistical indicator are statistically processed in the measurement manner to determine the composite indicator.

[0038] Optionally, there are multiple fact tables; the measurement rules include: association methods between fact tables;

[0039] The generating of a basic data table according to the dimension information table and the fact table includes:

[0040] Generate an associated fact table according to the multiple fact tables and the associated relationships;

[0041] The basic data table is generated according to the dimension information table and the associated fact table.

[0042] Optionally, the step of obtaining at least one fact table, at least one dimension information table, and measurement rules corresponding to the statistical indicators includes:

[0043] Obtaining statistical rules corresponding to the statistical indicators;

[0044] According to the statistical rules, the fact table, the dimension information table and the measurement rules are determined.

[0045] Optionally, the step of obtaining at least one fact table, at least one dimension information table, and measurement rules corresponding to the statistical indicators includes:

[0046] Obtaining attribute information of the statistical indicator;

[0047] Get attribute information of multiple fact tables;

[0048] respectively determining the matching degree between the attribute information of the statistical indicator and the attribute information of the fact table;

[0049] According to the matching degree, determining at least one fact table corresponding to the statistical indicator from the multiple fact tables;

[0050] The at least one dimension information table is determined according to the at least one fact table.

[0051] Optionally, determining the at least one dimension information table according to the at least one fact table includes:

[0052] determining at least one dimension field in the fact table;

[0053] Determine at least one dimension information table corresponding to the dimension field from the plurality of dimension information tables;

[0054] The determined dimension information table is used as the dimension information table corresponding to the statistical indicator.

[0055] In a second aspect, an embodiment of the present invention provides an indicator determination device, including:

[0056] A table acquisition module, used to acquire at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator;

[0057] A table generation module, configured to generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field;

[0058] The indicator determination module is used to perform statistical processing on the metric fields in the basic data table according to the metric rules to determine the statistical indicators.

[0059] In a third aspect, an embodiment of the present invention provides an electronic device, including:

[0060] one or more processors;

[0061] a storage device for storing one or more programs,

[0062] When the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any of the above embodiments.

[0063] In a fourth aspect, an embodiment of the present invention provides a computer-readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the method described in any of the above embodiments.

[0064] An embodiment of the above invention has the following advantages or beneficial effects: the statistical indicator can be automatically calculated based on at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator. Compared with manual statistics and hard coding of indicators, it can save the manpower cost required for the statistical indicator process, has high efficiency, and the statistical results are reliable and not prone to errors.

[0065] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS

[0066] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.

[0067] Figure 1 is an exemplary system architecture diagram to which embodiments of the present invention may be applied;

[0068] Figure 2 is a schematic diagram of a process of an indicator determination method provided by an embodiment of the present invention;

[0069] Figure 3 is a schematic diagram of a process of a composite index determination method provided by an embodiment of the present invention;

[0070] Figure 4 is a schematic diagram of a process of a method for determining a derivative index provided by an embodiment of the present invention;

[0071] Figure 5 is a schematic diagram of a process of another indicator determination method provided by an embodiment of the present invention;

[0072] Figure 6 is a schematic diagram of a process of another indicator determination method provided by an embodiment of the present invention;

[0073] Figure 7 It is a schematic diagram of the composition structure of a basic data table provided by an embodiment of the present invention;

[0074] Figure 8 It is a schematic diagram of determining a statistical indicator by using a measurement rule provided by an embodiment of the present invention;

[0075] Fig. 9 It is a schematic diagram of a method for setting a measurement rule of a composite indicator provided by an embodiment of the present invention;

[0076] Fig.10 It is a schematic diagram of a method for setting a measurement rule of a derived indicator provided by an embodiment of the present invention;

[0077] Fig.11 is a structural schematic diagram of an indicator determination device provided by an embodiment of the present invention;

[0078] Fig.12 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION

[0079] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings; various details of the embodiments of the present invention are included to facilitate understanding, and they should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Likewise, for the sake of clarity and conciseness, descriptions of well-known functions and structures are omitted in the following description.

[0080] Figure 1 An exemplary system architecture 100 to which the indicator determination method or indicator determination device according to the embodiment of the present invention can be applied is shown.

[0081] like Figure 1 As shown, the system architecture 100 may include terminal devices 101, 102, 103, a network 104 and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0082] The terminal devices 101, 102, 103 may be various terminal devices deployed in various branches or departments, such as mobile phones, notebooks, tablet computers, laptop portable computers, etc. The terminal devices 101, 102, 103 interact with the server 105 through the network 104 to receive or send messages.

[0083] The terminal devices 101 , 102 , and 103 store various fact tables of each branch or department, such as an accounts receivable analysis table, a purchase summary table, etc., and send the various fact tables to the server 105 .

[0084] The server 105 receives the fact table sent by the terminal devices 101, 102, and 103. For the indicators to be counted, at least one fact table, at least one dimension information table, and a measurement rule corresponding to the statistical indicator are obtained, wherein the fact table includes the measurement field corresponding to the statistical indicator; based on the dimension information table and the fact table, a basic data table is generated, wherein the basic data table includes the measurement field; based on the measurement rule, the measurement field in the basic data table is statistically processed to determine the statistical indicator. It should be noted that the indicator determination method provided in the embodiment of the present invention is generally executed by the server 105, and accordingly, the indicator determination device is generally set in the server 105.

[0085] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0086] Figure 2 is a schematic diagram of a process of an indicator determination method provided by an embodiment of the present invention. The embodiment of the present invention provides an indicator determination method, such as Figure 2 As shown, including:

[0087] Step 201: Obtain at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes measurement fields corresponding to the statistical indicator.

[0088] The correspondence between the statistical indicators and the fact table, the dimension information table and the measurement rules can be pre-stored in the system, and the correspondence can be stored in the statistical rules of the statistical indicators. At least one fact table, at least one dimension information table and the measurement rules corresponding to the statistical indicators are determined according to the statistical rules.

[0089] Each statistical indicator can have multiple attribute information, such as indicator name, indicator description, measurement fields and measurement rules. Each fact table can also have multiple attribute information, such as table name, table description and fields in the table. The fact table corresponding to the statistical indicator can be determined by matching the attribute information of the statistical indicator with the attribute information of the fact table. For example, if the name of the statistical indicator is the gross domestic product of the entire company in the first quarter, the indicator name can be matched with the table names of multiple fact tables according to algorithms such as natural language processing or string matching, and at least one fact table with a matching degree greater than a preset matching threshold is selected, including: the gross domestic product table of the first department in the first quarter, the gross domestic product table of the second department in the first quarter, and the gross domestic product table of the third department in the first quarter, etc., as the fact table corresponding to the statistical indicator.

[0090] After determining the fact table corresponding to the statistical indicator, the dimension table corresponding to the statistical indicator can be determined according to the dimension fields included in the fact table. For example, if the fact table includes: organization field and gender field, the organization dimension information table and the gender dimension information table are determined as the dimension information tables corresponding to the statistical indicator.

[0091] Metric rules are used to describe the statistical rules used to calculate statistical indicators, such as metric caliber, metric method, and the relationship between fact tables. The fact table must include the metric field corresponding to the statistical indicator so that the metric field can be statistically processed according to the metric rules to obtain the statistical indicator value.

[0092] Step 202: Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes a measurement field.

[0093] In one embodiment of the present invention, a basic data table is generated according to the dimension information table and the fact table, including:

[0094] For each data record in the fact table: determine the dimension field in the data record; associate the dimension field with the dimension information table to determine the dimension information corresponding to the dimension field; add the dimension information to the data record to generate a basic data table.

[0095] The basic data table is a wide table with multiple dimension information. Determine the measurement field and dimension field from the fact table. For the dimension field, associate the corresponding dimension information table according to the dimension field, and add the data in the dimension information table to the corresponding data record.

[0096] For example, if the fact table includes a currency field, the currency dimension table is associated with the currency field, and the corresponding currency code, currency English name, and currency Chinese name are added to the corresponding data record of the fact table.

[0097] Generating a basic data table containing information of multiple dimensions can facilitate subsequent statistical calculations of multiple dimensions based on the basic data table and reduce the time required for job processing.

[0098] In one embodiment of the present invention, there are multiple fact tables; the measurement rules include: the association mode between the fact tables;

[0099] Generate basic data tables based on dimension information tables and fact tables, including:

[0100] Generate an associated fact table based on multiple fact tables and associated relationships;

[0101] Generate a basic data table based on the dimension information table and related fact tables.

[0102] When statistical analysis of statistical indicators cannot be performed based on one fact table, multiple fact tables need to be associated to generate a basic data table. For example, if the statistical indicator is sales in January, Fact Table 1 is used to store category codes and unit prices, and Fact Table 2 is used to store category codes and sales volume. Then, Fact Table 1 and Fact Table 2 need to be associated based on the category code, and the unit price in Fact Table 1 is multiplied by the sales volume in Fact Table 2 to generate the basic data table corresponding to the statistic.

[0103] By setting associations in measurement rules, the system can statistically calculate a variety of more complex statistical indicators involving multiple fact tables.

[0104] Step 203: According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine statistical indicators.

[0105] In the embodiment of the present invention, the statistical indicator is automatically calculated based on at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator. Therefore, the problem of high labor cost and low efficiency caused by manual or hard-coded statistical indicators can be solved.

[0106] In one embodiment of the present invention, the measurement rules include measurement caliber;

[0107] According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine statistical indicators, including:

[0108] According to the measurement caliber, filter out the record set to be counted from the basic data table;

[0109] Perform statistical processing on the measurement fields in the statistical record set to determine the statistical indicators.

[0110] The measurement caliber is used to limit the filtering conditions of the records to be counted, such as Gender = Female, Organization = Beijing Branch, etc. By setting the measurement caliber in the measurement rule, the system can determine the statistical indicators under any statistical caliber according to the measurement caliber. In addition, by binding the statistical indicators with the measurement caliber, it can also prevent different departments and different staff from calculating different statistical results for the same indicator.

[0111] In one embodiment of the present invention, the measurement rule includes a measurement method;

[0112] According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine statistical indicators, including:

[0113] In a metric way, the metric fields in the record set to be counted are counted to determine the statistical indicators.

[0114] The measurement method is used to define the statistical method of the measurement field, such as sum, count, unique value count, average, etc. By setting the measurement method in the measurement rule, the system can perform statistical operations in the statistical method determined by the measurement method. In addition, by binding the statistical indicator to the measurement method, it can also prevent different departments and different staff from calculating different statistical results for the same indicator.

[0115] Figure 3 FIG. 1 is a schematic diagram of a process of a composite index determination method provided by an embodiment of the present invention. The present invention provides a composite index determination method, such as Figure 3 As shown, including:

[0116] Step 301: Obtain a first fact table, a second fact table, at least one dimension information table, and measurement rules corresponding to the composite indicator, wherein the first fact table and the second fact table both include measurement fields corresponding to the composite indicator.

[0117] Step 302: Generate a first basic data table according to the dimension information table and the first fact table.

[0118] Step 303: Generate a second basic data table according to the dimension information table and the second fact table.

[0119] Step 304: Perform statistical processing on the first metric field in the first basic data table to determine a first statistical index.

[0120] Step 305: Perform statistical processing on the second metric field in the second basic data table to determine a second statistical index.

[0121] Step 306: Determine a composite indicator according to the first statistical indicator, the second statistical indicator and the measurement rule.

[0122] A composite index is an index that needs to be determined based on multiple statistical indicators. When a composite index needs to be calculated, the method of the embodiment of the present invention can be used to first calculate the first statistical index and the second statistical index respectively, and then determine the composite index based on the first statistical index and the second statistical index.

[0123] In one embodiment of the present invention, the measurement rule includes a measurement method;

[0124] According to the first statistical indicator, the second statistical indicator and the measurement rule, a composite indicator is determined, including:

[0125] The first statistical indicator and the second statistical indicator are statistically processed in a metric manner to determine a composite indicator.

[0126] The measurement method is used to define the calculation method of the first statistical indicator and the second statistical indicator, such as sum, count, unique value count, average, etc. For example, the composite indicator is: the balance of RMB deposits at outlets, the first statistical indicator is: the balance of RMB deposits for private use at outlets, and the second statistical indicator is: the balance of RMB deposits for public use at outlets. The measurement method is addition. That is, the composite indicator value is determined by the following formula: the balance of RMB deposits at outlets = the balance of RMB deposits for private use at outlets + the balance of RMB deposits for public use at outlets.

[0127] Figure 4 is a schematic diagram of a process of a method for determining a derivative index provided by an embodiment of the present invention. An embodiment of the present invention provides a method for determining a derivative index, such as Figure 4 As shown, including:

[0128] Step 401: Obtain at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicators, wherein the fact table includes measurement fields corresponding to the statistical indicators; the measurement rules include: a first statistical time and a second statistical time.

[0129] Step 402: Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes a metric field.

[0130] Step 403: According to the first statistical time, a first statistical record set is screened out from the basic data table.

[0131] Step 404: Perform statistical processing on the metric fields in the first statistical record set to determine a third statistical indicator corresponding to the first statistical time.

[0132] Step 405: According to the second statistical time, a second statistical record set is screened out from the basic data table.

[0133] Step 406: Perform statistical processing on the metric fields in the second statistical record set to determine a fourth statistical indicator corresponding to the second statistical time.

[0134] Step 407: Determine a derived indicator according to the third statistical indicator, the fourth statistical indicator and the measurement rule.

[0135] The derived indicator is a measure derived from the statistical indicator in the time dimension. When it is necessary to calculate the derived indicator, the method of the embodiment of the present invention can be used to first calculate the third statistical indicator of the statistical indicator at the first statistical time and the fourth statistical indicator at the second statistical time, and then determine the derived indicator based on the third statistical indicator and the fourth statistical indicator.

[0136] In one embodiment of the present invention, the measurement rule further includes a measurement method;

[0137] Derived indicators are determined based on the third statistical indicator, the fourth statistical indicator and the measurement rules, including:

[0138] The third statistical indicator and the fourth statistical indicator are statistically processed in a metric manner to determine a composite indicator.

[0139] The measurement method is used to define the calculation method of the first statistical indicator and the second statistical indicator, such as sum, count, unique value count, average, etc. For example, the derived indicator is: the RMB deposit balance of the outlet compared with the previous month, the third statistical indicator is: the RMB deposit balance of the outlet this month, and the fourth statistical indicator is: the RMB deposit balance of the outlet last month. The measurement method is subtraction. That is, the derived indicator value is determined by the following formula: RMB deposit balance of the outlet compared with the previous month = RMB deposit balance of the outlet this month - RMB deposit balance of the outlet last month.

[0140] Figure 5 FIG. 1 is a schematic diagram of a process of another indicator determination method provided by an embodiment of the present invention. The present invention provides an indicator determination method, such as Figure 5 As shown, including:

[0141] Step 501: Obtain attribute information of statistical indicators and attribute information of multiple fact tables.

[0142] Step 502: respectively determine the matching degree between the attribute information of the statistical indicator and the attribute information of multiple fact tables.

[0143] Step 503: According to the matching degree, at least one fact table corresponding to the statistical indicator is determined from the multiple fact tables.

[0144] Step 504: Determine at least one dimension information table based on the determined fact table.

[0145] Step 505: Generate a basic data table according to the dimension information table and the determined fact table, wherein the basic data table includes a metric field.

[0146] Step 506: According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine statistical indicators.

[0147] Each statistical indicator can have multiple attribute information, such as indicator name, indicator description, creation department, measurement fields, and measurement rules. Each fact table can also have multiple attribute information, such as table name, table description, creation department, and fields in the table. The fact table corresponding to the statistical indicator can be determined by matching the attribute information of the statistical indicator with the attribute information of the fact table.

[0148] For example, the name of the statistical indicator is the monthly salary summary of all employees in the company. The indicator name can be matched with the table names of multiple fact tables based on natural language processing or string matching algorithms, and at least one fact table with a matching degree greater than a preset matching threshold is selected, including: the monthly salary summary table of procurement department employees and the monthly salary summary table of sales department employees, and the above two tables are used as the fact tables corresponding to the statistical indicator.

[0149] In one embodiment of the present invention, determining at least one dimension information table according to at least one fact table includes:

[0150] Identify at least one dimension field in the fact table;

[0151] Determine at least one dimension information table corresponding to a dimension field from the multiple dimension information tables;

[0152] The determined dimension information table is used as the dimension information table corresponding to the statistical indicator.

[0153] After determining the fact table corresponding to the statistical indicator, the dimension table corresponding to the statistical indicator can be determined according to the dimension fields included in the fact table. For example, if the fact table includes: organization field and gender field, the organization dimension information table and the gender dimension information table are determined as the dimension information tables corresponding to the statistical indicator.

[0154] Figure 6 FIG. 1 is a schematic diagram of a process of another indicator determination method provided by an embodiment of the present invention. The embodiment of the present invention provides an indicator determination method, such as Figure 6 As shown, including:

[0155] Step 601: Obtain statistical rules corresponding to statistical indicators.

[0156] Step 602: Determine a fact table, a dimension information table and a measurement rule according to the statistical rules, wherein the fact table includes measurement fields corresponding to the statistical indicators.

[0157] Step 603: Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes a metric field.

[0158] Step 604: According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine statistical indicators.

[0159] Traditional indicator definitions are difficult to manage in a unified manner due to inconsistent expressions. The same business indicator may be repeatedly developed in different projects, and it is difficult to maintain consistent business caliber.

[0160] The embodiment of the present invention predefines the corresponding statistical rules of statistical indicators and fact tables, dimension information tables and measurement rules in the system. When the indicator statistics are subsequently performed, the statistical indicators can be directly calculated according to the statistical rules. A unified and standardized indicator management system can be formed, so that the indicator business definition statistics, technical processing caliber can be visualized, and the data processing path can be traced back. Based on the standardized indicator statistics, flexible and changeable processing methods can be implemented according to different application scenarios.

[0161] In one embodiment of the present invention, the method further comprises:

[0162] Establish data asset definitions, which include: dimension standardization definition, metric standardization definition, and metric calculation method standardization definition;

[0163] According to the standardized definition of dimensions, the standardized definition of measurements and the standardized definition of measurement calculation methods, statistical rules corresponding to statistical indicators are established. Statistical indicators include: basic indicators, composite indicators and derived indicators.

[0164] Data assets are defined as indicators that can be standardized and the basic elements of indicators (dimensions, measurement calibers, and measurement methods) are standardized. Any dimension and measurement has unique business meaning, and different names for the same object are not allowed. The definition description of indicators can only use standardized basic elements. Definitions other than basic elements need to be supplemented with basic elements.

[0165] Dimension standardization definition is used to standardize dimensions. Dimension is a measurement environment, used to describe a type of business attribute, which is a certain characteristic of things, such as time, organization, gender, currency, product, etc. As shown in Table 1, each record in Table 1 is common dimension standardization definition information provided by an embodiment of the present invention.

[0166] Table 1 Dimension standardization definition table

[0167]

[0168] Metric standardization definition is used to standardize metrics. Metrics are used to measure a physical attribute of an object and are the quantified result of a feature. The following are common metric fields provided in the embodiments of the present invention, including: balance, average daily balance, number of customers, number of visits, etc.

[0169] The standardized definition of the metric calculation method is used to standardize the metric calculation method. The metric method is a statistical method of measurement. The following are common metric methods provided by the embodiments of the present invention, including: summation, counting, unique value counting, average value, etc.

[0170] The indicator business definition is used to standardize the measurement fields, measurement methods, measurement calibers and dimensions corresponding to the statistical indicators. Indicators are divided into basic indicators, composite indicators and derived indicators. Basic indicators are standardized definitions based on fact tables and dimension tables, composite indicators are the logical operation results of basic indicators, and derived indicators are the derivatives of basic indicators and composite indicators in the time dimension.

[0171] The process of creating a basic indicator includes: selecting a measurement field; selecting a measurement method; selecting a measurement caliber and selecting a dimension. The process of creating a composite indicator includes: selecting a basic indicator and filling in arithmetic formulas. The process of creating a derived indicator includes: selecting an indicator and selecting a time dimension derived measure.

[0172] Example 1: For the basic indicator: Balance of RMB deposits for private individuals at outlets, the measurement field is: Balance, the measurement method is "Sum" of "Balance", the measurement caliber is currency dimension = RMB and public and private flag dimension = private individuals, and the measurement dimensions are: time dimension.Business date, institution dimension.Institution number, institution dimension.Institution name.

[0173] Example 2: For the composite indicator: RMB deposit balance at outlets, the basic indicators are: RMB personal deposit balance at outlets, RMB corporate deposit balance at outlets. The calculation formula is addition. RMB deposit balance at outlets = RMB personal deposit balance at outlets + RMB corporate deposit balance at outlets.

[0174] Example 3: For the derived indicator: RMB deposit balance at outlets compared with the previous month, select the indicator "RMB deposit balance at outlets" and select the derived measure "Compared with the previous month".

[0175] The embodiment of the present invention solves the problem of unified definition of indicators and realizes the uniqueness constraint of indicators. The indicator definition content is automatically converted into technical processing, which realizes the unification of indicator processing, solves the errors caused by human factors, and improves processing efficiency.

[0176] The statistical rules corresponding to the indicators provide a standardized unique expression of the indicators. Applying the statistical rules corresponding to the above statistical indicators, the following can be achieved: Figure 6 In order to make the method of the embodiment of the present invention easier to understand, the method of calculating the account deposit balance as a statistical indicator is explained, including the following steps:

[0177] S1: According to statistical rules, determine the fact table, dimension information table and measurement rules, wherein the fact table includes measurement fields corresponding to the statistical indicators.

[0178] Indicator processing is based on fact table data and dimension table data. Dimensions and metrics have been standardized through the data asset definition phase. It is necessary to determine whether each field in the fact table is a dimension or a metric, associate the dimension field with the corresponding dimension table, and associate the metric field with the corresponding metric. The account deposit balance table shown in Table 2 is a fact table, and the balance field is a metric field. The institution dimension information table in Table 3, the time dimension information table in Table 4, the currency dimension information table in Table 5, and the public and private sign dimension information table in Table 6 are all dimension information tables related to balance statistical indicators.

[0179] Table 2 Account deposit balance table

[0180]

[0181] Table 3 Organization dimension information table

[0182] Institution Number Institution Name Institution Type Institutional Level ……

[0183] Table 4 Time dimension information table

[0184] Business Date Previous day Last month Last year ……

[0185] Table 5 Currency dimension information table

[0186]

[0187]

[0188] Table 6 Public and private sign dimension information table

[0189] Public and private signs Public and private logo names ……

[0190] S2: Generate a basic data table based on the dimension information table and the fact table, wherein the basic data table includes measurement fields.

[0191] Figure 7 FIG. 1 is a schematic diagram of the composition structure of a basic data table provided by an embodiment of the present invention. Figure 7 As shown, based on the fact table and dimension table in step S1, a standardized account deposit balance model is generated, and the model is the basic data table.

[0192] S3: According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine the statistical indicators.

[0193] Based on the indicator business definition results, the basic indicator results are dynamically constructed based on the basic data table. Based on the basic indicator results, the composite indicator is constructed according to the composite indicator definition. Fig. 9 FIG. 1 is a schematic diagram of a method for setting a measurement rule for a composite indicator provided by an embodiment of the present invention. Fig. 9As shown in the figure, the composite indicator is: the balance of RMB deposits at outlets, the first statistical indicator is: the balance of RMB deposits for private use at outlets, and the second statistical indicator is: the balance of RMB deposits for public use at outlets. The measurement method is addition. That is, the composite indicator value is determined by the following formula: the balance of RMB deposits at outlets = the balance of RMB deposits for private use at outlets + the balance of RMB deposits for public use at outlets.

[0194] Based on the basic indicator results and composite indicator results, the derived indicator results are constructed according to the time dimension derivative measurement calculation. Fig.10 FIG. 1 is a schematic diagram of a method for setting a measurement rule for a derivative indicator provided by an embodiment of the present invention. Fig.10 As shown in the figure, the derived indicator is: the balance of RMB deposits at outlets compared with the previous month, the third statistical indicator is: the balance of RMB deposits at outlets during the current period, and the fourth statistical indicator is: the balance of RMB deposits at outlets at the end of the previous month. The measurement method is subtraction. That is, the derived indicator value is determined by the following formula: the balance of RMB deposits at outlets compared with the previous month = the balance of RMB deposits at outlets during the current period - the balance of RMB deposits at outlets at the end of the previous month.

[0195] Fig.11 : is a schematic diagram of a structure of an indicator determination device provided by an embodiment of the present invention, comprising:

[0196] A table acquisition module 1101 is used to acquire at least one fact table, at least one dimension information table and a measurement rule corresponding to the statistical indicator, wherein the fact table includes a measurement field corresponding to the statistical indicator;

[0197] A table generation module 1102 is used to generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field;

[0198] The indicator determination module 1103 is used to perform statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical indicator.

[0199] In one embodiment of the present invention, the table generation module 1102 is specifically used for:

[0200] For each data record in the fact table: determine the dimension field in the data record; associate the dimension field with the dimension information table to determine the dimension information corresponding to the dimension field; add the dimension information to the data record to generate a basic data table.

[0201] In one embodiment of the present invention, the measurement rules include measurement caliber;

[0202] The indicator determination module 1103 is specifically used to: filter out the record set to be counted from the basic data table according to the measurement caliber;

[0203] Perform statistical processing on the measurement fields in the statistical record set to determine the statistical indicators.

[0204] In one embodiment of the present invention, the measurement rule includes a measurement method;

[0205] The indicator determination module 1103 is specifically used to: count the metric fields in the record set to be counted in a metric manner to determine the statistical indicator.

[0206] In one embodiment of the present invention, the statistical indicator is a composite indicator; the at least one fact table includes: a first fact table and a second fact table;

[0207] The table generation module 1102 is specifically used to: generate a first basic data table according to the dimension information table and the first fact table;

[0208] Generate a second basic data table according to the dimension information table and the second fact table;

[0209] The indicator determination module 1103 is specifically used to: perform statistical processing on the first metric field in the first basic data table to determine a first statistical indicator;

[0210] Performing statistical processing on the second metric field in the second basic data table to determine a second statistical indicator;

[0211] A composite indicator is determined according to the first statistical indicator, the second statistical indicator and the measurement rule.

[0212] In one embodiment of the present invention, the measurement rule includes a measurement method;

[0213] The indicator determination module 1103 is specifically used to perform statistical processing on the first statistical indicator and the second statistical indicator in a metric manner to determine a composite indicator.

[0214] In one embodiment of the present invention, the statistical indicator is a derived indicator; the measurement rule includes: a first statistical time and a second statistical time;

[0215] The indicator determination module 1103 is specifically used to: filter out a first statistical record set from the basic data table according to the first statistical time;

[0216] Performing statistical processing on the metric field in the first statistical record set to determine a third statistical indicator corresponding to the first statistical time;

[0217] According to the second statistical time, a second statistical record set is selected from the basic data table;

[0218] Performing statistical processing on the metric field in the second statistical record set to determine a fourth statistical indicator corresponding to the second statistical time;

[0219] Derived indicators are determined based on the third statistical indicator, the fourth statistical indicator and the measurement rules.

[0220] In one embodiment of the present invention, the measurement rule further includes a measurement method;

[0221] The indicator determination module 1103 is specifically used to perform statistical processing on the third statistical indicator and the fourth statistical indicator in a metric manner to determine a composite indicator.

[0222] In one embodiment of the present invention, there are multiple fact tables; the measurement rules include: the association mode between the fact tables;

[0223] The indicator determination module 1103 is specifically used to: generate an associated fact table according to a plurality of fact tables and associated relationships;

[0224] Generate a basic data table based on the dimension information table and related fact tables.

[0225] In one embodiment of the present invention, the table acquisition module 1101 is specifically used for:

[0226] Obtain statistical rules corresponding to statistical indicators;

[0227] According to statistical rules, determine the fact table, dimension information table and measurement rules.

[0228] In one embodiment of the present invention, the table acquisition module 1101 is specifically used for:

[0229] Get the attribute information of statistical indicators;

[0230] Get attribute information of multiple fact tables;

[0231] Determine the matching degree between the attribute information of the statistical indicator and the attribute information of the fact table respectively;

[0232] According to the matching degree, determining at least one fact table corresponding to the statistical indicator from the multiple fact tables;

[0233] At least one dimension information table is determined according to at least one fact table.

[0234] In one embodiment of the present invention, the table acquisition module 1101 is specifically used for:

[0235] Identify at least one dimension field in the fact table;

[0236] Determine at least one dimension information table corresponding to a dimension field from the multiple dimension information tables;

[0237] The determined dimension information table is used as the dimension information table corresponding to the statistical indicator.

[0238] An embodiment of the present invention provides an electronic device, including:

[0239] one or more processors;

[0240] a storage device for storing one or more programs,

[0241] When one or more programs are executed by one or more processors, the one or more processors implement the method of any of the above embodiments.

[0242] Reference below Fig.12 , which shows a schematic diagram of the structure of a computer system 1200 of a terminal device suitable for implementing an embodiment of the present invention. Fig.12 The terminal device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0243] like Fig.12 As shown, the computer system 1200 includes a central processing unit (CPU) 1201, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1202 or a program loaded from a storage part 1208 into a random access memory (RAM) 1203. In the RAM 1203, various programs and data required for the operation of the system 1200 are also stored. The CPU 1201, the ROM 1202, and the RAM 1203 are connected to each other via a bus 1204. An input / output (I / O) interface 1205 is also connected to the bus 1204.

[0244] The following components are connected to the I / O interface 1205: an input section 1206 including a keyboard, a mouse, etc.; an output section 1207 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1208 including a hard disk, etc.; and a communication section 1209 including a network interface card such as a LAN card, a modem, etc. The communication section 1209 performs communication processing via a network such as the Internet. A drive 1210 is also connected to the I / O interface 1205 as needed. A removable medium 1211, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1210 as needed, so that a computer program read therefrom is installed into the storage section 1208 as needed.

[0245] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 1209, and / or installed from the removable medium 1211. When the computer program is executed by the central processing unit (CPU) 1201, the above-mentioned functions defined in the system of the present invention are executed.

[0246] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.

[0247] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0248] The modules involved in the embodiments of the present invention may be implemented in software or hardware. The modules described may also be set in a processor, for example, they may be described as: a processor including a table acquisition module, a table generation module, and an indicator determination module. The names of these modules do not, in some cases, constitute limitations on the modules themselves. For example, the table acquisition module may also be described as a "module for acquiring at least one fact table, at least one dimension information table, and a measurement rule corresponding to a statistical indicator."

[0249] As another aspect, the present invention further provides a computer-readable medium, which may be included in the device described in the above embodiment; or may exist independently without being assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device includes:

[0250] Acquire at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator;

[0251] Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field;

[0252] According to the measurement rules, statistical processing is performed on the measurement fields in the basic data table to determine the statistical indicators.

[0253] According to the technical solution of the embodiment of the present invention, the statistical indicator can be automatically calculated based on at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator. Compared with manual statistics and hard-coding of indicators, it can save the manpower cost required for the statistical indicator process, has high efficiency, and the statistical results are reliable and not prone to errors.

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

Claims

1. A method for determining an indicator, characterized in that: include: Acquire at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator; Generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field; According to the measurement rule, statistical processing is performed on the measurement fields in the basic data table to determine the statistical index; The obtaining of at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator includes: obtaining attribute information of the statistical indicator; obtaining attribute information of multiple fact tables; respectively determining the matching degree between the attribute information of the statistical indicator and the attribute information of the multiple fact tables; determining at least one fact table corresponding to the statistical indicator from the multiple fact tables based on the matching degree; and determining the at least one dimension information table based on the at least one fact table.

2. The method according to claim 1, characterized in that The generating a basic data table according to the dimension information table and the fact table includes: For each data record in the fact table: determine the dimension field in the data record; associate the dimension field with the dimension information table to determine the dimension information corresponding to the dimension field; add the dimension information to the data record to generate the basic data table.

3. The method according to claim 1, characterized in that The measurement rules include measurement caliber; The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes: According to the measurement caliber, a set of records to be counted is selected from the basic data table; Statistical processing is performed on the metric fields in the record set to be counted to determine the statistical index.

4. The method according to claim 3, characterized in that The measurement rules include measurement methods; The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes: The metric fields in the record set to be counted are counted in the metric manner to determine the statistical index.

5. The method according to claim 1, characterized in that The statistical indicators mentioned are composite indicators; The at least one fact table includes: a first fact table and a second fact table; The generating a basic data table according to the dimension information table and the fact table includes: Generate a first basic data table according to the dimension information table and the first fact table; Generate a second basic data table according to the dimension information table and the second fact table; The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes: Performing statistical processing on the first metric field in the first basic data table to determine a first statistical indicator; Performing statistical processing on the second metric field in the second basic data table to determine a second statistical index; The composite indicator is determined according to the first statistical indicator, the second statistical indicator and the measurement rule.

6. The method according to claim 5, characterized in that The measurement rules include measurement methods; The determining the composite indicator according to the first statistical indicator, the second statistical indicator and the measurement rule includes: The first statistical indicator and the second statistical indicator are statistically processed in the measurement manner to determine the composite indicator.

7. The method according to claim 1, characterized in that The statistical indicator is a derived indicator; the measurement rule includes: a first statistical time and a second statistical time; The step of performing statistical processing on the metric fields in the basic data table according to the metric rule to determine the statistical index includes: According to the first statistical time, a first statistical record set is selected from the basic data table; Performing statistical processing on the metric field in the first statistical record set to determine a third statistical indicator corresponding to the first statistical time; According to the second statistical time, a second statistical record set is selected from the basic data table; Performing statistical processing on the metric field in the second statistical record set to determine a fourth statistical indicator corresponding to the second statistical time; The derived indicator is determined according to the third statistical indicator, the fourth statistical indicator and the measurement rule.

8. The method according to claim 7, characterized in that The measurement rules also include measurement methods; The determining the derived indicator according to the third statistical indicator, the fourth statistical indicator and the measurement rule includes: The third statistical indicator and the fourth statistical indicator are statistically processed in the measurement manner to determine the derived indicator.

9. The method according to claim 1, characterized in that: The number of the fact tables is multiple; The measurement rules include: association relationships between fact tables; The generating a basic data table according to the dimension information table and the fact table includes: Generate an associated fact table according to the multiple fact tables and the associated relationships; The basic data table is generated according to the dimension information table and the associated fact table.

10. The method according to claim 1, characterized in that The obtaining of at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicators includes: Obtaining statistical rules corresponding to the statistical indicators; According to the statistical rules, the fact table, the dimension information table and the measurement rules are determined.

11. The method according to claim 10, characterized in that The determining, according to the at least one fact table, the at least one dimension information table comprises: determining at least one dimension field in the fact table; Determine at least one dimension information table corresponding to the dimension field from the plurality of dimension information tables; The determined dimension information table is used as the dimension information table corresponding to the statistical indicator.

12. An indicator determination device, characterized in that: include: A table acquisition module, used to acquire at least one fact table, at least one dimension information table and measurement rules corresponding to the statistical indicator, wherein the fact table includes the measurement field corresponding to the statistical indicator; A table generation module, configured to generate a basic data table according to the dimension information table and the fact table, wherein the basic data table includes the metric field; An indicator determination module, used to perform statistical processing on the metric fields in the basic data table according to the metric rules to determine the statistical indicators; The table acquisition module is specifically used to: obtain the attribute information of the statistical indicator; obtain the attribute information of multiple fact tables; respectively determine the matching degree between the attribute information of the statistical indicator and the attribute information of the multiple fact tables; based on the matching degree, determine at least one fact table corresponding to the statistical indicator from the multiple fact tables; and determine the at least one dimension information table based on the at least one fact table.

13. An electronic device, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 11.

14. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 11 is implemented.

Images