Data query method and device

A data query and data technology, applied in the field of data analysis, can solve the problem of inability to query data in data warehouse

Active Publication Date: 2020-02-07
BEIJING GRIDSUM TECH CO LTD
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present application provides a data query method and device to at least solve the technical problem that the existing query system cannot perform data query on the data warehouse that combines the data organization method of the star schema and the snowflake schema

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
  • Data query method and device
  • Data query method and device
  • Data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0022] 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 data query method and device. The method comprises the following steps that: receiving a data query request, wherein the data query request comprises the dimension and the index of data to be queried; utilizing metadata which is configured in advance in a data warehouse to determine a target data table set, wherein the metadata preconfigures an incidence relation of data tables in the data warehouse; detecting whether the target data table set contains the data table of a snowflake model or not; when the target data table set contains the data table of the snowflake model, connecting with the data table of the snowflake model; through the data table of the snowflake model, connecting with the data tables of other star type models in the target data table set; and according to the connected data table, querying the data to be queried. By use of the method, the technical problem that an existing query system can not carry out data query on the data warehouse of a data organization way that the star type model and the snowflake model are combined is solved.

Description

technical field [0001] This application relates to the field of data analysis, in particular, to a data query method and device. Background technique [0002] In the field of analyzing data, the data model usually includes a star schema and a snowflake schema. Among them, the data organization mode of the star schema is: a data fact table, and other tables are dimension tables, such as time dimension, geographic dimension table, etc. Dimension tables are radially distributed around the fact table; the data organization mode of the snowflake model is: when a fact table is associated with a dimension table, it needs to go through an intermediate fact table or an intermediate dimension table, thus forming a multi-layer association relationship, similar to Snowflake-like shapes, such as analyzing session-related data through product names, must be associated through the intermediate data order table. That is, you need to find out all the corresponding orders through the product...

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/2455G06F16/28
CPCG06F16/288
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