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

A kind of SQL statement execution method and device

A statement and execution process technology, applied in the field of SQL statement execution methods and devices, can solve the problems of long time, consumption, slow execution speed of SQL statements, etc., and achieve the effect of improving execution speed

Active Publication Date: 2019-12-20
HANGZHOU HIKVISION DIGITAL TECH
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During this process, each compilation process usually takes a long time, resulting in slow execution of SQL statements

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 kind of SQL statement execution method and device
  • A kind of SQL statement execution method and device
  • A kind of SQL statement execution method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0131] As an implementation manner of an embodiment of the present invention, the device further includes:

[0132] The first storage module (not shown in the figure) is used to store the corresponding relationship between the input and output of the target SQL statement in the compilation process.

[0133] As an implementation manner of the embodiment of the present invention, the electronic device locally stores the corresponding relationship between the input and output of the predetermined compilation process during the execution of the SQL statement; the device also includes:

[0134] The judging module (not shown in the figure) is used for judging whether the corresponding relationship between the input and the output of the compiling process is saved locally for each compiling process; if it exists, the searching module 420 is triggered.

[0135] As an implementation manner of the embodiment of the present invention, the electronic device locally stores the correspondin...

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 an SQL sentence executing method and device. The method comprises the steps of receiving a to-be-executed target SQL sentence; aiming at all compiling processes, searching for whether or not target input matched with input of the target SQL sentence in the compiling process exists in the corresponding relation of input and output which are stored locally inthe compiling process; if yes, using target output corresponding to the target input as output of the target SQL sentence in the compiling process; if not, accordingly compiling the target SQL sentence according to the input of the target SQL sentence in the compiling process to obtain output of the target SQL sentence in the compiling process, and using the output as the input of the target SQLsentence in the next compiling process; when a physical executing tree output by the target SQL sentence in a physical optimizing period is obtained, inputting the physical executing tree into an executing engine to be executed. By means of the SQL sentence executing method and device, the executing speed of the SQL sentence can be increased.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for executing SQL statements. Background technique [0002] SQL (Structured Query Language, Structured Query Language) is a language for operating databases. It can be used to access data and query, update and manage relational database systems. The execution of the SQL statement may generally include two phases of compilation and execution, wherein the compilation phase may include a series of processes such as lexical analysis, syntax analysis, semantic analysis, logic optimization, and physical optimization. In other words, the entire process from submitting a SQL statement to sending the physically optimized physical execution tree to the execution engine for execution is called the compilation phase. [0003] Lexical analysis is the first process in the compilation phase, which is responsible for reading in the SQL statements that make up the source p...

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/2455
CPCG06F16/24553
Inventor 邓长春陈国栋郭峰席大超
Owner HANGZHOU HIKVISION DIGITAL TECH