Index management and analysis system, method, electronic device and storage medium

Abstract

The present disclosure provides an indicator management and analysis system, method, electronic device and storage medium. The indicator management and analysis system includes a derived indicator creation module, an indicator data verification module and an indicator online review module; the derived indicator creation module is used to respond to customer needs in business scenarios, and when the corresponding indicator data is not found according to the target indicator, automatically create the target indicator as a derived indicator according to the entered atomic indicator; the indicator data verification module is used to verify the indicator data of the derived indicator; the indicator online review module is used to conduct an online review of the derived indicator in response to the indicator data verification being passed; and in response to the derived indicator online review being passed, launch the derived indicator; the different functions of different modules are integrated to realize the intelligent management of indicators and indicator data between different platforms within a travel company.

Description

Technical Field

[0001] The present disclosure relates to the field of data analysis, and in particular to an indicator management and analysis system, method, electronic device, and storage medium. Background Art

[0002] With the booming tourism industry, different departments within tourism companies need to use and analyze a large amount of data. Indicators are the result of data quantification for specific business scenarios. Indicator dictionaries are the embodiment of business data standardization. They are used to clarify indicator names, definitions, and data acquisition logic, and quickly obtain other relevant information about indicators.

[0003] In the prior art, the data model of the indicator platform is usually constructed by breaking down the indicator into atomic indicators, and combining the atomic indicators and the attribute values ​​of different dimensions one by one to construct different derived indicators, but this will result in the generation of a large number of useless derived indicators, resulting in indicator redundancy, and leading to the actual use scenario of the data out of business personnel. At the same time, many travel companies have a relatively single functional positioning of the indicator platform, which is mainly used as a management tool for the onlineization of the indicator dictionary, which leads to the inability to realize linkage and correspondence between the indicators in the indicator platform and the data of other platforms of different departments of the travel company. The common data visualization platform on the Internet is usually a BI (Business Intelligence) system, but statistics show that more than 70% of BI projects have ended in failure. The root cause is that there is no unified management of indicators. Derived indicators are usually generated by users, which makes it impossible to determine the uniqueness and standardization of indicators, and further leads to the inability to integrate different platforms within the travel company, and it is impossible to achieve intelligent management of different indicators and their corresponding indicator data through a unified system. Summary of the invention

[0004] The technical problem to be solved by the present disclosure is to overcome the defects in the prior art that the uniqueness and standardization of indicators cannot be ensured within the travel company and the intelligent management of different indicators and corresponding indicator data cannot be achieved, and an indicator management and analysis system, method, electronic device and storage medium are provided.

[0005] The present invention solves the above technical problems through the following technical solutions:

[0006] In a first aspect, an indicator management and analysis system is provided, the indicator management and analysis system comprising a derived indicator creation module, an indicator data verification module, and an indicator online review module;

[0007] The derived indicator creation module is used to respond to customer needs in business scenarios, and automatically create the target indicator as a derived indicator based on the entered atomic indicator when no corresponding indicator data is found according to the target indicator;

[0008] The indicator data verification module is used to verify the indicator data of the derived indicator;

[0009] The indicator online review module is used to perform an online review on the derived indicator in response to the indicator data verification being passed; and to launch the derived indicator online in response to the derived indicator online review being passed.

[0010] Optionally, the derived indicator creation module includes an identification generation unit and a calculation logic generation unit;

[0011] The identifier generation unit is used to automatically generate the indicator identifier of the target indicator according to the indicator identifier related fields of the target indicator; wherein the indicator identifier related fields include atomic indicator fields;

[0012] The calculation logic generation unit is used to automatically generate the calculation logic of the target indicator according to the calculation logic related fields of the target indicator;

[0013] The calculation logic generation unit is further used for analyzing the reason why the indicator data verification fails in response to the indicator data verification failing, and regenerating the calculation logic of the target indicator according to the reason;

[0014] The indicator data verification module is specifically used to verify the indicator data according to the calculation logic.

[0015] Optionally, the indicator management and analysis system further includes a push module, which is used to push the indicator viewing instruction and / or the user role generation instruction to the administrator platform for permission review in response to receiving the indicator viewing instruction and / or the user role generation instruction; wherein different user roles correspond to different permissions; and / or,

[0016] The indicator management and analysis system also includes an anomaly detection module.

[0017] The anomaly detection module is used to detect the historical distribution law of indicator data corresponding to different indicators, obtain abnormal results according to the historical distribution law, and determine abnormal indicators according to the abnormal results;

[0018] The push module is also used for, in response to detecting an abnormal indicator, pushing the abnormal indicator to an indicator follower and / or indicator maintainer related to the abnormal indicator.

[0019] Optionally, the indicator management and analysis system further includes a permission review module, and the permission review module is used to review whether the user has the permission to enter and / or modify indicators based on the user's login information.

[0020] Optionally, the indicator management and analysis system further includes an analysis module, and the analysis module is used to respond to an indicator query error and analyze the cause of the indicator query error according to a log of the indicator query error.

[0021] Optionally, the indicator management and analysis system further includes a personalized dashboard generation module, wherein the personalized dashboard generation module is used to generate different personalized dashboards in response to the user's personalized attention to different indicators; and / or,

[0022] The indicator management and analysis system also includes an intelligent assistant module, which is used to respond to the user's question instructions, call the calculation logic corresponding to the question instructions, and obtain and display the corresponding indicator data according to the calculation logic.

[0023] In a second aspect, an indicator management and analysis method is provided, the indicator management and analysis method is applied to the indicator management and analysis system as described in the first aspect, and the indicator management and analysis method comprises the following steps:

[0024] In response to customer needs in business scenarios, when no corresponding indicator data is found according to the target indicator, the target indicator is automatically created as a derived indicator according to the entered atomic indicator;

[0025] Verifying the indicator data of the derived indicator;

[0026] In response to the indicator data verification being passed, conducting an online review of the derived indicator;

[0027] In response to the derived indicator being approved for online review, the derived indicator is put online.

[0028] Optionally, the indicator management and analysis method further includes:

[0029] Automatically generate the indicator identification of the target indicator according to the indicator identification related fields of the target indicator; wherein the indicator identification related fields include atomic indicator fields;

[0030] Automatically generate the calculation logic of the target indicator according to the calculation logic related fields of the target indicator;

[0031] In response to the indicator data verification failing, analyzing the reason why the indicator data verification failed, and regenerating the calculation logic of the target indicator according to the reason;

[0032] The indicator data is verified according to the calculation logic.

[0033] Optionally, the indicator management and analysis method further includes: in response to receiving an indicator viewing instruction and / or a user role generation instruction, pushing the indicator viewing instruction and / or the user role generation instruction to an administrator platform for permission review; wherein different user roles correspond to different permissions; and / or,

[0034] Detecting the historical distribution patterns of indicator data corresponding to different indicators, obtaining abnormal results according to the historical distribution patterns, and determining abnormal indicators according to the abnormal results;

[0035] In response to detecting an abnormal indicator, the abnormal indicator is pushed to an indicator follower and / or an indicator maintainer related to the abnormal indicator.

[0036] Optionally, the indicator management and analysis method further includes: reviewing whether the user has the authority to enter and / or modify indicators based on the user's login information.

[0037] Optionally, the indicator management and analysis method further includes: in response to an indicator query error, analyzing a cause of the indicator query error according to a log of the indicator query error.

[0038] Optionally, the indicator management and analysis method further includes: generating different personalized dashboards in response to the user's personalized attention to different indicators; and / or,

[0039] The indicator management and analysis method further includes: in response to a question instruction of a user, calling a calculation logic corresponding to the question instruction, and acquiring and displaying corresponding indicator data according to the calculation logic.

[0040] In a third aspect, an electronic device is provided, comprising a memory, a processor, and a computer program stored in the memory and used to run on the processor, wherein the processor implements the indicator management and analysis method described in the second aspect when executing the computer program.

[0041] In a fourth aspect, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the indicator management and analysis method described in the second aspect is implemented.

[0042] In a fifth aspect, a computer program product is provided, comprising a computer program, wherein when the computer program is executed by a processor, the indicator management and analysis method as described in the second aspect is implemented.

[0043] On the basis of being in accordance with the common sense in the art, the above-mentioned preferred conditions can be arbitrarily combined to obtain the preferred embodiments of the present disclosure.

[0044] The positive and progressive effects of the present disclosure are as follows: the present disclosure realizes the linkage of indicators among different platforms within a travel company through the unified management of indicators, and the indicator management and analysis system includes a derived indicator creation module, an indicator data verification module and an indicator online review module; the uniqueness and standardization of indicators are determined by automatically creating derived indicators, thereby avoiding the uncertainty caused by user-defined generation of derived indicators; before the derived indicators are put online, the indicator data of the derived indicators are verified to ensure that the derived indicators correspond to accurate indicator data; under the dual guarantee of the indicator data verification and the derived indicators online review, the derived indicators are put online; thereby realizing the intelligent management of different indicators and their corresponding indicator data. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 A schematic diagram of a module of an indicator management and analysis system provided in Embodiment 1 of the present disclosure;

