Data cube-oriented operable graphic perspective table construction method

A data cube, data-oriented technology, applied in the field of data processing, can solve the problems such as the need to rebuild the conversion table, the rigid data display, and the inoperability of the chart.

Pending Publication Date: 2020-11-17
ZHEJIANG UNIV OF TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this process, almost every process will involve human intervention, and the final data display is relatively rigid, the chart is not operable, and the conversion table needs to be rebuilt, etc.

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
  • Data cube-oriented operable graphic perspective table construction method
  • Data cube-oriented operable graphic perspective table construction method
  • Data cube-oriented operable graphic perspective table construction method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0041] Example: such as figure 1 As shown, a data cube-oriented operable graphical pivot table construction method, according to the needs of the application scenario, set the known data source, select the corresponding dimension and measure to complete a data cube, according to the information of the data cube, in the data perspective Perform OLAP operations on the table, where the pivot table such as figure 2 shown, including the following steps:

[0042] 1) for image 3 In the configuration file of the data cube, the dimension of the data cube and the definition configuration information of the measurement are obtained in the configuration file. where the cube model such as Figure 4 shown.

[0043] 2) Query the level of each dimension, and query the dimension members of different levels in the dimension level, and construct a B+ tree, according to image 3 The schematic diagram of the data cube dimension member B+ tree in Figure 5 shown;

[0044] 3) According to ...

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 relates to a data cube-oriented operable graphic perspective table construction method, which comprises the following steps of: projecting a cube into a two-dimensional data perspectivetable, and quickly indexing member information of dimensions by adopting a B + tree according to the dimensions and measurement information displayed by horizontal and longitudinal axes of the perspective table configured by a user, and in combination with a table algebra calculation table structure and a table header structure, obtaining a row and column structure of a table data area and a numerical attribute of each data unit, and constructing an MDX query statement according to the calculated attributes to query a corresponding specific numerical value in the data cube. When the user operates the level of the dimension hierarchy, the user only needs to combine the B + tree of the dimension and the table algebra again to quickly calculate the table structure and index the data. The inventionadapts to the characteristics of simplicity and intuition of a data perspective table, has the characteristics of agile perspective table operation response, efficient processing of a large amount of data and the like, and can quickly calculate and reduce system I / O.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method for constructing an operable graphic pivot table oriented to a data cube. Background technique [0002] In recent years, enterprises have accumulated more and more data in the development of the Internet era. As the granularity of data becomes finer and the number of Internet users increases, the magnitude of these data shows an exponential growth trend. Although the price of storage is declining day by day, how to use these massive data to extract valuable information from the data, dig out the meaning and relevance behind the data, promote the value of the data, and convert the data into intuitive graphical reports, which is convenient for enterprise managers Analyzing data, and then promoting the formulation of corporate decisions, planning the development direction of the enterprise, and enhancing the competitiveness of the enterprise in the market, these hav...

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): G06F16/22G06F16/242
CPCG06F16/2246G06F16/2282G06F16/2433
Inventor 任海潮杨良怀
Owner ZHEJIANG UNIV OF TECH
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