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 the problems of low efficiency of multi-dimensional data query execution

Active Publication Date: 2019-12-10
BEIJING GRIDSUM TECH CO LTD
View PDF13 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 multi-dimensional data. The method comprises the following steps that: obtaining a query condition, wherein the query condition comprises a query dimension chain and a query index, and the query dimension chain comprises at least one query dimension; according to the query condition, obtaining a least table set from a plurality of fact data tables, wherein the least table set is a set of event data tables which at least contain one query dimension and one query index and have a smallest quantity in a plurality of event data tables; according to a connecting relationship between the event data tables in the least table set, generating a data structure used for reflecting a data stream process; and according to the data structure, generating a corresponding data query language, and executing data query through the data query language. Through the method, the technical problem of low execution efficiency of multi-dimensional 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 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