A method and system for calculating complex index sets based on formula analysis

A technology of formula analysis and calculation method, applied in the field of data informatization, it can solve problems such as error-prone, unacceptable workload, increased workload, etc., achieve strong data dimension and measurement expansion ability, solve inefficiency, and achieve complete automation Effect

Active Publication Date: 2018-07-20
CHINACCS INFORMATION IND
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when performing statistics on data sets with large amounts of data and complex data relationships, the amount of continuous calculation will increase exponentially; especially when adding new data types and adding / modifying formulas, the workload is even more unacceptable
As the amount of formulas continues to increase and formulas change, maintenance personnel have to face a large number of cell names without clear meanings in Excel, and need to find the required data locations in different sheets, which will increase the workload and error prone

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 method and system for calculating complex index sets based on formula analysis
  • A method and system for calculating complex index sets based on formula analysis
  • A method and system for calculating complex index sets based on formula analysis

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The core idea of ​​the present invention is to realize better readability, maintainability and expansibility than traditional methods through a data formula description language that can be recognized by both humans and computers, and can support automated batch calculations. , so that when processing complex data sets with thousands or even tens of thousands of data, it can still maintain high execution efficiency.

[0043] The embodiment of the present invention proposes a complex index set calculation method based on formula analysis, including:

[0044] Determine the parameters of the data standardization model, the parameters include the dimensions, measurement values, and derived values ​​of the data in the data set;

[0045] Determine the underlying data Data in the dataset x , and denote the underlying data as Data x ={Name b , Valueb}, where Name b is the name of the underlying data, Value b is the data value of the underlying data;

[0046] Determine the...

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 invention propose a formula analysis based complicated index set calculation method and system. The calculation method comprises: determining parameters of a data standardization model, wherein the parameters include a dimension, a measurement value and a derivative value of data in a data set; determining basic data in the data set; determining non-basic data in the data set and representing the non-basic data by arithmetic of at least one or more sub-data; representing each non-basic datum as a tree structure, wherein end points of the tree structure are arithmetic operators for generating the non-basic data, and branches of the tree structure are sub-data for generating the non-basic data; sorting formulae corresponding to all the generated non-basic data to ensure that formulae corresponding to the sub-data cited by the non-basic data are arranged before formulae corresponding to the non-basic data; then generating executable statements according to the sorted formulae; and importing the basic data and then executing the executable statements in sequence.

Description

technical field [0001] The invention relates to the technical field of data informatization, in particular to a calculation method and system for complex index sets based on formula analysis. Background technique [0002] As the scale of the enterprise gradually expands, the amount of various types of data and derived data in the enterprise will also increase, and the relationship between the data will become more and more complicated. These relationships include derivative relationships, parent-child relationships, etc. In the existing data processing technology field, data is divided into basic data, derived data, and parent data. The data that does not depend on other data is called basic data, and basic data can be obtained directly or through underlying data statistics; while derived data refers to data obtained through other data, and data formed by combining multiple basic data or derived data is called for the parent data. [0003] In the prior art, many enterprise...

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/10
CPCG06F17/10
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