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

Execution plan search method, storage method and device

An execution plan, to-be-executed technology, applied in the database field, can solve problems such as time consumption and poor database system performance, and achieve the effect of reducing latency and improving performance

Active Publication Date: 2020-08-07
BEIJING OCEANBASE TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the step of semantically parsing the SQL statement generally takes a certain amount of time, which will cause poor performance of the database system

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
  • Execution plan search method, storage method and device
  • Execution plan search method, storage method and device
  • Execution plan search method, storage method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In order to enable those skilled in the art to better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described The embodiments are only some of the embodiments of the present application, but 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 shall fall within the scope of protection of this application.

[0037] As we all know, the access operations to the database may include: adding, deleting, reading, and changing data, etc., and the above access operations can generally be realized through SQL statements. Since the SQL statement is a descriptive language, it is used to specify what the user needs to do without specifying how to do the ...

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 an executive plan search method, and an executive plan storage method and apparatus. The executive plan search method comprises the steps of receiving an SQL statement; according to the SQL statement, generating a parameterized SQL statement corresponding to the SQL statement; searching for pre-stored executive plan and constraint conditions corresponding to the parameterized SQL statement; if the pre-stored executive plan and constraint conditions are found, judging whether parameters corresponding to the constraint conditions in the parameterized SQL statement meet the constraint conditions or not; and if the constraint conditions are met, determining the queried executive plan as a to-be-executed executive plan. According to the executive plan search method, and the executive plan storage method and apparatus, the SQL statement can be prevented from being subjected to semantic analysis in the process of searching for the executive plan, so that the time consumption in the process of searching for the executive plan is reduced and the performance of a database system is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a search method, storage method and device for an execution plan. Background technique [0002] Usually, database access can be implemented through SQL (Structured Query Language, Structured Query Language). Generally, the database system needs to formulate an execution process for how to achieve the purpose of the access task according to the SQL statement corresponding to the access task. This process is called "execution plan". An instance of a program to be executed to return the result desired by the user. [0003] In the prior art, the process of generating the execution plan corresponding to the SQL statement roughly includes: first, analyzing the lexical / syntax of the SQL statement, and then analyzing the semantics of the SQL statement, and determining the optimal execution plan based on the optimization rules , and finally, generate code with the above opti...

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/242G06F16/2453
CPCG06F16/2433G06F16/24542
Inventor 陈萌萌陈俊全肖意
Owner BEIJING OCEANBASE TECH CO LTD