Method, device, electronic device and storage medium for determining index correlation

By analyzing the sub-calculation indicators under multiple dimensions of the calculated indicators and obtaining data fields, the correlation between indicators is determined, which solves the problem of duplicate calculation of indicators and improves the efficiency and accuracy of identifying similar indicators.

CN111782691BActive Publication Date: 2024-11-15BEIJING SANKUAI ONLINE TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202010404574.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2020-05-13
Publication Date
2024-11-15
Estimated Expiration
2040-05-13

AI Technical Summary

Technical Problem

In existing technologies, indicators with different names but the same calculation logic are prone to duplicate calculations, wasting resources, increasing complexity and making them difficult to identify. Manual management is inefficient and has low accuracy.

Method used

By parsing and calculating the metrics, we can determine their sub-metrics across multiple dimensions, retrieve data fields from a pre-built database, and determine the correlation between metrics based on these data fields, thus avoiding reliance on metric names.

Benefits of technology

It improves the efficiency and accuracy of identifying similar indicators, reduces the waste of computing and storage resources, and simplifies indicator management.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN111782691B_ABST
    Figure CN111782691B_ABST
Patent Text Reader

Abstract

The embodiments of the present disclosure provide a method, device, electronic device and storage medium for determining the correlation of indicators. The method comprises: obtaining at least two calculation indicators; parsing the at least two calculation indicators to determine the sub-calculation indicators of the at least two calculation indicators under at least one dimension; obtaining the data fields corresponding to the sub-calculation indicators from a preset database; and determining the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiments of the present disclosure can improve the efficiency and accuracy of identifying similar indicators.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] Embodiments of the present disclosure relate to the technical field of data indicator processing, and in particular, to an indicator correlation determination method, device, electronic device, and storage medium. Background Art

[0002] The data in the data warehouse is ultimately output in the form of calculated indicators. In our work, we often encounter indicators with different names but the same calculation logic, which are actually the same indicator. This situation can easily lead to repeated calculations and waste computing and storage resources. It also increases the complexity of indicators, easily causes misunderstandings, increases communication and usage costs, and is difficult to detect in daily life.

[0003] In the existing technical solutions, manual management is usually adopted to judge the similarity of indicators by indicator names. This method is very inefficient and the accuracy of identifying similar indicators is not high. Summary of the invention

[0004] Embodiments of the present disclosure provide a method, device, electronic device, and storage medium for determining indicator correlation, so as to improve the efficiency and accuracy of identifying similar indicators.

[0005] According to a first aspect of an embodiment of the present disclosure, a method for determining an indicator relevance is provided, comprising:

[0006] Get at least two calculated metrics;

[0007] Parsing the at least two calculation indicators to determine sub-calculation indicators of the at least two calculation indicators in at least one dimension;

[0008] Obtaining data fields corresponding to the sub-calculation indicators from a preset database;

[0009] The correlation between the at least two calculation indicators is determined according to the data fields corresponding to the sub-calculation indicators.

[0010] Optionally, parsing the at least two calculation indicators to determine sub-calculation indicators of the at least two calculation indicators in at least one dimension includes:

[0011] Parsing the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions;

[0012] Deduplication processing is performed on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator under the at least one dimension.

[0013] Optionally, acquiring a data field corresponding to the sub-calculation indicator from a preset database includes:

[0014] The preset database is searched according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain the data fields under the sub-calculation indicators corresponding to the at least two calculation indicators.

[0015] Optionally, the sub-calculation indicators include: at least one of a calculation dimension indicator, an aggregation method indicator, a data source indicator, a filtering rule indicator, and an association relationship indicator.

[0016] Optionally, when the sub-calculation indicator includes the calculation dimension indicator, the aggregation mode indicator, the data source indicator, the filtering rule indicator, and the association relationship indicator at the same time, determining the association between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators includes:

[0017] When it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are completely identical, determining that the at least two calculation indicators are repeated calculation indicators;

[0018] When only the filtering rule indicator and the calculation dimension indicator are different among the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field, determining that the at least two calculation indicators are similar calculation indicators;

[0019] When it is determined according to the data field that only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators, it is determined that the at least two calculation indicators are the same type of calculation indicators.

[0020] According to a second aspect of an embodiment of the present disclosure, there is provided an indicator relevance determination device, comprising:

