Query execution method and device, electronic equipment and computer readable medium

An execution method and sub-query technology, which is applied in the database field to reduce the calculation pressure

Pending Publication Date: 2021-02-23
ALIBABA GRP HLDG LTD
View PDF0 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of this application is to propose a query execution method, device, electronic device, and computer-readable m

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
  • Query execution method and device, electronic equipment and computer readable medium
  • Query execution method and device, electronic equipment and computer readable medium
  • Query execution method and device, electronic equipment and computer readable medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only configured to explain the related invention, rather than limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

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

[0024] refer to figure 1 , shows a flow chart of the steps of the query execution method according to Embodiment 1 of the present application.

[0025] Specifically, the execution method of the query in this embodiment includes the following steps:

[0026] In step S...

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 invention provides a query execution method and device, electronic equipment and a computer readable medium, and relates to the field of databases. The method comprises the following steps: converting a sub-query in a received SQL request to obtain a relational algebraic expression corresponding to the sub-query; determining a part, which can be pushed downwards to be executed by child nodes in a distributed database, in the relational algebra expression; and converting a part, which can be pushed down to be executed by a child node in a distributed database, in the relational algebraic expression to obtain an SQL instruction used for indicating the child node to execute related operations of the child query. According to the embodiment of the invention, the sub-queries are pushed downwards to the sub-nodes in the distributed database to be executed, and the sub-nodes of the distributed database are effectively combined to execute the sub-queries, so that the overall computing power of the distributed database can be completely utilized, and the computing pressure of an execution server in a distributed database system is effectively relieved.

Description

technical field [0001] The embodiments of the present application relate to the field of databases, and in particular, to a query execution method, device, electronic equipment, and computer-readable medium. Background technique [0002] A subquery is a program module at the lower level of a nested query in a common computer language. When one query is a condition of another query, it is called a subquery. As a kind of SQL (StructuredQuery Language, Structured Query Language) structure syntax that is easy to understand and convenient to construct, the proportion of subqueries in SQL statements processed by distributed databases is currently on the rise. [0003] In a distributed relational database, a subquery is a non-standard relational algebra operator. If the subquery is effectively combined with a distributed data structure, the overall computing power of the distributed relational database can be fully utilized, thereby Effectively reduce the computing pressure 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
IPC IPC(8): G06F16/242G06F16/2455G06F16/27
CPCG06F16/2433G06F16/2455G06F16/27
Inventor 刘继龙
Owner ALIBABA GRP HLDG 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