Multidimensional expression data caching method and device in online analytical processing system

An online analytical processing, multi-dimensional expression technology, applied in the computer field, can solve problems such as slow running speed and memory waste

Active Publication Date: 2007-08-01
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] In view of this, the present invention is to provide a method and device for caching multi-dimensional expression data in an online analysis and processing system, so as to solve the above-mentioned problems of serious memory waste and slow running speed

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
  • Multidimensional expression data caching method and device in online analytical processing system
  • Multidimensional expression data caching method and device in online analytical processing system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The main steps of the present invention will be described below, and the preferred embodiments of the present invention will be described in detail in conjunction with the accompanying drawings. In this embodiment, the implementation process of the present invention is described by taking the data processing of a trading company as an example.

[0039] In this embodiment, the data of the trading company includes multiple dimensions, such as: product dimension, origin dimension and employee dimension.

[0040] When analyzing and processing the data of a trading company, if the user needs to query the proportion of the sales amount data of a certain time unit in the entire sales amount in the current data, it is necessary to pre-define the two calculation members of the entire sales amount and the ratio, and the entire The sales amount needs to be calculated through a certain amount, and the calculation process is relatively complicated. When the proportion calculation me...

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

This invention discloses one cross analysis process system multi-dimension expression data buffer method and device, which comprises the following steps: setting in advance multi-dimension buffer labels in the expression sentences; analyzing sentence to generate grammar tree and executing the expressions; in process, if yes, then setting the buffer label property as true and getting the said buffer label computation results and generating relative key words; storing the computation results and said key words.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for caching multi-dimensional expression data in an online analysis and processing system. Background technique [0002] Today, with the rapid development of science and technology, the data that needs to be counted in various fields of society are increasing rapidly. The recording and query of massive data bring new development directions and provide new technical issues for computer technology. [0003] Enterprise Resource Planning (ERP, Enterprise Recourse Planning) system brings new data management methods to enterprises. Through the ERP system, enterprises can use and manage various resources of the enterprise more efficiently. A large amount of data is stored in the ERP database. From the perspective of analysis and processing, the analysis generally requires multi-table operations and long running time. If the existing data in the ERP business system...

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 KINGDEE SOFTWARE(CHINA) CO LTD
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