Formula analysis based complicated index set calculation method and system

A formula analysis and calculation method technology, applied in the field of data informatization, can solve problems such as unacceptable workload, error-prone, and increased workload, and achieve low efficiency, complete automation, and powerful data dimension and measurement expansion capabilities Effect

Active Publication Date: 2016-03-16
CHINACCS INFORMATION IND
View PDF7 Cites 2 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
  • Formula analysis based complicated index set calculation method and system
  • Formula analysis based complicated index set calculation method and system
  • Formula analysis based complicated index set calculation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0043] An embodiment of the present invention proposes a method for calculating a complex index set based on formula parsing, including:

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

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

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 method and system for calculating a complex index set 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 complex. These relationships include derived relationships, parent-child relationships, and so on. In the existing technical field of data processing, 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 the basic data can be obtained directly or through the underlying data statistics; while the derived data is obtained through other data, and the data formed by combining multiple basic data or derived data is called for the parent data. [0003] In the prior art, many ente...

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
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

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