[0021] A calculation indicator acquisition module, used to obtain at least two calculation indicators;

[0022] A sub-calculation indicator determination module, used to parse the at least two calculation indicators and determine sub-calculation indicators of the at least two calculation indicators in at least one dimension;

[0023] A data field acquisition module is used to acquire the data field corresponding to the sub-calculation indicator from a preset database;

[0024] The indicator correlation determination module is used to determine the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators.

[0025] Optionally, the sub-computation indicator determination module includes:

[0026] An initial calculation indicator acquisition unit, configured to parse the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions;

[0027] The sub-computation indicator acquisition unit is used to perform deduplication processing on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator under the at least one dimension.

[0028] Optionally, the data field acquisition module includes:

[0029] The data field acquisition unit is used to search the preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain the data fields under the sub-calculation indicators corresponding to the at least two calculation indicators.

[0030] Optionally, the sub-calculation indicators include: at least one of a calculation dimension indicator, an aggregation method indicator, a data source indicator, a filtering rule indicator, and an association relationship indicator.

[0031] Optionally, when the sub-calculation indicator includes the calculation dimension indicator, the aggregation mode indicator, the data source indicator, the filtering rule indicator, and the association relationship indicator at the same time, the indicator association determination module includes:

[0032] a repeated indicator determination unit, configured to determine that the at least two calculation indicators are repeated calculation indicators when it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are exactly the same;

[0033] a similarity indicator determination unit, configured to determine that the at least two calculation indicators are similar calculation indicators when, in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field, only the filtering rule indicator and the calculation dimension indicator are different;

[0034] The same type indicator determination unit is used to determine that the at least two calculation indicators are the same type of calculation indicators when only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field.

[0035] According to a third aspect of an embodiment of the present disclosure, there is provided an electronic device, including:

[0036] A processor, a memory, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, any one of the above-mentioned methods for determining the correlation between indicators is implemented.

[0037] According to a fourth aspect of an embodiment of the present disclosure, a readable storage medium is provided. When instructions in the storage medium are executed by a processor of an electronic device, the electronic device can execute any of the above-mentioned methods for determining indicator correlation.

[0038] The indicator correlation determination scheme provided by the embodiment of the present disclosure obtains at least two calculation indicators, parses the at least two calculation indicators, determines the sub-calculation indicators of the at least two calculation indicators under at least one dimension, obtains the data fields corresponding to the sub-calculation indicators from the preset database, and determines the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiment of the present disclosure parses the data calculation indicators according to the calculation logic of the data calculation indicators to obtain the sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators, without relying on the indicator name. Therefore, the embodiment of the present disclosure can improve the efficiency and accuracy of identifying similar indicators. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure, the drawings required for use in the description of the embodiments of the present disclosure will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the embodiments of the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0040] Figure 1 A flowchart of a method for determining an indicator correlation provided by an embodiment of the present disclosure;

[0041] Figure 2 A flowchart of another method for determining the correlation of indicators provided by an embodiment of the present disclosure;

[0042] Figure 3 A schematic diagram of the structure of an indicator correlation determination device provided in an embodiment of the present disclosure;

[0043] Figure 4 A schematic diagram of the structure of an indicator correlation determination device provided in an embodiment of the present disclosure. DETAILED DESCRIPTION

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

[0045] Embodiment 1

[0046] Reference Figure 1 , which shows a flowchart of a method for determining an indicator correlation provided by an embodiment of the present disclosure, such as Figure 1 As shown, the indicator correlation determination method may specifically include the following steps:

[0047] Step 101: Obtain at least two calculation indicators.

[0048] The embodiments of the present disclosure can be applied to scenarios where business personnel set associated calculation indicators of data in a data warehouse to detect.

[0049] The data in the data warehouse outputs data value in the form of calculation indicators. The data stored in the data warehouse exists in the form of rows and columns and is raw data without any meaning. In order to reflect the value of the data in the data warehouse, business personnel usually set calculation indicators to output data value, such as the number of visits to the website in one day and the number of visitors.

[0050] Calculation indicators refer to indicators pre-set by business personnel to reflect the value of data in the data warehouse.

[0051] When the correlation of the calculation indicators set by the business personnel needs to be detected, at least two calculation indicators pre-set by the business personnel may be obtained.

[0052] After obtaining at least two calculation indicators, step 102 is performed.

[0053] Step 102: Analyze the at least two calculation indicators to determine sub-calculation indicators of the at least two calculation indicators in at least one dimension.

[0054] Sub-calculation indicators refer to sub-indicators of multiple dimensions obtained after decomposing the calculation indicators. In this embodiment, after obtaining at least two calculation indicators, the complete SQL (Structured Query Language) of the calculation indicators can be input into the indicator identification system. The indicator identification system can parse the complete SQL of the calculation indicators. All calculation indicators will be parsed into a fixed format of calculation logic. Then, sub-calculation indicators of at least two calculation indicators in at least one dimension can be determined (such as calculation dimension indicators, data source indicators, aggregation method indicators, filtering rule indicators, association relationship indicators, etc.).

[0055] After parsing the at least two calculation indicators to obtain sub-calculation indicators of the at least two calculation indicators in at least one dimension, step 103 is performed.

[0056] Step 103: Acquire the data field corresponding to the sub-calculation indicator from the preset database.

[0057] After parsing at least two calculation indicators to obtain sub-calculation indicators of at least two calculation indicators in at least one dimension, a search can be performed in a preset database according to the sub-calculation indicators to obtain data fields corresponding to the sub-calculation indicators. Specifically, the search process can be a query process according to an SQL statement, and this embodiment will not describe this process in detail.

[0058] After the data fields corresponding to the sub-calculation indicators are acquired from the preset database, step 104 is executed.

[0059] Step 104: Determine the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators.

[0060] After obtaining the data fields corresponding to the sub-calculation indicators from the preset database, the correlation between at least two calculation indicators can be determined based on the data fields corresponding to the sub-calculation indicators. Specifically, it can be determined based on the data fields which dimension of the at least two calculation indicators has the same sub-calculation indicators, and based on the determination result, the correlation between the at least two calculation indicators can be determined.

[0061] The indicator correlation determination method provided by the embodiment of the present disclosure obtains at least two calculation indicators, parses the at least two calculation indicators, determines the sub-calculation indicators of the at least two calculation indicators under at least one dimension, obtains the data fields corresponding to the sub-calculation indicators from the preset database, and determines the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiment of the present disclosure parses the data calculation indicators according to the calculation logic of the data calculation indicators to obtain the sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators, without relying on the indicator name. Therefore, the embodiment of the present disclosure can improve the efficiency and accuracy of identifying similar indicators.

[0062] Embodiment 2

[0063] Reference Figure 2 , which shows a flowchart of another method for determining the correlation of indicators provided by an embodiment of the present disclosure, such as Figure 2 As shown, the indicator correlation determination method may specifically include the following steps:

[0064] Step 201: Obtain at least two calculation indicators.

[0065] The embodiments of the present disclosure can be applied to scenarios where business personnel set associated calculation indicators of data in a data warehouse to detect.

[0066] The data in the data warehouse outputs data value in the form of calculation indicators. The data stored in the data warehouse exists in the form of rows and columns and is raw data without any meaning. In order to reflect the value of the data in the data warehouse, business personnel usually set calculation indicators to output data value, such as the number of visits to the website in one day and the number of visitors.

[0067] Calculation indicators refer to indicators pre-set by business personnel to reflect the value of data in the data warehouse.

[0068] When the correlation of the calculation indicators set by the business personnel needs to be detected, at least two calculation indicators pre-set by the business personnel may be obtained.

[0069] After obtaining at least two calculation indicators, step 202 is executed.

[0070] Step 202: parse the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions.

[0071] The initial sub-calculation indicator refers to the sub-calculation indicators under multiple dimensions that have not been filtered after the calculation indicator is parsed.

[0072] After obtaining at least two calculation indicators, the complete SQL (Structured Query Language) of the calculation indicators can be input into the indicator identification system. The indicator identification system can parse the complete SQL of the calculation indicators. All calculation indicators will be parsed into a fixed format of calculation logic. Then, the initial sub-calculation indicators of at least two calculation indicators in multiple dimensions can be determined.

[0073] After the at least two calculation indicators are parsed to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions, step 203 is performed.

[0074] Step 203: Deduplication processing is performed on the initial sub-calculation indicators corresponding to each calculation indicator to obtain the sub-calculation indicators of each calculation indicator under the at least one dimension.

[0075] After obtaining the initial sub-calculation indicators of at least two calculation indicators in multiple dimensions, the initial sub-calculation indicators corresponding to each calculation indicator can be deduplicated, that is, the business personnel remove the same indicators in the initial sub-calculation indicators and retain only one of the same initial sub-calculation indicators.

[0076] After deduplication processing is performed on the initial sub-computation indicators corresponding to each calculation indicator, the sub-computation indicators of each calculation indicator in at least one dimension can be obtained.

[0077] In this embodiment, the sub-calculation index may include at least one of: a calculation dimension index, an aggregation method index, a data source index, a filtering rule index, an association relationship index, and the like.

[0078] The calculation dimension index refers to the grouping index of the data field. For example, taking gender as an example, the gender corresponding to the data field is male, which is one dimension, and the gender corresponding to the data field is female, which is another dimension.

[0079] Aggregation indicators refer to indicators of the data table associated with a data field. For example, a data field may be associated with multiple data tables. Aggregation calculations such as cumulative average size are used to determine whether two data fields are the same.

[0080] The data source indicator refers to the source of the data master table of the data field.

[0081] The filter rule indicators refer to all the where conditions involved after the final valid table is determined as all the filter rule indicators. For example, for a data field, a gender, such as male, can be passed in and the gender can be used as a filter rule.

[0082] The correlation indicator refers to the dimension that uses the main table as the target table to verify whether the auxiliary table has an impact on the final result of the statistical indicator.

[0083] After deduplication processing is performed on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator in at least one dimension, step 204 is executed.

[0084] Step 204: searching the preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain the data fields under the sub-calculation indicators corresponding to the at least two calculation indicators.

[0085] After deduplication processing is performed on the initial sub-calculation indicators corresponding to each calculation indicator to obtain the sub-calculation indicators of each calculation indicator under at least one dimension, a search can be performed in the preset database according to the sub-calculation indicators to obtain data fields under the sub-calculation indicators corresponding to at least two calculation indicators. Specifically, the search process can be a query process according to an SQL statement, and this embodiment will not describe this process in detail.

[0086] After obtaining the data fields under the sub-calculation indicators corresponding to at least two calculation indicators, execute step 205, or execute step 206, or execute step 207.

[0087] Step 205: When it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are completely identical, it is determined that the at least two calculation indicators are repeated calculation indicators.

[0088] After obtaining the data fields under the sub-calculation indicators corresponding to at least two calculation indicators, it can be determined whether the sub-calculation indicators corresponding to the two calculation indicators are the same according to the data fields corresponding to each calculation indicator.

[0089] When it is determined based on the data fields that the sub-calculation indicators corresponding to at least two calculation indicators are exactly the same, that is, the calculation dimension indicators, aggregation method indicators, data source indicators, filtering rule indicators, and association relationship indicators corresponding to at least two calculation indicators are all the same, then it can be determined that at least two calculation indicators are repeated calculation indicators, that is, at least two calculation indicators are exactly the same.

[0090] Step 206: When it is determined according to the data field that only the filtering rule indicator and the calculation dimension indicator are different in the sub-calculation indicators corresponding to the at least two calculation indicators, it is determined that the at least two calculation indicators are similar calculation indicators.

[0091] When only the filtering rule indicator and the calculation dimension indicator are different in the sub-calculation indicators under at least two calculation indicators determined according to the data fields, at this time, the aggregation method indicator, the data source indicator, and the association relationship indicator are all the same, and it can be determined that the at least two calculation indicators are similar calculation indicators.

[0092] Step 207: when it is determined according to the data field that only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators, it is determined that the at least two calculation indicators are the same type of calculation indicators.

[0093] When it is determined based on the data fields that only the association relationship indicators are the same in the sub-calculation indicators corresponding to at least two calculation indicators, at this time, the calculation dimension indicators, aggregation method indicators, data source indicators, and filtering rule indicators corresponding to the at least two calculation indicators are all different, and it can be determined that the at least two calculation indicators are the same type of calculation indicators.

[0094] This embodiment analyzes the data calculation indicators according to the calculation logic of the data calculation indicators to obtain sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators without relying on the indicator names, which can improve the accuracy of identifying similar indicators.

