Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method and system for multidimensional analysis of big data

A multi-dimensional analysis and big data technology, applied in the computer field, can solve the problems of inconvenience and low efficiency of cross-CUBE query, and achieve the effect of convenient query and high efficiency

Active Publication Date: 2019-10-29
武汉奇米网络科技有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, propose a method and system for multidimensional analysis of big data, and solve the technical problems of inconvenient and inefficient cross-CUBE query in the multidimensional analysis of 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
  • A method and system for multidimensional analysis of big data
  • A method and system for multidimensional analysis of big data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0028] The present invention provides a method for multidimensional analysis of big data, including:

[0029] S1. Build multiple CUBEs, which contain dimension information and index information, store the dimension information and index information of the CUBEs in the first database table, mark different CUBEs with the name of the CUBE, and mark the dimension of the CUBE with the name of the dimension and the name of the index and indicators;

[0030] S2. Identify dimension names with the same meaning for each CUBE, establish a matching relationship table between dimension names with the same mean...

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 discloses a big data multi-dimensional analysis method and system. The method comprises the steps of constructing a plurality of CUBEs, identifying dimension names, same in meaning, of the CUBEs, establishing a dimension matching relation table, generating public dimension names of the dimension names same in meaning, selecting the public dimension names and index names by a user, and finding a third CUBE name set containing public dimensions and indexes selected by the user; generating an SQL statement, querying data in the CUBEs of the third CUBE name set, and putting query results into a memory for caching; and assembling the query results to obtain a result set, and displaying a chart corresponding to the result set. The method and the system have the beneficial effects that dimension matching relations of the CUBEs are established, the user selects the dimensions and the indexes to query the data, the data, meeting the conditions, in the CUBEs is queried and put into the memory for caching, the data in the memory is assembled into the result set, and the result set is displayed by the chart, so that cross-CUBE data query is realized, the efficiency is high, the query is convenient, and information does not need to be integrated manually.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a large data multidimensional analysis method and system. Background technique [0002] In the big data industry, multidimensional analysis is a very important technology that can provide analysts with free combination queries from multiple angles, multiple granularities, and multiple indicators, which provides great convenience for data exploration and analysis. Different from traditional report development, it has the advantages of high degree of freedom, high scalability, wide coverage and low maintenance cost. [0003] Generally speaking, the method of multidimensional analysis is to establish a multidimensional data cube model (CUBE) in advance. After the user selects the indicators and dimensions, they query and cooperate with the OLAP calculation engine commonly used in the industry to pull and calculate from the CUBE. The result that the end user wants, and pre...

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): G06F16/22G06F16/2453G06F16/28
CPCG06F16/2264G06F16/24539G06F16/284
Inventor 刘春江黎侃柴楹黄承松夏里峰
Owner 武汉奇米网络科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com