Method and device for optimizing multidimensional cube model

A technology of dimensional cube and optimization method, which is applied in the field of artificial intelligence, can solve problems such as difficulty in evaluating rationality and dependence on designers for Cube design, and achieve a highly practical effect

Active Publication Date:
View PDF4 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] The present invention provides an optimization method and device for a multi-dimensional cube model to solve the problem that the existing Cube design is too dependent on the designer and the rationality is difficult to evaluate, and optimize the multi-dimensional cube model

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
  • Method and device for optimizing multidimensional cube model
  • Method and device for optimizing multidimensional cube model
  • Method and device for optimizing multidimensional cube model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] figure 2 It is a schematic flowchart of a method for optimizing a multi-dimensional cube model provided in Embodiment 1 of the present invention. Such as figure 2 As shown, the method of this embodiment can be executed by a device for optimizing a multi-dimensional cube model, which can be realized by means of software, and generally can be independently configured in a user terminal or server to implement the method of this embodiment.

[0032] The method of this embodiment specifically includes:

[0033] S110. Construct a full-dimensional multi-dimensional cube model based on a dimension set, where the dimension set includes all data dimensions in the business model.

[0034] Generally, a multidimensional cube contains raw factual data and aggregated data, and the aggregated data enables users to perform complex queries quickly. In the construction of multi-dimensional cubes, dimensions provide classification descriptions, representing a type of analysis perspect...

Embodiment 2

[0044] Figure 3A It is a schematic flowchart of a method for optimizing a multi-dimensional cube model provided in Embodiment 2 of the present invention. Such as Figure 3A As shown, in this embodiment, on the basis of the above-mentioned embodiments, it is optional to update the dimension set based on the collected user behavior data according to a preset update rule, including: aggregating the collected user behavior data Group optimization and / or storage optimization, updating the set of dimensions based on an optimization result.

[0045] In order to further improve the query efficiency of optimizing the multi-dimensional cube, on this basis, the method for optimizing the multi-dimensional cube model may further include: performing routing strategy optimization on the multi-dimensional cube model.

[0046] Correspondingly, the method in this embodiment specifically includes:

[0047] S210. Construct a full-dimensional multi-dimensional cube model based on a dimension s...

Embodiment 3

[0083] Figure 4 Shown is a schematic structural diagram of a device for optimizing a multi-dimensional cube model provided by Embodiment 3 of the present invention. The device can be implemented by means of software, and generally can be independently configured in a user terminal or server to implement the method of this embodiment. Such as Figure 4 As shown, the device for optimizing the multi-dimensional cube model specifically includes: a multi-dimensional cube creation module 410 , a dimension set update module 420 and a multi-dimensional cube model update module 430 .

[0084] Among them, the multidimensional cube building module 410 is used to construct a full-dimensional multidimensional cube model based on a dimension set, and the dimension set includes all data dimensions in the business model; the dimension set update module 420 is used to collect user behavior data based on The preset update rule updates the dimension set; the multidimensional cube model update ...

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 method and a device for optimizing a multidimensional cube model. The method for optimizing a multidimensional cube model comprises the following steps: building an all-dimension multidimensional cube model based on a dimension set, wherein the dimension set includes all data dimensions in a service model; updating the dimension set based on acquired user behavior data and according to preset updating rules; and regenerating a multidimensional cube model according to the updated dimension set. According to the technical scheme of the invention, the dimension set is updated based on the acquired user behavior data, and then, a multidimensional cube is regenerated. The problem that the updating of a multidimensional cube at present requires a large amount of calculation and depends on the experience of the designer is solved. A multidimensional cube can be updated automatically. Updating of the dimension set based on the operation data in a database is closer to the actual need of users. Thus, the updated multidimensional cube model is smarter and more practical.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of artificial intelligence, in particular to a method and device for optimizing a multi-dimensional cube model. Background technique [0002] In the conventional BI (Business Intelligence, business intelligence) field, multi-dimensional cube Cube design is based on the premise of fully understanding the business, designing its dimensions and measurements for use by the business side. [0003] For sales data analysis, such as figure 1 As shown, in the Cube model, there are a total of 6 dimensions of commodity, user, region, store, salesperson, and payment channel, and two measurement columns of purchase quantity and purchase amount. Assume that A, B, C, D, E, F represents the six dimensions of product, user, region, store, salesperson, and payment channel. When designing the dimension table, the dimension table can include a primary key (PK) and dimension attributes, and for the hie...

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 Applications(China)
IPC IPC(8): G06Q10/04G06Q10/06G06F17/30
CPCG06F16/221G06F16/27G06Q10/04G06Q10/0633
Inventor 李寅威
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