[0095] The indicator correlation determination method provided by the embodiment of the present disclosure obtains at least two calculation indicators, parses the at least two calculation indicators, determines the sub-calculation indicators of the at least two calculation indicators under at least one dimension, obtains the data fields corresponding to the sub-calculation indicators from the preset database, and determines the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiment of the present disclosure parses the data calculation indicators according to the calculation logic of the data calculation indicators to obtain the sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators, without relying on the indicator name. Therefore, the embodiment of the present disclosure can improve the efficiency and accuracy of identifying similar indicators.

[0096] Embodiment 3

[0097] Reference Figure 3 , which shows a schematic diagram of the structure of an indicator correlation determination device provided by an embodiment of the present disclosure, such as Figure 3 As shown, the indicator correlation determination device may specifically include the following modules:

[0098] A calculation index acquisition module 310 is used to acquire at least two calculation indexes;

[0099] A sub-calculation indicator determination module 320 is used to parse the at least two calculation indicators and determine sub-calculation indicators of the at least two calculation indicators in at least one dimension;

[0100] A data field acquisition module 330 is used to acquire the data field corresponding to the sub-calculation indicator from a preset database;

[0101] The indicator correlation determination module 340 is used to determine the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators.

[0102] The indicator correlation determination device provided by the embodiment of the present disclosure obtains at least two calculation indicators, parses the at least two calculation indicators, determines the sub-calculation indicators of the at least two calculation indicators under at least one dimension, obtains the data fields corresponding to the sub-calculation indicators from the preset database, and determines the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiment of the present disclosure parses the data calculation indicators according to the calculation logic of the data calculation indicators to obtain the sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators, without relying on the indicator name. Therefore, the embodiment of the present disclosure can improve the efficiency and accuracy of identifying similar indicators.

[0103] Embodiment 4

[0104] Reference Figure 4, which shows a schematic diagram of the structure of another indicator correlation determination device provided by an embodiment of the present disclosure, such as Figure 4 As shown, the indicator correlation determination device may specifically include the following modules:

[0105] A calculation index acquisition module 410 is used to acquire at least two calculation indexes;

[0106] The sub-calculation indicator determination module 420 is used to parse the at least two calculation indicators and determine the sub-calculation indicators of the at least two calculation indicators in at least one dimension;

[0107] A data field acquisition module 430 is used to acquire the data field corresponding to the sub-calculation indicator from a preset database;

[0108] The indicator correlation determination module 440 is used to determine the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators.

[0109] Optionally, the sub-computation indicator determination module 420 includes:

[0110] An initial calculation indicator acquisition unit 421 is used to parse the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions;

[0111] The sub-computation indicator acquisition unit 422 is used to perform deduplication processing on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator under the at least one dimension.

[0112] Optionally, the data field acquisition module 430 includes:

[0113] The data field acquisition unit 431 is used to search the preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain the data fields under the sub-calculation indicators corresponding to the at least two calculation indicators.

[0114] Optionally, the sub-calculation indicators include: at least one of a calculation dimension indicator, an aggregation method indicator, a data source indicator, a filtering rule indicator, and an association relationship indicator.

[0115] Optionally, when the sub-calculation indicator includes the calculation dimension indicator, the aggregation mode indicator, the data source indicator, the filtering rule indicator, and the association relationship indicator at the same time, the indicator association determination module 440 includes:

[0116] A repeated indicator determination unit 441 is configured to determine that the at least two calculation indicators are repeated calculation indicators when it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are completely identical;

[0117] A similarity indicator determination unit 442, configured to determine that the at least two calculation indicators are similar calculation indicators when, in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field, only the filtering rule indicator and the calculation dimension indicator are different;

[0118] The same type indicator determination unit 443 is used to determine that the at least two calculation indicators are the same type of calculation indicators when only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field.

[0119] The indicator correlation determination device provided by the embodiment of the present disclosure obtains at least two calculation indicators, parses the at least two calculation indicators, determines the sub-calculation indicators of the at least two calculation indicators under at least one dimension, obtains the data fields corresponding to the sub-calculation indicators from the preset database, and determines the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators. The embodiment of the present disclosure parses the data calculation indicators according to the calculation logic of the data calculation indicators to obtain the sub-calculation indicators under multiple dimensions, and then judges the correlation between the data calculation indicators based on the sub-calculation indicators, without relying on the indicator name. Therefore, the embodiment of the present disclosure can improve the efficiency and accuracy of identifying similar indicators.

