Unlock instant, AI-driven research and patent intelligence for your innovation.

A real-time analysis method of multi-dimensional data based on dynamic crosstab

A real-time analysis and multi-dimensional data technology, applied in the field of data analysis, can solve problems such as unsatisfactory business needs, performance problems, poor user experience, etc., and achieve excellent performance, broaden application fields, and flexible and efficient analysis

Active Publication Date: 2021-06-08
山东浪潮傲林大数据科技有限公司
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The existing relational analysis model is relatively solid, and it is oriented to a single topic, and the topic determines the range of analysis indicators and dimensions. Relational data analysis is based on the temporary table after the query of the SELECT statement. When there is a large amount of data, there are many performances. problems, resulting in poor user experience, thus failing to meet business needs

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 real-time analysis method of multi-dimensional data based on dynamic crosstab

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0049] Data preparation: index system definition, index definition, measurement definition, dimension definition, index system inclusion relationship, semantic object designer;

[0050] Database connection settings;

[0051] Create analysis wizard: indicator selection, dimension selection, condition setting;

[0052] The SSAS layer dynamically creates CUBE;

[0053] The front end displays real-time multi-dimensional analysis.

[0054] The core code for index and dimension processing is as follows:

[0055] / / Parameter Description

[0056] / / zbtx (index system number), zb (index number string), wd (dimension number string), rootwd (dimension string with root node), wherStr (filter condition string in condition setting )

[0057] public string GetGuideSql(string zbtx, string zb, string wd, stringrootwd, string wherStr)

[0058] {

[0059] string txtable = zbtx.ToUpper() + tableflag; / / corresponding fact table

[0060] string lds = ZBTXLD(zbtx); / / measurement attribute ...

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 multi-dimensional data real-time analysis method based on a dynamic cross table, which belongs to the technical field of data analysis. The front end adopts the form of an analysis guide to independently select indicators and dimensions; the back end adopts an SSAS method to dynamically create a CUBE; The implementation steps are as follows: S1: Data collation, including the system fact table and dimension table; S2: Include indicators, dimensions and measures into the indicator system through the indicator tool; S3: Describe all dimensions through the semantic object designer, and carry out the dimension Grouping and grading; S4: Use the analysis wizard to self-complete the inclusion relationship between the system and indicators, dimensions and measures; S5: Select the indicators and dimensions to be analyzed to form a real-time analysis table. The invention greatly improves the performance of data processing and analysis, makes up for the deficiency in multi-dimensional analysis performance of the relational cross table, makes the analysis more flexible and efficient, and satisfies different business scenarios.

Description

technical field [0001] The invention relates to the technical field of data analysis, in particular to a real-time analysis method for multi-dimensional data based on a dynamic cross-table. Background technique [0002] With the development of the times, the gradual and widespread application of big data, and the increase in the amount of enterprise data, the disadvantages of traditional relational BI (Business Intelligence, business intelligence) analysis have begun to appear. The existing relational analysis model is relatively solid and is oriented to a single topic, and the topic determines the range of analysis indicators and dimensions. Relational data analysis is based on the temporary table after the query of the SELECT statement. When there is a large amount of data, there are many performances. problems, resulting in poor user experience, which cannot meet business needs. Contents of the invention [0003] The technical task of the present invention is to provid...

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/2458G06F16/27G06F16/28
Inventor 杨良冯洋洋刘静
Owner 山东浪潮傲林大数据科技有限公司