Data warehouse index-based subscription processing method and apparatus, intelligent device

Abstract

The application discloses a data warehouse index-based subscription processing method and device and an intelligent device, and relates to the technical field of data warehouse index subscription processing.The method comprises the following steps: obtaining an index name and an index parameter item corresponding to the index name from a preset index library; obtaining an index selection instruction of a user; determining an index item with a check mark in the index list as a subscription index according to the obtained index selection instruction of the user in the index list, and determining a subscription relationship; when an index viewing instruction is detected, obtaining a data set corresponding to the subscription index, and displaying the data set corresponding to the index name and the index parameter item corresponding to the index name; and when it is detected that the index data of the subscription index is changed, reminding the user of the change of the index data.The application can realize the data warehouse index subscription function, the index display is simple, and the viewer can better control the dynamic of the key index, thereby providing convenience for the user.

Description

Technical Field

[0001] This invention relates to the field of database technology, and in particular to a subscription processing method, apparatus, and intelligent device based on data warehouse metrics. Background Technology

[0002] With the development of big data and the continuous improvement of the technological level of various smart devices, the use of big data is becoming more and more widespread.

[0003] In today's big data companies, data metrics in data warehouses are very common, with several metrics needing to be output almost every week. However, as the number of metrics increases, many companies default to only adding and never removing them, leading to a complex mix of metrics. This makes it difficult for viewers to grasp the dynamics of key metrics, and makes it impossible to subscribe to data warehouse metrics according to user needs. In fact, the data warehouse metric subscription function is basically impossible to implement, making it inconvenient for users.

[0004] Therefore, existing technologies still need to be improved and enhanced. Summary of the Invention

[0005] The technical problem to be solved by the present invention is to provide a subscription processing method, apparatus, and smart device based on data warehouse indicators, in order to address the above-mentioned deficiencies of the prior art. This solves the technical problem that the prior art cannot realize the subscription of data warehouse indicators according to user needs, and is basically unable to realize the data warehouse indicator subscription function, which is inconvenient for users.

[0006] To address the aforementioned technical problems, the first aspect of this invention provides a subscription processing method based on data warehouse metrics, the method comprising:

[0007] Upon detecting a login command, the system retrieves the indicator name and the corresponding indicator parameter items from the preset indicator library and displays them as an indicator list.

[0008] Obtain the user's indicator selection instruction; based on the obtained user's selection instruction in the indicator list, determine the indicator items marked with the checkmark in the indicator list as subscription indicators, and determine the subscription relationship.

[0009] When a metric viewing command is detected, the dataset corresponding to the subscribed metric is retrieved, and the corresponding metric parameter items are displayed according to the metric name.

[0010] The system monitors in real time whether there are any changes to the subscription metrics data. When changes are detected, a notification is sent to alert users of the changes.

[0011] The subscription processing method based on data warehouse metrics, wherein, before the steps of detecting a login command, retrieving the metric name and the corresponding metric parameter items from a preset metric library, and displaying them as a metric list, includes:

[0012] The system pre-sets the names of multiple data warehouse metrics that can be selectively subscribed to, as well as the corresponding metric parameter items. The metric parameter items include: metric ID, metric level, metric category, metric affiliation, and indicator explanation.

[0013] The subscription processing method based on data warehouse metrics, wherein, before the steps of detecting a login command, retrieving the metric name and the corresponding metric parameter items from a preset metric library, and displaying them as a metric list, further includes:

[0014] Based on the preset indicator names and the corresponding indicator parameter items, a corresponding indicator library is generated according to the preset indicator tree.

[0015] The subscription processing method based on data warehouse metrics, wherein the steps of detecting a login command, retrieving the metric name and the corresponding metric parameter items from a preset metric library, and displaying them as a metric list include:

[0016] Obtain and verify the user's login account;

[0017] If the verification is successful, it is determined that a login command has been detected and the system has logged in; the system then retrieves the indicator name and the corresponding indicator parameter items from the preset indicator library and displays them as an indicator list for users to select the desired indicator items as subscription indicators.