[0046] Figure 2 A schematic diagram of a methodology for index dictionary management provided in Example 1 of the present disclosure;

[0047] Figure 3 A schematic diagram of another module of an indicator management and analysis system provided in Embodiment 1 of the present disclosure;

[0048] Figure 4 A schematic diagram of a unit of a derived indicator creation module provided in Embodiment 1 of the present disclosure;

[0049] Figure 5 A schematic diagram of another module of an indicator management and analysis system provided in Embodiment 1 of the present disclosure;

[0050] Figure 6 An internal flow chart of a service number provided in Embodiment 1 of the present disclosure;

[0051] Figure 7 A technical architecture diagram of an indicator management and analysis system provided in Example 1 of the present disclosure;

[0052] Figure 8 A flowchart of an indicator management and analysis method provided in Example 2 of the present disclosure;

[0053] Fig. 9 A schematic diagram of the structure of an electronic device provided in Embodiment 3 of the present disclosure. DETAILED DESCRIPTION

[0054] The present disclosure is further described below by way of examples, but the present disclosure is not limited to the scope of the examples.

[0055] Prefixes such as "first" and "second" are used in the embodiments of the present disclosure only to distinguish different description objects, and have no limiting effect on the position, order, priority, quantity or content of the described objects. The use of prefixes such as ordinal numbers to distinguish description objects in the embodiments of the present disclosure does not constitute a limitation on the described objects. For the statement of the described objects, please refer to the description in the context of the claims or embodiments, and no unnecessary limitation should be constituted due to the use of such prefixes. In addition, in the description of the present embodiment, unless otherwise specified, the meaning of "plurality" is two or more.

[0056] Example 1

[0057] Figure 1 This is a module diagram of an indicator management and analysis system provided in this embodiment. The indicator management and analysis system 10 includes a derived indicator creation module 11, an indicator data verification module 12 and an indicator online review module 13.

[0058] The derived indicator creation module 11 is used to respond to customer needs in business scenarios, and when no corresponding indicator data is found according to the target indicator, automatically create the target indicator as a derived indicator according to the entered atomic indicator.

[0059] The indicator data verification module 12 is used to verify the indicator data of the derived indicator.

[0060] The indicator online review module 13 is used for conducting an online review on the derived indicator in response to the indicator data verification being passed; and for launching the derived indicator in response to the derived indicator online review being passed.

[0061] In this embodiment, the indicator linkage between different platforms within the travel company is achieved through the unified management of indicators. The uniqueness and standardization of indicators are determined by automatically creating derived indicators, avoiding the uncertainty caused by user-defined generation of derived indicators. Before the derived indicators are put online, the indicator data of the derived indicators are verified to ensure that the derived indicators correspond to accurate indicator data. Under the dual guarantee of the indicator data verification and the derived indicators being approved for online review, the derived indicators are put online. Thus, intelligent management of different indicators and their corresponding indicator data is achieved.

[0062] Specifically, by building an indicator management and analysis system to unify the indicator calculation caliber within the tourism company, we focus on the construction of indicator caliber and data model to solve the problem of confusion in indicator caliber in the enterprise. In the construction of the indicator management and analysis system, it is necessary to build an indicator dictionary. The methodological diagram of indicator dictionary management is as follows Figure 2As shown in the figure, data requirements are quantified into specific indicators according to business segments, data domains, modifier types, modifiers, business processes, atomic indicators, metrics, derived indicators, dimensions, and dimension attributes. Figure 2 The relationships shown generate summary fact tables, detail dimension fact tables, and dimension tables.

[0063] The business segment includes at least one of domestic train tickets, international train tickets, small steamers, and public. The business domain includes at least one of a transaction domain, a log domain, and a user domain. The modification type includes at least one of a statistical caliber, a time period, and an additional product. The modifier includes an additional product type; the additional product type includes at least one of an X product, a voucher package, and insurance. The business process includes at least one of ordering, payment, ticketing, cancellation, refund, and travel. The dimension includes an enumeration table and / or an association table.

[0064] For example, according to "the number of train ticket orders submitted by a certain brand APP in the last day", first, it is clear that this indicator is data belonging to the "train ticket" business segment, "transaction domain" is a collection of business abstractions of this indicator, that is, the data domain, "order" is a behavioral event that cannot be further divided in the business event, that is, the business process; "order volume" is a measurement based on the business process of placing an order, that is, a measurement; "certain brand" and "APP" are the business attribute values ​​of "brand" and "terminal type" respectively, that is, the dimension value of the dimension; "last day" is the event range of data statistics. Through disassembly, it can be converted into the entry of "train ticket order volume" and associated with the two dimensions of "brand" and "terminal type".

[0065] In the process of entering indicators, atomic indicators are first created and entered, and original indicators are generated according to the atomic indicator-related fields. The atomic indicator-related fields include data domain, business process, atomic indicator and dimension management. Figure 3 This is a module diagram of an indicator management and analysis system, including business management, metadata management and security management. Among them, business management includes business segment management module, subject domain management module and business process management module; metadata management includes indicator management module, dimension management module, statistical dimension management module and data table management module; security management includes permission review module, indicator online review module and role approval module.

[0066] Specifically, select "Data Domain" under the "Indicator Management" module in the first-level navigation bar to enter the data domain, click "New" to fill in the Chinese and English fields, description and business segment of the data domain, and submit after filling in; after the data domain is created, select "Business Process" under the "Indicator Management" module in the first-level navigation bar to enter the business process, click "New" to fill in the Chinese and English fields, description and business segment and data domain of the business process, and submit after filling in; after the business process is created, select "Atomic Indicator" under the "Indicator Management" module in the first-level navigation bar to enter the atomic indicator, click "New" to fill in the Chinese and English fields, description and business segment, data domain and business process of the atomic indicator, and submit after filling in; after the atomic indicator is created, select "Dimension Management" under the "Indicator Management" module in the first-level navigation bar to enter dimension management, click "New" to fill in the Chinese and English fields, description and business segment of the dimension, and distinguish and fill in the attribute value type (enumeration, associated dimension table), and submit after filling in.

[0067] After completing the above creation, in response to customer needs in business scenarios, when no corresponding indicator data is found according to the target indicator, the target indicator is automatically created as a derived indicator according to the entered atomic indicator.

[0068] In a specific example, during the online review process, the administrator will review the submitted indicators, including atomic indicators and derived indicators, and the indicators can only be used after passing the review. The indicator status is divided into three review states: pending review, passed, and rejected. If there is a problem with the indicator input during the review, the administrator can directly modify it and then approve it; if no problem is found, it can be directly reviewed and approved.

[0069] In an optional embodiment, Figure 4 A unit schematic diagram of a derived indicator creation module provided in this embodiment, the derived indicator creation module 11 includes an identification generation unit 111 and a calculation logic generation unit 112.

[0070] The identifier generating unit 111 is used to automatically generate the indicator identifier of the target indicator according to the indicator identifier related fields of the target indicator; wherein the indicator identifier related fields include atomic indicator fields.

[0071] In this embodiment, the indicator identification related fields of the target indicator also include the Chinese name of the target indicator, the indicator type and at least one of the modifiers. The atomic indicator field includes at least one of the business sector, data domain, business process and atomic indicator to which the target indicator belongs. The identification generation unit automatically generates an indicator identification according to the indicator identification related fields, for example, automatically splicing and generating an indicator English field according to the indicator identification related fields, thereby ensuring the uniqueness and standardization of the target indicator.

[0072] The calculation logic generation unit 112 is used to automatically generate the calculation logic of the target indicator according to the calculation logic related fields of the target indicator.

[0073] In this embodiment, the calculation logic related fields of the target indicator include at least one of the following: the dimension associated with the target indicator, whether the target indicator can be accumulated, the indicator classification, the unit of measurement, the display format, the indicator definition, the calculation function, and whether to calculate the same period last year. The calculation logic of the target indicator is automatically generated according to the calculation logic related fields, such as automatically splicing and generating the SQL calculation logic of the target indicator, to ensure the standardization of indicator creation.

[0074] Furthermore, in actual use, users do not need to write SQL calculation logic, but can directly call the generated SQL calculation logic to complete flexible self-service query and analysis needs, thereby opening up the entire link from indicator caliber viewing to self-service data retrieval, to self-service analysis, and finally to the intelligent assistant.

[0075] For approved indicators, users can enter keywords such as indicator level, indicator type, indicator name, indicator ID, indicator maintainer, etc. to generate indicator viewing instructions for indicator query to view basic information of the indicator, such as the definition, level, SQL calculation logic, whether to calculate the same period last year, maintainer, modification records, etc. In addition, users can understand the business process and indicator relationship of the indicator by clicking on the indicator map to view the page and clicking on different business sections to generate different instructions.

[0076] The calculation logic generation unit 112 is also used to analyze the reason why the indicator data verification fails in response to the indicator data verification failing, and regenerate the calculation logic of the target indicator according to the reason. The indicator data verification module 12 is specifically used to verify the indicator data according to the calculation logic.

[0077] In this embodiment, if the corresponding indicator data cannot be obtained according to the automatically generated calculation logic or the obtained indicator data is erroneous, the user can modify the above calculation logic by himself to generate a new calculation logic until the indicator data obtained under the calculation logic passes the verification.

[0078] In an optional embodiment, Figure 5 As shown, the indicator management and analysis system 10 also includes a push module 14, which is used to push the indicator viewing instruction and / or user role generation instruction to the administrator platform for permission review in response to receiving the indicator viewing instruction and / or user role generation instruction; wherein different user roles correspond to different permissions.

[0079] In this embodiment, usually in the process of creating an indicator, the user will select the role of "operator" to create and enter the indicator. The user can also generate an indicator viewing instruction by at least one of the Chinese name of the indicator to be viewed, the indicator ID, and the English name of the indicator to view, so as to view at least one of the definition, version iteration, calculation logic, level, and indicator maintainer of the indicator to be viewed. Among them, the push module will push the indicator viewing instruction to the administrator platform so that the administrator can review whether the current user has the authority to view the indicator. Only after passing the administrator's review can the user view the relevant information of the indicator to be viewed according to the indicator viewing instruction.

[0080] The indicator management and analysis system also includes an anomaly detection module 15, which is used to detect the historical distribution law of indicator data corresponding to different indicators, obtain abnormal results according to the historical distribution law, and determine abnormal indicators according to the abnormal results. The push module is also used to push the abnormal indicator to the indicator attention person and / or indicator maintainer related to the abnormal indicator in response to detecting the abnormal indicator.

[0081] In this embodiment, the indicator management and analysis system currently covers hundreds of business indicators, and the number of indicators is gradually increasing. At the same time, manual monitoring of abnormal conditions of indicators is time-consuming and laborious. AI algorithms are used to replace manual work and fully automatically monitor indicators, aiming to help data maintenance personnel and business parties discover problems and dig out the causes of problems as early as possible.

[0082] In a specific example, the anomaly detection module uses a variety of unsupervised detection algorithms to calculate anomaly scores based on the historical distribution patterns of indicator data within the indicator management and analysis system. Specifically, the anomaly threshold is calculated based on the time series characteristics and the business characteristics of the indicator; the anomaly results of multiple algorithms are integrated for hard voting to obtain anomaly results and achieve real-time monitoring; in addition, different voting rules are set according to the importance of the indicator to weigh the precision recall rate; further, the anomaly results are output in descending order according to the number of votes, and the detected abnormal indicators are pushed to the indicator followers and / or indicator maintainers based on the anomaly results. After receiving the anomaly notification message, the indicator followers and / or indicator maintainers can directly click to enter the anomaly detection module in the indicator management and analysis system to determine the abnormal data. In addition, the anomaly detection module also supports jumping to the indicator result display page to perform attribution analysis of abnormal data.

[0083] In an optional embodiment, Figure 5 As shown, the indicator management and analysis system further includes a permission review module 16, which is used to review whether the user has the permission to enter and / or modify indicators based on the user's login information.

[0084] In an optional embodiment, Figure 5 As shown, the indicator management and analysis system further includes an analysis module 17, which is used to respond to an indicator query error and analyze the cause of the indicator query error according to a log of the indicator query error.

[0085] In an optional embodiment, Figure 5 As shown, the indicator management and analysis system 10 further includes a personalized dashboard generation module 18, and the personalized dashboard generation module 18 is used to generate different personalized dashboards in response to the user's personalized attention to different indicators.

[0086] In this embodiment, users, i.e. business personnel, can query the indicators they want to view on the indicator caliber query page, and click on the favorites one by one; if you want to view a personalized dashboard, click My Favorites to generate a personalized dashboard. Furthermore, the personalized dashboard contains visual graphics of four parts: indicator card, trend chart, pie chart and table. Specifically, the indicator card displays the summary of the past 14 days and the year-on-year data by default, and uses a bar chart to display it by day, so that you can view the summary and year-on-year data; the trend chart shows the change trend of the past 14 days; the pie chart shows the proportion of enumeration values ​​of different dimensions; the table shows the specific detailed numbers for users to filter, sort and download. Furthermore, for the result display page, considering the data security issue, the indicator management and analysis system adds a watermark to the display page of the indicator results, and adds operation monitoring to all download interfaces to ensure that the data is not leaked and the link is traceable.

[0087] In an optional embodiment, Figure 5 As shown, the indicator management and analysis system 10 also includes an intelligent assistant module 19, which is used to respond to the user's question instructions, call the calculation logic corresponding to the question instructions, and obtain and display the corresponding indicator data according to the calculation logic.

[0088] In this embodiment, the index management and analysis system is combined with the service account within the travel company. The internal process of the service account is as follows: Figure 6 As shown, specifically, the service number is used for display and interactive logic design, the service number can be a public number, and the internal process includes the following steps:

