Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-dimensional data query method and device

A multi-dimensional data and query method technology, applied in the field of multi-dimensional data query methods and devices, can solve problems such as low execution efficiency of multi-dimensional data query, and achieve the effect of quickly realizing multi-dimensional data query

Active Publication Date: 2020-06-12
BEIJING GRIDSUM TECH CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a multi-dimensional data query method and device to at least solve the technical problem of low execution efficiency of multi-dimensional data query in the related art

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0020] It should be noted that the terms "first" and "second" in the description and claims of the present application and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such...

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 query method and device for multidimensional data. The method comprises the steps that a table set meeting a query condition is acquired from multiple fact data tables, wherein the query condition comprises a query dimension chain, and the query dimension chain comprises at least one query dimension; to-be-distributed fields are distributed to the corresponding fact data tables in the table set to obtain a first target table set, wherein the to-be-distributed fields are needed column fields acquired from the query condition; a target filtering condition is sunk into a target data table in the first target table set to obtain a second target table set; a data structure used for reflecting a data flow process is generated according to a connection relation between the fact data tables in the second target table set; and a corresponding data query language is generated according to the data structure, and data query is executed through the data query language. Through the query method and device, the technical problem of low execution efficiency of multidimensional data query is solved.

Description

technical field [0001] The present application relates to the field of databases, in particular, to a query method and device for multi-dimensional data. Background technique [0002] In the environment of On-Line Analytical Processing (OLAP for short), currently commonly used query engines include structured databases with metadata such as Hive and Impala. In these databases, generally, data of various events are recorded in respective fact data tables. For example, in the "Teaching Management System", the teaching management database contains the following fact tables: "Teacher" table, "Course" table, "Grade" table, "Student" table, "Class" table and "Teaching" table etc. Through the above fact table, the information of students, teachers, courses, etc. in the teaching process can be managed. For another example, when monitoring Internet sessions, there are generally session table (Session), page view table (PageView), site search table (SiteSearch), order table (Ecommer...

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/28
CPCG06F16/283
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products