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

A multi-dimensional data query method and device

A multi-dimensional data query and dimension data technology, which is applied in the field of big data analysis, can solve the problems of excessive definition of dimensions, dimension explosion, occupation, etc., and achieve the effect of improving richness

Active Publication Date: 2022-06-07
SUNING CLOUD COMPUTING CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Under the goal of ensuring the actual multi-dimensional analysis, if the definition of dimensions is defined based on all business scenarios, it will lead to the hidden dangers of excessively repeated definitions of dimensions, occupying too much physical storage space, and dimension explosion, and the management of dimensions will also be affected. pose a great challenge

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 multi-dimensional data query method and device
  • A multi-dimensional data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] see figure 1 , this embodiment provides a multidimensional data query method, including: constructing atomic dimension data based on a dimension table in a data warehouse, where the atomic dimension data includes dimension codes, dimension names, dimension value codes and dimension value names; based on facts in the data warehouse The table trains the physical model, and the physical model stores detailed fact data and corresponding indicator fields and measurement fields; expands the dimensions of the atomic dimension data, and generates multiple derived dimension data corresponding to it; maps the physical model to the derived dimension data Matching to build a logical model, the logical model stores the mapping relationship between the derived dimension data and the corresponding indicator fields and measurement fields; obtains the query command, and retrieves the derived dimension data corresponding to the mapping relationship and the statistical output of the indica...

Embodiment 2

[0066] This embodiment provides an apparatus for querying multidimensional data, including an atomic dimension construction unit for constructing atomic dimension data based on a dimension table in a data warehouse, where the atomic dimension data includes dimension codes, dimension names, dimension value codes, and dimension value names ;

[0067] A physical model modeling unit for training a physical model based on a fact table in the data warehouse, where detailed fact data and corresponding index fields and measurement fields are stored in the physical model;

[0068] A dimension expansion unit, used for dimension expansion for the atomic dimension data, and correspondingly generating a plurality of derivative dimension data related to it;

[0069] a logical model modeling unit, configured to map and match the physical model and the derived dimension data to construct a logical model, where the logical model stores the mapping relationship between the derived dimension dat...

Embodiment 3

[0075] This embodiment provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and the computer program executes the steps of the multidimensional data query method when the computer program is run by a processor.

[0076] Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in this embodiment are the same as those of the multi-dimensional data query method provided by the above-mentioned technical solutions, which will not be repeated here.

[0077] Those of ordinary skill in the art can understand that all or part of the steps in the above-mentioned inventive method can be completed by instructing the relevant hardware through a program, and the above-mentioned program can be stored in a computer-readable storage medium, and when the program is executed, it includes For each step of the method in the above embodiment, the storage medium may be: ROM / RAM, magnetic di...

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 query method and device, relates to the technical field of big data analysis, and can achieve accurate query of approximate dimension data while reducing the physical storage space of a data model. The method includes: constructing atomic dimension data based on the dimension table in the data warehouse; training a physical model based on the fact table in the data warehouse, in which detailed fact data and corresponding index fields and measurement fields are stored; dimensioning the atomic dimension data Expand, correspondingly generate multiple derived dimension data related to it; map and match the physical model and derived dimension data to build a logical model, which stores the mapping relationship between derived dimension data and corresponding index fields and measurement fields; obtain query instructions, The derived dimension data corresponding to the mapping relationship and the statistical output of the indicator field and measurement field are retrieved from the logical model. The device applies the method in the above scheme.

Description

technical field [0001] The invention relates to the technical field of big data analysis, and in particular, to a multidimensional data query method and device. Background technique [0002] In multi-dimensional data analysis and processing, business logic model modeling based on OLAP engine is a commonly used solution, that is, by implementing a "data cube" to model and aggregate the data in the data warehouse according to different dimensional combinations, And when the data analyst conducts actual business queries, the logical model is aggregated and returned according to the combination of indicators and dimensions of the query, so as to achieve strong support for multi-dimensional analysis of business data. [0003] However, with the subdivision and development of specific business fields, there are more and more scenarios where the number of dimensions and the cardinality of dimension values ​​are too large in a single business logic model. Certain types of analysis di...

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/28G06F16/2458G06F16/248
CPCG06F16/283G06F16/2462G06F16/248
Inventor 曲乾坤崔建梅彭虎李成孙迁
Owner SUNING CLOUD COMPUTING CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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