[0089] Step 1, monitor and / or subscribe to the QMQ (Qunar MessageQueue, message middleware) of the service number of the indicator management and analysis system;

[0090] Step 2: Call the AI ​​parsing interface to parse the query words, i.e., question instructions, entered by the user, and parse the query words into corresponding indicators, dimensions, dimension values, and query time ranges;

[0091] Step 3: Return the parsing result to the train ticket BU (Business Unit) main service, and then map the indicators into Chinese and English based on the parsing result;

[0092] Step 4: Call the data query interface to obtain the data query result of this query;

[0093] Step 5: Return the data query results to the train ticket BU main service;

[0094] Step 6. The main service of the train ticket BU sends QMQ to the service number for result display and interaction, thereby realizing the data result display of the query script, opening up the entire link from caliber viewing to self-service data retrieval, to self-service analysis, and finally to the intelligent assistant, meeting the business party's requirements for intelligent viewing and analysis of indicators, improving data efficiency, and releasing the potential of multiple parties; using the indicator management and analysis system at any time with zero threshold to query indicators and indicator data, strengthen collaboration, and release organizational potential.

[0095] In an optional embodiment, the indicator management and analysis system also includes a query module, which includes an indicator caliber query unit, an indicator map viewing unit, and an indicator result query unit. Users can initiate indicator query requests by selecting different search items and entering keywords to search for indicators in the database. For the searched indicators, the definition and description of the indicator, the indicator level, the business to which the indicator belongs, the indicator version, the calculation logic, and the maintainer will be returned; for business personnel, i.e. users, to view and use, to help business personnel understand and master the basic information of the indicator, and ensure the consistency and uniqueness of the indicator. At the same time, business personnel can clearly see the business process to which the indicator belongs and the atomic indicators and derived indicators related to it in the displayed map, which is convenient for business personnel to understand the business ecology and grasp the indicator blood relationship more quickly.

[0096] Furthermore, business personnel can select the required indicators by switching businesses. The system will log in according to the user information, initiate an authentication request, query the database, and return the indicators with viewing permissions to the user for selection. When the business personnel clicks on the required indicator, the system will query the database for the dimensions and related enumeration values ​​associated with the indicator according to the request initiated by the page, and finally display the dimensions and enumeration values ​​together on the page. After selecting the indicators and dimensions, the business personnel can initiate a query. The present invention will calculate the indicator data for the past 14 days by default, and finally visualize the data results using indicator cards, trend charts, pie charts and tables, respectively, to achieve self-service calculation of indicators:

[0097] First, the indicator card displays the summary data and daily bar charts within the selected time range. At the same time, for indicators that need to calculate year-on-year and month-on-month changes, the year-on-year comparison is displayed.

