Standardized management method and device for enterprise-level index system

Abstract

The invention relates to a standardized management method and device for an enterprise-level index system. The method comprises the steps that on the basis of dimension basic information and index basic information, newly-added operation of dimensions and indexes is completed, calculation fields and dimension fields corresponding to atomic indexes are obtained, query statements are assembled according to the calculation fields and the dimension fields so as to achieve automatic obtaining of the atomic indexes, and the atomic indexes are obtained by defining an index calculation model. When the index calculation model passes the legality verification, selecting a dimension shared by calculation indexes associated with the index calculation model as a target dimension, and assembling a calculation statement according to the target dimension, the index calculation model and the calculation indexes associated with the index calculation model to realize automatic acquisition of the calculation indexes; by adopting the method, the development efficiency can be improved while the cost is reduced.

Description

Technical Field

[0001] The present application relates to the technical field of data management, and in particular to a standardized management method and device for an enterprise-level indicator system. Background Art

[0002] With the advent of the digital economy era, the promulgation of various laws and regulations on data management, the issuance of various policies such as the inclusion of data assets in tables, the mining and use of data value has become increasingly important. At present, the calculation of indicators is usually carried out in the traditional way of writing SQL (Structured Query Language), which requires manual completion of SQL statement writing, resulting in high costs and slow development efficiency. Summary of the invention

[0003] Based on this, it is necessary to provide a standardized management method and device for an enterprise-level indicator system that can reduce costs and improve development efficiency in response to the above technical problems.

[0004] In a first aspect, the present application provides a standardized management method for an enterprise-level indicator system, the method comprising:

[0005] Based on the basic information of the dimension, complete the dimension addition operation, and bind the target data to the corresponding dimension according to the dimension type corresponding to the target data; the dimension types include common dimensions and geographic dimensions;

[0006] Based on the basic information of the indicator, complete the operation of adding the indicator, where the indicator includes calculation indicators and atomic indicators;

[0007] Obtain the calculated fields and dimension fields corresponding to the atomic indicators respectively, assemble query statements according to the calculated fields and dimension fields, the query statements are used to associate and bind the atomic indicators with the target data corresponding to the calculated fields according to the calculated fields, and the query statements are also used to associate and bind the atomic indicators with the dimensions corresponding to the dimension fields;

[0008] Define the indicator calculation model and perform a validity check on the indicator calculation model, where the indicator calculation model corresponds to the calculation indicator, and an indicator calculation model supports the free combination of multiple atomic indicators and / or multiple calculation indicators;

[0009] When the indicator calculation model passes the legality check, the dimension common to all calculation indicators associated with the indicator calculation model is selected as the target dimension. The calculation statement is assembled according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model. The calculation statement is used to load the indicator calculation model at a preset time interval to obtain the calculation indicators corresponding to the indicator calculation model. The target dimension is used to characterize the dimension corresponding to the indicator calculation model.

[0010] In one embodiment, binding the target data to the dimension according to the dimension type corresponding to the target data includes:

[0011] When the dimension type corresponding to the target data is a geographic dimension, the classification field corresponding to the target data is obtained, and the target data is bound to the dimension based on the classification field, where the classification field includes a field for regional division;

[0012] When the dimension type corresponding to the target data is a common dimension, the target data is bound to the dimension.

[0013] In one embodiment, assembling a query statement according to the calculated field and the dimension field includes:

[0014] Determine the target data corresponding to the atomic indicator based on the calculation field, and obtain the dimension corresponding to the atomic indicator based on the dimension field;

[0015] Atomic indicators, target data corresponding to the atomic indicators, and dimensions corresponding to the atomic indicators are connected through calculation fields and dimension fields to assemble query statements.

[0016] In one embodiment, the method further comprises:

[0017] Obtaining decoration conditions, where the decoration conditions are used to screen target data corresponding to the atomic indicator and determine the specified data;

[0018] Atomic indicators, specified data, and dimensions corresponding to atomic indicators are connected through calculated fields, dimension fields, and decorative conditions to assemble query statements.

[0019] In one embodiment, the number of target dimensions is one or more; selecting dimensions common to the calculation indicators associated with the indicator calculation model as target dimensions includes:

[0020] Business demand information is obtained, and based on the business demand information, a target dimension is determined from dimensions common to all calculation indicators associated with the indicator calculation model.

[0021] In one embodiment, assembling a calculation statement according to a target dimension, an indicator calculation model, and a calculation indicator associated with the indicator calculation model includes:

[0022] The target dimension and the indicator calculation model are connected through the calculated indicator associated with the indicator calculation model to assemble the calculation statement.

[0023] In a second aspect, the present application also provides a standardized management device for an enterprise-level indicator system, the device comprising:

[0024] The dimension adding module is used to complete the dimension adding operation based on the basic information of the dimension, and bind the target data to the corresponding dimension according to the dimension type corresponding to the target data; the dimension types include common dimensions and geographic dimensions;

[0025] The indicator adding module is used to complete the indicator adding operation based on the basic information of the indicator, where the indicator includes calculation indicators and atomic indicators;

