A SQL statement processing method and device

A processing method and statement technology, applied in the field of cloud computing, can solve problems that affect system performance, low operating efficiency, and long time consumption

Active Publication Date: 2020-09-08
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the era of information explosion, a large amount of information and data are generated every day. It is a routine business to store, search, update, and delete massive amounts of data by using SQL statements. However, when executing certain SQL statements, it often takes a long time and Low operating efficiency, which seriously hinders the operating speed of the system, prolongs the page response speed, affects system performance, and thus affects user experience

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 SQL statement processing method and device
  • A SQL statement processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.

[0018] figure 1 Shown is the flowchart of the SQL statement processing method in Embodiment 1 of the present invention, comprising the following steps:

[0019] Step 101: According to the obtained SQL statements whose execution time is greater than or equal to the first preset value and the execution times of the SQL statements within the preset time period, assign the SQL statements to the corresponding queue;

[0020] Further, before assigning the SQL statement to the corresponding queue according to the acquired SQL statement whose execution time is greater than or equal to the first preset value and the number of execution times of the SQL statement within the preset period of time, further incl...

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 a SQL (structured query language) sentence processing method and device. The method includes following steps: distributing SQL sentences into corresponding queues according to acquired SQL sentences whose execution time is longer than or equal to a first preset value within a preset time period and execution time number of the SQL sentences; acquiring average execution time of the SQL sentences in each queue; processing selected SQL sentences whose average execution time is longer than or equal to a second preset value and / or the execution time number is larger than or equal to a third preset value. In the technical scheme, the SQL sentences with large execution time number and serious time consumption are optimized after the SQL sentences with the average execution time longer than or equal to the second preset value and / or the execution time number is larger than or equal to the third preset value are found out, so that system running efficiency is greatly improved, and user experience is improved.

Description

technical field [0001] The invention belongs to the technical field of cloud computing, and in particular relates to a SQL statement processing method and device. Background technique [0002] In the era of information explosion, a large amount of information and data are generated every day. It is a routine business to store, search, update, and delete massive amounts of data by using SQL statements. However, when executing certain SQL statements, it often takes a long time and In the case of low operating efficiency, this seriously hinders the operating speed of the system, prolongs the page response speed, affects system performance, and thus affects user experience. [0003] Therefore, it is urgent to provide a SQL statement processing solution to solve the above technical problems. Contents of the invention [0004] The present invention provides a SQL statement processing method and device to solve the above problems. [0005] An embodiment of the present invention...

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/21
CPCG06F16/217
Inventor 张保林何万县
Owner INSPUR SUZHOU INTELLIGENT TECH 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