[0120] An embodiment of the present disclosure further provides an electronic device, comprising: a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the processor implements the indicator correlation determination method of the aforementioned embodiment when executing the program.

[0121] An embodiment of the present disclosure further provides a readable storage medium, when instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the indicator correlation determination method of the aforementioned embodiment.

[0122] As for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0123] The algorithms and displays provided herein are not inherently related to any particular computer, virtual system or other device. Various general purpose systems may also be used together with the teachings based thereon. According to the above description, it is apparent that the structure required for constructing such systems is. In addition, the embodiments of the present disclosure are not directed to any particular programming language either. It should be understood that the contents of the embodiments of the present disclosure described herein may be realized using various programming languages, and the description of the specific languages ​​above is intended to disclose the best mode of implementation of the embodiments of the present disclosure.

[0124] In the description provided herein, a large number of specific details are described. However, it is understood that the embodiments of the present disclosure can be practiced without these specific details. In some instances, well-known methods, structures and techniques are not shown in detail so as not to obscure the understanding of this description.

[0125] Similarly, it should be understood that in order to streamline the present disclosure and aid in understanding one or more of the various inventive aspects, in the above description of the exemplary embodiments of the present disclosure, the various features of the embodiments of the present disclosure are sometimes grouped together into a single embodiment, figure, or description thereof. However, the disclosed method should not be interpreted as reflecting the following intention: the claimed embodiments of the present disclosure require more features than the features explicitly recited in each claim. More specifically, as reflected in the claims below, the inventive aspects lie in less than all the features of the single embodiment disclosed above. Therefore, the claims that follow the specific embodiment are hereby expressly incorporated into the specific embodiment, with each claim itself serving as a separate embodiment of the embodiments of the present disclosure.

[0126] Those skilled in the art will appreciate that the modules in the devices in the embodiments may be adaptively changed and arranged in one or more devices different from the embodiments. The modules or units or components in the embodiments may be combined into one module or unit or component, and in addition they may be divided into a plurality of submodules or subunits or subcomponents. Except that at least some of such features and / or processes or units are mutually exclusive, all features disclosed in this specification (including the accompanying claims, abstracts and drawings) and all processes or units of any method or device disclosed in this manner may be combined in any combination. Unless otherwise expressly stated, each feature disclosed in this specification (including the accompanying claims, abstracts and drawings) may be replaced by an alternative feature providing the same, equivalent or similar purpose.

[0127] The various component embodiments of the embodiments of the present disclosure may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It should be understood by those skilled in the art that a microprocessor or a digital signal processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components of the dynamic picture generation device according to the embodiments of the present disclosure. The embodiments of the present disclosure may also be implemented as a device or apparatus program for executing part or all of the methods described herein. Such a program implementing an embodiment of the present disclosure may be stored on a computer-readable medium, or may be in the form of one or more signals. Such a signal may be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.

[0128] It should be noted that the above embodiments illustrate rather than limit the embodiments of the present disclosure, and that those skilled in the art may design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference symbol between brackets should not be constructed as a limitation on the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "one" or "an" preceding an element does not exclude the presence of multiple such elements. The embodiments of the present disclosure may be implemented by means of hardware including several different elements and by means of appropriately programmed computers. In a unit claim that lists several devices, several of these devices may be embodied by the same hardware item. The use of the words first, second, and third, etc. does not indicate any order. These words may be interpreted as names.

[0129] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0130] The above description is only a preferred embodiment of the embodiments of the present disclosure and is not intended to limit the embodiments of the present disclosure. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the embodiments of the present disclosure should be included in the protection scope of the embodiments of the present disclosure.

[0131] The above is only a specific implementation of the embodiment of the present disclosure, but the protection scope of the embodiment of the present disclosure is not limited thereto. Any technician familiar with the technical field can easily think of changes or replacements within the technical scope disclosed by the embodiment of the present disclosure, which should be included in the protection scope of the embodiment of the present disclosure. Therefore, the protection scope of the embodiment of the present disclosure should be based on the protection scope of the claims.

