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

Multi-dimensional data query method and device

A query method and multi-dimensional technology are applied in the field of data multi-dimensional query methods and devices, which can solve the problems of low multi-dimensional data query efficiency, and achieve the effect of improving query efficiency.

Active Publication Date: 2020-05-22
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 main purpose of this application is to provide a multi-dimensional data query method and device to solve the problem of low efficiency of multi-dimensional data query

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] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0020] 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.

[0021] It should be noted that the terms "first" and "second...

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 data multi-dimensional query method and apparatus. The method comprises the steps of obtaining a query condition, wherein the query condition comprises a dimension analysis chain and to-be-queried indexes, and the dimension analysis chain consists of at least one dimension and is used for filtering a plurality of fact data tables; obtaining the fact data tables associated with the query condition, thereby obtaining an associated fact data table set; generating an analytic tree according to connection relationships of the fact data tables in the associated fact data table set, wherein the analytic tree is generated by the query condition and the connection relationships and used for reflecting a data structure of a data flow process; and generating a corresponding data query language according to the analytic tree, and executing query processing through the data query language. Through the method and the apparatus, the problem of relatively low efficiency of data multi-dimensional query is solved.

Description

technical field [0001] The present application relates to the field of data processing, in particular, to a multi-dimensional data query method and device. 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, data records of various events are usually recorded in the individual fact tables. For example, in the Teaching Management System, the Teaching Management database contains the following fact tables: Teachers, Courses, Grades, Students, Classes, and Lectures Tables, etc., are used to manage information such as students, teachers, and courses in the teaching process through the above fact data tables. For example, session monitoring on the Internet generally has session tables (Session), page browsing tables (PageView), and site search tables ( SiteSearch), order table (Ecommerce), custom event tabl...

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

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

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