[0026] The first statement module is used to obtain the calculated fields and dimension fields corresponding to the atomic indicators respectively, assemble query statements according to the calculated fields and dimension fields, and the query statements are used to associate and bind the atomic indicators with the target data corresponding to the calculated fields according to the calculated fields. The query statements are also used to associate and bind the atomic indicators with the dimensions corresponding to the dimension fields.

[0027] The second statement module is used to define an indicator calculation model and perform a validity check on the indicator calculation model, wherein the indicator calculation model corresponds to the calculation indicator, and an indicator calculation model supports a free combination of multiple atomic indicators and / or multiple calculation indicators;

[0028] The second statement module is also used to select the common dimension of each calculation indicator associated with the indicator calculation model as the target dimension when the indicator calculation model passes the legality check, and assemble the calculation statement according to the target dimension, the indicator calculation model, and the calculation indicator associated with the indicator calculation model. The calculation statement is used to load the indicator calculation model at a preset time interval to run and obtain the calculation indicator corresponding to the indicator calculation model; the target dimension is used to characterize the dimension corresponding to the indicator calculation model.

[0029] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above method when executing the computer program.

[0030] In a fourth aspect, the present application also provides a computer-readable storage medium having a computer program stored thereon, which implements the steps of the above method when the computer program is executed by a processor.

[0031] In a fifth aspect, the present application also provides a computer program product, including a computer program, which implements the steps of the above method when executed by a processor.

[0032] The above-mentioned standardized management method and device of the enterprise-level indicator system, by completing the new operations of dimensions and indicators based on the basic information of dimensions and indicators, respectively, obtains the calculation fields and dimension fields corresponding to the atomic indicators respectively, assembles query statements according to the calculation fields and dimension fields to realize automatic acquisition of atomic indicators, and defines the indicator calculation model. When the indicator calculation model passes the legality check, the dimension common to each calculation indicator associated with the indicator calculation model is selected as the target dimension, and the calculation statement is assembled according to the target dimension, the indicator calculation model, and the calculation indicator associated with the indicator calculation model to realize automatic acquisition of the calculation indicator; after the user completes the definition of the calculation field and the dimension field, the application can automatically generate a query statement to realize automatic acquisition of the atomic indicator. After the user completes the definition of the indicator calculation model and the target dimension, the application can automatically generate a calculation statement to realize automatic acquisition of the calculation indicator. Compared with the traditional method of manually writing SQL statements to realize the calculation of indicators, the automatic assembly of corresponding query statements is realized, which reduces costs and improves development efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0034] Figure 1 A flowchart of a standardized management method for an enterprise-level indicator system in one embodiment;

[0035] Figure 2 A schematic diagram of the process of dimension creation and data binding in one embodiment;

[0036] Figure 3 A schematic diagram of a process for managing an indicator directory in one embodiment;

[0037] Figure 4 A flowchart of steps for assembling a query statement according to calculation fields and dimension fields in one embodiment;

[0038] Figure 5 A flowchart of steps for assembling a calculation statement according to a target dimension, an indicator calculation model, and calculation indicators associated with the indicator calculation model in one embodiment;

[0039] Figure 6 A schematic diagram of a process flow of a standardized management method for an enterprise-level indicator system in another embodiment;

[0040] Figure 7It is a structural block diagram of a standardized management device for an enterprise-level indicator system in one embodiment;

[0041] Figure 8 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0042] In order to facilitate understanding of the present application, the present application will be described more fully below with reference to the relevant drawings. Embodiments of the present application are provided in the drawings. However, the present application can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present application more thorough and comprehensive.

[0043] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein in the specification of this application are only for the purpose of describing specific embodiments and are not intended to limit this application.

[0044] It can be understood that the terms "first", "second", etc. used in the present application can be used in this article to describe various elements, but these elements are not limited by these terms. These terms are only used to distinguish the first element from another element.

[0045] It can be understood that the “connection” in the following embodiments should be understood as “electrical connection”, “communication connection”, etc. if the connected circuits, modules, units, etc. have electrical signals or data transmission between each other.

[0046] It can be understood that “at least one” means one or more, “plurality” means two or more, and “at least a portion of an element” means a part or all of an element.

[0047] When used herein, the singular forms "a", "an", and "said / the" may also include plural forms, unless the context clearly indicates otherwise. It should also be understood that the terms "include / comprise" or "have" and the like specify the presence of stated features, wholes, steps, operations, components, parts, or combinations thereof, but do not exclude the possibility of the presence or addition of one or more other features, wholes, steps, operations, components, parts, or combinations thereof. At the same time, the term "and / or" used in this specification includes any and all combinations of the relevant listed items.

[0048] At present, data is an important production factor and a basic strategic resource for enterprises. With the advent of the digital economy era, the promulgation of various laws and regulations on data management, the issuance of various policies such as the inclusion of data assets in the table, the mining and use of data value has become increasingly important. At present, enterprise data management is chaotic, data quality is uneven, and there are serious problems such as dark data, isolated data and inconsistent data standards. For example, the traditional indicator system management method includes at least the following problems: ① Indicator management includes the management of three parts: business attributes, technical attributes, and management attributes of indicators. However, many companies currently do not have indicator data standards. Although some companies have formulated indicator data standards, they have not applied them. Some companies use offline documents for management, which makes the entire management work chaotic and inefficient. ② For indicator calculation, In the past, the traditional way of writing SQL was adopted, which required specialized technicians to write SQL statements and complete the calculation of indicators by configuring jobs. The development efficiency of these indicator calculations was very low. It took about 1 to 2 days for one person to develop an indicator, which resulted in high costs and slow development efficiency. ③ If the current indicator data needs to add or delete the dimension of the indicator, it is necessary to modify the code, rewrite the SQL statement, and then go back online. That is, the maintenance cost of indicator data calculation is very high and the timeliness is low. ④ When the indicator is maintained offline, the names of the indicators proposed by business personnel may be different, but the business caliber is consistent, resulting in repeated indicators, which is not conducive to verification. In addition, the indicator calculation is calculated by technicians by writing SQL statements, and it is impossible to view the calculation logic of the indicator and the blood relationship of the indicator calculation.

[0049] The standardized management method of the enterprise-level indicator system provided in the embodiment of the present application can be applied to computer devices. By completing the operation of adding dimensions and indicators based on the basic dimension information and indicator basic information input by the user, respectively, after the user completes the definition of the calculation field and the dimension field, the query statement can be automatically generated to realize the automatic acquisition of the atomic indicator. After the user completes the definition of the indicator calculation model and the target dimension, the calculation statement can be automatically generated to realize the automatic acquisition of the calculation indicator. Compared with the traditional method of manually writing SQL statements to realize indicator calculation, the automatic assembly of the corresponding query statements is realized, which reduces costs while improving development efficiency.

[0050] In an exemplary embodiment, Figure 1 As shown, a standardized management method for an enterprise-level indicator system is provided, and the method includes:

[0051] S102, based on the basic information of the dimension, complete the dimension adding operation, and bind the target data to the corresponding dimension according to the dimension type corresponding to the target data; wherein the dimension type includes a common dimension and a geographic dimension.

[0052] Among them, the basic information of the dimension can be set according to actual conditions and is not limited in the embodiments of the present application.

[0053] Specifically, the user clicks the add dimension function button in the indicator management page on the computer device, and the computer device pops up the dimension addition page. The user enters the basic dimension information in the dimension addition page, including dimension code, dimension name, dimension type, dimension description, dimension storage table, dimension field (FK), parent dimension field, dimension value name field and classification field to complete the dimension addition operation. Dimension types include common dimensions and geographic dimensions. In the process of binding target data and dimensions, the target data is bound to the dimensions of the corresponding dimension type through the dimension types corresponding to the target data.

[0054] For example, Figure 2 The flowchart of dimension creation and data binding is shown as an example. After the user completes filling in the dimension name, dimension type, and dimension description, the creation of the new dimension can be completed. The user clicks the Bind Storage Table button to bind the storage table. The dimension storage table is used to represent the storage table type (target data) selected for binding. This storage table type can be a real physical table, a view in the data source, or a result set of a SQL statement written directly on the platform. Based on the basic information of the dimension, the computer device assigns the dimension field and the dimension value name field in the dimension definition and corresponds to the above target data, that is, it can be understood as the correspondence of the columns in the data table. Based on the basic information of the dimension, the computer device assigns the parent dimension field in the dimension definition. The filtering condition is set to remove junk data and invalid data in the target data to avoid inaccurate calculation results of subsequent indicators. After all the dimension definitions are assigned, the user can click View Dimension Data on the page to view the specific dimension data; for example, if the company has a department dimension, the user clicks the View Dimension Data button to view all department information of the company, including department code, department name, superior department, etc.; after the above operations, the addition of a single dimension is completed. We can continue to manage and add other dimensions.

[0055] It should be noted that the user can also modify or delete the dimension, that is, modify and delete the information of the dimension, which is not elaborated in the embodiments of the present application.

[0056] S104, based on the basic information of the indicator, completing the operation of adding the indicator, wherein the indicator includes a calculation indicator and an atomic indicator.

[0057] Among them, the basic information of the indicator can be set according to actual conditions and is not limited in the embodiments of the present application; it should be noted that, in order to facilitate standardized management of indicators, the attributes in the basic information of the indicators corresponding to each indicator are the same, for example: the basic information of each indicator includes data on the business attributes, technical attributes and management attributes of the indicator, and the business attributes may include the indicator name, indicator directory, indicator dimension (dimensional field), business caliber (the meaning of the indicator) and data rollup (whether it is necessary to calculate the parent dimension); technical attributes may include indicator type (atomic indicator / calculation indicator), measurement type (counting, summation, etc.), data type (decimal / integer), processing frequency (daily processing, monthly processing or other), indicator unit (ten thousand, one million or other, for easy viewing), whether to deduplicate (whether the data needs to be deduplicated); management attributes may include the responsible department (the department that proposes the indicator) and the person in charge (the person who proposes the indicator); that is, for each new indicator, it is necessary to complete the filling of the business attributes, technical attributes and management attributes of the indicator, obtain the basic information of the indicator, and complete the operation of adding the indicator based on the basic information of the indicator.

[0058] Specifically, the indicator catalog is managed based on the basic information of the indicator, and new indicators are added to the corresponding indicator catalog to complete the indicator addition operation; it should be noted that atomic indicators are indicators calculated through the result set of the physical table, view or SQL statement in the data source; calculated indicators are indicators calculated through addition, subtraction, multiplication and division between atomic indicators or between atomic indicators and constants.

[0059] For example, the management of the indicator directory includes operations such as directory addition, directory modification, directory deletion, and directory sorting. The flowchart of the indicator directory management is as follows: Figure 3 As shown, adding a directory includes filling in the basic information of the directory and setting the operation and viewing permissions of the directory to complete the directory addition operation. Correspondingly, when modifying a directory, the basic information of the directory and the operation and viewing permissions of the directory are also modified to complete the directory modification operation. Directory sorting is achieved by dragging the upper and lower relationships of the directory. When confirming the deletion of the directory, a dialog box will pop up to prompt the user whether to confirm the deletion. If the user confirms, the directory deletion operation is completed.

[0060] S106, obtaining the calculated fields and dimension fields corresponding to the atomic indicators respectively, assembling query statements according to the calculated fields and dimension fields, the query statements are used to associate and bind the atomic indicators with the target data corresponding to the calculated fields based on the calculated fields, and the query statements are also used to associate and bind the atomic indicators with the dimensions corresponding to the dimension fields.

[0061] Among them, the query statement can be a SQL statement, or other statements used to associate and bind atomic indicators with target data corresponding to the calculation fields based on the calculation fields, and associate and bind atomic indicators with dimensions corresponding to the dimension fields, which is not limited in the embodiments of the present application.

[0062] Specifically, the data types of atomic indicators include sql, data tables, and data views; after confirming the data type corresponding to the current atomic indicator, the user sets the calculation fields and dimension fields corresponding to the atomic indicator respectively, and the computer device assembles query statements through the calculation fields and dimension fields to associate and bind the atomic indicator with the target data corresponding to the calculation field, and associate and bind the atomic indicator with the dimension corresponding to the dimension field.

[0063] S108, defining an indicator calculation model, and performing a validity check on the indicator calculation model, wherein the indicator calculation model corresponds to the calculation indicator, and one indicator calculation model supports a free combination of multiple atomic indicators and / or multiple calculation indicators.

[0064] Specifically, a calculation indicator refers to an indicator calculated by addition, subtraction, multiplication and division between atomic indicators and atomic indicators, between atomic indicators and constants, between calculation indicators, between calculation indicators and atomic indicators, or between calculation indicators and constants. One calculation indicator corresponds to an indicator calculation model. The indicator calculation model includes an indicator calculation formula. For example, the total amount of charging orders and the number of charging orders are both atomic indicators, and the average order amount needs to be obtained by dividing the total amount of charging orders by the number of charging orders. The average order amount is the calculation indicator. The user completes the definition of the indicator calculation model according to business needs and performs a legitimacy check on the indicator calculation model. For example, it is determined that the divisor cannot be 0. It should be noted that the method of performing a legitimacy check on the indicator calculation model can be determined according to actual conditions and is not limited in the embodiments of the present application.

[0065] S110, when the indicator calculation model passes the legality check, select the dimension common to each calculation indicator associated with the indicator calculation model as the target dimension, assemble the calculation statement according to the target dimension, the indicator calculation model, and the calculation indicator associated with the indicator calculation model, the calculation statement is used to load the indicator calculation model at a preset time interval to run, and obtain the calculation indicator corresponding to the indicator calculation model; the target dimension is used to characterize the dimension corresponding to the indicator calculation model.

[0066] Among them, the calculation statement can be a SQL statement, or other statements used to realize the operation of the loading indicator calculation model according to the preset time interval, which is not limited in the embodiment of the present application; the preset time interval can be set according to actual conditions, which is not limited in the embodiment of the present application.

[0067] Specifically, when the indicator calculation model passes the legality check, based on the user's selection operation, the target dimension is selected from the dimensions common to the calculation indicators associated with the indicator calculation model. The computer device assembles calculation statements according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model to load the indicator calculation model at a preset time interval and obtain the calculation indicators corresponding to the indicator calculation model.

[0068] In the standardized management method of the above-mentioned enterprise-level indicator system, by completing the new operations of dimensions and indicators based on the basic information of dimensions and indicators, respectively, obtaining the calculated fields and dimension fields corresponding to the atomic indicators respectively, assembling query statements according to the calculated fields and dimension fields to realize automatic acquisition of atomic indicators, and by defining the indicator calculation model, when the indicator calculation model passes the legality check, selecting the common dimension of each calculation indicator associated with the indicator calculation model as the target dimension, assembling calculation statements according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model to realize automatic acquisition of calculation indicators. Compared with the traditional method of manually writing SQL statements to realize the calculation of indicators, the automatic assembly of corresponding query statements is realized, which reduces costs and improves development efficiency.

