Data query method and device and computer readable storage medium

A data query and data table technology, applied in the computer field, can solve the problems of lack of real-time data query and analysis capabilities, increase the difficulty of complex data query, affect the efficiency of data query, etc., achieve integrated batch processing and improve resource utilization efficiency , the effect of reducing the difficulty of query

Pending Publication Date: 2021-06-04
TENCENT TECH (SHENZHEN) CO LTD
View PDF0 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Usually, real-time query requirements in big data scenarios involve real-time data and offline data query and multidimensional analysis. The applicable scenarios are relatively limited, and the correlation ability between tables is poor when the data of multiple tables needs to be obtained at the same time, which affects the efficiency of data query and increases the difficulty of complex 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
  • Data query method and device and computer readable storage medium
  • Data query method and device and computer readable storage medium
  • Data query method and device and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

[0026] The definitions of the key terms involved in this application are firstly explained below.

[0027] Data engine: the database engine used to store, process and protect data. Leverage a database engine that controls access and processes transactions quickly to handle large volumes of data.

[0028] Physical table: the basic table, which is a real table stored in a certain data source.

[0029] View: A view is an SQL statement stored in the database. It is a virtual table or a logica...

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

Embodiments of the invention disclose a data query method and apparatus, and a computer readable storage medium. The method comprises the steps of obtaining a data query request submitted by a client; if the data query request carries a view name of a target view, performing reconstruction processing on the data query request to obtain a target query statement of at least one data table corresponding to the target view; using the metadata information in the data warehouse to analyze the target query statement to determine a query engine and a query rule, wherein the query engine is a distributed computing engine or a local computing engine; obtaining a data query result of the data query request from a target database in a data warehouse through a query engine and a query rule, sending the data query result to the client side, wherein the data warehouse comprises one or two of offline data and real-time data. By means of the data query method and device, synchronous query processing of offline data and real-time data can be achieved, the query difficulty of complex data is lowered, and the data query efficiency is effectively improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a data query method, device and computer-readable storage medium. Background technique [0002] Usually, real-time query requirements in big data scenarios involve real-time data and offline data query and multidimensional analysis. The applicable scenarios are relatively limited. When the data of multiple tables needs to be obtained at the same time, the correlation ability between the tables is poor, which affects the efficiency of data query and increases the difficulty of complex data query. Contents of the invention [0003] Embodiments of the present application provide a data query method, device, and computer-readable storage medium, which can realize synchronous query processing of offline data and real-time data, reduce the difficulty of complex data query, and effectively improve the efficiency of data query. [0004] On the one hand, an embodiment of th...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/2455G06F16/2458G06F16/25G06F16/27G06F16/28
CPCG06F16/2282G06F16/2433G06F16/24568G06F16/2471G06F16/254G06F16/27G06F16/284
Inventor 孟善珏万春晓
Owner TENCENT TECH (SHENZHEN) 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