[0098] Second, the disclosure also supports switching of time range and time aggregation granularity: by switching days, weeks, months, years and special holidays (Spring Festival, Qingming Festival, Dragon Boat Festival, May Day, National Day, Mid-Autumn Festival, New Year's Day, etc.), self-service calculation of indicator results of different dimensions and time ranges is initiated;

[0099] Third, business personnel can not only select a single indicator and a single dimension, but also select multiple indicators and multiple dimensions to initiate queries at the same time. For the calculated results, by clicking different indicator cards, the data and display of trend charts and pie charts can be linked;

[0100] Fourth, the present disclosure can also save and sort the user's historical queries, and name a query as "Query 1", "Query 2", "Query 3". Similarly, business personnel can switch to different pages to click again to view historical query records, reducing the steps of user self-service queries and improving efficiency;

[0101] Fifth, for the calculated indicator results, business personnel can roll up and drill down the dimensions by selecting the dimensions associated with the indicator, and view the trend chart of the indicator under each dimension and the proportion of different dimension values ​​respectively, which helps business personnel perform multi-dimensional analysis of data, data drilling and data filtering, and further realize self-service analysis functions.

[0102] In the specific implementation, in order to improve the query efficiency, the indicator management and analysis system is based on a distributed database with fast query speed and simple use to reconstruct the OLAP (On-Line Analytical Processing) architecture of the indicator management and analysis system - StarRocks, a full-scenario MPP database, has the advantages of powerful performance, simple use, high concurrency, materialized views, support for multiple data models and support for multiple import methods, which greatly improves the query performance and query speed.

[0103] At the same time, a cache mechanism is introduced: record the last indicator query information. Specifically, it includes at least one of the indicator name, dimension, dimension value, time range, MD5 value of the original calculation SQL of the indicator, and whether the query is successful. Furthermore, when a new query comes in, it will check whether there is the same query in the records of the day; if there is the same query, then use the unique query identifier-groupkey to point the current query to the query that has been executed last time. In this way, the detailed data and summary results of the last query can be read directly, thereby improving query efficiency. Therefore, the cache here is not a cache in the true sense, but a direct call to the result of the same query to reduce the waiting time of the user.

[0104] In an optional embodiment, Figure 7This is a technical architecture diagram of an indicator management and analysis system. The technical architecture of the indicator management and analysis system includes a data access layer, a service layer, a presentation layer, and application scenarios. The indicator management and analysis system calls the interface of the service layer through the presentation layer to obtain the data of the data access layer, and then displays the application scenario through the AntDesign UI component of the presentation layer. Among them, the application scenarios include indicator dictionary management, self-service analysis and personalized dashboards, real-time risk control, anomaly detection and root cause analysis, and intelligent assistants. The presentation layer includes the React front-end framework, AntDesignCharts data visualization, and Ant Design UI components. The service layer is built based on the Express framework (an interface framework), including Http restful service interface and different interfaces such as user management, permission management, metadata configuration, single indicator and multi-indicator result calculation, dimension drilling, holidays, and year-on-year comparison. The data layer is used to generate specific query SQL statements and execute query commands according to the called service layer interface; the data layer is also used for log caching and error reporting; the data layer includes DWD (Detail layer of Data Warehouse Detail database), DWS (Data Warehouse Service, data warehouse service), DIM (Dimension Layer, dimension layer of database) and Hive (a data warehouse tool). In addition, the indicator management and analysis system realizes data transmission through the OLAP interface and also has the Clogging alarm monitoring function.

[0105] Example 2

[0106] Corresponding to the aforementioned indicator management and analysis system embodiment 1, the present disclosure also provides an embodiment of an indicator management and analysis method.

[0107] Figure 8 This is a flowchart of an indicator management and analysis method provided in this embodiment. The indicator management and analysis method is applied to the indicator management and analysis system as described in Example 1. The indicator management and analysis method includes the following steps:

[0108] S21. In response to customer needs in a business scenario, when no corresponding indicator data is found according to the target indicator, the target indicator is automatically created as a derived indicator according to the entered atomic indicator.

[0109] S22: Verify the indicator data of the derived indicator.

[0110] S23: In response to the indicator data being verified, an online review is performed on the derived indicator.

[0111] S24. In response to the derived indicator being approved for online review, the derived indicator is put online.

[0112] As for the method embodiment, since it basically corresponds to the system embodiment, the relevant parts may refer to the partial description of the system embodiment.

[0113] Example 3

[0114] Fig. 9 This is a schematic diagram of the structure of an electronic device shown in this embodiment. The electronic device includes a memory, a processor, and a computer program stored in the memory and used to run on the processor. When the processor executes the computer program, the indicator management and analysis method described in the above embodiment 2 is implemented. Fig. 9 The electronic device 30 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0115] like Fig. 9 As shown, the electronic device 30 may be in the form of a general-purpose computing device, for example, it may be a server device. The components of the electronic device 30 may include, but are not limited to: at least one processor 31, at least one memory 32, and a bus 33 connecting different system components (including the memory 32 and the processor 31).

[0116] The bus 33 includes a data bus, an address bus, and a control bus.

[0117] The memory 32 may include a volatile memory, such as a random access memory (RAM) 321 and / or a cache memory 322 , and may further include a read-only memory (ROM) 323 .

[0118] The memory 32 may also include a program tool 325 (or utility) having a set (at least one) of program modules 324, such program modules 324 including but not limited to: an operating system, one or more application programs, other program modules and program data, each of which or some combination may include an implementation of a network environment.

[0119] The processor 31 executes various functional applications and data processing by running the computer programs stored in the memory 32, such as the indicator management and analysis method provided in the above-mentioned embodiment 2.

[0120] The electronic device 30 may also communicate with one or more external devices 34 (e.g., keyboards, pointing devices, etc.). Such communication may be performed via an input / output (I / O) interface 35. Furthermore, the electronic device 30 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 36. As shown, the network adapter 36 communicates with other modules of the electronic device 30 via a bus 33. It should be understood that although Fig. 9Not shown, other hardware and / or software modules may be used in conjunction with the electronic device 30, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems.

[0121] It should be noted that although several units / modules or sub-units / modules of the electronic device are mentioned in the above detailed description, this division is merely exemplary and not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more units / modules described above can be embodied in one unit / module. Conversely, the features and functions of one unit / module described above can be further divided into multiple units / modules to be embodied.

[0122] Example 4