[0069] In one embodiment, binding the target data to the dimension according to the dimension type corresponding to the target data includes:

[0070] When the dimension type corresponding to the target data is a geographic dimension, the classification field corresponding to the target data is obtained, and the target data is bound to the dimension based on the classification field, where the classification field includes a field for regional division;

[0071] When the dimension type corresponding to the target data is a common dimension, the target data is bound to the dimension.

[0072] Specifically, the dimension type of the dimension includes geographic dimension and common dimension. When the dimension type corresponding to the target data is geographic dimension, for example, the dimension type of the city dimension is geographic dimension, where the city dimension includes target data such as administrative division code, administrative division name, and superior administrative division code, and the city dimension can be set with classification fields such as South China, North China, Central China, West China, and East China, so as to bind the target data to the dimension (city dimension) based on the classification field. When the dimension type corresponding to the target data is common dimension, for example, the dimension type of the company department dimension is common dimension, where the company department dimension includes target data such as department code, department name, and superior department code, all of which are common dimensions, and the target data can be directly bound to the dimension (company department dimension).

[0073] Exemplarily, the classification field may also include a field for product category classification, such as order transactions. The classification field corresponding to the order transaction may be obtained, such as digital products, household products, etc., and the order data may be bound to the corresponding dimension according to the classification field. The order transaction may be a geographic dimension. It can be understood that the target data that can be classified and needs to be classified belongs to the geographic dimension type, and is not limited to the classification for geographic location. It should be noted that the dimension type of the dimension also includes the time dimension, such as the date dimension. The date dimension does not need to be bound to the target data, but is initialized to obtain the data corresponding to the date dimension. It can be understood that the data corresponding to the date dimension may be a timetable defined in advance in the computer device, wherein the dimension whose dimension type is the time dimension cannot be deleted.

[0074] In an embodiment of the present application, when the dimension type corresponding to the target data is a geographic dimension, the target data is bound to the corresponding dimension based on the classification field. When the dimension type corresponding to the target data is a common dimension, the target data is directly bound to the dimension to facilitate subsequent queries on the target data under the corresponding dimension, thereby improving the standardization of indicator system management.

[0075] In one embodiment, assembling a query statement according to the calculated field and the dimension field includes:

[0076] Determine the target data corresponding to the atomic indicator based on the calculation field, and obtain the dimension corresponding to the atomic indicator based on the dimension field;

[0077] Atomic indicators, target data corresponding to the atomic indicators, and dimensions corresponding to the atomic indicators are connected through calculation fields and dimension fields to assemble query statements.

[0078] Specifically, after the user confirms the data type corresponding to the current atomic indicator, because there are a large number of target data belonging to this data type and not all target data belonging to this data type need to be bound to the atomic indicator, the computer device determines the target data corresponding to the atomic indicator based on the calculation field set by the user. Similarly, the target data corresponding to the corresponding dimension is obtained, and the dimension corresponding to the atomic indicator is obtained by setting a dimension field. The atomic indicator and the target data corresponding to the atomic indicator are connected through the calculation field, and the atomic indicator and the dimension corresponding to the atomic indicator are connected through the dimension field to complete the assembly of the query statement.

[0079] In an embodiment of the present application, by determining the target data corresponding to the atomic indicator based on the calculation field, and obtaining the dimension corresponding to the atomic indicator according to the dimension field, the query statement is assembled to automatically obtain the atomic indicator, thereby reducing costs and improving development efficiency.

[0080] In one embodiment, the method further comprises:

[0081] Obtaining decoration conditions, where the decoration conditions are used to screen target data corresponding to the atomic indicator and determine the specified data;

[0082] Atomic indicators, specified data, and dimensions corresponding to atomic indicators are connected through calculated fields, dimension fields, and decorative conditions to assemble query statements.

[0083] Among them, the decoration conditions can be set according to actual conditions and are not limited in the embodiments of the present application.

[0084] Specifically, the user inputs the decoration condition, and the computer device filters the target data corresponding to the atomic indicator based on the decoration condition to obtain the specified data. For example, if only the transaction customer data of males needs to be counted, the decoration condition can be set to "customer gender = male" to obtain the corresponding specified data; the atomic indicator and the specified data corresponding to the atomic indicator are connected through the calculation field and the decoration condition, and the atomic indicator and the dimension corresponding to the atomic indicator are connected through the dimension field to complete the assembly of the query statement.

[0085] In the embodiment of the present application, atomic indicators, specified data and dimensions corresponding to atomic indicators are connected through calculation fields, dimension fields, and decoration conditions to complete the assembly of query statements and realize automatic acquisition of atomic indicators, thereby reducing costs and improving development efficiency, making calculation indicator management more efficient.