[0018] The subscription processing method based on data warehouse metrics, wherein the steps of obtaining the user's metric selection instruction, determining the metric items marked with a checkmark in the metric list as subscription metrics based on the obtained user's selection instruction in the metric list, and determining the subscription relationship include:

[0019] Obtain the user's metric selection instructions.

[0020] According to the indicator selection instructions, check the indicators in the displayed indicator list, and determine the indicator items with check marks in the indicator list as subscription indicators based on the user's selection instructions in the indicator list.

[0021] The subscription relationship between users and metrics is determined based on the subscription metrics and stored in the subscription relationship table; wherein, the subscription relationship is used to determine the relationship between metrics and subscribers, and the subscription relationship table is used to interpret the list of corresponding relationships between users and metrics during the subscription process.

[0022] The subscription processing method based on data warehouse metrics, wherein the steps of obtaining the dataset corresponding to the subscribed metric when a metric viewing command is detected, and displaying the dataset according to the metric name and the corresponding metric parameter items, include:

[0023] When a query to view metrics is received, the dataset corresponding to each subscribed metric is retrieved. The dataset is then displayed according to the metric name and the corresponding metric parameter items, using different states that distinguish it from unsubscribed metrics.

[0024] The subscription processing method based on data warehouse metrics, wherein the step of real-time detection of whether the metric data of the subscribed metrics has been modified, and issuing a notification of the metric data modification when modification is detected, includes:

[0025] Real-time detection of any changes to the data of the subscribed metrics, including updates and modifications to each metric;

[0026] When an update and / or modification operation is detected in the metric data of the subscribed metric, a notification of the metric data change is sent.

[0027] A subscription processing apparatus based on data warehouse metrics, wherein the apparatus includes:

[0028] The pre-setting module is used to pre-set the indicator names and corresponding indicator parameter items of multiple selectable data warehouse indicators. The indicator parameter items include: indicator ID, indicator level, indicator category, indicator affiliation, and indicator explanation. Based on the preset indicator names and corresponding indicator parameter items, the module generates a corresponding indicator library according to the preset indicator tree.

[0029] The indicator list display module is used to detect login commands, retrieve indicator names and corresponding indicator parameter items from a preset indicator library, and display them as an indicator list.

[0030] The subscription metric selection module is used to obtain the user's metric selection instruction, determine the metric items marked with a check mark in the metric list as subscription metrics based on the obtained user's selection instruction in the metric list, and determine the subscription relationship.

[0031] The subscription indicator display control module is used to obtain the dataset corresponding to the subscribed indicator when an indicator viewing command is detected, and to display the corresponding data according to the indicator name and the indicator parameter items to which the indicator name belongs.

[0032] The modification notification module is used to detect in real time whether there are any changes to the indicator data of the subscribed indicator. When changes are detected, a notification is sent to remind users of the changes.

[0033] A smart device includes a memory and one or more programs, wherein one or more programs are stored in the memory and configured to be executed by one or more processors, the one or more programs comprising the method for performing any one of the methods.

[0034] A non-transitory computer-readable storage medium, wherein, when instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to perform any of the methods described above.

[0035] Beneficial Effects: Compared with existing technologies, this invention provides a subscription processing method based on data warehouse metrics. This invention enables users to subscribe to data warehouse metrics according to their needs, realizing a data warehouse metric subscription function. Users can freely subscribe to the metrics they need. Subscribed metrics are not only displayed on a fixed entry page, but any changes to the metrics are also sent to the user via email. This allows users to focus on the metrics they need without paying attention to those irrelevant metrics, receiving information through both the page and email. This invention allows users to select data warehouse metrics as needed, and the metric display is simple, making it easier for viewers to monitor the dynamics of key metrics and providing convenience for users. Attached Figure Description

[0036] Figure 1 This is a schematic diagram of the indicator tree for the subscription processing method based on data warehouse indicators provided in an embodiment of the present invention.

[0037] Figure 2 This is a flowchart illustrating a specific implementation of the subscription processing method based on data warehouse metrics provided in this invention.