[0123] The embodiment of the present disclosure also provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the indicator management and analysis method provided in the above embodiment 2 is implemented.

[0124] The readable storage medium may include but is not limited to: a portable disk, a hard disk, a random access memory, a read-only memory, an erasable programmable read-only memory, an optical storage device, a magnetic storage device or any suitable combination of the above.

[0125] Example 5

[0126] The present disclosure also provides a computer program product, including a computer program, which implements the indicator management and analysis method described in the above embodiment 2 when executed by a processor.

[0127] Among them, the program code for executing the computer program product of the present disclosure can be written in any combination of one or more programming languages, and the program code can be executed completely on the user device, partially on the user device, as an independent software package, partially on the user device and partially on a remote device, or completely on the remote device.

[0128] Although the specific embodiments of the present disclosure are described above, those skilled in the art should understand that this is only an example, and the protection scope of the present disclosure is defined by the appended claims. Those skilled in the art may make various changes or modifications to these embodiments without departing from the principles and essence of the present disclosure, but these changes and modifications all fall within the protection scope of the present disclosure.

Claims

1. An indicator management and analysis system, characterized in that: The indicator management and analysis system includes a derived indicator creation module, an indicator data verification module, and an indicator online review module; The derived indicator creation module is used to respond to customer needs in business scenarios, and automatically create the target indicator as a derived indicator based on the entered atomic indicator when no corresponding indicator data is found according to the target indicator; The indicator data verification module is used to verify the indicator data of the derived indicator; The indicator online review module is used for conducting an online review of the derived indicator in response to the indicator data verification being passed; and for launching the derived indicator online in response to the derived indicator online review being passed.

2. The index management and analysis system according to claim 1, characterized in that: The derived indicator creation module includes an identification generation unit and a calculation logic generation unit; The identifier generation unit is used to automatically generate the indicator identifier of the target indicator according to the indicator identifier related fields of the target indicator; wherein the indicator identifier related fields include atomic indicator fields; The calculation logic generation unit is used to automatically generate the calculation logic of the target indicator according to the calculation logic related fields of the target indicator; The calculation logic generation unit is further used for analyzing the reason why the indicator data verification fails in response to the indicator data verification failing, and regenerating the calculation logic of the target indicator according to the reason; The indicator data verification module is specifically used to verify the indicator data according to the calculation logic.

3. The index management and analysis system according to claim 1, characterized in that: The indicator management and analysis system further includes a push module, which is used to push the indicator viewing instruction and / or the user role generation instruction to the administrator platform for permission review in response to receiving the indicator viewing instruction and / or the user role generation instruction; wherein different user roles correspond to different permissions; and / or, The indicator management and analysis system also includes an anomaly detection module. The anomaly detection module is used to detect the historical distribution law of indicator data corresponding to different indicators, obtain abnormal results according to the historical distribution law, and determine abnormal indicators according to the abnormal results; The push module is also used for, in response to detecting an abnormal indicator, pushing the abnormal indicator to an indicator follower and / or indicator maintainer related to the abnormal indicator.

4. The index management and analysis system according to claim 1, characterized in that: The indicator management and analysis system further includes a permission review module, which is used to review whether the user has the permission to enter and / or modify indicators based on the user's login information.

5. The index management and analysis system according to claim 1, characterized in that: The indicator management and analysis system also includes an analysis module, which is used to respond to an indicator query error and analyze the cause of the indicator query error according to a log of the indicator query error.

6. The index management and analysis system according to claim 1, characterized in that: The indicator management and analysis system further includes a personalized dashboard generation module, wherein the personalized dashboard generation module is used to generate different personalized dashboards in response to the user's personalized attention to different indicators; and / or, The indicator management and analysis system also includes an intelligent assistant module, which is used to respond to the user's question instructions, call the calculation logic corresponding to the question instructions, and obtain and display the corresponding indicator data according to the calculation logic.

7. An indicator management and analysis method, characterized in that: The index management and analysis method is applied to the index management and analysis system according to any one of claims 1 to 6, and the index management and analysis method comprises the following steps: In response to customer needs in business scenarios, when no corresponding indicator data is found according to the target indicator, the target indicator is automatically created as a derived indicator according to the entered atomic indicator; Verifying the indicator data of the derived indicator; In response to the indicator data verification being passed, the derived indicator is subject to online review; and in response to the derived indicator online review being passed, the derived indicator is put online.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and used to run on the processor, characterized in that: When the processor executes the computer program, the indicator management and analysis method according to claim 7 is 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 indicator management and analysis method according to claim 7 is implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the indicator management and analysis method according to claim 7 is implemented.

Images