[0086] To facilitate understanding by those skilled in the art, the steps of assembling a query statement based on a calculated field and a dimension field are described below with reference to a specific example. Figure 4 As shown, the data types of atomic indicators include sql, data tables, and data views, among which data tables and data types are collectively referred to as database objects. When the data type selected for binding is sql, it can be understood that the atomic indicator is bound to the result data set generated after the sql statement is executed. In order to ensure the accuracy of the sql statement, the sql statement needs to be executed first. If this sql statement is not executable or there is no data when it is executed or the result set of the execution does not meet the binding conditions of the indicator, binding is not allowed.

[0087] After confirming the data type corresponding to the current atomic indicator, the user sets the calculation field corresponding to the atomic indicator. Taking the data type of sql as an example, the result set obtained after executing the sql statement is a two-dimensional table, so you need to select a specific column to perform the calculation; for example, the sql statement queries a transaction information table, including the following fields: transaction customer name, transaction amount, transaction date, payment method, transaction location; and the atomic indicator is the number of transaction customers, so you need to bind the calculation field of transaction customer name; if the atomic indicator is the total transaction amount, then the calculation field should select the transaction amount field.

[0088] The user continues to set the dimension field corresponding to the atomic indicator. Taking the data type of sql as an example, the transaction location and transaction method are set as dimension fields. Then, the transaction location dimension field needs to be associated with the dimension whose dimension type is the geographic dimension. In this way, the number of transaction customers in South China and the number of transaction customers in Central China can be counted according to the corresponding classification field in the geographic latitude; the payment method dimension field can be associated with the payment method (ordinary dimension) dimension to count the number of WeChat payment customers, the number of Alipay payment customers, etc.

[0089] The user sets the decoration conditions, which are used to filter the target data (sql, database objects) corresponding to the atomic indicators and determine the specified data; the computer device saves the association between the atomic indicators and the fact table (target data) to complete the fact table binding, and connects the atomic indicators, specified data and dimensions corresponding to the atomic indicators through calculated fields, dimension fields, and decoration conditions to assemble query statements.

[0090] In one embodiment, the number of target dimensions is one or more; selecting dimensions common to the calculation indicators associated with the indicator calculation model as target dimensions includes:

[0091] Business demand information is obtained, and based on the business demand information, a target dimension is determined from dimensions common to all calculation indicators associated with the indicator calculation model.

[0092] Among them, the business demand information can be set according to actual conditions and is not limited in the embodiments of the present application.

[0093] Specifically, not all combinations between dimensions are meaningful, and arbitrary combinations between dimensions will cause an explosion of dimensional data and an explosion of indicator result data, which will not only waste computing resources but also cause a surge in demand for storage space for indicator result data. By determining the target dimension from the dimensions shared by all calculation indicators associated with the indicator calculation model based on business demand information, business needs can be met without wasting computing resources, and storage space can be greatly saved.

[0094] Exemplarily, when the target dimension is single (one-dimensional), it can be expressed as the target data of a certain dimension that needs to be calculated separately, such as: the number of customers in South China, the number of customers in North China, the number of customers of Alipay, or the number of customers of WeChat; when the target dimensions are two (two-dimensional), it can be expressed as the target data of two dimensions that need to be calculated, such as: the number of WeChat payment customers in South China, the number of Alipay payment customers in South China, the number of WeChat payment customers in North China, and the number of Alipay payment customers in North China.

[0095] In an embodiment of the present application, by determining the target dimension from the common dimensions of the calculation indicators associated with the indicator calculation model based on the business demand information, the business demand is met without wasting computing resources and greatly saving storage space.

[0096] In one embodiment, assembling a calculation statement according to a target dimension, an indicator calculation model, and a calculation indicator associated with the indicator calculation model includes:

[0097] The target dimension and the indicator calculation model are connected through the calculated indicator associated with the indicator calculation model to assemble the calculation statement.

[0098] Specifically, since the calculation indicators are respectively associated with the target dimension and the indicator calculation model, the target dimension and the indicator calculation model are connected through the calculation indicators to assemble the calculation statement.

[0099] In the embodiment of the present application, the target dimension and the indicator calculation model are connected by the calculation indicator associated with the indicator calculation model, so as to complete the assembly of the calculation statement and realize the automatic acquisition of the calculation indicator, thereby reducing the cost and improving the development efficiency.

[0100] To facilitate understanding by those skilled in the art, the steps of assembling a calculation statement according to a target dimension, an indicator calculation model, and calculation indicators associated with the indicator calculation model are described below with reference to a specific example. Figure 5 As shown:

[0101] The user clicks the button for setting the calculation formula on the page to enter the calculation formula editing page. The user selects the atomic indicators that need to be calculated and defines the calculation range of the calculation indicator. The user enters the indicator calculation model and verifies its legality. When the indicator calculation model passes the legality check, the user sets the calculation dimension of the indicator, that is, selects the dimension shared by all calculation indicators associated with the indicator calculation model as the target dimension, and publishes the indicator calculation model as a job. The calculation job is executed according to the indicator calculation frequency, that is, the calculation statement is assembled according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model to finally obtain the calculation indicator.