[0038] Figure 3 This is a timing diagram of the subscription processing method based on data warehouse metrics provided in an embodiment of the present invention.

[0039] Figure 4 This is a schematic diagram of the indicator list for the subscription processing method based on data warehouse indicators provided in an embodiment of the present invention.

[0040] Figure 5 This is a schematic diagram of the indicator system generation process of the subscription processing method based on data warehouse indicators provided in the embodiments of the present invention.

[0041] Figure 6 This is a schematic diagram illustrating the state differences between subscribed and unsubscribed indicator items in the data warehouse indicator subscription processing method provided in this embodiment of the invention.

[0042] Figure 7This is a schematic diagram illustrating the specific metrics of the subscription processing method based on data warehouse metrics provided in this embodiment of the invention.

[0043] Figure 8 This is a schematic diagram illustrating the subscribed metric item in the subscription processing method based on data warehouse metrics provided in this embodiment of the invention.

[0044] Figure 9 This is a schematic diagram of a subscription processing device based on data warehouse metrics provided in an embodiment of the present invention.

[0045] Figure 10 This is a schematic diagram of the intelligent device provided in the embodiment of the present invention. Detailed Implementation

[0046] To make the objectives, technical solutions, and effects of this invention clearer and more explicit, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

[0047] In today's big data companies, data metrics in data warehouses are very common, with several metrics needing to be output almost every week. However, as the number of metrics increases, many companies default to only adding and never removing them, leading to a complex mix of metrics. This makes it difficult for viewers to grasp the dynamics of key metrics, and makes it impossible to subscribe to data warehouse metrics according to user needs. In fact, the data warehouse metric subscription function is basically impossible to implement, making it inconvenient for users.

[0048] To address the problems of existing technologies, this embodiment provides a subscription processing method based on data warehouse metrics.

[0049] Exemplary methods

[0050] The method in this embodiment can be applied to smart devices. In specific implementation, such as... Figure 2 As shown in the figure, the subscription processing method based on data warehouse metrics provided by this embodiment of the invention specifically includes the following steps:

[0051] Step S100: Detecting a login command, obtaining the indicator name and the corresponding indicator parameter item from the preset indicator library, and displaying them as an indicator list;

[0052] In this embodiment of the invention, before implementation, the names of multiple selectable subscribed data warehouse metrics and the corresponding metric parameter items need to be pre-set. These metric parameter items include: metric ID, metric level, metric category, metric affiliation, and explanation. When setting the names of the multiple selectable subscribed data warehouse metrics and the corresponding metric parameter items, this invention can refer to... Figure 1As shown, according to the preset... Figure 1 The indicator tree generates a corresponding indicator library. For example... Figure 1 As shown, the basic structure of most company indicator systems includes: a first-level directory (departments or business lines A, B, C, ...), a second-level directory (categorized and summarized indicators, such as revenue indicators, terminal indicators, account indicators, etc.), and a third-level directory (specific indicator names, such as: geographic distribution records, monthly new paying user accounts, monthly retained paying users, etc.). Figure 4 This is a list of indicators in the indicator system. For example... Figure 7 Specific indicators are displayed.

[0053] In this embodiment of the invention, step S100 is specifically implemented as follows: Figure 3 As shown, when a user logs into the metrics system, the system obtains and verifies the user's login account. Upon successful verification, it is determined that a login command has been detected. Further, the system retrieves the metric name and its corresponding metric parameter from a pre-defined metric library and displays them as shown below. Figure 4 A list of metrics is provided for selecting desired metrics as subscription metrics, as described above. Figure 4 The indicator list includes: serial number, indicator name, indicator ID, indicator level, indicator category, indicator affiliation, indicator explanation, status, indicator details, and indicator query. Specific indicator displays are as follows: Figure 7 As shown.

