Online analysis processing method and device, storage medium and electronic equipment

An online analytical processing and computer program technology, applied in the field of data processing, can solve problems such as cube inapplicability, fixed hierarchical relationship, and inability to meet business flexible drilling and analysis requirements, so as to improve the scope of applicable scenarios, broaden dimensions and measurements, and facilitate The effect of maintenance updates

Inactive Publication Date: 2019-05-10
NEUSOFT CORP
View PDF9 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This will cause the analyzable dimensions and the hierarchical relationship between dimensions to be fixed. When business requirements change and new dimensions need to be analyzed, the cube cannot be applied to the analysis of new business requirements and cannot meet the flexible drill analysis requirements of the business; in addition, the establishment of The cube has a long cycle, difficult to change, and low analysis efficiency

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
  • Online analysis processing method and device, storage medium and electronic equipment
  • Online analysis processing method and device, storage medium and electronic equipment
  • Online analysis processing method and device, storage medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] The specific embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are only used to illustrate and explain the present disclosure, and are not used to limit the present disclosure.

[0055] The online analysis processing method according to the exemplary embodiment of the present disclosure can be applied to the intelligent analysis of various data. After the intelligent analysis, it can be shown to the user in the form of a chart (such as a bar chart, a pie chart, etc.) according to the needs of the user The data users expect to know.

[0056] In the online analysis and processing method according to the exemplary embodiment of the present disclosure, the dimension refers to the angle of displaying the data, and the value in the corresponding data table is a non-numerical field; the metric refers to the displayed quantity value, that is, the ...

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 an online analysis processing method and device, a storage medium and electronic equipment, and the method comprises the steps: querying an original data table according to afirst dimension and a measurement, and obtaining first data corresponding to the first dimension and the measurement; generating an analysis chart according to the first data; Responding to a receiveddrilling instruction for a target dimension attribute in a current analysis chart, and drilling from the level of the current dimension according to the drilling instruction in a dimension hierarchical relationship corresponding to the original data table to obtain a second dimension; Querying the original data table according to a second dimension and the metric, and obtaining second data corresponding to the second dimension and the metric; and generating a new analysis chart according to the second data. Therefore, the analyzable dimension and measurement of the online analysis processingmethod can be effectively broadened, and cube does not need to be established in advance during online analysis, so that the online analysis efficiency can be improved, the complexity can be reduced,and the maintenance and updating are easy.

Description

Technical field [0001] The present disclosure relates to the field of data processing, and in particular, to an online analysis and processing method, device, storage medium, and electronic equipment. Background technique [0002] Online Analytical Processing (OLAP) is a data analysis and processing technology that enables analysts to consistently and interactively observe information from all aspects to achieve the purpose of in-depth understanding of data. [0003] OLAP is mostly seen in traditional business intelligence (BI) analysis tools. Traditional BI analysis tools mostly use the way of building data cubes (cube) for data modeling. However, when creating a cube, you need to analyze the entire business scenario and set fixed dimensions and Measure and the hierarchical relationship between dimensions, and then store the data corresponding to the dimension and measure in the database to the cube. Then perform OLAP analysis based on the fixed dimensions and measurement informa...

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/28G06F16/248G06F16/22
Inventor 廉帅
Owner NEUSOFT CORP
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