Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Structured query language processing method and related device

A structured query and processing method technology, applied in the field of structured query language processing methods and devices, can solve problems such as low optimization efficiency, huge workload, and inability to guarantee program performance, so as to improve optimization efficiency and ensure program performance Effect

Active Publication Date: 2021-03-30
MASHANG CONSUMER FINANCE CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The entire optimization process has a huge workload and is extremely time-consuming, and the optimization efficiency is low, and the optimization quality is very dependent on the programmer's work experience, and the optimized program performance cannot be guaranteed.

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
  • Structured query language processing method and related device
  • Structured query language processing method and related device
  • Structured query language processing method and related device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0056] The invention provides a processing method of a structured query language and a related device, which can efficiently complete the optimization work of SQL, discover problems existing in SQL in time, and improve program performance.

[0057] First of all, it should be explained that during the development of a project or application, when a developer completes a functional module or system method, he or she will generally perform a unit test or an integr...

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 discloses a structured query language (SQL) processing method and a related device. The method comprises the following steps of: firstly, obtaining a statement constructed by utilizing an SQL; performing lexical analysis on the statement constructed by utilizing the SQL to obtain a word set of the statement constructed by utilizing the SQL; processing the word set of the statement constructed by utilizing the SQL by utilizing a preset index setting rule to obtain an updated index list corresponding to the statement constructed by utilizing the SQL; determining an original index list corresponding to the statement constructed by utilizing the SQL; and generating an index optimization suggestion of the statement constructed by utilizing the SQL according to a comparison resultof the updated index list and the original index list. According to the method, the index of the statement constructed by utilizing the SQL can be optimally optimized through the index setting rule, manual operation is not needed any more, and the optimized program performance is guaranteed while the optimization efficiency is improved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method and device for processing structured query language. Background technique [0002] Structured Query Language (Structured Query Language, SQL) is a database query and programming language for accessing data and querying, updating and managing relational database systems. In the process of project development and database operation and maintenance, in order to improve program performance and reduce online failure rate, it is often necessary to optimize SQL. [0003] At present, the commonly used SQL processing method is to execute the SQL statement using the previously established index, and then manually analyze the execution result of the SQL statement. When the programmer finds that the previously established index does not meet the requirements, he will modify the previously established index by manually adjusting the index or adding an index, and use the modified index...

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/22G06F16/242
Inventor 吴雨轩宗占杰
Owner MASHANG CONSUMER FINANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products