[0054] Specifically, the generation process of the indicator system is as follows: Figure 5 As shown, in a specific implementation of the present invention, multiple data warehouse indicators that can be selected for subscription can be pre-set according to each product indicator, along with the indicator parameter items corresponding to the indicator names. This forms an indicator definition output to the analysis function. After the analysis function analyzes the indicators, it matches them with the product through indicator caliber output. The indicators that match the product are then classified and archived in the R&D function. The R&D function generates an indicator system by performing indicator calculations on the indicators and displays the indicators.

[0055] like Figure 2 As shown, the method further includes the following steps:

[0056] Step S200: Obtain the user's indicator selection instruction; based on the obtained user's selection instruction in the indicator list, determine the indicator items marked with the checkmark in the indicator list as subscription indicators, and determine the subscription relationship.

[0057] In specific implementation, refer to Figure 3 As shown, the user can view the present invention as follows. Figure 4 After viewing the list of indicators, click the subscribe button corresponding to the indicator you want to subscribe to. Figure 4The checkbox on the left allows you to select the subscription button. The subscription function, after receiving the user's metric selection instruction, will then display the corresponding information in the shown menu. Figure 4 The indicator list is checked and marked, and according to the user's selection instruction in the indicator list, the indicator items with the check mark in the indicator list are determined as subscription indicators. Further, the subscription relationship between the user and the indicator is determined according to the subscription indicator, and a subscription relationship table as shown in Table 1 is generated.

[0058] Table 1

[0059]

[0060]

[0061] The subscription relationship table shown in Table 1 is used to determine the relationship between metrics and subscribers. The subscription relationship table shown in Table 1 is used to explain the correspondence between users and metrics during the subscription process. The subscription relationship table specifically includes serial number, metric name, metric number, subscriber, subscription time, and subscription email.

[0062] Step S300: When a metric viewing command is detected, obtain the dataset corresponding to the subscribed metric, and display it according to the metric name and the metric parameter items corresponding to the metric name.

[0063] In a specific implementation of this invention, when a user issues a command to view the indicator library, the indicator system detects the command, retrieves the user's subscribed indicators according to the subscription relationship table as shown in Table 1, further retrieves the datasets corresponding to each subscribed indicator in the indicator library, and displays them according to the indicator name and the corresponding indicator parameter items, using different states that distinguish them from unsubscribed indicators. Figure 6 As shown, the heart-shaped marker 01 corresponding to the subscribed metric is solid, while the heart-shaped marker 02 corresponding to the other unsubscribed metric is hollow. For example, if the metric subscribed to by the subscriber is "Daily Active Devices", then the heart-shaped marker 01 corresponding to the metric named "Daily Active Devices" is solid, and the other three unsubscribed metric items are "Daily Power-On Duration", "Daily Power-On Count", and "Cumulative Devices", and their corresponding heart-shaped marker 02 is hollow.

[0064] Furthermore, such as Figure 8 As shown, the subscribed metric item will display the metric parameter item to which it belongs. The metric parameter item includes the metric name, metric ID, subscription time and operation.

[0065] Step S400: Detect whether the indicator data of the subscription indicator has been changed in real time. When the indicator data of the subscription indicator is changed, issue a reminder for the change of indicator data.

[0066] In specific implementation of this invention, refer to Figure 3 As shown, the indicator system monitors the subscribed indicator data in real time for any changes, including updates and modifications to each indicator. When the indicator system detects an update and / or modification of the subscribed indicator data, it sends a notification. For example, when the indicator system detects an update and / or modification, it automatically responds to the email function. Upon receiving the response, the email function sends an email to the user (subscriber) notifying them of the change in the subscribed indicator data. The specific email content format is as follows:

[0067] {

[0068] "first_classify":"Department or Business Line A",

[0069] "second_classify":"Terminal metrics",

[0070] "target_name":"Daily Active Devices",

[0071] "target_desc":"Company's daily active device information",

[0072] "target_status":"Added XX users",

[0073] "target_time":"2022-09-06"

[0074] }

