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

Active Publication Date: 2009-06-03
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] The purpose of the present invention is to provide a method for processing non-empty data in an online analysis and processing system, to overcome the inability to filter part of the data before obtaining the two-dimensional table in the prior art, when encountering blank rows or empty columns in the generated two-dimensional table In many cases, a lot of time is wasted in the process of traversing the table, which reduces the problem of operational efficiency
[0014] Another object of the present invention is to provide a device for processing non-empty data in an online analysis and processing system to solve the problem of low efficiency in processing non-empty data in an online analysis and processing table in the prior art

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
  • 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
no application Login to view more
Patent Type & Authority Patents(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

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