[0102] In order to facilitate the understanding of those skilled in the art, the standardized management method of the enterprise-level indicator system is described below with reference to a specific example. Figure 6 As shown:

[0103] By modeling indicator management, the physical model attributes of indicator management include: indicator name, indicator code, indicator type, calculation type, indicator unit, indicator data type, indicator data accuracy, calculation frequency, indicator dimension, business scope, responsible department, person in charge, indicator operation authority and indicator query authority. Indicators include atomic indicators and calculated indicators; among them, atomic indicators are indicators calculated through the result set of physical tables, views or SQL statements in the data source. Calculated indicators are calculated through addition, subtraction, multiplication and division between indicators or between indicators and constants.

[0104] Then, the indicator dimensions and the indicator catalog are remodeled, and the indicator dimensions, indicator catalog, indicator basic information, and indicator authority information are uniformly managed. After the indicator information is managed, the indicator model and dimension model are associated with the data (target data) in the enterprise data warehouse to achieve the automatic generation of indicator calculation code (query statements, calculation statements), and then the code is packaged into a job through the scheduling tool to automatically execute it according to the calculation frequency of the indicator. After the execution is completed, the result data of the indicator can be viewed through the indicator in the computer device.

[0105] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0106] Based on the same inventive concept, the embodiment of the present application also provides a standardized management device for an enterprise-level indicator system for implementing the standardized management method for the enterprise-level indicator system involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in the embodiments of the standardized management device for one or more enterprise-level indicator systems provided below can refer to the limitations of the standardized management method for the enterprise-level indicator system above, and will not be repeated here.

[0107] In an exemplary embodiment, Figure 7 As shown, a standardized management device 700 for an enterprise-level indicator system is provided, and the device 700 includes:

[0108] The dimension adding module 701 is used to complete the dimension adding operation based on the dimension basic information, and bind the target data with the corresponding dimension according to the dimension type corresponding to the target data; wherein the dimension type includes a common dimension and a geographic dimension;

[0109] An indicator adding module 702 is used to complete the indicator adding operation based on the indicator basic information, wherein the indicator includes a calculation indicator and an atomic indicator;

[0110] The first statement module 703 is used to obtain the calculated fields and dimension fields corresponding to the atomic indicators respectively, and assemble a query statement according to the calculated fields and the dimension fields. The query statement is used to associate and bind the atomic indicator with the target data corresponding to the calculated field according to the calculated field, and the query statement is also used to associate and bind the atomic indicator with the dimension corresponding to the dimension field;

[0111] The second statement module 704 is used to define an indicator calculation model and perform a validity check on the indicator calculation model, wherein the indicator calculation model corresponds to the calculation indicator, and one indicator calculation model supports a free combination of multiple atomic indicators and / or multiple calculation indicators;

[0112] The second statement module 704 is also used to select the common dimension of each calculation indicator associated with the indicator calculation model as the target dimension when the indicator calculation model passes the legality check, and assemble the calculation statement according to the target dimension, the indicator calculation model, and the calculation indicator associated with the indicator calculation model. The calculation statement is used to load the indicator calculation model at a preset time interval to run and obtain the calculation indicator corresponding to the indicator calculation model; the target dimension is used to characterize the dimension corresponding to the indicator calculation model.

[0113] In one embodiment, the dimension adding module 701 is further used to obtain a classification field corresponding to the target data when the dimension type corresponding to the target data is a geographic dimension, and bind the target data to the dimension based on the classification field, wherein the classification field includes a field for regional division;

[0114] When the dimension type corresponding to the target data is a common dimension, the target data is bound to the dimension.

[0115] In one embodiment, the first statement module 703 is further used to determine the target data corresponding to the atomic indicator based on the calculation field, and to obtain the dimension corresponding to the atomic indicator according to the dimension field;

[0116] Atomic indicators, target data corresponding to the atomic indicators, and dimensions corresponding to the atomic indicators are connected through calculation fields and dimension fields to assemble query statements.

[0117] In one embodiment, the first statement module 703 is further used to obtain a decoration condition, and the decoration condition is used to screen the target data corresponding to the atomic indicator to determine the specified data;

[0118] Atomic indicators, specified data, and dimensions corresponding to atomic indicators are connected through calculated fields, dimension fields, and decorative conditions to assemble query statements.

[0119] In one embodiment, the number of target dimensions is one or more; the second statement module 704 is also used to obtain business demand information, and determine the target dimension from the dimensions shared by each calculation indicator associated with the indicator calculation model based on the business demand information.

[0120] In one embodiment, the second statement module 704 is further used to connect the target dimension and the indicator calculation model through the calculation indicator associated with the indicator calculation model to assemble the calculation statement.

[0121] Each module in the standardized management device of the above-mentioned enterprise-level indicator system can be implemented in whole or in part by software, hardware and a combination thereof. Each of the above-mentioned modules can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0122] In an exemplary embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Figure 8As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be realized through WIFI, a mobile cellular network, near field communication (Near Field Communication, NFC) or other technologies. When the computer program is executed by the processor, a standardized management method for an enterprise-level indicator system is realized. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0123] Those skilled in the art will understand that Figure 8 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0124] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the above-mentioned standardized management method of the enterprise-level indicator system when executing the computer program.

[0125] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the standardized management method of the above-mentioned enterprise-level indicator system is implemented.

[0126] In one embodiment, a computer program product is provided, including a computer program, which implements the above-mentioned standardized management method of the enterprise-level indicator system when executed by a processor.

[0127] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0128] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0129] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0130] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A standardized management method for an enterprise-level indicator system, characterized in that: The method comprises: Based on the basic information of the dimension, the operation of adding the dimension is completed, and according to the dimension type corresponding to the target data, the target data is bound to the corresponding dimension; wherein the dimension type includes a common dimension and a geographic dimension; Based on the basic information of the indicator, complete the operation of adding the indicator, wherein the indicator includes the calculation indicator and the atomic indicator; Acquire the calculated fields and dimension fields respectively corresponding to the atomic indicators, assemble a query statement according to the calculated fields and the dimension fields, the query statement is used to associate and bind the atomic indicator with the target data corresponding to the calculated fields according to the calculated fields, and the query statement is also used to associate and bind the atomic indicator with the dimension corresponding to the dimension field; Defining an indicator calculation model and performing a validity check on the indicator calculation model, wherein the indicator calculation model corresponds to the calculation indicator, and one indicator calculation model supports a free combination of multiple atomic indicators and / or multiple calculation indicators; When the indicator calculation model passes the legality check, the dimension shared by the calculation indicators associated with the indicator calculation model is selected as the target dimension, and a calculation statement is assembled according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model. The calculation statement is used to load the indicator calculation model at a preset time interval to run it, and obtain the calculation indicator corresponding to the indicator calculation model; the target dimension is used to characterize the dimension corresponding to the indicator calculation model.

2. The method according to claim 1, characterized in that Binding the target data to the dimension according to the dimension type corresponding to the target data includes: When the dimension type corresponding to the target data is the geographic dimension, obtaining a classification field corresponding to the target data, and binding the target data to the dimension based on the classification field, wherein the classification field includes a field for regional division; When the dimension type corresponding to the target data is the common dimension, the target data is bound to the dimension.

3. The method according to claim 1, characterized in that The assembling of the query statement according to the calculated field and the dimension field includes: Determining the target data corresponding to the atomic indicator based on the calculation field, and acquiring the dimension corresponding to the atomic indicator according to the dimension field; The atomic indicator, the target data corresponding to the atomic indicator, and the dimension corresponding to the atomic indicator are connected through the calculation field and the dimension field to assemble the query statement.

4. The method according to claim 3, characterized in that The method further comprises: Acquiring a decoration condition, wherein the decoration condition is used to screen the target data corresponding to the atomic indicator to determine the designated data; The atomic indicator, the specified data, and the dimension corresponding to the atomic indicator are connected through the calculation field, the dimension field, and the decoration condition to assemble the query statement.

5. The method according to claim 1, characterized in that The number of the target dimensions is one or more; the selecting the dimension common to each of the calculation indicators associated with the indicator calculation model as the target dimension includes: Business requirement information is obtained, and the target dimension is determined from the dimensions common to the calculation indicators associated with the indicator calculation model according to the business requirement information.

6. The method according to claim 1, characterized in that The assembling of a calculation statement according to the target dimension, the indicator calculation model, and the calculation indicator associated with the indicator calculation model includes: The target dimension and the indicator calculation model are connected through the calculation indicator associated with the indicator calculation model to assemble the calculation statement.

7. A standardized management device for an enterprise-level indicator system, characterized in that: The device comprises: a dimension adding module, which is used to complete the dimension adding operation based on the dimension basic information, and bind the target data with the corresponding dimension according to the dimension type corresponding to the target data; wherein the dimension type includes a common dimension and a geographic dimension; An indicator adding module is used to complete the indicator adding operation based on the indicator basic information, wherein the indicator includes calculation indicators and atomic indicators; A first statement module is used to obtain a calculated field and a dimension field respectively corresponding to the atomic indicator, and assemble a query statement according to the calculated field and the dimension field, wherein the query statement is used to associate and bind the atomic indicator with the target data corresponding to the calculated field according to the calculated field, and the query statement is also used to associate and bind the atomic indicator with the dimension corresponding to the dimension field; The second statement module is used to define an indicator calculation model and perform a legality check on the indicator calculation model, wherein the indicator calculation model corresponds to the calculation indicator, and one indicator calculation model supports a free combination of multiple atomic indicators and / or multiple calculation indicators; The second statement module is also used to select the dimension shared by all the calculation indicators associated with the indicator calculation model as the target dimension when the indicator calculation model passes the legality check, and assemble a calculation statement according to the target dimension, the indicator calculation model, and the calculation indicators associated with the indicator calculation model, wherein the calculation statement is used to load the indicator calculation model at a preset time interval to run and obtain the calculation indicator corresponding to the indicator calculation model; the target dimension is used to characterize the dimension corresponding to the indicator calculation model.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images