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

A Partial Recalculation Method of Key Performance Indicators Supporting Factual Data Changes

A key performance indicator and partial technology, applied in the field of data processing, can solve problems such as heavy system burden, low efficiency, and inability to meet the requirements of massive data, and achieve the effect of ensuring real-time performance

Active Publication Date: 2015-12-23
北京讯鸟软件有限公司
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
  • A Partial Recalculation Method of Key Performance Indicators Supporting Factual Data Changes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In the process of using the database to calculate the KPI indicators, in order to improve the overall operation 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 local recalculation efficiency of KPI indicators.

[0019] Specifically as figure 1 As shown, when a new 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 it from other factual 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 the key exists in the historical data stored in the memory, and the found results are divided into two cases.

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

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 when factual data is changed, and belongs to the technical field of data processing. Background technique [0002] Key Performance Indicator (KeyPerformanceIndicator), abbreviated as KPI, is a measurable measurement value used to measure business performance. It is widely used in technical fields such as telecommunication management and business intelligence analysis. A KPI is a collection of calculations associated with a group of measures in a cube used to assess business performance. These calculations are usually multidimensional expressions (MDX) or combinations of calculated members. KPIs also include additional metadata that provides information about how client applications display the results of KPI calculations. [0003] A typical KPI object consists of basic informat...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 吴为民武继孔李晓磊
Owner 北京讯鸟软件有限公司