Memory OLAP What-if analytical method based on a difference table

An analysis method and a technology of difference tables, which are applied in special data processing applications, instruments, electrical digital data processing, etc., can solve problems such as exponential changes in data volume

Active Publication Date: 2009-10-14
王珊
View PDF0 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, under different aggregation assumptions, the amount of assumed data will change exponentially

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
  • Memory OLAP What-if analytical method based on a difference table
  • Memory OLAP What-if analytical method based on a difference table
  • Memory OLAP What-if analytical method based on a difference table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] 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 embodiments. In the drawings, the same reference numerals are used to denote the same elements.

[0035] First, refer to figure 1 , to illustrate the difference table-based memory OLAP What-if analysis method according to the present invention.

[0036] In step A, the user obtains the data he is interested in by directly inputting MDX statements or a graphical interface for subsequent What-if analysis, and converts the user's graphical representation into MDX statements and submits them to the OLAP server. That is to say, the user inputs the user query statement and hypothetical data through the graphical interface, and at the same time stores the above hypothetical data in the difference table. Thereafter, the server parses and executes the MDX statement, and returns 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

A memory OLAP What-if analytical method based on a difference table includes: A. when a user expresses an inquiry request through a graphical interface and inputs assumed data, converting the graphical expression of the user into MDX statement to be submitted to an OLAP server, and simultaneously storing the assumed data in the difference data; B. analyzing a piece of MDX statement into SQL statement and generating a What-if data view by the combination of a user inquiry view and the difference table; C. connecting the What-if data view with a new dimension table and variously assuming the connected assumed view; and D. after the What-if analysis is finished, deleting the difference table and related accessory structure from a database.

Description

technical field [0001] The invention relates to a memory OLAP What-if analysis method, in particular to a memory OLAP What-if analysis method based on a difference table. Background technique [0002] As computer hardware follows Moore's Law, its cost-effectiveness has doubled, and memory prices have dropped to 0.06 yuan / MB (the current mainstream DDR800 memory price [December 2008]). At the same time, the current 64-bit operating system + 64-bit processor makes The theoretical value of recognizable system memory capacity reaches 2^34GB (Windows Server 2003 x64 Edition already supports a maximum memory capacity of 512GB), so more and more data can be stored in memory, and even the entire CUBE can be stored in memory. This provides the hardware foundation for in-memory OLAP. [0003] In-memory OLAP assumes that all data is stored in the computer's memory, and only stores basic data, not aggregated data. The data is stored using some kind of memory-based compression techniqu...

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