Method for improving slice performance of multi-dimensional analysis by adopting bidirectional indexes

A technology of slicing performance and multi-dimensional analysis, applied in the field of multi-dimensional analysis, it can solve the problems of not very abundant space and occupying a large space.

Inactive Publication Date: 2017-12-12
北京润乾信息系统技术有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the slice result set is guaranteed to be stored continuously in the original data set, the original data set needs to be physically sorted for each dimension, resulting in a large amount of space (the original data set will be copied N times if there are N dimensions), which is in terms of space. Not acceptable if not very abundant

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 for improving slice performance of multi-dimensional analysis by adopting bidirectional indexes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The staff of a loan company checks the bank statement information (working date, entry date, currency, counterparty account number, remittance, transaction code, amount, terminal number, balance, loan, area code, operator) of the customer applying for the loan. The analysis is mainly interested in the entry date dimension and the loan dimension in the bank statement information data set, so the data slice analysis on the entry date dimension and the loan dimension fully conforms to the implementation scenario of the patent of the present invention.

[0029] First, copy a data set of bank slip information to two data sets. In data set A, according to the dimensions (working date, entry date, currency, counterparty account number, remittance, transaction code, terminal number, loan, area code, Operator) sorting, dimension sorting by working date, sorting by entry date dimension based on working date dimension sorting, and so on, until finally there is only one record when ...

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 provides a method for improving slice performance of multi-dimensional analysis by adopting bidirectional indexes. A piece of data is copied in two data sets; one data set A is sorted according to dimensions of D(1), D(2)......D(N-1), and D(n); the other data set B is sorted according to dimensions of D(n), D(n-1)......D(2), and D(1); indexes are created for first half of the dimensions of the two data sets; the indexes in the two data sets just correspond to all the dimensions in the data sets; then the data sets are subjected to data slicing, the dimension where the optimal index is located is selected, and conditions of other dimensions are calculated by traversal; and records of calculation through the method are all sorted and distributed continuously and orderly according to the index dimensions, the records involved in calculation are record pieces according to the conditions of the first half of the dimensions, and each piece is relatively not excessively small, so that the indexes can achieve the effect of improving the slice performance.

Description

technical field [0001] The present invention relates to multidimensional analysis, and more specifically, relates to a method for improving slice performance of multidimensional analysis by using bidirectional indexes. Background technique [0002] Multidimensional analysis is a software technique that enables analysts to quickly, consistently, and interactively observe information from all sides to achieve a deep understanding of data. It has the characteristics of FASMI (Fast Analysis of SharedMultidimensional Information), that is, the fast analysis of shared multidimensional information. Among them, F is fast (Fast), which means that the system can respond to most of the analysis requirements of users within a few seconds; A is analysis (Analysis), which means that users can define new special calculations without programming, and use them as analysis part of the data, and give reports in the way users want; M is multidimensional, which refers to providing multidimensio...

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/30G06Q40/02
CPCG06F16/2462G06F16/2453G06Q40/02
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