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

Dimensional Analysis Method and Device for Analyzing Database

A database and dimension technology, applied in the field of dimensional analysis of the analysis database, can solve the problems of slow analysis speed and achieve the effect of speeding up the analysis speed

Active Publication Date: 2017-11-21
BEIJING GRIDSUM TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The main purpose of the present invention is to provide a method and device for analyzing dimensions of an analysis database, so as to solve the problem of slow analysis speed when the dimensions in the analysis database are simultaneously analyzed with multiple attributes

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
  • Dimensional Analysis Method and Device for Analyzing Database
  • Dimensional Analysis Method and Device for Analyzing Database
  • Dimensional Analysis Method and Device for Analyzing Database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0030] figure 1 is a flow chart of the first embodiment of the dimension analysis method for analyzing databases according to the present invention. Such as figure 1 As shown, the dimensional analysis method of the analysis database includes:

[0031] Step S101, acquiring a first dimension table in the analysis database, wherein the first dimension table is a dimension table with a data volume greater than a first preset threshold in the analysis database.

[0032]SSAS includes an analysis database. The analysis database can perform online statistics on data, online data analysis, and random query to discover the value of information and data. It is an important branch of database products. ...

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 dimensionality analyzing method and device for an analytic database. The method comprises the steps that a first dimensionality list in the analytic database is acquired, preset dimensionality lines in the first dimensionality list are acquired, shared dimensionality corresponding to the preset dimensionality lines is established, and when a plurality of attributes in the first dimensionality list are analyzed at the same time, analyzing is carried out through the shared dimensionality corresponding to the preset dimensionality lines in the first dimensionality list. By means of the dimensionality analyzing method, the problem that when the attributes of the dimensionality in the analytic database are analyzed at the same time, the analyzing speed is low is solved, and the effect that the analyzing speed is greatly increased when the attributes of the dimensionality in the analytic database are analyzed at the same time is achieved.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a dimension analysis method and device for analyzing a database. Background technique [0002] Data analysis server (SQL Services Analysis Services referred to as SSAS) provides an integrated platform for combined data mining solutions. The dimension in SSAS has a large amount of data, which generally corresponds to a large dimension table in the database. AutoExists is a feature in SSAS dimension analysis. It is used to avoid that when two column attributes in the same dimension table are applied to the analysis conditions at the same time, only the dimension values ​​that exist in both analysis columns are selected for corresponding analysis. Small dimension tables or medium dimension tables have improved performance, and on display, only corresponding data records with values ​​in both dimension columns will be displayed. In this way, the effect of data analysis on som...

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): G06F17/30
CPCG06F16/2264G06F16/283
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD