Unlock instant, AI-driven research and patent intelligence for your innovation.

Key performance indicator (KPI) local recalculation method supporting factual data changes

A key performance indicator, local technology, applied in the field of data processing, can solve the problems of heavy system burden, inability to meet the requirements of massive data, difficult decision makers KPI index results, etc., to achieve the effect of ensuring real-time performance

Active Publication Date: 2013-04-24
北京讯鸟软件有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The work efficiency of this approach is very low, the system burden is heavy, and it increases the complexity of the system
Obviously, this traditional KPI index calculation method can no longer meet the requirements of the existing massive data
Under the condition of massive data, it is costly and inefficient to recalculate KPI indicators frequently, and it is difficult for decision makers to grasp the latest KPI indicator results in a timely manner

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Key performance indicator (KPI) local recalculation method supporting factual data changes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In the process of using the database to calculate KPI indicators, in order to improve the overall operating efficiency, the corresponding keys and values ​​are usually stored in the memory of the computer system. This feature can be used by the present invention to improve the efficiency of partial recalculation of KPI indicators.

[0019] Specific as figure 1 As shown, when a new piece of fact data is passed, a unique key (key) is generated according to the source information of the fact table. The purpose of this key is to distinguish other fact data. The value of the key is composed of: the database name corresponding to the data, the name of the fact table, the original label of the fact data, and the label (id) of the KPI indicator. Then check whether this key exists in the historical data stored in the memory, and the results are divided into two cases.

[0020] The first case: If the corresponding value (value) cannot be found through this key, it means that t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a KPI local recalculation method supporting factual data changes. The method includes the following steps: when new factual data appear, generating corresponding keys according to the source of a fact table and then searching whether the keys exist in historical data; if corresponding values are not searched out through the keys, saving the factual data in key and value modes; and if corresponding values are searched out through the keys, performing negative operations on searched values, performing addition operations on values generated by the factual data, and updating values corresponding to the keys. According to the KPI local recalculation method, aiming at factual data local change conditions under mass data conditions, only addition and subtraction operations to local KPIs are needed, and not only the defect that all the KPIs are needed to be recalculated during changes of existing fact tables is overcome, but also timeliness of the calculation results of the KPIs is guaranteed.

Description

technical field [0001] The invention relates to a method for calculating key performance indicators (KPI), in particular to a method for realizing partial recalculation of key performance indicators in the case of fact data changes, and belongs to the technical field of data processing. Background technique [0002] Key Performance Indicator (Key Performance Indicator) is abbreviated as KPI, which is a measurable measurement value used to measure business performance, and has a wide range of applications in technical fields such as telecommunications management and business intelligence analysis. A KPI is a collection of calculations associated with a measure group in a cube used to evaluate business performance. These calculations are usually a combination of Multidimensional Expressions (MDX) or calculated members. KPIs also include additional metadata that provides information about how client applications display the results of KPI calculations. [0003] A typical KPI ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 吴为民武继孔李晓磊
Owner 北京讯鸟软件有限公司