[0075] As can be seen from the above, the data warehouse metric subscription method described in this embodiment of the invention enables users to subscribe to data warehouse metrics according to their needs. This provides a data warehouse metric subscription function, allowing users to freely subscribe to the metrics they require. Subscribed metrics are not only displayed on a fixed entry page, but any changes to the metrics are also sent to the user via email. This allows users to focus on the metrics they need without needing to pay attention to irrelevant ones, receiving information through both the page and email. This invention allows users to select data warehouse metrics as needed, and the metric display is simple, making it easier for viewers to monitor the dynamics of key metrics and providing convenience for users.

[0076] Exemplary device

[0077] like Figure 9 As shown in the figure, an embodiment of the present invention provides a subscription processing device based on data warehouse metrics, the device comprising:

[0078] The pre-setting module 10 is used to pre-set the indicator names and corresponding indicator parameter items of multiple selectable data warehouse indicators, wherein the indicator parameter items include: indicator ID, indicator level, indicator category, indicator affiliation, and indicator explanation; and generate the corresponding indicator library according to the preset indicator names and corresponding indicator parameter items of the indicator names by a preset indicator tree.

[0079] The indicator list display module 20 is used to detect a login command, retrieve the indicator name and the corresponding indicator parameter item from the preset indicator library, and display them as an indicator list.

[0080] The subscription metric selection module 30 is used to obtain the user's metric selection instruction, determine the metric items marked with a check mark in the metric list as subscription metrics based on the obtained user's selection instruction in the metric list, and determine the subscription relationship.

[0081] The subscription indicator display control module 40 is used to obtain the dataset corresponding to the subscribed indicator when an indicator viewing command is detected, and to display the corresponding data according to the indicator name and the indicator parameter items corresponding to the indicator name.

[0082] The modification notification module 50 is used to detect in real time whether the indicator data of the subscribed indicator has been modified. When the indicator data of the subscribed indicator is detected to have been modified, a modification notification is issued, as described above.

[0083] Based on the above embodiments, the present invention also provides a smart device, the principle block diagram of which can be as follows: Figure 10 As shown, the intelligent device includes a processor, memory, network interface, and display screen connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The network interface is used to communicate with external terminals via a network connection. When the computer program is executed by the processor, it implements a subscription processing method based on data warehouse metrics. The display screen of the intelligent device can be an LCD screen or an e-ink screen.

[0084] Those skilled in the art will understand that Figure 10 The block diagram shown is merely a partial structural diagram related to the present invention and does not constitute a limitation on the smart device to which the present invention is applied. Specific smart devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0085] In one embodiment, a smart device is provided, including a memory and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by one or more processors. The one or more programs include instructions for performing the following operations:

[0086] Upon detecting a login command, the system retrieves the indicator name and the corresponding indicator parameter items from the preset indicator library and displays them as an indicator list.

[0087] Obtain the user's indicator selection instruction; based on the obtained user's selection instruction in the indicator list, determine the indicator items marked with the checkmark in the indicator list as subscription indicators, and determine the subscription relationship.

[0088] When a metric viewing command is detected, the dataset corresponding to the subscribed metric is retrieved, and the corresponding metric parameter items are displayed according to the metric name.

[0089] The system monitors in real time whether there are any changes to the subscription metrics data. When changes are detected, a notification is sent to alert the user of the changes, as described above.

[0090] The step of detecting a login command, retrieving the indicator name and the corresponding indicator parameter items from a preset indicator library, and displaying them as an indicator list includes the following:

[0091] The metric names and corresponding metric parameter items of multiple selectable data warehouse metrics are pre-defined, wherein the metric parameter items include: metric ID, metric level, metric category, metric affiliation, and indicator explanation;

[0092] Based on the preset indicator names and the corresponding indicator parameter items, a corresponding indicator library is generated according to the preset indicator tree.

[0093] The step of detecting a login command, retrieving the indicator name and the corresponding indicator parameter items from a preset indicator library, and displaying them as an indicator list includes:

[0094] Obtain and verify the user's login account;

[0095] If the verification is successful, it is determined that a login command has been detected and the system has logged in; the system then retrieves the indicator name and the corresponding indicator parameter items from the preset indicator library and displays them as an indicator list for users to select the desired indicator items as subscription indicators.

[0096] The step of obtaining the user's indicator selection instruction, determining the selected indicator items in the indicator list as subscription indicators based on the obtained user's selection instruction in the indicator list, and determining the subscription relationship includes:

[0097] Obtain the user's metric selection instructions.

[0098] According to the indicator selection instructions, check the indicators in the displayed indicator list, and determine the indicator items with check marks in the indicator list as subscription indicators based on the user's selection instructions in the indicator list.

[0099] The subscription relationship between users and metrics is determined based on the subscription metrics and stored in the subscription relationship table; wherein, the subscription relationship is used to determine the relationship between metrics and subscribers, and the subscription relationship table is used to interpret the list of corresponding relationships between users and metrics during the subscription process.

[0100] The step of detecting an indicator viewing command, obtaining the dataset corresponding to the subscribed indicator, and displaying it according to the indicator name and the corresponding indicator parameter items includes:

[0101] When a query to view metrics is received, the dataset corresponding to each subscribed metric is retrieved. The dataset is then displayed according to the metric name and the corresponding metric parameter items, using different states that distinguish it from unsubscribed metrics.

[0102] The step of real-time detection of whether the subscription metric data has changed, and issuing a notification when the subscription metric data has changed, includes:

[0103] Real-time detection of any changes to the data of the subscribed metrics, including updates and modifications to each metric;

[0104] When an update and / or modification operation is detected in the metric data of the subscribed metric, a notification of the metric data change is sent.

[0105] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-transitory computer-readable storage medium. When executed, the computer program can include the processes of the embodiments of the above methods. Any references to memory, storage, databases, or other media used in the embodiments provided by this invention can include non-transitory and / or temporary memory. Non-transitory memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Temporary memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), RAMbus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and RAMbus dynamic RAM (RDRAM), etc.

[0106] In summary, this invention discloses a subscription processing method, apparatus, and smart device based on data warehouse metrics. The method includes: obtaining metric names and corresponding metric parameter items from a preset metric library; obtaining a user's metric selection instruction, determining the selected metric items in the metric list as subscription metrics based on the obtained user selection instruction, and establishing a subscription relationship; when a metric viewing instruction is detected, obtaining the dataset corresponding to the subscription metric, and displaying it according to the metric name and corresponding metric parameter items; and when a change in the metric data of the subscription metric is detected, providing a notification of the data change. This invention enables data warehouse metric subscription functionality, provides simple metric display, and makes it easier for viewers to monitor the dynamics of key metrics, thus facilitating user experience.

[0107] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A subscription processing method based on data warehouse metrics, characterized in that, The method includes: Upon detecting a login command, the system retrieves the indicator name and the corresponding indicator parameter items from the preset indicator library and displays them as an indicator list. Before the step of detecting a login command, retrieving the indicator name and the corresponding indicator parameter items from a preset indicator library, and displaying them as an indicator list, the following steps are included: The system pre-sets the names of multiple selectable data warehouse metrics and the corresponding metric parameter items, wherein the metric parameter items include: metric ID, metric level, metric category, metric affiliation, and indicator explanation. Before the step of detecting a login command, retrieving the indicator name and the corresponding indicator parameter item from a preset indicator library, and displaying them as an indicator list, the method further includes: Based on the preset indicator names and the corresponding indicator parameter items, generate the corresponding indicator library according to the preset indicator tree. The steps of detecting a login command, retrieving the indicator name and the corresponding indicator parameter items from a preset indicator library, and displaying them as an indicator list include: Obtain and verify the user's login account; Once the verification is successful, it is determined that a login command has been detected and the system has logged in; the system then retrieves the indicator name and the corresponding indicator parameter item from the preset indicator library and displays them as an indicator list for users to select the desired indicator item as the subscription indicator. The indicator list includes the serial number, indicator name, indicator ID, indicator level, indicator category, indicator affiliation, indicator explanation, status, indicator details, and indicator query. The generation process of the indicator system includes: Based on the metrics of each product, the metric names and corresponding metric parameter items of multiple selectable data warehouse metrics are pre-set to form metric definitions and output to the analysis function. After the analysis function analyzes the indicators, it matches the product with the output of the indicator caliber. The indicators that match the product are classified and archived in the R&D function. The R&D function generates an indicator system by calculating the indicators and then displays the indicators. Obtain the user's indicator selection instruction; based on the obtained user's selection instruction in the indicator list, determine the indicator items marked with the checkmark in the indicator list as subscription indicators, and determine the subscription relationship. When a metric viewing command is detected, the dataset corresponding to the subscribed metric is retrieved, and the corresponding metric parameter items are displayed according to the metric name. The system monitors in real time whether there are any changes to the subscription metrics data. When changes are detected, a notification is sent to alert users of the changes.

