Query rewriting-based What-if hypothetical analysis method

A technology of hypothesis analysis and query rewriting, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve problems such as expensive re-aggregation time, unable to meet the real-time requirements of What-if analysis, etc.

Inactive Publication Date: 2009-11-04
陈红
View PDF0 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method not only needs to update the underlying data and dimension tables, but also the time cost of re-aggregation is very expensive, which is far from meeting the real-time requirements of what-if analysis

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
  • Query rewriting-based What-if hypothetical analysis method
  • Query rewriting-based What-if hypothetical analysis method
  • Query rewriting-based What-if hypothetical analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to understand the present invention and its advantages more fully, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific examples.

[0032] First, refer to figure 1 , to illustrate the What-if analysis method based on query rewriting.

[0033] First, in step A, construct a What-if hypothetical scenario in B / S mode.

[0034] Specifically, the hypothetical scenario of the What-if analysis of the present invention is composed of four basic assumptions, namely: new measurement member assumptions, measurement member change assumptions, non-metric dimension dimension membership addition assumptions, non-metric dimension dimension deletion Member assumptions. First select a Cube, add different assumptions on this Cube, and construct a hypothetical scenario to assist decision-making. The construction process of the four assumptions is as follows:

[0035](1) Add the assumption of "add measure memb...

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 relates to a query rewriting-based What-if hypothetical analysis method, comprising the steps: A. a What-if hypothetical scene is constructed under the B / S mode; B. the multi-dimensional query is constructed, and C. an OLAP server generates, analyzes and implements an MDX statement containing the reaggregation process against the hypothetical scene and the user multi-dimensional query. The query rewriting-based What-if hypothetical analysis method fully utilizes a materialized view which has been existed in the traditional OLAP and stimulates the data change and the change of a Cube structure by calculation, thereby avoiding the reaggregation calculation of CUBE and being capable of well meeting the requirements of the What-if real-time analysis.

Description

technical field [0001] The invention relates to a What-if hypothesis analysis method, in particular to a What-if hypothesis analysis method based on query rewriting. Background technique [0002] In the field of practical applications, decision supporters want to evaluate the adoption of new tactics or strategies, and the impact on the company now or in the future, so as to facilitate decision-making. This type of application is generally called what-if analysis or What-if analysis. What-If analysis is an important data analysis method for business personnel to manage and analyze data and provide decision support in modern business intelligence. The decision-maker formulates a series of hypothetical scenarios according to the decision-making objectives. The What-if analysis function obtains the change of business data in the hypothetical scenario through the hypothetical analysis of the existing data, and helps the decision-maker to formulate a correct and reasonable busines...

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/30
Inventor 陈红王珊冯海军何国明周国亮徐凡
Owner 陈红
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