Multi-dimensional data query method and device

A multi-dimensional data query and data technology, applied in the computer field, can solve problems such as increasing the difficulty of management, performance bottlenecks, and reducing the efficiency of updating fact tables, achieving the effect of fast retrieval and reduced complexity

Active Publication Date: 2019-04-12
JINGDONG TECH HLDG CO LTD
View PDF7 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventors found that there are at least the following problems in the prior art: 1. Various indexes need to be created in the method (1), causing a large number of indexes to occupy a large amount of resources, reducing the efficiency of updating the fact table, and Increase the difficulty of management; 2. In the method (2), if the dimension of the data is too high, the cubes established will be relatively sparse, requiring a large amount of storage resources and lack of economy; 3. The calculation cost of the method (3) is high, and the calculation Resources grow with the growth of data volume, even higher than the growth rate of data volume, and will encounter performance bottlenecks; 4. In method (1) and method (3), dimension data is stored in their respective fact tables, and from their respective fact tables The data is summarized according to the dimensions, and the unified management of dimension data cannot be realized.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0035] figure 1 is a schematic diagram of main steps of a multidimensional data query method according to an embodiment of the present invention. As a reference example of the present invention, such as figure 1 As shown, the main steps of the multidimensional data query method in the embodiment of the present invention may include:

[0036] Step S101: Establish a dimensi...

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, and relates to the technical field of computers. A specific embodiment of the method comprises the following steps: establishing a dimension retrieval table according to a fact table and a dimension table related to the fact table, and adding a composite index of the dimension retrieval table; according to at least one dimension query condition in the query request, performing query in a dimension retrieval table by utilizing the composite index, and determining a target data primary key; and according to the target dataprimary key, inquiring the fact table to obtain data needing to be inquired in the inquiry request. According to the embodiment, a dimension retrieval table is adopted; according to the technical scheme, the method has the advantages that the data can be quickly retrieved only by creating a small amount of indexes in the dimension retrieval table, the number of the indexes is not increased alongwith the increase of the number of dimensions, the dimension retrieval table can be used for uniformly managing the dimension data, and the dimension management complexity is reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a multidimensional data query method and device. Background technique [0002] In order to observe the data from multiple angles and sides, so that users can have a deep understanding of the information and connotation contained in the data, multi-dimensional data analysis technology came into being. Multidimensional data analysis refers to various analysis operations on data organized in a multidimensional manner to perform data analysis. As a component of multidimensional data analysis technology, multidimensional data query technology has important research value. [0003] At present, there are three common ways to query multi-dimensional data: (1) create an index on the dimension field of the original fact table, and improve the efficiency of data query through the index; (2) build a multi-dimensional data cube, that is, summarize the fact table by dimension, Generate a m...

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): G06F16/22
Inventor 马春亮
Owner JINGDONG TECH HLDG CO LTD
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