2. The subscription processing method based on data warehouse metrics according to claim 1, characterized in that, The steps of obtaining the user's indicator selection instructions, determining the selected indicator items in the indicator list as subscription indicators based on the obtained user's selection instructions in the indicator list, and determining the subscription relationship include: Obtain the user's indicator selection instruction, check the indicator in the displayed indicator list according to the indicator selection instruction, and determine the indicator items with check marks in the indicator list as subscription indicators according to the user's selection instruction in the indicator list. The subscription relationship between users and metrics is determined based on the subscription metrics and stored in the subscription relationship table; wherein, the subscription relationship is used to determine the relationship between metrics and subscribers, and the subscription relationship table is used to interpret the list of corresponding relationships between users and metrics during the subscription process.

3. The subscription processing method based on data warehouse metrics according to claim 1, characterized in that, The steps of obtaining the dataset corresponding to the subscribed metric when a metric viewing command is detected, and displaying the dataset according to the metric name and the corresponding metric parameter items, include: When a query to view metrics is received, the dataset corresponding to each subscribed metric is retrieved. The dataset is then displayed according to the metric name and the corresponding metric parameter items, using different states that distinguish it from unsubscribed metrics.

4. The subscription processing method based on data warehouse metrics according to claim 1, characterized in that, The step of real-time detection of whether the subscription metric data has changed, and issuing a notification when the subscription metric data has changed, includes: Real-time detection of any changes to the data of the subscribed metrics, including updates and modifications to each metric; When an update and / or modification operation is detected in the metric data of the subscribed metric, a notification of the metric data change is sent.

5. A subscription processing device based on data warehouse metrics, characterized in that, The subscription processing apparatus based on data warehouse metrics is applied to the subscription processing method based on data warehouse metrics as described in any one of claims 1-4, and the apparatus comprises: The pre-setting module is used to pre-set the indicator names and corresponding indicator parameter items of multiple selectable data warehouse indicators. The indicator parameter items include: indicator ID, indicator level, indicator category, indicator affiliation, and indicator explanation. Based on the preset indicator names and corresponding indicator parameter items, the module generates a corresponding indicator library according to the preset indicator tree. The indicator list display module is used to detect login commands, retrieve indicator names and corresponding indicator parameter items from a preset indicator library, and display them as an indicator list. The subscription metric selection module is used to obtain the user's metric selection instruction, determine the metric items marked with a check mark in the metric list as subscription metrics based on the obtained user's selection instruction in the metric list, and determine the subscription relationship. The subscription indicator display control module is used to obtain the dataset corresponding to the subscribed indicator when an indicator viewing command is detected, and to display the corresponding data according to the indicator name and the indicator parameter items to which the indicator name belongs. The modification notification module is used to detect in real time whether there are any changes to the indicator data of the subscribed indicator. When changes are detected, a notification is sent to remind users of the changes.

6. A smart device, characterized in that, It includes a memory and one or more programs, wherein one or more programs are stored in the memory and configured to be executed by one or more processors, the one or more programs comprising the means for performing the method as described in any one of claims 1-4.

7. A non-transitory computer-readable storage medium, characterized in that, When the instructions in the storage medium are executed by the processor of the electronic device, the electronic device is able to perform the method as described in any one of claims 1-4.

Images