Indicator calculating method and system based on dimension combinations

A technology of index calculation and dimension, applied in the field of enterprise informatization and data processing, can solve the problem of increasing the total time consumed by data calculation, and achieve the effect of improving performance and efficiency

Active Publication Date: 2016-02-24
CHINACCS INFORMATION IND
View PDF6 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 2. With the development of business, the amount of data will increase, and the total time consumed by data calculation will increase;

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
  • Indicator calculating method and system based on dimension combinations
  • Indicator calculating method and system based on dimension combinations
  • Indicator calculating method and system based on dimension combinations

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] For ease of understanding, some nouns mentioned in the embodiments of the present invention are now explained:

[0045] Measure: Refers to the numerical column that can be measured in the data table, and can be used for aggregation operations such as SUM.

[0046] Dimension: Refers to the column with classification meaning, such as direction, which can be divided into east, south, west, and north. The direction can be used as a dimension, corresponding to a column in the table.

[0047] Dimension value, dimension value: It means the same meaning, referring to the value range in the column corresponding to the dimension, such as the dimension of direction, its value range is east, south, west, north, in a specific row, the dimension The value of is also fixed, which is reflected in the table that the value of the direction field of a certain row is east, while the value of the direction field of another row is west.

[0048]Dimension combination (the full name is the co...

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

Embodiments of the present invention provide an indicator calculating method and system based on dimension combinations. The method comprises: acquiring common attributes, dimensions, and measurement values of all data, wherein each piece of data has at least two dimensions; statistically acquiring all dimension combinations in the data, wherein a total measurement value of the dimension combinations is a sum of measurement values of all data comprised by the dimension combinations; generating a dimension statistics table, wherein each row of the dimension statistics table represents a dimension combination, and the dimension statistics table comprises at least: columns that represent dimensions, columns that represent total measurement values corresponding to the dimension combinations, and columns that represent dimension combinations subjected to indicator statistics; acquiring all indicators, wherein each indicator is a statistical condition defined by a dimension value range of several dimensions in a dimension combination; determining a dimension combination represented by each indicator, and adding a label to the corresponding dimension combination in the dimension statistics table; and traversing each row of the dimension statistics table, and determining whether there is a row that is labelled more than once or not labelled.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to an index calculation method and system based on dimension combination that can be applied in the field of enterprise informatization. Background technique [0002] When an enterprise conducts data statistics, it usually aggregates various data into a wide table. Taking the most important "income" data of an enterprise as an example, the income data from various sources is usually aggregated into a wide table at a light granularity, and then audited to ensure that the total income of the wide table is consistent with the total income from various sources. Specifically, various income data are written as structured query statements (StructuredQueryLanguage hereinafter referred to as SQL) to perform operations on various income data one by one; then the calculation results of all data are summed and compared with the total income data , if consistent, the data is correct. ...

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
CPCG06F16/283
Inventor 魏晟坤尚志强尚超王秀英
Owner CHINACCS INFORMATION IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap