Data query method and device

A data query and database technology, applied in the field of data query methods and devices, can solve problems such as untrustworthy query results, inaccurate query data, and complex software analysis, and achieve the effects of simple query methods, improved user experience, and improved convenience.

Pending Publication Date: 2021-03-02
南京江北新区生物医药公共服务平台有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this way of using Kylin to split dimensions may need to split dozens or even hundreds of Cubes (defined internally by Kylin to represent data cubes) for ultra-multidimensional query analysis requests. A data structure), and at the same time, it must be able to accurately locate the specified cube when performing data query, otherwise the query data will be inaccurate, resulting in untrustworthy query results
Therefore, there is an urgent need for an effective solution to the situation that there are too many dimensions in the query analysis request, which makes the analysis of big data analysis software such as Kylin too complicated or impossible to analyze.

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

[0026] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with specific embodiments and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0027] In order to solve the problem in the prior art that there are too many dimensions in the request for query and analysis, which makes the analysis of big data analysis software such as Kylin too complicated or impossible to analyze. The present invention provides a data query method, which can be applied to a data query system. The data query system includes several different types ...

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, the method is applied to a data query system, the data query system comprises a plurality of different types of database management systems, and the methodcomprises the following steps: obtaining a data query request; determining the number of dimensions of query condition fields corresponding to the data query request; determining a target database management system according to the number of dimensions of the query condition field; and determining a data query result corresponding to the data query request based on the target database managementsystem. According to the method, a scheme that a plurality of different types of database management systems are matched for use can be utilized, so that the pain point that Kylin cannot normally process and analyze the data query request under the condition that the dimensions of the data query request are too many can be improved, and the convenience of querying and reading the data in the database based on the data query request can be improved; the development efficiency of the database is improved, and the user experience of data query is improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data query method and device. Background technique [0002] Kylin is one of the widely used OLAP (Online Analytical Processing) tools. It has more than 10 billion data query and analysis capabilities, can provide standard SQL interface, and can conduct interactive real-time data analysis. Its performance Compared with ordinary data warehouses (such as Hive), the performance is higher. At present, many companies have chosen Kylin for OLAP tools. However, Kylin, as a leader in OLAP tools, has certain limitations in the number of dimensions of data processed (for example, the current upper limit of the dimensions of data processed by Kylin is 64), that is, the number of dimensions supported by Kylin is very limited. Big bottleneck. Usually, the amount of data to be statistically analyzed is not large, but the data has many dimensions (for example, more than one hundred ...

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
IPC IPC(8): G06F16/242G06F16/22G06F16/28
CPCG06F16/244G06F16/2228G06F16/284G06F16/283
Inventor 朱旨昂阚苏立王路孙祥黄璐徐晓岚
Owner 南京江北新区生物医药公共服务平台有限公司
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