Method and device for processing nonempty date in online analytical processing system

An on-line analytical processing and data technology, applied in the computer field, can solve the problems of low efficiency in processing non-empty data, inability to filter data in two-dimensional tables, and low operation efficiency, so as to improve filtering efficiency, improve flexibility, and improve operation efficiency. Effect

An on-line analytical processing and data technology, applied in the computer field, can solve the problems of low efficiency in processing non-empty data, inability to filter data in two-dimensional tables, and low operation efficiency, so as to improve filtering efficiency, improve flexibility, and improve operation efficiency. Effect

CN100495403CActive Publication Date: 2009-06-03KINGDEE SOFTWARE(CHINA) CO LTD
4 Cites 1 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for processing nonempty date in online analytical processing system
  • Method and device for processing nonempty date in online analytical processing system
  • Method and device for processing nonempty date in online analytical processing system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The core of the present invention is to provide a method for processing non-empty data in an online analysis and processing system. The original range of the query axis is obtained by analyzing the defined multidimensional expression. The combination of each dimension member on the point, and filter the points where the data of at least one dimension member is empty to obtain the initial two-dimensional table; then traverse all the cells determined by each row or column in the initial two-dimensional table, when all cells have no physical When data exists, filter the row or column to obtain the required two-dimensional table.

[0051] The present invention obtains the required two-dimensional table through MDX query OLAP:

[0052] The main feature of OLAP is to directly imitate the user's multi-angle thinking mode, and build a multi-dimensional data model for the user in advance, where the dimension refers to the user's analysis angle. For example, in the analysis of m...

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 method to process non vacuum data, which comprises the following steps: a, analyzing defined multi-dimension expression to get index axis original range; b, when only considering physical data, browsing the said original range each member combination and filtering the one dimension data to get initial two dimensional form; c, browsing the said two dimension each line or row units and filtering them to get needed two dimensional form. This invention also discloses one device to analyze process system for non-hollow data of cross machine.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for processing non-empty data in an online analysis and processing system. Background technique [0002] OLAP (On-Line Analytical Processing, Online Analytical Processing) is a software technology that enables analysts to quickly, consistently, and interactively observe information from various aspects in order to achieve a deep understanding of the data, which is obtained directly from the original data. Converted, they reflect the reality of the business in a way that users can easily understand. Most of the OLAP strategies are to store relational or common data in multi-dimensional data for easy analysis, so as to achieve the purpose of online analysis and processing. This kind of multi-dimensional data is regarded as a hypercube, which stores data along the direction of each dimension, which allows users to analyze data along the axis of the transaction...

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
03 Jun 2009
Publication
CN100495403C
IPC
G06F17/30
Inventors
æž—å¿—è´¤