Supercharge Your Innovation With Domain-Expert AI Agents!

SQL analysis optimization method and device

An optimization method and parser technology, applied in the database field, can solve the problems of low efficiency of SQL statement parsing and frequent use of keywords, and achieve the effect of avoiding low parsing efficiency and improving speed.

Active Publication Date: 2020-12-11
YUSUR TECH CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, since the use of non-reserved keywords is uncommon, and the use of keywords is relatively frequent, certain types of nodes will be repeatedly created and then destroyed, and memory will be continuously applied for and then released, eventually resulting in SQL Statement parsing efficiency is low

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
  • SQL analysis optimization method and device
  • SQL analysis optimization method and device
  • SQL analysis optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with the embodiments and accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0037] Here, it should also be noted that, in order to avoid obscuring the present invention due to unnecessary details, only the structures and / or processing steps closely related to the solution according to the present invention are shown in the drawings, and the related Other details are not relevant to the invention.

[0038] It should be emphasized that the term "comprising / comprising" when used herein refers to the presence of a feature, element, step or component, but does not exclude the presence or addition of one or more other features, elements, steps or components.

[0039] When t...

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 invention provides an SQL (Structured Query Language) analysis optimization method and device. The method comprises the following steps: initiating a request for applying for a node of a type matched with an SQL statement based on the SQL statement; according to the applied node type, searching for idle nodes of the corresponding type in an established node pool, wherein the established node pool comprises node linked lists of different types, each node linked list comprises a plurality of nodes, and data of each node in the node linked list are pointers pointing to a node memory; and under the condition that the idle nodes of the corresponding types exist in the node pool, taking one idle node out from the idle nodes to serve as an applied node. According to the embodiment of the invention, the analysis of the SQL statement in the prior art is optimized, and the problem of low analysis efficiency caused by repeated construction and then analysis construction is avoided by constructing the node pool.

Description

technical field [0001] The invention relates to database technology in big data applications, in particular to an SQL parsing and optimization method and device. Background technique [0002] Structured Query Language (Structured Query Language), referred to as SQL, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. [0003] In the prior art, the SQL statement edited by the user in the editor will be parsed by the parser in the form of a string, and the key information and clauses will be formed into nodes, and finally the entire syntax tree will be constructed. [0004] SQL keywords in SQL statements can be divided into reserved keywords and non-reserved keywords. Among them, reserved keywords are used to define, operate and access databases, and they are usually not used as identifiers. Non-reserved keywords only have special meanings in specific environments, ...

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/2453
CPCG06F16/2433G06F16/2453
Inventor 鄢贵海赵璐
Owner YUSUR TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com