SQL sentence processing method, device, computer device and storage medium

A processing method and computer program technology, applied in the field of databases, can solve the problems of a long upgrade cycle of relational database systems, time-consuming analysis and positioning, etc., and achieve the effect of shortening the upgrade cycle and saving time.

Active Publication Date: 2018-06-22
PING AN TECH (SHENZHEN) CO LTD
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when the amount of SQL statements is very large, the traditional SQL statement processing method needs to spend a lot of time analyzing and lo

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 sentence processing method, device, computer device and storage medium
  • SQL sentence processing method, device, computer device and storage medium
  • SQL sentence processing method, device, computer device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0022] It can be understood that the terms "first", "second" and the like used in the present invention may be used to describe various elements herein, but these elements are not limited by these terms. These terms are only used to distinguish one element from another element. For example, a first analysis parameter could be termed a second analysis parameter, and, similarly, a second analysis parameter could be termed a first analysis parameter, without departing from the scope of the present invention. Both the first analysis parameter and the second analysis parameter...

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 application relates to a SQL sentence processing method, a SQL sentence processing device, a computer device and a storage medium. The method includes steps of acquiring a database sub-parameter of every initial SQL sentence; calculating according to the database sub-parameter to obtain performance consumption ratio of every initial SQL sentence; extracting an initial SQL sentence of which performance consumption ratio is more than the preset threshold value, and forming a core SQL sentence set; placing the core SQL sentence set in an old version environment and a new version environment to carry out performance analysis, and acquiring a low-performance SQL sentence, wherein the low-performance SQL sentence is the initial SQL sentence of which performance in the new version environmentis lower than that in the old version environment, and which is located in the core SQL sentence set; promoting performance of the low-performance SQL sentence. By adopting the method, the time for analyzing and positioning the SQL sentence with reduced performance in the new version environment is saved, thus the version upgrading cycle of a relationship database system is shortened.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a SQL statement processing method, device, computer equipment and storage medium. Background technique [0002] SQL (Structured Query Language) is a database query and programming language for accessing data and querying, updating and managing relational database systems. There are differences between optimizers between different versions of relational database systems. The purpose of the optimizer is to obtain the most efficient execution path of the target SQL statement in the current situation according to certain judgment principles, that is, to obtain the best execution plan of the target SQL statement. Therefore, the execution plan of the same SQL statement in different versions of the database environment will be different, and the execution plan will change the performance of the SQL statement. Usually, SPA (SQL Performance Analyze, SQL performance analysis)...

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): G06F17/30
CPCG06F16/2433G06F16/2453
Inventor 王瑾玲高金芳
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap