A data query method, related device and database system

A data query device and data query technology are applied in the fields of data query and database system, and can solve the problems of increased execution overhead, decreased query speed, and decreased performance.

Active Publication Date: 2021-06-08
HUAWEI TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] However, in practical applications, if there are repeated input parameter b1 values ​​in the t1 table, the process of iterating to the subquery to calculate the average value avg will be repeated, resulting in slow query speed and increased execution overhead. causing performance degradation

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
  • A data query method, related device and database system
  • A data query method, related device and database system
  • A data query method, related device and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0077] The present application provides a method, related device, and database system of data queries, avoiding repetition calculations using the same parameters, thereby increasing query speed, reducing execution overhead, which is advantageous for performance.

[0078]The description and claims of the present application and the terms "first", "second", "third", "fourth", etc. in the above drawings are used to distinguish similar objects without A specific sort or order is described. It is to be understood that the data such as use can be interchanged in place so that the embodiments of the present application described herein can be implemented, for example, in addition to those other than those illustrated or described herein. Moreover, the terms "including" and "having" and any variations are intended to cover non-rowing, such as process, methods, systems, products, or equipment that contain a series of steps or units, including a series of steps or units, are not necessarily...

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 embodiment of the present application discloses a data query method, including: receiving a data query request, the data query request includes a sub-query and a parent query corresponding to the sub-query; determining the sub-query estimated cost value of the data query request; if the sub-query estimated cost value is less than the preset threshold, construct a parent query data table according to multiple parameter values ​​passed in by the parent query, and sort the tuples in the parent query data table to obtain the target query data table; if the target query data table The parameter value corresponding to the first tuple is inconsistent with the parameter value corresponding to the second tuple, and then a subquery is executed according to the parameter value corresponding to the first tuple to obtain the first data query result. The embodiment of the application discloses a data query device and a database system. The embodiment of the present application can avoid repeated calculations using the same parameters, thereby increasing query speed, reducing execution overhead, and improving performance.

Description

Technical field [0001] The present application relates to the field of computer technology, in particular, to a method, related device, and database system for data queries. Background technique [0002] With the rapid development of Internet technology, many applications are accompanied by a large amount of data, which are saved through the database. At the same time, the application can obtain the data required from the database by a structural query language (SSQL) query. Subproof, also known as internal query (INNER QUERY) or Nested Query, is a query nested in other SQL queries or a query in the WHERE clause. The nested other SQL queries are also known as a parent query or an outer query. Subquers include associated subqueries and non-associated subquers. If the outer query is in a subsequent query, the sub-query is the associated subquery, otherwise the non-correlation subquery. [0003] In order to improve subquerical efficiency, prior art can usually convert sub-queries to...

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/2453G06F16/2455
Inventor 李茂增孟聪陈毅能
Owner HUAWEI 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