Claims

1. A method for determining the correlation of indicators, It is characterized in that include: Get at least two calculated metrics; Parsing the at least two calculation indicators to determine sub-calculation indicators of the at least two calculation indicators in at least one dimension; Searching in a preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators, obtaining data fields under the sub-calculation indicators corresponding to the at least two calculation indicators; Determining the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators; The sub-calculation indicators include: calculation dimension indicators, aggregation method indicators, data source indicators, filtering rule indicators, and association relationship indicators; The calculation dimension index refers to the grouping index of the data field, the aggregation method index refers to the data table associated with the data field, the data source index refers to the data main table source of the data field, the filtering rule index refers to the filtering rule index of all where conditions involved after determining the final valid table, and the association relationship index refers to the dimension of verifying whether the auxiliary table has an impact on the final result of the statistical indicator with the main table as the target table; The determining, according to the data fields corresponding to the sub-calculation indicators, the correlation between the at least two calculation indicators comprises: When it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are completely identical, determining that the at least two calculation indicators are repeated calculation indicators; When only the filtering rule indicator and the calculation dimension indicator are different among the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field, determining that the at least two calculation indicators are similar calculation indicators; When it is determined according to the data field that only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators, it is determined that the at least two calculation indicators are the same type of calculation indicators.

2. The method according to claim 1, It is characterized in that The parsing of the at least two calculation indicators to determine sub-calculation indicators of the at least two calculation indicators in at least one dimension includes: Parsing the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions; Deduplication processing is performed on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator under the at least one dimension.

3. A device for determining the correlation of indicators, It is characterized in that include: A calculation indicator acquisition module, used to obtain at least two calculation indicators; A sub-calculation indicator determination module, used to parse the at least two calculation indicators and determine sub-calculation indicators of the at least two calculation indicators in at least one dimension; A data field acquisition module searches a preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain data fields under the sub-calculation indicators corresponding to the at least two calculation indicators; An indicator correlation determination module, used to determine the correlation between the at least two calculation indicators according to the data fields corresponding to the sub-calculation indicators; The sub-calculation indicators include: calculation dimension indicators, aggregation method indicators, data source indicators, filtering rule indicators, and association relationship indicators. The calculation dimension indicators refer to the grouping indicators of the data fields. The aggregation method indicators refer to the data tables associated with the data fields. The data source indicators refer to the data main table sources of the data fields. The filtering rule indicators refer to the filtering rule indicators of all where conditions involved after determining the final valid table. The association relationship indicators refer to the dimensions that use the main table as the target table to verify whether the auxiliary table has an impact on the final result of the statistical indicators. The indicator relevance determination module includes: a repeated indicator determination unit, configured to determine that the at least two calculation indicators are repeated calculation indicators when it is determined according to the data field that the sub-calculation indicators corresponding to the at least two calculation indicators are exactly the same; a similarity indicator determination unit, configured to determine that the at least two calculation indicators are similar calculation indicators when, in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field, only the filtering rule indicator and the calculation dimension indicator are different; The same type indicator determination unit is used to determine that the at least two calculation indicators are the same type of calculation indicators when only the association relationship indicator is the same in the sub-calculation indicators corresponding to the at least two calculation indicators determined according to the data field.

4. The device according to claim 3, It is characterized in that The sub-calculation indicator determination module includes: An initial calculation indicator acquisition unit, used to parse the at least two calculation indicators to obtain initial sub-calculation indicators of the at least two calculation indicators in multiple dimensions; The sub-computation indicator acquisition unit is used to perform deduplication processing on the initial sub-computation indicators corresponding to each calculation indicator to obtain the sub-computation indicators of each calculation indicator under the at least one dimension.

5. The device according to claim 3, It is characterized in that The data field acquisition module includes: The data field acquisition unit is used to search the preset database according to the sub-calculation indicators corresponding to the at least two calculation indicators to obtain the data fields under the sub-calculation indicators corresponding to the at least two calculation indicators.

6. An electronic device, It is characterized in that include: A processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the method for determining the indicator correlation according to claim 1 or 2 is implemented when the processor executes the program.

7. A readable storage medium, It is characterized in that When the instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the indicator correlation determination method described in claim 1 or 2.