Unlock instant, AI-driven research and patent intelligence for your innovation.

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

An execution method and execution plan technology, applied in the database field, can solve problems such as performance lag

Pending Publication Date: 2021-03-05
ALIBABA GRP HLDG LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of this application is to propose an execution method, device, electronic device and computer-readable medium of a query instruction, which are used to solve the problem of how to effectively solve the execution plan of all physical sub-tables of the cache logic table in the prior art. The problem of performance lag

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019]The following detailed description will be further described below with reference to the accompanying drawings and examples. It will be appreciated that the specific embodiments described herein are only configured to interpret the relevant invention, and is not limited to the invention. It will also be described in that, in order to facilitate the description, only portions associated with the relevant invention are shown in the drawings.

[0020]It should be noted that the features in the embodiments and embodiments in the present application may be combined with each other in the case of an unable conflict. The present application will be described in detail below with reference to the accompanying drawings.

[0021]ReferFigure 1A The steps of performing the execution method of the query instruction of the first example of the present application are shown.

[0022]Specifically, the execution method of the query instruction of the present embodiment includes the following steps:

[002...

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 instruction execution method and device, electronic equipment and a computer readable medium, and relates to the field of databases. The method comprises the following steps: determining a library name and / or a table name to be filled into an execution plan of a query template corresponding to a first query instruction according to a service parameter in the received first query instruction; merging the service parameters, the table names and / or the library names to obtain a merging result of the service parameters, the table names and / or the library names to be filled into an execution plan of a query template corresponding to the first query instruction; and based on the combination result, filling the execution plan with the service parameters, the table name and / or the library name to generate a second query instruction sent to a node of a distributed database for execution. Through the embodiment of the invention, the problem of performance lag caused by execution plans of all physical sub-tables of the cache logic table is effectively solved.

Description

Technical field[0001]The present application embodiment relates to the field of database, and more particularly to a method, apparatus, electronic device, and computer readable medium for query instructions.Background technique[0002]The MySQL database is an open source relational database that is currently one of the most popular databases. In the slice scene of the MySQL database, in order to resolve storage capacity restrictions and lift single table query performance, a large number of physical scraps of the same structure are created for logic tables. Since the Mysql Database's Prepared Statement Protocol Default Query is only allowed to use placeholders for constants, the cached execution plan needs to include the execution plan for the Query instruction for all physical scales. With the number of physical scales, the complexity of the query instruction is increased, a large number of caches will be taken to trigger the performance of performance Cardon. It can be seen that how...

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/2453G06F16/242G06F16/22G06F16/28G06F16/27
CPCG06F16/2282G06F16/2433G06F16/24537G06F16/24539G06F16/27G06F16/284
Inventor 陈默
Owner ALIBABA GRP HLDG LTD